{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 11,
"name": "GIS.GISADMIN.WMOTOR",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "ET_CREATED",
"creatorField": "ET_CREATOR",
"editDateField": "ET_EDITED",
"editorField": "ET_EDITOR"
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": true,
"relationships": [],
"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,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true
},
"hasMetadata": false,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "EquipmentID",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "EquipmentID",
"type": "esriFieldTypeString",
"alias": "Equipment ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "EquipmentID"
},
{
"name": "InstallDate",
"type": "esriFieldTypeDate",
"alias": "Install Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "InstallDate"
},
{
"name": "Manufacturer",
"type": "esriFieldTypeString",
"alias": "MANUFACTURER",
"domain": {
"type": "codedValue",
"name": "d_wMfg",
"description": "Water Manufacturer",
"codedValues": [
{
"name": "John Smith",
"code": "JS"
},
{
"name": "McManus",
"code": "MC"
},
{
"name": "John Foundry",
"code": "JF"
},
{
"name": "Other",
"code": "OTH"
},
{
"name": "Unknown",
"code": "UNK"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 5,
"defaultValue": null,
"modelName": "MANUFACTURER"
},
{
"name": "SerialNumber",
"type": "esriFieldTypeString",
"alias": "Serial Number",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "SerialNumber"
},
{
"name": "LifecycleStatus",
"type": "esriFieldTypeString",
"alias": "Lifecycle Status",
"domain": {
"type": "codedValue",
"name": "d_ConstructionStatus",
"description": "Construction Status",
"codedValues": [
{
"name": "Sold",
"code": "SOLD"
},
{
"name": "Abandoned",
"code": "ABN"
},
{
"name": "Active",
"code": "ACT"
},
{
"name": "Proposed",
"code": "PROP"
},
{
"name": "Purchased",
"code": "PURC"
},
{
"name": "Removed",
"code": "REM"
},
{
"name": "Retired",
"code": "RET"
},
{
"name": "Staked",
"code": "STKD"
},
{
"name": "Temporary",
"code": "TEMP"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 5,
"defaultValue": "ACT",
"modelName": "LifecycleStatus"
},
{
"name": "CaptureSource",
"type": "esriFieldTypeString",
"alias": "CAPTURESOURCE",
"domain": {
"type": "codedValue",
"name": "d_CaptureSource",
"description": "Feature Capture Source",
"codedValues": [
{
"name": "As-Built",
"code": "AB"
},
{
"name": "Consultant",
"code": "CON"
},
{
"name": "Other",
"code": "OTH"
},
{
"name": "Unknown",
"code": "UNK"
},
{
"name": "Department",
"code": "DEPT"
},
{
"name": "Geocode Location",
"code": "GEOCODE"
},
{
"name": "GPS Collection with GeoXT",
"code": "GPS"
},
{
"name": "Manual Using Ortho Reference",
"code": "ORTHO"
},
{
"name": "Manual Using Pictometry Reference",
"code": "PICTOMETRY"
},
{
"name": "Manual Using Vector Reference",
"code": "VECTOR"
},
{
"name": "GPS Collection Using VRS",
"code": "VRS"
},
{
"name": "Laser",
"code": "LASER"
},
{
"name": "Survey",
"code": "SURVEY"
},
{
"name": "Plan",
"code": "P"
},
{
"name": "Site Plan",
"code": "SP"
},
{
"name": "Video",
"code": "VIDEO"
},
{
"name": "CAD",
"code": "CAD"
},
{
"name": "Plot Plan",
"code": "PLOT"
},
{
"name": "Fire Inspection",
"code": "FIRE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": "DEPT",
"modelName": "CAPTURESOURCE"
},
{
"name": "AveragePowerUsage",
"type": "esriFieldTypeString",
"alias": "Average Power Usage",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "AveragePowerUsage"
},
{
"name": "PeakPowerUsage",
"type": "esriFieldTypeString",
"alias": "Peak Power Usage",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "PeakPowerUsage"
},
{
"name": "RatedPower",
"type": "esriFieldTypeString",
"alias": "Rated Power",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "RatedPower"
},
{
"name": "VariableSpeed",
"type": "esriFieldTypeString",
"alias": "Variable Speed",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "VariableSpeed"
},
{
"name": "Voltage",
"type": "esriFieldTypeDouble",
"alias": "Voltage",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Voltage"
},
{
"name": "NetworkStructureObjectID",
"type": "esriFieldTypeInteger",
"alias": "Network Structure ObjectID",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "NetworkStructureObjectID"
},
{
"name": "OLDFID",
"type": "esriFieldTypeString",
"alias": "Old Facility ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "OLDFID"
},
{
"name": "FeatureID",
"type": "esriFieldTypeString",
"alias": "Feature ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "FeatureID"
},
{
"name": "Model",
"type": "esriFieldTypeString",
"alias": "Model",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "Model"
},
{
"name": "SourceDocument",
"type": "esriFieldTypeString",
"alias": "SourceDocument",
"domain": null,
"editable": true,
"nullable": true,
"length": 15,
"defaultValue": null,
"modelName": "SourceDocument"
},
{
"name": "Phases",
"type": "esriFieldTypeString",
"alias": "Phases",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "Phases"
},
{
"name": "RPM",
"type": "esriFieldTypeInteger",
"alias": "RPM",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "RPM"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
},
{
"name": "AssetID",
"type": "esriFieldTypeString",
"alias": "AssetID",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "AssetID"
},
{
"name": "ET_CREATOR",
"type": "esriFieldTypeString",
"alias": "ET_CREATOR",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "ET_CREATOR"
},
{
"name": "ET_CREATED",
"type": "esriFieldTypeDate",
"alias": "ET_CREATED",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "ET_CREATED"
},
{
"name": "ET_EDITOR",
"type": "esriFieldTypeString",
"alias": "ET_EDITOR",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "ET_EDITOR"
},
{
"name": "ET_EDITED",
"type": "esriFieldTypeDate",
"alias": "ET_EDITED",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "ET_EDITED"
},
{
"name": "REL_GlobalID",
"type": "esriFieldTypeGUID",
"alias": "REL_GlobalID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "REL_GlobalID"
}
],
"indexes": [
{
"name": "R171_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_171",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G645FeatureID",
"fields": "FeatureID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G645EquipmentID",
"fields": "EquipmentID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "UUID_OID_171",
"fields": "GlobalID,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "GDB_645_AssetID",
"fields": "AssetID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "GIS.GISADMIN.WMOTOR",
"description": "",
"prototype": {
"attributes": {
"REL_GlobalID": null,
"AssetID": null,
"EquipmentID": null,
"InstallDate": null,
"Manufacturer": null,
"SerialNumber": null,
"LifecycleStatus": "ACT",
"CaptureSource": "DEPT",
"AveragePowerUsage": null,
"PeakPowerUsage": null,
"RatedPower": null,
"VariableSpeed": null,
"Voltage": null,
"NetworkStructureObjectID": null,
"OLDFID": null,
"FeatureID": null,
"Model": null,
"SourceDocument": null,
"Phases": null,
"RPM": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 10000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing",
"useStandardizedQueries": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 10000,
"maxRecordCountFactor": 1
}