Tag Info

New answers tagged

0

Perhaps opening up an old question - but I think this is relevant. The Make Query Table SQL creator throws an error when you verify, even if your syntax is correct. I created my query without any double-quotes or brackets, simply Table1.Field1 = Table2.Field1 AND Table1.Field2 = Table2.Field2 and did not select verify; I simply ran the tool and my output ...


1

If you've already done the join, yes. If not, then you should start with the Join Field tool. This allows you to directly write attributes from one file to another based on a join (a one-step process rather than join/export two-step).


3

Joining a table to a shapefile won't change any data in your shapefile's attributes (thankfully!). Once you have the table joined to your shapefile, which you've done successfully, use the Field Calculator to copy the values from the joined table's fields to your shapefile's fields: Right-click the shapefile's field heading (we'll call it Field 1). Click ...


1

This tool has saved my life many times when working with excel data, or converting excel data in ArcGIS. The tool is called, Table to Table This tool allows you to format each field before you import - so that you can verify everything is correct (ex. text is text, and date as date). I've found ArcGIS works funny with excel, and it's best to import excel ...


2

Before getting to the solution to your question, I need to clarify exactly what you're wanting to divide/compare. If you're wanting the areas in all of red vs all of green, you can skip this part. However, if you want to directly compare the areas of name and type within the same total boundary, you'll need to first clip red to the extents of green. Your ...


0

If I understand your question correctly, you could try the following: Add the .csv file with the 450 locations layer as a Delimited Text Layer and select the appropriate options Add the other .csv file again as a Delimited Text Layer but select the No geometry (attribute only table) option From the Processing plugin, select the Join attributes table ...


0

After typing the following into the Python console: import processing processing.alghelp("qgis:joinbylocation") You get this: ALGORITHM: Join by location INPUT1 <ParameterVector> INPUT2 <ParameterVector> SUMMARY <ParameterSelection> STATS <ParameterString> GEOMETRY <ParameterSelection> KEEP <ParameterSelection> OUTPUT ...


0

@ghostfacemapper the records do not need to be in the same order. Not true at all. Now, if you are getting an error that says: ERROR 000339: Input [YOUR FILE NAME] does not have OIDs Failed to execute (Join Field). You can fix the problem by 'adding' an objectID field by using arcGIS to make a new table that has an objectID. You can do this by ...



Top 50 recent answers are included