Name: STIP Approved Project Points (Current)

Display Field: agency_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

The State Transportation Improvement Program (STIP) is a list of projects that the state proposes to fund with federal aid. This table uses point geometry to represent the projects on state roadways.This model has been modified to include the Detroit region only.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -83.2711139257216
YMin: 42.2625029857126
XMax: -82.9282629143845
YMax: 42.4481670119633
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[145,52,52,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ogc_fid

Unique ID Field:

Name : ogc_fid

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ogc_fid (type: esriFieldTypeOID, alias: ogc_fid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• job_id (type: esriFieldTypeInteger, alias: job_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• job_type_code (type: esriFieldTypeString, alias: job_type_code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• fiscal_year (type: esriFieldTypeString, alias: fiscal_year, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• agency_type (type: esriFieldTypeString, alias: agency_type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• agency_name (type: esriFieldTypeString, alias: agency_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• rpt_route_name (type: esriFieldTypeString, alias: rpt_route_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• pr_route_name (type: esriFieldTypeString, alias: pr_route_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• rpt_location_description (type: esriFieldTypeString, alias: rpt_location_description, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• construction_length (type: esriFieldTypeDouble, alias: construction_length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rpt_work_description (type: esriFieldTypeString, alias: rpt_work_description, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• fund_source_description (type: esriFieldTypeString, alias: fund_source_description, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• total_project_cost (type: esriFieldTypeDouble, alias: total_project_cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rural_or_mpo (type: esriFieldTypeString, alias: rural_or_mpo, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• location_id (type: esriFieldTypeInteger, alias: location_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_project_federal_cost (type: esriFieldTypeDouble, alias: total_project_federal_cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_project_state_cost (type: esriFieldTypeDouble, alias: total_project_state_cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_project_local_cost (type: esriFieldTypeDouble, alias: total_project_local_cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• job_operation_status_code (type: esriFieldTypeString, alias: job_operation_status_code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• global_id (type: esriFieldTypeString, alias: global_id, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)

Templates:

Name: stip_approved_project_points_detroit
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/6/2025 5:00:18 AM

Schema Last Edit Date: 4/6/2025 5:00:18 AM

Data Last Edit Date: 4/6/2025 5:00:18 AM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat