Specialty Lighting (SpecialtyLighting)Specialty Lighting (SpecialtyLighting)
by DC, Department of Transportation. OSAT on 7//20/01/0
Keywords
About:
transportation, location, Station, Traffic Count, Traffic, Count, signalSign
Taking place at:
Washington, D.C., District of Columbia, DC, DC GIS, DCGIS
Abstract
Street Light Poles. The dataset contains locations and attributes of street lights, created as part of the District of Columbia, Department of Transportation (DDOT) Street Spatial Database (SSD).
A database provided by the District of Columbia, Department of Transportation identified Street Lights.
All DC GIS data is stored and exported in Maryland State Plane coordinates NAD 83 meters.
METADATA CONTENT IS IN PROCESS OF VALIDATION AND SUBJECT TO CHANGE.
Purpose
This data is used for the planning and management of Street Lights - Assets, Activities, Incidents, as well as the maintenance of Street Light Features of the District of Columbia, Department of Transportation (DDOT).
Access constraints
Contact DDOT / OCTO GIS. Any data obtained outside of DDOT / OCTO GIS are unauthorized copies.
Use constraints
Acknowledgment of the DC Geographic Information Systems Program (DC GIS). The District of Columbia Government makes no claims as to the completeness, accuracy or content of any data contained hereon, and makes no representation of any kind, including, but not limited to, the warranty of the accuracy or fitness for a particular use, nor are any such warranties to be implied or inferred with respect to the information or data furnished herein.
Point of contact
Markos K. Yeterawork
in DC Department of Transportation, Operational Support and Applied Technology (OSAT) - Spatial Data Systems Division
64 New York Ave NE
Washington DC, 20002, USA
phone: (202) 741-5391
fax: (202) 727-5660
hours: 8:30 am - 5 pm
Credits
District of Columbia, Department of Transportation.
Operational Support and Applied Technology (OSAT) - Spatial Data Systems.
Data accuracy
Accuracy
Osmose will achieve 95% attribute accuracy on a maximum 10% random sample in order for data to be deemed acceptable. Collected attributes will be evaluated against field conditions and the calculation of accuracy will be based on total countable collected attributes. Streetlight attributes will be quality controlled to an accuracy of 95% based on each counted attribute receiving equal weight. Attributes collected are as follows:
TSALIGHTID
PEPCOLIGHTID
LIGHTTYPE
WATTAGE
POLETYPE
POLESTYLE
POLEHEIGHT
POWERFEED
NUMBERARMS
ARMLENGTH
FIXTURE
CORNER
PROXIMITY
HOUSENO
STREETNAME
QUADRANT
STREETNAME1
ROADTYPE
OWNER
WARD
COMMENTS
XCOORDINAT
YCOORDINAT
Logical consistency
Streetlight poles (where applicable) in wards 1-8 are tagged with a unique TSALIGHTID with the following formats:
WARD 1-3 and 5-8, a 5 digit numeric - NNNNN - where the first number = the ward number and the next 4 digits are sequential from 0001 to 9999.
Example:
WARD 1
10001
10002
WARD 4: 5 digit alphanumeric - NANNN - where the first number = 4 for Ward 4, the second letter is alpha beginning with A and the next 3 digits are sequential from 001 to 999 as follows:
4A001 to 4A999
4B001 to 4B999
4C001 to 4C999
4D001 to 4D999
4E001 to 4E999
4F001 to 4F999
4G001 to 4G999
4H001 to 4H999
4J001 to 4J999
4K001 to 4K999
4L001 to 4L999
Pole numbering information for joint use poles owned by others such as PEPCO and Verizon utilizes the same numbering convention as described above except a 7 digit number will be employed where the LAST two digits are always DC. Where the first number represents the Ward # and the next 4 digits are sequential from 0001 to 9999. Example - 10001DC - 19999DC
Pole tags are affixed at 14 ft above ground facing a road. If it is impossible due to obstructions or unforeseen circumstances, Osmose will affix the pole tag in an alternative place and note it in the data.
Streetlight poles are placed relative to the DDOT road network and have their XCOORDINAT and YCOORDINAT fields populated with the collected sub-meter X and Y coordinates in the NAD83 Maryland State Planes Meter coordinate system.
Completeness
Osmose performed an inventory of streetlights on 50,000 - 65,000 poles within the District of Columbia. The inventory was conducted in all of the Washington DC wards excluding ward 1 and part of ward 3. The streetlight inventory includes the following items:
The collection of pole and streetlight attribute information as described in the Attribute Accuracy section of the Data Quality tab.
The collection of sub-meter GPS on streetlight poles as described in the Positional Accuracy section of the Data Quality tab.
The installation of plastic tags on all streetlight poles as described in the Logical Consistency Report section above.
Horizontal positional accuracy
All light poles are inventoried and placed relative to DDOT's source road network. A sub-meter gps point is taken for each light pole with the exclusion of underpasses and tunnels. Each sub-meter gps point is stored in Trimble formatted .SSF files. The .SSF files are differentially corrected and exported to the NAD83 Maryland State Planes Meter coordinate system using Trimble's GPS Pathfinder Office software program. The XCOORDINAT and YCOORDINAT fields contain the sub-meter gps X and Y coordinates respectively.
Vertical positional accuracy
Not inventoried.
Lineage / Sources
Lineage / Processes
in Osmose Utilities Services, Inc.
5703 B Enterprise Pkwy
East Syracuse New York, 13057, United States
phone: 315-385-3800
|
The QA/QC process is based on a FastGate Mobile application configured for use on the Severn Construction Services streetlight inventory project. FastGate Mobile data collection software is programmed in such a way as to reduce the potential for error. The mobile software will contain verification routines to support the accurate and complete collection of data. These validations and quality control tools are programmed into FastGate Mobile to alert technicians of data collection rule violations during collection and to provide an environment for objective field quality assurance after collection.
In order to achieve high levels of data accuracy, Osmose has developed a controlled QA/QC process that uses the same FastGate Mobile technology and project specific data model in a separate quality control mode. This allows the task of Quality Control to be performed in a repeatable and controlled manner consistent with the data rules of the project using the same technology.
|
in Osmose Utilities Services, Inc.
5703 B Enterprise Pkwy
East Syracuse New York, 13057, United States
phone: 315-385-3800
| After a completed workpacket has been handed to the field supervisor from the field collector, the Quality Control group will be given the work set. Using the same FastGate Mobile application put in "QC Mode", the software will randomly sample (up to 10%) poles in each work set per field technician. These workpackets will be the basis of the lot size for the quality control. Each pole in the sample set will be visited by the QC group, and the assets collected during the initial inventory will be verified. |
in Osmose Utilities Services, Inc.
5703 B Enterprise Pkwy
East Syracuse New York, 13057, United States
phone: 315-385-3800
| Collected attributes will be evaluated against field conditions. Osmose has integrated a FastGate Mobile Data Validation Application that automatically takes data collected by the field technician and compares it to the randomly selected data verified by the Quality Control group. |
in Osmose Utilities Services, Inc.
5703 B Enterprise Pkwy
East Syracuse New York, 13057, United States
phone: 315-385-3800
| The application then performs an analysis that determines the quantity of any errors found for each required attribute. A report for each work packet is also generated. The Quality Control group will use this report to pass or fail an individual work packet. Failed workpackets will be sent back to the field technician to be corrected. |
in Osmose Utilities Services, Inc.
5703 B Enterprise Pkwy
East Syracuse New York, 13057, United States
phone: 315-385-3800
| Osmose will achieve 95% overall accuracy on the random sample (up to 10%) in order for data to be deemed acceptable. The calculation of accuracy will be based on total countable attributes collected or verified in the field. |
in Osmose Utilities Services, Inc.
5703 B Enterprise Pkwy
East Syracuse New York, 13057, United States
phone: 315-385-3800
| Osmose will respond to rejected work sets by (1) examining the root cause of the problem and (2) requiring the field collection team to correct the information to reach the appropriate level of quality standards. A root cause method looks at the reason for the failure, if the majority of the errors are caused by the same attribute, and then only that attribute needs to be corrected. The work set will undergo another round of Quality Control prior to re-delivery to Severn Construction Services only if no root cause is identified. |
Distribution
Contact DDOT/TSA
Distribution liability
Acknowledgment of the DC Geographic Information Systems Program (DC GIS). The District of Columbia Government makes no claims as to the completeness, accuracy or content of any data contained hereon, and makes no representation of any kind, including, but not limited to, the warranty of the accuracy or fitness for a particular use, nor are any such warranties to be implied or inferred with respect to the information or data furnished herein.
Distributed by
Markos K. Yeterawork
in D.C. Department of Transportation. Operation Support and Applied Technology (OSAT) - Spatial Systems Division
2000 14th Street NW, 5th Floor
Washington DC, 20009, USA
phone: (202) 671 2123
fax: (202) 727-5660
hours: 8:30 am - 5 pm
Entity
DCGIS.SpecialtyLighting / District of Columbia, Department of Transportation
StreetLight is the point geometry that represents DDOT Street Lights
Attributes
- SHAPE / ESRI
Feature geometry. - OBJECTID / ESRI
Internal feature number. - TSALIGHTID
Unique TSA street light id - SOURCEID
Identifier of Street Segment in legacy system - SQUAREID
Property Square ID - LIGHTTYPE
Type of Light - WATTAGE
Wattage of light - POLETYPE
Type of Pole - POLEHEIGHT
Height of pole - POLESTYLE
Style of Pole - POWERFEED
Power feed type - NUMBERARMS
Number of arms of the light pole - ARMLENGTH
The arm length of the light pole - Shape / ESRI
Feature geometry - MODIFIEDDATE
Date modified - XCOORDINAT
- PROXIMITY
Proximity of light - CORNER
Description of corner - FIXTURE
Type of fixture - HOUSENO
House no - STREETNAME
Street Name - OWNER
Street light owner - WARD
Ward - MODIFIEDBY
Modified by - COMMENTS
Additional Comments - YCOORDINAT
- QUADRANT
- STREETNAME1
- ROADTYPE
- TYPE
Metadata
FGDC Content Standards for Digital Geospatial Metadata / FGDC-STD-001-1998 as of 05/09/2008
Provided by
Markos Yeterawork
in DDOT
64 New York Ave, NE
Washington DC, 20002, USA
phone: (202) 741-5391
hours: 9:00 am - 5 pm