20231201
14293300
1.0
FALSE
GasACMInspectionsReporting_VW
002
883314.591969
889674.350903
665135.501135
670449.260521
1
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot_US (0.304801)
NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901_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/10.8'><WKT>PROJCS["NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",656166.6666666665],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-81.0],PARAMETER["Scale_Factor",0.9999411764705882],PARAMETER["Latitude_Of_Origin",24.33333333333333],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2881]]</WKT><XOrigin>-17791300</XOrigin><YOrigin>-41645400</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2881</WKID><LatestWKID>2881</LatestWKID></ProjectedCoordinateSystem>
20261007
11042700
20261007
11064400
50000
5000
ItemDescription
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
GasACMInspectionsReporting_VW
1
-80.307484
-80.288007
26.176507
26.161793
This view was created to provide a report for end users. It included information about the gas meter and the ACM inspection on one table. It uses GASACMCycles and GASACMInspections.
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>CREATE VIEW AAAA AS SELECT A.OBJECTID, A.SHAPE, A.METER_LOCA AS METERADDRESS, A.METER_SERI AS SERIALNUMBER, A.METER_SIZE AS SIZE, A.METER_DESC AS MANUFACTURER, A.METER_MODEL AS METERMODEL, </SPAN></P><P><SPAN>A.METER_LOCATION AS DETAILEDLOCATION, A.COMMENTS, A.ACM_CYCLE, A.INSPECTOR, A.LAST_EDITED_DATE,</SPAN></P><P><SPAN>B.RISERTYPE, B.STEELRISERCORROSION, B.ANODELESSRISERCORROSION, B.METERSETINSPECTION, B.LIGHTOXIDATIONMETERSETPAINT, B.ATMOCORROSIONMSETPAINT,</SPAN></P><P><SPAN>B.ATMOCORROSIONMSETREPREGULATOR, B.ATMOCORROSIONMSETREPPIPE, B.ATMOCORROSIONMSETREPFITTING, B.ATMOCORROSIONMSETREPMETER, B.CREATEWORKORDER, B.FOLLOWUPDATE,</SPAN></P><P><SPAN>B.ACCESSTOMETER, B.CLEANEDWRAPPEDSTEELRISERTODAY, B.PIPETOSOILREADING, B.OTHERISSUEFOUND, B.WONUMBER, B.ISMETERLOCATEDATBUILDING, B.METERLOCATBUILDINGFUELPIPE,</SPAN></P><P><SPAN>B.METERNOTLOCATBUILDINGFUELPIPE, B.OUTSIDEGASEQUIPMENT</SPAN></P><P><SPAN /></P><P><SPAN>FROM UTILITIES.GISADMIN.GASACMCYCLES_evw AS A</SPAN></P><P><SPAN>LEFT JOIN UTILITIES.GISADMIN.GASACMINSPECTIONS_evw AS B ON A.ACCOUNTOBJECTID = B.ACCOUNTOBJECTID</SPAN></P><P><SPAN>WHERE A.LAST_EDITED_DATE IS NOT NULL</SPAN></P></DIV></DIV>
Sunrise GIS, Jon Stahl
Gas
Inspection
ACM
Meter
Feature Class
dataset
EPSG
8.9.3(9.0.0)
8336
Simple
FALSE
8336
FALSE
FALSE
GasACMInspectionsReporting_VW
Feature Class
8336
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
METERADDRESS
METERADDRESS
String
254
0
0
SERIALNUMBER
SERIALNUMBER
String
254
0
0
SIZE
SIZE
String
254
0
0
MANUFACTURER
MANUFACTURER
String
254
0
0
METERMODEL
METERMODEL
String
50
0
0
DETAILEDLOCATION
DETAILEDLOCATION
String
75
0
0
COMMENTS
COMMENTS
String
75
0
0
ACM_CYCLE
ACM_CYCLE
String
50
0
0
INSPECTOR
INSPECTOR
String
50
0
0
LAST_EDITED_DATE
LAST_EDITED_DATE
Date
8
0
0
RISERTYPE
RISERTYPE
String
30
0
0
STEELRISERCORROSION
STEELRISERCORROSION
String
50
0
0
ANODELESSRISERCORROSION
ANODELESSRISERCORROSION
String
50
0
0
METERSETINSPECTION
METERSETINSPECTION
String
50
0
0
LIGHTOXIDATIONMETERSETPAINT
LIGHTOXIDATIONMETERSETPAINT
String
3
0
0
ATMOCORROSIONMSETPAINT
ATMOCORROSIONMSETPAINT
String
3
0
0
ATMOCORROSIONMSETREPREGULATOR
ATMOCORROSIONMSETREPREGULATOR
String
3
0
0
ATMOCORROSIONMSETREPPIPE
ATMOCORROSIONMSETREPPIPE
String
3
0
0
ATMOCORROSIONMSETREPFITTING
ATMOCORROSIONMSETREPFITTING
String
3
0
0
ATMOCORROSIONMSETREPMETER
ATMOCORROSIONMSETREPMETER
String
3
0
0
CREATEWORKORDER
CREATEWORKORDER
String
50
0
0
FOLLOWUPDATE
FOLLOWUPDATE
Date
8
0
0
ACCESSTOMETER
ACCESSTOMETER
String
50
0
0
CLEANEDWRAPPEDSTEELRISERTODAY
CLEANEDWRAPPEDSTEELRISERTODAY
String
50
0
0
PIPETOSOILREADING
PIPETOSOILREADING
Double
8
38
8
OTHERISSUEFOUND
OTHERISSUEFOUND
String
255
0
0
WONUMBER
WONUMBER
Integer
4
10
0
ISMETERLOCATEDATBUILDING
ISMETERLOCATEDATBUILDING
String
3
0
0
METERLOCATBUILDINGFUELPIPE
METERLOCATBUILDINGFUELPIPE
String
80
0
0
METERNOTLOCATBUILDINGFUELPIPE
METERNOTLOCATBUILDINGFUELPIPE
String
80
0
0
OUTSIDEGASEQUIPMENT
OUTSIDEGASEQUIPMENT
String
50
0
0
20261007