New answers tagged

0

Create a unique ID field in the first column of the CSV file and populate it with a sequence (1,2,3...). Then load the CSV and join it to the shapefile. I've had Qgis display null values in the attribute table until I included an ID column to the data.


1

Not sure if you need a record for each or if the forward slash is the only issue. but if it is just dealing with the forward slash, try this. Add a new field to your shapefile and enter this is field calculator: !SOURCEFIELDHERE!.replace(chr(47),"") Then do a copy of your field in Excel and do a find/replace and replace the forward slashes with nothing. ...


1

This is called conflation and if you have ArcGIS 10.2 and an Advanced license you can use the Detect Feature Changes tool (under Data Management Tools, Data Comparison Toolset). If the two lines have a common road name attribute that can improve the matching process. My approach was to manually get a one-to-one match set up in the match table (most 1:1 ...


0

If you are intending to do analysis with this data consider setting up a RELATE, this will help you pass selections from one table to another, eg. you select the polygon on screen and then run the relate that passes the selection to the hospital admissions table. So one polygon selecting many admission rows. If you intend to summarize and display this ...


2

FROM should contain table names, not column names (and 100 is missing here in the table name) The ON part should connect columns from both tables, but you have specified the same table on both sides. I suggest to put the whole sql statement in quotation marks, single ones for Linux and double for Windows. The roles of dst_datasource_name and ...



Top 50 recent answers are included