Name: Ancillary_Structures_Inspections

Display Field: LSS_ConsultantName_txt

Type: Table

Geometry Type: N/A

Description:

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

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 )
• LSS_InspectionId_s ( type: esriFieldTypeString, alias: LSS_InspectionId_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_InspectionId_s )
• LSS_InventoryId_s ( type: esriFieldTypeString, alias: LSS_InventoryId_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_InventoryId_s )
• LSS_InspectionTypeId_s ( type: esriFieldTypeString, alias: LSS_InspectionTypeId_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_InspectionTypeId_s )
• LSS_InspectionDate_d ( type: esriFieldTypeDate, alias: LSS_InspectionDate_d, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LSS_InspectionDate_d )
• LSS_DistHWYEngineerId_L ( type: esriFieldTypeInteger, alias: LSS_DistHWYEngineerId_L, editable: true, nullable: true, defaultValue: null, modelName: LSS_DistHWYEngineerId_L )
• LSS_Weather_s ( type: esriFieldTypeString, alias: LSS_Weather_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_Weather_s )
• LSS_AirTempF_s ( type: esriFieldTypeString, alias: LSS_AirTempF_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_AirTempF_s )
• LSS_TeamLeaderId_L ( type: esriFieldTypeInteger, alias: LSS_TeamLeaderId_L, editable: true, nullable: true, defaultValue: null, modelName: LSS_TeamLeaderId_L )
• LSS_ProjectManagerId_L ( type: esriFieldTypeInteger, alias: LSS_ProjectManagerId_L, editable: true, nullable: true, defaultValue: null, modelName: LSS_ProjectManagerId_L )
• LSS_ConsultantName_txt ( type: esriFieldTypeString, alias: LSS_ConsultantName_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_ConsultantName_txt )
• LSS_Cracks_b ( type: esriFieldTypeSmallInteger, alias: LSS_Cracks_b, editable: true, nullable: true, defaultValue: null, modelName: LSS_Cracks_b )
• LSS_CondFoundationCurr_s ( type: esriFieldTypeString, alias: LSS_CondFoundationCurr_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondFoundationCurr_s )
• LSS_CondFoundationPrev_s ( type: esriFieldTypeString, alias: LSS_CondFoundationPrev_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondFoundationPrev_s )
• LSS_CondStructureCurr_s ( type: esriFieldTypeString, alias: LSS_CondStructureCurr_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondStructureCurr_s )
• LSS_CondStructurePrev_s ( type: esriFieldTypeString, alias: LSS_CondStructurePrev_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondStructurePrev_s )
• LSS_StructAttachmentsCurr_s ( type: esriFieldTypeString, alias: LSS_StructAttachmentsCurr_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_StructAttachmentsCurr_s )
• LSS_StructAttachmentsPrev_s ( type: esriFieldTypeString, alias: LSS_StructAttachmentsPrev_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_StructAttachmentsPrev_s )
• LSS_CondSignPanelsCurr_s ( type: esriFieldTypeString, alias: LSS_CondSignPanelsCurr_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondSignPanelsCurr_s )
• LSS_CondSignPanelsPrev_s ( type: esriFieldTypeString, alias: LSS_CondSignPanelsPrev_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondSignPanelsPrev_s )
• LSS_CondTrafficSafetyCurr_s ( type: esriFieldTypeString, alias: LSS_CondTrafficSafetyCurr_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondTrafficSafetyCurr_s )
• LSS_CondTrafficSafetyPrev_s ( type: esriFieldTypeString, alias: LSS_CondTrafficSafetyPrev_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondTrafficSafetyPrev_s )
• LSS_CondLuminaireCurr_s ( type: esriFieldTypeString, alias: LSS_CondLuminaireCurr_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondLuminaireCurr_s )
• LSS_CondLuminairePrev_s ( type: esriFieldTypeString, alias: LSS_CondLuminairePrev_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondLuminairePrev_s )
• LSS_CondOverallCurr_s ( type: esriFieldTypeString, alias: LSS_CondOverallCurr_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondOverallCurr_s )
• LSS_CondOverallPrev_s ( type: esriFieldTypeString, alias: LSS_CondOverallPrev_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CondOverallPrev_s )
• LSS_Recommendations_txt ( type: esriFieldTypeString, alias: LSS_Recommendations_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_Recommendations_txt )
• LSS_TotalAccessibilityHours_r ( type: esriFieldTypeDouble, alias: LSS_TotalAccessibilityHours_r, editable: true, nullable: true, defaultValue: null, modelName: LSS_TotalAccessibilityHours_r )
• LSS_Plans_b ( type: esriFieldTypeSmallInteger, alias: LSS_Plans_b, editable: true, nullable: true, defaultValue: null, modelName: LSS_Plans_b )
• LSS_Photos_b ( type: esriFieldTypeSmallInteger, alias: LSS_Photos_b, editable: true, nullable: true, defaultValue: null, modelName: LSS_Photos_b )
• LSS_DateOfPhotos_d ( type: esriFieldTypeDate, alias: LSS_DateOfPhotos_d, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LSS_DateOfPhotos_d )
• LSS_FieldTestPerformed_txt ( type: esriFieldTypeString, alias: LSS_FieldTestPerformed_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_FieldTestPerformed_txt )
• LSS_GeneralComments_txt ( type: esriFieldTypeString, alias: LSS_GeneralComments_txt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LSS_GeneralComments_txt )
• LSS_CsrRating_txt ( type: esriFieldTypeString, alias: LSS_CsrRating_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CsrRating_txt )
• LSS_CsrRatingYear_txt ( type: esriFieldTypeString, alias: LSS_CsrRatingYear_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CsrRatingYear_txt )
• LSS_LanesUnderStructure_txt ( type: esriFieldTypeString, alias: LSS_LanesUnderStructure_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_LanesUnderStructure_txt )
• LSS_ADT_s ( type: esriFieldTypeString, alias: LSS_ADT_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_ADT_s )
• LSS_ADTYear_s ( type: esriFieldTypeString, alias: LSS_ADTYear_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_ADTYear_s )
• LSS_AdditionalComments_txt ( type: esriFieldTypeString, alias: LSS_AdditionalComments_txt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LSS_AdditionalComments_txt )
• LSS_Complete_b ( type: esriFieldTypeSmallInteger, alias: LSS_Complete_b, editable: true, nullable: true, defaultValue: null, modelName: LSS_Complete_b )
• LSS_CompleteDate_d ( type: esriFieldTypeDate, alias: LSS_CompleteDate_d, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LSS_CompleteDate_d )
• LSS_Reviewed_L ( type: esriFieldTypeInteger, alias: LSS_Reviewed_L, editable: true, nullable: true, defaultValue: null, modelName: LSS_Reviewed_L )
• LSS_ReviewDate_d ( type: esriFieldTypeString, alias: LSS_ReviewDate_d, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_ReviewDate_d )
• LSS_Approved_L ( type: esriFieldTypeDouble, alias: LSS_Approved_L, editable: true, nullable: true, defaultValue: null, modelName: LSS_Approved_L )
• LSS_ApprovedDate_d ( type: esriFieldTypeDate, alias: LSS_ApprovedDate_d, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LSS_ApprovedDate_d )
• LSS_CreatedBy_s ( type: esriFieldTypeString, alias: LSS_CreatedBy_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CreatedBy_s )
• LSS_CreatedISODate_s ( type: esriFieldTypeString, alias: LSS_CreatedISODate_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_CreatedISODate_s )
• LSS_ModifiedBy_s ( type: esriFieldTypeString, alias: LSS_ModifiedBy_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_ModifiedBy_s )
• LSS_ModifiedISODate_s ( type: esriFieldTypeString, alias: LSS_ModifiedISODate_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_ModifiedISODate_s )
• LSS_ApprovalComments_txt ( type: esriFieldTypeString, alias: LSS_ApprovalComments_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_ApprovalComments_txt )
• LSS_DMeterNotes_txt ( type: esriFieldTypeString, alias: LSS_DMeterNotes_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_DMeterNotes_txt )
• LSS_Inspection_UUIDKey_s ( type: esriFieldTypeString, alias: LSS_Inspection_UUIDKey_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_Inspection_UUIDKey_s )
• LSS_Damage_d ( type: esriFieldTypeDate, alias: LSS_Damage_d, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LSS_Damage_d )
• LSS_DamageBy_s ( type: esriFieldTypeString, alias: LSS_DamageBy_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_DamageBy_s )
• LSS_DamageAccidentReport_B ( type: esriFieldTypeSmallInteger, alias: LSS_DamageAccidentReport_B, editable: true, nullable: true, defaultValue: null, modelName: LSS_DamageAccidentReport_B )
• LSS_DamageReimbursementNo_s ( type: esriFieldTypeString, alias: LSS_DamageReimbursementNo_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_DamageReimbursementNo_s )
• LSS_DamageCause_txt ( type: esriFieldTypeString, alias: LSS_DamageCause_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_DamageCause_txt )
• LSS_DamBostonCopyForwardTo_s ( type: esriFieldTypeString, alias: LSS_DamBostonCopyForwardTo_s, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_DamBostonCopyForwardTo_s )
• LSS_DamBostonOffice_d ( type: esriFieldTypeString, alias: LSS_DamBostonOffice_d, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_DamBostonOffice_d )
• LSS_DamBostonOfficeRemarks_txt ( type: esriFieldTypeString, alias: LSS_DamBostonOfficeRemarks_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSS_DamBostonOfficeRemarks_txt )
• 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 )
• GlobalID_rel ( type: esriFieldTypeGUID, alias: GlobalID_rel, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GlobalID_rel )

Templates:

• Name: Ancillary_Structures_Inspections
  Description:
  Prototype:
  LSS_DamBostonOfficeRemarks_txt: null
  GlobalID_rel: null
  LSS_InspectionId_s: null
  LSS_InventoryId_s: null
  LSS_InspectionTypeId_s: null
  LSS_InspectionDate_d: null
  LSS_DistHWYEngineerId_L: null
  LSS_Weather_s: null
  LSS_AirTempF_s: null
  LSS_TeamLeaderId_L: null
  LSS_ProjectManagerId_L: null
  LSS_ConsultantName_txt: null
  LSS_Cracks_b: null
  LSS_CondFoundationCurr_s: null
  LSS_CondFoundationPrev_s: null
  LSS_CondStructureCurr_s: null
  LSS_CondStructurePrev_s: null
  LSS_StructAttachmentsCurr_s: null
  LSS_StructAttachmentsPrev_s: null
  LSS_CondSignPanelsCurr_s: null
  LSS_CondSignPanelsPrev_s: null
  LSS_CondTrafficSafetyCurr_s: null
  LSS_CondTrafficSafetyPrev_s: null
  LSS_CondLuminaireCurr_s: null
  LSS_CondLuminairePrev_s: null
  LSS_CondOverallCurr_s: null
  LSS_CondOverallPrev_s: null
  LSS_Recommendations_txt: null
  LSS_TotalAccessibilityHours_r: null
  LSS_Plans_b: null
  LSS_Photos_b: null
  LSS_DateOfPhotos_d: null
  LSS_FieldTestPerformed_txt: null
  LSS_GeneralComments_txt: null
  LSS_CsrRating_txt: null
  LSS_CsrRatingYear_txt: null
  LSS_LanesUnderStructure_txt: null
  LSS_ADT_s: null
  LSS_ADTYear_s: null
  LSS_AdditionalComments_txt: null
  LSS_Complete_b: null
  LSS_CompleteDate_d: null
  LSS_Reviewed_L: null
  LSS_ReviewDate_d: null
  LSS_Approved_L: null
  LSS_ApprovedDate_d: null
  LSS_CreatedBy_s: null
  LSS_CreatedISODate_s: null
  LSS_ModifiedBy_s: null
  LSS_ModifiedISODate_s: null
  LSS_ApprovalComments_txt: null
  LSS_DMeterNotes_txt: null
  LSS_Inspection_UUIDKey_s: null
  LSS_Damage_d: null
  LSS_DamageBy_s: null
  LSS_DamageAccidentReport_B: null
  LSS_DamageReimbursementNo_s: null
  LSS_DamageCause_txt: null
  LSS_DamBostonCopyForwardTo_s: null
  LSS_DamBostonOffice_d: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.Ancillary_Structures (0) -- Related To: Ancillary Structures (0)

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: 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: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata