{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Light Poles", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2881, "latestWkid": 2881, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17791300, "falseY": -41645400, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "spatialReference": { "wkid": 2881, "latestWkid": 2881, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -17791300, "falseY": -41645400, "xyUnits": 1.372494229425764E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 10000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "613fde40e69be811efe542d581a7b9c8", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABlUlEQVQ4jb3U2yvDYRzH8ff8Zj/KbJOS5JdtTknKBbmh5tDCyM0k+Qu4cicR+QPUEnGl5E7J4WaRciGHkmgOJfyEkaI0/Nac2wVZttmv5FPPxfNcvPo+fZ/nq+UPo/1PTAMUAOmAD/AAfrWYiDG3HUtDDRaHGYPFROD2Adl9hjy/yeWaC/DGgqVgbRzFPuFAZ0j8OtVLaaQWWynpsrE+UMzOYA9+30Z0LKt2BMe0E40Q+eZlfdXEaXWs9rR+rzAUM+W1YRuqjwx9S2l3BVcr3cjujvBYpq0JgzWJmKIBqa4c2Z342ZRQLNmcjZpIlfkQXwTPGz8xQdSrwkRjPEZzOneH/MReAooq7MH7huI9/tyGYvenJ0BhzJh3+Yinx93wmHI1zNmiHalG/BV68sGNZwl4D48dzSygM82SUtBMUkZk6P0V1vr3OJjsjP5o98dbEHQiOc5GpKrg3wyNT4Yt1x7KpR0IRMeCZXvGmhASnJwvdaLPzEMQk3l79aNcyygXc+yM9YYrOPLU2HZNAcEVc/51nqnKB2E6cWhZjlh2AAAAAElFTkSuQmCC", "contentType": "image/png", "width": 14, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 865308.7838206701, "ymin": 642634.838787429, "xmax": 909886.2934187539, "ymax": 676699.9845677614, "spatialReference": { "wkid": 2881, "latestWkid": 2881, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -17791300, "falseY": -41645400, "xyUnits": 1.372494229425764E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "timeInfo": { "startTimeField": "ProblemReportDate", "endTimeField": null, "trackIdField": null, "type": "field", "timeExtent": [ 18000000, 1460534400000 ], "timeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "timeInterval": 3, "timeIntervalUnits": "esriTimeUnitsYears", "exportOptions": { "useTime": true, "timeDataCumulative": false, "timeOffset": null, "timeOffsetUnits": null }, "hasLiveData": false, "timeRelation": "esriTimeRelationOverlaps" }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Location", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FPLID", "type": "esriFieldTypeDouble", "alias": "FPLID", "domain": null }, { "name": "PoleNum", "type": "esriFieldTypeDouble", "alias": "PoleNum", "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 75, "domain": null }, { "name": "AccountNum", "type": "esriFieldTypeDouble", "alias": "AccountNum", "domain": null }, { "name": "ComponentCode", "type": "esriFieldTypeString", "alias": "ComponentCode", "length": 10, "domain": { "type": "codedValue", "name": "SLCompCode", "description": "Streetlight Component Code - HPS Wattage or Pole Material", "codedValues": [ { "name": "HPS0070", "code": "HPS0070" }, { "name": "HPS0100", "code": "HPS0100" }, { "name": "HPS0150", "code": "HPS0150" }, { "name": "HPS0200", "code": "HPS0200" }, { "name": "HPS0400", "code": "HPS0400" }, { "name": "PMC0001", "code": "PMC0001" }, { "name": "PMW0001", "code": "PMW0001" }, { "name": "LED041", "code": "LED041" }, { "name": "LED0168", "code": "LED0168" }, { "name": "LED060", "code": "LED060" }, { "name": "LED026", "code": "LED026" }, { "name": "LED058", "code": "LED058" }, { "name": "LED0118", "code": "LED0118" }, { "name": "LED0133", "code": "LED0133" }, { "name": "LED0138", "code": "LED0138" }, { "name": "LED0274", "code": "LED0274" }, { "name": "LED076", "code": "LED076" }, { "name": "LED080", "code": "LED080" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ComponentDesc", "type": "esriFieldTypeString", "alias": "ComponentDesc", "length": 30, "domain": { "type": "codedValue", "name": "SLCompDesc", "description": "Streetlight Component Description", "codedValues": [ { "name": "Decorative Light", "code": "Decorative Light" }, { "name": "FPL Meter", "code": "FPL Meter" }, { "name": "Light Panel", "code": "Light Panel" }, { "name": "Light Panel / FPL Meter", "code": "Light Panel / FPL Meter" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 25, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 25, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "PoleType", "type": "esriFieldTypeString", "alias": "PoleT ype", "length": 30, "domain": { "type": "codedValue", "name": "SLMaterial", "description": "Streetlight Material", "codedValues": [ { "name": "Metal Halide", "code": "Metal Halide" }, { "name": "Wood", "code": "Wood" }, { "name": "Steel", "code": "Steel" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Aluminum", "code": "Aluminum" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleStyle", "type": "esriFieldTypeString", "alias": "Pole Style", "length": 30, "domain": { "type": "codedValue", "name": "SLPoleStyle", "description": "Street Light Pole Style", "codedValues": [ { "name": "Standard", "code": "Standard" }, { "name": "Decorative", "code": "Decorative" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleHeight", "type": "esriFieldTypeSmallInteger", "alias": "Pole Height", "domain": null }, { "name": "ArmLength", "type": "esriFieldTypeSmallInteger", "alias": "Arm Length", "domain": null }, { "name": "FixtureType", "type": "esriFieldTypeString", "alias": "FixtureType", "length": 20, "domain": { "type": "codedValue", "name": "SLFixtureType", "description": "Type of Street Light Head", "codedValues": [ { "name": "Cobra", "code": "Cobra" }, { "name": "ShoeBox", "code": "Shoebox" }, { "name": "Post-Top", "code": "Post-Top" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LampType", "type": "esriFieldTypeString", "alias": "LampType", "length": 30, "domain": { "type": "codedValue", "name": "SLLampType", "description": "Type of Street Lght Lamp", "codedValues": [ { "name": "LED", "code": "LED" }, { "name": "High-Pressure Sodium", "code": "HPS" }, { "name": "Metal Halide", "code": "MHALIDE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PowerSource", "type": "esriFieldTypeString", "alias": "Power Source", "length": 50, "domain": null }, { "name": "OwnedBy", "type": "esriFieldTypeString", "alias": "Owned By", "length": 30, "domain": { "type": "codedValue", "name": "SLOwnedBy", "description": "Street Light Ownership", "codedValues": [ { "name": "City", "code": "City" }, { "name": "County", "code": "County" }, { "name": "FPL", "code": "FPL" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlMethod", "type": "esriFieldTypeString", "alias": "Control Method", "length": 30, "domain": { "type": "codedValue", "name": "SLControlMethod", "description": "How the Street Light truns on", "codedValues": [ { "name": "Photocell", "code": "Photocell" }, { "name": "Timer", "code": "Timer" }, { "name": "Smart Node", "code": "Smart Node" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "OperationalStatus", "type": "esriFieldTypeString", "alias": "Operational Status", "length": 30, "domain": { "type": "codedValue", "name": "SLStatus", "description": "Oprtational Status of Light Pole", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Out of Service", "code": "Out of Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ConditionRating", "type": "esriFieldTypeSmallInteger", "alias": "Condition Rating", "domain": null }, { "name": "LastInspectionDate", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "LastRepairDate", "type": "esriFieldTypeDate", "alias": "Last Repair Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R12_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G20FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S2_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "StreetLightProblemReporting", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B097ED5E-5CB3-41F0-A068-C0CDD08E2BB3}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "1280101187544a06beef374b7694ce05" } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "StreetLightProblemReporting", "type": "Table", "description": null, "copyrightText": null, "timeInfo": { "startTimeField": "FieldReportDate", "endTimeField": null, "trackIdField": null, "timeExtent": [ 1456308000000, 1512005939000 ], "timeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "Etc/GMT+5", "respectsDaylightSaving": false }, "timeInterval": 2, "timeIntervalUnits": "esriTimeUnitsMonths", "exportOptions": { "useTime": true, "timeDataCumulative": false, "timeOffset": 0, "timeOffsetUnits": "esriTimeUnitsYears" }, "hasLiveData": false, "timeRelation": "esriTimeRelationOverlaps" }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MaintBy", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MaintBy", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 15, "domain": { "type": "codedValue", "name": "SLMaintBy", "description": "Streetlight Maintained By", "codedValues": [ { "name": "FPL", "code": "FPL" }, { "name": "City", "code": "City" }, { "name": "County", "code": "County" }, { "name": "State", "code": "State" }, { "name": "City Maintained FDOT Owned", "code": "FDOTCity" }, { "name": "FPL Maintained - FDOT Reimbursed", "code": "FPL_FDOT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FieldReportDate", "type": "esriFieldTypeDate", "alias": "Field Report Date", "length": 8, "domain": null }, { "name": "ReportedBy", "type": "esriFieldTypeString", "alias": "Reported By", "length": 30, "domain": { "type": "codedValue", "name": "SLReportedBy", "description": "Streetlight Problem Reported By", "codedValues": [ { "name": "Resident", "code": "Resident" }, { "name": "Public Works", "code": "Public Works" }, { "name": "Facilities Management", "code": "Facilities Management" }, { "name": "Police", "code": "Police" }, { "name": "Code Enforcement", "code": "Code Enforcement" }, { "name": "Other (Enter in Comments)", "code": "Other (Enter in Comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Problem", "length": 30, "domain": { "type": "codedValue", "name": "SLProblem", "description": "Streetlight Problem", "codedValues": [ { "name": "Completely out", "code": "Completely out" }, { "name": "Stays on 24 hours", "code": "Stays on 24 hours" }, { "name": "Turns on and off", "code": "Turns on and off" }, { "name": "Light is dim", "code": "Light is dim" }, { "name": "Flickers on and off rapidly", "code": "Flickers on and off rapidly" }, { "name": "Multiple lights out in a row", "code": "Multiple lights out in a row" }, { "name": "Other (Enter in Comments)", "code": "Other (Enter in Comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AgencyReportDate", "type": "esriFieldTypeDate", "alias": "Agency Report Date", "length": 8, "domain": null }, { "name": "AgencyReported", "type": "esriFieldTypeString", "alias": "Agency Reported", "length": 10, "domain": { "type": "codedValue", "name": "SLReportedTo", "description": "Agency Reported To", "codedValues": [ { "name": "City", "code": "City" }, { "name": "FPL", "code": "FPL" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 150, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 25, "domain": null }, { "name": "PoleNum", "type": "esriFieldTypeString", "alias": "PoleNum", "length": 25, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 75, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "AgencyReportedBy", "type": "esriFieldTypeString", "alias": "Agency Reported By", "length": 5, "domain": { "type": "codedValue", "name": "SLAgencyReportedBy", "description": "Agency Reported By", "codedValues": [ { "name": "JM", "code": "JM" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FPLTicketNumber", "type": "esriFieldTypeString", "alias": "FPLTicketNumber", "length": 20, "domain": null }, { "name": "Resolved", "type": "esriFieldTypeString", "alias": "Resolved", "length": 3, "domain": { "type": "codedValue", "name": "DomainY/N", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R13_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_13", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G21FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_13", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "pwStreetlights", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B097ED5E-5CB3-41F0-A068-C0CDD08E2BB3}" } ], "capabilities": "Map,Query,Data", "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1280101187544a06beef374b7694ce05" } ] }