{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "ProdGeoDB.STREETLIGHTS.StreetLighting_Arms", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "GIS_FeatureKey", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Streetlight GIS ID", "domain": null }, { "name": "GIS_FeatureKey", "type": "esriFieldTypeString", "alias": "Unique Arm ID", "length": 20, "domain": null }, { "name": "ArmLength", "type": "esriFieldTypeString", "alias": "Length", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_ArmLength", "description": "Street Lighting - Arm Length", "codedValues": [ { "name": "0.6 m (2 ft)", "code": "2" }, { "name": "1.2 m (4 ft)", "code": "4" }, { "name": "1.8 m (6 ft)", "code": "6" }, { "name": "2.4 m (8 ft)", "code": "8" }, { "name": "3.0 m (9.8 ft)", "code": "9.8" }, { "name": "3.6 m (11.8 ft)", "code": "11.8" }, { "name": "4.6 m (15 ft)", "code": "15" }, { "name": "5.5 m (18 ft)", "code": "18" }, { "name": "6.1 m (20 ft)", "code": "20" }, { "name": "6.7 m (22 ft)", "code": "22" }, { "name": "7.6 m (25 ft)", "code": "25" }, { "name": "3.2 m (10.5 ft)", "code": "10.5" }, { "name": "0.2 m (0.5 ft)", "code": "0.5" }, { "name": "0.3 m (1 ft)", "code": "1" }, { "name": "2.7 m (8.8 ft)", "code": "8.8" }, { "name": "Uknown", "code": "UKN" }, { "name": "Other", "code": "OTH" }, { "name": "N/A", "code": "N/A" }, { "name": "0.8 m (2.5 ft)", "code": "2.5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ArmColour", "type": "esriFieldTypeString", "alias": "Colour", "length": 25, "domain": { "type": "codedValue", "name": "StreetLighting_Colour", "description": "Street Lighting - Colour", "codedValues": [ { "name": "Other", "code": "Other" }, { "name": "Black", "code": "Black" }, { "name": "Green", "code": "Green" }, { "name": "Grey", "code": "Grey" }, { "name": "N/A", "code": "N/A" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ArmStyle", "type": "esriFieldTypeString", "alias": "Style", "length": 8, "domain": { "type": "codedValue", "name": "StreetLighting_ArmStyle", "description": "Street Lighting - Arm Style", "codedValues": [ { "name": "Downtown Decorative (Stresscrete)", "code": "DD-S" }, { "name": "Decorative (Candy Cane)", "code": "D-CC" }, { "name": "Scroll Arm", "code": "SCROLL" }, { "name": "N/A", "code": "N/A" }, { "name": "Standard", "code": "STND" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R1472_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1857GIS_ID", "fields": "GIS_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "StreetLight Features", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{914FBDB2-1F5A-4B3B-89EB-9030DD87765A}" } ], "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }