{
"currentVersion": 10.51,
"id": 34,
"name": "sGenerator",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "AssetID",
"typeIdField": "SubType",
"subtypeFieldName": "SubType",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "AssetID",
"type": "esriFieldTypeString",
"alias": "AssetID",
"length": 30,
"domain": null
},
{
"name": "LegacyID",
"type": "esriFieldTypeString",
"alias": "LegacyID",
"length": 30,
"domain": null
},
{
"name": "InstallDate",
"type": "esriFieldTypeDate",
"alias": "InstallDate",
"length": 8,
"domain": null
},
{
"name": "SubType",
"type": "esriFieldTypeInteger",
"alias": "SubType",
"domain": null
},
{
"name": "Status",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 20,
"domain": {
"type": "codedValue",
"name": "LifecycleStatus_2",
"codedValues": [
{
"name": "Abandoned",
"code": "Abandoned"
},
{
"name": "Active",
"code": "Active"
},
{
"name": "Inactive",
"code": "Inactive"
},
{
"name": "Proposed",
"code": "Proposed"
},
{
"name": "Removed",
"code": "Removed"
},
{
"name": "Under Construction",
"code": "Under Construction"
},
{
"name": "Active New",
"code": "ActiveNew"
},
{
"name": "Inactive New",
"code": "Inactive New"
},
{
"name": "Inquiry",
"code": "Inquiry"
},
{
"name": "CIP",
"code": "CapitalImprovementProject"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "WarrantyDate",
"type": "esriFieldTypeDate",
"alias": "WarrantyDate",
"length": 8,
"domain": null
},
{
"name": "Condition",
"type": "esriFieldTypeString",
"alias": "Condition",
"length": 10,
"domain": {
"type": "codedValue",
"name": "Condition_Text",
"codedValues": [
{
"name": "Excellent",
"code": "Excellent"
},
{
"name": "Good",
"code": "Good"
},
{
"name": "Fair",
"code": "Fair"
},
{
"name": "Poor",
"code": "Poor"
},
{
"name": "Out of Service",
"code": "Out of Service"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ConditionDate",
"type": "esriFieldTypeDate",
"alias": "ConditionDate",
"length": 8,
"domain": null
},
{
"name": "PrimaryImage",
"type": "esriFieldTypeString",
"alias": "PrimaryImage",
"length": 250,
"domain": null
},
{
"name": "Manufacturer",
"type": "esriFieldTypeString",
"alias": "Manufacturer",
"length": 30,
"domain": {
"type": "codedValue",
"name": "sGeneratorManuf_1",
"codedValues": [
{
"name": "All Power",
"code": "ALP"
},
{
"name": "Caterpillar",
"code": "CAT"
},
{
"name": "Cummins",
"code": "CUM"
},
{
"name": "Generac",
"code": "GEN"
},
{
"name": "Kato",
"code": "KATO"
},
{
"name": "Kohler",
"code": "KOH"
},
{
"name": "Marathon",
"code": "MAR"
},
{
"name": "Newage-Stamford",
"code": "NEWST"
},
{
"name": "Spectrum/Detroit-Diesel",
"code": "SPECDD"
},
{
"name": "U. S. Motors",
"code": "USM"
},
{
"name": "Other",
"code": "OTH"
},
{
"name": "Westinghouse",
"code": "WEST"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "Model",
"type": "esriFieldTypeString",
"alias": "Model",
"length": 30,
"domain": null
},
{
"name": "Serial",
"type": "esriFieldTypeString",
"alias": "Serial",
"length": 30,
"domain": null
},
{
"name": "Voltage",
"type": "esriFieldTypeInteger",
"alias": "Voltage",
"domain": {
"type": "range",
"name": "sVoltage",
"range": [
100,
500
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "KW",
"type": "esriFieldTypeInteger",
"alias": "KW",
"domain": {
"type": "range",
"name": "sKW",
"range": [
10,
2500
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "FuelCapacity",
"type": "esriFieldTypeInteger",
"alias": "FuelCapacity",
"domain": null
},
{
"name": "FuelType",
"type": "esriFieldTypeString",
"alias": "FuelType",
"length": 20,
"domain": {
"type": "codedValue",
"name": "sFuelType_1",
"codedValues": [
{
"name": "Diesel",
"code": "D"
},
{
"name": "Gasoline",
"code": "G"
},
{
"name": "Natural Gas",
"code": "N"
},
{
"name": "Propane",
"code": "P"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "DEVICE_UID",
"type": "esriFieldTypeString",
"alias": "DEVICE_UID",
"length": 30,
"domain": null
},
{
"name": "DEVICE_SID",
"type": "esriFieldTypeString",
"alias": "DEVICE_SID",
"length": 10,
"domain": null
},
{
"name": "FEATURE_ID",
"type": "esriFieldTypeString",
"alias": "FEATURE_ID",
"length": 10,
"domain": null
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"domain": null
},
{
"name": "StationFacilityID",
"type": "esriFieldTypeString",
"alias": "StationFacilityID",
"length": 50,
"domain": null
},
{
"name": "Description",
"type": "esriFieldTypeString",
"alias": "Description",
"length": 50,
"domain": null
},
{
"name": "Amps",
"type": "esriFieldTypeDouble",
"alias": "Amps",
"domain": null
}
],
"indexes": [
{
"name": "R864_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_864",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G1957StationFaci",
"fields": "StationFacilityID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G1957AssetID",
"fields": "AssetID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "UUID_OID_864",
"fields": "GlobalID,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"types": [
{
"domains": {
"Status": {"type": "inherited"},
"Condition": {"type": "inherited"},
"Manufacturer": {
"type": "codedValue",
"name": "sGeneratorManuf",
"codedValues": [
{
"name": "Caterpillar",
"code": "Caterpillar"
},
{
"name": "Generac",
"code": "Generac"
},
{
"name": "Onan",
"code": "Onan"
},
{
"name": "Blue Star",
"code": "Blue Star"
},
{
"name": "Katolite",
"code": "Katolite"
},
{
"name": "Empire",
"code": "Empire"
},
{
"name": "Atlantic Power Sys",
"code": "Atlantic Power Sys"
},
{
"name": "Olympian",
"code": "Olympian"
},
{
"name": "Westinghouse",
"code": "Westinghouse"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"Voltage": {"type": "inherited"},
"KW": {"type": "inherited"},
"FuelType": {
"type": "codedValue",
"name": "sFuelType",
"codedValues": [
{
"name": "Diesel",
"code": "Diesel"
},
{
"name": "Natural Gas",
"code": "Natural Gas"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
"id": 1,
"name": "Stationary"
},
{
"domains": {
"Status": {"type": "inherited"},
"Condition": {"type": "inherited"},
"Manufacturer": {
"type": "codedValue",
"name": "sGeneratorManuf",
"codedValues": [
{
"name": "Caterpillar",
"code": "Caterpillar"
},
{
"name": "Generac",
"code": "Generac"
},
{
"name": "Onan",
"code": "Onan"
},
{
"name": "Blue Star",
"code": "Blue Star"
},
{
"name": "Katolite",
"code": "Katolite"
},
{
"name": "Empire",
"code": "Empire"
},
{
"name": "Atlantic Power Sys",
"code": "Atlantic Power Sys"
},
{
"name": "Olympian",
"code": "Olympian"
},
{
"name": "Westinghouse",
"code": "Westinghouse"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"Voltage": {"type": "inherited"},
"KW": {"type": "inherited"},
"FuelType": {
"type": "codedValue",
"name": "sFuelType",
"codedValues": [
{
"name": "Diesel",
"code": "Diesel"
},
{
"name": "Natural Gas",
"code": "Natural Gas"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
"id": 2,
"name": "Portable"
}
],
"subtypes": [
{
"domains": {
"Status": {"type": "inherited"},
"Condition": {"type": "inherited"},
"Manufacturer": {
"type": "codedValue",
"name": "sGeneratorManuf",
"codedValues": [
{
"name": "Caterpillar",
"code": "Caterpillar"
},
{
"name": "Generac",
"code": "Generac"
},
{
"name": "Onan",
"code": "Onan"
},
{
"name": "Blue Star",
"code": "Blue Star"
},
{
"name": "Katolite",
"code": "Katolite"
},
{
"name": "Empire",
"code": "Empire"
},
{
"name": "Atlantic Power Sys",
"code": "Atlantic Power Sys"
},
{
"name": "Olympian",
"code": "Olympian"
},
{
"name": "Westinghouse",
"code": "Westinghouse"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"Voltage": {"type": "inherited"},
"KW": {"type": "inherited"},
"FuelType": {
"type": "codedValue",
"name": "sFuelType",
"codedValues": [
{
"name": "Diesel",
"code": "Diesel"
},
{
"name": "Natural Gas",
"code": "Natural Gas"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
"defaultValues": {
"AssetID": null,
"LegacyID": null,
"InstallDate": null,
"SubType": null,
"Status": null,
"WarrantyDate": null,
"Condition": null,
"ConditionDate": null,
"PrimaryImage": null,
"Manufacturer": null,
"Model": null,
"Serial": null,
"Voltage": null,
"KW": null,
"FuelCapacity": null,
"FuelType": null,
"DEVICE_UID": null,
"DEVICE_SID": null,
"FEATURE_ID": null,
"GlobalID": null,
"StationFacilityID": null,
"Description": null,
"Amps": null
},
"code": 1,
"name": "Stationary"
},
{
"domains": {
"Status": {"type": "inherited"},
"Condition": {"type": "inherited"},
"Manufacturer": {
"type": "codedValue",
"name": "sGeneratorManuf",
"codedValues": [
{
"name": "Caterpillar",
"code": "Caterpillar"
},
{
"name": "Generac",
"code": "Generac"
},
{
"name": "Onan",
"code": "Onan"
},
{
"name": "Blue Star",
"code": "Blue Star"
},
{
"name": "Katolite",
"code": "Katolite"
},
{
"name": "Empire",
"code": "Empire"
},
{
"name": "Atlantic Power Sys",
"code": "Atlantic Power Sys"
},
{
"name": "Olympian",
"code": "Olympian"
},
{
"name": "Westinghouse",
"code": "Westinghouse"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"Voltage": {"type": "inherited"},
"KW": {"type": "inherited"},
"FuelType": {
"type": "codedValue",
"name": "sFuelType",
"codedValues": [
{
"name": "Diesel",
"code": "Diesel"
},
{
"name": "Natural Gas",
"code": "Natural Gas"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
"defaultValues": {
"AssetID": null,
"LegacyID": null,
"InstallDate": null,
"SubType": null,
"Status": null,
"WarrantyDate": null,
"Condition": null,
"ConditionDate": null,
"PrimaryImage": null,
"Manufacturer": null,
"Model": null,
"Serial": null,
"Voltage": null,
"KW": null,
"FuelCapacity": null,
"FuelType": null,
"DEVICE_UID": null,
"DEVICE_SID": null,
"FEATURE_ID": null,
"GlobalID": null,
"StationFacilityID": null,
"Description": null,
"Amps": null
},
"code": 2,
"name": "Portable"
}
],
"relationships": [
{
"id": 6,
"name": "sTransferSwitch",
"relatedTableId": 39,
"role": "esriRelRoleOrigin",
"keyField": "AssetID",
"cardinality": "esriRelCardinalityOneToOne",
"composite": false
},
{
"id": 2,
"name": "ssLiftStation",
"relatedTableId": 41,
"role": "esriRelRoleDestination",
"keyField": "StationFacilityID",
"cardinality": "esriRelCardinalityOneToOne",
"composite": false
}
],
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"supportsStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, AMF",
"isDataVersioned": true,
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": false,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true
},
"dateFieldsTimeReference": null
}