New answers tagged excel
You need to have GIS data, for example (State Boundary), in Arcmap in order to visualize the excel population data in GIS. The state boundary should have a field of StateName or State_Name that the names of the states in this field should be exactly similar to the names of the states in the State Name field in Excel. Otherwise, there will be no join relation ...
Firstly you'll need a spatial layer showing the state boundaries. A rough dataset is included with ArcGIS and is located at C:\Program Files (x86)\ArcGIS\Desktop10.2\TemplateData\TemplateData.gdb (or a similar path on your computer). You'll need to make some changes to your Excel file before you add it to ArcMap. Note that the column names cannot have ...
Your Latitude should be on the Y axis. Longitude on the X axis. You have them backwards.
Since TableToExcel takes an input of Table View data type, I believe you'd have to do something like this: inlayer = arcpy.mapping.Layer("mylayername") arcpy.MakeTableView_management(inlayer, "inlayerTableView", "", "", "") arcpy.TableToExcel_conversion("inlayerTableView", "C:/TEMP/export_tables/" + title + ".xls", "ALIAS") Per the documentation, the ...
I constructed two possible versions of my variables of interest, one assuming that the tool was returning "unpacked" values, and one assuming they were still "packed" and needed adjustment. I plotted them against each other and against another source and it seems like the tool actually returns unpacked values. No rescaling or offsets should be required.
ArcMap can load lots of dataformats. The direct load of xls/xlsx is pretty nice as you have all the named sections beside the tables and don´t need to transform anything. There are some guidelines (directly copied from ArcGis resources) how the tables in Excel need to look like: Field names need to start with a letter. Field names should only include ...
You could do the following. Save the Spreadsheet as a csv file. Open the csv in a text editor, and search/replace the commas for nothing (just leave a single space). Add the rest of the information to the header of the file above the values. Watch for the word wrapping as noted in the comment below. ncols 480 nrows 450 xllcorner -82.34552 yllcorner ...
I have this issue all the time. You need to make sure all the fields in the spreadsheet are formatted as "text".
For WGS84 data, many of your values are out of range (see WGS84 Spatial Info Page): WGS84 Bounds: -180.0000, -90.0000, 180.0000, 90.0000 Projected Bounds: -180.0000, -90.0000, 180.0000, 90.0000 I have a feeling that somewhere along the way, your excel file became corrupted or when the points were created (I'm assuming via script), many of the ...
There is an unsupported excel datastore in GeoTools that can be added to GeoServer to work directly from your spreadsheet. But the easiest answer would be to open the file in QGIS and save it as a shapefile.
If you have only 400 sites, I'd recommend converting it to JSON. Or you could load the CSV directly using a Leaflet plugin like this: https://github.com/mapbox/leaflet-omnivore Or if you want to point and click, load it into CartoDB. Get in touch if you want someone to do it for you =)
Did you try to export your .xls file to dBase Table then join and export. This should work by my experience.
I have problems with Excel all the time, hate it! Convert your Excel file into a table (dbf or geodatabase table) Now check that table looks OK, right number of rows/correct field names Do your join with this new table and export that.
Top 50 recent answers are included