Tag Info

New answers tagged

1

So now I got it. I tried something else. I wanted to remove the space out of the numbers which are these ID to join the csv. I could delete the space with the field-calculator, the funnction for that is replace("text",' ','') so and then the space was deleted. then I joined the csv and dadada it works. the values are all there, not NULL anymore. Thank you ...


2

I had same problem. I solved the problem. My solution: StringBuffer tmpStr = new StringBuffer(); tmpStr.append("ID,date,tstamp,X_prj,Y_prj,NEAR_FID,NEAR_DIST\n"); SimpleFeature f = null; int index = 0; String ID = null; while(simpleFeatureIterator.hasNext()){ f = simpleFeatureIterator.next(); index = f.getID().lastIndexOf('.'); ...


0

Here is one option using ArcGIS if the point data is regularly spaced: Create a feature class (fc) for each of the coordinate x/y pairs (R,M,L) Merge fc together from step 1 Use Create Fishnet tool to create polygon layer (you will have to define the number of columns and rows or cell height/width value) You may have to do some clean up using various ...


0

If you have one data value per line, I suggest to take the middle coordinates, and import coordinates and value as point data. In a second run, you can interpolate the data of different runs into a raster, if they are neatless. UPDATE If you are only interested in the swath polygon, I suggest to import the left and right coordinates in two runs as lines ...


2

Chad Cooper is right. change Text Field Length in Field Mapping. Make sure your length doesn't exceed your ouput workspace (FileGeodatabase, SDE, DBF) text field length limitation


0

Work around to this is to use the Conversion Tools>Excell>Table To Excel. This parses properly. Could be that there is a bug in ArcMap 10.2.1 Dor Desktop, for Attribute table export to csv with long value content such as commonly seen in UTM coordinates, 6 and 7 significant digits. These may get parsed with double quotes and internal thousands seperators ...


1

It turns out the Centroid(X) and Centroid(Y) in MapInfo are not the line centre point coordinates in BNG. (However to get around the rounding problem I exported the table as a DBF). Instead, I generated these in ArcGIS instead and got perfect results. I achieved my desired result by calculating differences in X and Y values between subsections and taking the ...


0

The reason must be somewhere in QGIS or in the GDAL version that it is using. Direct use of GDAL v.2.0-dev gives me an expected result: ogrinfo ECS-GIS-Locations_2.4.csv -al INFO: Open of `ECS-GIS-Locations_2.4.csv' using driver `CSV' successful. Layer name: ECS-GIS-Locations_2.4 Geometry: None Feature Count: 3 Layer SRS WKT: (unknown) X: Real (0.0) ...


2

What you are looking for is essentially an upsert (albeit without the update part). This is not part of ogr2ogr and is fairly complicated to implement in Postgres, see the docs, for more information than you would ever want to know about upserts. A simple alternative, would be to use a temp table to insert into from ogr2ogr and then run an insert for only ...


1

GeoRSS comes in several flavours - you could use simple which is a step up from CSV. This gives you an entry like: <entry> <title>M 3.2, Mona Passage</title> <link href="http://example.org/2005/09/09/atom01"/> <id>urn:uuid:1225c695-cfb8-4ebb-aaaa-80da344efa6a</id> ...


2

Normalizing the data leads me to some missing ideas/points. Also, I think Excel can do everything you want for the "database" you contemplate. Hint: Use sheets, or multiple files and use variations of Lookup functions. Save into the useful file(s) for imports/lookups from QGIS I envision these discrete tables [or excel sheets], to start off your data ...


4

One option its to make use of 2 coordinateExtractors , 1 for index 0 (1st coordinate) and another with index -1 (last coordinate) .



Top 50 recent answers are included