{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "CIS Layers", "type": "Group Layer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": null, "subLayers": [ { "id": 1, "name": "Customer Information System Locations" } ], "minScale": 0, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 6115308.796710223, "ymin": 1882165.2231918126, "xmax": 6216054.699220642, "ymax": 1986131.5073848069, "spatialReference": { "wkid": 102643, "latestWkid": 2227, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.2196446463532375E8, "falseY": -9.803219698505287E7, "xyUnits": 3.58926397780284E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query", "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Customer Information System Locations", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102643, "latestWkid": 2227, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115860600, "falseY": -93269500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": { "id": 0, "name": "CIS Layers" }, "subLayers": [], "minScale": 300000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "COLLECTIONTYPE", "uniqueValueGroups": [ { "heading": "Collection Type", "classes": [ { "label": "MFD", "description": "MFD", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 0, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 115, 0, 0, 255 ], "width": 2 } }, "values": [ [ "MFD" ] ] }, { "label": "SFD", "description": "SFD", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 168, 168, 0, 255 ], "width": 2 } }, "values": [ [ "SFD" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 0, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 115, 0, 0, 255 ], "width": 2 } }, "value": "MFD", "label": "MFD" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 168, 168, 0, 255 ], "width": 2 } }, "value": "SFD", "label": "SFD" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 156, 99, 92, 255 ], "toColor": [ 156, 99, 92, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 88, 232, 98, 255 ], "toColor": [ 88, 232, 98, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 116, 91, 240, 255 ], "toColor": [ 116, 91, 240, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 82, 186, 227, 255 ], "toColor": [ 82, 186, 227, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 209, 202, 102, 255 ], "toColor": [ 209, 202, 102, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 237, 128, 217, 255 ], "toColor": [ 237, 128, 217, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 76, 133, 79, 255 ], "toColor": [ 76, 133, 79, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 72, 78, 133, 255 ], "toColor": [ 72, 78, 133, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 106, 235, 200, 255 ], "toColor": [ 106, 235, 200, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 170, 151, 247, 255 ], "toColor": [ 170, 151, 247, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 55, 108, 255 ], "toColor": [ 158, 55, 108, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 112, 117, 255 ], "toColor": [ 250, 112, 117, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 144, 64, 173, 255 ], "toColor": [ 144, 64, 173, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 6115308.796710223, "ymin": 1882165.2231918126, "xmax": 6216054.699220642, "ymax": 1986131.5073848069, "spatialReference": { "wkid": 102643, "latestWkid": 2227, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.2196446463532375E8, "falseY": -9.803219698505287E7, "xyUnits": 3.58926397780284E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "STREETNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "INTID", "type": "esriFieldTypeInteger", "alias": "Integer ID", "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 150, "domain": null }, { "name": "APN", "type": "esriFieldTypeString", "alias": "APN", "length": 20, "domain": null }, { "name": "ACCOUNTNUMBER", "type": "esriFieldTypeInteger", "alias": "Account Number", "domain": null }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "Service Type", "length": 255, "domain": null }, { "name": "SERVICECOUNT", "type": "esriFieldTypeInteger", "alias": "Service Count", "domain": null }, { "name": "STREETNUM", "type": "esriFieldTypeInteger", "alias": "Street Number", "domain": null }, { "name": "STREETPREFIX", "type": "esriFieldTypeString", "alias": "Street Prefix", "length": 10, "domain": null }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "Street Name", "length": 80, "domain": null }, { "name": "STREETSUFFIX", "type": "esriFieldTypeString", "alias": "Street Suffix", "length": 10, "domain": null }, { "name": "UNITNUMBER", "type": "esriFieldTypeString", "alias": "Unit Number", "length": 20, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "Zip Code", "length": 10, "domain": null }, { "name": "FULLADDRESS", "type": "esriFieldTypeString", "alias": "Full Address", "length": 220, "domain": null }, { "name": "HAULERDISTRICT", "type": "esriFieldTypeString", "alias": "Hauler District", "length": 20, "domain": null }, { "name": "HAULERNAME", "type": "esriFieldTypeString", "alias": "Hauler Name", "length": 255, "domain": null }, { "name": "COLLECTIONTYPE", "type": "esriFieldTypeString", "alias": "Collection Type", "length": 3, "domain": { "type": "codedValue", "name": "CollectionTypes_1", "description": "Types of parcel waste collection", "codedValues": [ { "name": "SFD", "code": "SFD" }, { "name": "MFD", "code": "MFD" }, { "name": "COM", "code": "COM" }, { "name": "UNC", "code": "UNC" }, { "name": "FAC", "code": "FAC" }, { "name": "OTH", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 40, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "ENTERPRISEID", "type": "esriFieldTypeString", "alias": "Enterprise ID", "length": 20, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "TOTALCUBICYARDS", "type": "esriFieldTypeDouble", "alias": "Total Cubic Yards per Week for Account", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CREATIONDATE", "type": "esriFieldTypeDate", "alias": "Creation Date", "length": 8, "domain": null }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "Creator", "length": 40, "domain": null }, { "name": "HOANAME", "type": "esriFieldTypeString", "alias": "HOA Name", "length": 150, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R54_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5286ADDRESS", "fields": "ADDRESS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_54", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CIS List of Services", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "ADDRESS", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{281C9752-4F28-4C27-86FD-F471AD985D65}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": 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 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Collection Hauler Routes", "type": "Feature Layer", "description": "Routes of garbage, recycling, and yard trimming haulers. The route geometries are found by buffering properties serviced by the route and dissolving the buffered polygons by the route number.Data is updated as needed.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102643, "latestWkid": 2227, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115860600, "falseY": -93269500, "xyUnits": 3048.00609601219, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "Integrated Waste Management", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 195, 208, 247, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 2 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -115860600, "ymin": -93269500, "xmax": 6216731.717879832, "ymax": 1984439.7010572255, "spatialReference": { "wkid": 102643, "latestWkid": 2227, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.2196446463532375E8, "falseY": -9.803219698505287E7, "xyUnits": 3.58926397780284E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "HAULERNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "INTID", "type": "esriFieldTypeInteger", "alias": "Integer ID", "domain": null }, { "name": "DAY", "type": "esriFieldTypeString", "alias": "Day", "length": 30, "domain": null }, { "name": "ROUTE", "type": "esriFieldTypeString", "alias": "Route", "length": 50, "domain": null }, { "name": "DAYROUTE", "type": "esriFieldTypeString", "alias": "Day Route", "length": 80, "domain": null }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "Service Type", "length": 100, "domain": null }, { "name": "COLLECTIONTYPE", "type": "esriFieldTypeString", "alias": "Collection Type", "length": 10, "domain": { "type": "codedValue", "name": "CollectionTypes_1", "description": "Types of parcel waste collection", "codedValues": [ { "name": "SFD", "code": "SFD" }, { "name": "MFD", "code": "MFD" }, { "name": "COM", "code": "COM" }, { "name": "UNC", "code": "UNC" }, { "name": "FAC", "code": "FAC" }, { "name": "OTH", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HAULERDISTRICT", "type": "esriFieldTypeString", "alias": "Hauler District", "length": 20, "domain": null }, { "name": "HAULERNAME", "type": "esriFieldTypeString", "alias": "Hauler Name", "length": 50, "domain": { "type": "codedValue", "name": "CollectionHaulers", "description": "Waste hauler company names", "codedValues": [ { "name": "California Waste Solutions", "code": "California Waste Solutions" }, { "name": "Garden City Sanitation", "code": "Garden City Sanitation" }, { "name": "GreenTeam (MFD)", "code": "GreenTeam (MFD)" }, { "name": "GreenTeam of San Jose", "code": "GreenTeam of San Jose" }, { "name": "GreenWaste (MFD)", "code": "GreenWaste (MFD)" }, { "name": "GreenWaste Recovery", "code": "GreenWaste Recovery" }, { "name": "Recology South Bay", "code": "Recology South Bay" }, { "name": "Republic Services", "code": "Republic Services" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 40, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "ENTERPRISEID", "type": "esriFieldTypeString", "alias": "Enterprise ID", "length": 20, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "ROUTEID", "type": "esriFieldTypeString", "alias": "Route Identifier", "length": 20, "domain": null }, { "name": "CREATIONDATE", "type": "esriFieldTypeDate", "alias": "Creation Date", "length": 8, "domain": null }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "Creator", "length": 40, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R64_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_64", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_64", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S45_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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "CIS Accounts", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ADDRESS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 150, "domain": null }, { "name": "ACCOUNTNUMBER", "type": "esriFieldTypeInteger", "alias": "Account Number", "domain": null }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "Service Type", "length": 100, "domain": null }, { "name": "SERVICECOUNT", "type": "esriFieldTypeInteger", "alias": "Service Count", "domain": null }, { "name": "DATEINSTALLED", "type": "esriFieldTypeDate", "alias": "Date Installed", "length": 8, "domain": null }, { "name": "HAULERNAME", "type": "esriFieldTypeString", "alias": "Hauler Name", "length": 100, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 40, "domain": null } ], "indexes": [ { "name": "R52_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5283ADDRESS", "fields": "ADDRESS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_52", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CIS Account Locations", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "ADDRESS", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{281C9752-4F28-4C27-86FD-F471AD985D65}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }