{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 9, "name": "Capital_Programs_Septic", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BuildingName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TankType", "type": "esriFieldTypeString", "alias": "TankType", "length": 50, "domain": { "type": "codedValue", "name": "CP_TANK_TYPE", "description": "Tank Material Type", "codedValues": [ { "name": "Fiberglass", "code": "FIBER" }, { "name": "Steel", "code": "STEEL" }, { "name": "Concrete", "code": "CON" }, { "name": "Aluminum", "code": "ALU" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TankSize", "type": "esriFieldTypeString", "alias": "TankSize", "length": 50, "domain": { "type": "codedValue", "name": "CP_TANK_SIZE", "description": "Tank Size", "codedValues": [ { "name": "10,000 Gallon", "code": "10000" }, { "name": "Not Applicable", "code": "NA" }, { "name": "3,000 Gallon", "code": "3000" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ServiceVendor", "type": "esriFieldTypeString", "alias": "ServiceVendor", "length": 50, "domain": null }, { "name": "LastServiceDate", "type": "esriFieldTypeDate", "alias": "LastServiceDate", "length": 8, "domain": null }, { "name": "BuildingName", "type": "esriFieldTypeString", "alias": "BuildingName", "length": 50, "domain": { "type": "codedValue", "name": "CP_BUILDING_NAME", "description": "Building Name", "codedValues": [ { "name": "Assessor\u2019s Building", "code": "AB" }, { "name": "Animal Control Facility", "code": "ACF" }, { "name": "Bennett\u2019s Creek Park", "code": "BCP" }, { "name": "Booker T. Washington Recreation Center", "code": "BTW-REC" }, { "name": "Cypress Park and Pool", "code": "CPP" }, { "name": "Creekside Recreation Center", "code": "CRC" }, { "name": "Chuckatuck Station Library", "code": "CSL" }, { "name": "Driver Sportsplex Site", "code": "DSS" }, { "name": "EDR Facility Phase 1& 2", "code": "EDRF-WTAB" }, { "name": "East Suffolk Recreation Center", "code": "ESRC" }, { "name": "Fleet Management", "code": "FM" }, { "name": "Fire Station #1", "code": "FS-1" }, { "name": "Fire Station #10", "code": "FS-10" }, { "name": "Fire Station #1 Maintenance Shop", "code": "FS-1MS" }, { "name": "Fire Station #3", "code": "FS-3" }, { "name": "Fire Station #4", "code": "FS-4" }, { "name": "Fire Station #5", "code": "FS-5" }, { "name": "Fire Station #6 Public Safety Center", "code": "FS-6" }, { "name": "Fire Station #7", "code": "FS-7" }, { "name": "Fire Station #8", "code": "FS-8" }, { "name": "Godwin Courts Building", "code": "GCB" }, { "name": "Holland Ball Park and Triangle", "code": "HBP-T" }, { "name": "Health and Human Services Department", "code": "HHSB" }, { "name": "Human Resources Building", "code": "HR" }, { "name": "JFK Athletic Facility", "code": "JFK-AF" }, { "name": "King\u2019s Fork Athletic Complex", "code": "KF-AF" }, { "name": "Lake Kennedy Park", "code": "LKP" }, { "name": "Lake Meade park", "code": "LMP" }, { "name": "Lone Star Lodge", "code": "LSL" }, { "name": "Lone Star Lakes Park Entrance Ways", "code": "LSLPEW" }, { "name": "Magnolia Park", "code": "MAG-PRK" }, { "name": "Monogram Ball Field", "code": "MBF" }, { "name": "Municipal Center", "code": "MC" }, { "name": "Morgan Library", "code": "ML" }, { "name": "North Suffolk Library", "code": "NSL" }, { "name": "Northern Shores Recreation Center", "code": "NSRC" }, { "name": "Oakland Recreation Center", "code": "ORC" }, { "name": "Planters Club/Entrance", "code": "PC-E" }, { "name": "Planters Club-Tenant House", "code": "PC-TH" }, { "name": "Police Headquarters Admin", "code": "PHQA" }, { "name": "Peanut Park", "code": "P-PRK" }, { "name": "Police Precinct Sector 1", "code": "PPS1" }, { "name": "Police Precinct Sector 2", "code": "PPS2" }, { "name": "Parks and Recreation Administration Annex Building", "code": "PR-AB" }, { "name": "Pughsville Park", "code": "PUG-P" }, { "name": "Public Utilities Line Maintenance Shop", "code": "PU-LMS" }, { "name": "Public Utilities Maintenance", "code": "PU-M" }, { "name": "Public Utilities Water Treatment Plant", "code": "PU-WTP" }, { "name": "Public Works Building A \u2013 Zone A Office", "code": "PWA-A" }, { "name": "Public Works Building B \u2013 Zone A Shop", "code": "PWA-B" }, { "name": "Public Works Building C \u2013 Zone A Salt Building", "code": "PWA-C" }, { "name": "Public Works Building D \u2013 Zone A Warehouse Office", "code": "PWA-D" }, { "name": "Public Works Building E \u2013 Zone A Warehouse", "code": "PWA-E" }, { "name": "Public Works Building F \u2013 Zone A Gas Pumps and Support Structure", "code": "PWA-F" }, { "name": "Public Works Building A \u2013 Zone B Office", "code": "PWB-A" }, { "name": "Public Works Building B \u2013 Zone B Salt Building", "code": "PWB-B" }, { "name": "Public Works Building C \u2013 Zone B Material Building", "code": "PWB-C" }, { "name": "Public Works Building A \u2013 Zone C Office", "code": "PWC-A" }, { "name": "Public Works Trailer A \u2013 Assistant Director\u2019s Office", "code": "PWT-A" }, { "name": "Public Works Trailer B \u2013 Roadway Admin Office", "code": "PWT-B" }, { "name": "Public Works Trailer C \u2013 Traffic Engineer Admin Office", "code": "PWT-C" }, { "name": "Public Works Trailer G \u2013 Zone D Office", "code": "PWT-G" }, { "name": "Public Works Trailer H \u2013 Mosquito Control", "code": "PWT-H" }, { "name": "Public Works Trailer J \u2013 Training Facility", "code": "PWT-J" }, { "name": "Public Works Trailer K \u2013 Signal Storage", "code": "PWT-K" }, { "name": "Public Works Trailer L \u2013 File Room", "code": "PWT-L" }, { "name": "Public Works Trailer N \u2013 Paint Metal Building", "code": "PWT-N" }, { "name": "Public Works Trailer O \u2013 Salt Building", "code": "PWT-O" }, { "name": "Public Works Trailer P \u2013 Paint Building \u2013 Fabric Tensioned Building", "code": "PWT-P" }, { "name": "Public Works Trailer Q \u2013 Permits/Litter Control", "code": "PWT-Q" }, { "name": "Public Works Trailer T \u2013 Tormmel Screen", "code": "PWT-T" }, { "name": "Riddick\u2019s Folly Museum", "code": "RFM" }, { "name": "Suffolk Executive Airport", "code": "SEA" }, { "name": "Sleepy Hole Park", "code": "SHP" }, { "name": "Suffolk Museum", "code": "SM" }, { "name": "Tourism (Historic Courthouse)", "code": "T-HC" }, { "name": "VA National Guard Armory", "code": "VA-NGA" }, { "name": "Whaleyville Center & Ball Field", "code": "WBF" }, { "name": "Work Force Development Center", "code": "WFDC" }, { "name": "Whaleyville Center", "code": "WRC" }, { "name": "Whaleyville Recreation Center", "code": "WRC-REC" }, { "name": "Water Treatment Administration Building", "code": "WTAB" }, { "name": "Whaleyville Village Town Square", "code": "WTS" }, { "name": "Public Works Building A \u2013 PW-Storage Building 1", "code": "PWPINE-A" }, { "name": "Public Works Building B \u2013 PWE-Storage Building\nPWE-Storage Building", "code": "PWPINE-B" }, { "name": "Public Works Building C \u2013 PW-Storage Building 2", "code": "PWPINE-C" }, { "name": "Public Works Building D \u2013 PWE-Equipment Shed 1", "code": "PWPINE-D" }, { "name": "Public Works Building E \u2013 Office and Locker Room", "code": "PWPINE-E" }, { "name": "Public Works Building H \u2013 PWE-Equipment Shed 2", "code": "PWPINE-H" }, { "name": "Public Works Building I \u2013 PW-Storage Building 3", "code": "PWPINE-I" }, { "name": "Public Works Building J \u2013 PW-Storage Building 4", "code": "PWPINE-J" }, { "name": "Public Works Trailer E \u2013 Sign/Signal Shop", "code": "PWT-E" }, { "name": "Public Works Trailer M \u2013 Storage 1", "code": "PWT-M" }, { "name": "Public Works Trailer F \u2013 Sign/Signal Shop", "code": "PWT-F" }, { "name": "Public Works Trailer R \u2013 Street Construction/ Locker Room", "code": "PWT-R" }, { "name": "Public Works Trailer S \u2013 Storage 2", "code": "PWT-S" }, { "name": "Public Works Trailer U \u2013 Storage 3", "code": "PWT-U" }, { "name": "Public Utilities Operations Center", "code": "PU-OPS" }, { "name": "Transit Support Building - Main ST", "code": "TSB" }, { "name": "Public Works Operation - Admin", "code": "PW-OPS-ADMIN" }, { "name": "Public Works Operation - Street", "code": "PW-OPS-STREET" }, { "name": "Public Works Operation - Traffic", "code": "PW-OPS-TRAFFIC" }, { "name": "Fire Station #2", "code": "FS-2" }, { "name": "Fire Station #9", "code": "FS-9" }, { "name": "Downtown Communication Tower", "code": "DT-COMM" }, { "name": "Driver Communication Tower", "code": "DR-COMM" }, { "name": "Pruden Communication Tower", "code": "PR-COMM" }, { "name": "Hunter Communication Tower", "code": "HU-COMM" }, { "name": "Whaleyville Communication Tower", "code": "WH-COMM" }, { "name": "Old Transmitter Site Suffolk", "code": "OLD-TRANS" }, { "name": "Suffolk Seaboard Station Railroad Museum", "code": "RAIL-MUSEUM" }, { "name": "Bennetts Creek Recreation Center", "code": "BCRC" }, { "name": "Parks and Recreation Joint Operations", "code": "PRJO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "CP_Condition_Code", "description": "CP Condition of Assest", "codedValues": [ { "name": "GOOD", "code": "GD" }, { "name": "POOR", "code": "PR" }, { "name": "FAIR", "code": "FR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "SepticType", "type": "esriFieldTypeString", "alias": "SepticType", "length": 100, "domain": { "type": "codedValue", "name": "CP_SEPTIC_TYPE", "description": "Septic Equipment Type", "codedValues": [ { "name": "Septic System", "code": "SEPSYS" }, { "name": "Chopper Pump", "code": "CHPMP" }, { "name": "Other", "code": "OTHR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Building Relate ID", "length": 10, "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 } ], "indexes": [ { "name": "R1028_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5013BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5013ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Buildings", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "839204bc5d3e449a985394dbd05d3c90" }