{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "Civic Address Points", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "Civic address points created from municipal sources. Created primarily from Oxford County's 9-1-1 six digit address locates and assessment records\nExported weekly to Oxford_OpenData 17-08-2023", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "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": true, "extent": { "xmin": 489555.6629999997, "ymin": 4742014.827, "xmax": 545694.5750000002, "ymax": 4799934.368000001, "zmin": 0, "zmax": 0, "mmin": -9.999E35, "mmax": -9.999E35, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 150, 0, 125, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "COMMUNITY_ADDRESS", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "PIN" }, { "name": "XROLL", "type": "esriFieldTypeString", "alias": "XROLL", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "XROLL" }, { "name": "ADDRESSID", "type": "esriFieldTypeInteger", "alias": "ADDRESSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADDRESSID" }, { "name": "ADDRESS_NUMBER", "type": "esriFieldTypeInteger", "alias": "ADDRESS_NUMBER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADDRESS_NUMBER" }, { "name": "ADDRESS_NUMBER_HIGH", "type": "esriFieldTypeInteger", "alias": "ADDRESS_NUMBER_HIGH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADDRESS_NUMBER_HIGH" }, { "name": "ADDRESS_QUALIFIER", "type": "esriFieldTypeString", "alias": "ADDRESS_QUALIFIER", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ADDRESS_QUALIFIER" }, { "name": "UNIT_TYPE", "type": "esriFieldTypeString", "alias": "UNIT_TYPE", "domain": { "type": "codedValue", "name": "Add_UnitType", "description": "Unit types to use for address point units.", "codedValues": [ { "name": "UNIT", "code": "UNIT" }, { "name": "Lower", "code": "Lower" }, { "name": "LOT", "code": "LOT" }, { "name": "Upper", "code": "Upper" }, { "name": "SUITE", "code": "SUITE" }, { "name": "APT", "code": "APT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UNIT_TYPE" }, { "name": "UNIT", "type": "esriFieldTypeString", "alias": "UNIT", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "UNIT" }, { "name": "ROADNAMEID", "type": "esriFieldTypeInteger", "alias": "ROADNAMEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ROADNAMEID" }, { "name": "ROADNAME", "type": "esriFieldTypeString", "alias": "ROADNAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ROADNAME" }, { "name": "ROAD_NUM", "type": "esriFieldTypeSmallInteger", "alias": "ROAD_NUM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ROAD_NUM" }, { "name": "MU", "type": "esriFieldTypeString", "alias": "MU", "domain": { "type": "codedValue", "name": "Add_Mu", "description": "Municipality code as first initial.", "codedValues": [ { "name": "B", "code": "B" }, { "name": "E", "code": "E" }, { "name": "I", "code": "I" }, { "name": "N", "code": "N" }, { "name": "S", "code": "S" }, { "name": "T", "code": "T" }, { "name": "W", "code": "W" }, { "name": "Z", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "MU" }, { "name": "PARENT_ADDRESSID", "type": "esriFieldTypeInteger", "alias": "PARENT_ADDRESSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PARENT_ADDRESSID" }, { "name": "DATA_SOURCE", "type": "esriFieldTypeString", "alias": "DATA_SOURCE", "domain": { "type": "codedValue", "name": "Add_DataSource", "description": "Data source of address point. \"M\" for municipality, \"C\" for county if no formal notification, \"X\" from developer.", "codedValues": [ { "name": "M", "code": "M" }, { "name": "C", "code": "C" }, { "name": "X", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "DATA_SOURCE" }, { "name": "XCOORD", "type": "esriFieldTypeDouble", "alias": "XCOORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "XCOORD" }, { "name": "YCOORD", "type": "esriFieldTypeDouble", "alias": "YCOORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YCOORD" }, { "name": "LAT", "type": "esriFieldTypeDouble", "alias": "LAT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LAT" }, { "name": "LONG_", "type": "esriFieldTypeDouble", "alias": "LONG_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LONG_" }, { "name": "URBAN", "type": "esriFieldTypeString", "alias": "URBAN", "domain": { "type": "codedValue", "name": "Add_YesNo", "description": "Yes no values to be used in urban, IsException, and most DC fields.", "codedValues": [ { "name": "N", "code": "N" }, { "name": "Y", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "URBAN" }, { "name": "IS_EXCEPTION", "type": "esriFieldTypeString", "alias": "IS_EXCEPTION", "domain": { "type": "codedValue", "name": "Add_YesNo", "description": "Yes no values to be used in urban, IsException, and most DC fields.", "codedValues": [ { "name": "N", "code": "N" }, { "name": "Y", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "IS_EXCEPTION" }, { "name": "EXCEPTION_NOTE", "type": "esriFieldTypeString", "alias": "EXCEPTION_NOTE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EXCEPTION_NOTE" }, { "name": "EDIT_USERNAME", "type": "esriFieldTypeString", "alias": "EDIT_USERNAME", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EDIT_USERNAME" }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDIT_DATE" }, { "name": "END_DATE", "type": "esriFieldTypeDate", "alias": "END_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "END_DATE" }, { "name": "END_USERNAME", "type": "esriFieldTypeString", "alias": "END_USERNAME", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "END_USERNAME" }, { "name": "END_REASON", "type": "esriFieldTypeString", "alias": "END_REASON", "domain": { "type": "codedValue", "name": "Add_EndReason", "description": "Reason for enddating an address.", "codedValues": [ { "name": "R", "code": "R" }, { "name": "E", "code": "E" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "END_REASON" }, { "name": "START_DATE", "type": "esriFieldTypeDate", "alias": "START_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "START_DATE" }, { "name": "START_USERNAME", "type": "esriFieldTypeString", "alias": "START_USERNAME", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "START_USERNAME" }, { "name": "Community", "type": "esriFieldTypeString", "alias": "Community", "domain": { "type": "codedValue", "name": "Add_Community", "description": "Community that address is in. Not including Woodstock, Ingersoll or Tillsonburg, as these are urban areas.", "codedValues": [ { "name": "BEACHVILLE", "code": "BEACHVILLE" }, { "name": "BRIGHT", "code": "BRIGHT" }, { "name": "BROWNSVILLE", "code": "BROWNSVILLE" }, { "name": "BURGESSVILLE", "code": "BURGESSVILLE" }, { "name": "CANNING", "code": "CANNING" }, { "name": "CULLODEN", "code": "CULLODEN" }, { "name": "CURRIES", "code": "CURRIES" }, { "name": "DELMER", "code": "DELMER" }, { "name": "DEREHAM CENTRE", "code": "DEREHAM CENTRE" }, { "name": "DRUMBO", "code": "DRUMBO" }, { "name": "EASTWOOD", "code": "EASTWOOD" }, { "name": "EMBRO", "code": "EMBRO" }, { "name": "FOLDENS", "code": "FOLDENS" }, { "name": "GOBLES", "code": "GOBLES" }, { "name": "HARRINGTON", "code": "HARRINGTON" }, { "name": "HAWTREY", "code": "HAWTREY" }, { "name": "HICKSON", "code": "HICKSON" }, { "name": "INNERKIP", "code": "INNERKIP" }, { "name": "KINTORE", "code": "KINTORE" }, { "name": "LAKESIDE", "code": "LAKESIDE" }, { "name": "MOUNT ELGIN", "code": "MOUNT ELGIN" }, { "name": "NORWICH", "code": "NORWICH" }, { "name": "OSTRANDER", "code": "OSTRANDER" }, { "name": "OTTERVILLE", "code": "OTTERVILLE" }, { "name": "OXFORD CENTRE", "code": "OXFORD CENTRE" }, { "name": "PLATTSVILLE", "code": "PLATTSVILLE" }, { "name": "PRINCETON", "code": "PRINCETON" }, { "name": "SALFORD", "code": "SALFORD" }, { "name": "SPRINGFORD", "code": "SPRINGFORD" }, { "name": "SWEABURG", "code": "SWEABURG" }, { "name": "TAVISTOCK", "code": "TAVISTOCK" }, { "name": "THAMESFORD", "code": "THAMESFORD" }, { "name": "VERSCHOYLE", "code": "VERSCHOYLE" }, { "name": "WASHINGTON", "code": "WASHINGTON" }, { "name": "WOLVERTON", "code": "WOLVERTON" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Community" }, { "name": "COMMUNITY_ADDRESS", "type": "esriFieldTypeString", "alias": "COMMUNITY_ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "COMMUNITY_ADDRESS" }, { "name": "PINParent", "type": "esriFieldTypeString", "alias": "PINParent", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "PINParent" }, { "name": "County_DC", "type": "esriFieldTypeString", "alias": "County_DC", "domain": { "type": "codedValue", "name": "Add_YesNo", "description": "Yes no values to be used in urban, IsException, and most DC fields.", "codedValues": [ { "name": "N", "code": "N" }, { "name": "Y", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "County_DC" }, { "name": "WaterWW_DC", "type": "esriFieldTypeString", "alias": "WaterWW_DC", "domain": { "type": "codedValue", "name": "Add_YesNo", "description": "Yes no values to be used in urban, IsException, and most DC fields.", "codedValues": [ { "name": "N", "code": "N" }, { "name": "Y", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "WaterWW_DC" }, { "name": "Muni_DC", "type": "esriFieldTypeString", "alias": "Muni_DC", "domain": { "type": "codedValue", "name": "Add_YesNo", "description": "Yes no values to be used in urban, IsException, and most DC fields.", "codedValues": [ { "name": "N", "code": "N" }, { "name": "Y", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Muni_DC" }, { "name": "DC_ServiceArea", "type": "esriFieldTypeString", "alias": "DC_ServiceArea", "domain": { "type": "codedValue", "name": "Add_DCServiceArea", "description": "Development charge service area.", "codedValues": [ { "name": "DRUMBO", "code": "DRUMBO" }, { "name": "INGERSOLL", "code": "INGERSOLL" }, { "name": "INNERKIP", "code": "INNERKIP" }, { "name": "MOUNT ELGIN", "code": "MOUNT ELGIN" }, { "name": "NORWICH", "code": "NORWICH" }, { "name": "PLATTSVILLE", "code": "PLATTSVILLE" }, { "name": "TAVISTOCK", "code": "TAVISTOCK" }, { "name": "THAMESFORD", "code": "THAMESFORD" }, { "name": "TILLSONBURG", "code": "TILLSONBURG" }, { "name": "WOODSTOCK", "code": "WOODSTOCK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DC_ServiceArea" }, { "name": "PropertyRSN", "type": "esriFieldTypeInteger", "alias": "PropertyRSN", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PropertyRSN" }, { "name": "ParentPropertyRSN", "type": "esriFieldTypeInteger", "alias": "ParentPropertyRSN", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ParentPropertyRSN" }, { "name": "Post_Code", "type": "esriFieldTypeString", "alias": "Postal Code", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Post_Code" }, { "name": "Province", "type": "esriFieldTypeString", "alias": "Province", "domain": { "type": "codedValue", "name": "Add_Province", "description": "Province values as required by NENA standard for address points. Default to ON.", "codedValues": [ { "name": "Alberta", "code": "AB" }, { "name": "British Columbia", "code": "BC" }, { "name": "Manitoba", "code": "MB" }, { "name": "New Brunswick", "code": "NB" }, { "name": "Newfoundland and Labrador", "code": "NL" }, { "name": "Nova Scotia", "code": "NS" }, { "name": "Northwest Territories", "code": "NT" }, { "name": "Nunavut", "code": "NU" }, { "name": "Ontario", "code": "ON" }, { "name": "Prince Edward Island", "code": "PE" }, { "name": "Québec", "code": "QC" }, { "name": "Saskatchewan", "code": "SK" }, { "name": "Yukon", "code": "YT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "ON", "modelName": "Province" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R21059_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S13436_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "OxfordSDE.OXDATA.Civic_Address_pt", "description": "", "prototype": { "attributes": { "Post_Code": null, "PIN": null, "XROLL": null, "ADDRESSID": null, "ADDRESS_NUMBER": null, "ADDRESS_NUMBER_HIGH": null, "ADDRESS_QUALIFIER": null, "UNIT_TYPE": null, "UNIT": null, "ROADNAMEID": null, "ROADNAME": null, "ROAD_NUM": null, "MU": null, "PARENT_ADDRESSID": null, "DATA_SOURCE": null, "XCOORD": null, "YCOORD": null, "LAT": null, "LONG_": null, "URBAN": null, "IS_EXCEPTION": null, "EXCEPTION_NOTE": null, "EDIT_USERNAME": null, "EDIT_DATE": null, "END_DATE": null, "END_USERNAME": null, "END_REASON": null, "START_DATE": null, "START_USERNAME": null, "Community": null, "COMMUNITY_ADDRESS": null, "PINParent": null, "County_DC": null, "WaterWW_DC": null, "Muni_DC": null, "DC_ServiceArea": null, "PropertyRSN": null, "ParentPropertyRSN": null, "Province": "ON" } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }