Find closest features to point and generate report
Hello all,
I am looking for a way to create a report showing the distance and attribute information for the closest feature in multiple layers to the currently selected parcel feature or coordinate.
Basically, my planners want to select a parcel and then run a report that will query a list of environmental layers which returns the distance to the nearest feature in each of the layers as well as basic data. Has anyone done this already?
We already have an ArcGIS Server 9.3 Silverlight application (not Geocortex based) that uses ArcObjects to find the various layers but we are trying to replicate it for the latest version of ArcGIS Server as well as use the better Geocortex Essentials Silverlight application.
We could pay the consultant to upgrade it for us but it still wouldn't be Geocortex based which is our preferred software.
Any thoughts or suggestions?
Thanks
Mike Gangemi
Erie County NY
-
I'm doing something similar with parcels by reporting nearby park names and distance away (as the crow flies) in miles. I'm accomplishing this with a spatial query stored in a data link on my parcel layer. I can supply a sample if you have a similar setup (data stored in SQL Server 2012 but the query should work in 2008 as well).
0 -
Hi Mike,
The Generate a Multi-Layer Report with Map example from the code gallery could serve as an base from which to build your workflow/report upon. See (https://support.geocortex.com/essentialsGSCCodeGallery?sub-nav=codegall&main-nav=essentials&id=kA460000000bllT) Generate a multi-layer report .
regards,
Edmond
0 -
Further Edmond's reply, the "nearest" functionality is a hard question to answer spatially on-the-fly. Thus most do pre-processing of the data to use an attribute query/value and reports the amount there. Alternatively you can generate an on-the-fly "nearest" algoritmn. An example pseudo code for on-demand closest is:
- Buffer selected object by X
- Select desired feature(s) within buffer distance
- Case: 0 selected features = Double Buffer Distance, Return to #1
- Case: 1 selected features = Answer!
- Case: >1 check linear distance between each feature from selected feature. Lowest is answer.
Good luck!
Shawn.
0 -
Check out one of Geocortex User Conference 2013: (https://support.geocortex.com/essentialsGSCVideo?sub-nav=videos&main-nav=essentials&id=kA560000000Caoj) Deep Dive: Working with Data II presented by John F.
If you are using MS SQL database as the backend data, it is so cool new way to achieve what you want to do.
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
4 Kommentare