Tag Info

New answers tagged

1

I think I was able to solve this myself, unless anyone has a better way of doing it. In MapInfo create a new column. Update this column using the value: objectinfo(obj,2). Then convert the file to a shapefile. After loading into QGIS use categorized symbol of the new column you created. The symbols wont be the same as in Mapinfo, but at least you are able ...


0

I would try something like this assuming we're interested only in those geometries that lie inside of some other geometry - these are considered as higher valued. UPDATE polygons -- adjust geometry SET wkb_geometry = new_polygon FROM ( SELECT p1.id, -- take the difference of the geometries ST_Difference(p1.wkb_geometry, ...


2

Assuming the csv is ready to be consumed by arcpy as a table with two columns named OLD_NAME and NEW_NAME, and following the example provided in the question to get to the source shp in the UpdateCursor. #create a dictionary of the csv to join to the shapefile #r[0] is the first item passed to the SearchCursor and used to join to shp #r[1] is the second ...


2

Import the csv as a table so you can see the values then right-click your original layer to choose joins and relates -> join. Be sure "Join Attributes from Table" is the option selected from the pulldown at the top. Choose the old_name from the original layer (under #1), the csv table under #2, and the old_name in the csv table for #3, then click Ok. If you ...


3

In QGIS you can perform Add Vector Join. Right click on your shapefile layer on Layer Panel and choose Properties. Then go to Joins tab. Press the + button, it will create new join. Join layer is your shapefile layer. Join field is field with the common values in both. Target field is your field you want to join to. After that you will get a new ...


1

Using shp2pgsql and pgsql on a Mac system but the principle should be the same as what follows here. Load the modified shapefile into a temporary table; Update the correct row of the original table with only the geometry from the modified shapefile. Load the modified shapefile into PostGIS (I use the Bash pipe ('|') here to send the SQL from shp2pgsql ...


2

Given you're supplying the shapefile data in it's entirety back into Postgres when reissuing the shp2pgsql command, the only way would be to import to a temporary table and copy across the rows that are different to your original. By the time you've had to compare every row, you might as well have replaced the whole thing with the temporary table anyway. ...



Top 50 recent answers are included