In 8.0.17 INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS is not prepopulated with ORGANIZATION="EPSG" records, leaving the table with only a single record, that for the default SRID=0.  A count in INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS of 1 record instead of the 5152 records found in 8.0.15.  It's breaking my load scripts with the following error due to the previously available spacial reference systems being omitted.  ERROR 3548 (SR001) at line 1: There's no spatial reference system with SRID 4326.   Is this a documented intentional change, or am I missing something?  This is not mentioned in the release notes:     My installations are both default AWS RDS installations made at different times resulting in different mysql versions. The reference systems are present on the prior installation but missing on the second.  version   8.0.15 innodb_version    8.0.15  SELECT count(*) FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS; 5152   version   8.0.17 innodb_version    8.0.17  SELECT count(*) FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS; 1
122173
On aws RDS I have an mysql 8.0.16 instance running. My problem is now, that the INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS table is empty.  This is a problem for me because I would like to create the following table:  CREATE TABLE my_table (     ...     coordinates            POINT         NOT NULL SRID 4326     ... );   But this leads to an error message that says There's no spatial reference system with SRID 4326.  Whats going on here? Why is the table empty? I would expect it to contain at least one entry for the SRID 4326.
91634
After considering a few options, I'm trying to give my 15-20 QGIS 2.2 users the ability to concurrently view/edit one or two basic point PostGIS layers, largest one has just 16,000 records. I've installed PostgreSQL 9.1 / PostGIS 2.0 and basic testing seems to work ok but haven't unleashed it to the masses yet.  We'll typically only have 2-3 editors at a time, but possibly 15 viewers. Edits will all be in QGIS, viewers will be QGIS and ArcGIS (but we don't have SDE).  As I said, these are just basic point files, and  edits will just be adding/deleting points and some table edits. I am not worried about editing the same features at the same time.  Can the combination provide dependable multi-user editing for two basic point files?
97745
I have a database setup with the following schema:   CREATE TABLE siteInfo (     siteID             SERIAL  NOT NULL,     siteName           TEXT    NOT NULL,     siteHost           TEXT    NOT NULL,     notes              TEXT    NOT NULL,     allowableCountries TEXT    NOT NULL,     displayChance      INT     NOT NULL,     imagePath          TEXT    NOT NULL,     PRIMARY KEY (siteID) );  CREATE TABLE siteLinks (     siteID             SERIAL  NOT NULL,     URL                TEXT    NOT NULL,     FOREIGN KEY (siteID) REFERENCES siteInfo(siteID) ON DELETE CASCADE );  CREATE TABLE siteDemographicLinks (     siteID             SERIAL  NOT NULL,     URL                TEXT    NOT NULL,     country            TEXT    NOT NULL,     chance             INT     NOT NULL,     FOREIGN KEY (siteID) REFERENCES siteInfo(siteID) ON DELETE CASCADE );  CREATE TABLE linkVisits (     siteID             SERIAL  NOT NULL,     rawVisit           BIGINT  NOT NULL,     redirects          BIGINT  NOT NULL,     FOREIGN KEY (siteID) REFERENCES siteInfo(siteID) ON DELETE CASCADE );   Data from my form is in the following format:  array(7) { ["siteName"]=&gt;string(9) "Site Name" ["siteHost"]=&gt;string(9) "SIte Host" ["notes"]=&gt;string(5) "Notes" ["links"]=&gt;array(2) {[0]=&gt;string(6) "Link 1" [1]=&gt;string(6) "Link 2"} ["countries"]=&gt;string(4) "None" ["displayChance"]=&gt;string(2) "15" ["extraLink"]=&gt;array(2) {    [0]=&gt;array(3) {       ["url"]=&gt;string(7) "dSite 1"       ["countries"]=&gt;string(4) "NONE"       ["chance"]=&gt;string(2) "11"       }    [1]=&gt;array(3) {       ["url"]=&gt;string(6) "dSite2"       ["countries"]=&gt;string(4) "None"       ["chance"]=&gt;string(2) "13"       }    } }   How would I go abound inserting data into the many type tables so they reference tuples inserted into the one type table?  I have this query constructed:  INSERT INTO siteInfo (siteName, siteHost, notes, allowableCountries, displayChance, imagePath) VALUES ('Sample', 'sample.com', 'note', 'NONE', '50', '../var');   I would then need to insert data into the siteLinks table, which is related to the entry already in the siteInfo table.  INSERT INTO siteLinks (siteID, URL) VALUES ((SELECT siteid FROM siteinfo WHERE sitename='Sample'), 'test');   Is there a better way of doing this?
61849
I have a small table of 10 cities (in one table) that I am snapping to the nearest road (in another table) with the following select and storing the table snapped_cities:  Select b.id, ST_Closestpoint(ST_Collect(a.geom), b.geom) as geom into snapped_cities from roads a inner join cities b on ST_Dwithin(a.geom, b.geom, 1000) group by b.id;   I would however like to have road ids and not just the geom (a.id above). How do I modify the select above to get these?  I use postgresql 9.2 and postgis 2.0  thanks,
28864
After using some non usual SRC for demonstration purpose, I wish to clear my  "Recently used coordinate reference systems" list for the sake of praticity.  Is it possible?   I am using QGIS 2.10.1.
61745
I am working with data in an ArcGIS 10.1 geodatabase.  I wanted to complete the simple task of taking a ten-digit ID field that is currently in String/Text format and create an identical field in Long/Numeric format.   However, Esri's resource pages on tables () do not discuss how to achieve this.  Also, the following GIS/SE thread does not help me either:  and the post mentioned in the comment there refers only to QGIS.    In the meantime, I created a new table with the extra field, joined it to the original shapefile and will reimport this shapefile into the gdb, adjusting the new field format as needed.    Is there an easier way to complete this task?
89908
I want to use ogr2ogr in order to import a shapefile in a postgis database. I have successfully installed ogr2ogr and I run from the pgsql the following command:  ogr2ogr -f "PostgreSQL" PG:"host=localhost user=user_1 password=***** dbname=imports" world_boundaries.shp   What I get back is an error message:  Unable to open datasource `world_boundaries.shp' with the following drivers: --a list of drivers follows (ESRI Shape File etc.)   I have also tried to define the full path of the shapefile but I got the same message.  Also I tried to run the:  ogrinfo world_boundaries.shp   Same thing.    After fixing the issues with the permissions of the file I get the following error:    ERROR 1: AddGeometryColumn failed for layer world_boundaries, layer creation has failed.   ERROR 1: Terminating translation prematurely after failed   translation of layer world_boundaries (use -skipfailures to skip errors)   I also tried to import it through the GUI shp2pgsql and I get the following error:   ALTER TABLE "public"."" Failed in pgui_exec(): ERROR:  permission denied for relation spatial_ref_sys  CONTEXT:  SQL statement "SELECT SRID         FROM spatial_ref_sys WHERE SRID = new_srid" PL/pgSQL function addgeometrycolumn(character varying,character   varying,character varying,character varying,integer,character varying,integer,boolean) line 50 at SQL statement  SQL statement "SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6,$7)"  PL/pgSQL function addgeometrycolumn(character varying,character  varying,character varying,integer,character varying,integer,boolean) line 5 at     SQL statement  Shapefile import failed.   The issue this time was that this database user didn't have sufficient permissions. This fixed it:  GRANT ALL ON TABLE spatial_ref_sys TO my_user_name;   Next error message is:    Warning 1: Geometry to be inserted is of type 3D Multi Polygon, whereas the layer geometry type is 3D Polygon.  Insertion is likely to fail  ERROR 1: INSERT command for new feature failed.  ERROR:  Geometry type (MultiPolygon) does not match column type (Polygon)   So it seems I need to use the parameter: -nlt MULTIPOLYGON But when I do so I get another error, which doesn't make any sense to me:  ERROR 1: PostgreSQL driver doesn't currently support database creation. Please create database with the `createdb' command. PostgreSQL driver failed to create PG:host=localhost user=my_user_name dbname=my_database password=password -nlt POLYGON   But it gets loaded using the shp2pgsql GUI.    Comment of @elrobis enabled this to finally work. Data loaded in db correctly!  ogr2ogr -f "PostgreSQL" PG:"host=localhost user=geonode dbname=geonode_imports password=geonode" -nlt GEOMETRY wld_bnd_adm0_gaul_2015.shp
95577
Here are my configurations: DB type: postgresql (9.3 if that's necessary) Table name: product_sections Column names: section_id (integer) &amp; section_path (ltree)    Detail: I have one reference value: section_id: 15 &amp; section_path: Automation_Solutionz. So, when I want to rename Automation_Solutionz to, say Chrome, I want all references of Automation_Solutionz to be updated.      FROM:  Automation_Solutionz Automation_Solutionz.Test_Case_Creation Automation_Solutionz.Test_Case_Creation.Automation Automation_Solutionz.Test_Case_Creation.Manual   TO:  Chrome Chrome.Test_Case_Creation Chrome.Test_Case_Creation.Automation Chrome.Test_Case_Creation.Manual     Similarly, when I update a value which is in the middle, it should rename those too. In the case above, Test_Case_Creation should be renamed to something like TestCase or anything else. The same goes for any item which is either in the middle, end or at the start.  Hope, I explained things correctly. Thanks in advance :)
32326
How can one change a coordinate system for a .lasd (Lidar) dataset?  The file is currently in UTM_Zone_15N and I am trying to convert it to IL_East.
54545
I'm using PostGIS 1.5.2, with geometries in SRID:900913. I need create a circles using a list of points as centre, with a radius of 600 kilometers. I'm using this query:  INSERT INTO circles (geom) (    SELECT ST_Buffer(point, 600000, 'quad_segs=8')     FROM points );   But circles created have not 600 kilometers of radius (radius is near this length, but not exactly).  Are there other methods to create circles in PostGIS?  NOTE: Information represented is from Spain. Correct projection is 4326, but client use Google rasters, so I am storing data in 900913 to avoid reprojections and increase performance.
44932
I got a problem when I try to load tab-separated text files in the "Create a layer from the delimited text file" tab (that one with de comma symbol). After normally selecting the X and Y fields and clicking OK, the reference coordinate system (SRC) selector screen appears, then the program closes by itself. I had uploaded more than a hundred of this type of file by the same procedure in the previous version of QGIS (2.14 Essen) and have no problem, but since I updated to version 2.18.8 (Las Palmas) I can not load any files or .CSV type.   Do anyone knows what's happening? Am I doing anything wrong?
76218
I have a script which contains several r objects which are CRSs that I use for transforming spatial objects. After updating R and many packages, there is a warning which wasn't there before. LCC &lt;- CRS(&quot;+proj=lcc +lat_1=49 +lat_2=77 +lat_0=0 +lon_0=-95 +x_0=0 +y_0=0 +ellps=GRS80 +units=m +no_defs&quot;)  Warning message: In showSRID(uprojargs, format = &quot;PROJ&quot;, multiline = &quot;NO&quot;, prefer_proj = prefer_proj) :   Discarded datum Unknown based on GRS80 ellipsoid in CRS definition  I understand that this is due to a change in how spatial information is stored... PROJ4 to PROJ6 upgrade and &quot;Discarded datum&quot; warnings ..but beyond that, I don't understand what this error means or if I need to do anything in response. Any thoughts?
19632
I'm importing many sets of geodata into PostGIS, and they have different SRID's. (Some have EPSG:3857, some EPSG:4326, some something else).   I'd like to create an additional geometry column, eg. the_geom_mercator with SRID EPSG:3857, and also keep the original geom column in whatever SRID it came in.  How can I do this with a PostGIS function?
105544
Could you please give the command to add a column to all the tables if the table doesn't contain that column in a schema?  e.g. The schema schema1 contains 50 tables in which 20 tables contain a column named colTest.   I need to add the column colTest to the remaining 30 tables.
115237
How i can transform the geometry WKB for example:  010600002031BF0D000100000001030000000100000004000000CE001744EA0212414BB26942EFE95641DD9AF00E49FF1441706072C152EC56413F53AF6BF9191441242DF04F7EC85641CE001744EA0212414BB26942EFE95641   in the same geometry with SRID 900913?  Ok, i think i found the solution, i use the next:  SELECT ST_SetSRID(st_astext(st_transform('010600002031BF0D0001000000010300000001000000050000008FEF9C07089AFEC0B90A9856E87251410F355DB1B395FEC0DCCEADDCED72514194BE3130A693FEC0DFD23127D072514114797186FA97FEC094E0C313CB7251418FEF9C07089AFEC0B90A9856E8725141'::geometry,4326)),900913)   and i seems to be working
71807
What is the function for getting SRID from Geometry field.   I have inserted a shapefile into SQL Server table with a Geometry field defined. I know the projection of shapefile is Swreff99_1800 (EPSG:3011).   Now my question is How I get this SRID:3011 by using some OGC method of the geometry field?
32303
I have previously saved a copy of /var/lib/mysql/ddms directory ("ddms" is the schema name). Now I installed a new MySQL on a freshly installed Ubuntu 10.04.3 LTS by running apt-get install mysql-server, I believe version 5.1 was installed. After I copy the ddms directory under /var/lib/mysql, some of its tables work fine, these are the tables with an associated set of three files: a .frm file, a .MYD file and a .MYI file.  However, there are two tables with a different set of files: a .frm file and a .ibd file. These two tables didn't show up in the table list in phpMyAdmin. When I look at the error log, it says:  [ERROR] Cannot find or open table ddms/dictionary_item from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version of the engine doesn't support.   Please help with restoring these two tables. Thanks.