Parent Layer: Streets

Name: Sidewalk Segments

Display Field: UNITID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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.

Copyright Text: C. Yang & A. Caldwell

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -5120900
YMin: -9998100
XMax: 497220.8457000004
YMax: 5464772.024499999
Spatial Reference: 26910  (26910)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: UNITTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: MUP
  Label: Multi-use path
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [38, 115, 0, 255]
  Width: 2
• Value: Boulevard
  Label: Sidewalk
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [0, 255, 0, 255]
  Width: 1
• Value: Bridge
  Label: Sidewalk
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [0, 255, 0, 255]
  Width: 1
• Value: Curb
  Label: Sidewalk
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [0, 255, 0, 255]
  Width: 1
• Value: Landing
  Label: Sidewalk
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [0, 255, 0, 255]
  Width: 1
• Value: Path
  Label: Sidewalk
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [0, 255, 0, 255]
  Width: 1
• Value: Stair
  Label: Sidewalk
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [0, 255, 0, 255]
  Width: 1
• Value: Trail
  Label: Sidewalk
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [0, 255, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• UNITID ( type: esriFieldTypeString, alias: UNITID, length: 10 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 12 , Coded Values: [Existing: Existing] , [Abandoned: Abandoned] , [Removed: Removed] , ...3 more... )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 300 )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 300 )
• BLOCK_STREET ( type: esriFieldTypeString, alias: BLOCK_STREET, length: 50 )
• MAPNO ( type: esriFieldTypeString, alias: MAPNO, length: 14 )
• UNITTYPE ( type: esriFieldTypeString, alias: UNITTYPE, length: 50 , Coded Values: [Boulevard: Boulevard sidewalk] , [Bridge: Bridge] , [Curb: Curb sidewalk] , ...5 more... )
• MATERIAL_TYPE ( type: esriFieldTypeString, alias: MATERIAL_TYPE, length: 50 , Coded Values: [Asphalt: Asphalt] , [Brick: Brick] , [Concrete: Concrete] , ...4 more... )
• SIDE_OF_STREET ( type: esriFieldTypeString, alias: SIDE_OF_STREET, length: 1 , Coded Values: [N: North] , [S: South] , [E: East] , ...1 more... )
• PEDESTRIAN_TRAFFIC ( type: esriFieldTypeString, alias: PEDESTRIAN_TRAFFIC, length: 1 )
• MJRRDNETWORK ( type: esriFieldTypeString, alias: Major Road Network, length: 1 )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
• WIDTH_M ( type: esriFieldTypeDouble, alias: WIDTH_M , Coded Values: [1.2: 1.2] , [1.5: 1.5] , [1.8: 1.8] , ...3 more... )
• CONSTRUCTED_DATE ( type: esriFieldTypeDate, alias: CONSTRUCTED_DATE, length: 8 )
• CONSTRUCTED_YEAR ( type: esriFieldTypeString, alias: CONSTRUCTED_YEAR, length: 10 )
• SEGMENT ( type: esriFieldTypeInteger, alias: SEGMENT )
• COMPLEX ( type: esriFieldTypeInteger, alias: COMPLEX )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 50 )
• GEOM_SOURCE ( type: esriFieldTypeString, alias: GEOM_SOURCE, length: 25 , Coded Values: [AsBuilt - Survey: AsBuilt - Survey] , [AsBuilt - Drawing: AsBuilt - Drawing] , [Record Drawing: Record Drawing] , ...8 more... )
• GEOM_REFERENCE ( type: esriFieldTypeString, alias: GEOM_REFERENCE, length: 50 )
• GIS_GEOM_DATE ( type: esriFieldTypeDate, alias: GIS_GEOM_DATE, length: 8 )
• ATTR_SOURCE ( type: esriFieldTypeString, alias: ATTR_SOURCE, length: 25 , Coded Values: [AsBuilt - Survey: AsBuilt - Survey] , [AsBuilt - Drawing: AsBuilt - Drawing] , [Record Drawing: Record Drawing] , ...8 more... )
• ATTR_REFERENCE ( type: esriFieldTypeString, alias: ATTR_REFERENCE, length: 50 )
• GIS_ATTR_DATE ( type: esriFieldTypeDate, alias: GIS_ATTR_DATE, length: 8 )
• CREATE_SOURCE ( type: esriFieldTypeString, alias: CREATE_SOURCE, length: 25 , Coded Values: [CNV Project: CNV Project] , [CNV Operational: CNV Operational] , [Contributed: Contributed] , ...5 more... )
• CREATE_REFERENCE ( type: esriFieldTypeString, alias: CREATE_REFERENCE, length: 50 )
• GIS_CREATION_DATE ( type: esriFieldTypeDate, alias: GIS_CREATION_DATE, length: 8 )
• GIS_EDIT_DATE ( type: esriFieldTypeDate, alias: GIS_EDIT_DATE, length: 8 )
• GIS_EDITOR ( type: esriFieldTypeString, alias: GIS_EDITOR, length: 50 )
• COMPTYPE ( type: esriFieldTypeSmallInteger, alias: COMPTYPE )
• GISSTATIC ( type: esriFieldTypeString, alias: GISSTATIC, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• LOCATION_AREA ( type: esriFieldTypeString, alias: LOCATION_AREA, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata