{
"currentVersion": 10.81,
"id": 229,
"name": "tp_Subprocess",
"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": 74,
"name": "tp_GroundingGrid",
"relatedTableId": 13,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 83,
"name": "tp_Greenspace",
"relatedTableId": 16,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 72,
"name": "tp_NetworkCabling",
"relatedTableId": 11,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 66,
"name": "YardLighting",
"relatedTableId": 9,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 81,
"name": "tp_Hardscape",
"relatedTableId": 15,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 73,
"name": "tp_YardElectrical",
"relatedTableId": 12,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 71,
"name": "tp_AccessGate",
"relatedTableId": 10,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 79,
"name": "stp_Tank",
"relatedTableId": 45,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 65,
"name": "stp_Generator",
"relatedTableId": 43,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 67,
"name": "stp_PumpStation",
"relatedTableId": 132,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 68,
"name": "stp_Well",
"relatedTableId": 49,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 84,
"name": "stp_Basin",
"relatedTableId": 47,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 70,
"name": "stp_YardPiping",
"relatedTableId": 50,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 69,
"name": "stp_YardValve",
"relatedTableId": 51,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 63,
"name": "tp_PointsOfInterest",
"relatedTableId": 127,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "SUBPROCESS_ID",
"composite": false
},
{
"id": 86,
"name": "tp_Process",
"relatedTableId": 225,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "PROCESS_ID",
"composite": false
}
],
"isDataVersioned": false,
"isDataArchived": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true
},
"hasAttachments": true,
"supportsAttachmentsByUploadId": true,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "SUBPROCESS_NAME",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "SUBPROCESS_ID",
"type": "esriFieldTypeString",
"alias": "Subprocess ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "SUBPROCESS_ID"
},
{
"name": "SUBPROCESS_NAME",
"type": "esriFieldTypeString",
"alias": "Subprocess Name",
"domain": {
"type": "codedValue",
"name": "tp_Subprocess_Name",
"description": "Subprocess Name",
"codedValues": [
{
"name": "Screening",
"code": "SCREENING"
},
{
"name": "Pumping",
"code": "PUMPING"
},
{
"name": "Grit Removal",
"code": "GRITREMOVAL"
},
{
"name": "Scum Collection",
"code": "SCUMCOLLECT"
},
{
"name": "Clarification",
"code": "CLARIFICATION"
},
{
"name": "Air Supply",
"code": "AIRSUPPLY"
},
{
"name": "Difffusion",
"code": "DIFFUSION"
},
{
"name": "Return Activated Sludge",
"code": "RETACTSLUDGE"
},
{
"name": "Waste Activated Sludge",
"code": "WASTEACTSLUDGE"
},
{
"name": "Effluent",
"code": "EFFLUENT"
},
{
"name": "Secondary Effluent",
"code": "SECEFFLUENT"
},
{
"name": "Agricultural Water",
"code": "AGWATER"
},
{
"name": "Storage",
"code": "STORAGE"
},
{
"name": "Filtration",
"code": "FILTRATION"
},
{
"name": "Disinfection",
"code": "DISINFECTION"
},
{
"name": "Chlorination",
"code": "CHLORINATION"
},
{
"name": "Neutralization",
"code": "NEUTRALIZATION"
},
{
"name": "Primary Digestion",
"code": "PRIMDIGESTION"
},
{
"name": "Secondary Digestion",
"code": "SECDIGESTION"
},
{
"name": "Sludge Thickening",
"code": "SLUDGETHICK"
},
{
"name": "Dewatering",
"code": "DEWATER"
},
{
"name": "Piping",
"code": "PIPING"
},
{
"name": "Coagulation",
"code": "COAGULATION"
},
{
"name": "Flocculation",
"code": "FLOCCULATION"
},
{
"name": "Feed",
"code": "FEED"
},
{
"name": "Clean In Place (CIP)",
"code": "CIP"
},
{
"name": "Backwash",
"code": "BACKWASH"
},
{
"name": "Reverse Osmosis",
"code": "REVOSMOSIS"
},
{
"name": "Odor Collection",
"code": "ODORCOLLECT"
},
{
"name": "Nutrient Feed System",
"code": "NUTFEEDSYS"
},
{
"name": "Air Scrubbing",
"code": "AIRSCRUBBING"
},
{
"name": "Pressure Reduction",
"code": "PRESSREDUCTION"
},
{
"name": "Security Access Control",
"code": "SECACCESSCNTRL"
},
{
"name": "HVAC",
"code": "HVAC"
},
{
"name": "Plumbing",
"code": "PLUMBING"
},
{
"name": "Building Electrical",
"code": "BLDGELECTRICAL"
},
{
"name": "Building Structural Maintenance",
"code": "BLDGSTRUCTMAINT"
},
{
"name": "Generation",
"code": "GENERATION"
},
{
"name": "Transfer",
"code": "TRANSFER"
},
{
"name": "Distribution",
"code": "DISTRIBUTION"
},
{
"name": "Grounding/Lightning Protection",
"code": "GRNDLIGHTPROTECT"
},
{
"name": "Fire Suppression",
"code": "FIRESUPPRESS"
},
{
"name": "Personal Protection",
"code": "PERSONALPROTECT"
},
{
"name": "Fire Alarm",
"code": "FIREALARM"
},
{
"name": "Recycle Water Chlorination",
"code": "DECHLORINATION"
},
{
"name": "Brine",
"code": "BRINE"
},
{
"name": "Sodium Hypochlorite",
"code": "SODIUM_HYPOCHLORITE"
},
{
"name": "Ferric",
"code": "FERRIC"
},
{
"name": "Coagulant",
"code": "COAGULANT"
},
{
"name": "Polymer",
"code": "POLYMER"
},
{
"name": "Supervisory Control and Data Acquisition",
"code": "SCADA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "SUBPROCESS_NAME"
},
{
"name": "PROCESS_ID",
"type": "esriFieldTypeString",
"alias": "Process ID (Relate)",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "PROCESS_ID"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
},
{
"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"
},
{
"name": "LASTEDITOR",
"type": "esriFieldTypeString",
"alias": "LASTEDITOR",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "LASTEDITOR"
},
{
"name": "LASTUPDATE",
"type": "esriFieldTypeDate",
"alias": "LASTUPDATE",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "LASTUPDATE"
},
{
"name": "ASSETSTATUS",
"type": "esriFieldTypeString",
"alias": "ASSETSTATUS",
"domain": {
"type": "codedValue",
"name": "AssetStatus",
"description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).",
"codedValues": [
{
"name": "Current",
"code": "C"
},
{
"name": "Retired",
"code": "R"
},
{
"name": "Abandoned",
"code": "A"
},
{
"name": "Geometric Network Only",
"code": "G"
},
{
"name": "Proposed",
"code": "P"
},
{
"name": "Needs Review",
"code": "N"
},
{
"name": "to Delete",
"code": "D"
},
{
"name": "Transposed",
"code": "T"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 1,
"defaultValue": "C",
"modelName": "ASSETSTATUS"
}
],
"indexes": [
{
"name": "R706_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_706",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G2908PROCESS_ID",
"fields": "PROCESS_ID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G2908SUBPROCESS_",
"fields": "SUBPROCESS_ID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"types": [],
"templates": [
{
"name": "tp_Subprocess",
"description": "",
"prototype": {
"attributes": {
"LASTUPDATE": null,
"LASTEDITOR": null,
"SUBPROCESS_ID": null,
"SUBPROCESS_NAME": null,
"PROCESS_ID": null,
"ASSETSTATUS": "C"
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON",
"capabilities": "Query",
"useStandardizedQueries": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1,
"serviceItemId": "6aa3f52844c748d88820036a76e0ab74"
}