Link to home
Start Free TrialLog in
Avatar of sbauch
sbauch

asked on

building bounding box from esri shapefile

I have ESRI shapefiles from a gov source.  I want to grab bounding box coordinates, a best fit rectangle that circumscribes the geographical region.  I need to get the lat/long min/max values (all 4) into a csv.  Found this tool http://www.obviously.com/gis/shp2text/ but cant figure out how to use it.  
SOLUTION
Avatar of TommySzalapski
TommySzalapski
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sbauch
sbauch

ASKER

Yeah exactly I don't code.  I built a drupal site using point and click, and I'm trying to do this to set up a geo taxonomy system without typing out all of my taxonomy terms and bounding boxes.  I also don't really understand the bounding box exactly.  Looking through the shp.xml file in a text editor I see this:

<geoBox esriExtentType="decdegrees">
                  <westBL Sync="TRUE">-74.257465</westBL>
                  <eastBL Sync="TRUE">-73.69945</eastBL>
                  <northBL Sync="TRUE">40.915808</northBL>
                  <southBL Sync="TRUE">40.495805</southBL>
                  <exTypeCode Sync="TRUE">1</exTypeCode>
            </geoBox>

but that's the only place where I see coordinates.  The shapefile I downloaded is for NYC boroughs, so my impression was that this file would have bounding box values for all 5 boroughs, whereas that looks like it might be the coordinates for a box that bounds all of NYC.
my idea is :
on this site is an online file converter:
http://www.gpsvisualizer.com/gpsbabel/
, you can convert the file to google earth kml file , then open the kml file in google map and modify the coordinates

hope it helps
Can you post the .shp file and the shp.xml file if they aren't super large or link to where you downloaded them would be better.
quicksilver, that's for waypoint files and such. I don't think it will work on .shp files.
Avatar of sbauch

ASKER

link here:

http://www.nyc.gov/html/dcp/html/bytes/dwndistricts.shtml#bcd

I want to have a multiple level hierarchy, so I eventually need 2 csv files, one for borough bounds and one for whatever gov't label fits common neighborhood bounds best
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sbauch

ASKER

hmm I get this error when trying to export coordinates to excel:

Error: 5 - invalid procedure call or argument.
In: Form1.frm\Private Sub mnuExportToExcel_Click
At Line: 1

More than willing to paypal you $20 to do this for me. Is that allowed by EE's terms? I'm not a student
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That first sheet I posted has all the formulas you'll need. You should see an 'Upgrade points' button and the top of the question.
After you get this closed hit 'Ask a related question' to ask how to convert from X,Y to lat/lon. It will notify me. I think I have an idea.
Or just do it now.
Avatar of sbauch

ASKER

how do I change # of points?