{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "SanitaryLiftStations", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 500000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "ssLiftStationPump", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{9E4332A8-6118-4EFD-9010-361E6CC23104}" }, { "id": 1, "name": "ssLiftStationOdorControlFilter", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{0425B998-237C-49E8-AA1E-2F20B317B0BA}" }, { "id": 2, "name": "ssLiftStationGenReceptacle", "relatedTableId": 16, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{E8FABCE1-2349-4065-996B-809E10D7DC80}" }, { "id": 3, "name": "ssLiftStationFlowMeter", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{D7B5F736-1DD2-4955-BAFB-D6900B176371}" }, { "id": 4, "name": "ssLiftStationRTU", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{2A2EB810-0C8A-4CCD-8D7B-DE4050AB7813}" }, { "id": 5, "name": "ssLiftStationControlPanel", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{B0547ED7-6E67-4B9F-B25D-5ED5499A6775}" }, { "id": 6, "name": "ssLiftStationHVAC", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{E32B4692-504E-4A47-AEDC-6F693B1FEA0F}" }, { "id": 7, "name": "ssLiftStationGenerator", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{FE6C8C14-46F3-40AF-B2F3-C5BDE326430F}" }, { "id": 8, "name": "ssLiftStationOdorControlPump", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{2A12C430-2C03-4FF4-A70B-FFA1591E693B}" }, { "id": 9, "name": "ssLiftStationValves", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{C9ACA1EE-9831-4E3A-B5D4-AB156D1D891B}" }, { "id": 10, "name": "ssLiftStationOdorControlTank", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{9AE16A20-9B7F-4B0A-98AE-BE3AFE1ABEA1}" }, { "id": 11, "name": "ssLiftStationStructure", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{3A0E6ADC-202A-4DF1-9D3D-030E2B51BBC0}" }, { "id": 12, "name": "ssLiftStationWetDryWell", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{8C62BE15-F9A5-4554-9A07-6FCD82B4CF81}" }, { "id": 13, "name": "ssLiftStationUnitHeater", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{0B433858-B3B3-4FAE-A13C-409151A897BC}" }, { "id": 14, "name": "ssLiftStationTransferSwitch", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{5631422B-A3EA-4308-A337-88EA117A1F90}" }, { "id": 15, "name": "ssLiftStationOverheadHoist", "relatedTableId": 18, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{0C93F874-3B36-4593-96DA-5DF60C9D0959}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -1.0788786561216032E7, "ymin": 5888849.226719654, "xmax": -1.0771643582211569E7, "ymax": 5942677.278255591, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkt2": "COMPOUNDCRS[\"\",PROJCRS[\"Fargo_Ground_Coordinate_System\",BASEGEOGCRS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",ELLIPSOID[\"GRS_1980\",6378137.0,298.257222101,LENGTHUNIT[\"Meter\",1.0]]],PRIMEM[\"Greenwich\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],CS[ellipsoidal,2],ANGLEUNIT[\"Degree\",0.0174532925199433]],CONVERSION[\"Rectified_Skew_Orthomorphic_Natural_Origin\",METHOD[\"Rectified_Skew_Orthomorphic_Natural_Origin\"],PARAMETER[\"False_Easting\",2869344.93,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"False_Northing\",-16657672.6488,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"Scale_Factor\",1.000038773618,SCALEUNIT[\"Unity\",1.0]],PARAMETER[\"Azimuth\",2.63389226,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Longitude_Of_Center\",-96.88886388888889,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Latitude_Of_Center\",46.99163611111111,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"XY_Plane_Rotation\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]]],CS[Cartesian,2],AXIS[\"Easting (X)\",east,ORDER[1]],AXIS[\"Northing (Y)\",north,ORDER[2]],LENGTHUNIT[\"Foot_US\",0.3048006096012192]],VERTCRS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],CS[vertical,1],AXIS[\"Gravity-related height (H)\",up,LENGTHUNIT[\"Meter\",1.0]]]]", "wkt": "PROJCS[\"Fargo_Ground_Coordinate_System\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Rectified_Skew_Orthomorphic_Natural_Origin\"],PARAMETER[\"False_Easting\",2869344.93],PARAMETER[\"False_Northing\",-16657672.6488],PARAMETER[\"Scale_Factor\",1.000038773618],PARAMETER[\"Azimuth\",2.63389226],PARAMETER[\"Longitude_Of_Center\",-96.88886388888889],PARAMETER[\"Latitude_Of_Center\",46.99163611111111],PARAMETER[\"XY_Plane_Rotation\",0.0],UNIT[\"Foot_US\",0.3048006096012192]],VERTCS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],PARAMETER[\"Vertical_Shift\",0.0],PARAMETER[\"Direction\",1.0],UNIT[\"Meter\",1.0]]", "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -100234300, "falseY": -82178900, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "d0986e536676d8712884e320ba141790", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAnklEQVQ4jWNhoBJgGdwGiToxHBAyZfhGjMZ3pxn+v97H4I3VIEkvBmW5KAYZYgx6uIDhyut9OFyEDA46MzD8+czAoJzJwKCQSNhgnAZ9f8rA8OcTA8Pvj8Mi1oaGQbcnMjDcnYHgm8xhYBCxIcOgfz8hGAb+/ybRRR43CFmBx6D3Zxk4WbgZiAIfrzDw4jTo8XIGkcfLiTMIHQy+6AcARwEn7pEYdwoAAAAASUVORK5CYII=", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "LiftStationNumber", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "OriginalProjectNumber", "type": "esriFieldTypeString", "alias": "OriginalProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "OriginalProjectNumber" }, { "name": "YearInstalled", "type": "esriFieldTypeString", "alias": "YearInstalled", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "YearInstalled" }, { "name": "ImprovementProjectNumber", "type": "esriFieldTypeString", "alias": "ImprovementProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "ImprovementProjectNumber" }, { "name": "YearImproved", "type": "esriFieldTypeString", "alias": "YearImproved", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "YearImproved" }, { "name": "ProjectRetired", "type": "esriFieldTypeString", "alias": "ProjectRetired", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectRetired" }, { "name": "YearRetired", "type": "esriFieldTypeString", "alias": "YearRetired", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "YearRetired" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "NumberOfPumps", "type": "esriFieldTypeString", "alias": "NumberOfPumps", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "NumberOfPumps" }, { "name": "SizeOfPumps", "type": "esriFieldTypeString", "alias": "SizeOfPumps", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SizeOfPumps" }, { "name": "TypeOfPumps", "type": "esriFieldTypeString", "alias": "TypeOfPumps", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "TypeOfPumps" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "GallonsPerMinute", "type": "esriFieldTypeString", "alias": "GallonsPerMinute", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "GallonsPerMinute" }, { "name": "HP", "type": "esriFieldTypeString", "alias": "HP", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "HP" }, { "name": "RPM", "type": "esriFieldTypeString", "alias": "RPM", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "RPM" }, { "name": "Volts", "type": "esriFieldTypeString", "alias": "Volts", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "Volts" }, { "name": "Building", "type": "esriFieldTypeString", "alias": "Building", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "Building" }, { "name": "Power", "type": "esriFieldTypeString", "alias": "Power", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Power" }, { "name": "GenKW", "type": "esriFieldTypeString", "alias": "GenKW", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "GenKW" }, { "name": "Head", "type": "esriFieldTypeString", "alias": "Head", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Head" }, { "name": "InsuranceNumbers", "type": "esriFieldTypeString", "alias": "InsuranceNumbers", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "InsuranceNumbers" }, { "name": "InsuranceLimit", "type": "esriFieldTypeString", "alias": "InsuranceLimit", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "InsuranceLimit" }, { "name": "InterceptorArea", "type": "esriFieldTypeString", "alias": "InterceptorArea\n", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "InterceptorArea" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure\n", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure\n", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation\n", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk\n", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife\n", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost\n", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate\n", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "LiftStationArea", "type": "esriFieldTypeString", "alias": "LiftStationArea", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationArea" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID\n", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "Jurisdiction", "type": "esriFieldTypeString", "alias": "Jurisdiction", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Jurisdiction" }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "X", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "X" }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "Y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Y" }, { "name": "Private", "type": "esriFieldTypeString", "alias": "Private", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Private" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R130_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I237Location", "fields": "Location", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I237LiftStationN", "fields": "LiftStationNumber", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G237Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G237Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S34_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SanitaryLiftStations", "description": "", "prototype": { "attributes": { "Jurisdiction": null, "Y": null, "X": null, "Private": null, "LiftStationNumber": null, "Comments": null, "OriginalProjectNumber": null, "YearInstalled": null, "ImprovementProjectNumber": null, "YearImproved": null, "ProjectRetired": null, "YearRetired": null, "Material": null, "NumberOfPumps": null, "SizeOfPumps": null, "TypeOfPumps": null, "Manufacturer": null, "GallonsPerMinute": null, "HP": null, "RPM": null, "Volts": null, "Building": null, "Power": null, "GenKW": null, "Head": null, "InsuranceNumbers": null, "InsuranceLimit": null, "InterceptorArea": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "ReplacementCost": null, "CostingDate": null, "LiftStationArea": null, "Location": null, "Status": null, "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "FargoLiftStation.DBO.ssLiftStationControlPanel", "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": 5, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{B0547ED7-6E67-4B9F-B25D-5ED5499A6775}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ControlPanelName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "Lift Station Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Voltage", "type": "esriFieldTypeDouble", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "Phase", "type": "esriFieldTypeDouble", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "Frequency", "type": "esriFieldTypeDouble", "alias": "Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Frequency" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "General Contractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "USBManufacture", "type": "esriFieldTypeString", "alias": "USB Manufacture (May be with RTU)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USBManufacturer" }, { "name": "USBInstallationDate", "type": "esriFieldTypeDate", "alias": "USB Installation Date (May be with RTU)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "USBInstallationDate" }, { "name": "USBModel", "type": "esriFieldTypeString", "alias": "USB Model Number (May be with RTU)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USBModel" }, { "name": "USBSerialNumber", "type": "esriFieldTypeString", "alias": "USB Serial Number (May be with RTU)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USBSerialNumber" }, { "name": "MemoryBatteryManufacture", "type": "esriFieldTypeString", "alias": "Memory Battery Manufacture (May be with RTU)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MemoryBatteryManufacturer" }, { "name": "MemoryBatteryModel", "type": "esriFieldTypeString", "alias": "Memory Battery Model Number (May be with RTU)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MemoryBatteryModel" }, { "name": "MemoryBatterySerialNumber", "type": "esriFieldTypeString", "alias": "Memory Battery Serial Number (May be with RTU)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MemoryBatterySerialNumber" }, { "name": "MemoryBatteryInstallationDate", "type": "esriFieldTypeDate", "alias": "Installation Date of Memory Battery (May be with RTU)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MemoryBatteryInstallationDate" }, { "name": "USB_Battery", "type": "esriFieldTypeString", "alias": "USB Battery", "domain": { "type": "codedValue", "name": "YesNo_4", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "USB_Battery" }, { "name": "MemoryBattery", "type": "esriFieldTypeString", "alias": "Memory Battery", "domain": { "type": "codedValue", "name": "YesNo_4", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MemoryBattery" }, { "name": "MainBreakerManufacture", "type": "esriFieldTypeString", "alias": "Main Breaker Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MainBreakerManufacture" }, { "name": "PumpBreakerManufacture", "type": "esriFieldTypeString", "alias": "Pump Breaker Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PumpBreakerManufacture" }, { "name": "GeneratorBreakerManufacture", "type": "esriFieldTypeString", "alias": "Generator Breakder Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneratorBreakerManufacture" }, { "name": "ControlPanelName", "type": "esriFieldTypeString", "alias": "ControlPanelName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ControlPanelName" }, { "name": "MainBreakerSize", "type": "esriFieldTypeDouble", "alias": "Main Breaker Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MainBreakerSize" }, { "name": "PumpBreakerSize", "type": "esriFieldTypeDouble", "alias": "Pump Breaker Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PumpBreakerSize" }, { "name": "GeneratorBreakerSize", "type": "esriFieldTypeDouble", "alias": "Generator Breaker Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GeneratorBreakerSize" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LiftStationLocation" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R74_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G179Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I179Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationControlPanel", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Type": null, "ReplacementCost": null, "CostingDate": null, "Voltage": null, "Phase": null, "Frequency": null, "Manufacture": null, "Model": null, "SerialNumber": null, "GeneralContractor": null, "EngProjectNumber": null, "USBManufacture": null, "USBInstallationDate": null, "USBModel": null, "USBSerialNumber": null, "MemoryBatteryManufacture": null, "MemoryBatteryModel": null, "MemoryBatterySerialNumber": null, "MemoryBatteryInstallationDate": null, "USB_Battery": null, "MemoryBattery": null, "MainBreakerManufacture": null, "PumpBreakerManufacture": null, "GeneratorBreakerManufacture": null, "ControlPanelName": null, "MainBreakerSize": null, "PumpBreakerSize": null, "GeneratorBreakerSize": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "FargoLiftStation.DBO.ssLiftStationGenerator", "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": 7, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{FE6C8C14-46F3-40AF-B2F3-C5BDE326430F}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "GeneratorName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "kWkVARating", "type": "esriFieldTypeDouble", "alias": "kW/kVA Rating", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Horsepower" }, { "name": "Voltage", "type": "esriFieldTypeDouble", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "Phase", "type": "esriFieldTypeDouble", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "EngProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "FuelType", "type": "esriFieldTypeString", "alias": "FuelType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FuelType" }, { "name": "FuelCapacity", "type": "esriFieldTypeDouble", "alias": "FuelCapacity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FuelCapacity" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "Dealer", "type": "esriFieldTypeString", "alias": "Dealer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Dealer" }, { "name": "GeneratorName", "type": "esriFieldTypeString", "alias": "Generator", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneratorName" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R76_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I181Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationGenerator", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "kWkVARating": null, "Voltage": null, "Phase": null, "Manufacture": null, "Model": null, "SerialNumber": null, "EngProjectNumber": null, "FuelType": null, "FuelCapacity": null, "GeneralContractor": null, "Dealer": null, "GeneratorName": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "FargoLiftStation.DBO.ssLiftStationHVAC", "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": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{E32B4692-504E-4A47-AEDC-6F693B1FEA0F}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "HVAC_Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Voltage", "type": "esriFieldTypeDouble", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "Phase", "type": "esriFieldTypeDouble", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "Frequency", "type": "esriFieldTypeDouble", "alias": "Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Frequency" }, { "name": "BTU", "type": "esriFieldTypeDouble", "alias": "BTU", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BTU" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "HVAC_Name", "type": "esriFieldTypeString", "alias": "HVAC_Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HVACName" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R78_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G183Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationHVAC", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "Voltage": null, "Phase": null, "Frequency": null, "BTU": null, "Manufacture": null, "Model": null, "SerialNumber": null, "GeneralContractor": null, "EngProjectNumber": null, "HVAC_Name": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "FargoLiftStation.DBO.ssLiftStationMotor", "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": 16, "name": "ssLiftStationPump", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{25801D83-A26B-42C6-AD38-82C35FB491F8}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PumpName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "PumpName", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PumpName" }, { "name": "MaximumCurrent", "type": "esriFieldTypeDouble", "alias": "Maximum Current", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaximumCurrent" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "General Contractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "MotorName", "type": "esriFieldTypeString", "alias": "MotorName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MotorName" }, { "name": "Speed_RPM", "type": "esriFieldTypeDouble", "alias": "Speed (RPM)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Speed_RPM" }, { "name": "Frequency", "type": "esriFieldTypeDouble", "alias": "Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Frequency" }, { "name": "Phase", "type": "esriFieldTypeDouble", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "Voltage", "type": "esriFieldTypeDouble", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "Horsepower", "type": "esriFieldTypeDouble", "alias": "Horsepower", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Horsepower" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R79_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G184Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationMotor", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "PumpName": null, "MaximumCurrent": null, "Manufacture": null, "Model": null, "SerialNumber": null, "GeneralContractor": null, "EngProjectNumber": null, "MotorName": null, "Speed_RPM": null, "Frequency": null, "Phase": null, "Voltage": null, "Horsepower": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "FargoLiftStation.DBO.ssLiftStationOdorControlFilter", "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": 1, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{0425B998-237C-49E8-AA1E-2F20B317B0BA}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "FilterName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "OdorControl", "description": "OdorControl", "codedValues": [ { "name": "Tank", "code": "Tank" }, { "name": "Filter", "code": "Filter" }, { "name": "Motor", "code": "Motor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "FilterName", "type": "esriFieldTypeString", "alias": "FilterName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FilterName" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R80_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G185Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationOdorControlFilter", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Type": null, "ReplacementCost": null, "CostingDate": null, "Manufacture": null, "Model": null, "SerialNumber": null, "GeneralContractor": null, "EngProjectNumber": null, "FilterName": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "FargoLiftStation.DBO.ssLiftStationOdorControlPump", "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": 8, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{2A12C430-2C03-4FF4-A70B-FFA1591E693B}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PumpName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "OdorControl", "description": "OdorControl", "codedValues": [ { "name": "Tank", "code": "Tank" }, { "name": "Filter", "code": "Filter" }, { "name": "Motor", "code": "Motor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Contents", "type": "esriFieldTypeString", "alias": "Contents", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Contents" }, { "name": "Capacity", "type": "esriFieldTypeDouble", "alias": "Capacity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Capacity" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "Horsepower", "type": "esriFieldTypeDouble", "alias": "Horsepower", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Horsepower" }, { "name": "Voltage", "type": "esriFieldTypeDouble", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "Phase", "type": "esriFieldTypeDouble", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "Frequency", "type": "esriFieldTypeDouble", "alias": "Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Frequency" }, { "name": "Speed", "type": "esriFieldTypeDouble", "alias": "Speed (RPM)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Speed" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "PumpName", "type": "esriFieldTypeString", "alias": "PumpName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PumpName" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R81_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G186Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationOdorControlPump", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Type": null, "ReplacementCost": null, "CostingDate": null, "Contents": null, "Capacity": null, "Manufacture": null, "Model": null, "SerialNumber": null, "GeneralContractor": null, "Horsepower": null, "Voltage": null, "Phase": null, "Frequency": null, "Speed": null, "EngProjectNumber": null, "PumpName": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "FargoLiftStation.DBO.ssLiftStationOdorControlTank", "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": 10, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{9AE16A20-9B7F-4B0A-98AE-BE3AFE1ABEA1}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "TankName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "OdorControl", "description": "OdorControl", "codedValues": [ { "name": "Tank", "code": "Tank" }, { "name": "Filter", "code": "Filter" }, { "name": "Motor", "code": "Motor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Contents", "type": "esriFieldTypeString", "alias": "Contents", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Contents" }, { "name": "Capacity", "type": "esriFieldTypeDouble", "alias": "Capacity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Capacity" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "TankName", "type": "esriFieldTypeString", "alias": "TankName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TankName" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R82_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G187Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationOdorControlTank", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Type": null, "ReplacementCost": null, "CostingDate": null, "Contents": null, "Capacity": null, "GeneralContractor": null, "EngProjectNumber": null, "TankName": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "FargoLiftStation.DBO.ssLiftStationPump", "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": 16, "name": "ssLiftStationMotor", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{25801D83-A26B-42C6-AD38-82C35FB491F8}" }, { "id": 0, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{9E4332A8-6118-4EFD-9010-361E6CC23104}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PumpName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "DischargeDiameter", "type": "esriFieldTypeDouble", "alias": "DischargeDiameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DischargeDiameter" }, { "name": "Horsepower", "type": "esriFieldTypeDouble", "alias": "Horsepower", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Horsepower" }, { "name": "Voltage", "type": "esriFieldTypeDouble", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "Phase", "type": "esriFieldTypeDouble", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "Frequency", "type": "esriFieldTypeDouble", "alias": "Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Frequency" }, { "name": "Speed", "type": "esriFieldTypeDouble", "alias": "Speed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Speed" }, { "name": "MaximumCurrent", "type": "esriFieldTypeDouble", "alias": "MaximumCurrent", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaximumCurrent" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "EngProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "PumpName", "type": "esriFieldTypeString", "alias": "PumpName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PumpName" }, { "name": "Capacity", "type": "esriFieldTypeDouble", "alias": "Capacity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Capacity" }, { "name": "TotalDynamicHead", "type": "esriFieldTypeDouble", "alias": "TotalDynamicHead", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalDynamicHead" }, { "name": "ImpellerType", "type": "esriFieldTypeString", "alias": "ImpellerType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ImpellerType" }, { "name": "MinimumSpherePassage", "type": "esriFieldTypeDouble", "alias": "MinimumSpherePassage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MinimumSpherePassage" }, { "name": "SuctionDiameter", "type": "esriFieldTypeDouble", "alias": "SuctionDiameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SuctionDiameter" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R84_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G189Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G189Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationPump", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "DischargeDiameter": null, "Horsepower": null, "Voltage": null, "Phase": null, "Frequency": null, "Speed": null, "MaximumCurrent": null, "Manufacture": null, "Model": null, "SerialNumber": null, "GeneralContractor": null, "EngProjectNumber": null, "PumpName": null, "Capacity": null, "TotalDynamicHead": null, "ImpellerType": null, "MinimumSpherePassage": null, "SuctionDiameter": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "FargoLiftStation.DBO.ssLiftStationRTU", "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": 4, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{2A2EB810-0C8A-4CCD-8D7B-DE4050AB7813}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "RTU_Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufactuer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "USBManufacture", "type": "esriFieldTypeString", "alias": "USB Manufacture (May be with Control Panel)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USBManufacturer" }, { "name": "USBInstallationDate", "type": "esriFieldTypeDate", "alias": "USB Installation Date (May be with Control Panel)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "USBInstallationDate" }, { "name": "USBModel", "type": "esriFieldTypeString", "alias": "USB Model Number (May be with Control Panel)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USBModel" }, { "name": "USBSerialNumber", "type": "esriFieldTypeString", "alias": "USB Serial Number (May be with Control Panel)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USBSerialNumber" }, { "name": "MemoryBatteryInstallationDate", "type": "esriFieldTypeDate", "alias": "Installation Date of Memory Battery (May be with Control Panel)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MemoryBatteryInstallationDate" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "General Contractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "USB_Battery", "type": "esriFieldTypeString", "alias": "USB_Battery", "domain": { "type": "codedValue", "name": "YesNo_4", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "USB_Battery" }, { "name": "MemoryBatteryModel", "type": "esriFieldTypeString", "alias": "Memory Battery Model Number (May be with Control Panel)", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MemoryBattery" }, { "name": "MemoryBatterySerialNumber", "type": "esriFieldTypeString", "alias": "Memory Battery Serial Number (May be with Control Panel)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MemoryBatterySerialNumber" }, { "name": "MemoryBatteryManufacture", "type": "esriFieldTypeString", "alias": "Memory Battery Manufacture (May be with Control Panel)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MemoryBatteryManufacture" }, { "name": "RTU_Name", "type": "esriFieldTypeString", "alias": "RTU_Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RTUName" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LiftStationLocation" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R85_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G190Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I190Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationRTU", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Type": null, "ReplacementCost": null, "CostingDate": null, "Manufacture": null, "Model": null, "SerialNumber": null, "USBManufacture": null, "USBInstallationDate": null, "USBModel": null, "USBSerialNumber": null, "MemoryBatteryInstallationDate": null, "GeneralContractor": null, "EngProjectNumber": null, "USB_Battery": null, "MemoryBatteryModel": null, "MemoryBatterySerialNumber": null, "MemoryBatteryManufacture": null, "RTU_Name": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "FargoLiftStation.DBO.ssLiftStationStructure", "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": 11, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{3A0E6ADC-202A-4DF1-9D3D-030E2B51BBC0}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "StructureName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "StructureType", "type": "esriFieldTypeString", "alias": "Structure Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Structure Type" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "EngProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "StructureName", "type": "esriFieldTypeString", "alias": "StructureName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StructureName" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "StructureName" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R86_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G191Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationStructure", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "StructureType": null, "GeneralContractor": null, "EngProjectNumber": null, "StructureName": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "FargoLiftStation.DBO.ssLiftStationTransferSwitch", "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": 14, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{5631422B-A3EA-4308-A337-88EA117A1F90}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "SwitchName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "Lift Station Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "ServicePointofContact", "type": "esriFieldTypeString", "alias": "Service Point of Contact", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ServicePointofContact" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "Voltage", "type": "esriFieldTypeSmallInteger", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "AmpRating", "type": "esriFieldTypeSmallInteger", "alias": "Amp Rating", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AmpRating" }, { "name": "TransistionType", "type": "esriFieldTypeString", "alias": "Transition Type (Open or Closed)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FuelType" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "General Contractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "ManufacturingDate", "type": "esriFieldTypeDate", "alias": "Manufacturing Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ManufacturingDate" }, { "name": "SwitchName", "type": "esriFieldTypeString", "alias": "SwitchName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SwitchName" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R87_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G192Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationTransferSwitch", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "ServicePointofContact": null, "Manufacture": null, "Model": null, "SerialNumber": null, "Voltage": null, "AmpRating": null, "TransistionType": null, "EngProjectNumber": null, "GeneralContractor": null, "ManufacturingDate": null, "SwitchName": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "FargoLiftStation.DBO.ssLiftStationValves", "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": 9, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{C9ACA1EE-9831-4E3A-B5D4-AB156D1D891B}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ValveName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Speed", "type": "esriFieldTypeDouble", "alias": "Speed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Speed" }, { "name": "MaximumCurrent", "type": "esriFieldTypeDouble", "alias": "MaximumCurrent", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaximumCurrent" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "EngProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "ValveName", "type": "esriFieldTypeString", "alias": "ValveName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ValveName" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "ValveType_1", "description": "ValveType", "codedValues": [ { "name": "Check", "code": "Check" }, { "name": "AirRelief", "code": "AirRelief" }, { "name": "Inlet", "code": "Inlet" }, { "name": "Discharge", "code": "Discharge" }, { "name": "Air/Vacuum", "code": "Air/Vacuum" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Type" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Size", "type": "esriFieldTypeDouble", "alias": "Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Size" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R89_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G194Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationValves", "description": "", "prototype": { "attributes": { "Comments": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "Speed": null, "MaximumCurrent": null, "Model": null, "SerialNumber": null, "GeneralContractor": null, "EngProjectNumber": null, "ValveName": null, "Type": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null, "OldParentID": null, "Manufacturer": null, "Size": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 14, "name": "FargoLiftStation.DBO.ssLiftStationWetDryWell", "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": 12, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{8C62BE15-F9A5-4554-9A07-6FCD82B4CF81}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "WetDryWellName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Diameter" }, { "name": "Depth", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Depth" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type of Wet Well", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Type" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "General Contractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "WetDryWellName", "type": "esriFieldTypeString", "alias": "WetDryWell", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WetDryWellName" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "ParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R90_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G195Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FargoLiftStation.DBO.ssLiftStationWetDryWell", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "Diameter": null, "Depth": null, "Type": null, "GeneralContractor": null, "EngProjectNumber": null, "WetDryWellName": null, "Location": null, "Status": "Active", "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 15, "name": "Cityworks_sde.DBO.ssLiftStationUnitHeater", "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": 13, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{0B433858-B3B3-4FAE-A13C-409151A897BC}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "HeaterName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "Voltage", "type": "esriFieldTypeDouble", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "kW_kVARating", "type": "esriFieldTypeString", "alias": "kW_kVARating", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "kW_kVARating" }, { "name": "Phase", "type": "esriFieldTypeString", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Phase" }, { "name": "Dealer", "type": "esriFieldTypeString", "alias": "Dealer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Dealer" }, { "name": "HeaterName", "type": "esriFieldTypeString", "alias": "HeaterName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HeaterName" }, { "name": "HeaterLocation", "type": "esriFieldTypeString", "alias": "HeaterLocation", "domain": { "type": "codedValue", "name": "HeaterLocation", "description": "Location of the Unit Heater", "codedValues": [ { "name": "Main Floor", "code": "Main Floor" }, { "name": "Basement", "code": "Basement" }, { "name": "Scrubber Room", "code": "Scrubber Room" }, { "name": "Generator Room/Enclosure", "code": "Generator Room/Eclosure" }, { "name": "Other", "code": "Other" }, { "name": "NW Mechanical Room", "code": "NW Mechanical Room" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HeaterLocation" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "Warranty", "type": "esriFieldTypeString", "alias": "Warranty", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Warranty" }, { "name": "LifeExpectancy", "type": "esriFieldTypeString", "alias": "LifeExpectancy", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LifeExpectancy" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "EngProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "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": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": false, "length": 38, "defaultValue": "{00000000-0000-0000-0000-000000000000}", "modelName": "GlobalID" }, { "name": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R88_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G193Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G193GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Cityworks_sde.DBO.ssLiftStationUnitHeater", "description": "", "prototype": { "attributes": { "GlobalID": "{00000000-0000-0000-0000-000000000000}", "OldParentID": null, "LiftStationNumber": null, "Voltage": null, "kW_kVARating": null, "Phase": null, "Dealer": null, "HeaterName": null, "HeaterLocation": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "Warranty": null, "LifeExpectancy": null, "EngProjectNumber": null, "GeneralContractor": null, "Location": null, "Comments": null, "Status": "Active", "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 16, "name": "Cityworks_sde.DBO.ssLiftStationGenReceptacle", "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": 2, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{E8FABCE1-2349-4065-996B-809E10D7DC80}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "DockName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Material" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Voltage", "type": "esriFieldTypeSmallInteger", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "Engineering Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "General Contractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Parent_ID" }, { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LiftStationNumber" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "ManufacturingDate", "type": "esriFieldTypeDate", "alias": "Manufacturing Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ManufacturingDate" }, { "name": "AmpRating", "type": "esriFieldTypeSmallInteger", "alias": "Amp Rating", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AmpRating" }, { "name": "DockName", "type": "esriFieldTypeString", "alias": "DockName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DockName" }, { "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": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R77_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G182Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Cityworks_sde.DBO.ssLiftStationGenReceptacle", "description": "", "prototype": { "attributes": { "DockName": null, "OldParentID": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "Material": null, "ReplacementCost": null, "CostingDate": null, "Asset_ID": null, "Status": "Active", "Voltage": null, "Manufacture": null, "Model": null, "SerialNumber": null, "EngProjectNumber": null, "GeneralContractor": null, "Parent_ID": null, "LiftStationNumber": null, "Location": null, "ManufacturingDate": null, "AmpRating": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 17, "name": "Cityworks_sde.DBO.ssLiftStationFlowMeter", "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": 3, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{D7B5F736-1DD2-4955-BAFB-D6900B176371}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Manufacturer", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "CALNumber", "type": "esriFieldTypeString", "alias": "CALNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CALNumber" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "TraceNumber", "type": "esriFieldTypeString", "alias": "TraceNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TraceNumber" }, { "name": "VoltageInput", "type": "esriFieldTypeString", "alias": "VoltageInput", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "VoltageInput" }, { "name": "VoltageOutput", "type": "esriFieldTypeString", "alias": "VoltageOutput", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "VoltageOutput" }, { "name": "CurrentInput", "type": "esriFieldTypeString", "alias": "CurrentInput", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CurrentInput" }, { "name": "CurrentOutput", "type": "esriFieldTypeString", "alias": "CurrentOutput", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CurrentOutput" }, { "name": "PowerInput", "type": "esriFieldTypeString", "alias": "PowerInput", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PowerInput" }, { "name": "PowerOutput", "type": "esriFieldTypeString", "alias": "PowerOutput", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PowerOutput" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Type" }, { "name": "Lighted", "type": "esriFieldTypeSmallInteger", "alias": "Lighted", "domain": { "type": "codedValue", "name": "YesNo", "description": "Populates Yes and No Values", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Lighted" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "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": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": false, "length": 38, "defaultValue": "{00000000-0000-0000-0000-000000000000}", "modelName": "GlobalID" }, { "name": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" }, { "name": "LiftStationNumber", "type": "esriFieldTypeString", "alias": "LiftStationNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LiftStationNumber" } ], "indexes": [ { "name": "R75_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G180GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G180Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Cityworks_sde.DBO.ssLiftStationFlowMeter", "description": "", "prototype": { "attributes": { "OldParentID": null, "LiftStationNumber": null, "Manufacturer": null, "Model": null, "CALNumber": null, "SerialNumber": null, "TraceNumber": null, "VoltageInput": null, "VoltageOutput": null, "CurrentInput": null, "CurrentOutput": null, "PowerInput": null, "PowerOutput": null, "Type": null, "Lighted": null, "Location": null, "Comments": null, "Status": "Active", "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "ReplacementCost": null, "CostingDate": null, "Asset_ID": null, "Parent_ID": null, "GlobalID": "{00000000-0000-0000-0000-000000000000}" } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 18, "name": "Cityworks_sde.DBO.ssLiftStationOverheadHoist", "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": 15, "name": "SanitaryLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_ID", "composite": false, "catalogID": "{0C93F874-3B36-4593-96DA-5DF60C9D0959}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Name" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "ProductDescription", "type": "esriFieldTypeString", "alias": "ProductDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProductDescription" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "HoistSerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "HoistHeightOfLift", "type": "esriFieldTypeString", "alias": "HoistHeightOfLift", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistHeightOfLift" }, { "name": "HoistLoad", "type": "esriFieldTypeString", "alias": "HoistLoad", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistLoad" }, { "name": "HoistDutyClass", "type": "esriFieldTypeString", "alias": "HoistDutyClass", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistDutyClass" }, { "name": "HoistLoadChainType", "type": "esriFieldTypeString", "alias": "HoistLoadChainType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistLoadChainType" }, { "name": "HoistReevingSystem", "type": "esriFieldTypeString", "alias": "HoistReevingSystem", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistReevingSystem" }, { "name": "HoistChainLength", "type": "esriFieldTypeString", "alias": "HoistChainLength", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistChainLength" }, { "name": "HoistChainSize", "type": "esriFieldTypeString", "alias": "HoistChainSize", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistChainSize" }, { "name": "HoistChainClass", "type": "esriFieldTypeString", "alias": "HoistChainClass", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistChainClass" }, { "name": "HoistChainGrade", "type": "esriFieldTypeString", "alias": "HoistChainGrade", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistChainGrade" }, { "name": "HoistChainMaxWorkLoad", "type": "esriFieldTypeString", "alias": "HoistChainMaxWorkLoad", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistChainMaxWorkLoad" }, { "name": "HoistChainBreakLoad", "type": "esriFieldTypeString", "alias": "HoistChainBreakLoad", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistChainBreakLoad" }, { "name": "HoistChainTotalBreakingElongati", "type": "esriFieldTypeString", "alias": "HoistChainTotalBreakingElongation", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistChainTotalBreakingElongation" }, { "name": "HoistingMachineryEDMax", "type": "esriFieldTypeString", "alias": "HoistingMachineryEDMax", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistingMachineryEDMax" }, { "name": "HoistingMachineryPower", "type": "esriFieldTypeString", "alias": "HoistingMachineryPower", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistingMachineryPower" }, { "name": "HoistingMachineryHoistingSpeed", "type": "esriFieldTypeString", "alias": "HoistingMachineryHoistingSpeed", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HoistingMachineryHoistingSpeed" }, { "name": "ControlsMainVoltage", "type": "esriFieldTypeString", "alias": "ContolsMainVoltage", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ControlsMainVoltage" }, { "name": "ControlsVoltage", "type": "esriFieldTypeString", "alias": "ControlsVoltage", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ControlsVoltage" }, { "name": "ControlsPhases", "type": "esriFieldTypeString", "alias": "ControlsPhases", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ControlsPhases" }, { "name": "ControlsFrequency", "type": "esriFieldTypeString", "alias": "ControlsFrequency", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ControlsFrequency" }, { "name": "ControlsPendantType", "type": "esriFieldTypeString", "alias": "ControlsPendantType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ControlsPendantType" }, { "name": "ControlsType", "type": "esriFieldTypeString", "alias": "ControlsControlType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ControlsType" }, { "name": "TrolleyType", "type": "esriFieldTypeString", "alias": "TrolleyType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TrolleyType" }, { "name": "Warranty", "type": "esriFieldTypeString", "alias": "Warranty", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Warranty" }, { "name": "LifeExpectancy", "type": "esriFieldTypeString", "alias": "LifeExpectancy", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LifeExpectancy" }, { "name": "ParentType", "type": "esriFieldTypeString", "alias": "ParentType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ParentType" }, { "name": "EngProjectNumber", "type": "esriFieldTypeString", "alias": "EngProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EngProjectNumber" }, { "name": "GeneralContractor", "type": "esriFieldTypeString", "alias": "GeneralContractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GeneralContractor" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Active", "modelName": "Status" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Parent_ID" }, { "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": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": false, "length": 38, "defaultValue": "{00000000-0000-0000-0000-000000000000}", "modelName": "GlobalID" }, { "name": "OldParentID", "type": "esriFieldTypeString", "alias": "OldParentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OldParentID" } ], "indexes": [ { "name": "R83_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G188Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G188GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Cityworks_sde.DBO.ssLiftStationOverheadHoist", "description": "", "prototype": { "attributes": { "GlobalID": "{00000000-0000-0000-0000-000000000000}", "OldParentID": null, "Name": null, "Manufacturer": null, "ProductDescription": null, "Model": null, "HoistSerialNumber": null, "HoistHeightOfLift": null, "HoistLoad": null, "HoistDutyClass": null, "HoistLoadChainType": null, "HoistReevingSystem": null, "HoistChainLength": null, "HoistChainSize": null, "HoistChainClass": null, "HoistChainGrade": null, "HoistChainMaxWorkLoad": null, "HoistChainBreakLoad": null, "HoistChainTotalBreakingElongati": null, "HoistingMachineryEDMax": null, "HoistingMachineryPower": null, "HoistingMachineryHoistingSpeed": null, "ControlsMainVoltage": null, "ControlsVoltage": null, "ControlsPhases": null, "ControlsFrequency": null, "ControlsPendantType": null, "ControlsType": null, "TrolleyType": null, "Warranty": null, "LifeExpectancy": null, "ParentType": null, "EngProjectNumber": null, "GeneralContractor": null, "Comments": null, "Status": "Active", "Location": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "ReplacementCost": null, "CostingDate": null, "Asset_ID": null, "Parent_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }