Hello We are trying to build the EPSG database downloaded from the IOGP web site. We took the latest version which is EPSG-MySQL-export-9.8.2. It contains the following files:
MySQL_Data_Script.sql MYSQL_Key_script.sql MySQL_Table.sql We copied the files in a ExternalSources folder. It did not load. After looking at the code (InstallationScriptProvider.java) we figured out you were looking for different file names (EPSG_*.sql). We changed the names and also added 's' at the end of Key and Table to match what the code is looking for. So now we have: EPSG_Data_Script.sql EPSG_Keys_script.sql EPSG_Tables.sql Eventually it starts loading but then we get the following error: WARNING [CRS] Can not create the EPSG schema in database. An error occurred in file “EPSG_Data_Script.sql” at line 167,071. ┃ SQL: INSERT INTO "EPSG"."Change" VALUES ( 2011.043, ┃ '2011-04-11', ┃ '2011-06-20', ┃ 'OGP', ┃ 'Amend NAD areas', ┃ 'Area; Coordinate Operation', ┃ '1323-1325 1334 1337 1349-50 1511 1546-50 2137-2150 3114-3117 3206 3404-3407 3419-3420; 1252.', ┃ 'This clarifies the use of these GeogCRSs as either onshore or onshore and offshore. NAD27 onshore and offshore Canada \& US east coasts, Alaska, GoM and Cuba. Other areas onshore only. NAD83 and NAD83(NSRS2007) are onshore \& offshore. NAD83(HARN) onshore.', ┃ ┃ 'For Areas 1323-1325, 1334, 1337, 1349-50 1511 1546-50 2137-50 3206 3114-17 3404-07 and 3419-20 , amended description and name where appropriate. Added areas 3864 3866-67 3872 3883. For tfm 1252, changed area code from 1334 to 3883.' ) ╹ Caused by SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'This clarifies the use of these GeogCRSs as either onshore o&' to length 254. Can you please advise? We have tried to edit the file and shorten the comment but then it gets another similar error further down. Thankw -Thierry
