Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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? – Kirk Kuykendall 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
share|improve this answer
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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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