Leaflet and Google maps created by GPS Visualizer can now display ski trails from OpenSnowMap as a background map option. More 30m-resolution DEM elevation data has been installed on GPS Visualizer's server: new LIDAR-based files ("ODP1") for Iceland, and NASA SRTM1 data for Central America, the Caribbean, and northern Queensland. When tickmarks are added to a Google or Leaflet map, the "description" field of the tickmark will now contain the distance (for time-based tickmarks) or time (for normal distance tickmarks), if your input file contains the relevant data. If you create a Google or Leaflet map where the markers are displayed in folders in the marker list, you can use the gv_options.marker_list_options.folder_zoom parameter to automatically include a "zoom to contents" link next to the name of the folder. The JavaScript-based tool that can retrieve elevation data from the Google Maps Elevation API (using your Google API Key) has been updated so that it can look up 500 points at once this saves both time and calls to the API. GPS Visualizer's "NED1" collection of elevation data has been updated with the latest files from the US Geological Survey's 3D Elevation Program, which uses LIDAR to improve the accuracy of elevation data. GPS Visualizer now has basic support for Points, LineStrings, MultiLineStrings, Polygons, and MultiPolygons in GeoJSON (.json) FeatureCollection files. GPS Visualizer is based in Portland, Oregon, and has been on the Web since October 2002. xlsx),Īnd of course tab-delimited or comma-separated text. Garmin MapSource/ BaseCamp/ HomePort (.gdb), GPX (a standard format used with many devices and programs, including Garmin's eTrex, GPSMAP, Oregon, Dakota, Colorado, & Nüvi series), GPS Visualizer can read data files from many different sources, including but not limited to: Or, you could send an Amazon wish list item. GPS Visualizer is a free service and hopefully always will be however, if you find it interesting, time-saving, or just plain fun, you can say "thanks" - and encourage further development - by clicking the button above and making a contribution via credit card or PayPal. Data can be moved by SQL: INSERT INTO new SELECT. Calc files can be much bigger, but always check if all your data is back in the database.īetter: do as and modify an empty table. I would guess nobody would try this with really big databases, but I should mention it anyway: A lot of people lost databat the end of their tables saving in. The Auto-detect “features” of calc can silently change data, for example if misread as Date (1234.05.06 is just text, but 12.05.06 is converted to an integer representing a date) and depending on your settings you may alter data. odb-embedded database, wich can contain several tables, all queries, forms you will loose data!Įven for. dbf” instead of save under original file-name. Your way is possible for dbf and csv/tsv, as this files are actually tables and now you also state “save back as. And also I import and export tables between Base and Calc quite often - I get data sent to me as an Excel file (don’t have a choice about it) that I want to add to a database. I guess I should say that I had no data in the table - I was using a copy of a pre-existing database as a template and needed to add and change a couple of field names in one table. I might have to edit a couple of queries and a form… but quicker than having to make a new table, typing in 15 field names etc. I did have to go through and reset the field type of each field. Gave it the same name, used the column headings as field names etc. Added a new column and the new field name I wanted.ĭeleted the table in Base, went back to Calc and exported (dragged back) the table to Base. I ‘imported’ (dragged the table into) a blank calc sheet. Probably easier/safer If you haven’t got lots of data in your table and I would make sure I had a backup first and know the ‘field type’ /settings of each field. (Although I guess I should look at MySQL Workbench…) Not as professional but I found a work around that I found easier than using SQL. I came across this (old) question trying to do the same thing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |