Latest Contributions by AyokunleAdebisi

Hello Curtis,..I want to question my related database table by building a model in the arcgispro modelbuilder.  ... View more

In case that is still not clear enough. Please let me know the specifics, so i can give more explanation. ... View more

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. ... View more

Hello. I am using model builder but confuse as tools required to run in order to get my output for a question like : "What is the total sum of a single tree specie at a  specific location in a particular year". I will build a back-end like GUI through the model through which the user can interact with to select the specie, location, and the year which will give output of the numbers. I hope you get what I am trying to say. Thanks. I need the tools to run the model of that type. In addition it is a related database table ... View more

Hello @Curtis Price. I am using model builder but confuse as tools required to run in order to get my output for a question like : "What is the total sum of a single tree specie at a  specific location in a particular year". I will build a back-end like GUI through the model through which the user can interact with to select the specie, location, and the year which will give output of the numbers. I hope you get what I am trying to say. Thanks. I need the tools to run the model of that type. ... View more

Thanks..Please can you give me a sample code to start...atleast for that spatial question asked above. ... View more

Right now I need to develop my own geoprocessing tools either with python or model-builder to carry out spatial query of the related table for instance  " what is the population of a particular bird specie in a particular location in a certain year and month.   I will appreciate if I get a sample of python script or model-builder for such question, as I will still ask as many spatial questions but getting what the code will look like will give me a startup. Thanks. ... View more

It has already been translated in file geodatabase. And also my spreadsheets is over 74,000 column and shape-files is 82 column. Anyways I have been able to join and relate them. Right now I need to develop my own geoprocessing tools either with python or model-builder to carry out spatial query of the related table for instance  " what is the population of a particular bird specie in a particular location in a certain year and month. I will appreciate if I get a sample of python script or model-builder for such question, as I will still ask as many spatial questions but getting what the code will look like will give me a startup. Thanks. ... View more

The database is spatially enabled. The related database is the joining and related excel sheet and shape-file attribute data-table. Thanks. ... View more

That will be a long wait. I need to perform this task within the week. Thanks ... View more

Thanks for your response. But in performing queries, one can use selection by attribute which gives the option to input an SQL statement. But with this, I think there will be a lot of SQL statement depending on the question one need to query at a point in time, which i feel it will be too much. I am just thinking of a tool that perform such queries by just input of parameters from the database. ... View more

Thanks will try that, ... View more