Sign Code and Data QC
Needs Consolidation/De-duplication
The below table captures a listing of sign codes that are effectively duplicates of each other (the left column). Once the decision is made, we will migrate existing types to the destination code (right column)
| Sign Type | Duplicate Codes | Destination Code | Date of Migration |
|---|---|---|---|
| No Parking Entrance | r-ns-038 r-dc-no_park_entrance_times r-dc-npentrance | r-dc-no_park_entrance_times | Â |
| No Standing Or Parking | r-ns-006 (No Standing or Parking w/times) *pic includes tow away r-ns-247 (No Standing or Parking times and arrows) *no pic, may not include tow away r-dc-nsnp (No Standing No Parking) *pic is of Tow Away No Standing or Parking with times and space for an arrow | r-dc-nsnp | Â |
| No Standing or Parking Anytime | r-ns-011 (Tow Away No Standing or Parking Anytime w/arrow) r-ns-307 (No Standing or Parking Anytime w/arrow) **not sure these are the same, since one says tow away and the other does not, so could be distinct | r-ns-011 | Â |
| Newer Pay-to-Load Loading Zones with ID | R-DC-Loading_Zone_With_Parkmobile_Zone R-NS-LZPPTL R-DC-LZPTL R-NS-LZPTL ?? Not sure if there's an issue, but the last two definitely have nearly identical descriptions (Loading Zone Permit or Pay to Load) and pay to load kind of implies a zone | r-ns-lzptl | Â |
| Older Loading Zone Signs | r-ns-007 r-ns-026 r-ns-148 r-ns-old r-ns-lzold r-dc-lzold | r-dc-lzold | Â |
| Metro No Standing | R-NS-059: NO STANDING METRO BUS ZONE R-NS-363: TOW AWAY NO STANDING METRO BUS ZONE / NO STANDING R-DC-NSMETRO: NO STANDING METRO BUS ZONE | r-dc-nsmetro | Â |
| Metro No Standing No Parking | r-ns-019 r-dc-nsnpmetro | r-dc-nsnpmetro | Â |
No parking anytime except | R-NS-185 R-NS-213 | R-NS-185 | Â |
| No littering | O-NS-040 R-NS-194 |
Data tweaks
| Data Issue | Correction Needed | Date of Fix |
|---|---|---|
| Park Mobile Zone ID #s in Zone ID field | Remove from Zone ID field *Note:Â Added to Sign Text field | Â |
| Migrate generic R6-2 | Update R6-2 to R6-2L/R *Note: The arrow direction was used as a determining factor when choosing between l and r. 38 records remained which did |  |
| Migrate generic R3-5 | Update R3-5 to R3-5L/R *Note: Similar to R6-2, the arrow direction was used to choose which new type to assign. 46 remained which did not have an arrow direction and those were assigned a default of R3-5L (left) |  |
| Migrate R-NS-019 to R-NS-356 | *Note:Â Already addressed above | Â |
| Migrate generic W16-7P | Update to either W16-7PL or W16-7PR *Note: Similar to R6-2, the arrow direction was used to choose which new type to assign. 248 remained which did not have an arrow direction and those were assigned a default of W16-7PL (left) |  |