Error in Python code when importing geometry into River Database Tables

Question

Hi - using the 'Baldeagle' data I have created river database tables, however, when I use the 'Import layers into river database tables' tool, I received the errors below.

The database connection seems okay (am using pgAdmin 4), though I read in another post that you need to create a PostGIS extension - I have used a postgres_fdw' extension since 'postgis' is not available from the dropdown list.

Can anyone help? Thanks, Mike

1. Error In the RiverGIS application window:

Import data into RAS PostGIS tables...

ProgrammingError('type "geometry" does not exist\nLINE 3: geom geometry(LINESTRING, 102728),\n ^\n',)

Process aborted!

1. Error in a QGIS window:

An error has occurred while executing Python code:

KeyError: 'StreamCenterlines'

Traceback (most recent call last):
  File "C:/Users/MGreen/.qgis2/python/plugins\rivergis\dlg_rasImportDataIntoRasTables.py", line 298, in acceptDialog
    self.processLayers(key, data)
  File "C:/Users/MGreen/.qgis2/python/plugins\rivergis\dlg_rasImportDataIntoRasTables.py", line 280, in processLayers
    self.rgis.rdb.register[data['className']],
KeyError: 'StreamCenterlines'

Python version: 2.7.5 (default, May 15 2013, 22:44:16) [MSC v.1500 64 bit (AMD64)]
QGIS version: 2.18.3 Las Palmas, 77b8c3d

Python Path:

• C:/PROGRA~1/QGIS2~1.18/apps/qgis/./python/plugins\processing
• C:/Users/MGreen/.qgis2/python/plugins\postgis_geoprocessing
• C:/PROGRA~1/QGIS2~1.18/apps/qgis/./python
• C:/Users/MGreen/.qgis2/python
• C:/Users/MGreen/.qgis2/python/plugins
• C:/PROGRA~1/QGIS2~1.18/apps/qgis/./python/plugins
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\matplotlib-1.3.1-py2.7-win-amd64.egg
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\nose-1.3.3-py2.7.egg
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\tornado-4.0.1-py2.7-win-amd64.egg
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\backports.ssl_match_hostname-3.4.0.2-py2.7.egg
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\certifi-14.05.14-py2.7.egg
• C:\PROGRA~1\QGIS2~1.18\bin\python27.zip
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\DLLs
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\plat-win
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\lib-tk
• C:\PROGRA~1\QGIS2~1.18\bin
• C:\PROGRA~1\QGIS2~1.18\apps\Python27
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\PIL
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\jinja2-2.7.2-py2.7.egg
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\markupsafe-0.23-py2.7-win-amd64.egg
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\pytz-2012j-py2.7.egg
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\win32
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\win32\lib
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\Pythonwin
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\Shapely-1.2.18-py2.7-win-amd64.egg
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\wx-2.8-msw-unicode
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\xlrd-0.9.2-py2.7.egg
• C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\xlwt-0.7.5-py2.7.egg
• C:/Users/MGreen/.qgis2//python
• G:/Anybody/HEC-RAS/RiverGIS/baldeagle

Comments

Добрый вечер.
 Услуги:
модернизация промышленного оборудования, ремонт частотных преобразователей, наладка промышленной автоматики, ремонт промышленной электроники, ремонт силовой электроники, автоматизация технологических процессов, ремонт устройств плавного пуска:
P3-E540-1.5K, VFD055F43B-G, CIMR-E7C20370, CFW-090180TGZ, CIMR-E7Z41600B, ATV12HU22M2TQ, SMC940150-P, CIMRL7B45P57A, M300-02400023A, CSXI-007-V4-C1, PA7300-4125-N1, EQ5-4400-C, FR-F2-750BU, CIMR-E7Z40151B, CIMRJ7AZ40P20, CIMR-F7Z27P51, CIMR-F7C40300, ATV212HU40N4, CIMRG5C42200F, FR-A540L-G90K, PA7300-4350-N1, CIMR MR5N 2011, ATV61HD15M3X, CIMRJ7AC44P00, FR-V540L-250K, FR-S540E-2.2K, M400-06200440A, CSX-055-V4-C1, ATV212WD37N4C, FR-F720-00105, M200-01100024A, CIMRE7Z25P51A, CIMRF7Z40301A, FR-V520-7.5K, CIMR-F7A41850, M300-05400300A, ACH 400, M800-06400350A, SMC920150, ATV71HD11M3X337, FR-A221E-55K-UL, MP105A5, VG104002, ATV61EXS5C31Y, ATV312H075S6, CFW110515T4SZ, ATS22C17Q, ATS22C41S6U, M4-0030-311, FR-A540-1.5K, PA7300-2050-N1, M810-08201320A, CIMR-G7C41100B, ATV212WU22N4, EQ5-2005-N1, L200-040HFU, M800-05200250A, M100-01200024A, FR-D720S-100, M400-06400350A, FR-V540L-90K, ATV32H037N4, FR-A820-02330, FR-A120E-30K, VFD300V43A, E1-9013 300H, ATV71LD37N4Z, ATV71EXC5C40N4, FR-E520-0.75K, EI-P7012-175H, ATS48C32Q, L300P-900HFU2, CIMR-V7AT43P70, ATV71HU22M3, CIMR-E7U40451A, ATV312H055M2B, EQ5-4015-N1, FR-A840-05470, CIMRF7Z42P21B, CIMR-E7Z20900, SMC931750, CIMR-V7CC40P47, CIMR-F7C40111, FR-A120E-7.5K, VFD185VL43A, ATV312HU15M2, FR-F740-06830, CIMR-E7C20151, CIMR M5N 2030, ATV71HD45N4Z, FR-Z240-15K-UL, PA7300-2060-N1, ATS01N232QN, ATV61EXC5C20N, CIMRJ7ACB1P50, M400-06400470A, CIMR-F7Z40181B, EQ7-41000-C, GP102001, CIMR-F7C40750,  и др.
 
<a href="https://prom-electric.ru/articles/1/1/">ремонт преобразователей частоты</a> в Prom Electric

Answer 1

Hi Mike,

ProgrammingError('type "geometry" does not exist ... means your database is not spatially enabled. You have to create PostGIS extensions for that database, as stated in the requirements [1].

CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;

[1] http://rivergis.com/requirements.html

Comments

Hi - many thanks for your answer. It appears that PostGIS was somehow not installed during the pgAdmin/PostgreSQL installation (!) After installing it and enabling the extensions, I am now able to import the geometry :)

I (eventually) managed to figure out how to manually install the PostGIS extensions via the answer at the end of this post: http://gis.stackexchange.com/questions/41060/how-to-install-postgis-on-windows