{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Named_Intersections", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryMultipoint", "description": "

The layer was created through several steps in order to obtain a single attribute with intersecting street names. <\/SPAN><\/P>

Step 1 - Geoprocessing function CREATE ROUTES was applied to the County-wide street network in order to cull extraneous nodes.<\/SPAN><\/P>

Step 2 - The intersection function was used to create intersection points with name attribution transferred from street features. This process created unnecessary, duplicate points because a point was created for each street forming the intersection.<\/SPAN><\/P>

Step 3 - X,Y coordinate fields were added to the point layer to use in the FIND IDENTICAL function. Identical records were exported to provide a singular point layer.<\/SPAN><\/P>

Step 4 - The JOIN (one-to-one) function was used to join single intersection to the original layer with duplicates. <\/SPAN><\/P>

Step 5 - Records from the duplicate layer with NULL attributes were exported as unjoined records.<\/SPAN><\/P>

Step 6 - The unjoined records were rejoined to the single point layer in another one-to-one join.<\/SPAN><\/P>

Step 6 - Street name fields from each join were concatenated into a single field.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "copyrightText": "Murfreesboro GIS", "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "extent": { "xmin": 1814836.4594515562, "ymin": 520565.935306564, "xmax": 1870325.831412226, "ymax": 586313.0183790624, "spatialReference": { "wkid": 103152, "latestWkid": 6576, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121521300, "falseY": -93934000, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 103152, "latestWkid": 6576, "vcsWkid": 5702, "latestVcsWkid": 5702, "xyTolerance": 0.003280833333333333, "zTolerance": 0.003280833333333333, "mTolerance": 2, "falseX": -121521300, "falseY": -93934000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NGVD_1929", "heightUnit": "us-foot" }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 161, 0, 47, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 0 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "POINT_X", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POINT_X" }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POINT_Y" }, { "name": "IntRds", "type": "esriFieldTypeString", "alias": "Intersecting_Roads", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IntRds" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R275_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S219_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Named_Intersections", "description": "", "prototype": { "attributes": { "POINT_Y": null, "POINT_X": null, "IntRds": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 2000, "tileMaxRecordCount": 2000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "2f97ebca023d47e189303155475f647b" }