{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 0, "name": "ArcSDE.DBO.Addresses_Berkeley", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": false, "extent": { "xmin": 6464342.381808549, "ymin": 1705839.7959881425, "xmax": 6494936.605068803, "ymax": 1727464.3180277199, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.6983428057351544E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 138, 92, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "STREETNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "U_X", "type": "esriFieldTypeDouble", "alias": "U_X", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "U_X" }, { "name": "U_Y", "type": "esriFieldTypeDouble", "alias": "U_Y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "U_Y" }, { "name": "LAT", "type": "esriFieldTypeDouble", "alias": "LAT", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "LAT" }, { "name": "LONG", "type": "esriFieldTypeDouble", "alias": "LONG", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "LONG" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LOCATIONID", "type": "esriFieldTypeInteger", "alias": "LOCATIONID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LOCATIONID" }, { "name": "PARCELID", "type": "esriFieldTypeInteger", "alias": "PARCELID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PARCELID" }, { "name": "APN", "type": "esriFieldTypeString", "alias": "APN", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "APN" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "STATUS" }, { "name": "ADDRESSTYP", "type": "esriFieldTypeString", "alias": "ADDRESSTYP", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "ADDRESSTYP" }, { "name": "STREETNUMB", "type": "esriFieldTypeInteger", "alias": "STREETNUMB", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STREETNUMB" }, { "name": "PREQUALIFI", "type": "esriFieldTypeString", "alias": "PREQUALIFI", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PREQUALIFI" }, { "name": "DIRECTION", "type": "esriFieldTypeString", "alias": "DIRECTION", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "DIRECTION" }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "STREETNAME", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "STREETNAME" }, { "name": "UNIT", "type": "esriFieldTypeString", "alias": "UNIT", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "UNIT" }, { "name": "STREETSUFF", "type": "esriFieldTypeString", "alias": "STREETSUFF", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "STREETSUFF" }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "ZIPCODE", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "ZIPCODE" }, { "name": "FULLADDRES", "type": "esriFieldTypeString", "alias": "FULLADDRES", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "FULLADDRES" }, { "name": "MAINLOCID", "type": "esriFieldTypeString", "alias": "MAINLOCID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MAINLOCID" }, { "name": "USECODE", "type": "esriFieldTypeString", "alias": "USECODE", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "USECODE" }, { "name": "USECODEDES", "type": "esriFieldTypeString", "alias": "USECODEDES", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "USECODEDES" }, { "name": "LOTSQFT", "type": "esriFieldTypeInteger", "alias": "LOTSQFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LOTSQFT" }, { "name": "BLDGSQFT", "type": "esriFieldTypeInteger", "alias": "BLDGSQFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BLDGSQFT" }, { "name": "OWNERNAME", "type": "esriFieldTypeString", "alias": "OWNERNAME", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "OWNERNAME" }, { "name": "OWNERADDRE", "type": "esriFieldTypeString", "alias": "OWNERADDRE", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "OWNERADDRE" }, { "name": "OWNERADD_1", "type": "esriFieldTypeString", "alias": "OWNERADD_1", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "OWNERADD_1" }, { "name": "OWNERCITY", "type": "esriFieldTypeString", "alias": "OWNERCITY", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OWNERCITY" }, { "name": "OWNERSTATE", "type": "esriFieldTypeString", "alias": "OWNERSTATE", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "OWNERSTATE" }, { "name": "OWNERZIP", "type": "esriFieldTypeString", "alias": "OWNERZIP", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "OWNERZIP" }, { "name": "INDBDATE", "type": "esriFieldTypeDate", "alias": "INDBDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INDBDATE" }, { "name": "Complete_address", "type": "esriFieldTypeString", "alias": "Complete_address", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "Complete_address" }, { "name": "Create_date1", "type": "esriFieldTypeDate", "alias": "Create_date1", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Create_date1" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": { "type": "codedValue", "name": "BuiltYr", "description": "BuiltYr for Mayor's Smart Growth Initiative", "codedValues": [ { "name": "Prio to 2005", "code": 0 }, { "name": "2005", "code": 2005 }, { "name": "2006", "code": 2006 }, { "name": "2007", "code": 2007 }, { "name": "2008", "code": 2008 }, { "name": "2009", "code": 2009 }, { "name": "2010", "code": 2010 }, { "name": "2011", "code": 2011 }, { "name": "2012", "code": 2012 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 2007, "modelName": "Year" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R13_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_13", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_13", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S3_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ArcSDE.DBO.Addresses_Berkeley", "description": "", "prototype": { "attributes": { "Year": 2007, "U_X": null, "U_Y": null, "Complete_address": null, "INDBDATE": null, "OWNERZIP": null, "OWNERSTATE": null, "OWNERCITY": null, "OWNERADD_1": null, "Create_date1": null, "LOCATIONID": null, "PARCELID": null, "APN": null, "STATUS": null, "ADDRESSTYP": null, "STREETNUMB": null, "PREQUALIFI": null, "DIRECTION": null, "STREETNAME": null, "UNIT": null, "STREETSUFF": null, "ZIPCODE": null, "FULLADDRES": null, "MAINLOCID": null, "USECODE": null, "USECODEDES": null, "LOTSQFT": null, "BLDGSQFT": null, "OWNERNAME": null, "OWNERADDRE": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "be4c3aae8e474d3a9c92a942dfa4143f" }