Home
Storm Water Projects
Drainage & Flooding
Pollution Prevention
Fees & Billing
Volunteer
Storm Water A-Z
Print this PageSite Feedback
   
Metadata: Storm Water Infrastructure Structures
stm.DBO.StormStructure_pt

Frequently-anticipated questions:


What does this data set describe?

Title: stm.DBO.StormStructure_pt

Abstract: Inventoried structures in Mecklenburg County

  1. How should this data set be cited?

Charlotte-Mecklenburg Storm Water Services Agency

  1. What geographic area does the data set cover?

West_Bounding_Coordinate: -81.013724

East_Bounding_Coordinate: -80.602095

North_Bounding_Coordinate: 35.511173

South_Bounding_Coordinate: 35.015475

  1. What does it look like?
  2. Does the data set describe conditions during a particular time period?

Calendar_Date: 2004 forward

Currentness_Reference: publication date

  1. What is the general form of this data set?

Geospatial_Data_Presentation_Form: vector digital data

  1. How does the data set represent geographic features?
    1. How are geographic features stored in the data set?

This is a Vector data set. It contains the following vector data types (SDTS terminology):

      • Entity point (112348)
    1. What coordinate system is used to represent geographic features?

The map projection used is Lambert Conformal Conic.

Projection parameters:

Standard_Parallel: 34.333333

Standard_Parallel: 36.166667

Longitude_of_Central_Meridian: -79.000000

Latitude_of_Projection_Origin: 33.750000

False_Easting: 2000000.002617

False_Northing: 0.000000

Planar coordinates are encoded using coordinate pair
Abscissae (x-coordinates) are specified to the nearest 0.000625
Ordinates (y-coordinates) are specified to the nearest 0.000625
Planar coordinates are specified in survey feet

The horizontal datum used is North American Datum of 1983.
The ellipsoid used is Geodetic Reference System 80.
The semi-major axis of the ellipsoid used is 6378137.000000.
The flattening of the ellipsoid used is 1/298.257222.

Vertical_Coordinate_System_Definition:

Altitude_System_Definition:

Altitude_Resolution: 1.000000

Altitude_Encoding_Method:

Explicit elevation coordinate included with horizontal coordinates

  1. How does the data set describe geographic features?

stm.DBO.StormStructure_pt

OBJECTID

Internal feature number. (Source: ESRI)

Sequential unique whole numbers that are automatically generated.

MAT_TEXT

Other material if not listed in domain (Source: City of Charlotte Storm Water)

Other material

INV_DATE

Date of inventory collection (Source: City of Charlotte Storm Water)

Date of inventory collection

TOP_ELEVAT

Auto generated top elevation (Source: City of Charlotte Storm Water)

Auto generated top elevation

EASTING

X coordinate (Source: GPS)

Auto populated X coordinate

NORTHING

Y coordinate (Source: GPS)

Auto populated Y coordinate

INVERT

Elevation depth (Source: City of Charlotte Storm Water)

Elevation depth

Enabled

Features geometry (Source: ESRI)

Coordinates defining feature

INV_BY

Person who collected feature (Source: City of Charlotte Storm Water)

Value

Definition

Ackerman

 

Alzate

 

Ballard

 

Belcher

 

Bird

 

Bissette

 

Bost

 

Broome

 

BrownSC

 

CampbellBR

 

Clapp

 

ColeB

 

Crigler

 

Deans

 

Dressler

 

Drzewiecki

 

EdwardsJE

 

Ganzert

 

Gladys

 

Gunter

 

Hardison

 

Honeycutt

 

HudsonJS

 

Knight

 

Mamar

 

MartinMW

 

McCullough

 

MeckCty

 

MillerGK

 

New Insp

New Inspector (add name to domain)

Pilipovic

 

Rockwell

 

RogersJW

 

Washington

 

WillisSL

 

Woods

 

Contract01

Contract Crew 01

Contract 02

Contract Crew 02

Contract 03

Contract Crew 03

Contract 04

Contract Crew 04

SIC_CODE

WQ field for type of facility close to where outfall is located (Source: City of Charlotte Storm Water)

WQ code

DEPTH

Depth of feature (Source: City of Charlotte Storm Water)

Depth of feature

NOTES

Notes referring to feature (Source: City of Charlotte Storm Water)

Notes

NODE_ID

ID for structure (Source: City of Charlotte Storm Water)

ID for structure

ENABLED

Feature geometry. (Source: ESRI)

Coordinates defining the features.

MATERIAL

Structure material (Source: City of Charlotte Storm Water)

Value

Definition

Grouted RR

Grouted riprap

Brick

Brickwork

Concrete_Reinf

Concrete Reinforced

Concrete Block

Concrete Block

RCP

Concrete Pipe

CMP

Corrugated Metal or Steel

HPDE

Plastic Pipe

Stone

Stone/gravel

VCP

Vitrified Clay

Earthen

Earthen

Grass

Grass

Paved

Paved

RipRap

RipRap

Other

Other material (input below)

Unknown

Unknown

N/A

Not Applicable

Open Channel

Open Channel (Meck Cty use only)

Coordinates defining the features.

SHAPE

Feature geometry. (Source: ESRI)

Coordinates defining the features.

Shape

Feature geometry. (Source: ESRI)

Coordinates defining the features.

FUNCTION_

Whether the channel is functioning (Source: City of Charlotte Storm Water)

Value

Definition

Yes

Yes the channel is functioning

No

No the channel is not functioning

STANDARD_C

Standard Comments for structures (Source: City of Charlotte Storm Water)

Value

Definition

No access to structure - (structures) Unable to physically access structure - minimal attribute input.

 

Pipe not followed - (pipestubs) Pipe not followed to next structure/junction.

 

Next structure not found - (pipestubs) Next structure not found

 

Channel data estimated - (channels) Large stream - dimensions estimated.

 

MEDIA_LINK

Link to picture (Source: City of Charlotte Storm Water)

Filepath for pictures

CONST_DATE

Approximate date of construction (Source: City of Charlotte Storm Water)

Date of construction

IN_OUTLET

Structure function (Source: City of Charlotte Storm Water)

Value

Definition

Inlet

 

Outlet

 

Junction

 

ANCILLARYR

Source or sink for flow (Source: City of Charlotte Storm Water)

Source or sink for flow

DATA_SOURCE

STRUCT_TYPE

STRUCT_TYPE_TEXT

STRUCTURE_SIZE

OUTFALL_ID


Who produced the data set?

  1. Who are the originators of the data set? (may include formal authors, digital compilers, and editors)
    • REQUIRED: The name of an organization or individual that developed the data set.
  2. Who also contributed to the data set?
  3. To whom should users address questions about the data?

Catherine Crigler
City of Charlotte
Inventory Coordinator
600 E 4th St
Charlotte, NC 28202

704-336-5735 (voice) or email: ccrigler@charlottenc.ogr

 


Why was the data set created?

Create inventory network to track assets and use with Storm Water projects


How was the data set created?

  1. From what previous works were the data drawn?
  2. How were the data generated, processed, and modified?

(process 1 of 5)

Locate structures with GPS technology and enter structure attributes and linear features using mobile GIS software.

Data sources used in this process:

    • Server=isp-sde-01.isp.lcl; Service=5151; User=SDE; Version=sde.DEFAULT

(process 2 of 5)

Dataset copied.

Data sources used in this process:

    • Server=virt-sde-01; Service=5162; Database=storm; User=storm; Version=STORM.Storm_edit

Date: 12-Nov-2008 (process 3 of 5)

Metadata imported.

Data sources used in this process:

    • H:\Metadata\sw_drainage.xml

(process 4 of 5)

Metadata imported.

Data sources used in this process:

    • H:\Metadata\Storm_structures.xml

(process 5 of 5)

Metadata imported.

Data sources used in this process:

    • H:\Metadata\Storm_structures.xml
  1. What similar or related data should the user be aware of?

How reliable are the data; what problems remain in the data set?

  1. How well have the observations been checked?

We try to minimize the room for input error by creating domains and automatically populated fields. However, there is still room for error and we check all field data for missing attributes and logical errors.

  1. How accurate are the geographic locations?

sub-meter GPS accuracy for 2004 and beyond

  1. How accurate are the heights or depths?

based on 2002 DTM (10 ft cells)

  1. Where are the gaps in the data? What is missing?

The inventory collection is ongoing with a goal to recapture the pre-2004 data and complete all remaining inventory within the city limits. After initial completion, the inventory effort will continue in order to collect data on new construction, repaired systems, and annexed areas.

  1. How consistent are the relationships among the observations, including topology?

All data with an Inventory Date of 2004 and beyond has been collected with sub-meter GPS equipment and reviewed for locational accuracy against aerial photography. All data with an Inventory Date before 2004 was located manually and not all of the data has been checked against current aerial photography.


How can someone get a copy of the data set?

Are there legal restrictions on access or use of the data?

User must read and understand the disclaimer provided with the data.

  1. Who distributes the data set? (Distributor 1 of 1)

Catherine Crigler
City of Charlotte
Inventory Coordinator
600 E 4th St
Charlotte, NC 28202

704-336-5735 (voice)

  1. What's the catalog number I need to order this data set?

Downloadable Data

  1. What legal disclaimers am I supposed to read?

In no event shall the City of Charlotte and/or Mecklenburg County Government be liable for any special, indirect, or loss of use, data or profits, whether in an action of contract, negligence or other tortuous action, arising out of or in connection with the use or performance of software, documents, provision of, or failure to provide services or information available from this data.

  1. How can I download or order the data?
    • Availability in digital form: from Charmeck.org/stormwater

Who wrote the metadata?

Dates:

Last modified: 09-Mar-2011

Metadata author:

Samantha Willis, GIS Analyst, City of Charlotte, E&PM, Storm Water Services Agency

Metadata standard:

FGDC Content Standards for Digital Geospatial Metadata (FGDC-STD-001-1998)

Metadata extensions used:

·         <http://www.esri.com/metadata/esriprof80.html>

·         <http://www.esri.com/metadata/esriprof80.html>

·         <http://www.esri.com/metadata/esriprof80.html>

·         <http://www.esri.com/metadata/esriprof80.html>


Generated by mp version 2.9.6 on Wed Mar 09 12:38:57 2011