US Zip/City/County/State spatial data all ready for your SQL Server 2008… Just download, SQLCMD/import and go

by vj 22. April 2009 03:16

This is so cool, if we could get a similar data made available for GCC my life would be so easier :D

 

[via] Geeks are Sexy

 

CodePlex - US Census Data for SQL Server 2008

Project Description
This is a repository for US Census Data for SQL Server 2008 with spatial information. Some of the data that is and will be included will be for states, counties, cities, and zip codes. The project will be updated as the data is available in SQL Server 2008 format.

Please note that this tables contain geometry data types made for the "Flat Earth Model."

Data downloaded from http://www.census.gov and imported using the SQL Server 2008 Spatial Tools (http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx) by Morten Nielsen

Florida

FloridaCounties "

…”

US Census Data for SQL Server 2008 - State and County Table

“…

State Table
source code, 1785K, uploaded Today

County Table
source code, 14132K, uploaded Sat

Release Notes

The State and County Table are based on the 2000 Census Data and was normalized to the best of my knowledge. Please note that the the County table requires the State table. Both scripts contain the create and insert of the data.

The State geometry was derived by grouping all of the counties of each state using the User Defined Function found here: http://conceptdev.blogspot.com/2007/12/sql-server-2008-geometry-stunion.html

…”

US Census Data for SQL Server 2008 - Version 0.0.1.0

"...

State
source code, 1528K, uploaded Today - ...

County
source code, 7148K, uploaded Today -...

City
source code, 12258K, uploaded Today - ...

ZipCode
source code, 42531K, uploaded Today - ...
Release
Notes

Changes:
Added the ZipCode table
Modified all scripts
to include the spatial index
Compressed the files to a rar to make the files
smaller#

..."

A number of the podcasts I listen to have been covering SQL Server 2008’s spatial data type, so when I saw this I knew I had capture the data and mention it…

Update 4/20/2009 @ 7:15am:

There's now a City table/download (21860K) too... ;)

Update 4/20/2009 @ 4:20PM:
Added 0.0.1.0 block, which includes ZipCode data!

US Zip/City/County/State spatial data all ready for your SQL Server 2008… Just download, SQLCMD/import and go
Greg (noreply@blogger.com)
Sun, 19 Apr 2009 19:18:00 GMT

Tags: ,

Technology | References

Volunteers needed for various requirements

by vj 5. April 2009 19:59


on behalf of Volunteer In Dubai


10th April


Times Square Mall
Feline Friends Book Sale
Job: Selling books to the public in aid of Feline Friends. Morning and Evening Shifts Required.


Please email all your details to:

 


17th April 2009

Dubai Festival City
Job: supporting the wonderful pianist Mr. Johnny Miller (the guy who plays in Mercato) who is completing a 12 hour painothon in aid of Dubai Autism Centre. We need your help to hand out flyers on the day to inform the public of this wonderful appeal.


Please email all your details to:

Tags:

Volunteering

That's cool! ... BMW GINA Light Visionary Model

by vj 4. April 2009 23:38

Tags:

Entertainment

सच

by vj 3. April 2009 18:58

कुछ ऊँचे रिश्तों की खातिर
कुछ ज्यादा खुशियों की खातिर
कुछ ज्यादा पैसों की खातिर
कुछ हंसते लम्हों की खातिर,

मैं छोड़ चला था दुनिया को,
मैं छोड़ चला था उस आँचल को,
और घर के प्यारे आँगन को,
और बहन की हंसती आँखों को,
राखी से सजी उस थाली को,
और छोडा अपने यारों को,
गम में तडपते प्यारों को,
मुड के भी ना मैने देखा था,
दर्द भरी उन आँखों को,

जिस दुनिया को मैने पाया,
वो दुनिया नहीं एक धोखा था,
एक गरम हवा का छोंका था,
आया और आ कर चला गया,
फिर भी पैसा खूब कमाया,
और कुछ सम्मान भी पाया,
पर सच नहीं वो धोखा था,
जब आज जोड़ने मैं बैठा
देखा कुछ तो न पाया था,

जिस राखी को मैने तोडा,
जिस आँचल को मैने छोडा,
naa मिलेंगे वो राखी, आँचल,
मैं छोडूँ चाहे दुनिया को,
सब छोड़ चला था मैं जैसे,
उसमे तो कुछ तो मुझे दे दो,
मुझको तो "आप" से 'तुम' कर दो,
मैं छोड़ चला था दुनिया को,

'मुझको मेरी दुनिया दे दो'

-शांडिल्य

 

Thanks Shandily :)

Will provide a translation shortly.

Tags:

Just Like That

Google Transliteration ... it works!

by vj 3. April 2009 18:23

From March 30th, Google has enabled its transliteration service for Indic languages to its Gmail users, if you have been waiting to compose emails in your native Indian languages (well, for now they support Hindi, Kannada,  Gmail is all game now Happy.

 

Head over to your Gmail settings, and enable the transliteration service along with specifying your default preferred language and you are all set. By the way, if you are looking into transliterating some arbitrary text without sending it as an email, you can use the transliteration service available at http://www.google.com/transliterate/indic

 

 

I have been thinking of using this service for few things, lets see Winking

Tags:

Technology

Remembering...

by vj 3. April 2009 16:45

Woke up very early today, and was going through a walk down the memory lane … came across this song sent to me by an old friend … such a beautiful song, great lyrics, nice choreography, smoothing music and rain Sigh yea rain! …  Whenever I see rain I remember the home days when me and bro used to pay no heed to mom’s warnings and get going out for enjoying the rain, really worth the cold and fever that follows for the next few days Happy

 

miss you!

 

Parijatham – Unnai Kandena

 

By the way, an update to my Downloading YouTube videos as mp4 post, there is an easier way to do this. For any YouTube video that you would like to download just add “kick” to the YouTube.com part of the url, for example the above video is located at http://www.youtube.com/watch?v=4Iz5_Xgw35A and so you can download this video by going to url http://kickyoutube.com/watch?v=4Iz5_Xgw35A and from the top after selecting your needed file format press “GO”.

 

Have a nice weekend :)

Tags:

Entertainment