Posted by
Tracey P. Lauriault-2 on
Mar 21, 2007; 5:11am
URL: http://civicaccess.416.s1.nabble.com/civic-engagement-using-portal-pages-tp947p957.html
Hey Cory,
I like the conversation on the list to!
See my comments below, just trying to make sure i am comprehend what you
are saying
. Cory Horner wrote:
> 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
>
is this the address of the hotspot? If so do you have a list of hotspots
from isf mtl to start w/address soz you can get the lat long
> 2. latitude-longitude to riding(s)
>
So you have a boundary file (polygon files) of the ridings and the
hotspot lat long point files will overlay onto the riding polygon file
soz you can see what is what and then you would add the riding as an
attribute to the hotspots tables? What about the postal code files that
are associated to the riding files?
> 3. riding to feed
>
so i guess hotspot address to riding to feed and then to the portal page
> For 1, see this:
>
http://geocoder.ca/?addresst=SPRINGRIDGE&stno=788&city=KAMLOOPS&prov=BC&geoit=1>
> We 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.
>
What geomatics software are you using to do all this in?
Cheers
tracey
> Cory.
>
> _______________________________________________
> CivicAccess-discuss mailing list
>
[hidden email]
>
http://civicaccess.ca/mailman/listinfo/civicaccess-discuss_civicaccess.ca>
>
>