1 / 6

# Query Layers are Your Friends - PowerPoint PPT Presentation

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about ' Query Layers are Your Friends' - milek

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### Query Layers are Your Friends

Inside ArcMap

Services Anyone?

Polling Places

Using them in place of conventional feature classes

BaseMapIMS

Using them to fix inherent problems

AVL like applications

• Simply looking at a table

• Sensor_PT

• Combining disparate datasources easily

• Unit Time

• Making functionality

• Editing

• With a little work

• 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

Select APID, Num, PreDir, StrName, StrType, SecUnit, SecUnitDes, City,

geometry::Point(X,Y,3419) as Shape

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')

• 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