Name: Projects
Display Field: projname
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Has Views: true
Source Schema Changes Allowed: true
Views
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)
- ProjType2 (type: esriFieldTypeString, alias: Secondary Project Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Drainage: Drainage], [Facilities: Facilities], [Transportation Multimodal Enhancements: Transportation Multimodal Enhancements], ... 2 more ...)
- date2 (type: esriFieldTypeDateOnly, alias: date2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- label (type: esriFieldTypeDouble, alias: label, SQL Type: sqlTypeOther, nullable: true, editable: true)
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
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat