{
 "culture": "en-US",
 "name": "",
 "guid": "",
 "catalogPath": "",
 "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.",
 "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>",
 "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.",
 "title": "UTILITIES.gisadmin.GASACMInspections_NoAccessToMeter_VW",
 "tags": [
  "Gas",
  "ACM",
  "Inspection",
  "No Access",
  "meter"
 ],
 "type": "",
 "typeKeywords": [],
 "thumbnail": "",
 "url": "",
 "minScale": 50000,
 "maxScale": 5000,
 "spatialReference": "",
 "accessInformation": "Sunrise GIS, Paola Rossie, Jon Stahl",
 "licenseInfo": "",
 "portalUrl": ""
}