{ "currentVersion": 10.91, "id": 4, "name": "Surge", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CONDITION", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Condition", "length": 50, "domain": { "type": "codedValue", "name": "ITSCondition", "description": "ITS Condition", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNEDBY_DELETE", "type": "esriFieldTypeSmallInteger", "alias": "SET FOR DELETION", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Pinellas County", "code": 50 }, { "name": "Belleair Beach", "code": 2 }, { "name": "Belleair Bluffs", "code": 3 }, { "name": "Belleair Shore", "code": 4 }, { "name": "Clearwater", "code": 5 }, { "name": "Dunedin", "code": 6 }, { "name": "Gulfport", "code": 7 }, { "name": "Indian Rocks Beach", "code": 8 }, { "name": "Indian Shores", "code": 9 }, { "name": "Kenneth City", "code": 10 }, { "name": "Largo", "code": 11 }, { "name": "Madeira Beach", "code": 12 }, { "name": "N Redington Beach", "code": 13 }, { "name": "Oldsmar", "code": 14 }, { "name": "Pinellas Park", "code": 15 }, { "name": "Redington Beach", "code": 16 }, { "name": "Redington Shores", "code": 17 }, { "name": "Safety Harbor", "code": 18 }, { "name": "St Petersburg", "code": 19 }, { "name": "St Pete Beach", "code": 20 }, { "name": "Semnole", "code": 21 }, { "name": "South Pasadena", "code": 22 }, { "name": "Tarpon Springs", "code": 23 }, { "name": "Treasure Island", "code": 24 }, { "name": "Unncorporated", "code": 25 }, { "name": "State of Florida", "code": 100 }, { "name": "SWFWMD", "code": 101 }, { "name": "FDOT", "code": 102 }, { "name": "Unknown", "code": -3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Pinellas County", "code": 50 }, { "name": "Belleair Beach", "code": 2 }, { "name": "Belleair Bluffs", "code": 3 }, { "name": "Belleair Shore", "code": 4 }, { "name": "Clearwater", "code": 5 }, { "name": "Dunedin", "code": 6 }, { "name": "Gulfport", "code": 7 }, { "name": "Indian Rocks Beach", "code": 8 }, { "name": "Indian Shores", "code": 9 }, { "name": "Kenneth City", "code": 10 }, { "name": "Largo", "code": 11 }, { "name": "Madeira Beach", "code": 12 }, { "name": "N Redington Beach", "code": 13 }, { "name": "Oldsmar", "code": 14 }, { "name": "Pinellas Park", "code": 15 }, { "name": "Redington Beach", "code": 16 }, { "name": "Redington Shores", "code": 17 }, { "name": "Safety Harbor", "code": 18 }, { "name": "St Peatersburg", "code": 19 }, { "name": "St Pete Beach", "code": 20 }, { "name": "Seminole", "code": 21 }, { "name": "South Pasadena", "code": 22 }, { "name": "Tarpon Springs", "code": 23 }, { "name": "Treasure Island", "code": 24 }, { "name": "Unincorporated", "code": 25 }, { "name": "State of Floirda", "code": 100 }, { "name": "SWFWMD", "code": 101 }, { "name": "FDOT", "code": 102 }, { "name": "Unknown", "code": -3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "SURGEPROTECTIONTYPE1", "type": "esriFieldTypeString", "alias": "Surge Protection Type 1", "length": 50, "domain": { "type": "codedValue", "name": "ITSSurgeProtectionType", "description": "ITS Surge Protection Type", "codedValues": [ { "name": "DC", "code": "DC" }, { "name": "AC", "code": "AC" }, { "name": "RS232/comm", "code": "RS232/comm" }, { "name": "coax", "code": "coax" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURGEPROTECTIONTYPE2", "type": "esriFieldTypeString", "alias": "Surge Protection Type 2", "length": 50, "domain": { "type": "codedValue", "name": "ITSSurgeProtectionType", "description": "ITS Surge Protection Type", "codedValues": [ { "name": "DC", "code": "DC" }, { "name": "AC", "code": "AC" }, { "name": "RS232/comm", "code": "RS232/comm" }, { "name": "coax", "code": "coax" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURGEPROTECTIONTYPE3", "type": "esriFieldTypeString", "alias": "Surge Protection Type 3", "length": 50, "domain": { "type": "codedValue", "name": "ITSSurgeProtectionType", "description": "ITS Surge Protection Type", "codedValues": [ { "name": "DC", "code": "DC" }, { "name": "AC", "code": "AC" }, { "name": "RS232/comm", "code": "RS232/comm" }, { "name": "coax", "code": "coax" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURGEPROTECTIONMANUFACTURER", "type": "esriFieldTypeString", "alias": "Surge Protection Manufacturer", "length": 50, "domain": { "type": "codedValue", "name": "ITSSurgeProtectionManuType", "description": "ITS Surge Protection Manu Type", "codedValues": [ { "name": "Atlantic Scientific", "code": "Atlantic Scientific" }, { "name": "EDCO/Emerson", "code": "EDCO/Emerson" }, { "name": "Citel", "code": "Citel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURGEPROTECTIONSERIALNUM1", "type": "esriFieldTypeString", "alias": "Surge Protection Serial Number 1", "length": 50, "domain": null }, { "name": "SURGEPROTECTIONSERIALNUM2", "type": "esriFieldTypeString", "alias": "Surge Protection Serial Number 2", "length": 50, "domain": null }, { "name": "SURGEPROTECTIONSERIALNUM3", "type": "esriFieldTypeString", "alias": "Surge Protection Serial Number 3", "length": 50, "domain": null }, { "name": "CABINETID", "type": "esriFieldTypeString", "alias": "Signal Cabinet ID", "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": "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": "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": "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": "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": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "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": "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": "R3016_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_3016", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G16141CABINETID", "fields": "CABINETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_3016", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Traffic Cabinet", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "CabinetID", "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 }