Recently we get enormous amount of spam registration. We have closed the registration for new members, sorry...
0 votes
1.1k views
by (180 points)
edited by

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
by
Добрый вечер.
 Услуги:
модернизация промышленного оборудования, ремонт частотных преобразователей, наладка промышленной автоматики, ремонт промышленной электроники, ремонт силовой электроники, автоматизация технологических процессов, ремонт устройств плавного пуска:
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

1 Answer

+1 vote
by (3.8k points)
selected by
 
Best answer

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

by (180 points)
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
Welcome to RiverGIS Q&A, where you can ask questions and receive answers from other members of the community.

Visit rivergis.com for documentation and general info about the QGIS plugin.

Categories

...