How should I go about making a map of alternate side of the street parking rules (in nyc?)? Does such a one already exist (I can't seem to find one)?
If anyone is familiar with the transportation rules in NYC, certain days of the week you cannot park on a specific side of the road because that side of the road is being cleaned. The location and time varies. But I am interested in overlaying a map of my home borough (Brooklyn) with specific street signs, and then coding them so that I can easily see "this is all the monday sides", "this is all the tuesday sides", "if I am looking for a parking spot on Wednesday I should look here and not there" etc.
To do this, I downloaded a couple of files from NYC Open Data https://data.cityofnewyork.us/ . The two primary data files I have are:
Parking Regulation Sign Locations - it stores information related to: BoroughCode, StatusOrderNumber, SignSequence, Distance, ArrowPoints, SignDescription
And Parking Regulation Street Segements - BoroughCode, StatusOrderNumber, MainStreet FromStreet, ToStreet, SideOfStreet.
Obviously the two tables can be joined on the basis of StatusOrderNumber. But looking at the Lion Shapefile put out by the NYC Department of City Planning, they do not keep their roads by road segments; they simply label the entire road.
My more specific question would then be:
How would I isolate a specific road segment (IE: Flatbush between 5th avenue and 8th avenue) from a road (ie: flatbush avenue) and populate it with a specific code that says 'on wednesday, there is no parking on the east side of this road segement between 11am and 1230pm?