Tag Info

New answers tagged

1

Assuming that you are using a recent version of ArcGIS for Desktop, and I have not tested, but you should be able to use the Excel To Table tool to do this: Converts Microsoft Excel files into a table. I frequently use fields of 4,000 characters in file geodatabase tables and feature classes.


0

This isn't a step-by-step answer, more of an explore-on-your-own answer. To get your LatLon data into XY coordinates, you would want to "Display XY" the excel table and save the event layer as a feature class. After that, there are several options you'll want to explore. There's a tool in ET GeoWizard called "Points To Pie Segments" that may be useful to ...


1

Since I've been helping my (non-GIS user) brother with this lately: Essentially you have to join your data table to your shapefile, but since XLS aren't readable by QGIS, you can use CSV and accomplish the same thing. open your XLS and remove all formatting from the sheet, if any (ie. colours or lines or anything like that) ensure all the column names are ...


2

The answer by @jbosq addresses the issue accessing the parameters and your indentation errors. However, the code as is will open the path to excelfile as a text file, not an Excel spreadsheet and just write the field names separated by a newline to this text file. You need to use xlwt (for .xls Excel 2003 binary spreadsheets) or openpyxl (for .xlsx Excel ...


1

I believe your main problem is in how the parameters are passed to the execute. Defining object parameters works like a function where declarations are not global. Give this a try: def execute(self, params, messages): #params is your parameter list from getParameterInfo shapefile = params[0].valueAsText #first parameter from your list fields = ...


0

Problem solved by reinstalling ArcGIS 10.2.


0

A line with arrows can be made with the line symbology, depending on the software you want to use: How to indicate flow of a watershed feature? . A simple > text symbology can work too. For the curved lines, you have to create great circle lines on a custom aeqd projection. See great circles in QGIS and export in 3857 webmap for a workflow.


0

what version of excel do you have? - from the docs If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver similar, but older, info is here ArcGIS can read both XLS and XLSX files, but you may need to install an additional driver on your machine, depending on ...


0

I am assuming that you are interested in interpolating the data into a raster (unless the points are already in a regular grid). You should import your data into ArcMap as a points layer using the add x/y data tool. Then you can interpolate the points into a raster using your z value with the IDW interpolation with spatial analyst. There are other ...


0

That import error is probably due to a non-valid URL for CartoDB, as it needs the URL to give directly a file in a supported format. What usually happens with Google Drive, Dropbox, Sharepoint and similar services in general is that the URL to share them is not a direct download URL to the exported table but it's an URL that sends you to an HTML site. In ...


1

So I've found out what was it ! I added into the code a column with city names to add as labels on the map. But it only contain a small number of them, and Qgis probably don't like Null values that much... After replacing them with zeros the importation of the .xlsx files went smoothly ;) !



Top 50 recent answers are included