(Interestingly enough, it used to do the same thing when I had ArcGIS 9.3 and yet it still worked.)īasically, what I'm trying to do is have this tool query out only those water bodies that have an assessment for a specified pollutant and be able to display them as a map layer. My guess is that there is a problem with my expression because the "verify" option always tells that it won't work. I'm not sure what I'm doing wrong as I've tried tweaking what options I select within the Make Query Table tool about 20 different ways. To represent database-table data in Python objects, Django uses an intuitive system: A model class represents a database table, and an. "An expected field was not found or could not be retrieved properly." Now in ArcGIS 10.2.1, it keeps giving me an error message stating that "IR2014_RiversStreams.Cause_Grouping" = 'Bacteria' "IR2014_RiversStreams.ID" = "rc_RiversStreams_2014.ID_FK" AND Here is an example of the VBA or SQL code used to do this: "Rivers_Streams_2014.ComID" = "rc_RiversStreams_2014.ComID_FK" AND MakeQueryTableOLEDB. Creating a Database Connection Check for the status of the connection on the left-bottom side (above the Help button).
#MAKE QUERY TABLE TOOL HOW TO#
In ArcGIS 9.3, I was able to use the "Make Query Table" tool to link these tables up and then query based on a single pollutant. The following script is an example of how to use the MakeQueryTable tool in the Python scripting environment. The reason for the many-to-many relationship is that one water body can impaired by many pollutants and one pollutant can impair many water bodies. Use the Query Wizard to build a query from a primary table and a related table On the Database Tools tab, in the Show/Hide group, click Relationships. All of these tables (river table, attributed relationship class, pollutants table) are located in the same file geodatabase. One is a table of water body (rivers) features and the other is a series of pollutants the water bodies have been assessed for. I have two tables that I have connected via an attributed relationship class of the cardinality Many-to-Many.
0 kommentar(er)
