New answers tagged

2

It seems that Spatialite's ST_LocateAlong function only returns a value if the searched value is directly found on a vertex. It does not interpolate between vertices. It's what's written in Spatialite's manual: ST_LocateAlong( geom Geometry , m_value Double precision ) : Geometry Return a derived geometry collection value with elements that match ...


1

There is a workaround that can solve your problem. You can create a new dataset (in CartoDB, Excel or another spreedsheet software) with the same number of rows (19), add the extra columns with the values you need. And then merge the region_polygons dataset with this new dataset. Here you have a tutorial about how to merge two datasets.


0

If you would like to get distinct geometries, use in postgis: SELECT DISTINCT your_geom_column FROM your_table; If you are interested in the number of points at the same positions: SELECT your_geom_column, count(*) FROM your_table GROUP BY 1;


0

The excel parameter's datatype would be 'File', with a filter of "xls;xlsx" as per @crmackey comment. The sheet parameter's datatype would be 'String'. There is no automatic behavior for populating the 'sheets' into a combobox/choice list from the 'File'. This is something you'll need to do yourself. Fortunately this has been done, you could just copy the ...


2

An alternative to CSV or dBase is to write to a personal geodatabase table, which is essentially an Access table. You if need your data in Excel (xlsx) then you could import it with the tools in Excel. I would recommend writing to a personal geodatabase as it will accept unicode characters, so all your problems discussed above simply go away. You also write ...


2

You can download Python package XlsxWriter, write a script and import to your toolbox for use in your model: https://pypi.python.org/pypi/XlsxWriter


2

I think your problem is that you're trying to save your output in your geodatabase. Change endingP to: endingP = r"C:\Directory\ArcGIS\output.xls" And see if that works.


0

I solved the issue. I figured out that I could create a line layer from the State provided PLSS polygon layer. To removed extra vertices from the line layer: I merged all lines, planerized all lines, then generalized all lines with a tolerance smaller than that of the shortest section line. Then I used the "snap" tool (making sure to select the "vertices" ...


1

I think you try to first and foremost convert your raster data to vector using the Raster to Polygon (Conversion) tool prior to joining it to the other dataset and exporting to Excel.


0

Sometimes I have needed to be dynamically linked to an Excel sheet that others interact with. One thing you might try is to open Access, go to the External Data tab, hit the Excel button, select Link to the data source by creating a linked table, and ensure your fields are all importing as the correct type. If you create a database connection with the ...


0

Might be good idea to review this since you said it is clean and doesn't contain any characters, sometimes you might be missing something... http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm


2

Save your excel file as a .csv, or export the excel file as a .dbase table or into a geodatabase. You should then be able to successfully join.


1

Here is a very useful ESRI blog you (and anyone else) who intends to link data held in Excel with ArcMap should read. It explains the many pitfalls there are with Excel. I personal avoid using Excel like the plague and get my data into personal geodatabase which is essentially a spatial enabled Access database. Much easier to read and write from and you ...


1

Be sure of the type of your columns (date sometimes crash) and their names (no space, no special characters). It could also be the encoding (make a try with UTF8.) or your csv delimiter.



Top 50 recent answers are included