{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "Water Meter Info", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WSC_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MB_ID", "type": "esriFieldTypeInteger", "alias": "MB_ID", "domain": null }, { "name": "WSC_ID", "type": "esriFieldTypeString", "alias": "WSC_ID", "length": 50, "domain": null }, { "name": "WSC_TYPE", "type": "esriFieldTypeString", "alias": "WSC_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "Water Service Types", "description": "Types of water services", "codedValues": [ { "name": "BILLABLE", "code": "BILLABLE" }, { "name": "CITY", "code": "CITY" }, { "name": "FUTURE", "code": "FUTURE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACCT_TYPE", "type": "esriFieldTypeString", "alias": "ACCT_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "Water Meter Account Type", "description": "Types of water accounts", "codedValues": [ { "name": "VERNONIA SCHOOLS", "code": "47J" }, { "name": "CITY", "code": "CITY" }, { "name": "COMMERCIAL", "code": "COMM" }, { "name": "MULTI-UNIT COMMERCIAL", "code": "COMM_MULTI" }, { "name": "GOVERNMENT", "code": "GOV" }, { "name": "INDUSTRIAL", "code": "IND" }, { "name": "NON-PROFIT", "code": "NOPRT" }, { "name": "RESIDENTIAL", "code": "RES" }, { "name": "MULTI-UNIT RESIDENTIAL", "code": "RES_MULTI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "PLACENAME", "type": "esriFieldTypeString", "alias": "PLACENAME", "length": 60, "domain": null }, { "name": "SEWER", "type": "esriFieldTypeSmallInteger", "alias": "SEWER", "domain": null }, { "name": "IN_CITY", "type": "esriFieldTypeSmallInteger", "alias": "IN_CITY", "domain": null }, { "name": "RES_UNITS", "type": "esriFieldTypeSmallInteger", "alias": "RES_UNITS", "domain": null }, { "name": "METER_MB_ID", "type": "esriFieldTypeInteger", "alias": "METER_MB_ID", "domain": null }, { "name": "METER_SIZE_D", "type": "esriFieldTypeDouble", "alias": "METER_SIZE_D", "domain": { "type": "codedValue", "name": "Water Meter Sizes", "description": "Sizes of water meters", "codedValues": [ { "name": "0.75", "code": 0.75 }, { "name": "1", "code": 1 }, { "name": "1.5", "code": 1.5 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "METER_SIZE_T", "type": "esriFieldTypeString", "alias": "METER_SIZE_T", "length": 50, "domain": { "type": "codedValue", "name": "Water Meter Sizes (text)", "description": "Sizes of water meters (text)", "codedValues": [ { "name": "3/4", "code": "3/4" }, { "name": "1", "code": "1" }, { "name": "1 1/2", "code": "1 1/2" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "METER_MFR", "type": "esriFieldTypeString", "alias": "METER_MFR", "length": 50, "domain": null }, { "name": "METER_MFR_YEAR", "type": "esriFieldTypeInteger", "alias": "METER_MFR_YEAR", "domain": null }, { "name": "METER_SN", "type": "esriFieldTypeString", "alias": "METER_SN", "length": 50, "domain": null }, { "name": "METER_REG_SN", "type": "esriFieldTypeString", "alias": "METER_REG_SN", "length": 50, "domain": null }, { "name": "METER_RADIO", "type": "esriFieldTypeSmallInteger", "alias": "METER_RADIO", "domain": null }, { "name": "METER_COMPOUND", "type": "esriFieldTypeSmallInteger", "alias": "METER_COMPOUND", "domain": null }, { "name": "METER_AGE", "type": "esriFieldTypeSmallInteger", "alias": "METER_AGE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "LINE_IN_MATERIAL", "type": "esriFieldTypeString", "alias": "LINE_IN_MATERIAL", "length": 255, "domain": { "type": "codedValue", "name": "Pipe Material", "description": "Pipe material for water, wastewater and stormwater", "codedValues": [ { "name": "Asbestos cement", "code": "AC" }, { "name": "Cast iron", "code": "CI" }, { "name": "Concrete", "code": "CONC" }, { "name": "Copper", "code": "CU" }, { "name": "Ductile iron", "code": "DI" }, { "name": "Acrylonitrile butadiene styrene", "code": "ABS" }, { "name": "High-density polyethylene", "code": "HDPE" }, { "name": "Polyvinyl chloride", "code": "PVC" }, { "name": "Stainless steel", "code": "SST" }, { "name": "Galvanized steel", "code": "STL" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified clay pipe", "code": "VCP" }, { "name": "High-density polyethylene (service line)", "code": "POLY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LINE_IN_SIZE", "type": "esriFieldTypeDouble", "alias": "LINE_IN_SIZE", "domain": null }, { "name": "LINE_OUT_MATERIAL", "type": "esriFieldTypeString", "alias": "LINE_OUT_MATERIAL", "length": 255, "domain": { "type": "codedValue", "name": "Pipe Material", "description": "Pipe material for water, wastewater and stormwater", "codedValues": [ { "name": "Asbestos cement", "code": "AC" }, { "name": "Cast iron", "code": "CI" }, { "name": "Concrete", "code": "CONC" }, { "name": "Copper", "code": "CU" }, { "name": "Ductile iron", "code": "DI" }, { "name": "Acrylonitrile butadiene styrene", "code": "ABS" }, { "name": "High-density polyethylene", "code": "HDPE" }, { "name": "Polyvinyl chloride", "code": "PVC" }, { "name": "Stainless steel", "code": "SST" }, { "name": "Galvanized steel", "code": "STL" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified clay pipe", "code": "VCP" }, { "name": "High-density polyethylene (service line)", "code": "POLY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LINE_OUT_SIZE", "type": "esriFieldTypeDouble", "alias": "LINE_OUT_SIZE", "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I11WSC_ID", "fields": "WSC_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "W_Meters", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "WSC_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{8E012E41-9B41-489B-97D7-36DA39185C2B}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "ef2cb0c4998e45679ebc41cde156db4c" }