http://www.geonames.org/
http://download.geonames.org/export/dump/?C=S;O=D
On 02/02/2011 11:30 AM, viraj wrote:
dear list,
where can i find a list of map polygons for united states cities? any
open database? or tool to obtain correct coordinates?
i googled but couldn't find anything
On 2/2/2011 04:23, Hal Vaughan wrote:
I'm using this query in a Perl program:
SELECT Distinct x.Search FROM $source.Searches AS x LEFT JOIN searching.Status
AS s
ON x.Search=s.Search AND s.Source='$source' WHERE x.RedoTime'$now' AND
s.Search IS NULL
This program runs other programs
I currently have a query that organizes search results for volunteers that
should be called for projects based on how close they live to a project the
and there past attendance.
Currently doing
SELECT name, city, state, phone, prods_done, cancels, miles
FROM volunteer_search
WHERE project_id =
SELECT name, city, state, phone, prods_done, cancels, miles FROM
(SELECT name, city, state, phone, prods_done, cancels, miles, ((prod_done -
cancels) * 100 / prod_done) reliability
FROM volunteer_search WHERE project_id = 5653) A
ORDER BY reliability DESC, miles ASC
Give it a try !!!
Rolando A.
Hey,
MySQLers if you are looking to present at PgEast, now would be a great
time to get your talk in. Yes it is a PostgreSQL conference, but we like
to learn from each other, do we not?
I would be all over seeing talk titled:
What I wish PostgreSQL could do, from a MySQL users perspective!
Dear MySQL users,
MySQL Server 5.0.92, a new version of the popular Open Source Database
Management System, has been released. Please note that the active
maintenance of 5.0 has ended, and these builds are only provided
because of the fixes to security bugs as described below.
The release is
Dear MySQL users,
MySQL Server 5.1.55, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.1.55 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
Dear MySQL users,
MySQL 5.5.9 is a new version of the 5.5 production version of the
world's most popular open source database. MySQL 5.5.9 is recommended
for use on production systems.
MySQL 5.5 includes several high-impact changes to address scalability
and performance issues in MySQL Server.
All,
Thanks for your replies and as per the advise I switched to row-based
replication but replication ended with below error.
*Last_Error: Error 'Table 'b.sdefrent' doesn't exist' on query. Default
database: 'b. Query: 'drop table sdefrent'*
above error is due to non existence of database