traduction par l'auteur, Florent Daudens ###Map of the Week, CartoDB ####Guest author: Florent Daudens ####Link (en): http://blog.cartodb.com/mow-radiorent
Montréal a une curieuse tradition : beaucoup de gens déménagent le 1er juillet. Ce qui provoque une chasse aux logements dans les mois précédents.
Deux journalistes de Radio-Canada, Pasquale Harrison-Julien (@pasqualehj) et Florent Daudens (@fdaudens), ont voulu savoir combien coûtent les loyers en moyenne dans la métropole et en banlieue.
Résultat : deux cartes. L’une qui permet de voir le prix moyen des loyers dans 35 zones de la ville et de sa banlieue, par nombre de chambres. L’autre qui permet de comparer ces données avec les données officielles de la Société canadienne d’hypothèques et de logement (SCHL), l’organisme gouvernemental qui surveille le marché. Explications.
This map is a projection experiment with polygon fills from other CartoDB maps, a meta map of the Americas, made for the Storefront for Art and Architecture's art show (Fall 2015) 'Measure'.
CartoDB maps featured are some of the most popular maps made over the past view years, illustrating the variety of maps made possible by open source software. The following SQL changes the projection from standard mercator to azimuthal equidistant.
SELECT ST_Transform(the_geom, 102016) AS the_geom_webmercator FROM table_name
This map visualizes max lat/lon landsat scene capture locations. The data is available via the Landsat Ingester project as a link in the README of that repo.
This map uses CartoDB to view points of LandSat imagery capture across the globe with links to the images as TIFs in the tooltip ID for each point; they are arranged as a choropleth map according to the average percent of cloud cover that might obscure the image capture process.
| SET GEOM FOR NYC | |
| ================ | |
| UPDATE name_of_db SET the_geom = ST_Transform(ST_SetSRID(ST_MakePoint(x_coordinate, y_coordinate),2263),4326) | |
| //Order of Operations nested commands | |
| //ST_MakePoint(x,y) turns any x, y value into a geometry. | |
| (If this was latitude and longitude, that is the same as saying ST_MakePoint(longitude, latitude); backwards (x,y)->(long,lat) | |
| //ST_SetSRID(our_new_geom, 2263) | |
| //wrap in ST_Transform to 4326 - standard projection for geom column always - lat/long |
| .c3 svg{font:10px sans-serif}.c3 line,.c3 path{fill:none;stroke:#000}.c3 text{-webkit-user-select:none;-moz-user-select:none;user-select:none}.c3-bars path,.c3-event-rect,.c3-legend-item-tile,.c3-xgrid-focus,.c3-ygrid{shape-rendering:crispEdges}.c3-chart-arc path{stroke:#fff}.c3-chart-arc text{fill:#fff;font-size:13px}.c3-grid line{stroke:#aaa}.c3-grid text{fill:#aaa}.c3-xgrid,.c3-ygrid{stroke-dasharray:3 3}.c3-text.c3-empty{fill:gray;font-size:2em}.c3-line{stroke-width:1px}.c3-circle._expanded_{stroke-width:1px;stroke:#fff}.c3-selected-circle{fill:#fff;stroke-width:2px}.c3-bar{stroke-width:0}.c3-bar._expanded_{fill-opacity:.75}.c3-chart-arcs-title{dominant-baseline:middle;font-size:1.3em}.c3-target.c3-focused{opacity:1}.c3-target.c3-focused path.c3-line,.c3-target.c3-focused path.c3-step{stroke-width:2px}.c3-target.c3-defocused{opacity:.3!important}.c3-region{fill:#4682b4;fill-opacity:.1}.c3-brush .extent{fill-opacity:.1}.c3-legend-item{font-size:12px}.c3-legend-item-hidden{opacity:.15}.c3-legend-background{ |
| .c3 svg{font:10px sans-serif}.c3 line,.c3 path{fill:none;stroke:#000}.c3 text{-webkit-user-select:none;-moz-user-select:none;user-select:none}.c3-bars path,.c3-event-rect,.c3-legend-item-tile,.c3-xgrid-focus,.c3-ygrid{shape-rendering:crispEdges}.c3-chart-arc path{stroke:#fff}.c3-chart-arc text{fill:#fff;font-size:13px}.c3-grid line{stroke:#aaa}.c3-grid text{fill:#aaa}.c3-xgrid,.c3-ygrid{stroke-dasharray:3 3}.c3-text.c3-empty{fill:gray;font-size:2em}.c3-line{stroke-width:1px}.c3-circle._expanded_{stroke-width:1px;stroke:#fff}.c3-selected-circle{fill:#fff;stroke-width:2px}.c3-bar{stroke-width:0}.c3-bar._expanded_{fill-opacity:.75}.c3-chart-arcs-title{dominant-baseline:middle;font-size:1.3em}.c3-target.c3-focused{opacity:1}.c3-target.c3-focused path.c3-line,.c3-target.c3-focused path.c3-step{stroke-width:2px}.c3-target.c3-defocused{opacity:.3!important}.c3-region{fill:#4682b4;fill-opacity:.1}.c3-brush .extent{fill-opacity:.1}.c3-legend-item{font-size:12px}.c3-legend-item-hidden{opacity:.15}.c3-legend-background{ |
| gistup |
