20200316
14021100
1.0
FALSE
Holiday_Shopping_Moratorium_Street
002
6463273.652072
6512041.410180
1858363.756974
1921015.298994
1
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_California_V_FIPS_0405_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.4.0'><WKT>PROJCS["NAD_1983_StatePlane_California_V_FIPS_0405_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-118.0],PARAMETER["Standard_Parallel_1",34.03333333333333],PARAMETER["Standard_Parallel_2",35.46666666666667],PARAMETER["Latitude_Of_Origin",33.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2229]]</WKT><XOrigin>-117608900</XOrigin><YOrigin>-91881400</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102645</WKID><LatestWKID>2229</LatestWKID></ProjectedCoordinateSystem>
20260210
09252700
20260210
09252700
150000000
5000
ItemDescription
Esri ArcGIS 13.4.0.55405
Holiday_Shopping_Moratorium_Street
1
-118.325674
-118.163918
34.270919
34.098435
The original street centerline data was taken from the LA County CAMS dataset in March 2020. The data was heavily modified and the schema altered to conform to the standards of the Central Square CAD system. There are many other details, reference the attached excel document for field mappings and comments. o The documentation recommended the use of a planarized system to model streets and provide routability with the junctions of intersections having all incoming lines split. To ensure each line was split at a junction, we ran the planarize lines tool on the entire dataset and then proceeded to clean up all the address ranges which were split amongst many other checks. o There are many specific FeatureTypeCodes, however we used a more generic set of codes for each type of line segment. For example, main streets are A30, minor streets are A40, highways are A15, all ramps are A63, and alleys are A73. o Since all lines are planarized, we have added the elevation based on the CAD GIS requirements guide. Ramps, overpasses and non-connecting streets had the elevations changed. In general, city streets connect and had the ‘to elevation’ and ‘from elevation’ values set to 0,0. The highways are set to 1,1, with the exception being the on/off ramps and special locations with overpasses that needed elevations up to the number 4. Railroad elevations were set to 9, though with the FeatureTypeCode and speed limit being 0 it is not routable anyways.
o Based on another verbal recommendation from Randy, we went with detailed naming conventions for highways and particular freeway ramps (for example Fletcher Dr CA-2 N on ramp). o Roads in the mountains which are truck trails for brush clearance, or leading to towers were set with a speed limit of 0. We did this to prevent cases where a route can be generated from west Glendale to the North Glendale area since it would technically be shorter than traveling around the large mountain range in the mid-west portion of the City. These trail-roads were also setup with a FeatureTypeCode of A50 – Jeep Trail. o All one-way streets were manually setup with cross referencing other sources including Google Maps street view for accuracy. One-way streets use the value of ‘F’, all geometries for line segments were flipped and if needed the address ranges adjusted. So all lines should be going forward (start vertex to end vertex). o Standard speed limits (prima-facie) are 25 MPH with the exceptions being the streets listed on the QCode legal page. Highway standards are 65 MPH. The speed limit information for implemented Glendale streets in the dataset was taken from the legal page at the link: http://www.qcode.us/codes/glendale/?view=desktop&topic=10-10_24-10_24_020
o Alleys were kept in the dataset and named accordingly (ALLEY). We kept driveways which led to houses that were not visible off the main street since this may be useful for police personnel to see. o In general, we have standardized on all letters being capitalized throughout all the datasets for CAD.
Police Department Computer Aided Dispatch CAD Street Centerline
Enterprise Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
Holiday_Shopping_Moratorium_Street
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
ExternalStreetKey
ExternalStreetKey
String
36
0
0
StreetName
StreetName
String
150
0
0
LeftFromAddress
LeftFromAddress
Integer
4
10
0
LeftToAddress
LeftToAddress
Integer
4
10
0
RightFromAddress
RightFromAddress
Integer
4
10
0
RightToAddress
RightToAddress
Integer
4
10
0
LParity
LParity
String
1
0
0
RParity
RParity
String
1
0
0
LeftCityCode
LeftCityCode
String
10
0
0
RightCityCode
RightCityCode
String
10
0
0
LeftState
LeftState
String
3
0
0
RightState
RightState
String
3
0
0
SHAPE
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
LeftCountyCode
LeftCountyCode
String
5
0
0
LeftZipCode
LeftZipCode
String
10
0
0
RightZipCode
RightZipCode
String
10
0
0
RightCountyCode
RightCountyCode
String
5
0
0
FeatureTypeCode
FeatureTypeCode
String
3
0
0
SpeedLimit
SpeedLimit
SmallInteger
2
5
0
OneWayCode
OneWayCode
String
1
0
0
ToElevation
ToElevation
SmallInteger
2
5
0
FromElevation
FromElevation
SmallInteger
2
5
0
LeftCityName
LeftCityName
String
50
0
0
RightCityName
RightCityName
String
50
0
0
LeftCountyName
LeftCountyName
String
50
0
0
RightCountyName
RightCountyName
String
50
0
0
Duration
Duration
String
255
0
0
Comment
Comment
String
255
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20260210