Name: READ_DW_INSPTECH_SPMS_FACT_SS

Display Field: ASSET_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 1c8f5fbfa21049f2bfdd7e5d60b52fa6

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• CHAN_PROTECTION ( type: esriFieldTypeString, alias: CHAN_PROTECTION, length: 10 )
• INVENTORY_RATING ( type: esriFieldTypeInteger, alias: INVENTORY_RATING )
• APPRO_ALIGN_OV ( type: esriFieldTypeString, alias: APPRO_ALIGN_OV, length: 2 )
• APPRO_ALIGN_UN ( type: esriFieldTypeString, alias: APPRO_ALIGN_UN, length: 2 )
• LENGTH_OF_IMPRV ( type: esriFieldTypeString, alias: LENGTH_OF_IMPRV, length: 10 )
• BRIDGE_IMPRV_COST ( type: esriFieldTypeString, alias: BRIDGE_IMPRV_COST, length: 10 )
• TOTAL_PROJ_COST ( type: esriFieldTypeString, alias: TOTAL_PROJ_COST, length: 10 )
• ASSET_NAME ( type: esriFieldTypeString, alias: ASSET_NAME, length: 50 )
• ASSET_CODE ( type: esriFieldTypeString, alias: ASSET_CODE, length: 50 )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: INSPECTION_DATE, length: 8 )
• DISTRICT_CODE ( type: esriFieldTypeString, alias: DISTRICT_CODE, length: 25 )
• COUNTY_CODE ( type: esriFieldTypeString, alias: COUNTY_CODE, length: 25 )
• INV_ROUTE_OVER ( type: esriFieldTypeString, alias: INV_ROUTE_OVER, length: 25 )
• INV_ROUTE_UNDER ( type: esriFieldTypeString, alias: INV_ROUTE_UNDER, length: 25 )
• FEATURES_INTERSECTED ( type: esriFieldTypeString, alias: FEATURES_INTERSECTED, length: 34 )
• FACILITY_CARRIED ( type: esriFieldTypeString, alias: FACILITY_CARRIED, length: 35 )
• LOCATION_A ( type: esriFieldTypeString, alias: LOCATION_A, length: 25 )
• LOCATION_B ( type: esriFieldTypeString, alias: LOCATION_B, length: 25 )
• POST ( type: esriFieldTypeString, alias: POST, length: 25 )
• LAT_DEG ( type: esriFieldTypeString, alias: LAT_DEG, length: 25 )
• LAT_MIN ( type: esriFieldTypeString, alias: LAT_MIN, length: 25 )
• LAT_SEC ( type: esriFieldTypeString, alias: LAT_SEC, length: 25 )
• LOG_DEG ( type: esriFieldTypeString, alias: LOG_DEG, length: 25 )
• LOG_MIN ( type: esriFieldTypeString, alias: LOG_MIN, length: 25 )
• LOG_SEC ( type: esriFieldTypeString, alias: LOG_SEC, length: 25 )
• DETOUR_LENGTH ( type: esriFieldTypeString, alias: DETOUR_LENGTH, length: 25 )
• TOLL ( type: esriFieldTypeString, alias: TOLL, length: 25 )
• OWNER_CODE ( type: esriFieldTypeString, alias: OWNER_CODE, length: 25 )
• FUNC_CLASS_OVER ( type: esriFieldTypeString, alias: FUNC_CLASS_OVER, length: 25 )
• FUNC_CLASS_UNDER ( type: esriFieldTypeString, alias: FUNC_CLASS_UNDER, length: 25 )
• HIST_SIG ( type: esriFieldTypeString, alias: HIST_SIG, length: 25 )
• STRAHNET ( type: esriFieldTypeString, alias: STRAHNET, length: 25 )
• PARALLEL_STR_DES ( type: esriFieldTypeString, alias: PARALLEL_STR_DES, length: 25 )
• TRAFFIC_DIR ( type: esriFieldTypeString, alias: TRAFFIC_DIR, length: 25 )
• TEMP_STR_DES ( type: esriFieldTypeString, alias: TEMP_STR_DES, length: 25 )
• DESIGN_LOADING ( type: esriFieldTypeString, alias: DESIGN_LOADING, length: 25 )
• MAIN_STR_TYPE_ENGL ( type: esriFieldTypeString, alias: MAIN_STR_TYPE_ENGL, length: 50 )
• NUMBER_MAIN_SPANS ( type: esriFieldTypeString, alias: NUMBER_MAIN_SPANS, length: 25 )
• NUMBER_APPRO_SPANS ( type: esriFieldTypeString, alias: NUMBER_APPRO_SPANS, length: 25 )
• YEAR_BUILT ( type: esriFieldTypeString, alias: YEAR_BUILT, length: 4 )
• LANES_OVER ( type: esriFieldTypeString, alias: LANES_OVER, length: 25 )
• LANES_UNDER ( type: esriFieldTypeString, alias: LANES_UNDER, length: 25 )
• APPROACH_RDWY_WIDTH ( type: esriFieldTypeString, alias: APPROACH_RDWY_WIDTH, length: 25 )
• BRIDGE_MEDIAN ( type: esriFieldTypeString, alias: BRIDGE_MEDIAN, length: 25 )
• SKEW ( type: esriFieldTypeString, alias: SKEW, length: 25 )
• STR_FLARED ( type: esriFieldTypeString, alias: STR_FLARED, length: 25 )
• OPC_CODE ( type: esriFieldTypeString, alias: OPC_CODE, length: 25 )
• INSP_FREQ ( type: esriFieldTypeString, alias: INSP_FREQ, length: 25 )
• YR_RECONSTRUCTED ( type: esriFieldTypeString, alias: YR_RECONSTRUCTED, length: 25 )
• NBIS_BRIDGE_LENGTH ( type: esriFieldTypeString, alias: NBIS_BRIDGE_LENGTH, length: 25 )
• SCOUR_CRITICAL_BRIDGES ( type: esriFieldTypeString, alias: SCOUR_CRITICAL_BRIDGES, length: 25 )
• FUTURE_ADT ( type: esriFieldTypeString, alias: FUTURE_ADT, length: 25 )
• FUTURE_ADT_YR ( type: esriFieldTypeString, alias: FUTURE_ADT_YR, length: 4 )
• LENGTH_MAX_SPAN ( type: esriFieldTypeString, alias: LENGTH_MAX_SPAN, length: 25 )
• STRUCTURE_LENGTH ( type: esriFieldTypeSingle, alias: STRUCTURE_LENGTH )
• SIDEWALK_WIDTH_LEFT ( type: esriFieldTypeString, alias: SIDEWALK_WIDTH_LEFT, length: 25 )
• SIDEWALK_WIDTH_RIGHT ( type: esriFieldTypeString, alias: SIDEWALK_WIDTH_RIGHT, length: 25 )
• BRIDGE_ROADWAY_WIDTH ( type: esriFieldTypeString, alias: BRIDGE_ROADWAY_WIDTH, length: 25 )
• DECK_WIDTH ( type: esriFieldTypeString, alias: DECK_WIDTH, length: 25 )
• MIN_VERT_OV_FT ( type: esriFieldTypeString, alias: MIN_VERT_OV_FT, length: 25 )
• MIN_VERT_OV_IN ( type: esriFieldTypeString, alias: MIN_VERT_OV_IN, length: 25 )
• MIN_VERT_UN_FT ( type: esriFieldTypeString, alias: MIN_VERT_UN_FT, length: 25 )
• MIN_VERT_UN_IN ( type: esriFieldTypeString, alias: MIN_VERT_UN_IN, length: 25 )
• NBI_NUMBER ( type: esriFieldTypeString, alias: NBI_NUMBER, length: 15 )
• COND_OF_DECK ( type: esriFieldTypeString, alias: COND_OF_DECK, length: 10 )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 240 )
• CONTRACT_NUM ( type: esriFieldTypeString, alias: CONTRACT_NUM, length: 12 )
• DESIG_NUMBER ( type: esriFieldTypeString, alias: DESIG_NUMBER, length: 12 )
• PAINT_CONDITION ( type: esriFieldTypeString, alias: PAINT_CONDITION, length: 7 )
• PAINT_EST_REMAIN_LIFE ( type: esriFieldTypeString, alias: PAINT_EST_REMAIN_LIFE, length: 7 )
• PAINT_RATE ( type: esriFieldTypeString, alias: PAINT_RATE, length: 7 )
• APPRA_OF_DECK_GEOMETRY ( type: esriFieldTypeString, alias: APPRA_OF_DECK_GEOMETRY, length: 7 )
• APPRA_OF_STR_COND ( type: esriFieldTypeString, alias: APPRA_OF_STR_COND, length: 7 )
• APPRA_OF_WATERWAY_ADEQ ( type: esriFieldTypeString, alias: APPRA_OF_WATERWAY_ADEQ, length: 7 )
• COND_OF_SBSTR ( type: esriFieldTypeString, alias: COND_OF_SBSTR, length: 10 )
• COND_OF_SPSTR ( type: esriFieldTypeString, alias: COND_OF_SPSTR, length: 10 )
• DECK_WEAR_SURFACE ( type: esriFieldTypeString, alias: DECK_WEAR_SURFACE, length: 7 )
• DW_CONSTRUCTION_COST_ESTIMATE ( type: esriFieldTypeDouble, alias: DW_CONSTRUCTION_COST_ESTIMATE )
• DW_NATIONAL_BRIDGE_INVENTORY ( type: esriFieldTypeInteger, alias: DW_NATIONAL_BRIDGE_INVENTORY )
• DW_DISTRICT ( type: esriFieldTypeString, alias: DW_DISTRICT, length: 20 )
• APPRA_OF_UNDERCLR ( type: esriFieldTypeString, alias: APPRA_OF_UNDERCLR, length: 2 )
• CULV_COND ( type: esriFieldTypeString, alias: CULV_COND, length: 2 )
• DW_RP_TO_OFF ( type: esriFieldTypeString, alias: DW_RP_TO_OFF, length: 4 )
• DW_RP_FR_OFF ( type: esriFieldTypeString, alias: DW_RP_FR_OFF, length: 4 )
• DW_RP_FR ( type: esriFieldTypeString, alias: DW_RP_FR, length: 4 )
• DW_RP_TO ( type: esriFieldTypeString, alias: DW_RP_TO, length: 4 )
• DW_COUNTY ( type: esriFieldTypeString, alias: DW_COUNTY, length: 20 )
• FUNCTIONALLY_OBSOLETE ( type: esriFieldTypeString, alias: FUNCTIONALLY_OBSOLETE, length: 2 )
• STRUCTURALLY_DEFICIENT ( type: esriFieldTypeString, alias: STRUCTURALLY_DEFICIENT, length: 2 )
• AS_ID ( type: esriFieldTypeDouble, alias: AS_ID )
• MAINT_CODE ( type: esriFieldTypeString, alias: MAINT_CODE, length: 10 )
• ASSET_STATUS_ID ( type: esriFieldTypeInteger, alias: ASSET_STATUS_ID )
• INV_CODE ( type: esriFieldTypeString, alias: INV_CODE, length: 5 )
• INV_TONS ( type: esriFieldTypeString, alias: INV_TONS, length: 5 )
• DW_COUNTY_NAME ( type: esriFieldTypeString, alias: DW_COUNTY_NAME, length: 11 )
• OFFSET ( type: esriFieldTypeString, alias: OFFSET, length: 7 )
• SUFFICIENCY_RATING ( type: esriFieldTypeSingle, alias: SUFFICIENCY_RATING )
• SUFFICIENCY_RATING_DATE ( type: esriFieldTypeDate, alias: SUFFICIENCY_RATING_DATE, length: 8 )
• UNOFF_SUFF_RATING ( type: esriFieldTypeSingle, alias: UNOFF_SUFF_RATING )
• UNOFF_SUFF_RATING_DATE ( type: esriFieldTypeDate, alias: UNOFF_SUFF_RATING_DATE, length: 8 )
• UNOFF_STRUCT_DEF ( type: esriFieldTypeString, alias: UNOFF_STRUCT_DEF, length: 2 )
• UNOFF_FUNCT_OBS ( type: esriFieldTypeString, alias: UNOFF_FUNCT_OBS, length: 2 )
• RECORD_TYPE_O ( type: esriFieldTypeString, alias: RECORD_TYPE_O, length: 5 )
• RECORD_TYPE_U ( type: esriFieldTypeString, alias: RECORD_TYPE_U, length: 5 )
• RTE_SIGNING_PRE_O ( type: esriFieldTypeString, alias: RTE_SIGNING_PRE_O, length: 1 )
• RTE_SIGNING_PRE_U ( type: esriFieldTypeString, alias: RTE_SIGNING_PRE_U, length: 1 )
• LEVEL_OF_SERVICE_O ( type: esriFieldTypeString, alias: LEVEL_OF_SERVICE_O, length: 1 )
• LEVEL_OF_SERVICE_U ( type: esriFieldTypeString, alias: LEVEL_OF_SERVICE_U, length: 1 )
• ROUTE_NUM_O ( type: esriFieldTypeString, alias: ROUTE_NUM_O, length: 5 )
• ROUTE_NUM_U ( type: esriFieldTypeString, alias: ROUTE_NUM_U, length: 5 )
• DIRECTIONAL_SUFF_O ( type: esriFieldTypeString, alias: DIRECTIONAL_SUFF_O, length: 1 )
• DIRECTIONAL_SUFF_U ( type: esriFieldTypeString, alias: DIRECTIONAL_SUFF_U, length: 1 )
• HIWAY_SYS_O ( type: esriFieldTypeString, alias: HIWAY_SYS_O, length: 1 )
• HIWAY_SYS_U ( type: esriFieldTypeString, alias: HIWAY_SYS_U, length: 1 )
• TYPE_SERV_ON ( type: esriFieldTypeString, alias: TYPE_SERV_ON, length: 1 )
• TYPE_SERV_UN ( type: esriFieldTypeString, alias: TYPE_SERV_UN, length: 1 )
• COND_OF_DECK_TXT ( type: esriFieldTypeString, alias: COND_OF_DECK_TXT, length: 200 )
• DECK_WEAR_SURFACE_TXT ( type: esriFieldTypeString, alias: DECK_WEAR_SURFACE_TXT, length: 200 )
• COND_OF_SBSTR_TXT ( type: esriFieldTypeString, alias: COND_OF_SBSTR_TXT, length: 200 )
• INV_CODE_PT1 ( type: esriFieldTypeString, alias: INV_CODE_PT1, length: 1 )
• INV_CODE_PT1_TXT ( type: esriFieldTypeString, alias: INV_CODE_PT1_TXT, length: 50 )
• INV_CODE_PT2 ( type: esriFieldTypeString, alias: INV_CODE_PT2, length: 1 )
• INV_CODE_PT2_TXT ( type: esriFieldTypeString, alias: INV_CODE_PT2_TXT, length: 50 )
• MAD_SCOUR_PLAN_OF_ACTION ( type: esriFieldTypeString, alias: MAD_SCOUR_PLAN_OF_ACTION, length: 100 )
• MAD_ASSET_TYPE_HAS_CHANGED ( type: esriFieldTypeString, alias: MAD_ASSET_TYPE_HAS_CHANGED, length: 10 )
• MAD_ATHC_COMMENTS ( type: esriFieldTypeString, alias: MAD_ATHC_COMMENTS, length: 1000 )
• MAD_GENERAL_PAINT_COND ( type: esriFieldTypeString, alias: MAD_GENERAL_PAINT_COND, length: 10 )
• MAD_GPC_COMMENTS ( type: esriFieldTypeString, alias: MAD_GPC_COMMENTS, length: 1000 )
• MAD_PAINT_YEAR ( type: esriFieldTypeString, alias: MAD_PAINT_YEAR, length: 4 )
• MAD_BATS ( type: esriFieldTypeString, alias: MAD_BATS, length: 1 )
• MAD_SWALLOWS ( type: esriFieldTypeString, alias: MAD_SWALLOWS, length: 1 )
• MAD_RP_SOURCE ( type: esriFieldTypeString, alias: MAD_RP_SOURCE, length: 50 )
• MAD_ROUTE_TYPE ( type: esriFieldTypeString, alias: MAD_ROUTE_TYPE, length: 5 )
• MAD_ROUTE_NUMBER ( type: esriFieldTypeString, alias: MAD_ROUTE_NUMBER, length: 5 )
• MAD_RP ( type: esriFieldTypeString, alias: MAD_RP, length: 50 )
• MAD_OFFSET ( type: esriFieldTypeString, alias: MAD_OFFSET, length: 10 )
• LAST_UPDATE_ON ( type: esriFieldTypeDate, alias: LAST_UPDATE_ON, length: 8 )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

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

  Iteminfo   Thumbnail   Metadata