Re: SQL Work Needed at the City of Wilsonville

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.

On Tue, Aug 2, 2011 at 11:53 AM, Eli Adam <EAdam(at)co(dot)lincoln(dot)or(dot)us> wrote:
> Dan,
>
>  Welcome to the list.  If you like open source and GIS, there is a consortium of several Counties, Cities, and State Agencies that jointly develop and use some open source GIS tools.  You can contact Dean or I for more information.  You can see some of it in action here on Dean's site, http://apps.co.polk.or.us/geomoose2/index.html
>
> Best Regards, Eli
>
>
>
>
> --
>
> Eli L Adam
> GIS Analyst
> Lincoln County
> (541)574-1289
>
>
>>>> On 8/1/2011 at 9:45 PM, in message
> <CALGiQrCviBP9vXhjxRA6XrtvCYXtExgmjoustKnz_PUhB07vJg(at)mail(dot)gmail(dot)com>, daniel
> stark <dan(dot)j(dot)stark(at)gmail(dot)com> wrote:
>> On Mon, Aug 1, 2011 at 7:23 PM, Lindsey Smith <lindsey(dot)smith(at)gmail(dot)com> wrote:
>>> I invited him to join but I will try again so any momentum picked up
>>> so far isn't lost.
>>>
>>> On Mon, Aug 1, 2011 at 5:43 PM, gabrielle <gorthx(at)gmail(dot)com> wrote:
>>>> On Wed, Jul 27, 2011 at 10:18 PM, Lindsey Smith <lindsey(dot)smith(at)gmail(dot)com>
>> wrote:
>>>>> I'm more than willing to ride shotgun with Gabrielle to discuss what
>>>>> needs to be done. Dan at the City of Wilsonville is a personal friend
>>>>> and I *think* they'd be receptive to any offer of help.
>>>>
>>>> I'm still picking up pieces of my shattered post-OSCON brain :)  Did
>>>> you get Dan on the mailing list?
>>>>
>>>> gabrielle
>>>>
>>
>> Hello to all-
>>
>> I've joined the list and would be thrilled to work with the group,
>> individuals, or all of the above to accomplish the work we need to get
>> done.  This can be a paying gig for someone or a group, and I'd be
>> more than happy to buy lunch or dinner, host meetings or sponsor a
>> hackfest.  I'm a big open source fan and would be solidly behind any
>> efforts to further it's application at the City.  Feel free to shoot
>> me ideas as a group or individually.
>>
>> We are a very small IT group and often need to rely on experts for
>> specialized tasks.  In this case we have tables coming from multiple
>> sources that need to be manipulated so that they match the tables in
>> our production SQL databases. There are several different data sets
>> that we need to manipulate but I'll provide an example of one
>> (deceptively simple one) that could start the conversation.
>>
>> I have a table with property owner addresses.  The address is one
>> field that includes street number, name, type, direction, plus
>> apartment/suite/room/.  I need to strip off the apartment/suite/room
>> portion of the field and dump it into it's own "suite" field.  There
>> are about 12 or so types of "suites" and I have an all inclusive list.
>>  It should be fairly straight forward to look for those 12 keywords
>> and remove the keyword plus any trailing numbers or characters (ie
>> Floor 2 Room 12E), then place them into the suite field.
>>
>> I'll keep it brief tonight and end here as way of an introduction and
>> hope to hear more.  Feel free to contact me on or off the list.
>>
>> Best,
>> dan
>>
>> GIS Manager
>> City of Wilsonville
>> voice: 503-570-1533
>> stark(at)ci(dot)wilsonville(dot)or(dot)us
>
>