Is it possible to extract a small portion of data from an entire database? If possible then how can I do it. I want data to be extracted which is within my map view only, so that other data objects are excluded: only objects contained in the map view should be in the extract.
-
3what software are you using? Is this desktop GIS or on the web? More info required– Stev_kCommented Apr 11, 2012 at 11:11
-
Just to clarify, by "contained in" do you mean the features fall entirely within the current extent, or that they overlap the current extent?– Kirk KuykendallCommented Apr 11, 2012 at 14:30
Add a comment
|
2 Answers
I am assuming from GIS database and map view that you are using ArcGIS.
If so the below steps could help.
- Activate the Distributed Geodatabase toolbar.
- Zoom to the map view you want.
- Click the extract Data button.
- Select Show Advanced Options
- Enable Current Display extent.
-
Thanks for your reply.I am using GE Smallworld GIS and I want the small portion of data to be extracted as Datastore file so that using that DS file I can open new image...Please suggest method for this.– AnshuCommented Apr 12, 2012 at 4:43
-
I just want spatial extraction(extract for network objects) process– AnshuCommented Apr 12, 2012 at 5:01
As with your other question, you've failed to specify which database you're using and the SQL will vary a bit between databases. I'll leave others to deal with this aspect.
Given you're apparently using FME (per your other question), you can use that to do it in a couple of ways:
a) Once you've added the reader you can specify Maximum x,y and minimum x,y as parameters and the reader will only select features within those bounds. That creates a square bounding box.
b) Alternately you can pass the data through a SpatialFilter and check against a shape of your given area. Use the "INTERSECTS" test.
answered Apr 11, 2012 at 12:04
