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