Re: SQL Work Needed at the City of Wilsonville

No need to apologize, I just thought you might get some PostGIS type
help at the other group too. At some point you might want to make
your addresses into points and query how far they are from something
and then we are sort of back into GIS land.

W

On Tue, Aug 2, 2011 at 4:12 PM, daniel stark <dan(dot)j(dot)stark(at)gmail(dot)com> wrote:
> Sorry, GIS cross-talk is for context only, don't mean to be off-topic.
>  The task at hand is crafting some SQL to tackle an issue with a
> table.
>
> Both your referrals are very strong and should not be overlooked.
>
> On Tue, Aug 2, 2011 at 3:10 PM, Webb Sprague <webb(dot)sprague(at)gmail(dot)com> wrote:
>> Two things (and apologies for top posting):
>>
>> In case nobody has mentioned it yet, here is the PDX open source GIS
>> group with monthly meetings:  http://groups.google.com/group/pdx-osgis
>>
>> Also, if you are researching open source alternatives, you would
>> probably want to talk to someone at Tri Met about their experiences,
>> in case you don't know that already.
>>
>> Forgive my redundancy, if it is such...
>>
>> On Tue, Aug 2, 2011 at 1:00 PM, daniel stark <dan(dot)j(dot)stark(at)gmail(dot)com> wrote:
>>> Thanks Eli!  I worked with Dean a little bit back in my Marion County
>>> days (94-99).  15+ years later I am still consistently impressed by
>>> his accomplishments.  My reasons for getting on this list arose from
>>> my need to do the same thing that I did when working with Dean all
>>> those years ago: merge data from two counties into our database while
>>> each one stores data in different fields with different standards.  My
>>> existing processes use the ESRI model builder to do some geographic
>>> stuff and an SQL script to do some data massaging.  I need some expert
>>> help to enhance the processing done within the SQL script as it has
>>> outgrown my skills.
>>>
>>> I am looking to replace my existing AGIS Server implementations this
>>> fiscal year and I plan to aggressively research open source
>>> alternatives to the ESRI+Business Partner approach.  That research
>>> just began in earnest at the UC this year and I hope to find more time
>>> to spend soon.
>>
>