20260227
20590900
1.0
FGDC CSDGM Metadata
FALSE
swPoint_Feature_New
002
1725433.379518
1807537.549955
194127.949928
295582.609879
1
-
dataDev.SDE.Stormwater_Point_InspecRelate
Relationship
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Alabama_West_FIPS_0102_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.0.0'><WKT>PROJCS["NAD_1983_StatePlane_Alabama_West_FIPS_0102_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["Transverse_Mercator"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-87.5],PARAMETER["Scale_Factor",0.9999333333333333],PARAMETER["Latitude_Of_Origin",30.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["Esri",102630]],VERTCS["NAVD_1988",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Meter",1.0],AUTHORITY["EPSG",5703]]</WKT><XOrigin>-16478800</XOrigin><YOrigin>-43705000</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102630</WKID><LatestWKID>102630</LatestWKID><VCSWKID>5703</VCSWKID><LatestVCSWKID>5703</LatestVCSWKID></ProjectedCoordinateSystem>
20220816
13241100
20220816
13241100
150000000
5000
ItemDescription
Esri ArcGIS 13.0.0.36056
swPoint_Feature_New
1
-88.274257
-88.011265
30.811725
30.531502
Stormwater point data including: Inlets, cleanouts, and manholes
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Date_last_cleaned_inspected and NumberTimes_cleanedInspected last updated on 2/23/2021 using stormWater.dbo.vw_swPoint_Inspection_Table_CleanHistory.</SPAN></P></DIV></DIV></DIV>
Stormwater
Inlet
CleanOut
Manhole
Feature Class
dataset
Esri
8.0.1
0
Simple
FALSE
0
TRUE
FALSE
swPoint_Feature_New
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Enabled
Enabled
SmallInteger
2
0
0
LifecycleStatus
LifecycleStatus
String
20
0
0
FeatureID
FeatureID
Integer
4
0
0
Feature_Type
Feature_Type
String
50
0
0
Feature_SubType
Feature_SubType
String
50
0
0
Structure_Condition
Structure_Condition
String
50
0
0
Inlet_Filter
Inlet Filter
String
50
0
0
LadderRungs
LadderRungs
String
1
0
0
Plan_Depth
Plan_Depth
Double
8
0
0
Plan_Elevation
Plan_Elevation
Double
8
0
0
Plan_InvertElevation
Plan_InvertElevation
Double
8
0
0
LocationDescription
LocationDescription
String
200
0
0
Owner
Owner
String
20
0
0
MaintainedBy
MaintainedBy
String
20
0
0
Source
Source
String
20
0
0
Northing
Northing
Double
8
0
0
Easting
Easting
Double
8
0
0
Comments
Comments
String
250
0
0
WallMaterial
WallMaterial
String
20
0
0
Conflict_Type
Conflict_Type
String
50
0
0
Survey_Date
Survey_Date
Date
8
0
0
Survey_Contract
Survey_Contract
String
50
0
0
Survey_GPS_Status
Survey_GPS_Status
String
50
0
0
Survey_GPS_Accuracy
Survey_GPS_Accuracy
Double
8
0
0
Survey_GPS_Source
Survey_GPS_Source
String
50
0
0
Survey_Measurement_Status
Survey_Measurement_Status
String
50
0
0
Survey_Office_Process_Status
Survey_Office_Process_Status
String
50
0
0
Survey_Office_Process_Comment
Survey_Issues_Comment
String
250
0
0
Survey_Depth
Survey_Depth
Double
8
0
0
Survey_Elevation
Survey_Elevation
Double
8
0
0
Survey_InvertElevation
Survey_InvertElevation
Double
8
0
0
TYLER_AUTO_ID
TYLER_AUTO_ID
Integer
4
0
0
TYLER_ASSET_CODE
TYLER_ASSET_CODE
String
100
0
0
TYLER_DESCRIPTION
TYLER_DESCRIPTION
String
100
0
0
TYLER_GIS_LINKID
TYLER_GIS_LINKID
Integer
4
0
0
TYLER_CATEGORY
TYLER_CATEGORY
String
5
0
0
TYLER_ASSET_TYPE
TYLER_ASSET_TYPE
String
30
0
0
TYLER_TYPE_DESCRIPTION
TYLER_TYPE_DESCRIPTION
String
100
0
0
TYLER_GIS_LAYER
TYLER_GIS_LAYER
String
255
0
0
FeatureID_OLD
FeatureID_OLD
Integer
4
0
0
Creat_User
Creat_User
String
255
0
0
Creat_Date
Creat_Date
Date
8
0
0
Rev_Oper
Rev_Oper
String
50
0
0
Rev_Date
Rev_Date
Date
8
0
0
SHAPE
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
Watershed
Watershed
String
100
0
0
CleanZone
CleanZone
String
5
0
0
Survey_GPS_Comment
Survey GPS Comment
String
255
0
0
Survey_Measurement_Comment
Structure Measurement Comment
String
255
0
0
Survey_GPS_Issue
Structure GPS Issue
String
30
0
0
Survey_Measurement_Issue
Structure Measurement Issue
String
25
0
0
Survey_Office_Process_Issue
Structure_Office_Process_Issue
String
25
0
0
Survey_City_Review_Status
Survey_City_Review_Status
String
50
0
0
Survey_City_Review_Issue
Survey_City_Review_Issue
String
25
0
0
Survey_City_Review_Comment
Survey_City_Review_Comment
String
255
0
0
Survey_PW_Structure_Status
Survey_City_PW_Structure_Status
String
50
0
0
Survey_PW_Structure_Comment
Survey_City_PW_Structure_Comment
String
255
0
0
Survey_PW_Complete_Date
Date of Completion for Public Work
Date
8
0
0
GlobalID
GlobalID
GlobalID
38
0
0
ACCESSIBLE
ACCESSIBLE
String
10
0
0
Lid_Material
Lid_Material
String
25
0
0
Date_Last_Cleaned_Inspected
Date_Last_Cleaned_Inspected
Date
8
0
0
Survey_Temp_ID
Survey_Temp_ID
String
15
0
0
NumberTimes_CleanedInspected
NumberTimes_CleanedInspected
SmallInteger
2
0
0
ACCESSIBLE_ISSUE
ACCESSIBLE_ISSUE
String
50
0
0
Billing_Structure_Type
Billing Structure Type
String
50
0
0
Billing_GoBack_Status
Billing GoBack Status
String
50
0
0
Billing_Location
Billing Location
String
25
0
0
GPS_Horiz_Accuracy
GPS_Horiz_Accuracy
Double
8
0
0
GPS_Vert_Accuracy
GPS_Vert_Accuracy
Double
8
0
0
Survey_Easement_Comment
Survey_Easement_Comment
String
256
0
0
SRO_Submitted_Date
SRO_Submitted_Date
Date
8
0
0
Billing_Cycle_GPS
Billing_Cycle_GPS
String
25
0
0
Billing_Cycle_GoBack_1
Billing_Cycle_GoBack_1
String
25
0
0
Billing_Cycle_GoBack_2
Billing_Cycle_GoBack_2
String
25
0
0
Billing_Cycle_Connectivity
Billing_Cycle_Connectivity
String
25
0
0
20220816