{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "ProdGeoDB.STREETLIGHTS.StreetLighting_Poles", "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 Pole ID", "length": 20, "domain": null }, { "name": "PoleLength", "type": "esriFieldTypeString", "alias": "Length", "length": 4, "domain": { "type": "codedValue", "name": "StreetLighting_PoleLength", "description": "Street Lighting - Pole Length", "codedValues": [ { "name": "4.6 m (15 ft)", "code": "15" }, { "name": "5.5 m (18 ft)", "code": "18" }, { "name": "5.6m (18.5 ft)", "code": "18.5" }, { "name": "5.8m (19 ft)", "code": "19" }, { "name": "6.0 m (19.5 ft)", "code": "19.5" }, { "name": "6.1m (20 ft)", "code": "20" }, { "name": "6.6m (21.5 ft)", "code": "21.5" }, { "name": "6.7m (22 ft)", "code": "22" }, { "name": "6.9 m (22.5 ft)", "code": "22.5" }, { "name": "7.3 m (24 ft)", "code": "24" }, { "name": "7.6 m (25 ft)", "code": "25" }, { "name": "8.4 m (27.5 ft)", "code": "27.5" }, { "name": "9.1m (30 ft)", "code": "30" }, { "name": "9.8m (32 ft)", "code": "32" }, { "name": "9.9 m (32.5 ft)", "code": "32.5" }, { "name": "10 m (33 ft)", "code": "33" }, { "name": "10.7 m (35 ft)", "code": "35" }, { "name": "11.4 m (37.5 ft)", "code": "37.5" }, { "name": "11.6 m (38 ft)", "code": "38" }, { "name": "12.2 m (40 ft)", "code": "40" }, { "name": "6.4m (20.5 ft)", "code": "6.4" }, { "name": "7.9 m (26 ft)", "code": "7.9" }, { "name": "2.7 m (9 ft)", "code": "9" }, { "name": "N/A", "code": "N/A" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleMaterial", "type": "esriFieldTypeString", "alias": "Material", "length": 8, "domain": { "type": "codedValue", "name": "StreetLighting_PoleMaterial", "description": "Street Lighting - Pole Material", "codedValues": [ { "name": "Other", "code": "Other" }, { "name": "Aluminum", "code": "Aluminum" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Steel", "code": "Steel" }, { "name": "Wood", "code": "Wood" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleFoundation", "type": "esriFieldTypeString", "alias": "Foundation", "length": 13, "domain": { "type": "codedValue", "name": "StreetLighting_PoleFoundation", "description": "Street Lighting - Pole Foundation", "codedValues": [ { "name": "Concrete", "code": "Concrete" }, { "name": "Direct Buried", "code": "Direct Buried" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleStyle", "type": "esriFieldTypeString", "alias": "Style", "length": 14, "domain": { "type": "codedValue", "name": "StreetLighting_PoleStyle", "description": "Street Lighting - Pole Style", "codedValues": [ { "name": "Other", "code": "Other" }, { "name": "Decorative", "code": "D" }, { "name": "Non-Decorative", "code": "ND" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleColour", "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": "PoleUse", "type": "esriFieldTypeString", "alias": "Use", "length": 4, "domain": { "type": "codedValue", "name": "StreetLighting_PoleUse", "description": "Street Lighting - Pole Use", "codedValues": [ { "name": "Single Use", "code": "SU" }, { "name": "Joint Use - Traffic", "code": "JU-T" }, { "name": "Joint Use - Hydro", "code": "JU-H" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HeadCount", "type": "esriFieldTypeInteger", "alias": "Head Count", "domain": { "type": "codedValue", "name": "StreetLighting_HeadCount", "description": "Street Lighting - Head Count", "codedValues": [ { "name": "1 Head", "code": 1 }, { "name": "2 Heads", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FeedSubtype", "type": "esriFieldTypeString", "alias": "Feed Type", "length": 7, "domain": { "type": "codedValue", "name": "StreetLighting_Feedtype", "description": "Street Lighting - Feed type", "codedValues": [ { "name": "Underground Feed", "code": "UGF" }, { "name": "Overhead Feed", "code": "OHF" }, { "name": "N/A", "code": "N/A" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R1471_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1856GIS_ID", "fields": "GIS_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "StreetLight Features", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{64108B9E-15CA-4BCF-B46C-3556E970B9F3}" } ], "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 } }