Name: ADA_Facilities_Table

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fe2f127ad50446aaaf1b6a01231f073e

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: false
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 )
• Owned__Leased ( type: esriFieldTypeString, alias: Owned/ Leased, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Owned__Leased )
• cityWorks.DBO.ADA_Facilities_Table.Area ( type: esriFieldTypeString, alias: cityWorks.DBO.ADA_Facilities_Table.Area, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: cityWorks.DBO.ADA_Facilities_Table.Area )
• Room_space ( type: esriFieldTypeString, alias: Room/space, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Room_space )
• Room_Space_Description ( type: esriFieldTypeString, alias: Room/Space Description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Room_Space_Description )
• Room_Space_Type ( type: esriFieldTypeString, alias: Room/Space Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Room_Space_Type )
• Element ( type: esriFieldTypeString, alias: Element, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Element )
• Element_Description ( type: esriFieldTypeString, alias: Element Description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Element_Description )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Attribute ( type: esriFieldTypeString, alias: Attribute, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Attribute )
• Attribute_Description ( type: esriFieldTypeString, alias: Attribute Description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Attribute_Description )
• On_Site_Value ( type: esriFieldTypeString, alias: On-Site Value, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: On_Site_Value )
• Compliant ( type: esriFieldTypeString, alias: Compliant, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Compliant )
• Program_Access_ ( type: esriFieldTypeString, alias: Program Access?, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Program_Access_ )
• Finding ( type: esriFieldTypeString, alias: Finding, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Finding )
• Photo_Reference_Number ( type: esriFieldTypeString, alias: Photo Reference Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Photo_Reference_Number )
• Priority ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Priority )
• Recommendation ( type: esriFieldTypeString, alias: Recommendation, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Recommendation )
• Recommended_Value ( type: esriFieldTypeString, alias: Recommended Value, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Recommended_Value )
• Element_Citation ( type: esriFieldTypeString, alias: Element_Citation, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Element_Citation )
• Mitigation_Difficulty ( type: esriFieldTypeString, alias: Mitigation Difficulty, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Mitigation_Difficulty )
• Milestone_Date ( type: esriFieldTypeString, alias: Milestone Date, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Milestone_Date )
• Milestone_Months ( type: esriFieldTypeInteger, alias: Milestone Months, editable: true, nullable: true, defaultValue: null, modelName: Milestone_Months )
• Suggested_Net_Priority__1__High ( type: esriFieldTypeInteger, alias: Suggested Net Priority (1- High to 15-Low), editable: true, nullable: true, defaultValue: null, modelName: Suggested_Net_Priority__1__High )
• Resolution_Status ( type: esriFieldTypeString, alias: Resolution Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Resolution_Status )
• Resolution_Comments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Resolution_Comments )
• Column1 ( type: esriFieldTypeInteger, alias: Column1, editable: true, nullable: true, defaultValue: null, modelName: Column1 )
• Column2 ( type: esriFieldTypeString, alias: Column2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Column2 )
• Column3 ( type: esriFieldTypeString, alias: Column3, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Column3 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FacilityID )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location )
• 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, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )

Templates:

• Name: ADA_Facilities_Table
  Description:
  Prototype:
  Location: null
  Owned__Leased: null
  cityWorks.DBO.ADA_Facilities_Table.Area: null
  Room_space: null
  Room_Space_Description: null
  Room_Space_Type: null
  Element: null
  Element_Description: null
  Latitude: null
  Longitude: null
  Attribute: null
  Attribute_Description: null
  On_Site_Value: null
  Compliant: null
  Program_Access_: null
  Finding: null
  Photo_Reference_Number: null
  Priority: null
  Recommendation: null
  Recommended_Value: null
  Element_Citation: null
  Mitigation_Difficulty: null
  Milestone_Date: null
  Milestone_Months: null
  Suggested_Net_Priority__1__High: null
  Resolution_Status: null
  Resolution_Comments: null
  Column1: null
  Column2: null
  Column3: null
  FacilityID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• cityWorks.DBO.ADA_Facilities (0) -- Related To: ADA Facilities (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,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

Child Resources:   Field Groups   Contingent Values

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