{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 91, "name": "Sidewalk Segments", "type": "Feature Layer", "description": "(August 22, 2017, C.Yang). Add Sidewalk.(August 24, 2017, C.Yang). Add Sidewalk.(August 15, 2017, A.Caldwell). Pedestrian Traffic field set to high for only those sidewalks denoted as High Traffic Areas by Jeff Klochnyk (Sidewalk_Inspection_29Mar2017.pdf); everything else set as NULL. Also, added MJRRDNETWORK \"Major Road Network\" field as a 1 character string.(September 6, 2017, A.Caldwell). Pedestrian Traffic field recreated as a 1-character String for H, M, L & NULL options. SEGKEY & COMPLEXKEY were recreated as integers from strings; only SEGKEY had any data.(September 7, 2017, A.Caldwell). Using the Sept 6 file - The Major Road Networkds field was re-created as a 1 character string (to match IPS) and then the Length field was switched from Integer to Double to match IPS field type. All of the recreated fields (Sept 6&7) needed to be properly re-ordered back so the Make Query Table tool was run on so that the Python Snipet of that tool could be manually adjusted to re-order the fields and then run in the Python window. A Copy Feature tool was then used to write the corrected file back into the Sidewalk File Geodatabase. Add UNITID values using the new ordered ObjectID field. Remove one record of lenght 0m. Set UNITTYPE to be the IPS Code values instead of the full Descriptions; this is because GeoAdmin defaults to matching to the Code field and the Code field length is too short to handle the full Descriptions.(September 8, 2017, C.Yang). Added segment attribute data and construction dates. The construction dates are still in review, an email was sent to Jeff.(September 19, 2017, C.Yang) Jeff confirmed construction dates. Sidewalk types were edited, based on 2017 orthophoto some sidewalks became MUP.(September 20, 2017, C.Yang) New Green Necklace MUP through Grand Blvd Park is added. (October 2, 2017, C. Yang) Updated construction dates of MUP. Reviewed and added details in the description field. Added bike path along Grand Blvd.(October 3, 2017, C. Yang) As per the meeting help on Octorber 2, all Spirit Trail and Green Necklace Trails will not be included and have STATUS Removed. Shipyard sidewalks are changed to UNITTYPE Curb. All MUPs are removed. (October 24, 2017, C. Yang) Any outstanding sidewalks missing widths were completed along with a two trail segments that were missing a Block_Street value.(October 24, 2017, A. Caldwell) All of the sidewalks in Tempe Heights had the Removed status set back to Null and pushed to IPS so that they will be included in the SW project again.(October 25, 2017, A. Caldwell) Adjust all block stree values to have the numbers by the hundreds (ie 100 instead of 110); added the work \"Block\" as a prefix. Set all comments for Tempe Heights entities to be \"Tempe Heights\" from Private Sidewalks.(November 21, 2017, A. Caldwell) Updated the Segment ID for the two sidewalks on the cul de sac beside the road for Block 700 W 3RD. The UNITID field was reordered by sorting based on Existing (and within this by UNITID) and then Removed & Proposed (and within this by UNITID). The [COMPKEY] field was set to NULL, and all Proposed and Removed sidewalks had their [COMPTYPE] set to NULL to ensure they will not unintentionally be added to IPS later. At this point testing in the IPS Yard database was complete so the reordering was in preparation for load into the IPS production database (Note these UNITIDs were again recreated on Nov22).(November 22, 2017, A. Caldwell) On this date all of the sidwalks with Existing [STATUS] were loaded into IPS. Prior to the load, the ArcToolbox SORT tool was used to re-order the [OBJECTID] field based on Descending [STATUS] and Ascending [UNITID]. Next, all sidewalks with a Removed [STATUS] were set as Proposed. Then, the UNITIDs were recreated based on the new [OBJECTID]. Then, the [STATUS] of all existing sidwalks was changed from NULL to Existing since there had been no values actually stating those sidealks were existing up to this point. [COMMENTS] set all blanks to NULL, [MATERIAL_TYPE] set Bricks to Brick, [SIDE_OF_STREET] set w as W, Correct [SEGMENT] value for SWK-1836v0 which had a disposed street associated to it.(November 24, 2017, A. Caldwell) Updated a number of [SEGMENT] values for sidewalks where paving was done. As well, set all [CREATE_SOURCE] values to Null as they had been CONTRB to this point.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 26910, "latestWkid": 26910, "vcsWkid": 115702, "latestVcsWkid": 115702, "xyTolerance": 1.0E-4, "zTolerance": 1.0E-4, "mTolerance": 1.0E-4, "falseX": -5120900, "falseY": -9998100, "xyUnits": 20000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "ellipsoidal", "vertCRS": "NAD_1983", "heightUnit": "meter" }, "copyrightText": "C. Yang & A. Caldwell", "parentLayer": { "id": 88, "name": "Streets" }, "subLayers": [], "minScale": 5000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "UNITTYPE", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 38, 115, 0, 255 ], "width": 2 }, "value": "MUP", "label": "Multi-use path" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 0, 255, 0, 255 ], "width": 1 }, "value": "Boulevard", "label": "Sidewalk" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 0, 255, 0, 255 ], "width": 1 }, "value": "Bridge", "label": "Sidewalk" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 0, 255, 0, 255 ], "width": 1 }, "value": "Curb", "label": "Sidewalk" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 0, 255, 0, 255 ], "width": 1 }, "value": "Landing", "label": "Sidewalk" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 0, 255, 0, 255 ], "width": 1 }, "value": "Path", "label": "Sidewalk" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 0, 255, 0, 255 ], "width": 1 }, "value": "Stair", "label": "Sidewalk" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 0, 255, 0, 255 ], "width": 1 }, "value": "Trail", "label": "Sidewalk" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 204, 192, 252, 255 ], "toColor": [ 204, 192, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 188, 255 ], "toColor": [ 182, 252, 188, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 201, 179, 255 ], "toColor": [ 252, 201, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 241, 252, 255 ], "toColor": [ 184, 241, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 212, 255 ], "toColor": [ 252, 182, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 244, 182, 255 ], "toColor": [ 252, 244, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 252, 219, 255 ], "toColor": [ 212, 252, 219, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 238, 215, 255 ], "toColor": [ 252, 238, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 251, 187, 252, 255 ], "toColor": [ 251, 187, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 222, 252, 255 ], "toColor": [ 215, 222, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 251, 215, 252, 255 ], "toColor": [ 251, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 204, 216, 255 ], "toColor": [ 252, 204, 216, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 225, 252, 189, 255 ], "toColor": [ 225, 252, 189, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -5120900, "ymin": -9998100, "xmax": 497220.8457000004, "ymax": 5464772.024499999, "spatialReference": { "wkid": 26910, "latestWkid": 26910, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5426530.616185, "falseY": -1.1044296713775001E7, "xyUnits": 3.9133954690553886E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "UNITID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "UNITID", "type": "esriFieldTypeString", "alias": "UNITID", "length": 10, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 12, "domain": { "type": "codedValue", "name": "WS2_dENG_Status", "description": "", "codedValues": [ { "name": "Existing", "code": "Existing" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Proposed", "code": "Proposed" }, { "name": "Severed", "code": "Severed" }, { "name": "Superseded", "code": "Superseded" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPKEY", "type": "esriFieldTypeInteger", "alias": "COMPKEY", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 300, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 300, "domain": null }, { "name": "BLOCK_STREET", "type": "esriFieldTypeString", "alias": "BLOCK_STREET", "length": 50, "domain": null }, { "name": "MAPNO", "type": "esriFieldTypeString", "alias": "MAPNO", "length": 14, "domain": null }, { "name": "UNITTYPE", "type": "esriFieldTypeString", "alias": "UNITTYPE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_dENG_SidewalkTypes", "description": "Sidewalk types for sidewalk centrelines (Hansen assets)", "codedValues": [ { "name": "Boulevard sidewalk", "code": "Boulevard" }, { "name": "Bridge", "code": "Bridge" }, { "name": "Curb sidewalk", "code": "Curb" }, { "name": "Landing", "code": "Landing" }, { "name": "Multi-use path", "code": "MUP" }, { "name": "Pathway", "code": "Path" }, { "name": "Stair", "code": "Stair" }, { "name": "Trail", "code": "Trail" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL_TYPE", "type": "esriFieldTypeString", "alias": "MATERIAL_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_dENG_SidewalkMaterial", "description": "Material types for sidewalks", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Brick", "code": "Brick" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Dirt", "code": "Dirt" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Pavers", "code": "Pavers" }, { "name": "Wood", "code": "Wood" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIDE_OF_STREET", "type": "esriFieldTypeString", "alias": "SIDE_OF_STREET", "length": 1, "domain": { "type": "codedValue", "name": "WS2_dGIS_CompassDirection", "description": "Compass direction (north, south, east, west)", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PEDESTRIAN_TRAFFIC", "type": "esriFieldTypeString", "alias": "PEDESTRIAN_TRAFFIC", "length": 1, "domain": null }, { "name": "MJRRDNETWORK", "type": "esriFieldTypeString", "alias": "Major Road Network", "length": 1, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null }, { "name": "WIDTH_M", "type": "esriFieldTypeDouble", "alias": "WIDTH_M", "domain": { "type": "codedValue", "name": "WS2_dENG_SidewalkWidth", "description": "Widths of sidewalks", "codedValues": [ { "name": "1.2", "code": 1.2 }, { "name": "1.5", "code": 1.5 }, { "name": "1.8", "code": 1.8 }, { "name": "2.0", "code": 2 }, { "name": "3.0", "code": 3 }, { "name": "4.0", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONSTRUCTED_DATE", "type": "esriFieldTypeDate", "alias": "CONSTRUCTED_DATE", "length": 8, "domain": null }, { "name": "CONSTRUCTED_YEAR", "type": "esriFieldTypeString", "alias": "CONSTRUCTED_YEAR", "length": 10, "domain": null }, { "name": "SEGMENT", "type": "esriFieldTypeInteger", "alias": "SEGMENT", "domain": null }, { "name": "COMPLEX", "type": "esriFieldTypeInteger", "alias": "COMPLEX", "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "OWNER", "length": 50, "domain": null }, { "name": "GEOM_SOURCE", "type": "esriFieldTypeString", "alias": "GEOM_SOURCE", "length": 25, "domain": { "type": "codedValue", "name": "WS2_dENG_GeomSource", "description": "", "codedValues": [ { "name": "AsBuilt - Survey", "code": "AsBuilt - Survey" }, { "name": "AsBuilt - Drawing", "code": "AsBuilt - Drawing" }, { "name": "Record Drawing", "code": "Record Drawing" }, { "name": "Design Drawing", "code": "Design Drawing" }, { "name": "Aerial Photo", "code": "Aerial Photo" }, { "name": "GPS", "code": "GPS" }, { "name": "Offset", "code": "Offset" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Field", "code": "Field" }, { "name": "Sketch", "code": "Sketch" }, { "name": "Null", "code": "Null" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEOM_REFERENCE", "type": "esriFieldTypeString", "alias": "GEOM_REFERENCE", "length": 50, "domain": null }, { "name": "GIS_GEOM_DATE", "type": "esriFieldTypeDate", "alias": "GIS_GEOM_DATE", "length": 8, "domain": null }, { "name": "ATTR_SOURCE", "type": "esriFieldTypeString", "alias": "ATTR_SOURCE", "length": 25, "domain": { "type": "codedValue", "name": "WS2_dENG_AttrSource", "description": "", "codedValues": [ { "name": "AsBuilt - Survey", "code": "AsBuilt - Survey" }, { "name": "AsBuilt - Drawing", "code": "AsBuilt - Drawing" }, { "name": "Record Drawing", "code": "Record Drawing" }, { "name": "Design Drawing", "code": "Design Drawing" }, { "name": "Other Document", "code": "Other Document" }, { "name": "Aerial Photo", "code": "Aerial Photo" }, { "name": "GPS", "code": "GPS" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Field", "code": "Field" }, { "name": "Sketch", "code": "Sketch" }, { "name": "Null", "code": "Null" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ATTR_REFERENCE", "type": "esriFieldTypeString", "alias": "ATTR_REFERENCE", "length": 50, "domain": null }, { "name": "GIS_ATTR_DATE", "type": "esriFieldTypeDate", "alias": "GIS_ATTR_DATE", "length": 8, "domain": null }, { "name": "CREATE_SOURCE", "type": "esriFieldTypeString", "alias": "CREATE_SOURCE", "length": 25, "domain": { "type": "codedValue", "name": "WS2_dENG_CreateSource", "description": "Reference to origin of the feature", "codedValues": [ { "name": "CNV Project", "code": "CNV Project" }, { "name": "CNV Operational", "code": "CNV Operational" }, { "name": "Contributed", "code": "Contributed" }, { "name": "Donated", "code": "Donated" }, { "name": "Found", "code": "Found" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Contributed", "code": "Contrib" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATE_REFERENCE", "type": "esriFieldTypeString", "alias": "CREATE_REFERENCE", "length": 50, "domain": null }, { "name": "GIS_CREATION_DATE", "type": "esriFieldTypeDate", "alias": "GIS_CREATION_DATE", "length": 8, "domain": null }, { "name": "GIS_EDIT_DATE", "type": "esriFieldTypeDate", "alias": "GIS_EDIT_DATE", "length": 8, "domain": null }, { "name": "GIS_EDITOR", "type": "esriFieldTypeString", "alias": "GIS_EDITOR", "length": 50, "domain": null }, { "name": "COMPTYPE", "type": "esriFieldTypeSmallInteger", "alias": "COMPTYPE", "domain": null }, { "name": "GISSTATIC", "type": "esriFieldTypeString", "alias": "GISSTATIC", "length": 50, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "LOCATION_AREA", "type": "esriFieldTypeString", "alias": "LOCATION_AREA", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1459_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1459", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1459", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1422_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1695575526000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }