Jeffrey Johnson jj0hns0n
jj0hns0n
/ gist:4c90db42026fb62795c30052f9dba7eb
Created
May 1, 2025 16:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "city": "Seattle-Tacoma", | |
| "country": "United States", | |
| "year": 2025, | |
| "safest_neighborhoods": [ | |
| { | |
| "name": "Loyal Heights (Seattle)", | |
| "description": "Family-friendly with strong schools and a crime rate 60% lower than the city average.", | |
| "source": "https://www.pods.com/blog/safest-neighborhoods-seattle" | |
| }, |
jj0hns0n
/ gist:5f4d2bc6224aed94bd57a317c063a908
Created
April 30, 2025 16:23
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "city": "Kinshasa", | |
| "country": "Democratic Republic of the Congo", | |
| "year": 2025, | |
| "articles": [ | |
| { | |
| "title": "Braquage mortel à Kinshasa : Deux décès et plusieurs blessés signalés à Bumbu", | |
| "date": "2025-03-11", | |
| "source": { | |
| "name": "Le Potentiel", |
jj0hns0n
/ barranquilla.json
Created
April 30, 2025 15:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "city": "Barranquilla", | |
| "country": "Colombia", | |
| "year": 2025, | |
| "news_sources": [ | |
| { | |
| "name": "El Heraldo", | |
| "url": "https://www.elheraldo.co", | |
| "language": "Spanish" | |
| }, |
jj0hns0n
/ gist:e53e7afa7a7990555cea3919b7f7bbf8
Created
April 30, 2025 15:33
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "city": "Manila", | |
| "country": "Philippines", | |
| "year": 2025, | |
| "articles": [ | |
| { | |
| "title": "Metro Manila Index Crimes Down by 19.6% in January 2025", | |
| "date": "2025-02-02", | |
| "source": { | |
| "name": "Manila Bulletin", |
jj0hns0n
/ manila.json
Created
April 30, 2025 15:18
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "city": "Manila", | |
| "country": "Philippines", | |
| "year": 2025, | |
| "news_sources": [ | |
| { | |
| "name": "Manila Bulletin", | |
| "url": "https://mb.com.ph/", | |
| "language": "English" | |
| }, |
jj0hns0n
/ gist:ab1cd41fa89e3de8e435c83ce07a5987
Last active
April 29, 2025 20:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "city": "São Paulo", | |
| "country": "Brazil", | |
| "year": 2025, | |
| "key_news_sources": [ | |
| { | |
| "name": "Folha de S.Paulo", | |
| "url": "https://www.folha.uol.com.br" | |
| }, | |
| { |
jj0hns0n
/ gist:a3af5b19c67907faea8ad788a913fb17
Created
April 28, 2025 23:55
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH base_risk AS ( | |
| SELECT | |
| *, | |
| ( | |
| -- Base risk calculation using already inverted scores | |
| (prosperity_score_inverted * 0.35) + | |
| (safety_and_security_inverted * 0.25) + | |
| (violent_crime_inverted * 0.20) + | |
| (property_crime_inverted * 0.10) + | |
| (personal_freedom_inverted * 0.10) |
jj0hns0n
/ gist:5ed453fa025e160d3040033a785469a9
Created
April 28, 2025 23:17
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH base_risk AS ( | |
| SELECT | |
| *, | |
| ( | |
| (100 - prosperity_score) * 0.10 + | |
| (100 - safety_and_security) * 0.10 + | |
| (100 - violent_crime) * 0.30 + | |
| (100 - property_crime) * 0.25 | |
| ) AS base_risk_score | |
| FROM your_table |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "jobTypes" : [ | |
| { | |
| "featureDefinitions" : [ | |
| { | |
| "featureClass" : "Pole", | |
| "geometryType" : "Point", | |
| "featureIdAttribute" : "Number", | |
| "arColor" : "#ffff00", | |
| "fixedDistanceInformation" : { |
jj0hns0n
/ gist:47fb3e803693fba2761ba10fb60bb807
Last active
August 23, 2016 09:37
GeoNode Developers Workshop
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| http://docs.geonode.org/en/master/tutorials/overview_and_ref/reference_doc/architecture.html | |
| workon geonode_live | |
| cd geonode_live | |
| python manage.py updatelayers | |
| python manage.py loaddata ../geonode/geonode/base/fixtures/initial_data.json |