Name: SNBI_01_PRIMARY_TBL

Display Field: BID01

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 8f318809a7ed4a15b27590de61c6da27

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: true
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: false
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:

Fields:

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

Templates:

• Name: SNBI_01_PRIMARY_TBL
  Description:
  Prototype:
  BIE11_LAST: null
  BIE10_LAST: null
  BL01: 19
  BID01:
  BID02: null
  BID03: null
  BL02: null
  BL02_TEXT: null
  BL03: null
  BL03_TEXT: null
  BL04: null
  BL05: null
  BL06: null
  BL07: null
  BL08: null
  BL09: null
  BL10: null
  BL11: null
  BL12: null
  BCL01: null
  BCL02: null
  BCL03: null
  BCL04: null
  BCL05: null
  BCL06: null
  BRH01: null
  BRH02: null
  BG01: null
  BG02: null
  BG03: null
  BG04: null
  BG05: null
  BG06: null
  BG07: null
  BG08: null
  BG09: null
  BG10: null
  BG11: null
  BG12: null
  BG13: null
  BG14: null
  BG15: null
  BG16: null
  BLR01: null
  BLR02: null
  BLR03: null
  BLR04: null
  BLR05: null
  BLR06: null
  BLR07: null
  BLR08: null
  BIR01: null
  BIR02: null
  BIR03: null
  BIR04: null
  BC01: null
  BC02: null
  BC03: null
  BC04: null
  BC05: null
  BC06: null
  BC07: null
  BC08: null
  BC09: null
  BC10: null
  BC11: null
  BC12: null
  BC12_LAST_REPORTED: null
  BC12_REPORTED_DATE: null
  BC13: null
  BC14: null
  BC15: null
  BAP01: null
  BAP02: null
  BAP03: null
  BAP04: null
  BAP05: null
  BW01: null
  BH13_MIN: null
  DISTRICT_STATE_HOUSE: null
  DISTRICT_STATE_SENATE: null
  BRIDGECONDINDEX: null
  ALL_SYSTEMS_PERMIT_OVERWEIGHT: null
  SYMBOL: null
  MAINTCENTER: null
  MAINTGARAGE: null
  BIE12_LAST: null
  BIE09_LAST: null
  BIE08_LAST: null
  BIE07_LAST: null
  BIE06_LAST: null
  as_id_SIIMS: null
  BPS01_LAST: null
  BPS02_LAST: null
  BIE01_LAST: null
  BIE02_LAST: null
  BIE03_LAST: null
  BIE04_LAST: null
  BIE05_LAST: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata