{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 135, "name": "Hydrant_Assessment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ExportAppName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Start", "type": "esriFieldTypeDate", "alias": "Start", "length": 8, "domain": null }, { "name": "End", "type": "esriFieldTypeDate", "alias": "End", "length": 8, "domain": null }, { "name": "SubmissionNumber", "type": "esriFieldTypeDouble", "alias": "SubmissionNumber", "domain": null }, { "name": "ExportAppName", "type": "esriFieldTypeString", "alias": "ExportAppName", "length": 255, "domain": null }, { "name": "Username", "type": "esriFieldTypeString", "alias": "Username", "length": 255, "domain": null }, { "name": "UserLastName", "type": "esriFieldTypeString", "alias": "UserLastName", "length": 255, "domain": null }, { "name": "UserFirstName", "type": "esriFieldTypeString", "alias": "UserFirstName", "length": 255, "domain": null }, { "name": "ResponseID", "type": "esriFieldTypeString", "alias": "ResponseID", "length": 255, "domain": null }, { "name": "ResponseDate_Time", "type": "esriFieldTypeDate", "alias": "ResponseDate_Time", "length": 8, "domain": null }, { "name": "DeviceDate_Time", "type": "esriFieldTypeDate", "alias": "DeviceDate_Time", "length": 8, "domain": null }, { "name": "SubmissionFormName", "type": "esriFieldTypeString", "alias": "SubmissionFormName", "length": 255, "domain": null }, { "name": "SubmissionFormVersion", "type": "esriFieldTypeDouble", "alias": "SubmissionFormVersion", "domain": null }, { "name": "SectionName", "type": "esriFieldTypeString", "alias": "SectionName", "length": 255, "domain": null }, { "name": "Client", "type": "esriFieldTypeString", "alias": "Client", "length": 255, "domain": null }, { "name": "Hydrant", "type": "esriFieldTypeDouble", "alias": "Hydrant", "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 255, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 255, "domain": null }, { "name": "ZipCode", "type": "esriFieldTypeString", "alias": "ZipCode", "length": 255, "domain": null }, { "name": "TypeofHydrant", "type": "esriFieldTypeString", "alias": "TypeofHydrant", "length": 255, "domain": null }, { "name": "AssessmentPhoto", "type": "esriFieldTypeString", "alias": "AssessmentPhoto", "length": 255, "domain": null }, { "name": "SummaryofHydrantdisfunction", "type": "esriFieldTypeString", "alias": "SummaryofHydrantdisfunction", "length": 255, "domain": null }, { "name": "TroubleCodes", "type": "esriFieldTypeString", "alias": "TroubleCodes", "length": 255, "domain": null }, { "name": "UpperBarrel", "type": "esriFieldTypeSmallInteger", "alias": "UpperBarrel", "domain": null }, { "name": "LowerBarrel", "type": "esriFieldTypeSmallInteger", "alias": "LowerBarrel", "domain": null }, { "name": "HydrantGreased", "type": "esriFieldTypeSmallInteger", "alias": "HydrantGreased", "domain": null }, { "name": "HydrantFlushed", "type": "esriFieldTypeSmallInteger", "alias": "HydrantFlushed", "domain": null }, { "name": "HydrantPainted", "type": "esriFieldTypeSmallInteger", "alias": "HydrantPainted", "domain": null }, { "name": "CommentHalls", "type": "esriFieldTypeString", "alias": "CommentHalls", "length": 255, "domain": null }, { "name": "PhotoHalls", "type": "esriFieldTypeString", "alias": "PhotoHalls", "length": 255, "domain": null }, { "name": "Partsreplaced", "type": "esriFieldTypeString", "alias": "Partsreplaced", "length": 255, "domain": null }, { "name": "Notes_Comments", "type": "esriFieldTypeString", "alias": "Notes_Comments", "length": 255, "domain": null }, { "name": "Technician", "type": "esriFieldTypeString", "alias": "Technician", "length": 255, "domain": null }, { "name": "ProjectManager", "type": "esriFieldTypeString", "alias": "ProjectManager", "length": 255, "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "Lat", "type": "esriFieldTypeDouble", "alias": "Lat", "domain": null }, { "name": "Lng", "type": "esriFieldTypeDouble", "alias": "Lng", "domain": null }, { "name": "HydName", "type": "esriFieldTypeString", "alias": "HydName", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I275HydName", "fields": "HydName", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "f219c65c4e5e47fa8e3cf831800cbd88" }