Map3D 2009: Theming on joined datasources.

One of the big problems (at least for me and many of our clients) with the initial release of Map 3D 2009 was that it would not allow you to create a theme based on a column from a joined datasource.  The problem was that the joined columns were just not shown in the UI. 

However... it would appear that this issue has been addressed in the latest map update.

As you can see from the screen captures below, the joined columns are now available in the Property dropdown list, and the Expression Builder Property list.
 

For those who do not know how to create a join, some simple instructions are:

Connect to both datasources and add to the map any required features.  In the sample image we've connected to and added to the map the Hydrants SDF for the point features, and made an ODBC connection to an Access database that contains more details for the Hydrants


In the Display Manger, right-click on the datasource (Hydrants) that you want to create a join on and select Create Join.  

In the Create a Join dialog, choose the secondary datasource to join to.  In this sample, select the Hydrants table

Next, choose the common columns between the 2 datasources, and determine what type of join you require: inner/outer join, and one-to-one or one-to-many.


Take care,
Warren
AU 2008 in 83 days...

Comments

Post a Comment

Popular posts from this blog

ArcGIS: Packaging error - General function failure

Image
Whoa... 2 posts within 2 months...  I'm on a roll baby...   :-) In today's episode I want to document what I've discovered with the following lovely error when attempting to create a Map Package: I've had this very insightful (hint:sarcasm) message box pop-up a number of times when trying to create a Map Package.  After much copying/pasting, renaming, re-connecting data sources I finally figured out what the problem was in this particular instance. This particular map had some DWG files connected to the map, and some of these DWG names contained a special character "#", and also contained extra 'dots' in the name to delimit a date.  For example: Name#-2013.04.09.dwg In my testing and trials, removing the '#' symbol did not resolve the issue, and it wasn't until I removed the extra 'dots' in the name that I was finally able to successfully generate the package.  Further testing revealed that the '#' symbol
Read more

More ArcGIS Woes with 'Special' Characters...

Image
It's no secret that I've griped and complained about many of ArcGIS's quirks that seem stuck or rooted in the 80's ...  One would think I wouldn't be surprised anymore when I come across such silly issues... But I am. The latest 'undocumented feature' I've discovered is that the Field Calculator will fail if there is forward slash ( '\' ) in the Layer name. ArcGIS 11 can't come soon enough.
Read more

ArcGIS Collector: Update Error Code 1006

Image
Alright, this is the second time this happened to me, and I neglected to document it the first time, so I had to search again to find the answer, so I will document it here, and now. Here goes... If you happen to come across ArcGIS Collector throwing an error when updating a feature, and the error states something along the lines of: Invalid untrusted Html content detected in field: Have no fear, there is a simple fix.  Well, that is, it's a simple fix if this is 'local' map, not accessible to the general public.  That's only because ESRI doesn't actually 'recommend' this fix. So what is 'this fix' I speak of? A little more background... If you have any fields that contain HTML content, there is a chance that Collector could see that as malicious content, and it will block it.  You can see a list of allowable HTML tags in Collector a this link . In my instance, I am running some database triggers to populate and update a URL field, where
Read more