topic Selecting from a Database Table in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/selecting-from-a-database-table/m-p/86173#M2972 <HTML><HEAD></HEAD><BODY><SPAN>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:</SPAN><BR /><BR /><UL><BR /><LI>saving the db table as a csv, </LI><BR /><LI>importing the table to Arc,</LI><BR /><LI>saving the layer,</LI><BR /><LI>performing my selection,</LI><BR /><LI>exporting the table again, </LI><BR /><LI>importing the table back into my database.</LI><BR /></UL><SPAN>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. </SPAN><BR /><BR /><SPAN>I am using ArcView 10.0 and I have two database connections, one in SQL and the other in Access.</SPAN><BR /><BR /><SPAN>Thanks in advance!!</SPAN></BODY></HTML> Fri, 19 Oct 2012 15:31:34 GMT JasonTaylor 2012-10-19T15:31:34Z Selecting from a Database Table https://community.esri.com/t5/geoprocessing-questions/selecting-from-a-database-table/m-p/86173#M2972 <HTML><HEAD></HEAD><BODY><SPAN>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:</SPAN><BR /><BR /><UL><BR /><LI>saving the db table as a csv, </LI><BR /><LI>importing the table to Arc,</LI><BR /><LI>saving the layer,</LI><BR /><LI>performing my selection,</LI><BR /><LI>exporting the table again, </LI><BR /><LI>importing the table back into my database.</LI><BR /></UL><SPAN>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. </SPAN><BR /><BR /><SPAN>I am using ArcView 10.0 and I have two database connections, one in SQL and the other in Access.</SPAN><BR /><BR /><SPAN>Thanks in advance!!</SPAN></BODY></HTML> Fri, 19 Oct 2012 15:31:34 GMT https://community.esri.com/t5/geoprocessing-questions/selecting-from-a-database-table/m-p/86173#M2972 JasonTaylor 2012-10-19T15:31:34Z Re: Selecting from a Database Table https://community.esri.com/t5/geoprocessing-questions/selecting-from-a-database-table/m-p/86174#M2973 <HTML><HEAD></HEAD><BODY><SPAN>I'm not sure, if I understood you correctly - so just a thought.</SPAN><BR /><BR /><SPAN>You can try </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00170000006r000000">Make Query Table</A><SPAN> tool which allow to query directly tables from OLE DB connection and Spatial Database connection.</SPAN><BR /><SPAN>You can specify which files to preserve and enter SQL query expression.</SPAN><BR /><BR /><SPAN>The output is a temporary table view which can be used as an input for Make XY Event Layer tool.</SPAN><BR /><SPAN>Then you can chain those two tools in model tool.</SPAN></BODY></HTML> Fri, 19 Oct 2012 18:16:01 GMT https://community.esri.com/t5/geoprocessing-questions/selecting-from-a-database-table/m-p/86174#M2973 MarcinGasior 2012-10-19T18:16:01Z