3

I think the problem here is that you're passing directly the attribute ($yield_ls) to the ramp expression, and the results are sorted by number of occurrences of each category. In order to classify the content you're receiving, you've to use the buckets as follows: color: ramp(buckets($yield_ls, [ "Fractured 0.0 - 0.1 l/s", "Fractured 0.1 - 0.5 l/s"...


3

You can change the underlying column type. It is likely a geometry column, that you can change to a geometry(point) column. Let's note that the type change will work only if there is only point in the column, so you would have to clean your current data first: Create table public.a( id integer, geom geometry ); insert into public.a values (1, ...


2

Not sure if it was your case, but I found out -I should not be used together with appending data -a. I was importing many TIF files into a DB, and -I actually creates the index again and performs analyse on the table for each file, which takes 10x more time. -I should only be used when creating the table, with -p option.


1

Your question is almost all pandas so you could try posting it to stackoverflow and get a shorter answer. But this seems to work: import pandas as pd import arcpy #I tried with csv input. Convert shapefile table to csv... df = pd.read_csv(r'C:\somefolder\input.csv', dtype={'st_time':str,'end_time':str}) #...or use da.SearchCursor columns = ['ID', 'Year', '...


1

To use another user, add the parameters -U myusername -W -U specifies a username, -W will prompt for the password


1

Just for anyone else trying to do this within QGIS, I've found a way. Create a data only layer with a single column 'FIELD'. This should be populated with all the fields (their exact names) from your target layer that you want transposed as records. Load it into your project. Use field calculator to create a new column 'Results' and populate it with the ...


1

The OpenSpatial spec says numerous things about this, When integrating this SQL with that of SQL/MM, the type-name prefix "ST_" should be used as appropriate. And, Class names in SQL/MM carry a "ST_" prefix. This is optional and implementations may chose to drop this prefix as has been done in various places in this standard. From this Committee ...


1

OGC GeoPackage can have unlimited Vector Features and Raster Tiles. It can be shared on network drive. It's SQLite database so can also be read by any SQLite viewer/browser. In addition, it's mobile friendly and can be viewed /edited in many mobile apps.


1

MySQL Spatial Everyone here is telling you how to do it with PostgreSQL using KNN, without telling you the advantages. Using MySQL you can not determine the nearest neighbor without calculating the distance for all of the neighbors. That's extremely slow. With PostgreSQL this can be done on an index. Neither, MySQL nor MariaDB currently support KNN


Only top voted, non community-wiki answers of a minimum length are eligible