Name: EPM - All Projects as Points

Display Field: ROUTE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;font-size:12pt"><P><SPAN>This map displays points for all PIN statuses except 'Abandoned'. This data from ePM is refreshed daily. All projects are represented in the point geometry.</SPAN></P></DIV>

Service Item Id: fabf0206f8ef4724be54ab2a13032458

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.2696184328092812E7
YMin: 4438862.762727826
XMax: -1.2140512615242295E7
YMax: 5160893.433802257
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 7.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• PROJECT_ID ( type: esriFieldTypeDouble, alias: PROJECT_ID )
• PROJ_XREF_NO ( type: esriFieldTypeDouble, alias: PROJ_XREF_NO )
• PDBS_PROJ_NO ( type: esriFieldTypeString, alias: PDBS_PROJ_NO, length: 32 )
• PIN ( type: esriFieldTypeInteger, alias: PIN )
• PIN_DESC ( type: esriFieldTypeString, alias: PIN_DESC, length: 50 )
• PIN_STAT_CD ( type: esriFieldTypeString, alias: PIN_STAT_CD, length: 1 )
• PIN_STAT_NM ( type: esriFieldTypeString, alias: PIN_STAT_NM, length: 20 )
• MSTR_PIN ( type: esriFieldTypeInteger, alias: MSTR_PIN )
• MSTR_PIN_DESC ( type: esriFieldTypeString, alias: MSTR_PIN_DESC, length: 60 )
• MSTR_PIN_LOC ( type: esriFieldTypeString, alias: MSTR_PIN_LOC, length: 60 )
• ROAD_SYS_CD ( type: esriFieldTypeString, alias: ROAD_SYS_CD, length: 2 )
• FMIS_NO ( type: esriFieldTypeString, alias: FMIS_NO, length: 7 )
• PROJ_LOC ( type: esriFieldTypeString, alias: PROJ_LOC, length: 250 )
• PROJECT_VALUE ( type: esriFieldTypeDouble, alias: PROJECT_VALUE )
• REGION_CD ( type: esriFieldTypeString, alias: REGION_CD, length: 1 )
• CONCEPT_DESC ( type: esriFieldTypeString, alias: CONCEPT_DESC, length: 60 )
• PDL_TYPE ( type: esriFieldTypeSmallInteger, alias: PDL_TYPE )
• PDL_DESC ( type: esriFieldTypeString, alias: PDL_DESC, length: 40 )
• PROJECT_MANAGER ( type: esriFieldTypeString, alias: PROJECT_MANAGER, length: 25 )
• UDOT_RESIDENT_ENGINEER ( type: esriFieldTypeString, alias: UDOT_RESIDENT_ENGINEER, length: 25 )
• CNSLT_RESIDENT_ENGINEER ( type: esriFieldTypeString, alias: CNSLT_RESIDENT_ENGINEER, length: 50 )
• DESIGN_ENGINEER ( type: esriFieldTypeString, alias: DESIGN_ENGINEER, length: 50 )
• EPM_PLAN_START_DATE ( type: esriFieldTypeDate, alias: EPM_PLAN_START_DATE, length: 8 )
• EPM_PLAN_DURATION ( type: esriFieldTypeDouble, alias: EPM_PLAN_DURATION )
• EPM_PLAN_END_DATE ( type: esriFieldTypeDate, alias: EPM_PLAN_END_DATE, length: 8 )
• JOB_PROJ ( type: esriFieldTypeString, alias: JOB_PROJ, length: 500 )
• FUNCTION_TYPE ( type: esriFieldTypeString, alias: FUNCTION_TYPE, length: 500 )
• LOCAL_GOV_PROJ_FLAG ( type: esriFieldTypeString, alias: LOCAL_GOV_PROJ_FLAG, length: 1 )
• COMM_APRV_IND ( type: esriFieldTypeString, alias: COMM_APRV_IND, length: 1 )
• WILL_ADVERTISE_FLAG ( type: esriFieldTypeString, alias: WILL_ADVERTISE_FLAG, length: 1 )
• SUBMIT_FOR_ADVERTISE_DATE ( type: esriFieldTypeDate, alias: SUBMIT_FOR_ADVERTISE_DATE, length: 8 )
• COMMIT_FOR_ADVERTISE_DATE ( type: esriFieldTypeDate, alias: COMMIT_FOR_ADVERTISE_DATE, length: 8 )
• PROJ_ROUTE_SEQ ( type: esriFieldTypeString, alias: PROJ_ROUTE_SEQ, length: 20 )
• LAST_DT_RTE_VALIDATED ( type: esriFieldTypeDate, alias: LAST_DT_RTE_VALIDATED, length: 8 )
• CREATED_DT ( type: esriFieldTypeDate, alias: CREATED_DT, length: 8 )
• MODIFIED_DT ( type: esriFieldTypeDate, alias: MODIFIED_DT, length: 8 )
• ST_FED_IND ( type: esriFieldTypeString, alias: ST_FED_IND, length: 1 )
• TOTAL_EXPENDITURES ( type: esriFieldTypeDouble, alias: TOTAL_EXPENDITURES )
• FED_DOLLARS ( type: esriFieldTypeDouble, alias: FED_DOLLARS )
• STATE_DOLLARS ( type: esriFieldTypeDouble, alias: STATE_DOLLARS )
• PROJECT_TYPE ( type: esriFieldTypeString, alias: PROJECT_TYPE, length: 10 )
• PROJ_TYPE ( type: esriFieldTypeString, alias: PROJ_TYPE, length: 3 )
• PROGRAM ( type: esriFieldTypeString, alias: PROGRAM, length: 4000 )
• PROJ_TYP_NM ( type: esriFieldTypeString, alias: PROJ_TYP_NM, length: 4000 )
• UOM_TYP ( type: esriFieldTypeDouble, alias: UOM_TYP )
• PRE_BID_MTG_DAT ( type: esriFieldTypeDate, alias: PRE_BID_MTG_DAT, length: 8 )
• BID_OPEN_DAT ( type: esriFieldTypeDate, alias: BID_OPEN_DAT, length: 8 )
• AWARD_DAT ( type: esriFieldTypeDate, alias: AWARD_DAT, length: 8 )
• PROCEED_DAT ( type: esriFieldTypeDate, alias: PROCEED_DAT, length: 8 )
• PROJECTED_START_DATE ( type: esriFieldTypeDate, alias: PROJECTED_START_DATE, length: 8 )
• START_DAT ( type: esriFieldTypeDate, alias: START_DAT, length: 8 )
• EST_COMPL_DAT ( type: esriFieldTypeDate, alias: EST_COMPL_DAT, length: 8 )
• SUBSTANTIALLY_COMPLETE_DATE ( type: esriFieldTypeDate, alias: SUBSTANTIALLY_COMPLETE_DATE, length: 8 )
• FNLEST_ACCPT_DAT ( type: esriFieldTypeDate, alias: FNLEST_ACCPT_DAT, length: 8 )
• DAYS ( type: esriFieldTypeDouble, alias: DAYS )
• WORK_CAL_TYP ( type: esriFieldTypeDouble, alias: WORK_CAL_TYP )
• PLAN_AMT ( type: esriFieldTypeDouble, alias: PLAN_AMT )
• MAIL_AMT ( type: esriFieldTypeDouble, alias: MAIL_AMT )
• AVAIL_AWRD_FND_AMT ( type: esriFieldTypeDouble, alias: AVAIL_AWRD_FND_AMT )
• ENG_EST_AMT ( type: esriFieldTypeDouble, alias: ENG_EST_AMT )
• ENG_EST_A_AMT ( type: esriFieldTypeDouble, alias: ENG_EST_A_AMT )
• ORIG_CNTRCT_AMT ( type: esriFieldTypeDouble, alias: ORIG_CNTRCT_AMT )
• CHANGE_ORDER_AMT ( type: esriFieldTypeDouble, alias: CHANGE_ORDER_AMT )
• OCIP_IND ( type: esriFieldTypeDouble, alias: OCIP_IND )
• IG_LCL_GOV ( type: esriFieldTypeDouble, alias: IG_LCL_GOV )
• IG_10_PCT_OVER ( type: esriFieldTypeDouble, alias: IG_10_PCT_OVER )
• IG_FHWA ( type: esriFieldTypeDouble, alias: IG_FHWA )
• EST_CLSD_YN ( type: esriFieldTypeDouble, alias: EST_CLSD_YN )
• SEP_MSTR_YN_TYP ( type: esriFieldTypeDouble, alias: SEP_MSTR_YN_TYP )
• DSNBLD_IND ( type: esriFieldTypeDouble, alias: DSNBLD_IND )
• STIMULUS_FLAG ( type: esriFieldTypeString, alias: STIMULUS_FLAG, length: 1 )
• TEST_PROJECT_FLAG ( type: esriFieldTypeString, alias: TEST_PROJECT_FLAG, length: 1 )
• ESCROW_PERCENTAGE ( type: esriFieldTypeDouble, alias: ESCROW_PERCENTAGE )
• MSTR_PROJECT_ID ( type: esriFieldTypeDouble, alias: MSTR_PROJECT_ID )
• AWRDD_CNTRCTR_COMPANY_EMP_ID ( type: esriFieldTypeDouble, alias: AWRDD_CNTRCTR_COMPANY_EMP_ID )
• ADVERTISE_DATE ( type: esriFieldTypeDate, alias: ADVERTISE_DATE, length: 8 )
• ENG_EST_ID ( type: esriFieldTypeString, alias: ENG_EST_ID, length: 10 )
• MSTR_PROJ_NUM ( type: esriFieldTypeString, alias: MSTR_PROJ_NUM, length: 10 )
• PCT_ELAPSED ( type: esriFieldTypeDouble, alias: PCT_ELAPSED )
• PCT_COMPLETE ( type: esriFieldTypeDouble, alias: PCT_COMPLETE )
• PRIME ( type: esriFieldTypeString, alias: PRIME, length: 40 )
• PROJ_DELVR_MTHD ( type: esriFieldTypeString, alias: PROJ_DELVR_MTHD, length: 40 )
• PROJ_CONCPT_NM ( type: esriFieldTypeString, alias: PROJ_CONCPT_NM, length: 4000 )
• PROJ_CONCPT_CD ( type: esriFieldTypeString, alias: PROJ_CONCPT_CD, length: 3 )
• PRIMARY_CONCEPT ( type: esriFieldTypeString, alias: PRIMARY_CONCEPT, length: 4000 )
• SECONDARY_CONCEPT ( type: esriFieldTypeString, alias: SECONDARY_CONCEPT, length: 4000 )
• FORECAST_ST_YR ( type: esriFieldTypeSmallInteger, alias: FORECAST_ST_YR )
• REGION_PRTY ( type: esriFieldTypeSmallInteger, alias: REGION_PRTY )
• STIP_SPONSOR_CD ( type: esriFieldTypeString, alias: STIP_SPONSOR_CD, length: 10 )
• SPONSOR_NAME ( type: esriFieldTypeString, alias: SPONSOR_NAME, length: 4000 )
• TOTAL_CD_AMOUNT ( type: esriFieldTypeDouble, alias: TOTAL_CD_AMOUNT )
• TIP_CD ( type: esriFieldTypeString, alias: TIP_CD, length: 6 )
• CNTY_CD ( type: esriFieldTypeString, alias: CNTY_CD, length: 2 )
• CNTY_NAME ( type: esriFieldTypeString, alias: CNTY_NAME, length: 4000 )
• PIN_STATUS_PHASE_DESC ( type: esriFieldTypeString, alias: PIN_STATUS_PHASE_DESC, length: 25 )
• PLANNED_CONSTRUCTION_YEAR ( type: esriFieldTypeSmallInteger, alias: PLANNED_CONSTRUCTION_YEAR )
• CREATED_BY ( type: esriFieldTypeString, alias: CREATED_BY, length: 30 )
• FNLZ_CNCPT_COMP_DT ( type: esriFieldTypeDate, alias: FNLZ_CNCPT_COMP_DT, length: 8 )
• PUBLIC_DESC ( type: esriFieldTypeString, alias: PUBLIC_DESC, length: 4000 )
• PUBLIC_DESC_TAG1 ( type: esriFieldTypeString, alias: PUBLIC_DESC_TAG1, length: 50 )
• PUBLIC_DESC_TAG2 ( type: esriFieldTypeString, alias: PUBLIC_DESC_TAG2, length: 50 )
• PUBLIC_DESC_TAG3 ( type: esriFieldTypeString, alias: PUBLIC_DESC_TAG3, length: 50 )
• PUBLIC_DESC_TAG4 ( type: esriFieldTypeString, alias: PUBLIC_DESC_TAG4, length: 50 )
• PUBLIC_DESC_TAG5 ( type: esriFieldTypeString, alias: PUBLIC_DESC_TAG5, length: 50 )
• PUB_CTC_NM ( type: esriFieldTypeString, alias: PUB_CTC_NM, length: 93 )
• PUB_CTC_PH ( type: esriFieldTypeString, alias: PUB_CTC_PH, length: 24 )
• PUB_CTC_EMAIL ( type: esriFieldTypeString, alias: PUB_CTC_EMAIL, length: 60 )
• CONTRACT_RANGE ( type: esriFieldTypeString, alias: CONTRACT_RANGE, length: 25 )
• UNIFIED_PLAN_UNIQUE_ID_LST ( type: esriFieldTypeString, alias: UNIFIED_PLAN_UNIQUE_ID_LST, length: 4000 )
• ABANDONED_FLAG ( type: esriFieldTypeString, alias: ABANDONED_FLAG, length: 1 )
• TO_PIN ( type: esriFieldTypeInteger, alias: TO_PIN )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 1000 )
• STIP_WORKSHOP ( type: esriFieldTypeString, alias: STIP_WORKSHOP, length: 100 )
• STIP_WORKSHOP_YR ( type: esriFieldTypeString, alias: STIP_WORKSHOP_YR, length: 5 )
• WORKSHOP_CAT ( type: esriFieldTypeString, alias: WORKSHOP_CAT, length: 100 )
• STIP_WORKSHOP_APPROVED_DT ( type: esriFieldTypeString, alias: STIP_WORKSHOP_APPROVED_DT, length: 25 )
• STIP_WORKSHOP_APPROVED_AMT ( type: esriFieldTypeDouble, alias: STIP_WORKSHOP_APPROVED_AMT )
• TIF_PRIORITY_FLAG ( type: esriFieldTypeString, alias: TIF_PRIORITY_FLAG, length: 1 )
• TIF_PRIORITY_SCORE_RANGE ( type: esriFieldTypeString, alias: TIF_PRIORITY_SCORE_RANGE, length: 20 )
• TIF_PLAN_FUND_CD ( type: esriFieldTypeString, alias: TIF_PLAN_FUND_CD, length: 20 )
• UP_PHASE ( type: esriFieldTypeSmallInteger, alias: UP_PHASE )
• UP_PROJECT_ID ( type: esriFieldTypeString, alias: UP_PROJECT_ID, length: 4000 )
• ROUTE_NAME ( type: esriFieldTypeString, alias: ROUTE_NAME, length: 30 )
• ROUTE_DIR_ID ( type: esriFieldTypeString, alias: ROUTE_DIR_ID, length: 20 )
• ROUTE_DESC ( type: esriFieldTypeString, alias: ROUTE_DESC, length: 4000 )
• ROUTE_CLASS ( type: esriFieldTypeString, alias: ROUTE_CLASS, length: 10 )
• START_ACCUM ( type: esriFieldTypeDouble, alias: START_ACCUM )
• END_ACCUM ( type: esriFieldTypeDouble, alias: END_ACCUM )
• LENGTH_ACCUM ( type: esriFieldTypeDouble, alias: LENGTH_ACCUM )
• USE_GEOM_ONLY_IND ( type: esriFieldTypeString, alias: USE_GEOM_ONLY_IND, length: 1 )
• ENV_DOC_TYPE_CD ( type: esriFieldTypeString, alias: ENV_DOC_TYPE_CD, length: 10 )
• ERR_CD ( type: esriFieldTypeDouble, alias: ERR_CD )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata