Re: Cool SQL Presentation At IDUG North America
- From: Tool <tool@xxxxxxxxxxx>
- Date: Tue, 10 Apr 2007 21:22:31 -0400
Gumby,
Somehow I've failed you, completely, and for that I'm really sorry.
Google has some great stuff for connecting maps with data. It's been a
while since I've dabbled with their API, but they do make it easy to take
data and mix it with their maps.
For example:
http://www.housingmaps.com/
If you can't understand what I'm saying after viewing this website, then nothing else I'll say will help you get it.
-t-
Ian Michael Gumby wrote:
From: Tool <tool@xxxxxxxxxxx>Wow,
You mean google has access to the MLS?
And to the registered sex offenders database?
And access to patient medical records?
Its no wonder they are what keeps Gates and Balmer up at night.
How about "redlining"? Can they do that as well?
(Its a mortgage compliance term).
You can get the kind of code you are referring to over at Google. They have developer resources for just the kind of queries you are referring to, and show you how to place addresses on the Google Earth map.
-t-
Ian Michael Gumby wrote:
>
>
>
> JGP wrote:
>>
>> Things like "get the list of all customers and sort them by last name"?
>>
>> ;-) I am a software developer, not very original...
>>
>
> Well thats part of the problem.
>
> Software developers who don't grok the database end up writing
> inefficient queries and code.
> This concept of the database just being a persistent data store should
> get the developer demoted to junior grade to the assistant of the
> assistant of the piss collector.
>
> Now if you want to suggest something fun...
>
> How about a geo-spatial query that finds all of the homes for sale with
> the minimum number of registered sex-offenders within a 2 mile radius of
> the home? (And then add in factors like square footage, #bedrooms,
> #baths, price ...)
>
> (This query came up during a conversation with some former neighbors of
> ours. They recently moved from the city (Chicago) to the burbs. She was
> telling my wife that she was shocked to find out just how many
> registered offenders lived close to our condo.)
>
> Want some more fun, try and think of some epidemiology research queries,
> like looking for cancer clusters or antibiotic resistant TB.
>
> If you want to be politically incorrect, try to find a home that is
> within proximity with the most number of gentlemen's clubs and/or
> nightclubs or bars. ;-)
>
>
> At least is much more interesting than trying to talk about how you've
> optimized a query that used to use roll up tables in an effort to gather
> data for your monthly sales forecast... :-(
>
> But hey! What do I know?
> I've been accused of being green and very flexible....;-)
>
> -G
>
>> > -----Original Message-----
>> > From: informix-list-bounces@xxxxxxxx [mailto:informix-list-
>> > bounces@xxxxxxxx] On Behalf Of Darryl Priest
>> > Sent: lundi 9 avril 2007 16:43
>> > To: informix-list@xxxxxxxx
>> > Subject: Cool SQL Presentation At IDUG North America
>> >
>> > Have you ever done something exciting and/or cool using just SQL and
>> > wanted to share your success?
>> >
>> > Have you wondered if you could be a presenter at a conference, but
>> > doing an entire hour presentation seems like a bit much?
>> >
>> > With a nod to the Open Source Conference's Lightning Talks idea,
>> > here's your chance to present your SQL success without doing a full
>> > session.
>> >
>> > At IDUG North America on Tuesday May 8, from 1:40 to 2:40, David Link
>> > and I will be "moderating" a session called 'Cool Uses of SQL' where
>> > you could present your SQL. We will be sharing an example each and
>> > then the floor is yours to wow your fellow attendees. Each mini-
>> > presentation will be 5 minutes or less in length and have slides
>> > prepared to show the SQL, data structures, output, etc.
>> >
>> > If you will not be present at the conference, why not? But if you'd
>> > still like to have your cool SQL shown to others please submit your
>> > ideas to me via email and they will be presented, if time is
>> > available. Priority will be given to those who are actually attending
>> > the conference.
>> >
>> > -Darryl
>> >
>> > _______________________________________________
>> > Informix-list mailing list
>> > Informix-list@xxxxxxxx
>> > http://www.iiug.org/mailman/listinfo/informix-list
>>
>> _______________________________________________
>> Informix-list mailing list
>> Informix-list@xxxxxxxx
>> http://www.iiug.org/mailman/listinfo/informix-list
>
> _________________________________________________________________
> MSN is giving away a trip to Vegas to see Elton John. Enter to win
> today. http://msnconcertcontest.com?icid-nceltontagline
>
--
*
* http://www.youtube.com/watch?v=rVS3kdXycrM&mode=related&search=
*
_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
Can’t afford to quit your job? – Earn your AS, BS, or MS degree online in 1 year. http://www.classesusa.com/clickcount.cfm?id=866145&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D866143
--
*
* http://www.youtube.com/watch?v=rVS3kdXycrM&mode=related&search=
*
.
- References:
- Re: Cool SQL Presentation At IDUG North America
- From: Ian Michael Gumby
- Re: Cool SQL Presentation At IDUG North America
- Prev by Date: Re: Cool SQL Presentation At IDUG North America
- Next by Date: Re: Problem exporting data
- Previous by thread: Re: Cool SQL Presentation At IDUG North America
- Next by thread: physbuff and logbuff utilization
- Index(es):
Relevant Pages
|
