Tag Info

New answers tagged

1

http://support.esri.com/em/knowledgebase/techarticles/detail/41763 For ArcGIS 10.1+ from arcpy import da import os inTable = arcpy.GetParameterAsText(0) fileLocation = arcpy.GetParameterAsText(1) with da.SearchCursor(inTable,['DATA','ATT_NAME']) as cursor: for row in cursor: binaryRep = row[0] fileName = row[1] # save to disk ...


3

To answer the original question, from here, it states: If you do not have ArcInfo Workstation installed, the Coverage toolbox will not appear in the list of available toolboxes. I understand your confusion - search shows it, but it doesn't open. If you expand the toolbox under System Toolboxes or the ArcToolbox window, you don't see the Coverage ...


1

I can reproduce your issue with 10.2, strange. But you can open the tool by right-clicking it in the Search results > Locate in Catalog > and then double-click it from the toolbox.


1

It seems you're overcomplicating the use of SRS flags. If you have source data from two spatial reference systems (SRSs): EPSG:4269 (Census data) and EPSG:3081 (Texas data), and your desired SRS (in PostGIS) is EPSG:4269 (same as Census data), then you'd use two variations of the ogr2ogr command. For the Texas data, specify source and target SRSs, so data ...


2

You say that you're open to using FME for this but don't want to run in a Windows environment. Good news, as of FME 2014, FME now runs on a Mac as a "technical preview". With FME, you can bypass many of your intermediate steps and go straight from DWG to Google Earth. I would have open a DWG reader and connect it to a Trimble Sketchup Writer. You can ...


1

The bbox for osmosis should have the order left - right - top - bottom. Note that West of Greenwich has to be negative. Alternatively, you can write something like --bb left=30. right=34. bottom=53. top=57. to avoid any misunderstanding. See http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.44#--bounding-box_.28--bb.29 EDIT The Map-Writer ...


2

The ST_Polygonize aggregate in PostGIS will return a geometry_dump containing all possible polygons formed by a set of lines. I'm assuming the block IDs shown in your example are not related to the IDs of input linework. If this is the case, you can get your polygons and IDs with: SELECT (st_dump).path[1] as poly_id, (st_dump).geom FROM (SELECT ...


1

Once you coverted the DWG to DXF you should be able to use GDAL/OGR. Note that you have to use DXF version 2000 (http://www.gdal.org/ogr/drv_dxf.html). I have recently used ogr2ogr with the -gcp (ground control point) option (http://www.gdal.org/ogr2ogr.html) successfully to geolocate DXFs. Thus, with ogr2ogr you can covert the DXF to Shapefile and ...


4

I think you may need to process this file yourself - either manually, or by writing a script to automate the extraction. If you rename the file GMRT.kmz to GMRT.zip you can open it in WinZip or similar, and see its contents. This includes the file doc.kml, which contains a number of Links - examining the first link shows a URL: <Link> ...


1

That loads two raster layers in Google Earth. I don't think QGIS (through GDAL) supports reading that KMZ (not a KML) because of it. ogrinfo below can't recognize the geometry, even with the libkml (google) driver. ogrinfo -ro -so GMRT.kmz -al ERROR 1: ERROR Parseing kml Style: No id ERROR 1: ERROR Parseing kml Style: No id INFO: Open of `GMRT.kmz' ...


1

If you have access to Autocad map 3D you can export point, polylines and lines into shapefiles that you can import into Qgis. If there is attached data you would be able to have it associated with the shapefiles and have it showing up in the attributes table when loaded in Qgis


1

Converting OSM to PBF is probably not necessary, most tools that can read PBFs can also read OSM XML. If you do need to read the file with osmosis, the issue here is that ogr2osm by default generates files that can be loaded in JOSM and merged with existing OSM data. These files have no timestamp or version attributes as well as having negative IDs, while ...


0

The OSM wiki lists some more tools for converting shape files to .osm. Maybe try another one?


0

Have you tried this? Shp2OSM & PG2OSM You may need one step in Postgre ...


0

The .osm file you create with the script does not have version/user/timestamp attributes. Osmosis does not like that. I guess you have to look for other ways to get your map file. I'm not sure how you want to do the last step anyway.


1

About the DB sizes and Excel import failures: Trying to import the file in XLSX fails after a while. In production we have monitoring services that will kill imports taking too much and/or going out of memory. Importing from Excel is terrible because the internal format forces you to read the whole file into memory before being able to export in CSV (we ...


1

Have you tried doing a PostgreSQL VACUUM? Usually with that you will regain some space, as for performance CartoDB's Postgres does not automatically perform it after actions like column type change*. Importing from XLSX is the same as importing from CSV (in fact, we convert first to CSV and then import), so column types are lost. Other formats like ...


0

With a table in UTM SELECT ST_X(table.geometry) AS X1, --point x ST_Y(table.geometry) AS Y1, --point y ST_X(ST_TRANSFORM(table.geometry,4674)) AS LONG, -- longitude point x SIRGAS 2000 ST_Y(ST_TRANSFORM(table.geometry,4674)) AS LAT, --latitude point y SIRGAS 2000 ST_ASTEXT(table.geometry) AS XY, --wkt point xy ST_ASTEXT(ST_TRANSFORM(table.geometry,4674)) ...


4

I would consider two options: Get ArcGIS Explorer. It is a lightweight ESRI GIS Viewer and offered for free. Since it is by ESRI, you will get file geodatabase support. I don't have much experience with it, but it should offer the ability to export the data in another format.http://www.esri.com/software/arcgis/explorer Get QGIS, an open source and ...


0

Googling this returns many informative pages. Here's one: http://www.uwgb.edu/dutchs/usefuldata/utmformulas.htm


3

Here is a user contributed PostGIS function called dms2dd. Your data however looks like Degree, decimal Minutes. You may need to modify the function to suite your needs. functions



Top 50 recent answers are included