A Mobile Information System Based on Crowd-Sensed and Official Crime Data for Finding Safe Routes: A Case Study of Mexico City

<table class="table-group" id="tab2"><tr><td><table class="table"><tr><td class="thead-hr" colspan="9"><hr/></td></tr><tr class="thead"><td class="align_left" rowspan="2">Event type </td><td class="align_center" colspan="4"> Year: 2012 </td><td class="align_center" colspan="4"> Year: 2013 </td></tr><tr class="thead"><td class="align_center"><span style="width: 14.7674ptpx;"><svg height="11.9479pt" id="M7" style="vertical-align:-3.181499pt" version="1.1" viewbox="-0.0498162 -8.7664 14.7674 11.9479" width="14.7674pt" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><g transform="matrix(.013,0,0,-0.013,0,0)"><path d="M720 -138C627 -96 538 -41 476 2C594 39 703 153 703 331C703 532 552 665 384 665C170 665 44 499 44 315C44 215 87 129 147 73C211 11 298 -11 355 -14C476 -99 554 -136 584 -144S664 -160 712 -159L720 -138ZM348 25C231 49 146 172 146 342C146 533 249 629 360 629C497 629 601 510 601 302C601 142 523 51 443 28C434 34 425 41 416 47L348 25Z" id="g121-79"></path><glyph.data ascent="989" descent="-360" horiz-adv-x="745" vert-adv-y="745"></glyph.data></g><g transform="matrix(.0091,0,0,-0.0091,9.685,3.132)"><path d="M389 0V32C297 38 291 46 291 118V635C234 613 175 595 109 583V556L161 554C203 552 207 547 207 497V118C207 46 201 38 110 32V0H389Z" id="g50-50"></path><glyph.data ascent="3443" descent="-2856" horiz-adv-x="487" vert-adv-y="487"></glyph.data></g></svg></span></td><td class="align_center"><span style="width: 14.7674ptpx;"><svg height="11.9479pt" id="M8" style="vertical-align:-3.181499pt" version="1.1" viewbox="-0.0498162 -8.7664 14.7674 11.9479" width="14.7674pt" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><g transform="matrix(.013,0,0,-0.013,0,0)"><path d="M720 -138C627 -96 538 -41 476 2C594 39 703 153 703 331C703 532 552 665 384 665C170 665 44 499 44 315C44 215 87 129 147 73C211 11 298 -11 355 -14C476 -99 554 -136 584 -144S664 -160 712 -159L720 -138ZM348 25C231 49 146 172 146 342C146 533 249 629 360 629C497 629 601 510 601 302C601 142 523 51 443 28C434 34 425 41 416 47L348 25Z" id="g121-79"></path><glyph.data ascent="989" descent="-360" horiz-adv-x="745" vert-adv-y="745"></glyph.data></g><g transform="matrix(.0091,0,0,-0.0091,9.685,3.132)"><path d="M414 144C384 79 371 75 317 75H135L276 221C367 316 408 376 408 465C408 570 327 635 237 635C179 635 131 609 100 575L42 494L67 471C94 510 138 565 205 565C277 565 321 517 321 435C321 348 258 270 195 195C146 137 88 81 33 26V0H411C423 44 433 88 446 135L414 144Z" id="g50-51"></path><glyph.data ascent="3443" descent="-2856" horiz-adv-x="487" vert-adv-y="487"></glyph.data></g></svg></span></td><td class="align_center"><span style="width: 14.7674ptpx;"><svg height="12.0575pt" id="M9" style="vertical-align:-3.2911pt" version="1.1" viewbox="-0.0498162 -8.7664 14.7674 12.0575" width="14.7674pt" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><g transform="matrix(.013,0,0,-0.013,0,0)"><path d="M720 -138C627 -96 538 -41 476 2C594 39 703 153 703 331C703 532 552 665 384 665C170 665 44 499 44 315C44 215 87 129 147 73C211 11 298 -11 355 -14C476 -99 554 -136 584 -144S664 -160 712 -159L720 -138ZM348 25C231 49 146 172 146 342C146 533 249 629 360 629C497 629 601 510 601 302C601 142 523 51 443 28C434 34 425 41 416 47L348 25Z" id="g121-79"></path><glyph.data ascent="989" descent="-360" horiz-adv-x="745" vert-adv-y="745"></glyph.data></g><g transform="matrix(.0091,0,0,-0.0091,9.685,3.132)"><path d="M290 377C321 398 342 415 358 430C378 450 389 473 389 502C389 578 329 635 238 635H237C184 635 137 610 109 578L64 515L88 493C112 529 154 573 208 573S303 542 303 482C303 409 233 370 141 341L149 308C165 313 190 319 215 319C272 319 341 283 341 193C342 98 292 43 222 43C163 43 122 72 96 94C88 101 79 100 70 94C61 87 47 73 46 60C44 47 48 37 62 23C76 10 118 -12 165 -12C238 -12 430 62 430 223C430 297 379 359 290 375V377Z" id="g50-52"></path><glyph.data ascent="3443" descent="-2856" horiz-adv-x="487" vert-adv-y="487"></glyph.data></g></svg></span></td><td class="align_center"><span style="width: 14.7674ptpx;"><svg height="11.9479pt" id="M10" style="vertical-align:-3.181499pt" version="1.1" viewbox="-0.0498162 -8.7664 14.7674 11.9479" width="14.7674pt" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><g transform="matrix(.013,0,0,-0.013,0,0)"><path d="M720 -138C627 -96 538 -41 476 2C594 39 703 153 703 331C703 532 552 665 384 665C170 665 44 499 44 315C44 215 87 129 147 73C211 11 298 -11 355 -14C476 -99 554 -136 584 -144S664 -160 712 -159L720 -138ZM348 25C231 49 146 172 146 342C146 533 249 629 360 629C497 629 601 510 601 302C601 142 523 51 443 28C434 34 425 41 416 47L348 25Z" id="g121-79"></path><glyph.data ascent="989" descent="-360" horiz-adv-x="745" vert-adv-y="745"></glyph.data></g><g transform="matrix(.0091,0,0,-0.0091,9.685,3.132)"><path d="M462 177V227H365V632H320C217 496 116 350 21 208V177H284V109C284 43 280 38 190 31V0H451V31C369 38 365 43 365 108V177H462ZM284 227H88C155 336 218 430 282 519H284V227Z" id="g50-53"></path><glyph.data ascent="3443" descent="-2856" horiz-adv-x="487" vert-adv-y="487"></glyph.data></g></svg></span></td><td class="align_center"><span style="width: 14.7674ptpx;"><svg height="11.9479pt" id="M11" style="vertical-align:-3.181499pt" version="1.1" viewbox="-0.0498162 -8.7664 14.7674 11.9479" width="14.7674pt" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><g transform="matrix(.013,0,0,-0.013,0,0)"><path d="M720 -138C627 -96 538 -41 476 2C594 39 703 153 703 331C703 532 552 665 384 665C170 665 44 499 44 315C44 215 87 129 147 73C211 11 298 -11 355 -14C476 -99 554 -136 584 -144S664 -160 712 -159L720 -138ZM348 25C231 49 146 172 146 342C146 533 249 629 360 629C497 629 601 510 601 302C601 142 523 51 443 28C434 34 425 41 416 47L348 25Z" id="g121-79"></path><glyph.data ascent="989" descent="-360" horiz-adv-x="745" vert-adv-y="745"></glyph.data></g><g transform="matrix(.0091,0,0,-0.0091,9.685,3.132)"><path d="M389 0V32C297 38 291 46 291 118V635C234 613 175 595 109 583V556L161 554C203 552 207 547 207 497V118C207 46 201 38 110 32V0H389Z" id="g50-50"></path><glyph.data ascent="3443" descent="-2856" horiz-adv-x="487" vert-adv-y="487"></glyph.data></g></svg></span></td><td class="align_center"><span style="width: 14.7674ptpx;"><svg height="11.9479pt" id="M12" style="vertical-align:-3.181499pt" version="1.1" viewbox="-0.0498162 -8.7664 14.7674 11.9479" width="14.7674pt" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><g transform="matrix(.013,0,0,-0.013,0,0)"><path d="M720 -138C627 -96 538 -41 476 2C594 39 703 153 703 331C703 532 552 665 384 665C170 665 44 499 44 315C44 215 87 129 147 73C211 11 298 -11 355 -14C476 -99 554 -136 584 -144S664 -160 712 -159L720 -138ZM348 25C231 49 146 172 146 342C146 533 249 629 360 629C497 629 601 510 601 302C601 142 523 51 443 28C434 34 425 41 416 47L348 25Z" id="g121-79"></path><glyph.data ascent="989" descent="-360" horiz-adv-x="745" vert-adv-y="745"></glyph.data></g><g transform="matrix(.0091,0,0,-0.0091,9.685,3.132)"><path d="M414 144C384 79 371 75 317 75H135L276 221C367 316 408 376 408 465C408 570 327 635 237 635C179 635 131 609 100 575L42 494L67 471C94 510 138 565 205 565C277 565 321 517 321 435C321 348 258 270 195 195C146 137 88 81 33 26V0H411C423 44 433 88 446 135L414 144Z" id="g50-51"></path><glyph.data ascent="3443" descent="-2856" horiz-adv-x="487" vert-adv-y="487"></glyph.data></g></svg></span></td><td class="align_center"><span style="width: 14.7674ptpx;"><svg height="12.0575pt" id="M13" style="vertical-align:-3.2911pt" version="1.1" viewbox="-0.0498162 -8.7664 14.7674 12.0575" width="14.7674pt" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><g transform="matrix(.013,0,0,-0.013,0,0)"><path d="M720 -138C627 -96 538 -41 476 2C594 39 703 153 703 331C703 532 552 665 384 665C170 665 44 499 44 315C44 215 87 129 147 73C211 11 298 -11 355 -14C476 -99 554 -136 584 -144S664 -160 712 -159L720 -138ZM348 25C231 49 146 172 146 342C146 533 249 629 360 629C497 629 601 510 601 302C601 142 523 51 443 28C434 34 425 41 416 47L348 25Z" id="g121-79"></path><glyph.data ascent="989" descent="-360" horiz-adv-x="745" vert-adv-y="745"></glyph.data></g><g transform="matrix(.0091,0,0,-0.0091,9.685,3.132)"><path d="M290 377C321 398 342 415 358 430C378 450 389 473 389 502C389 578 329 635 238 635H237C184 635 137 610 109 578L64 515L88 493C112 529 154 573 208 573S303 542 303 482C303 409 233 370 141 341L149 308C165 313 190 319 215 319C272 319 341 283 341 193C342 98 292 43 222 43C163 43 122 72 96 94C88 101 79 100 70 94C61 87 47 73 46 60C44 47 48 37 62 23C76 10 118 -12 165 -12C238 -12 430 62 430 223C430 297 379 359 290 375V377Z" id="g50-52"></path><glyph.data ascent="3443" descent="-2856" horiz-adv-x="487" vert-adv-y="487"></glyph.data></g></svg></span></td><td class="align_center"><span style="width: 14.7674ptpx;"><svg height="11.9479pt" id="M14" style="vertical-align:-3.181499pt" version="1.1" viewbox="-0.0498162 -8.7664 14.7674 11.9479" width="14.7674pt" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><g transform="matrix(.013,0,0,-0.013,0,0)"><path d="M720 -138C627 -96 538 -41 476 2C594 39 703 153 703 331C703 532 552 665 384 665C170 665 44 499 44 315C44 215 87 129 147 73C211 11 298 -11 355 -14C476 -99 554 -136 584 -144S664 -160 712 -159L720 -138ZM348 25C231 49 146 172 146 342C146 533 249 629 360 629C497 629 601 510 601 302C601 142 523 51 443 28C434 34 425 41 416 47L348 25Z" id="g121-79"></path><glyph.data ascent="989" descent="-360" horiz-adv-x="745" vert-adv-y="745"></glyph.data></g><g transform="matrix(.0091,0,0,-0.0091,9.685,3.132)"><path d="M462 177V227H365V632H320C217 496 116 350 21 208V177H284V109C284 43 280 38 190 31V0H451V31C369 38 365 43 365 108V177H462ZM284 227H88C155 336 218 430 282 519H284V227Z" id="g50-53"></path><glyph.data ascent="3443" descent="-2856" horiz-adv-x="487" vert-adv-y="487"></glyph.data></g></svg></span></td></tr><tr><td class="thead-hr" colspan="9"><hr/></td></tr><tr><td class="align_left">Robbery of passenger in public transport </td><td class="align_center"> 159 </td><td class="align_center"> 175 </td><td class="align_center"> 154 </td><td class="align_center"> 111 </td><td class="align_center"> 102 </td><td class="align_center"> 134 </td><td class="align_center"> 115 </td><td class="align_center"> 86 </td></tr><tr><td class="align_left">Robbery of passer without violence </td><td class="align_center"> 47 </td><td class="align_center"> 80 </td><td class="align_center"> 54 </td><td class="align_center"> 79 </td><td class="align_center"> 73 </td><td class="align_center"> 46 </td><td class="align_center"> 49 </td><td class="align_center"> 57 </td></tr><tr class="table-tr"><td colspan="9"><hr class="tbody-hr"/></td></tr></table></td></tr></table>

Record structure for the official database.

Mobile Information Systems

tab2

Table 2

Table 2: A Mobile Information System Based on Crowd-Sensed and Official Crime Data for Finding Safe Routes: A Case Study of Mexico City 