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.

  • 3
    what software are you using? Is this desktop GIS or on the web? More info required
    – Stev_k
    Apr 11 '12 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? Apr 11 '12 at 14:30

I am assuming from GIS database and map view that you are using ArcGIS.

If so the below steps could help.

  1. Activate the Distributed Geodatabase toolbar. Dsitributed Geodatabase Toolbar
  2. Zoom to the map view you want.
  3. Click the extract Data button.
  4. Select Show Advanced Options enter image description here
  5. Enable Current Display extent. enter image description here
  • 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.
    – Anshu
    Apr 12 '12 at 4:43
  • I just want spatial extraction(extract for network objects) process
    – Anshu
    Apr 12 '12 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.