{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "Capital Programs Buildings", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 2925, "latestWkid": 2925, "xyTolerance": 0.003280833333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -111140600, "falseY": -91532100, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 250000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 0, 0, 255 ], "outline": null } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1.1981153897075802E7, "ymin": 3378701.5421904773, "xmax": 1.2093405545603558E7, "ymax": 3490731.912617475, "spatialReference": { "wkid": 2925, "latestWkid": 2925, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -111140600, "falseY": -91532100, "xyUnits": 3.672703675085654E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "BuildingName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "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": "BuildingAbbrev", "type": "esriFieldTypeString", "alias": "BuildingAbbrev", "length": 25, "domain": { "type": "codedValue", "name": "CP_BUILDING_ABBRV", "description": "Building Name Abbreviation", "codedValues": [ { "name": "AB", "code": "AB" }, { "name": "ACF", "code": "ACF" }, { "name": "BCP", "code": "BCP" }, { "name": "BTW-REC", "code": "BTW-REC" }, { "name": "CPP", "code": "CPP" }, { "name": "CRC", "code": "CRC" }, { "name": "CSL", "code": "CSL" }, { "name": "DSS", "code": "DSS" }, { "name": "EDRF-WTAB", "code": "EDRF-WTAB" }, { "name": "ESRC", "code": "ESRC" }, { "name": "FM", "code": "FM" }, { "name": "FS-1", "code": "FS-1" }, { "name": "FS-10", "code": "FS-10" }, { "name": "FS-1MS", "code": "FS-1MS" }, { "name": "FS-3", "code": "FS-3" }, { "name": "FS-4", "code": "FS-4" }, { "name": "FS-5", "code": "FS-5" }, { "name": "FS-6", "code": "FS-6" }, { "name": "FS-7", "code": "FS-7" }, { "name": "FS-8", "code": "FS-8" }, { "name": "GCB", "code": "GCB" }, { "name": "HBP-T", "code": "HBP-T" }, { "name": "HHSB", "code": "HHSB" }, { "name": "HR", "code": "HR" }, { "name": "JFK-AF", "code": "JFK-AF" }, { "name": "KF-AF", "code": "KF-AF" }, { "name": "LKP", "code": "LKP" }, { "name": "LMP", "code": "LMP" }, { "name": "LSL", "code": "LSL" }, { "name": "LSLPEW", "code": "LSLPEW" }, { "name": "MAG-PRK", "code": "MAG-PRK" }, { "name": "MBF", "code": "MBF" }, { "name": "MC", "code": "MC" }, { "name": "ML", "code": "ML" }, { "name": "MS", "code": "MS" }, { "name": "NSL", "code": "NSL" }, { "name": "NSRC", "code": "NSRC" }, { "name": "ORC", "code": "ORC" }, { "name": "PC-E", "code": "PC-E" }, { "name": "PC-TH", "code": "PC-TH" }, { "name": "PHQA", "code": "PHQA" }, { "name": "P-PRK", "code": "P-PRK" }, { "name": "PPS1", "code": "PPS1" }, { "name": "PPS2", "code": "PPS2" }, { "name": "PR-AB", "code": "PR-AB" }, { "name": "PU-CMP", "code": "PU-CMP" }, { "name": "PU-CS", "code": "PU-CS" }, { "name": "PU-ED", "code": "PU-ED" }, { "name": "PUG-P", "code": "PUG-P" }, { "name": "PU-LMS", "code": "PU-LMS" }, { "name": "PU-M", "code": "PU-M" }, { "name": "PU-RFW", "code": "PU-RFW" }, { "name": "PU-WTP", "code": "PU-WTP" }, { "name": "PWA-A", "code": "PWA-A" }, { "name": "PWA-B", "code": "PWA-B" }, { "name": "PWA-C", "code": "PWA-C" }, { "name": "PWA-D", "code": "PWA-D" }, { "name": "PWA-E", "code": "PWA-E" }, { "name": "PWA-F", "code": "PWA-F" }, { "name": "PWB-A", "code": "PWB-A" }, { "name": "PWB-B", "code": "PWB-B" }, { "name": "PWB-C", "code": "PWB-C" }, { "name": "PWC-A", "code": "PWC-A" }, { "name": "PWPINE-A", "code": "PWPINE-A" }, { "name": "PWPINE-B", "code": "PWPINE-B" }, { "name": "PWPINE-C", "code": "PWPINE-C" }, { "name": "PWPINE-D", "code": "PWPINE-D" }, { "name": "PWPINE-E", "code": "PWPINE-E" }, { "name": "PWPINE-F", "code": "PWPINE-F" }, { "name": "PWPINE-G", "code": "PWPINE-G" }, { "name": "PWPINE-H", "code": "PWPINE-H" }, { "name": "PWPINE-I", "code": "PWPINE-I" }, { "name": "PWPINE-J", "code": "PWPINE-J" }, { "name": "PWT-A", "code": "PWT-A" }, { "name": "PWT-B", "code": "PWT-B" }, { "name": "PWT-C", "code": "PWT-C" }, { "name": "PWT-E", "code": "PWT-E" }, { "name": "PWT-F", "code": "PWT-F" }, { "name": "PWT-G", "code": "PWT-G" }, { "name": "PWT-H", "code": "PWT-H" }, { "name": "PWT-J", "code": "PWT-J" }, { "name": "PWT-K", "code": "PWT-K" }, { "name": "PWT-L", "code": "PWT-L" }, { "name": "PWT-M", "code": "PWT-M" }, { "name": "PWT-N", "code": "PWT-N" }, { "name": "PWT-O", "code": "PWT-O" }, { "name": "PWT-P", "code": "PWT-P" }, { "name": "PWT-Q", "code": "PWT-Q" }, { "name": "PWT-T", "code": "PWT-T" }, { "name": "RFM", "code": "RFM" }, { "name": "SEA", "code": "SEA" }, { "name": "SHP", "code": "SHP" }, { "name": "SM", "code": "SM" }, { "name": "T-HC", "code": "T-HC" }, { "name": "VA-NGA", "code": "VA-NGA" }, { "name": "WBF", "code": "WBF" }, { "name": "WFDC", "code": "WFDC" }, { "name": "WRC", "code": "WRC" }, { "name": "WRC-REC", "code": "WRC-REC" }, { "name": "WTAB", "code": "WTAB" }, { "name": "WTS", "code": "WTS" }, { "name": "PWT-R", "code": "PWT-R" }, { "name": "PWT-S", "code": "PWT-S" }, { "name": "PWT-U", "code": "PWT-U" }, { "name": "PU-OPS", "code": "PU-OPS" }, { "name": "TSB", "code": "TSB" }, { "name": "PW-OPS-ADMIN", "code": "PW-OPS-ADMIN" }, { "name": "PW-OPS-STREET", "code": "PW-OPS-STREET" }, { "name": "PW-OPS-TRAFFIC", "code": "PW-OPS-TRAFFIC" }, { "name": "FS-2", "code": "FS-2" }, { "name": "FS-9", "code": "FS-9" }, { "name": "DT-COMM", "code": "DT-COMM" }, { "name": "DR-COMM", "code": "DR-COMM" }, { "name": "PR-COMM", "code": "PR-COMM" }, { "name": "HU-COMM", "code": "HU-COMM" }, { "name": "WH-COMM", "code": "WH-COMM" }, { "name": "OLD-TRANS", "code": "OLD-TRANS" }, { "name": "RAIL-MUSEUM", "code": "RAIL-MUSEUM" }, { "name": "BCRC", "code": "BCRC" }, { "name": "PRJO", "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": "Occupied", "type": "esriFieldTypeString", "alias": "Occupied", "length": 3, "domain": { "type": "codedValue", "name": "YES_NO_UNK", "description": "Yes, No, Unknown Choices", "codedValues": [ { "name": "YES", "code": "Y" }, { "name": "NO", "code": "N" }, { "name": "UNKNOWN", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BillingAddress", "type": "esriFieldTypeString", "alias": "BillingAddress", "length": 50, "domain": { "type": "codedValue", "name": "CP_Billing_Address", "description": "Billing Address", "codedValues": [ { "name": "P.O. Box 1858 Suffolk, Va 23439", "code": "MAIN" }, { "name": "866 Carolina Road Suffolk, Va 23439", "code": "DPW" }, { "name": "442 W. Washington Street Suffolk, Va 23434", "code": "DPU" }, { "name": "134 E. 6th Street, Suffolk, Va 23434", "code": "P&REC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CityworksID", "type": "esriFieldTypeString", "alias": "CityworksID", "length": 50, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "Common_Name", "type": "esriFieldTypeString", "alias": "Common_Name", "length": 100, "domain": null }, { "name": "Serviced", "type": "esriFieldTypeString", "alias": "Serviced", "length": 4, "domain": { "type": "codedValue", "name": "YES_NO_UNK", "description": "Yes, No, Unknown Choices", "codedValues": [ { "name": "YES", "code": "Y" }, { "name": "NO", "code": "N" }, { "name": "UNKNOWN", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Demolished", "type": "esriFieldTypeString", "alias": "Demolished", "length": 10, "domain": { "type": "codedValue", "name": "YES_NO_UNK", "description": "Yes, No, Unknown Choices", "codedValues": [ { "name": "YES", "code": "Y" }, { "name": "NO", "code": "N" }, { "name": "UNKNOWN", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "BldgID", "type": "esriFieldTypeString", "alias": "Building 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 } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R1031_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5016BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5016BldgID", "fields": "BldgID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S878_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Building_Component", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "BldgID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "Equipment", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "BldgID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "Fire_System", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "BldgID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "Generators", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "BldgID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "HVAC", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "BldgID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "Plumbing", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "BldgID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "Security", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "BldgID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "Septic", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "BldgID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "Ventilation", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "BldgID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "839204bc5d3e449a985394dbd05d3c90" } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Capital_Programs_Building_Component", "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": "Component_Type", "type": "esriFieldTypeString", "alias": "Component_Type", "length": 100, "domain": { "type": "codedValue", "name": "CP_BUILDING_COMPONENT_TYPE", "description": "Building Component Type", "codedValues": [ { "name": "Roof", "code": "ROOF" }, { "name": "Window", "code": "WIND" }, { "name": "Emergency Lighting", "code": "EMLT" }, { "name": "Elevator", "code": "ELVT" }, { "name": "Automatic Door", "code": "ADOR" }, { "name": "Detention Lock", "code": "DELC" }, { "name": "Other", "code": "OTHR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Primary_Material", "type": "esriFieldTypeString", "alias": "Primary_Material", "length": 100, "domain": { "type": "codedValue", "name": "CP_BUILDING_MATERIAL_TYPE", "description": "Building Material Type", "codedValues": [ { "name": "Metal", "code": "MET" }, { "name": "Flat", "code": "FLT" }, { "name": "Tar", "code": "TAR" }, { "name": "Rubber", "code": "RUB" }, { "name": "Synthetic Membrane", "code": "SYN" }, { "name": "Vinyl", "code": "VYN" }, { "name": "Other", "code": "OTHR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "Installed_By", "type": "esriFieldTypeString", "alias": "Installed By", "length": 100, "domain": null }, { "name": "Warranty_Info", "type": "esriFieldTypeString", "alias": "Warranty_Info", "length": 50, "domain": null }, { "name": "Color", "type": "esriFieldTypeString", "alias": "Color", "length": 50, "domain": null }, { "name": "Size_SQFT", "type": "esriFieldTypeString", "alias": "Size_SQFT", "length": 50, "domain": null }, { "name": "Install_Date", "type": "esriFieldTypeDate", "alias": "Year_Installed", "length": 8, "domain": null }, { "name": "Access_Method", "type": "esriFieldTypeString", "alias": "Access_Method", "length": 100, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 100, "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": "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": "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": "R1030_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5015BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5015ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "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" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "Capital_Programs_Equipment", "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": "EquipmentType", "type": "esriFieldTypeString", "alias": "EquipmentType", "length": 50, "domain": { "type": "codedValue", "name": "CP_Equipment_Type", "description": "List of CP Equipment Types", "codedValues": [ { "name": "Vacuum Cleaner", "code": "VC" }, { "name": "Shampooer", "code": "SHP" }, { "name": "Buffer", "code": "BUF" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "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": "R1021_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5006BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5006ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "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" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "Capital_Programs_Fire_System", "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": "SafeSystemType", "type": "esriFieldTypeString", "alias": "SafeSystemType", "length": 50, "domain": { "type": "codedValue", "name": "CP_FIRE_TYPE", "description": "Fire System Equipment Type", "codedValues": [ { "name": "Exstinguer 5 lbs", "code": "EXST5" }, { "name": "Exstinguer 6 lbs", "code": "EXST6" }, { "name": "Exstinguer 10 lbs", "code": "EXST10" }, { "name": "Exstinguer 16 lbs", "code": "EXST16" }, { "name": "Exstinguer 24 lbs", "code": "EXST24" }, { "name": "Fire Panel-Main", "code": "FIRPNLM" }, { "name": "Fire Panel-Sub", "code": "FIRPNLS" }, { "name": "Fire Suppression", "code": "FIRESUP" }, { "name": "Wheel Chair Lift", "code": "WHLIFT" }, { "name": "Chemical Suppression", "code": "CHEMSUP" }, { "name": "Wet Sprinkler", "code": "WETSPR" }, { "name": "Dry Sprinkler", "code": "DRYSPR" }, { "name": "Smoke Detector", "code": "SMKDEC" }, { "name": "Fire Alarm", "code": "FIR_AL" } ], "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": "Field", "type": "esriFieldTypeInteger", "alias": "Field", "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 100, "domain": null }, { "name": "Color", "type": "esriFieldTypeString", "alias": "Color", "length": 50, "domain": null }, { "name": "Installed_By", "type": "esriFieldTypeString", "alias": "Installed By", "length": 100, "domain": null }, { "name": "Warranty_Info", "type": "esriFieldTypeString", "alias": "Warranty_Info", "length": 50, "domain": null }, { "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": "R1026_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5011BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5011ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "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" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "Capital_Programs_Generators", "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": "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": "GeneratorType", "type": "esriFieldTypeString", "alias": "GeneratorType", "length": 50, "domain": { "type": "codedValue", "name": "CP_Generator_Type", "description": "CP Generator Types", "codedValues": [ { "name": "Generator Unit", "code": "GEN" }, { "name": "Transfer Switch", "code": "TRANS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Wattage", "type": "esriFieldTypeString", "alias": "Wattage", "length": 50, "domain": { "type": "codedValue", "name": "CP_Generator_Wattage", "description": "CP Generator Wattage Rating", "codedValues": [ { "name": "40Kw", "code": "40" }, { "name": "47Kw", "code": "47" }, { "name": "60Kw", "code": "60" }, { "name": "80Kw", "code": "80" }, { "name": "100Kw", "code": "100" }, { "name": "150Kw", "code": "150" }, { "name": "300Kw", "code": "300" }, { "name": "400Kw", "code": "400" }, { "name": "500Kw", "code": "500" }, { "name": "800Kw", "code": "800" }, { "name": "2250Kw", "code": "2250" }, { "name": "2500Kw", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Ownership", "type": "esriFieldTypeString", "alias": "Ownership", "length": 50, "domain": { "type": "codedValue", "name": "CP_GENERATOR_OWNERSHIP", "description": "Generator Ownership", "codedValues": [ { "name": "Owned", "code": "OWN" }, { "name": "Leased", "code": "LES" }, { "name": "Not Applicable", "code": "NA" } ], "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": "R1022_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5007BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5007ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "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" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 5, "name": "Capital_Programs_HVAC", "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": "HVACunit", "type": "esriFieldTypeString", "alias": "HVACunit", "length": 50, "domain": null }, { "name": "VAV", "type": "esriFieldTypeString", "alias": "VAV", "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": "HVACType", "type": "esriFieldTypeString", "alias": "HVACType", "length": 100, "domain": { "type": "codedValue", "name": "CP_HVAC_TYPE", "description": "HVAC Equipment Type", "codedValues": [ { "name": "Roof Top Unit", "code": "RTU" }, { "name": "Air Handler", "code": "AHD" }, { "name": "Ice Maker", "code": "ICE" }, { "name": "Exhaust Fan", "code": "EFN" }, { "name": "Motor", "code": "MOT" }, { "name": "VAVS", "code": "VAV" }, { "name": "Boiler", "code": "BOL" }, { "name": "Other", "code": "OTHR" }, { "name": "Pump-Chilled Water", "code": "PCW" }, { "name": "Pump-Circulating", "code": "PCR" }, { "name": "Pump-Hot Water", "code": "PHW" }, { "name": "Mini-Split System", "code": "MIN" }, { "name": "Package Unit-Gas", "code": "PUG" }, { "name": "Package Unit-Electric", "code": "PUE" }, { "name": "Split System-Gas", "code": "SSG" }, { "name": "Split System-Electric", "code": "SSE" }, { "name": "Chiller-Closed Loop", "code": "CCL" }, { "name": "Geothermal", "code": "GEO" } ], "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": "R1023_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5008BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5008ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "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" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 6, "name": "Capital_Programs_Meters", "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": "MeterType", "type": "esriFieldTypeString", "alias": "MeterType", "length": 50, "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": "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": "R1024_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5009BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 7, "name": "Capital_Programs_Plumbing", "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": "PlumbingType", "type": "esriFieldTypeString", "alias": "PumpType", "length": 100, "domain": { "type": "codedValue", "name": "CP_PLUMBING_TYPE", "description": "Plumbing Equipment Type", "codedValues": [ { "name": "Domestic Pump", "code": "DOMPUMP" }, { "name": "Hot Water Circulation Pump", "code": "HWCIRCPUMP" }, { "name": "Hot Water Mixing Valve", "code": "HWMIXVALVE" }, { "name": "Domestic Backflow Preventer", "code": "DOMBACK" }, { "name": "Fire Protection Backflow", "code": "FIREBACK" }, { "name": "Circulation Pump", "code": "CIRCPUMP" }, { "name": "Commerical Hot Water Heater Large", "code": "COMMHWLRG" }, { "name": "Commerical Hot Water Heater Small", "code": "COMMHWSML" }, { "name": "Domestic Hot Water Heater", "code": "DOMHW" }, { "name": "Under Sink Hot Water Heater", "code": "UNDERHW" }, { "name": "Boiler", "code": "BOILER" }, { "name": "Sprinkler Backflow Preventer", "code": "SPRBACK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "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": "R1025_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5010BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5010ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "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" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 8, "name": "Capital_Programs_Security", "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": "SecuritySystemType", "type": "esriFieldTypeString", "alias": "SecuritySystemType", "length": 50, "domain": { "type": "codedValue", "name": "CP_SECURITY_TYPE", "description": "Security Equipment Type", "codedValues": [ { "name": "Security Alarm", "code": "SEC_AL" }, { "name": "Security Lock", "code": "SEC_LOC" }, { "name": "Security Door", "code": "SEC_DOOR" }, { "name": "Cameras", "code": "CAMS" }, { "name": "Recorders", "code": "RECRD" }, { "name": "Servers", "code": "SERVS" }, { "name": "Cloud", "code": "CLOUD" }, { "name": "Other", "code": "OTR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ServiceVendor", "type": "esriFieldTypeString", "alias": "ServiceVendor", "length": 50, "domain": { "type": "codedValue", "name": "CP_SECURITY_VENDOR", "description": "Security Equipment Vendor", "codedValues": [ { "name": "CSI", "code": "CSI" }, { "name": "Stanley", "code": "STAN" }, { "name": "ADT", "code": "ADT" }, { "name": "ADT-TYCO", "code": "ADT-TY" }, { "name": "Tritronics", "code": "TRIT" }, { "name": "Miscellaneous", "code": "MISC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "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": "R1027_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5012BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5012ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "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" }, { "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" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 10, "name": "Capital_Programs_Ventilation", "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": "VentilationType", "type": "esriFieldTypeString", "alias": "VentilationType", "length": 50, "domain": { "type": "codedValue", "name": "CP_Vent_Type", "description": "CP Ventilation Types", "codedValues": [ { "name": "Exhaust Fan", "code": "EXF" }, { "name": "Plymovent", "code": "PLY" }, { "name": "Hood Vent", "code": "HVT" }, { "name": "Hood Vent Controller", "code": "HVTCON" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "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": "R1029_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5014BuildingNam", "fields": "BuildingName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5014ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "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" } ] }