Data link to a data link
Trying to figure out the logic in my head, meanwhile thought I'd try posting here in case anyone's done this before.
In GIS database
Dataset 1: Apartment polygons, one polygon per complex
Dataset 2: Apartment rental licenses, one license per building in the complex
In ERP database
Dataset 3: Apartment rental license licensee contacts, multiple contacts per license
I've successfully connected the apartment rental licenses to the licensee contacts with a normal one-to-one data link. But now I'm trying to figure how to connect them to the apartment complex spatially. The process I'm trying to do:
1) STContains to select all of the rental licenses within an apartment complex
2) Join those rental licenses to licensee list
3) Return distinct list of licensee contacts as a data link on the apartment polygons
What I can't wrap my head around is how to do that because the apartment polygons and the licensee don't have a common field, but a data link requires a single data connection. So how can I join two GIS datasets spatially, and then join one of those datasets to a dataset in a different database? Is that even possible in GE?
0
-
In case you're wondering what the solution was on this, I ended up pulling the licensee lists into my GIS database on a daily extract schedule so all of the data I needed was in one location.
0
Please sign in to leave a comment.
Comments
1 comment