{ "currentVersion": 10.91, "id": 7, "name": "Controller", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CONTLTYPE", "type": "esriFieldTypeString", "alias": "Controller Type", "length": 30, "domain": { "type": "codedValue", "name": "itsSignalControllerType", "description": "Signal Controller Type", "codedValues": [ { "name": "Econolite ASC2", "code": "Econolite ASC2" }, { "name": "Econolite ASC3", "code": "Econolite ASC3" }, { "name": "2070", "code": "2070" }, { "name": "2070 C1 Processor", "code": "2070 C1 Processor" }, { "name": "Cobalt", "code": "Cobalt" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONTLSERNUM", "type": "esriFieldTypeString", "alias": "Controller Serial Number", "length": 20, "domain": null }, { "name": "CONTLIPNUM", "type": "esriFieldTypeString", "alias": "Controller IP Address", "length": 20, "domain": null }, { "name": "CONTFIRMNUM", "type": "esriFieldTypeString", "alias": "Contoller Firmware Number", "length": 20, "domain": null }, { "name": "CONSEQUENCEOFFAILURE", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": { "type": "codedValue", "name": "glblConsequenceOfFailure_DBL", "description": "global Consequence Of Failure", "codedValues": [ { "name": "Very minor consequence", "code": 1 }, { "name": "Minor consequence", "code": 2 }, { "name": "Moderate consequence", "code": 3 }, { "name": "Major consequence", "code": 4 }, { "name": "Catastrophic consequence", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LIKELIHOODOFFAILURE", "type": "esriFieldTypeDouble", "alias": "Likelihood of Failure", "domain": { "type": "codedValue", "name": "glblLikelihoodofFailure_DBL", "description": "global Likelihood of Failure", "codedValues": [ { "name": "Very Low: Failure is unlikely", "code": 1 }, { "name": "Low: Failure might happen", "code": 2 }, { "name": "Moderate: Failure could occur", "code": 3 }, { "name": "High: Failure is highly probable", "code": 4 }, { "name": "Very High: Failure is certain", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CRITICALITY", "type": "esriFieldTypeDouble", "alias": "Criticality", "domain": null }, { "name": "CRITICALITYDATE", "type": "esriFieldTypeDate", "alias": "Criticality Date", "length": 8, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "PURCHASEPRICE", "type": "esriFieldTypeDouble", "alias": "Purchase Price", "domain": null }, { "name": "CURRENTCONDITIONRATING", "type": "esriFieldTypeSmallInteger", "alias": "Current Condition Rating", "domain": { "type": "codedValue", "name": "glblCurrentConditionRating_SINT", "description": "global Current Condition Rating", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failed", "code": 5 }, { "name": "Not Feasible", "code": 0 }, { "name": "Not Appropriate", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "LASTINSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "LIFEEXPECTANCY", "type": "esriFieldTypeSmallInteger", "alias": "Life Expectancy", "domain": null }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "Life Cycle Status", "length": 50, "domain": { "type": "codedValue", "name": "glblLifeCycleStatus", "description": "global Life Cycle Status", "codedValues": [ { "name": "Plan", "code": "Plan" }, { "name": "Design", "code": "Design" }, { "name": "Construction", "code": "Construction" }, { "name": "In Service", "code": "In Service" }, { "name": "Abandoned in Place", "code": "Abandoned in Place" }, { "name": "Decommissioned", "code": "Decommissioned" }, { "name": "Acquired", "code": "Acquired" }, { "name": "Transferred", "code": "Transferred" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location Description", "length": 255, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeString", "alias": "Owned By", "length": 50, "domain": { "type": "codedValue", "name": "glblOwnedMaintBy", "description": "global Owned Maint By", "codedValues": [ { "name": "Airport", "code": "Airport" }, { "name": "Parks and Conservation Resources", "code": "Parks and Conservation Resources" }, { "name": "Public Works", "code": "Public Works" }, { "name": "Solid Waste", "code": "Solid Waste" }, { "name": "Utilities", "code": "Utilities" }, { "name": "Army Corp of Engineers", "code": "Army Corp of Engineers" }, { "name": "Belleair", "code": "Belleair" }, { "name": "Belleair Beach", "code": "Belleair Beach" }, { "name": "Belleair Bluffs", "code": "Belleair Bluffs" }, { "name": "Belleair Shore", "code": "Belleair Shore" }, { "name": "Clearwater", "code": "Clearwater" }, { "name": "Duke Energy", "code": "Duke Energy" }, { "name": "Dunedin", "code": "Dunedin" }, { "name": "Gulfport", "code": "Gulfport" }, { "name": "Indian Rocks Beach", "code": "Indian Rocks Beach" }, { "name": "Indian Shores", "code": "Indian Shores" }, { "name": "Kenneth City", "code": "Kenneth City" }, { "name": "Largo", "code": "Largo" }, { "name": "Madeira Beach", "code": "Madeira Beach" }, { "name": "N Redington Beach", "code": "N Redington Beach" }, { "name": "Oldsmar", "code": "Oldsmar" }, { "name": "Pinellas County Other", "code": "Pinellas County Other" }, { "name": "Pinellas Park", "code": "Pinellas Park" }, { "name": "Private Entity", "code": "Private Entity" }, { "name": "Redington Beach", "code": "Redington Beach" }, { "name": "Redington Shores", "code": "Redington Shores" }, { "name": "Safety Harbor", "code": "Safety Harbor" }, { "name": "Seminole", "code": "Seminole" }, { "name": "South Pasadena", "code": "South Pasadena" }, { "name": "St Pete Beach", "code": "St Pete Beach" }, { "name": "St Petersburg", "code": "St Petersburg" }, { "name": "SWFWMD", "code": "SWFWMD" }, { "name": "Tarpon Springs", "code": "Tarpon Springs" }, { "name": "Treasure Island", "code": "Treasure Island" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Tampa Bay Water", "code": "Tampa Bay Water" }, { "name": "Pinellas Park Water Management District", "code": "Pinellas Park Water Management District" }, { "name": "Florida Department of Environmental Protection", "code": "FDEP" }, { "name": "Florida Department of Transportation", "code": "FDOT" }, { "name": "Fish and Wildlife Conservation Commission", "code": "FWC" }, { "name": "Pinellas County Sheriff Office", "code": "PCSO" }, { "name": "Facilities Real Property", "code": "Facilities Real Property" }, { "name": "Fleet", "code": "Fleet" }, { "name": "Pinellas County School Board", "code": "PCSB" }, { "name": "Elected Officials", "code": "Elected Officials" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Economic Development", "code": "Economic Development" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTAINEDBY", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 50, "domain": { "type": "codedValue", "name": "glblOwnedMaintBy", "description": "global Owned Maint By", "codedValues": [ { "name": "Airport", "code": "Airport" }, { "name": "Parks and Conservation Resources", "code": "Parks and Conservation Resources" }, { "name": "Public Works", "code": "Public Works" }, { "name": "Solid Waste", "code": "Solid Waste" }, { "name": "Utilities", "code": "Utilities" }, { "name": "Army Corp of Engineers", "code": "Army Corp of Engineers" }, { "name": "Belleair", "code": "Belleair" }, { "name": "Belleair Beach", "code": "Belleair Beach" }, { "name": "Belleair Bluffs", "code": "Belleair Bluffs" }, { "name": "Belleair Shore", "code": "Belleair Shore" }, { "name": "Clearwater", "code": "Clearwater" }, { "name": "Duke Energy", "code": "Duke Energy" }, { "name": "Dunedin", "code": "Dunedin" }, { "name": "Gulfport", "code": "Gulfport" }, { "name": "Indian Rocks Beach", "code": "Indian Rocks Beach" }, { "name": "Indian Shores", "code": "Indian Shores" }, { "name": "Kenneth City", "code": "Kenneth City" }, { "name": "Largo", "code": "Largo" }, { "name": "Madeira Beach", "code": "Madeira Beach" }, { "name": "N Redington Beach", "code": "N Redington Beach" }, { "name": "Oldsmar", "code": "Oldsmar" }, { "name": "Pinellas County Other", "code": "Pinellas County Other" }, { "name": "Pinellas Park", "code": "Pinellas Park" }, { "name": "Private Entity", "code": "Private Entity" }, { "name": "Redington Beach", "code": "Redington Beach" }, { "name": "Redington Shores", "code": "Redington Shores" }, { "name": "Safety Harbor", "code": "Safety Harbor" }, { "name": "Seminole", "code": "Seminole" }, { "name": "South Pasadena", "code": "South Pasadena" }, { "name": "St Pete Beach", "code": "St Pete Beach" }, { "name": "St Petersburg", "code": "St Petersburg" }, { "name": "SWFWMD", "code": "SWFWMD" }, { "name": "Tarpon Springs", "code": "Tarpon Springs" }, { "name": "Treasure Island", "code": "Treasure Island" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Tampa Bay Water", "code": "Tampa Bay Water" }, { "name": "Pinellas Park Water Management District", "code": "Pinellas Park Water Management District" }, { "name": "Florida Department of Environmental Protection", "code": "FDEP" }, { "name": "Florida Department of Transportation", "code": "FDOT" }, { "name": "Fish and Wildlife Conservation Commission", "code": "FWC" }, { "name": "Pinellas County Sheriff Office", "code": "PCSO" }, { "name": "Facilities Real Property", "code": "Facilities Real Property" }, { "name": "Fleet", "code": "Fleet" }, { "name": "Pinellas County School Board", "code": "PCSB" }, { "name": "Elected Officials", "code": "Elected Officials" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Economic Development", "code": "Economic Development" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DATACOLLECTIONMETHOD", "type": "esriFieldTypeString", "alias": "Data Collection Method", "length": 50, "domain": { "type": "codedValue", "name": "glblDataSource", "description": "global Data Source", "codedValues": [ { "name": "Manual", "code": "Manual" }, { "name": "Aerial", "code": "Aerial" }, { "name": "GPS", "code": "GPS" }, { "name": "Survey Grade", "code": "Survey Grade" }, { "name": "Record Drawing", "code": "Record Drawing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LOCATIONID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 50, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null }, { "name": "CONTSHIPDATE", "type": "esriFieldTypeDate", "alias": "Ship Date of controller", "length": 8, "domain": null }, { "name": "CONTFIRMWAREREV", "type": "esriFieldTypeString", "alias": "Firmware Revision Number", "length": 20, "domain": null }, { "name": "FEDSYSTEM", "type": "esriFieldTypeString", "alias": "Federal System", "length": 10, "domain": { "type": "codedValue", "name": "FederalSystem", "description": "FederalSystem", "codedValues": [ { "name": "5 - NHS", "code": "NHS" }, { "name": "6 - STP", "code": "STP" }, { "name": "9 - FA NONE", "code": "FA NONE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "EMERGMGMTFUND", "type": "esriFieldTypeString", "alias": "Emergency Mgmt Fund Name", "length": 10, "domain": { "type": "codedValue", "name": "PMSEmergFund", "description": "PMS Emergency Fund", "codedValues": [ { "name": "FEMA", "code": "FEMA" }, { "name": "FHWA-ER", "code": "FHWA-ER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 250, "domain": null }, { "name": "ATTACHMENT", "type": "esriFieldTypeString", "alias": "Attachment URL", "length": 250, "domain": null }, { "name": "SITE_NAME", "type": "esriFieldTypeString", "alias": "Site Name", "length": 100, "domain": null }, { "name": "ENDOFLIFEDATE", "type": "esriFieldTypeDate", "alias": "End of Life Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R3068_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_3068", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G16193LOCATIONID", "fields": "LOCATIONID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_3068", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Traffic Cabinet", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "LocationID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }