Ian Villeda ian29

Converting to SQLite

Importing the spatially-explicit tables (TMsch.csv and TMlea.csv, in the form of simple lat/long coordinates) into QGIS via the'Add Delimited Text Layer' plugin, allows for a first look at the data. Selecting 'Save layer as vector file..' from the Layers menu. In the dialog box, select the following parameters:

Format: SQLite
Encoding: UTF-8
CRS: Google Mercator EPSG:900913

Import the non-spatial .csv tables into SQLite database files using a database inspector like Base or from the command line using SQL for SQLite. Be sure to import all six tables into one database.

Next Actions

By thurs night:

Robert + Ian (Mapping team)

research best options for GPS unit:
- smartphone interface for bluetooth device?
- if garmin, which one
spreadsheet template by Friday. can be evolved but helpful for funding proposal.

Hola RECIPIENT NAME,

En las últimas semanas hemos progresado mucho, completando las areas ausentes de CITY en OpenStreetMap[2]. Si no lo conoce OpenStreetMap, es parecido a Wikipedia de los mapas, que provee un mapa mundial[3] comprehensiva y abierta, listo para el uso público.

En su sitio web, veo que es el encargad@ de los dados acerca de los nombres de las calles[4]. Queremos contribuir estos dados a OpenStreetMap para que el mapa de CITY sea aún mas completo, pero nos quedan algunos preguntas acerca de la concesión de licencias de estos dados.

Con que condiciones abriria dados acerca de los nombres de las calles y otros datos geograficos?

Con cualquiera pregunta especifica, me puede hacer una llamada para que le explique mas.

Hi,

We have been working hard to get CITY well mapped on Open Street Map. Open Street Map is like the wikipedia of maps, relying on contributions from an active and growing community of users. Learn more about Open Street Map here.

We have been busy tracing streets, but would like to be able to add street names in order to really complete the map. What data or map sources are available for getting street names? Any format would be helpful: shapefiles, pdf, etc., so long as there is no problem making the data available for public use. Thanks,

As an immersive experience in a foreign land, the WWHGD-WG was certainly educational. It was fun and challenging to think about where MapBox fit into a landscape of mostly federal government agencies whose only notion of open source was "data not published by me", to steal the conclusion of one conversation I had.

But then Nigel Snoad from google.org made a strong showing at the end of the day and wooed the audience talking about google tools to support layer switching of user generated content + sourcing local knowledge using MyMaps, all while mushing mention of MapMaker + OSM into a passing comment. Given how popular his talk was and how little alternative/real open source tools were discussed, there is huge space for Mapbox to really disrupt a lot of entrenched paradigmatic thinking around open data and user generated content in this community.

##An Open Mapping Tool Chain

The process of adding data to OpenStreetMap to styling and publishing your maps online is not obvious at first. I'll walk though the open source tool chain we use to contribute to OSM, and how to use TileMill to leverage OSM data to build custom maps. Specifically I will share some of our recent experience over the past several weeks of tracing in Brazil and publishing maps online. I will share specifics on how to get started tracing roads and buildings from satellite imagery in a few minutes to how we actively engage local communities and working with local governments to open large datasets and import them to OpenStreetMap. Finally I will end showing how how to turn an OSM export into a map and publish it on your web site.

Las Carreteras de Jalisco Están disponibles a OSM

Vives en Jalisco? Ya puedes añadir las calles de tu estado

Estamos animados de liberar un conjunto de datos de todas las carreteras en el estado mexicano de Jalisco, asi que se lo puede contribuir en el editor popular JOSM. Vista nuestra repositorio osm-jalisco para bajar los datos y aprender como empezar.

Una prestación estilizada en TileMIll

	alter table clean_sch add column chg_math04_0910;
	alter table clean_sch add column chg_math08_0910;
	alter table clean_sch add column chg_math10_0910;
	alter table clean_sch add column chg_math12_0910;
	alter table clean_sch add column chg_read04_0910;
	alter table clean_sch add column chg_read08_0910;
	alter table clean_sch add column chg_read10_0910;
	alter table clean_sch add column chg_read12_0910;

	update clean_sch set chg_math04_0910 = 'up' where (all_math04_0910 > all_math04_0809);

	(select
	OGC_FID,
	GEOMETRY,
	t.stnam,
	t.schnam,
	t.fipst,
	t.leanm,
	t.leaid,
	t.ncessch,
	change,

	way[!boundary],
	way[!admin] {
	casing-width: +4;
	casing-color: #FF00FF;
	}

	way[boundary][admin_level] {
	casing-width: +4;
	casing-color: #00FF00;
	}