Name: SNBI_01_PRIMARY_TBL

Display Field: BID01

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e31075c5ae4a4b88849e15c149b90234

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• BL01 ( type: esriFieldTypeSmallInteger, alias: B.L.01-State Code )
• BID01 ( type: esriFieldTypeString, alias: B.ID.01-Bridge Number, length: 15 )
• BID02 ( type: esriFieldTypeString, alias: B.ID.02-Bridge Name, length: 15 )
• BID03 ( type: esriFieldTypeString, alias: B.ID.03-Previous Bridge Number, length: 120 )
• BL02 ( type: esriFieldTypeSmallInteger, alias: B.L.02-County Code )
• BL02_TEXT ( type: esriFieldTypeString, alias: B.L.02 (Text)-County Name, length: 50 )
• BL03 ( type: esriFieldTypeInteger, alias: B.L.03-Place Code )
• BL03_TEXT ( type: esriFieldTypeString, alias: B.L.03 (Text)-Place (City) Name, length: 100 )
• BL04 ( type: esriFieldTypeString, alias: B.L.04-Highway Agency District, length: 2 )
• BL05 ( type: esriFieldTypeDouble, alias: B.L.05-Latitude )
• BL06 ( type: esriFieldTypeDouble, alias: B.L.06-Longitude )
• BL07 ( type: esriFieldTypeString, alias: B.L.07-Border Bridge Number, length: 15 )
• BL08 ( type: esriFieldTypeString, alias: B.L.08-Border Bridge State or Country Code, length: 2 )
• BL09 ( type: esriFieldTypeString, alias: B.L.09-Border Bridge Inspection Responsibility, length: 1 )
• BL10 ( type: esriFieldTypeString, alias: B.L.10-Border Bridge Designated Lead State, length: 2 )
• BL11 ( type: esriFieldTypeString, alias: B.L.11-Bridge Location, length: 300 )
• BL12 ( type: esriFieldTypeString, alias: B.L.12-Metropolitan Planning Organization, length: 300 )
• BCL01 ( type: esriFieldTypeString, alias: B.CL.01-Owner, length: 4 )
• BCL02 ( type: esriFieldTypeString, alias: B.CL.02-Maintenance Responsibility, length: 4 )
• BCL03 ( type: esriFieldTypeString, alias: B.CL.03-Federal or Tribal Land Access, length: 30 )
• BCL04 ( type: esriFieldTypeString, alias: B.CL.04-Historical Significance, length: 1 )
• BCL05 ( type: esriFieldTypeString, alias: B.CL.05-Toll, length: 1 )
• BCL06 ( type: esriFieldTypeString, alias: B.CL.06-Emergency Evacuation Designation, length: 1 )
• BRH01 ( type: esriFieldTypeString, alias: B.RH.01-Bridge Railings, length: 4 )
• BRH02 ( type: esriFieldTypeString, alias: B.RH.02-Transitions, length: 4 )
• BG01 ( type: esriFieldTypeDouble, alias: B.G.01-NBIS Bridge Length )
• BG02 ( type: esriFieldTypeDouble, alias: B.G.02-Total Bridge Length )
• BG03 ( type: esriFieldTypeDouble, alias: B.G.03-Maximum Span Length )
• BG04 ( type: esriFieldTypeDouble, alias: B.G.04-Minimum Span Length )
• BG05 ( type: esriFieldTypeDouble, alias: B.G.05-Bridge Width Out-to-Out )
• BG06 ( type: esriFieldTypeDouble, alias: B.G.06-Bridge Width Curb-to-Curb )
• BG07 ( type: esriFieldTypeDouble, alias: B.G.07-Left Curb or Sidewalk Width )
• BG08 ( type: esriFieldTypeDouble, alias: B.G.08-Right Curb or Sidewalk Width )
• BG09 ( type: esriFieldTypeDouble, alias: B.G.09-Approach Roadway Width )
• BG10 ( type: esriFieldTypeString, alias: B.G.10-Bridge Median, length: 1 )
• BG11 ( type: esriFieldTypeSmallInteger, alias: B.G.11-Skew )
• BG12 ( type: esriFieldTypeString, alias: B.G.12-Curved Bridge, length: 2 )
• BG13 ( type: esriFieldTypeSmallInteger, alias: B.G.13-Maximum Bridge Height )
• BG14 ( type: esriFieldTypeString, alias: B.G.14-Sidehill Bridge, length: 1 )
• BG15 ( type: esriFieldTypeDouble, alias: B.G.15-Irregular Deck Area )
• BG16 ( type: esriFieldTypeDouble, alias: B.G.16-Calculated Deck Area )
• BLR01 ( type: esriFieldTypeString, alias: B.LR.01-Designed Load, length: 8 )
• BLR02 ( type: esriFieldTypeString, alias: B.LR.02-Designed Method, length: 4 )
• BLR03 ( type: esriFieldTypeDate, alias: B.LR.03-Load Rating Date, length: 8 )
• BLR04 ( type: esriFieldTypeString, alias: B.LR.04-Load Rating Method, length: 4 )
• BLR05 ( type: esriFieldTypeDouble, alias: B.LR.05-Inventory Load Rating Factor )
• BLR06 ( type: esriFieldTypeDouble, alias: B.LR.06-Operating Load Rating Factor )
• BLR07 ( type: esriFieldTypeDouble, alias: B.LR.07-Controlling Legal Load Rating Factor )
• BLR08 ( type: esriFieldTypeString, alias: B.LR.08-Routine Permit Loads, length: 1 )
• BIR01 ( type: esriFieldTypeString, alias: B.IR.01-NSTM Inspection Required, length: 1 )
• BIR02 ( type: esriFieldTypeString, alias: B.IR.02-Fatigue Details, length: 1 )
• BIR03 ( type: esriFieldTypeString, alias: B.IR.03-Underwater Inspection Required, length: 1 )
• BIR04 ( type: esriFieldTypeString, alias: B.IR.04-Complex Feature, length: 1 )
• BC01 ( type: esriFieldTypeString, alias: B.C.01-Deck Condition Rating, length: 1 )
• BC02 ( type: esriFieldTypeString, alias: B.C.02-Superstructure Condition Rating, length: 1 )
• BC03 ( type: esriFieldTypeString, alias: B.C.03-Substructure Condition Rating, length: 1 )
• BC04 ( type: esriFieldTypeString, alias: B.C.04-Culvert Condition Rating, length: 1 )
• BC05 ( type: esriFieldTypeString, alias: B.C.05-Bridge Railings Condition Rating, length: 1 )
• BC06 ( type: esriFieldTypeString, alias: B.C.06-Bridge Railings Transitions Condition Rating, length: 1 )
• BC07 ( type: esriFieldTypeString, alias: B.C.07-Bridge Bearings Condition Rating, length: 1 )
• BC08 ( type: esriFieldTypeString, alias: B.C.08-Bridge Joints Condition Rating, length: 1 )
• BC09 ( type: esriFieldTypeString, alias: B.C.09-Channel Condition Rating, length: 1 )
• BC10 ( type: esriFieldTypeString, alias: B.C.10-Channel Protection Condition Rating, length: 1 )
• BC11 ( type: esriFieldTypeString, alias: B.C.11-Scour Condition Rating, length: 4 )
• BC12 ( type: esriFieldTypeString, alias: B.C.12-Bridge Condition Classification, length: 1 )
• BC12_LAST_REPORTED ( type: esriFieldTypeString, alias: B.C.12 (Last Reported)-Bridge Condition Classification Last Reported to FHWA, length: 10 )
• BC12_REPORTED_DATE ( type: esriFieldTypeDate, alias: B.C.12 (Reported Date)-Date of Bridge Condition Classification when Last Reported to FHWA, length: 8 )
• BC13 ( type: esriFieldTypeString, alias: B.C.13-Lowest Condition Rating Code, length: 1 )
• BC14 ( type: esriFieldTypeString, alias: B.C.14-NSTM Inspection Condition, length: 1 )
• BC15 ( type: esriFieldTypeString, alias: B.C.15-Underwater Inspection Condition, length: 1 )
• BAP01 ( type: esriFieldTypeString, alias: B.AP.01-Approach Roadway Alignment, length: 1 )
• BAP02 ( type: esriFieldTypeString, alias: B.AP.02-Overtopping Likelihood, length: 5 )
• BAP03 ( type: esriFieldTypeString, alias: B.AP.03-Scour Vulnerability, length: 5 )
• BAP04 ( type: esriFieldTypeString, alias: B.AP.04-Scour Plan of Action, length: 3 )
• BAP05 ( type: esriFieldTypeString, alias: B.AP.05-Seismic Vulnerability, length: 1 )
• BW01 ( type: esriFieldTypeSmallInteger, alias: B.W.01-Year Built )
• BH13_MIN ( type: esriFieldTypeDouble, alias: B.H.13 (Min.)-Highway Minimum Vertical Under Clearance )
• DISTRICT_STATE_HOUSE ( type: esriFieldTypeSmallInteger, alias: State House District )
• DISTRICT_STATE_SENATE ( type: esriFieldTypeSmallInteger, alias: State Senate District )
• BRIDGECONDINDEX ( type: esriFieldTypeDouble, alias: Bridge Condition Index )
• ALL_SYSTEMS_PERMIT_OVERWEIGHT ( type: esriFieldTypeInteger, alias: All Systems Permit Overweight )
• SYMBOL ( type: esriFieldTypeString, alias: Symbol for Condition Map, length: 3 )
• MAINTCENTER ( type: esriFieldTypeSmallInteger, alias: Maintenance Center )
• MAINTGARAGE ( type: esriFieldTypeSmallInteger, alias: Maintenance Garage )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• as_id_SIIMS ( type: esriFieldTypeInteger, alias: as_id value from SIIMS )
• BPS01_LAST ( type: esriFieldTypeString, alias: B.PS.01-Load Posting Status (most recent), length: 4 )
• BPS02_LAST ( type: esriFieldTypeDate, alias: B.PS.02-Posting Status Change Date (most recent), length: 8 )
• BIE01_LAST ( type: esriFieldTypeString, alias: B.IE.01-Inspection Type (most recent approved), length: 1 )
• BIE02_LAST ( type: esriFieldTypeDate, alias: B.IE.02-Inspection Begin Date (most recent approved), length: 8 )
• BIE03_LAST ( type: esriFieldTypeDate, alias: B.IE.03-Inspection Completion Date (most recent approved), length: 8 )
• BIE04_LAST ( type: esriFieldTypeString, alias: B.IE.04-Nationally Certified Bridge Inspector (most recent approved), length: 15 )
• BIE05_LAST ( type: esriFieldTypeSmallInteger, alias: B.IE.05-Inspection Interval (most recent approved) )
• BIE06_LAST ( type: esriFieldTypeDate, alias: B.IE.06-Inspection Due Date (most recent approved), length: 8 )
• BIE07_LAST ( type: esriFieldTypeString, alias: B.IE.07-Risk-Based Inspection Interval Method (most recent approved), length: 1 )
• BIE08_LAST ( type: esriFieldTypeDate, alias: B.IE.08-Inspection Quality Control Date (most recent approved), length: 8 )
• BIE09_LAST ( type: esriFieldTypeDate, alias: B.IE.09-Inspection Quality Assurance Date (most recent approved), length: 8 )
• BIE10_LAST ( type: esriFieldTypeDate, alias: B.IE.10-Inspection Data Update Date (most recent approved), length: 8 )
• BIE11_LAST ( type: esriFieldTypeString, alias: B.IE.11-Inspection Note (most recent approved), length: 300 )
• BIE12_LAST ( type: esriFieldTypeString, alias: B.IE.12-Inspection Equipment (most recent approved), length: 120 )

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

  Iteminfo   Thumbnail   Metadata