| snippet:
|
This view is used to show locations where Gas TEchnicians are unable to access a gas meter when they are doing ACM inspections. This view is created from the GASACMCycles layer and the GASACMInspections table. This view has a subquery in it to use the most recent inspection. |
| summary:
|
This view is used to show locations where Gas TEchnicians are unable to access a gas meter when they are doing ACM inspections. This view is created from the GASACMCycles layer and the GASACMInspections table. This view has a subquery in it to use the most recent inspection. |
| accessInformation:
|
Sunrise GIS, Paola Rossie, Jon Stahl |
| thumbnail:
|
|
| maxScale:
|
5000 |
| typeKeywords:
|
[] |
| description:
|
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>CREATE VIEW GASACMInspections_NoAccessToMeter_VW AS SELECT A.OBJECTID, A.SHAPE, A.METER_LOCA AS METERADDRESS,A.ACM_CYCLE, B.ACCESSTOMETER, B.ACCOUNTOBJECTID</SPAN></P><P><SPAN>FROM UTILITIES.GISADMIN.GASACMCYCLES_evw AS A</SPAN></P><P><SPAN /></P><P><SPAN>LEFT JOIN UTILITIES.GISADMIN.GASACMINSPECTIONS_evw AS B ON A.ACCOUNTOBJECTID = B.ACCOUNTOBJECTID</SPAN></P><P><SPAN>WHERE (SELECT TOP 1 H.OBJECTID FROM UTILITIES.GISADMIN.GASACMINSPECTIONS_evw AS H</SPAN></P><P><SPAN>WHERE H.ACCOUNTOBJECTID = A.ACCOUNTOBJECTID AND B.ACCESSTOMETER IN ('NoGateLocked','NoNoOneHome','NoDog') </SPAN></P><P><SPAN>ORDER BY LAST_EDITED_DATE DESC) =B.OBJECTID</SPAN></P></DIV></DIV> |
| licenseInfo:
|
|
| catalogPath:
|
|
| title:
|
UTILITIES.gisadmin.GASACMInspections_NoAccessToMeter_VW |
| type:
|
|
| url:
|
|
| tags:
|
["Gas","ACM","Inspection","No Access","meter"] |
| culture:
|
en-US |
| portalUrl:
|
|
| name:
|
|
| guid:
|
|
| minScale:
|
50000 |
| spatialReference:
|
|