ian29

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.

ian29

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,

ian29

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.

ian29

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

ian29

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.

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.

ian29

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

ian29

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);

ian29

CREATE TABLE clean_sch AS 
SELECT 
nt.*,
c.stnam stnam07,
c.fipst fipst07,
schnam07,
c.leanm07,		
c.leaid leaid07,
c.ncessch ncessch07,
cast(round((all_math04pctprof_0708 * 100), 1) as text)||'%' all_math04_0708,

ian29

<style>
.wax-tooltip {
  position: absolute;
  height: auto;
  background: #fff;
  border: 1px solid #8C8C8C;
  border: 1px solid rgba(0, 0, 0, .45);
  -moz-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
  -webkit-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
  box-shadow: 0 1px 8px rgba(0, 0, 0, .3);