{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 7,
 "name": "Plumbing",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": {
  "creationDateField": "created_date",
  "creatorField": "created_user",
  "editDateField": "last_edited_date",
  "editorField": "last_edited_user"
 },
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [
  {
   "id": 6,
   "name": "Buildings",
   "relatedTableId": 0,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "ParentID",
   "composite": false,
   "catalogID": "{80103C92-4C2A-4BA2-8A0C-9251ED9701B8}"
  }
 ],
 "isDataVersioned": true,
 "isDataArchived": false,
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsCurrentUserQueries": true,
  "supportsFullTextSearch": true,
  "fullTextSearchCapabilities": {
   "supportsSearchOperator": true,
   "supportsOperator": false,
   "supportsSqlExpressionInFullText": true
  },
  "fullTextSearchableFields": [],
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsReturningGeometryEnvelope": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true,
  "supportsQueryWithCacheHint": false
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": true,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportedApplyEditsUploadIDFormats": "JSON,PBF"
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "BuildingName",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "PlumbingType",
   "type": "esriFieldTypeString",
   "alias": "PumpType",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": "CIRCPUMP",
   "modelName": "PumpType"
  },
  {
   "name": "LastServiceDate",
   "type": "esriFieldTypeDate",
   "alias": "LastServiceDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "LastServiceDate"
  },
  {
   "name": "BuildingName",
   "type": "esriFieldTypeString",
   "alias": "BuildingName",
   "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"
     },
     {
      "name": "Fire Station #11",
      "code": "FS-11"
     },
     {
      "name": "Suffolk Central Library",
      "code": "SCL"
     },
     {
      "name": "Suffolk Western Tidewater Shelter",
      "code": "SWTS"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BuildingName"
  },
  {
   "name": "Address",
   "type": "esriFieldTypeString",
   "alias": "Address",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Address"
  },
  {
   "name": "Location",
   "type": "esriFieldTypeString",
   "alias": "Location",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 250,
   "defaultValue": null,
   "modelName": "Location"
  },
  {
   "name": "Manufacturer",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Manufacturer"
  },
  {
   "name": "ModelNumber",
   "type": "esriFieldTypeString",
   "alias": "ModelNumber",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ModelNumber"
  },
  {
   "name": "SerialNumber",
   "type": "esriFieldTypeString",
   "alias": "SerialNumber",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SerialNumber"
  },
  {
   "name": "InstallDate",
   "type": "esriFieldTypeDate",
   "alias": "InstallDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "InstallDate"
  },
  {
   "name": "WarrantyDate",
   "type": "esriFieldTypeDate",
   "alias": "WarrantyDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "WarrantyDate"
  },
  {
   "name": "InspectionDate",
   "type": "esriFieldTypeDate",
   "alias": "InspectionDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "InspectionDate"
  },
  {
   "name": "Condition",
   "type": "esriFieldTypeString",
   "alias": "Condition",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "Condition"
  },
  {
   "name": "ConditionDate",
   "type": "esriFieldTypeDate",
   "alias": "ConditionDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "ConditionDate"
  },
  {
   "name": "AssetID",
   "type": "esriFieldTypeString",
   "alias": "Asset ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "AssetID"
  },
  {
   "name": "ParentID",
   "type": "esriFieldTypeString",
   "alias": "Building Relate ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "ParentID"
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "created_user"
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "created_date"
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "last_edited_user"
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "last_edited_date"
  }
 ],
 "indexes": [
  {
   "name": "R1025_SDE_ROWID_UK",
   "isAscending": true,
   "isUnique": true,
   "description": "",
   "fields": "OBJECTID"
  },
  {
   "name": "G5010BuildingNam",
   "isAscending": true,
   "isUnique": false,
   "description": "",
   "fields": "BuildingName"
  },
  {
   "name": "G5010ParentID",
   "isAscending": true,
   "isUnique": false,
   "description": "",
   "fields": "ParentID"
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "timeZoneIANA": "Etc/UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Capital_Programs_Plumbing",
   "description": "",
   "prototype": {
    "attributes": {
     "ParentID": null,
     "PlumbingType": "CIRCPUMP",
     "LastServiceDate": null,
     "BuildingName": null,
     "Address": null,
     "Location": null,
     "Manufacturer": null,
     "ModelNumber": null,
     "SerialNumber": null,
     "InstallDate": null,
     "WarrantyDate": null,
     "InspectionDate": null,
     "Condition": null,
     "ConditionDate": null,
     "AssetID": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
 "capabilities": "Query",
 "useStandardizedQueries": true,
 "bigIntegerRestrictedTo53Bits": true,
 "supportsAppend": true,
 "supportedAppendFormats": "FILEGDB,PBF",
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "d3bcbfae258e4ba8a2b422a00215aafd"
}