postgis
Postgis recipe: Extracting MULTILINESTRING into LINESTRING
angch — Wed, 30/09/2009 - 12:35
insert into linestringtable (the_geom, col1, col2, col3)
select st_geometryn(the_geom,n), col1, col2, col3
from
multilinestringtable,
generate_series(1, (select max(NumGeometries(the_geom)) from multilinestringtable)) n
where st_geometryn(the_geom,n) is not null
and GeometryType(st_geometryn(the_geom,n)) ='LINESTRING';Not horribly efficient, but gets the job done.
Malaysian state boundaries in SVG
angch — Thu, 06/08/2009 - 20:32
Malaysian state boundaries, in SVG compressed format as requested by Seah Hong Yee.
I made the .svg, converted from an internal database, but I'm not certain of the copyright of the original information. So I can't really put this under Creative Commons, sorry. But I hope it's okay under fair use.
Enjoy.
#geekcamp Malaysia presentation: A Coder's Intro to PostgreSQL+PostGIS
angch — Wed, 10/06/2009 - 19:53
Gave a quick and dirty talk at #geekcamp Malaysia: A Coder's Intro to PostgreSQL + PostGIS.
This looks like a topic I'd be revisiting and revising as I'm heavily into PostGIS these days, and definitely felt that the I missed several important topics. I'll just put this up here for now, and we'll see how well it improves.
