Tag Info

New answers tagged

1

I have same problem, my understanding is that the stored data is correct, if you consider it a binary utf-8 encoded data, to convert this data to nvarchar i wrote this (partially tested) UDF function in sql server: CREATE FUNCTION varbinUTF8_to_nvarchar ( @data VARBINARY(MAX) ) RETURNS NVARCHAR(MAX) AS BEGIN DECLARE @n INT DECLARE @buffer ...


0

You can put your polygons or lines in a geojson column. If necessary, you can transform that column in geometries using the st_geomfromgeojson function. update yourcsv set the_geom = st_geomfromgeojson(polygon1) The question is more or less related: ...


1

Add the new values with the Add Values button, not the Add ALL Values button. The add ALL values button will override the existing symbology and re-add all unique values whereas the Add Values button allows you to preserve the existing symbology and add new unique values not present in the Symbol list. EDIT: Also, confirm that after importing symbology ...


1

I think the two messages are separate. The first message is just a warning that anything such as formulae, formatting and additional worksheets cannot be saved in a CSV as it is a simple ascii format. The second message suggests that you maybe have a text field as one of your attributes which contains a comma. This will effectively introduce an extra ...


1

I took a closer look and actually the data wasn't truncated. It's just that some values are bigger (1477701) and others are smaller (203071). I thought I had a truncation issue when I saw the smaller values in the first page of the DBF and the large values from a segment of the attribute table of the shapefile they are supposed to match. On a different note ...


1

QGIS and ArcGIS use two different file extensions for a .PNG image's world file. When you georeference a PNG in ArcGIS, it generates a .PGWX file containing the spatial information for the PNG. QGIS uses the extension .PNGW instead. You can just rename your image's .PGWX files to .PNGW files and they should come in to QGIS correctly.


0

In Rails, you should check the import log as follows: DataImport.find(id: 'f248f418-5d88-4c06-ab2c-4bbbfdea88ce').log Typical errors for CSV files are: - File has some weird encoding. Solution: open it with a text editor and save it as UTF-8. - In the street you're using commas that are being interpreted as new rows. If this is the case, be sure that ...


1

You are correct that if your data are in a small region that you should use a geometry type. However, you would also normally transform the Lat/Long coordinates to a spatial reference system for the region. Normally most folks choose a UTM Zone, which describes coordinates for Eastings and Northing with length units in metres. Check out ST_Transform to ...


0

When using st_length() I can convert to geography using st_length(line.line_geometry :: geography) as was suggested or using ST_Length2D_Spheroid(line.geometry, 'SPHEROID["GRS 1980",6378137,298.257222101]'). Both answers seem to be the same as far as precision is concerned: 580139.3016159851 vs 580139.3016215176. I'm guessing the slight difference is due to ...


0

I did a comparison of various tools about a year back that also contains most of the options mentioned in this thread. As a more direct answer, I use FME a lot due to its versatility. However, when I work with complex data structures such as in CityGML, INSPIRE GML or bigger database models, I use HALE, an open source app developed for ETL and particularly ...



Top 50 recent answers are included