1 / 6

Query Layers are Your Friends

Query Layers are Your Friends. Show me the ways. Inside ArcMap. Services Anyone?. Polling Places Using them in place of conventional feature classes BaseMapIMS Using them to fix inherent problems Auto Updates AVL like applications. Bad Addresses Simply looking at a table Sensor_PT

milek
Download Presentation

Query Layers are Your Friends

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Query Layers are Your Friends

  2. Show me the ways Inside ArcMap Services Anyone? Polling Places Using them in place of conventional feature classes BaseMapIMS Using them to fix inherent problems Auto Updates AVL like applications • Bad Addresses • Simply looking at a table • Sensor_PT • Combining disparate datasources easily • Unit Time • Making functionality • Editing • With a little work

  3. Real Integration • Table with a geometric component • Either a geometry/geography column • Or simply X/Y values • Create a view to handle attributes • A replacement for SDE views, but better • Add the view to ArcMap • Voila, you have a feature class • Use it just like you would a “regular” feature class

  4. Bad Addresses Select APID, Num, PreDir, StrName, StrType, SecUnit, SecUnitDes, City, geometry::Point(X,Y,3419) as Shape from addrep.dbo.vwAddptFailQC_WithDescriptionsAndAddptData WHERE AddptQCID = 121

  5. Sensor_PT select cast(row_number() over(order by a.SiteID) as int) as seq,GEOMETRY::Point(a.XCoord,a.YCoord,3419) as Shape, a.*,b.SensorGroup,b.LastValidDataTime,b.LastValidDataValue from jocoPub.DL.Sensor_PT a left outer join OP_STORMWATCH2.StormWatch3.dbo.SensorDef b on a.SiteID = b.SiteID where a.XCoord is not null and a.YCoord is not null and b.InService = 1 and b.LastValidDataTime > GETDATE() - 1 and SensorGroup in ( 'Barometric Pressure', 'Flow Volume', 'Peak Wind', 'Rain', 'Relative Humidity', 'Temperature', 'Water Level', 'Wind Direction')

  6. Unit Time • Unit Time select * from (SELECT *, CAST(LEFT(DATETIME, 4) + '-' + SUBSTRING(DATETIME, 5, 2) + '-' + SUBSTRING(DATETIME, 7, 2) + ' ' + SUBSTRING(DATETIME, 9, 2) + ':' + SUBSTRING(DATETIME, 11, 2) + ':' + SUBSTRING(DATETIME, 13, 2) as DATETIME) as dt from dl.SHERIFFUNITS) a CROSS APPLY(SELECT MIN(DT) as dtt FROM (SELECT *, CAST(LEFT(DATETIME, 4) + '-' + SUBSTRING(DATETIME, 5, 2) + '-' + SUBSTRING(DATETIME, 7, 2) + ' ' + SUBSTRING(DATETIME, 9, 2) + ':' + SUBSTRING(DATETIME, 11, 2) + ':' + SUBSTRING(DATETIME, 13, 2) as DATETIME) as dt from dl.SHERIFFUNITS) c WHERE c.UNIT = a.UNIT AND c.dt > a.dt) b

More Related