taylor65

Selecting from a Database Table

Discussion created by taylor65 on Oct 19, 2012
Latest reply on Oct 19, 2012 by m.gasior
I've been experimenting with selecting data from database tables and trying to develop a work flow that allows me to select features from the tables without:


  • saving the db table as a csv,

  • importing the table to Arc,

  • saving the layer,

  • performing my selection,

  • exporting the table again,

  • importing the table back into my database.

Currently, I have my database table connected to arcgis and I have made my event layer from my database table. When I try to query my event, it won't let me. I can query the table, and make an event of the selection, but the event contains all the records and not simply the selected ones. It looks like I will still need to save my layer before making my selection, which is a messy pain. Does anyone know of a work around to doing these kinds of simple spatial queries that doesn't require me to have so much junk data to get my results.

I am using ArcView 10.0 and I have two database connections, one in SQL and the other in Access.

Thanks in advance!!

Outcomes