What can I do to build a model for a Related database table?
Thanks for you quick response
I have shapefile which contains about 82 locations which is a polygon shapefile (Table 1).
I have another database table of over 50years data which contains over 70,000 data of bird species distribution, types of bird species, category, year/month etc (Table 2: that contains additional information that is not in table 1.). All in the geodatabase table.
Table 1 which is the attribute of the shapefile table was related with table 2.
So now, at this stage what I am supposed to do is the use a model builder to build a tool to answer the spatial questions like:
At a Single location what is the total sum of birds in a particular year, in a particular month.
Because the birds are also grouped into categories: so questions like total sum of one category, yearly and monthly sum at a particular location or all locations.
Total sum of one specie at all location, yearly sum of one specie at all locations.
The tool will form a GUI for users to select from a drop down list of each parameters location of interest, specie of interest, category of interest. To be published as a web geoprocessing service that will enable users to carry out simple geoprocessing or spatial analysis query.
Below is the usual selection by attribute by clicking of a location the shapefile database table which shows the related data in the species database table.
