Tag Info

New answers tagged

-1

Yeah - you can use Model Builder/Python and the "Field Mapping" Technique to accomplish this.


1

Table POINTS (with column REGION_NAME), Table REGIONS (with column NAME) Add Column "POINTS" (REGION_NAME) From REGIONS Set To NAME Where contains You should replace names for your actual tables and columns.


1

Firstly few questions: 1. what do you mean by converting roads to nodes? Maybe you meant network graph? 2. Are you able to find at least one way and the trouble is with many ways? 3. Nearest school euclidean or by the roads? 4. What was the work-flow of this conversion form roads to nodes? 5. What are the names of tables and column names in this tables? 6. ...


3

Its not a complete answere but I cannot write it in a comment. Since you said you just need a hint with python I came up with this: My test table: import arcpy arcpy.env.workspace = "..." #on windows use \\ #SEARCHCURSOR #SearchCursor (in_table, field_names, {where_clause}, {spatial_reference}, {explode_to_points}, {sql_clause})""" stable = ...


4

Combining the answer of this previous question with the QGIS API results in python code that should do what you ask for. #attach a QgsMapLayerAction to all layers: joinLayerAction = qgis.gui.QgsMapLayerAction( "Join to layer", iface ); #add the action to the QGIS gui, so that it appears as an action for the layer ...


0

I just had the same problem and mmqgis only gave me error messages ("no matching records found"), but here is another solution to the problem that worked perfectly for me.


0

If you prefer to handle this in Excel you can use the TEXT formula. Create a new column in the spreadsheet and use a reference to the column that has the numbers that you want to format as text. Here is an example. =TEXT(A2, "0") After I do this, I will often copy and paste special (values) over the original column and re-save the spreadsheet.


1

In ArcGIS use the tool, 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 into a dBase or dbf using the tool above. I'm a little unclear about what you're trying to do, but I ...


1

Here are two options: Use Make XY Event Layer to create temp points from excel (based on x/y columns) Merge or Append (database schema has to be the same for append option) event layer to destination shapefile OR Use Table to Table to convert excel to .dbf or feature class table Use search cursor to get x/y coordinates and attributes from table, and ...


-1

I know that you're looking for an answer that uses ArcGIS but if you're willing to use QGIS instead, then here is a pluggin called mmqgis. This plugin simply join a shapefile with an excel database.



Top 50 recent answers are included