[Dutch] [Open Geo Groep] Re: BAG en Top10NL PostGIS dumps van april 2015

[Raymond Nijssen]

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
>
>
>
>