This repository will be home to documents, tutorials, and other helpful resources for structuring data.
#Structured Query Language
##Learning
- Learn SQL the Hard Way - Clear and simple introduction to SQL.
- SQL vs. NoSQL - Brief introduction to the differences between SQL and NoSQL.
##Databases
###NoSQL
- How to Download Open Street Map (OSM) and Natural Earth Data - [Tutorial] by Nathaniel V. Kelso (@nvkelso)
- National Historic Geographic Information System (NHGIS) - Historic Census and other demographic data, including geographic boundaries
- GeoCommons - Search, preview, share, and download spatial data on a variety of topics.
- Geospatial Data Abstraction Library (GDAL) - Open source toolkit for converting, georeferencing, and projecting spatial data.
- QGIS - Open source geographic information system (GIS). Requires GDAL. Python modules are recommended. See KyngChaos Wiki for OS X info.
- PostGIS - Spatially enabled PostgreSQL relational database. For OS X users, Postgres.app is a recommended 1-click installer.
- GIS tools for Hadoop - "Big data spatial analytics" frameworks and APIs from Esri.
- CartoCSS - Learn the CartoCSS language for styling spatial data. Very similar to Cascading Stylesheets (CSS) for the web.
- TileMill - Load data from Shapefiles, Postgres or SpatialLite DBs, and style with CartoCSS. Render tiles to serve yourself or publish them to MapBox.
#Hadoop