Projects

foiaqui

The project foiaqui is an use of the Google Maps API for improve the security in cities, using a collaborative approach. The main idea is an web site where you can tell where you was assaulted.

busytonight

BusyTonight is a community-generated, freely accessible global City Guide covering places, organizations, and people.

citiesinus

This project has a goal to provide a database in several formats for zipcode,cities,states in the US.

worlddb

Open World Database Service alphaThis database has multi languages country names, region names, city names and they's latitude and longitude number and country's alpha2 code .. countriesregionscities 246 rows4151 rows103818 rows TABLES locales countriesregioncities ... [More] countryNamesregionNamescityNames localesCREATE TABLE `locales` ( `locale` char(5) NOT NULL, `name` varchar(50) NOT NULL, `fullname` varchar(50) NOT NULL, PRIMARY KEY (`locale`), UNIQUE KEY `locale` (`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;countriesCREATE TABLE `countries` ( `code` char(2) NOT NULL, `url` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `latitude` double NOT NULL, `longitude` double NOT NULL, `regions` int(2) NOT NULL, PRIMARY KEY (`code`), UNIQUE KEY `name` USING BTREE (`name`), UNIQUE KEY `url` USING BTREE (`url`), UNIQUE KEY `code` (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;countryNamesCREATE TABLE `countryNames` ( `code` char(2) NOT NULL, `locale` char(5) NOT NULL, `name` varchar(60) NOT NULL, `fullname` varchar(60) NOT NULL, UNIQUE KEY `code` (`code`,`locale`), KEY `locale` (`locale`), CONSTRAINT `countryNames_ibfk_1` FOREIGN KEY (`code`) REFERENCES `countries` (`code`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `countryNames_ibfk_2` FOREIGN KEY (`locale`) REFERENCES `locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;regionsCREATE TABLE `regions` ( `ID` int(4) unsigned NOT NULL auto_increment, `country` char(2) NOT NULL, `code` char(3) NOT NULL, `url` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `latitude` double NOT NULL, `longitude` double NOT NULL, `cities` int(4) unsigned NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `unique` USING BTREE (`country`,`code`), UNIQUE KEY `unique2` USING BTREE (`country`,`name`), UNIQUE KEY `unique3` USING BTREE (`country`,`url`), KEY `country` USING BTREE (`country`), KEY `code` (`code`), CONSTRAINT `regions_ibfk_1` FOREIGN KEY (`country`) REFERENCES `countries` (`code`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;regionNamesCREATE TABLE `regionNames` ( `ID` int(4) unsigned NOT NULL, `locale` char(5) NOT NULL, `name` varchar(60) NOT NULL, `fullname` varchar(60) NOT NULL, UNIQUE KEY `ID` USING BTREE (`ID`,`locale`), KEY `locale` (`locale`), CONSTRAINT `regionNames_ibfk_2` FOREIGN KEY (`locale`) REFERENCES `locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `regionNames_ibfk_3` FOREIGN KEY (`ID`) REFERENCES `regions` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;citiesCREATE TABLE `cities` ( `ID` int(8) unsigned NOT NULL auto_increment, `country` char(2) NOT NULL, `region` char(3) NOT NULL, `url` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `latitude` double NOT NULL, `longitude` double NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `unique` USING BTREE (`country`,`region`,`name`), UNIQUE KEY `unique2` USING BTREE (`country`,`region`,`url`), KEY `country` USING BTREE (`region`,`country`), CONSTRAINT `cities_ibfk_1` FOREIGN KEY (`country`) REFERENCES `countries` (`code`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `cities_ibfk_2` FOREIGN KEY (`region`) REFERENCES `regions` (`code`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;cityNamesCREATE TABLE `cityNames` ( `ID` int(8) unsigned NOT NULL, `locale` char(5) NOT NULL, `name` varchar(60) NOT NULL, `fullname` varchar(60) NOT NULL, UNIQUE KEY `ID` (`ID`,`locale`), KEY `locale` (`locale`), CONSTRAINT `cityNames_ibfk_3` FOREIGN KEY (`ID`) REFERENCES `cities` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `cityNames_ibfk_2` FOREIGN KEY (`locale`) REFERENCES `locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; [Less]

Smart Campus

Smart Campus is a lab and a community. The lab builds a social and technical environment for collaborative service design. The community is composed of all students, researchers and campus staff, interested in taking advantage from the Smart Campus services, and in participating to their design. ... [More] Smart Campus provides advanced Information and Communication Technology (ICT) solutions to catalyze the creativity and enthusiasm of all people involved in a University campus, leading them to become active producers of innovative services designed to support their lives. [Less]