[postgis-users] ERROR: WKB structure does not match expected size!

Hi, When I try to restore my database ocurr this problems pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 3737; 0 18356 TABLE DATA test postgres pg_restore: [archiver (db)] COPY failed for table "test": ERROR: WKB structure does not

Re: [postgis-users] Help with SQL query?

Dear Regina, Many thanks for this suggestion. I ran the query in this form and for one raster it takes 3372s (~55 mins). I guess that is what I had anticipated from the single tile exercise I ran with the alternate algorithm. This still seems a little too long however and so I have started

Re: [postgis-users] Help with SQL query?

Dear Regina, Yes, I should have been clearer. To be honest I did not fully understand what I was trying to do at the outset ☺ The binary raster to point conversion was an afterthought as I had already been extracting data along short transects using a point shape file. For the record arc

Re: [postgis-users] Can we limit the search range of geocode() function in Tiger Geocoder?

Dracodoc, Nice writeup. I'll respond on your stack exchange question. That might be a good enhancement option to focus on for PostGIS 2.3. Haven't thought of how that filtering would work. Perhaps another geocode function that takes in a filter of desired states. Anyrate yah the geometry

Re: [postgis-users] Help with SQL query?

Dear Brent, Yes that works for me too ! Sometimes I look for what is familiar and overlook the obvious – a little embarrassing, but I know now . Many thanks Darrel From: Brent Wood [mailto:pcr...@yahoo.com] Sent: 27 November 2015 21:53 To: PostGIS Users Discussion

Re: [postgis-users] Help with SQL query?

Darrel, Oh that's what you are trying to do sorry I didn't recognize that whole CASE thing as a binary check operation until you described the purpose. For the bit operation type stuff it is much faster to define that 0/1 as a geometry (which it looks like you've done, but I don't know

Re: [postgis-users] Help with SQL query?

Darrel, I think the equivalent in PostGIS terminology would be ST_Reclass - http://postgis.net/docs/manual-2.2/RT_ST_Reclass.html And that's a fairly fast operation as I recall. Hope that helps, Regina From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On

[postgis-users] Can we limit the search range of geocode() function in Tiger Geocoder?

Hi all, I asked this question in gis stackexchange here already . I'm also posting the question in the mailing list to make sure the experts can see the question. I found the

Re: [postgis-users] Help with SQL query?

For completeness, your vector query would then look like CREATE TABLE mymodel.network AS SELECT rid As gid, ST_Polygon(ST_Reclass(rast, 1, '[0-600):0, [600-1]:1','1BB', 0) ) As geom FROM mymodel.concentrated ; I think you can put in –number in there like - -1000-600. There