CODEWITHSUNDEEP
csvgistype-conversion
AJMansfield
AJMansfield

Reputation: 4175

How to convert geographic data to CSV

I am trying to obtain accurate site geometry for a particular location in Autodesk Revit. The site in question is located near 19621 Waters Road, Germantown MD 20874-0000. The problem is that I can only import CSV or other comma delimited text, or a CAD format, into Revit, but height data for the region at the nessisary resolution is only available from USGS mational map thingey in ArcGrid, GeoTIFF, GridFloat, and BIL_16INT formats. I am working on a computer where (because of systemadmin stuff) I can't run any unapproved executables or anything, and my home computer doesn't have Windows, only Ubuntu. Does anyone know a way to convert the data to what I need, or know of a better whay to obtain this?

Upvotes: 1

Views: 1145

Answers (2)

Apsis0215
Apsis0215

Reputation: 115

I have a routine that did thins using google earth, VBA and excel... You have to install the google earth developers package but it works pretty well- grabs images off GE and coordinates it with revit VIA a CSV file.

Revit Tricks Blogspot

Upvotes: 1

nadya
nadya

Reputation: 240

If your ARC GRID is an ascii file (not binary), don't worry about .asc and just open it in Notepad. You will find there words xllcorner, yllcorner and cellsize, and values for cell centers. Keywords xllcorner and yllcorner are coordinates of the low left corner of the grid. (And you need to know what is the coordinate system of the file and if it is the same which you want to import as csv.)

Then you can calculate (for example in Excel) the coordinates of each cell center using cellsize. And then write all this in three columns x,y,value into a text file name.csv.

Upvotes: 1

Related Questions