Posted by
Cory Horner on
Mar 21, 2007; 4:54am
URL: http://civicaccess.416.s1.nabble.com/civic-engagement-using-portal-pages-tp947p956.html
Michael Lenczner wrote:
>> Does someone want to donate a postgres/postgis instance (iles sans fil?)
>> -- i'll toss the geogratis 2004 electoral boundaries shapefile in, and
>> build a quick link with geocoder. We can then offer address/postal
>> code/coordinates to electoral district conversion. As we acquire
>> additional spatial data, we can offer similar services for provincial
>> jurisdictions as well.
>>
>>
> Sorry - you reached my geek limit. I'm not sure what you need. Just a
> postgis install?
>
Yeah... someone to host the database, and host the perl (or ruby) script
> I'm not sure that this will help us show content. I think for the
> purposes of Wifidog that we'll be manually tie-ing MP rss feeds to
> individual content.
>
> Let me know. And I hope that it's okay if a bit more of this
> discussion happens on-list?
>
You bet... i'm content to discuss here until people say "hey, be quiet".
What i'm proposing is the spatial lookup service, which is an essential
part of what is needed to get that MP feed, but you are correct -- it is
not the complete thing.
There are 3 pieces to the whole puzzle:
1. address to latitude-longitude
2. latitude-longitude to riding(s)
3. riding to feed
For 1, see this:
http://geocoder.ca/?addresst=SPRINGRIDGE&stno=788&city=KAMLOOPS&prov=BC&geoit=1We can't otherwise obtain #1 without a major leaflet campaign (we'll get
to that).
I'm proposing we chain together 1 and 2. We could also put other spatial
data in there and output things other than ridings.
On the other hand, we could wait for HTV to roll this all into one
request (1-2-3 would just be hidden behind the scenes, and possibly be
cached for speed). Others may find a use for this in the meantime
though... (by the sounds of it, Judyth is eager).
Perhaps this isn't so useful without 3.
Cory.