Re: [SQL] Off topic : world database
Uz.ytkownik Rudi Starcevic napisa?: Hi, I have a slightly off SQL topic question which I don't think is too inappropriate, if it is please let me know and I'll not push my luck again of my *favorite email list*. I'd like to build a Postgresql database of Countries,States and Cities of the world. I would like to use 'earthdistance' module so distance queries are possible. I plan to expose this data as an SOAP webservice via xmethods.com for others to access as well. I've been searching for a source for this data without joy so far and would like to ask if someone on this list could point me to or help with a source for this info. Ideally I'd like Country,States,and Cities with Longitude and Latitude coordinates. Thank you kindly, Again if this is too off topic let me know and I'll keep all my questions strictly to SQL. Regards Rudi. Did you try to ask people related to PostGIS ? They work with maps, so maybe they know where to get such list without license problems. Regards, Tomasz Myrta ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [SQL] Complex outer joins?
Hi... Postgres 7.3 I'm using the copy command to fill my tables. I've got this file with the data with delimiter '\t' and 'isnull' for nulls as follows: copy mytable FROM '/usr/share/postgresql/data1/skripte/Daten/mytable' using delimiters '\t' with null as 'isnull'; But I receive an error saying that 'the value is too long for type varying(1)' This because I am filling a column defined as numeric(1) with nulls. But if I insert some values into the table with 'insert', including nulls and then do copy mytable TO '/usr/share/postgresql/data1/skripte/Daten/mytable' using delimiters '\t' with null as 'isnull'; the file looks exactly the same as my original one. Am i missing something?? thanks! Carla This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [SQL] Off topic : world database
On Thu, Mar 27, 2003 at 10:06:08 +1000, Rudi Starcevic <[EMAIL PROTECTED]> wrote: > > I've been searching for a source for this data without joy so far and > would like to > ask if someone on this list could point me to or help with a source for > this info. > Ideally I'd like Country,States,and Cities with Longitude and Latitude > coordinates. You can get data for the US for free. With a combination of Tiger and FIPS data you can get Latitude and Longitude coordinates for street addresses. There was an entry related to this in last year's Google contest. Finding that entry will provide you with instructions for getting the data (unless the government has decided it is too dangerous because of possible terrorism since last summer). The project has some software for doing street address to to Latitude and Longitude conversion. You will need to decide what point in a city you will want to use. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [SQL] Off topic : world database
On Wed, Mar 26, 2003 at 16:55:21 +, Michael A Nachbaur <[EMAIL PROTECTED]> wrote: > > I for one would be very interested in such a web service (I'd really like a > address / street lookup to find lat/longs for addresses, but thats not likely > to happen). Its already there for the US. A guy did this for last year's Google contest. I have plans to add it to a web site I run to enable boardgame players to find other boardgame players within a certian distance. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
