Parcel Search
We recently installed Geocortex Essentials and are in the process building our first viewer. I am currently working on the search and have run into a snag with searching parcels. Currently there are 2 components that are used for parcels, a layer (parcel_info) and a table (parcel_view). The layer contains the parcels with their geometries. Search for this layer is pretty straight forward, I was able to create an instant search index for it and search on it. The issue I am have is being able to search the none-spatial parcel_view table. This table contains all of the records in the parcel_info layer PLUS all the individual condo owner records. I want to be able to search for individual condo owners but return the geometry of the condo building that is stored in the parcel_layer. Currently, we have a webservice that does this, take a look at the xml output below, the number circled in red is the inputted PIN which is a non-spatial record of an individual condo owner. The output is circled in blue. Notice that the output number is different than the input. The output is the actual condo building polygon found in the parcel layer. That’s the logic I’m looking to add for the search.
The way this validator works is when a PIN is entered, it first searches the parcel layer, if it’s there then that record is returned from the parcel layer. If it’s not, then it searches the parcel_view table. If it’s there, it grabs a value from a field named “sub”. Using this value, a query is done on the parcel layer against a field named “condo”. If a record exists with this condo number, then then this polygon is returned. So the link between the parcel_layer and parcel_view table with regard to condo owner and condo building is the “sub” field in parcel_view and “condo” field in parcel layer.
I have tried adding a data link to the parcel_view table to the parcel layer , it almost works but no geometry is returned from the parcel layer. I tried adding a datalink to the parcel layer to the parcel_view table but it only seems to work if I search by condo number which is not what I want to do. I want to be able to search by PIN or owner. It’s at this point I’m at an impasse. Not sure if I need to write a workflow and if so how do I connect it to the search widget?
We have GeoCortex Essentials 4.11 installed with Viewer 2.12. Geocortex Workflow Designer 4.11.0.94
0
-
Bob,
Ah the world of data design and ralationships!
One question before I dive into a rabit hole, are the data sources (Polygons, Owner & Condo Data) in the same database or on the same data server that you have direct access to?
Scott0 -
Yes, they are both on the same server. 0 -
Yes they are both on the same server and database. 0 -
Scott, have you come up with a solution to this? Thanks! 0 -
Sorry Bob, lost track of this.
My recommendation would be to create a view in the database that joins the FeaturClass and the Table of parcel data. Instead of pointing to the parcel FeatureClass, point your layer to the new View that contains the Parcel Polygons AND parcel data. ArcMap will recognize it just like any other FeatureClass. Now when you search, you only have to search the FeatureClass, not other related tables. Does that make sense?0 -
Yes, that does make sense. I'll try this out and see what happens. Thank you so much for the help... I'll let you know what I find! 0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
6 kommentarer