Skip to content

Instantly share code, notes, and snippets.

@dmasad

dmasad/Aleppo_points.R

Created August 12, 2013 17:20
Show Gist options
  • Save dmasad/6213011 to your computer and use it in GitHub Desktop.
Save dmasad/6213011 to your computer and use it in GitHub Desktop.
Download ZIP
GDELT geocoded points for violent events in Aleppo, 2011-2013.
Raw
Aleppo_points.csv
We can make this file beautiful and searchable if this error is corrected: Any value after quoted field isn't allowed in line 2.
Name Lat Long Count
"Aleppo, ?alab, Syria" 36.2028 37.1586 25225
"Azaz, ?alab, Syria" 36.5866 37.0463 653
"Hamidiyeh, ?alab, Syria" 35.958 37.1142 186
"Berea, ?alab, Syria" 36.2028 37.1586 170
"Anadan, ?alab, Syria" 36.2935 37.0447 155
"Aazaz, ?alab, Syria" 36.5866 37.0463 134
"Qadi Askar, ?alab, Syria" 36.2013 37.1759 90
"Al-Bab, ?alab, Syria" 36.3699 37.5179 86
"Khan Al-Asal, ?alab, Syria" 36.1713 37.0391 82
"Barada, ?alab, Syria" 35.9287 37.1755 77
"Safira, ?alab, Syria" 36.077 37.3725 74
"Halab, ?alab, Syria" 36.2028 37.1586 70
"Nayrab, ?alab, Syria" 36.1756 37.228 69
"Aqraba, ?alab, Syria" 35.9596 37.4114 66
"Hader, ?alab, Syria" 35.9909 37.0517 61
"Nairab, ?alab, Syria" 36.1756 37.228 60
"Alep, ?alab, Syria" 36.2028 37.1586 57
"Afrin, ?alab, Syria" 36.2251 37.3266 53
"Karak, ?alab, Syria" 36.8417 38.3667 40
"Jdeideh, ?alab, Syria" 36.4891 36.8568 39
"Atma, ?alab, Syria" 36.3078 36.6889 33
"Al-Hamidiyah, ?alab, Syria" 35.961 37.1054 31
"Manbej, ?alab, Syria" 36.5282 37.955 29
"Al-Atarib, ?alab, Syria" 36.1389 36.825 28
"Al-Safira, ?alab, Syria" 36.077 37.3725 26
"Minakh, ?alab, Syria" 36.5253 37.0481 25
"Khalidiyah, ?alab, Syria" 36.5051 36.925 23
"Jafra, ?alab, Syria" 35.9167 37.45 22
"Hamidiyah, ?alab, Syria" 35.7167 37.1333 21
"Atarib, ?alab, Syria" 36.1389 36.825 21
"Miqdad, ?alab, Syria" 36.7345 36.859 21
"Izaz, ?alab, Syria" 36.5866 37.0463 20
"Neirab, ?alab, Syria" 36.1756 37.228 20
"Akhtarin, ?alab, Syria" 36.5123 37.3358 20
"Irbid, ?alab, Syria" 36.1982 37.5577 18
"Manbij, ?alab, Syria" 36.5282 37.955 18
"Atme, ?alab, Syria" 36.3078 36.6889 17
"Nubl, ?alab, Syria" 36.3787 36.9929 16
"Arrai, ?alab, Syria" 36.6167 37.45 15
"Ifrin, ?alab, Syria" 36.5119 36.8695 15
"Jarabulus, ?alab, Syria" 36.8175 38.0111 15
"Bashar, ?alab, Syria" 36.476 38.2059 14
"Safir, ?alab, Syria" 36.077 37.3725 13
"Deir Hafer, ?alab, Syria" 36.1569 37.7078 13
"Wadi Al-Arab, ?alab, Syria" 36.2217 37.4648 12
"Hayyan, ?alab, Syria" 36.3242 37.0589 9
"Tell Ain, ?alab, Syria" 36.1 37.35 9
"Ziraa, ?alab, Syria" 36.0057 37.3211 9
"Diman, ?alab, Syria" 36.0277 37.2665 9
"Tall Rifat, ?alab, Syria" 36.4736 37.0967 9
"Haritan, ?alab, Syria" 36.2886 37.0853 9
"Sfeira, ?alab, Syria" 36.0199 37.1968 9
"Burj, ?alab, Syria" 36.5331 37.4535 8
"Hamidiye, ?alab, Syria" 35.7167 37.1333 8
"Madinah, ?alab, Syria" 35.9833 37.4 7
"Masseh, ?alab, Syria" 35.801 37.1869 7
"Ein Al-Arab, ?alab, Syria" 36.8932 38.3651 7
"Gharib, ?alab, Syria" 36.85 38.5167 7
"Nasrallah, ?alab, Syria" 36.2124 37.6174 7
"Hayan, ?alab, Syria" 36.3242 37.0589 7
"Qabtan Al-Jabal, ?alab, Syria" 36.2643 36.9494 6
"Rityan, ?alab, Syria" 36.3472 37.092 6
"Atimah, ?alab, Syria" 36.3078 36.6889 6
"Al-Malikiyah, ?alab, Syria" 36.092 37.2793 6
"Kafr Hamra, ?alab, Syria" 36.2528 37.0792 6
"Assan, ?alab, Syria" 36.0866 37.2242 6
"Abu Hanaya, ?alab, Syria" 36.1652 37.8813 6
"El Hermel, ?alab, Syria" 36.1197 37.6661 6
"Wadi Jamal, ?alab, Syria" 36.35 37.0667 6
"Jerablus, ?alab, Syria" 36.8175 38.0111 6
"Hadath, ?alab, Syria" 36.4402 37.4751 5
"Kafr Al-Hamra, ?alab, Syria" 36.2528 37.0792 5
"Abu Taltal, ?alab, Syria" 36.3371 37.5233 5
"Haleb, ?alab, Syria" 36.2028 37.1586 5
"Abu Jabbar, ?alab, Syria" 36.3356 37.6282 5
"Saan, ?alab, Syria" 36.1 37.4833 5
"Handarat, ?alab, Syria" 36.2889 37.1609 5
"Khanasser, ?alab, Syria" 35.7811 37.4993 5
"Al-Aziziyah, ?alab, Syria" 36.208 37.1535 5
"Obaida, ?alab, Syria" 35.7833 37.4667 5
"Al-Hadir, ?alab, Syria" 35.9909 37.0517 5
"Khanasir, ?alab, Syria" 35.7811 37.4993 5
"Mazraah, ?alab, Syria" 36.3471 37.6314 5
"Suran, ?alab, Syria" 36.565 37.2122 5
"Al Safira, ?alab, Syria" 36.077 37.3725 4
"Aziziyah, ?alab, Syria" 35.9421 37.0335 4
"Al-Jubaylah, ?alab, Syria" 36.2022 37.1662 4
"Kafr Halab, ?alab, Syria" 36.0617 36.8702 4
"Jarablos, ?alab, Syria" 36.8175 38.0111 4
"Safirah, ?alab, Syria" 36.077 37.3725 4
"Ain Dara, ?alab, Syria" 36.4646 36.8659 4
"Dabis, ?alab, Syria" 36.7037 37.9568 4
"Marwan, ?alab, Syria" 36.35 38.4458 4
"Ablah, ?alab, Syria" 36.4328 37.3547 4
"Sulayman Al-Halabi, ?alab, Syria" 36.2168 37.1757 4
"Sunbul, ?alab, Syria" 36.4837 37.2458 4
"Qasr Al-Baladi, ?alab, Syria" 36.2031 37.1467 4
"Al-Fursan, ?alab, Syria" 36.7263 37.7052 4
"Ajami, ?alab, Syria" 36.4724 37.7202 4
"Minbej, ?alab, Syria" 36.5282 37.955 4
"Khan Al-Wazir, ?alab, Syria" 36.1996 37.1593 3
"Iskan, ?alab, Syria" 36.3536 36.8067 3
"Madain, ?alab, Syria" 35.8559 37.3051 3
"Abed, ?alab, Syria" 36.2307 37.3676 3
"Sarjah, ?alab, Syria" 35.8919 37.2557 3
"Hafyan, ?alab, Syria" 36.5141 38.3173 3
"Jdeide, ?alab, Syria" 36.4891 36.8568 3
"As-Safirah, ?alab, Syria" 36.077 37.3725 3
"Kuran, ?alab, Syria" 36.44 36.6741 2
"Ramle, ?alab, Syria" 35.716 37.397 2
"Kafr Naha, ?alab, Syria" 36.1683 36.9845 2
"Halab Al-Jadidah, ?alab, Syria" 36.1976 37.1056 2
"Huraytan, ?alab, Syria" 36.2886 37.0853 2
"Al-Magharah, ?alab, Syria" 36.6572 38.2051 2
"Khan Al Asal, ?alab, Syria" 36.1713 37.0391 2
"Rubayah, ?alab, Syria" 35.8167 37.35 2
"Barqum, ?alab, Syria" 36.0373 36.9663 2
"Barakah, ?alab, Syria" 36.5461 36.6855 2
"Abu Shahm, ?alab, Syria" 36.1411 37.0292 2
"Jabalaqra, ?alab, Syria" 36.4251 37.9785 2
"Aleppo, ?alab, Syria" 36.2012 37.1612 2
"Al-Jamiliyah, ?alab, Syria" 36.2069 37.1413 2
"Dulaym, ?alab, Syria" 36.6777 37.9832 2
"Al-Birah, ?alab, Syria" 36.3851 37.853 2
"Zarzur, ?alab, Syria" 36.4088 37.6166 2
"Qabtan Al Jabal, ?alab, Syria" 36.2643 36.9494 2
"Hajeb, ?alab, Syria" 35.8637 37.3966 2
"Al-Malihah, ?alab, Syria" 35.6219 37.209 1
"Dulab, ?alab, Syria" 36.0996 37.5259 1
"Zahriyah, ?alab, Syria" 35.8667 37.2333 1
"Aradah, ?alab, Syria" 36.0846 36.9366 1
"Kassar, ?alab, Syria" 36.4278 37.3108 1
"Qana, ?alab, Syria" 36.7231 38.127 1
"Tash, ?alab, Syria" 36.85 38.4 1
"Souhour, ?alab, Syria" 35.9 37.439 1
"Kafrhamrah, ?alab, Syria" 36.2528 37.0792 1
"Haddadin, ?alab, Syria" 36.1013 37.1692 1
"Qabtan, ?alab, Syria" 36.5268 37.3634 1
"Shaykhali, ?alab, Syria" 36.0974 36.9138 1
"Mayir, ?alab, Syria" 36.3873 37.0249 1
"Banis, ?alab, Syria" 35.977 36.9748 1
"Jaara, ?alab, Syria" 35.9844 37.3633 1
"Kharjis, ?alab, Syria" 36.2885 37.8348 1
"Shamil, ?alab, Syria" 36.7673 38.0108 1
"Khan Al- Asal, ?alab, Syria" 36.1713 37.0391 1
"Shaykh Jarrah, ?alab, Syria" 36.5173 37.4464 1
"Sourane, ?alab, Syria" 36.565 37.2122 1
"Khan Alasal, ?alab, Syria" 36.1713 37.0391 1
"Dar Ta-Izzah, ?alab, Syria" 36.2825 36.8522 1
"Al-Hadath, ?alab, Syria" 36.4402 37.4751 1
"Salib, ?alab, Syria" 36.8832 38.1721 1
"Arnaz, ?alab, Syria" 36.0996 36.8948 1
Raw
Aleppo_points.R
library(ggmap)
# Load data:
Aleppo_points <- read.delim("Aleppo_points.csv")
Aleppo_points$LogCount = log(Aleppo_points$Count)
# Load map:
aleppo.map <- get_map(location="aleppo", zoom=12, source="google", maptype="terrain", color="bw")
aleppo.map <- ggmap(aleppo.map)
aleppo.map + geom_point(aes(y=Lat, x=Long, size=LogCount), color="#6E9C27", data=Aleppo_points)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment