ItemInfo

Item Information

snippet:	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.
summary:	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.
accessInformation:	Sunrise GIS, Jon Stahl
thumbnail:
maxScale:	5000
typeKeywords:	[]
description:	<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>
licenseInfo:
catalogPath:
title:	UTILITIES.GISADMIN.GasACMInspectionsReporting_VW
type:
url:
tags:	["Gas","Inspection","ACM","Meter"]
culture:	en-US
portalUrl:
name:
guid:
minScale:	50000
spatialReference: