I use
select tz.tzid from location
join tz_world tz on st_within(location."locationPoint", tz.geom)
with the tz_world shapefile that I'm 99% sure I got from
http://efele.net/maps/tz/world/
--
John Abraham
j...@hbaspecto.com
> On Mar 22, 2017, at 3:23 PM, suraj birl
6e51f85> (I'm not sure whether upwork
is the best platform to ask for postgis freelance work, let me know if you have
other ideas.)
Hope someone can help,
--
John Abraham
j...@hbaspecto.com
403-232-1060
___
postgis-users mailing list
pos
ave a provincial boundary file but there seems to be much ambiguity in GIS
representations of the provincial boundary, so I won't send you the one I have.
I can try to assemble one from other sources.
--
John Abraham
j...@hbaspecto.com
403-232-1060
On Feb 25, 2015, at 6:28 AM, Mark Wyn
;13
120;5301;17
110;5246;17
100;4422;28
90;4332;28
80;3664;35
70;3292;43
60;2860;66
50;2236;74
40;1882;141
30;1493;215
20;993;618
10;445;3325
0;20;993265
--
John Abraham
j...@hbaspecto.com
403-232-1060
"POSTGIS="2.0.3 r11128" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March
square fairly simple regardless of how complex the other geometry is?
(Your reply initially fell into my junk mail, so I missed it, and also haven't
tried these things yet, partly because I missed your email.)
--
John Abraham
j...@hbaspecto.com
403-232-1060
On Feb 19, 2015, at 6:52 PM
cover_polygons_snap AS p
INNER JOIN sometaz AS n
ON (ST_Intersects(p.geom, n.the_geom)
AND NOT ST_Touches(p.geom, n.the_geom) );
)
--
John Abraham
j...@hbaspecto.com
403-232-1060
On Feb 19, 2015, at 11:56 AM, Rémi Cura wrote:
> Hey,
> you could try to not use CASE (so separate
polygons, e.g. apply a 1km grid over them?
PostGISfullversion(): "POSTGIS="2.0.3 r11128" GEOS="3.3.8-CAPI-1.7.8"
PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08"
LIBXML="2.7.8" LIBJS
Sorry to be the bearer of bad
news. Frankly, I don't understand why the GEOS library has to throw that
error.
I would encourage you to isolate particular problems and file bug reports.
Improvements in GEOS to eliminate the underlying error(s) would certainly be
welcome.
--
John Abrah
/files/12_pfg.pdf and thanks to Martijn
Meijers and team.
Then I rebuilt the topology layer in PostGIS from the fixed up Simple Feature
Class multi polygon layer.
--
John Abraham
j...@hbaspecto.com
403-232-1060
On Nov 3, 2014, at 9:13 AM, Rémi Cura wrote:
> Just for completeness sake,
> i
ssing piece. Thanks.
Nonetheless, the triangulation algorithm from Martijn seems so much cleaner and
more powerful than any of this. http://tudelft-gist.github.io/pprepair/ . I
don't even see a reason to try st_snap.
--
John Abraham
Sent from my iPhone, please excuse any typos.
> O
about 2 million parcels).
For everyone else, here’s the paper: http://www.gdmc.nl/ken/files/12_pfg.pdf
--
John Abraham
j...@hbaspecto.com
403-232-1060
On Oct 3, 2014, at 1:23 PM, Martijn Meijers wrote:
> Hi John,
>
> We know the pain you describe.
>
> For this we've devel
ryone else have boundaries that are defined in topologies, or with every
point specified? Or is there just some trick, that no-one’s ever told me
about, to add in the necessary points on edges so that identical line segments
are defined by the same pairs of points?
Feeling frustrated,
--
f the polygon was lost. I
can manually make these edits, I think, and your algorithm is better than
the original, but it's not perfect yet :)
--
John Abraham
j...@hbaspecto.com
On Thu, Jan 16, 2014 at 1:00 PM,
wrote:Message: 3
Date: Thu, 16 Jan 2014 14:42:29 +1000
From: Paul Pfeiffer
To: po
13 matches
Mail list logo