{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 4, "name": "HRL1$", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "meter_model_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "active", "type": "esriFieldTypeString", "alias": "active", "length": 255, "domain": null }, { "name": "comment", "type": "esriFieldTypeString", "alias": "comment", "length": 255, "domain": null }, { "name": "created_on", "type": "esriFieldTypeDate", "alias": "created_on", "length": 8, "domain": null }, { "name": "ended_at", "type": "esriFieldTypeString", "alias": "ended_at", "length": 255, "domain": null }, { "name": "id", "type": "esriFieldTypeDouble", "alias": "id", "domain": null }, { "name": "indicator_description", "type": "esriFieldTypeString", "alias": "indicator_description", "length": 255, "domain": null }, { "name": "investigation_status_descriptio", "type": "esriFieldTypeString", "alias": "investigation_status_description", "length": 255, "domain": null }, { "name": "last_investigation_result_flag_", "type": "esriFieldTypeString", "alias": "last_investigation_result_flag_assessment_description", "length": 255, "domain": null }, { "name": "meter_address", "type": "esriFieldTypeString", "alias": "meter_address", "length": 255, "domain": null }, { "name": "meter_cis_meter_id", "type": "esriFieldTypeDouble", "alias": "meter_cis_meter_id", "domain": null }, { "name": "meter_cis_premise_id", "type": "esriFieldTypeDouble", "alias": "meter_cis_premise_id", "domain": null }, { "name": "meter_customer_type_description", "type": "esriFieldTypeString", "alias": "meter_customer_type_description", "length": 255, "domain": null }, { "name": "meter_endpoint_id", "type": "esriFieldTypeDouble", "alias": "meter_endpoint_id", "domain": null }, { "name": "meter_flow_sensor_type_descript", "type": "esriFieldTypeString", "alias": "meter_flow_sensor_type_description", "length": 255, "domain": null }, { "name": "meter_installed_at", "type": "esriFieldTypeDate", "alias": "meter_installed_at", "length": 8, "domain": null }, { "name": "meter_latitude", "type": "esriFieldTypeDouble", "alias": "meter_latitude", "domain": null }, { "name": "meter_location_group", "type": "esriFieldTypeString", "alias": "meter_location_group", "length": 255, "domain": null }, { "name": "meter_longitude", "type": "esriFieldTypeDouble", "alias": "meter_longitude", "domain": null }, { "name": "meter_manufactured_at", "type": "esriFieldTypeDate", "alias": "meter_manufactured_at", "length": 8, "domain": null }, { "name": "meter_manufacturer_description", "type": "esriFieldTypeString", "alias": "meter_manufacturer_description", "length": 255, "domain": null }, { "name": "meter_min_ami_read_on", "type": "esriFieldTypeDate", "alias": "meter_min_ami_read_on", "length": 8, "domain": null }, { "name": "meter_model_name", "type": "esriFieldTypeString", "alias": "meter_model_name", "length": 255, "domain": null }, { "name": "meter_rate_code", "type": "esriFieldTypeDouble", "alias": "meter_rate_code", "domain": null }, { "name": "meter_register_id", "type": "esriFieldTypeString", "alias": "meter_register_id", "length": 255, "domain": null }, { "name": "meter_route", "type": "esriFieldTypeDouble", "alias": "meter_route", "domain": null }, { "name": "meter_serial_number", "type": "esriFieldTypeString", "alias": "meter_serial_number", "length": 255, "domain": null }, { "name": "meter_service_area", "type": "esriFieldTypeString", "alias": "meter_service_area", "length": 255, "domain": null }, { "name": "meter_size_description", "type": "esriFieldTypeString", "alias": "meter_size_description", "length": 255, "domain": null }, { "name": "revenue_loss_estimated_all_time", "type": "esriFieldTypeDouble", "alias": "revenue_loss_estimated_all_time", "domain": null }, { "name": "revenue_loss_estimated_monthly", "type": "esriFieldTypeDouble", "alias": "revenue_loss_estimated_monthly", "domain": null }, { "name": "revenue_loss_estimated_status_d", "type": "esriFieldTypeString", "alias": "revenue_loss_estimated_status_description", "length": 255, "domain": null }, { "name": "revenue_units", "type": "esriFieldTypeString", "alias": "revenue_units", "length": 255, "domain": null }, { "name": "started_at", "type": "esriFieldTypeDate", "alias": "started_at", "length": 8, "domain": null }, { "name": "volume_loss_estimated_all_time", "type": "esriFieldTypeDouble", "alias": "volume_loss_estimated_all_time", "domain": null }, { "name": "volume_loss_estimated_monthly", "type": "esriFieldTypeDouble", "alias": "volume_loss_estimated_monthly", "domain": null }, { "name": "volume_loss_estimated_status_de", "type": "esriFieldTypeString", "alias": "volume_loss_estimated_status_description", "length": 255, "domain": null }, { "name": "volume_units", "type": "esriFieldTypeString", "alias": "volume_units", "length": 255, "domain": null } ], "indexes": [ { "name": "R2181_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "f68576db8354436992a5b3ff9cd82ab0" }