Hi Fatemeh,
Did you add the extension Postgis to your database, for handeling
spatial data types (geometry)?
Hope this helps,
Raymond
On 10-02-17 10:42, Fatemeh Mahmoudi wrote:
Dear all,
I have a problem with restroing bag data in Postgres through pgAdmin.
But The pandactuell which has the geospatila values is not loading with
following error!
(pg_restore: creating TABLE "bagactueel.pand"
pg_restore: [archiver (db)] Error from TOC entry 380; 1259 554851963
TABLE pand kademo
pg_restore: [archiver (db)] could not execute query: ERROR: type
"public.geometry" does not exist
LINE 15: geovlak public.geometry,
^
Command was: CREATE TABLE pand (
gid integer NOT NULL,
identificatie numeric(16,0),
aanduidingrecordinactief boolean,
aan...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"pand" does not exist
Command was: ALTER TABLE pand OWNER TO kademo;)
I had done this before and it worked but now does not!
does anyone know about it?
Regards,
Fatemeh
On Sunday, April 26, 2015 at 11:56:13 PM UTC+2, Just van den Broecke wrote:
Sorry voor cross-posting.
Kort voor Koningsdag zijn de BAG van April 2015 en een nieuwe BRT
Top10NL via PDOK beschikbaar gekomen.
NLExtract heeft dezen gezwind in PostGIS ingelezen en ter download
beschikbaar gesteld:
Top10NL: http://data.nlextract.nl/top10nl/postgis/apr2015/
<http://data.nlextract.nl/top10nl/postgis/apr2015/>
BAG: http://data.nlextract.nl/bag (ook CSV)
Hartelijke groet,
--Just
_______________________________________________
Talk-nl mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/talk-nl
