{ "isCoGoEnabled": false, "extent": { "ymin": 357840.19034533226, "zmin": -9.9989999999999996E+35, "xmin": 1275417.0151089611, "ymax": 443424.90823238826, "zmax": -9.9989999999999996E+35, "xmax": 1331890.3840982763, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333335, "mUnits": 10000, "zUnits": 1, "latestWkid": 2285, "zTolerance": 2, "wkid": 102748, "xyUnits": 37926742.22403606, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "falseZ": 0 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": null, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "relationships": [], "cimVersion": "3.7.0", "isDataArchived": false, "id": 0, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333335, "mUnits": 10000, "zUnits": 1, "latestWkid": 2285, "zTolerance": 2, "wkid": 102748, "xyUnits": 37926742.22403606, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "falseZ": 0 }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson,kml,excel,featureCollection", "hasLastEditTime": false, "standardMaxRecordCount": 32000, "isDataVersioned": false, "templates": [{ "name": "Site Addresses", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": {"attributes": { "Unit_Number": null, "Street_Name": null, "Street_Suffix_Direction": null, "Full_Street_Name": null, "Street_Prefix_Direction": null, "City": null, "Unit": null, "County": null, "Address_Number": null, "Street_Suffix_Type": null, "State": null, "Short_Address": null, "Full_Address": null, "Zip_Code": null, "Street_Prefix_Type": null, "Parcel_ID": null }} }], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 12.1, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsSessionBasedAddAttachments": true, "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsSessionBasedUpdateFeatures": true, "supportsSessionBasedDeleteAttachments": true, "supportsDivideCombineGroupedObjects": true, "supportsDeleteAssociations": true, "supportsSessionBasedUpdateAttachments": true, "supportedSqlFormatsInCalculate": ["standard"], "supportedApplyEditsUploadIDFormats": "JSON,PBF", "supportsSessionBasedDeleteFeatures": true, "supportsSessionBasedAddFeatures": true }, "supportsQuantizationEditMode": true, "objectIdField": "OBJECTID", "name": "Site Addresses", "allowTrueCurvesUpdates": true, "displayField": "Street_Name", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "Address_Number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Address_Number", "length": 6, "alias": "Address_Number", "type": "esriFieldTypeString" }, { "modelName": "Street_Prefix_Direction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Street_Prefix_Direction", "length": 9, "alias": "Street_Prefix_Direction", "type": "esriFieldTypeString" }, { "modelName": "Street_Prefix_Type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Street_Prefix_Type", "length": 25, "alias": "Street_Prefix_Type", "type": "esriFieldTypeString" }, { "modelName": "Street_Name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Street_Name", "length": 60, "alias": "Street_Name", "type": "esriFieldTypeString" }, { "modelName": "Street_Suffix_Type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Street_Suffix_Type", "length": 15, "alias": "Street_Suffix_Type", "type": "esriFieldTypeString" }, { "modelName": "Street_Suffix_Direction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Street_Suffix_Direction", "length": 9, "alias": "Street_Suffix_Direction", "type": "esriFieldTypeString" }, { "modelName": "Full_Street_Name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Full_Street_Name", "length": 122, "alias": "Full_Street_Name", "type": "esriFieldTypeString" }, { "modelName": "Unit_Number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Unit_Number", "length": 75, "alias": "Unit_Number", "type": "esriFieldTypeString" }, { "modelName": "Unit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Unit", "length": 75, "alias": "Unit", "type": "esriFieldTypeString" }, { "modelName": "Zip_Code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Zip_Code", "length": 5, "alias": "Zip_Code", "type": "esriFieldTypeString" }, { "modelName": "Full_Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Full_Address", "length": 150, "alias": "Full_Address", "type": "esriFieldTypeString" }, { "modelName": "City", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "City", "length": 100, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "County", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "County", "length": 40, "alias": "County", "type": "esriFieldTypeString" }, { "modelName": "State", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "State", "length": 2, "alias": "State", "type": "esriFieldTypeString" }, { "modelName": "GlobalID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "modelName": "Short_Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Short_Address", "length": 150, "alias": "Short_Address", "type": "esriFieldTypeString" }, { "modelName": "Parcel_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Parcel_ID", "length": 50, "alias": "Parcel_ID", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "bigIntegerRestrictedTo53Bits": true, "hasM": false, "allowGeometryUpdates": false, "preferredTimeReference": null, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": 0, "xyTolerance": 0.0032808333333333331, "mUnits": 1, "zUnits": 10000, "latestWkid": 2285, "zTolerance": 0.001, "wkid": 102748, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "falseZ": -100000 }, "globalIdField": "GlobalID", "description": "

<\/P>

<\/P>

<\/P>

Relevant SQL snippet below:<\/SPAN><\/SPAN><\/P>

<\/P>

SET<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ANSI_NULLS<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ON<\/SPAN><\/SPAN>;<\/SPAN><\/SPAN><\/P>

SET<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ANSI_PADDING<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ON<\/SPAN><\/SPAN>;<\/SPAN><\/SPAN><\/P>

SET<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ANSI_WARNINGS<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ON<\/SPAN><\/SPAN>;<\/SPAN><\/SPAN><\/P>

SET<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ARITHABORT<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ON<\/SPAN><\/SPAN>;<\/SPAN><\/SPAN><\/P>

SET<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>CONCAT_NULL_YIELDS_NULL<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ON<\/SPAN><\/SPAN>;<\/SPAN><\/SPAN><\/P>

SET<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>QUOTED_IDENTIFIER<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>ON<\/SPAN><\/SPAN>;<\/SPAN><\/SPAN><\/P>

use<\/SPAN><\/SPAN> [Assessor]<\/SPAN><\/SPAN><\/P>

GO<\/SPAN><\/SPAN><\/P>

-- two steps - initial set up: drop the table and repopulate with appropriate schema<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>-- continuing steps: once schema is established - truncate table and use insert into to populate data<\/SPAN><\/SPAN><\/P>

IF<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>EXISTS<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>SELECT<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>*<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>FROM<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>sys<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>objects<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>WHERE<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>object_id<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>OBJECT_ID<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>N'[dbo].[MSVL_NG911_Publish]'<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>AND<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>type<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>in<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>N'U'<\/SPAN><\/SPAN>))<\/SPAN><\/SPAN><\/P>

TRUNCATE<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>TABLE<\/SPAN><\/SPAN> [dbo]<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>[MSVL_NG911_Publish]<\/SPAN><\/SPAN><\/P>

GO<\/SPAN><\/SPAN><\/P>

INSERT<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>INTO<\/SPAN><\/SPAN> [dbo]<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>[MSVL_NG911_Publish]<\/SPAN><\/SPAN><\/P>

SELECT<\/SPAN><\/SPAN> [OBJECTID]<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[Shape]<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>CONVERT<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>varbinary<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>MAX<\/SPAN><\/SPAN>),<\/SPAN><\/SPAN>[GDB_GEOMATTR_DATA]<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>1<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>AS<\/SPAN><\/SPAN> [GDB_GEOMATTR_DATA]<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[Add_Number] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Address_Number'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_PreDir] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Street_Prefix_Direction'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_PreTyp] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Street_Prefix_Type'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_Name] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Street_Name'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_PosTyp] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Street_Suffix_Type'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_PosDir] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Street_Suffix_Direction'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>TRIM<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>CONCAT_WS<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>' '<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_PreDir]<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_PreTyp]<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_Name]<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_PosTyp]<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[St_PosDir]<\/SPAN><\/SPAN>))<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Full_Street_Name'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[UNITNUM] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Unit_Number'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[Unit]<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[Post_Code] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Zip_Code'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[FULL_ADDR] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Full_Address'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[Inc_Muni] <\/SPAN><\/SPAN>as<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'City'<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[County]<\/SPAN><\/SPAN><\/P>

<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>[State]<\/SPAN><\/SPAN><\/P>

FROM<\/SPAN><\/SPAN><\/P>

[Assessor]<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>[dbo]<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>[SNOCO_NG911_EXTRACT]<\/SPAN><\/SPAN><\/P>

GO<\/SPAN><\/SPAN><\/P>

<\/P><\/DIV><\/DIV><\/DIV>", "syncCanReturnChanges": false, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 32000, "indexes": [ { "name": "R700_pk", "isUnique": true, "description": "", "isAscending": true, "fields": "OBJECTID" }, { "name": "UUID_700", "isUnique": true, "description": "", "isAscending": true, "fields": "GlobalID" }, { "name": "S582_idx", "isUnique": true, "description": "", "isAscending": true, "fields": "Shape" } ], "editFieldsInfo": null, "supportsDatumTransformation": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 4513.9887049999998, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsUseEstimateForExceedsLimit": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "fullTextSearchCapabilities": { "supportsSqlExpressionInFullText": true, "supportsOperator": false, "supportsSearchOperator": true }, "supportsQueryWithLodSR": false, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "72e23fdd087e4b3599f05252e39d814b", "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "supportedTrueCurvePbfFeatureEncodings": [ "esriCompressedShapeBuffer", "esriDefault" ], "hasMetadata": true, "supportedAppendFormats": "FILEGDB,PBF,CSV", "tileMaxRecordCount": 8000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAYAAACNMs+9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAcElEQVQYlZ3QMQqDUBCE4Q/iJbxDriLBIq1Vau9hk5AymMITeC0liF4hBCQ8Xp4gGdhilp/d2c3sVPYvWKDEC3cMKfCCNvAVjphjsI6m5zjjEYOHRLRvLwSfuAb+s7JPgTcsOGFCg3Hr6m6tH+3+4xvvNw9LMWsUbgAAAABJRU5ErkJggg==", "yoffset": 0, "width": 7, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "f131b6766187eae9fea2a4ff655a3768", "height": 7 }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [{ "symbol": { "backgroundColor": null, "kerning": true, "color": [ 0, 0, 0, 255 ], "yoffset": 0, "xoffset": 0, "haloColor": [ 255, 255, 255, 255 ], "type": "esriTS", "borderLineColor": null, "borderLineSize": null, "horizontalAlignment": "left", "haloSize": 1, "angle": 0, "rightToLeft": false, "verticalAlignment": "bottom", "font": { "size": 8, "weight": "normal", "style": "normal", "family": "Arial", "decoration": "none" } }, "stackLabel": true, "stackRowLength": 24, "maxScale": 0, "labelExpressionInfo": {"expression": "$feature.SITE_NO"}, "deconflictionStrategy": "dynamic", "priority": -1, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "removeDuplicates": "none", "name": "Class 1", "minScale": 0, "stackAlignment": "dynamic", "useCodedValues": true }] }, "geometryField": { "modelName": "Shape", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "Shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint" }