FALSE
1.0
PACP_Observations_ExportFeatures
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_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.3.0'><WKT>PROJCS["NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",6561666.666666666],PARAMETER["Central_Meridian",-98.5],PARAMETER["Standard_Parallel_1",32.13333333333333],PARAMETER["Standard_Parallel_2",33.96666666666667],PARAMETER["Latitude_Of_Origin",31.66666666666667],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2276]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>999999999.99999988</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>-10000</MOrigin><MScale>10000</MScale><XYTolerance>8.983152841195215e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102738</WKID><LatestWKID>2276</LatestWKID></ProjectedCoordinateSystem>
20250805
07062600
20250805
07062600
Point dataset created from Access database tables provided by the CCTV contractor, with points representing each PACP_Code created at the approximate distance along the inspection route. AssetID's are confirmed to ensure PACP_Codes are associated with the correct stormwater pipe. CCTV_Routes can be associated with the corresponding PACP_ObservationPts using the RouteID and Inspection_Name fields.
PACP Observations
X-Ray
NaN
NaN
NaN
NaN
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SHAPE
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
Additional_Info
Additional Info
String
255
0
0
Additional_Info
AssetID
Asset ID
String
50
0
0
City stormwater pipe AssetID.
CCTV_Status
CCTV Status
String
255
0
0
CCTV_Status
Certificate_Number
Certificate Number
String
255
0
0
Certificate_Number
City
City
String
255
0
0
City
Clock_At_From
Clock At From
Double
8
38
8
Clock_At_From
Clock_To
Clock To
Double
8
38
8
Clock_To
Coating_Method
Coating Method
String
255
0
0
Coating_Method
ConditionID
ConditionID
Double
8
38
8
ConditionID
Consequence_Of_Failure
Consequence Of Failure
String
255
0
0
Consequence_Of_Failure
Continuous
Continuous
String
255
0
0
Documents continuous PACP observations greater than 10 feet, where 'S' is start point and 'F' is endpoint.
Counter
Counter
String
255
0
0
Counter
Customer
Customer
String
255
0
0
Customer
Date_Cleaned
Date Cleaned
String
255
0
0
Date_Cleaned
Description
Description
String
255
0
0
PACP observation code description.
Direction
Direction
String
255
0
0
Inspection direction; valid values Upstream, Downstream.
Distance
Distance
Double
8
38
8
Distance along the inspection route for PACP_Code.
Down_Easting
Down Easting
String
255
0
0
Down_Easting
Down_Elevation
Down Elevation
String
255
0
0
Down_Elevation
Down_Grade_to_Invert
Down Grade to Invert
String
255
0
0
Down_Grade_to_Invert
Down_Northing
Down Northing
String
255
0
0
Down_Northing
Down_Rim_to_Grade
Down Rim to Grade
String
255
0
0
Down_Rim_to_Grade
Down_Rim_to_Invert
Down Rim to Invert
String
255
0
0
Down_Rim_to_Invert
Downstream_MH
Downstream MH
String
255
0
0
Downstream Access Point AssetID.
Drainage_Area
Drainage Area
String
255
0
0
Drainage_Area
Flow_Control
Flow Control
String
255
0
0
Flow_Control
GPS_Accuracy
GPS Accuracy
String
255
0
0
GPS_Accuracy
Grade
Grade
Double
8
38
8
PACP observation rating on a scale of 0 to 5, where 5 is severe.
Height
Height
Double
8
38
8
Height
Inspection_Date
Inspection Date
Date
8
0
0
PACP inspection date.
Inspection_Name
Inspection Name
String
150
0
0
PACP Inspection_Name, corresponds to the CCTV_Routes RouteID.
Inspection_Status
Inspection Status
String
255
0
0
Inspection_Status
Inspection_Technology_Used_CCTV
Inspection Technology Used CCTV
SmallInteger
2
5
0
Inspection_Technology_Used_CCTV
Inspection_Technology_Used_Lase
Inspection Technology Used Laser
SmallInteger
2
5
0
Inspection_Technology_Used_Laser
Inspection_Technology_Used_Othe
Inspection Technology Used Other
SmallInteger
2
5
0
Inspection_Technology_Used_Other
Inspection_Technology_Used_Side
Inspection Technology Used Sidewall
SmallInteger
2
5
0
Inspection_Technology_Used_Sidewall
Inspection_Technology_Used_Sona
Inspection Technology Used Sonar
SmallInteger
2
5
0
Inspection_Technology_Used_Sonar
Inspection_Technology_Used_Zoom
Inspection Technology Used Zoom
SmallInteger
2
5
0
Inspection_Technology_Used_Zoom
Inspection_Time
Inspection Time
Date
8
0
0
Inspection_Time
InspectionID
InspectionID
Double
8
38
8
InspectionID
IsImperial
IsImperial
SmallInteger
2
5
0
IsImperial
Joint
Joint
SmallInteger
2
5
0
Joint
Length_Surveyed
Length Surveyed
Double
8
38
8
Length, in linear feet, of the PACP inspection route.
Lining_Method
Lining Method
String
255
0
0
Lining_Method
Location_Code
Location Code
String
255
0
0
Location_Code
Location_Details
Location Details
String
255
0
0
Location_Details
Material
Material
String
255
0
0
Material
Media_Label
Media Label
String
255
0
0
Media_Label
Media_Path
Media Path
String
500
0
0
Media_Path
MH_Coordinate_System
MH Coordinate System
String
255
0
0
MH_Coordinate_System
Owner
Owner
String
255
0
0
Owner
PACP_Code
PACP Code
String
255
0
0
PACP observation code.
Pipe_Joint_Length
Pipe Joint Length
String
255
0
0
Pipe_Joint_Length
Pipe_Segment_Reference
Pipe Segment Reference
String
255
0
0
Pipe segment AssetID.
Pipe_Shape
Pipe Shape
String
255
0
0
Pipe_Shape
Pipe_Use
Pipe Use
String
255
0
0
Pipe_Use
PO_Number
PO Number
String
255
0
0
PO_Number
PreCleaning
PreCleaning
String
255
0
0
PreCleaning
Pressure_Value
Pressure Value
Double
8
38
8
Pressure_Value
Project
Project
String
255
0
0
Project
Purpose
Purpose
String
255
0
0
Purpose
Remarks
Remarks
String
255
0
0
Remarks noted by PACP inspector.
Reverse_Setup
Reverse Setup
String
255
0
0
Reverse_Setup
Review_Comments
Review Comments
String
255
0
0
Review_Comments
Review_Routes
Review Routes
String
255
0
0
Review_Routes
Reviewed_By
Reviewed By
String
255
0
0
Reviewed_By
Reviewer_Certificate_Number
Reviewer Certificate Number
String
255
0
0
Reviewer_Certificate_Number
Sheet_Number
Sheet Number
String
255
0
0
Sheet_Number
Street
Street
String
255
0
0
Street
Surveyed_By
Surveyed By
String
255
0
0
Surveyed_By
Total_Length
Total Length
String
255
0
0
Total_Length
Up_Easting
Up Easting
String
255
0
0
Up_Easting
Up_Elevation
Up Elevation
String
255
0
0
Up_Elevation
Up_Grade_to_Invert
Up Grade to Invert
String
255
0
0
Up_Grade_to_Invert
Up_Northing
Up Northing
String
255
0
0
Up_Northing
Up_Rim_to_Grade
Up Rim to Grade
String
255
0
0
Up_Rim_to_Grade
Up_Rim_to_Invert
Up Rim to Invert
Double
8
38
8
Up_Rim_to_Invert
Upstream_MH
Upstream MH
String
255
0
0
Upstream Access Point AssetID.
Value_1st_Dimension
Value 1st Dimension
String
255
0
0
Value_1st_Dimension
Value_2nd_Dimension
Value 2nd Dimension
String
255
0
0
Value_2nd_Dimension
Value_Percent
Value Percent
Double
8
38
8
Value_Percent
VCR_Time
VCR Time
String
255
0
0
VCR_Time
Vertical_Datum
Vertical Datum
String
255
0
0
Vertical_Datum
Weather
Weather
String
255
0
0
Weather
Width
Width
String
255
0
0
Width
WorkOrder
WorkOrder
String
255
0
0
WorkOrder
Year_Constructed
Year Constructed
String
255
0
0
Year_Constructed
Year_Renewed
Year Renewed
String
255
0
0
Year_Renewed
PACP_Observations_ExportFeatures
Feature Class
0
CodeGroup
CodeGroup
String
3
0
0
Grade_int
Grade_int
SmallInteger
2
5
0
Verify
Verify
String
50
0
0
FY
FY
String
255
0
0
Esri ArcGIS 13.3.4.52636
PACP_Observations_ExportFeatures
Enterprise Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
TRUE
20250805