Name: Projects
Display Field: projname
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 1155582
Max. Scale: 9027
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -10682300.7320927
YMin: 3430059.33504373
XMax: -10571134.3585866
YMax: 3540704.73954746
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,201,246,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true
HasM: false
Has Attachments: true
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field: projtype
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- projid (type: esriFieldTypeString, alias: Project Identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- projname (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
- projdesc (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- rationale (type: esriFieldTypeString, alias: Rationale, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- projtype (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [Facilities: Facilities], [Transportation Safety Enhancements: Transportation Safety Enhancements], [Transportation Multimodal Enhancements: Transportation Multimodal Enhancements], ... 7 more ...)
- priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [High: High], [Medium: Medium], [Low: Low], ... 1 more ...)
- planalignment (type: esriFieldTypeString, alias: Plan Alignment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Vision Zero: Vision Zero], [Katy East Master Plan: Katy East Master Plan], [Inner Northwest Master Plan: Inner Northwest Master Plan], ... 10 more ...)
- planstart (type: esriFieldTypeDate, alias: Planned Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- planend (type: esriFieldTypeDate, alias: Planned End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- estcost (type: esriFieldTypeDouble, alias: Estimated Budget, SQL Type: sqlTypeOther, nullable: true, editable: true)
- contingency (type: esriFieldTypeDouble, alias: Contingency, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pocname (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- pocphone (type: esriFieldTypeString, alias: Contact Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- pocemail (type: esriFieldTypeString, alias: Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- agency (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- department (type: esriFieldTypeString, alias: Department Responsible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Planning: Planning], [Engineering: Engineering])
- projphase (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Plan], [2: PreDesign], [3: Design], ... 3 more ...)
- actstart (type: esriFieldTypeDate, alias: Actual Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- actend (type: esriFieldTypeDate, alias: Actual End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- actcost (type: esriFieldTypeDouble, alias: Expenditures, SQL Type: sqlTypeOther, nullable: true, editable: true)
- notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- docpath (type: esriFieldTypeString, alias: Document Path, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- publicview (type: esriFieldTypeString, alias: Public View, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- funding (type: esriFieldTypeDouble, alias: Funding total, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fundingsources (type: esriFieldTypeString, alias: Funding Sources, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Grant Bucket: Grant Bucket], [Planning Bucket: Planning Bucket], [Legacy: Legacy], ... 9 more ...)
- fiscalyears (type: esriFieldTypeString, alias: Fiscal Years, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- projrank (type: esriFieldTypeDouble, alias: Number of drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
- cip (type: esriFieldTypeString, alias: CIP, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [N/A: N/A], [2018-2024: 2018-2024], [2024-2030: 2024-2030], ... 1 more ...)
- externalproject (type: esriFieldTypeString, alias: External Project, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- driver1 (type: esriFieldTypeString, alias: Health and Safety, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- driver2 (type: esriFieldTypeString, alias: Mandate, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- driver3 (type: esriFieldTypeString, alias: Repair or Maintenance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- driver4 (type: esriFieldTypeString, alias: Replacement, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- driver5 (type: esriFieldTypeString, alias: Expansion, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- driver6 (type: esriFieldTypeString, alias: Resiliency, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- driver7 (type: esriFieldTypeString, alias: Quality of Life / Aesthetic Value, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- driver8 (type: esriFieldTypeString, alias: Economic Development, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- driver9 (type: esriFieldTypeString, alias: Participatory Budgeting, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- driver10 (type: esriFieldTypeString, alias: Disadvantaged Community, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- internalprojectreview (type: esriFieldTypeString, alias: Internal Project Review, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- externalprojectreview (type: esriFieldTypeString, alias: External Project Review, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- roadreview (type: esriFieldTypeString, alias: Road Review, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- conflictexception (type: esriFieldTypeString, alias: Conflict Exception, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: Last Edited By, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: Transportation Capacity Enhancements
Name: Transportation Capacity Enhancements
Domains:
Templates:
Name: Transportation Capacity Enhancements
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Transportation Capacity Enhancements
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
ID: Facilities
Name: Facilities
Domains:
Templates:
Name: Facilities
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Facilities
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
ID: Parks
Name: Parks
Domains:
Templates:
Name: Parks
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Parks
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
ID: Transportation Multimodal Enhancements
Name: Transportation Multimodal Enhancements
Domains:
Templates:
Name: Transportation Multimodal Enhancements
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Transportation Multimodal Enhancements
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
ID: Grants Match
Name: Grants Match
Domains:
Templates:
Name: Grants Match
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Grants Match
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
ID: Neighborhood Drainage
Name: Neighborhood Drainage
Domains:
Templates:
Name: Neighborhood Drainage
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Neighborhood Drainage
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
ID: Planning
Name: Planning
Domains:
Templates:
Name: Planning
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Planning
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
ID: Subdivision Drainage
Name: Subdivision Drainage
Domains:
Templates:
Name: Subdivision Drainage
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Subdivision Drainage
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
ID: Transportation Management Systems
Name: Transportation Management Systems
Domains:
Templates:
Name: Transportation Management Systems
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Transportation Management Systems
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
ID: Transportation Safety Enhancements
Name: Transportation Safety Enhancements
Domains:
Templates:
Name: Transportation Safety Enhancements
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- projtype: Transportation Safety Enhancements
- contingency: 0
- projphase: 1
- driver1: No
- driver2: No
- driver3: No
- driver4: No
- driver5: No
- driver6: No
- driver7: No
- driver8: No
- driver9: No
- driver10: No
- internalprojectreview: No
- externalprojectreview: No
- roadreview: No
- conflictexception: No
Relationships:
- Comments (0) -- Related To: Comments (1)
- Funding (1) -- Related To: Funding (2)
- Spending (3) -- Related To: Spending (4)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/21/2025 7:26:42 PM
Schema Last Edit Date: 7/21/2025 7:26:42 PM
Data Last Edit Date: 7/21/2025 7:26:42 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Query Attachments
Add Features
Update Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat