{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Utilities_Water.DBO.Fire_Facilities", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2930, "latestWkid": 2930, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 2, "falseX": -118121300, "falseY": -97418300, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 131, 50, 145, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2485134.7804143867, "ymin": 382141.7576491335, "xmax": 2506391.517428384, "ymax": 408650.02254589205, "spatialReference": { "wkid": 103191, "latestWkid": 6609, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118121300, "falseY": -97418300, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "X", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "X", "domain": null }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "Y", "domain": null }, { "name": "FeatureType", "type": "esriFieldTypeString", "alias": "FeatureType", "length": 20, "domain": null }, { "name": "AboveGround", "type": "esriFieldTypeString", "alias": "AboveGround", "length": 5, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "UserID", "type": "esriFieldTypeString", "alias": "UserID", "length": 50, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12_pk", "fields": "ID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S2_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "ec469f334ff14ea7870ebbfc891d2891" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Utilities_Water.DBO.CustInfo", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CUSTNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DESCRIPT_1", "type": "esriFieldTypeString", "alias": "DESCRIPT_1", "length": 25, "domain": null }, { "name": "OLDACCTNBR", "type": "esriFieldTypeString", "alias": "OLDACCTNBR", "length": 18, "domain": null }, { "name": "COUNTRY", "type": "esriFieldTypeString", "alias": "COUNTRY", "length": 15, "domain": null }, { "name": "COLLBAL", "type": "esriFieldTypeDouble", "alias": "COLLBAL", "domain": null }, { "name": "WORKPHONE", "type": "esriFieldTypeDouble", "alias": "WORKPHONE", "domain": null }, { "name": "TAX_PCT_I", "type": "esriFieldTypeSingle", "alias": "TAX_PCT_I", "domain": null }, { "name": "STREETPRF2", "type": "esriFieldTypeString", "alias": "STREETPRF2", "length": 2, "domain": null }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "ZIPCODE", "length": 10, "domain": null }, { "name": "STREETDIR2", "type": "esriFieldTypeString", "alias": "STREETDIR2", "length": 2, "domain": null }, { "name": "PHONETIC", "type": "esriFieldTypeString", "alias": "PHONETIC", "length": 5, "domain": null }, { "name": "WOFFAMOUNT", "type": "esriFieldTypeDouble", "alias": "WOFFAMOUNT", "domain": null }, { "name": "PYMTDTE", "type": "esriFieldTypeInteger", "alias": "PYMTDTE", "domain": null }, { "name": "COLLAGENCY", "type": "esriFieldTypeString", "alias": "COLLAGENCY", "length": 5, "domain": null }, { "name": "BUDAMT", "type": "esriFieldTypeDouble", "alias": "BUDAMT", "domain": null }, { "name": "DRVLICNO2", "type": "esriFieldTypeString", "alias": "DRVLICNO2", "length": 15, "domain": null }, { "name": "REMSWDISC", "type": "esriFieldTypeDouble", "alias": "REMSWDISC", "domain": null }, { "name": "SEWRUSG", "type": "esriFieldTypeInteger", "alias": "SEWRUSG", "domain": null }, { "name": "PYMTDTNUM", "type": "esriFieldTypeInteger", "alias": "PYMTDTNUM", "domain": null }, { "name": "RELATION", "type": "esriFieldTypeString", "alias": "RELATION", "length": 10, "domain": null }, { "name": "EXEMPT", "type": "esriFieldTypeString", "alias": "EXEMPT", "length": 1, "domain": null }, { "name": "USERTYPE", "type": "esriFieldTypeString", "alias": "USERTYPE", "length": 5, "domain": null }, { "name": "HOLDBILL", "type": "esriFieldTypeString", "alias": "HOLDBILL", "length": 1, "domain": null }, { "name": "HOLDDEP", "type": "esriFieldTypeString", "alias": "HOLDDEP", "length": 1, "domain": null }, { "name": "AIDAMT", "type": "esriFieldTypeSingle", "alias": "AIDAMT", "domain": null }, { "name": "ORG_NBR", "type": "esriFieldTypeSmallInteger", "alias": "ORG_NBR", "domain": null }, { "name": "TAX_PCT", "type": "esriFieldTypeSingle", "alias": "TAX_PCT", "domain": null }, { "name": "XSTATUS", "type": "esriFieldTypeString", "alias": "XSTATUS", "length": 2, "domain": null }, { "name": "ACHACCTNBR", "type": "esriFieldTypeString", "alias": "ACHACCTNBR", "length": 17, "domain": null }, { "name": "COLLDATNUM", "type": "esriFieldTypeInteger", "alias": "COLLDATNUM", "domain": null }, { "name": "SURETYAMT", "type": "esriFieldTypeDouble", "alias": "SURETYAMT", "domain": null }, { "name": "OUTSIDER", "type": "esriFieldTypeString", "alias": "OUTSIDER", "length": 1, "domain": null }, { "name": "STREETTYP2", "type": "esriFieldTypeString", "alias": "STREETTYP2", "length": 5, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 25, "domain": null }, { "name": "RETCHDT", "type": "esriFieldTypeInteger", "alias": "RETCHDT", "domain": null }, { "name": "PHONENBR", "type": "esriFieldTypeDouble", "alias": "PHONENBR", "domain": null }, { "name": "OPENDATE", "type": "esriFieldTypeInteger", "alias": "OPENDATE", "domain": null }, { "name": "CUSTNAME", "type": "esriFieldTypeString", "alias": "CUSTNAME", "length": 25, "domain": null }, { "name": "SURETYEXP", "type": "esriFieldTypeInteger", "alias": "SURETYEXP", "domain": null }, { "name": "ACHBANKNBR", "type": "esriFieldTypeInteger", "alias": "ACHBANKNBR", "domain": null }, { "name": "COLLDATE", "type": "esriFieldTypeInteger", "alias": "COLLDATE", "domain": null }, { "name": "CLOSEDATE", "type": "esriFieldTypeInteger", "alias": "CLOSEDATE", "domain": null }, { "name": "CLSEDATNUM", "type": "esriFieldTypeInteger", "alias": "CLSEDATNUM", "domain": null }, { "name": "CUSTNAME2", "type": "esriFieldTypeString", "alias": "CUSTNAME2", "length": 25, "domain": null }, { "name": "ACCTBAL", "type": "esriFieldTypeDouble", "alias": "ACCTBAL", "domain": null }, { "name": "AUTOPAYFL", "type": "esriFieldTypeString", "alias": "AUTOPAYFL", "length": 1, "domain": null }, { "name": "SSN", "type": "esriFieldTypeInteger", "alias": "SSN", "domain": null }, { "name": "BUDSETDTE", "type": "esriFieldTypeInteger", "alias": "BUDSETDTE", "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "length": 2, "domain": null }, { "name": "MAILSUITE", "type": "esriFieldTypeString", "alias": "MAILSUITE", "length": 10, "domain": null }, { "name": "CARRIERRTE", "type": "esriFieldTypeString", "alias": "CARRIERRTE", "length": 4, "domain": null }, { "name": "ACCT_STAT", "type": "esriFieldTypeString", "alias": "ACCT_STAT", "length": 5, "domain": null }, { "name": "STREET2", "type": "esriFieldTypeString", "alias": "STREET2", "length": 25, "domain": null }, { "name": "STREETNBR2", "type": "esriFieldTypeInteger", "alias": "STREETNBR2", "domain": null }, { "name": "REASON", "type": "esriFieldTypeString", "alias": "REASON", "length": 67, "domain": null }, { "name": "BUDTYP", "type": "esriFieldTypeString", "alias": "BUDTYP", "length": 6, "domain": null }, { "name": "REL_DATE", "type": "esriFieldTypeInteger", "alias": "REL_DATE", "domain": null }, { "name": "SSN2", "type": "esriFieldTypeInteger", "alias": "SSN2", "domain": null }, { "name": "O_R", "type": "esriFieldTypeString", "alias": "O_R", "length": 1, "domain": null }, { "name": "DOLLARAID", "type": "esriFieldTypeString", "alias": "DOLLARAID", "length": 1, "domain": null }, { "name": "ADDLNAME", "type": "esriFieldTypeString", "alias": "ADDLNAME", "length": 25, "domain": null }, { "name": "DOB", "type": "esriFieldTypeInteger", "alias": "DOB", "domain": null }, { "name": "BILL", "type": "esriFieldTypeString", "alias": "BILL", "length": 1, "domain": null }, { "name": "LASTBILL", "type": "esriFieldTypeInteger", "alias": "LASTBILL", "domain": null }, { "name": "ACHACCTYPE", "type": "esriFieldTypeString", "alias": "ACHACCTYPE", "length": 1, "domain": null }, { "name": "APPLYDEPIN", "type": "esriFieldTypeString", "alias": "APPLYDEPIN", "length": 1, "domain": null }, { "name": "CHECKDIGIT", "type": "esriFieldTypeSmallInteger", "alias": "CHECKDIGIT", "domain": null }, { "name": "WORD4", "type": "esriFieldTypeString", "alias": "WORD4", "length": 25, "domain": null }, { "name": "WORD3", "type": "esriFieldTypeString", "alias": "WORD3", "length": 25, "domain": null }, { "name": "MAINT", "type": "esriFieldTypeString", "alias": "MAINT", "length": 1, "domain": null }, { "name": "WORD2", "type": "esriFieldTypeString", "alias": "WORD2", "length": 25, "domain": null }, { "name": "WORD1", "type": "esriFieldTypeString", "alias": "WORD1", "length": 25, "domain": null }, { "name": "SPECHANDFL", "type": "esriFieldTypeString", "alias": "SPECHANDFL", "length": 5, "domain": null }, { "name": "EXPIRDATE", "type": "esriFieldTypeInteger", "alias": "EXPIRDATE", "domain": null }, { "name": "COMPANY", "type": "esriFieldTypeString", "alias": "COMPANY", "length": 22, "domain": null }, { "name": "APPLYDEP", "type": "esriFieldTypeString", "alias": "APPLYDEP", "length": 1, "domain": null }, { "name": "EXEMPTDIS", "type": "esriFieldTypeString", "alias": "EXEMPTDIS", "length": 1, "domain": null }, { "name": "ADDRESS1", "type": "esriFieldTypeString", "alias": "ADDRESS1", "length": 25, "domain": null }, { "name": "BUDBILDTE", "type": "esriFieldTypeInteger", "alias": "BUDBILDTE", "domain": null }, { "name": "AUTHCD", "type": "esriFieldTypeString", "alias": "AUTHCD", "length": 5, "domain": null }, { "name": "LSTDELQDT", "type": "esriFieldTypeInteger", "alias": "LSTDELQDT", "domain": null }, { "name": "DRVLICNO", "type": "esriFieldTypeString", "alias": "DRVLICNO", "length": 15, "domain": null }, { "name": "HOLDPRNT", "type": "esriFieldTypeString", "alias": "HOLDPRNT", "length": 1, "domain": null }, { "name": "LIENDT", "type": "esriFieldTypeInteger", "alias": "LIENDT", "domain": null }, { "name": "REMWADISC", "type": "esriFieldTypeDouble", "alias": "REMWADISC", "domain": null }, { "name": "OWNERSNAME", "type": "esriFieldTypeDouble", "alias": "OWNERSNAME", "domain": null }, { "name": "CUSTNO", "type": "esriFieldTypeDouble", "alias": "CUSTNO", "domain": null }, { "name": "WOFFDATE", "type": "esriFieldTypeInteger", "alias": "WOFFDATE", "domain": null }, { "name": "EXEMPTCOL", "type": "esriFieldTypeString", "alias": "EXEMPTCOL", "length": 1, "domain": null }, { "name": "REQTIME", "type": "esriFieldTypeInteger", "alias": "REQTIME", "domain": null }, { "name": "MESSAGENBR", "type": "esriFieldTypeSmallInteger", "alias": "MESSAGENBR", "domain": null }, { "name": "SRVCKY", "type": "esriFieldTypeInteger", "alias": "SRVCKY", "domain": null }, { "name": "ADDRSNBR", "type": "esriFieldTypeSmallInteger", "alias": "ADDRSNBR", "domain": null }, { "name": "FRAHOUSE2", "type": "esriFieldTypeString", "alias": "FRAHOUSE2", "length": 5, "domain": null }, { "name": "PRVCLSDTNM", "type": "esriFieldTypeInteger", "alias": "PRVCLSDTNM", "domain": null }, { "name": "INQBUT", "type": "esriFieldTypeString", "alias": "INQBUT", "length": 1, "domain": null }, { "name": "OPENDATNUM", "type": "esriFieldTypeInteger", "alias": "OPENDATNUM", "domain": null }, { "name": "CONTFLOW", "type": "esriFieldTypeString", "alias": "CONTFLOW", "length": 1, "domain": null }, { "name": "EMAILADDR", "type": "esriFieldTypeString", "alias": "EMAILADDR", "length": 40, "domain": null }, { "name": "PRVCLSDATE", "type": "esriFieldTypeInteger", "alias": "PRVCLSDATE", "domain": null }, { "name": "SPHFREQ", "type": "esriFieldTypeSmallInteger", "alias": "SPHFREQ", "domain": null }, { "name": "EXEMPTLTE", "type": "esriFieldTypeString", "alias": "EXEMPTLTE", "length": 1, "domain": null }, { "name": "TRCODE", "type": "esriFieldTypeString", "alias": "TRCODE", "length": 6, "domain": null }, { "name": "QUANTITY", "type": "esriFieldTypeDouble", "alias": "QUANTITY", "domain": null }, { "name": "STREETPREF", "type": "esriFieldTypeString", "alias": "STREETPREF", "length": 2, "domain": null }, { "name": "STREETNBR", "type": "esriFieldTypeInteger", "alias": "STREETNBR", "domain": null }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "STREET", "length": 25, "domain": null }, { "name": "STREETTYPE", "type": "esriFieldTypeString", "alias": "STREETTYPE", "length": 5, "domain": null }, { "name": "STREETDIR", "type": "esriFieldTypeString", "alias": "STREETDIR", "length": 2, "domain": null }, { "name": "SUITE", "type": "esriFieldTypeString", "alias": "SUITE", "length": 10, "domain": null }, { "name": "FRAHOUSE", "type": "esriFieldTypeString", "alias": "FRAHOUSE", "length": 5, "domain": null }, { "name": "ADKEY", "type": "esriFieldTypeInteger", "alias": "ADKEY", "domain": null }, { "name": "PROP_ID", "type": "esriFieldTypeString", "alias": "PROP_ID", "length": 40, "domain": null } ], "indexes": [ { "name": "R31_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": "ec469f334ff14ea7870ebbfc891d2891" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "Utilities_Water.DBO.Gems_Usage", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TRANSDATE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TRANSDATE", "type": "esriFieldTypeInteger", "alias": "TRANSDATE", "domain": null }, { "name": "ACTUALUSED", "type": "esriFieldTypeInteger", "alias": "ACTUALUSED", "domain": null }, { "name": "SERVDAYS", "type": "esriFieldTypeSmallInteger", "alias": "SERVDAYS", "domain": null }, { "name": "OVERIDEDT", "type": "esriFieldTypeString", "alias": "OVERIDEDT", "length": 1, "domain": null }, { "name": "SERIALNBR", "type": "esriFieldTypeString", "alias": "SERIALNBR", "length": 14, "domain": null }, { "name": "READING", "type": "esriFieldTypeInteger", "alias": "READING", "domain": null }, { "name": "ESTRECD", "type": "esriFieldTypeString", "alias": "ESTRECD", "length": 2, "domain": null }, { "name": "DEMANDREAD", "type": "esriFieldTypeDouble", "alias": "DEMANDREAD", "domain": null }, { "name": "OFFPDEMDUS", "type": "esriFieldTypeDouble", "alias": "OFFPDEMDUS", "domain": null }, { "name": "CONSUMED", "type": "esriFieldTypeInteger", "alias": "CONSUMED", "domain": null }, { "name": "TRANSNBR", "type": "esriFieldTypeDouble", "alias": "TRANSNBR", "domain": null }, { "name": "ADKEY", "type": "esriFieldTypeInteger", "alias": "ADKEY", "domain": null }, { "name": "USAGEMONTH", "type": "esriFieldTypeInteger", "alias": "USAGEMONTH", "domain": null }, { "name": "READDATNUM", "type": "esriFieldTypeInteger", "alias": "READDATNUM", "domain": null }, { "name": "OFFPDEMDRD", "type": "esriFieldTypeDouble", "alias": "OFFPDEMDRD", "domain": null }, { "name": "READCODE", "type": "esriFieldTypeSmallInteger", "alias": "READCODE", "domain": null }, { "name": "CURRENTCUS", "type": "esriFieldTypeSmallInteger", "alias": "CURRENTCUS", "domain": null }, { "name": "CUSTNO", "type": "esriFieldTypeDouble", "alias": "CUSTNO", "domain": null }, { "name": "DEMANDUSED", "type": "esriFieldTypeDouble", "alias": "DEMANDUSED", "domain": null }, { "name": "RMOVED", "type": "esriFieldTypeString", "alias": "RMOVED", "length": 1, "domain": null }, { "name": "WORS", "type": "esriFieldTypeString", "alias": "WORS", "length": 1, "domain": null }, { "name": "BILLED", "type": "esriFieldTypeInteger", "alias": "BILLED", "domain": null }, { "name": "METERKY", "type": "esriFieldTypeInteger", "alias": "METERKY", "domain": null }, { "name": "MXCONSUMED", "type": "esriFieldTypeInteger", "alias": "MXCONSUMED", "domain": null }, { "name": "USGFLAG2", "type": "esriFieldTypeString", "alias": "USGFLAG2", "length": 1, "domain": null }, { "name": "USGFLAG1", "type": "esriFieldTypeString", "alias": "USGFLAG1", "length": 1, "domain": null }, { "name": "OLDMETERKY", "type": "esriFieldTypeInteger", "alias": "OLDMETERKY", "domain": null }, { "name": "MNCONSUMED", "type": "esriFieldTypeInteger", "alias": "MNCONSUMED", "domain": null }, { "name": "KWRDORIG", "type": "esriFieldTypeDouble", "alias": "KWRDORIG", "domain": null }, { "name": "KVRHREAD", "type": "esriFieldTypeInteger", "alias": "KVRHREAD", "domain": null }, { "name": "CALCPWRF", "type": "esriFieldTypeSingle", "alias": "CALCPWRF", "domain": null }, { "name": "KVRHUSED", "type": "esriFieldTypeInteger", "alias": "KVRHUSED", "domain": null }, { "name": "BILLEDKW", "type": "esriFieldTypeDouble", "alias": "BILLEDKW", "domain": null }, { "name": "KWUSED", "type": "esriFieldTypeDouble", "alias": "KWUSED", "domain": null }, { "name": "SONBR", "type": "esriFieldTypeInteger", "alias": "SONBR", "domain": null }, { "name": "STREETDIR", "type": "esriFieldTypeString", "alias": "STREETDIR", "length": 2, "domain": null }, { "name": "STREETPREF", "type": "esriFieldTypeString", "alias": "STREETPREF", "length": 2, "domain": null }, { "name": "STREETNBR", "type": "esriFieldTypeInteger", "alias": "STREETNBR", "domain": null }, { "name": "SUITE", "type": "esriFieldTypeString", "alias": "SUITE", "length": 10, "domain": null }, { "name": "FRAHOUSE", "type": "esriFieldTypeString", "alias": "FRAHOUSE", "length": 5, "domain": null }, { "name": "STREETTYPE", "type": "esriFieldTypeString", "alias": "STREETTYPE", "length": 5, "domain": null }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "STREET", "length": 25, "domain": null } ], "indexes": [ { "name": "R30_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": "ec469f334ff14ea7870ebbfc891d2891" } ] }