| ⌘T | go to file |
| ⌘⌃P | go to project |
| ⌘R | go to methods |
| ⌃G | go to line |
| ⌘KB | toggle side bar |
| ⌘⇧P | command prompt |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
- Natural Earth Shapefile downloads for cultural and physical data sets for the entire earth.
- US Census Shapefiles and KML files for US shapes.
(by @andrestaltz)
If you prefer to watch video tutorials with live-coding, then check out this series I recorded with the same contents as in this article: Egghead.io - Introduction to Reactive Programming.
- Natural Earth Shapefile downloads for cultural and physical data sets for the entire earth.
- US Census Shapefiles and KML files for US shapes.
The Open Source Mentorship Program is a partnership between Code for America brigades and Girl Develop It chapters. The "Summer of Open Source" was piloted in Philadelphia over the summer of 2014. Met with great excitement from the success of the experiment, CfA and GDI cemented the partnership so that other brigades and chapters across the country might replicate and extend the impact of this collaboration.
In the summer of 2015, Philadelphia once again launched osmp. This guidebook is the result of their experience and includes both successes and opportunities for improvement. It is as comprehensive as possible, but the intention is for subsequent programs to fork and bu
| class Rover: | |
| pass |
To make the differences between the old ordinance and the new ordinance, I made a few adjustments to them to make the diff line up. Anything in red is being removed, anything in green is being added. Text in black and white is unchanged.
Renamed the DEFINITION section of the new ordinance to DEFINITIONS (plural) to match to show clearly where the real content begins. The new ordinance only has one definition.
Moved the PENALTY section from the end of the new ordenance to after DEFINITIONS to correlate to the original ordinance placement.
Renamed the TNC OPERATING AUTHORITY APPLICATION REQUIRED section of the new ordinance by removing the word "APPLICATION" to match the old ordinance.
In the IDENTITY section, replaced "app" in the new ordinance with "application" to match the old ordinance to demonstrate the similarity.