Select to view content in your preferred language

Filter shapefiles by data attribute table

6365
5
07-30-2010 06:58 PM
JohnTaylor1
Emerging Contributor
I am new to ArcGIS, so please be patient.  I have some very large shapefiles I want to view in Explorer.  Right now I only have Explorer, and none of the other ArcGIS programs.  I would like to filter my shapefiles down to much smaller files, either using Explorer (if it has the ability) or using some other shapefile editor.  A free shapefile editor would be best, if such a think exists.  I want to filter based on the records in the shapefiles own database tables.  Does Explorer have this ability?  Do I need to purchase or download another program to edit the shapefiles before I load them into Explorer?

Thank you

John
0 Kudos
5 Replies
JosephSimon
Deactivated User
Hello John,
You can use the free Query add-in for ArcGIS Explorer (AGX) to see a filter of the data in the shapefiles. I routinely use it for my Parcel shapefile, which has 450,000 records.
If you want to natively alter the shapefiles, be it editing the dbf or compressing, you should use ArcGIS desktop. I won't comment on the free "alternatives" out there, but I think an ArcGIS desktop license is worth the investment. It will give you some great tools that will radically enhance your productivity. If you are serious about GIS you won't be sorry to have ArccGIS desktop.
You could try editing the shapefile in Excel, Access, Paradox, OpenOffice.org Base, or some other programs that opens shp xml. I've opened shapefiles in some of those programs, but not to filter them.
However, things are changing so fast, especially in light of the coming AGX 1500 release, though it wouldn't surprise me if ESRI offers something for editing shapefiles within AGX.
Just my two cents...someone else may have other ideas....
0 Kudos
JohnTaylor1
Emerging Contributor
Dear Joseph,

Thank you very much for the response.  I downloaded the add-in you recommended, but it falls short of what I was hoping for.  It allows me to query my shapefiles table on the values in a single field, then displays the query result in a little window.  I did not see any way to force Explorer to display only the filtered records from my shapefile, i.e., the query results don't affect the records displayed.  I did see that Explorer would highlight and jump one by one to each of the filtered records--like a kind of manic slideshow--but this is not a useful feature for my purposes. 

I really need the capability to filter on several fields of my shapefile table simultaneously, and I need to then be able to navigate the filtered shapefiles normally using Explorer.  If I could output the Query results as their own shapefile and then load them back by themselves then that would do the trick, but I didn't see any such capability built in. 

I tried simply opening the database table (*.dbx) using Microsoft Access.  This allowed me to filter the shapefile table to my hearts content.  Unfornately, trying to save these filtered tables in Access and open them in Explorer is pointless, as the sequence gets broken.  Hence the need for a real shapefile editor. 

This is an unfunded project at present, so I do not have the budget to purchase ArcGIS Desktop.  That may change if I can demonstrate a marketable product, but for now all the R&D is coming out of my own pocket.  Hence the need for a free shapefile editor, at least until I get the budget to purchase the real thing. 

Any further thoughts or suggestions would be appreciated. 

John
0 Kudos
JosephSimon
Deactivated User
Hello John,
It would violate my sense of netiquette to use this forum to point you to a non-ESRI tool, but if you search or post on a more general GIS forum I think you will find a dozen or so options to filter your shapefiles.
In additon, you may also want to inspect Microsoft SQL Server 2008 R2. ESRI officially supports SS2008 R2, at least at some level. The Express version is free and  there are built-in geospatial tools and functions that may get you going. Also of interest would be SS2008 R2's Report Builder 3.0, which imports ESRI shapefiles. Using a combination of those two you can filter geospatial via a parameter in the query.
You may also want to buy the latest ArcGIS Desktop book, which comes with a fully functional 180-day trial. You can use this for Proof-of-Concept until you can afford a commercial license.

Hope this helps.
0 Kudos
MichaelBranscomb
Esri Frequent Contributor
John,

I believe ArcGIS Explorer 1500 will provide the functionality you are looking for - by introducing some Shapefile (+ other vector data source) filtering in the application through SQL-style queries. We hope to have this release available later in August or possibly early September. There are also some API additions in this area which you may be interested in if you are planning any development with the (free) ArcGIS Explorer SDK.

You could also consider approaching your local ESRI distributor/regional office to speak to an account manager who I'm sure would try to support you during your product evaluation - we have evaluation licenses which might be available for this situation. We also have a developer programme which although has an upfront cost per developer, provides access to a whole bundle of ESRI SDK for desktop, web and mobile development.

Regards

Mike
0 Kudos
JohnTaylor1
Emerging Contributor
Mike, Joseph,

Thank you very much for your replies.  I was not aware that I could get a 180 day trial version of Desktop simply by purchasing the book.  That should give me more than enough time to develop my project.  Thank you very much for all your suggestions. 

John

P.S. (I will be sure to check out ArcGIS Explorer 1500 when it comes out later this year.)
0 Kudos