{ "metadata": { "name": "", "signature": "sha256:49d6947f9ecba00c357a707d7e9c520d821365dc84b96fbf007dbefc9f0818e8" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "import urllib, urllib2\n", "param = {'where':'1=1','outFields':'*','f':'json'}\n", "url = 'http://coagisweb.cabq.gov/arcgis/rest/services/public/APD_Incidents/MapServer/0/query?' + urllib.urlencode(param)\n", "rawreply = urllib2.urlopen(url).read()" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "rawreply[0]" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 2, "text": [ "'{'" ] } ], "prompt_number": 2 }, { "cell_type": "code", "collapsed": false, "input": [ "type(rawreply)" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 3, "text": [ "str" ] } ], "prompt_number": 3 }, { "cell_type": "code", "collapsed": false, "input": [ "import simplejson\n", "reply = simplejson.loads(rawreply)\n", "print reply[\"features\"][0][\"attributes\"][\"date\"]\n", "print reply[\"features\"][0][\"attributes\"][\"CVINC_TYPE\"]" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "1405468800000\n", "LARCENY ALL OTHER\n" ] } ], "prompt_number": 4 }, { "cell_type": "code", "collapsed": true, "input": [ "print len(reply[\"features\"])\n", "#reply[\"features\"][:3]\n", "reply[\"features\"][2:5]" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "24440\n" ] }, { "metadata": {}, "output_type": "pyout", "prompt_number": 5, "text": [ "[{u'attributes': {u'CVINC_TYPE': u'THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE',\n", " u'CV_BLOCK_ADD': u'4300 BLOCK ZUNI RD SE',\n", " u'OBJECTID': 1396553,\n", " u'date': 1405555200000L},\n", " u'geometry': {u'x': -11866271.569699999, u'y': 4173822.9486000016}},\n", " {u'attributes': {u'CVINC_TYPE': u'BURGLARY/BREAKING AND ENTERING',\n", " u'CV_BLOCK_ADD': u'1200 BLOCK DICKERSON DR SE',\n", " u'OBJECTID': 1396554,\n", " u'date': 1405468800000L},\n", " u'geometry': {u'x': -11868874.981800001, u'y': 4173046.724200003}},\n", " {u'attributes': {u'CVINC_TYPE': u'THEFT FROM A BUILDING',\n", " u'CV_BLOCK_ADD': u'1300 BLOCK VALLEY VIEW DR SW',\n", " u'OBJECTID': 1396555,\n", " u'date': 1405555200000L},\n", " u'geometry': {u'x': -11882344.039, u'y': 4170566.8716999963}}]" ] } ], "prompt_number": 5 }, { "cell_type": "code", "collapsed": false, "input": [ "count = 0\n", "myformateddata=[]\n", "while (count < len(reply[\"features\"])):\n", " mydict={}\n", " for key, value in reply[\"features\"][count][\"attributes\"].iteritems():\n", " mydict[key]= value\n", " myformateddata.append(mydict)\n", " count = count + 1" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 6 }, { "cell_type": "code", "collapsed": false, "input": [ "from pandas import DataFrame as df\n", "myFrame = df(data=myformateddata)\n", "len(myFrame)" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 7, "text": [ "24440" ] } ], "prompt_number": 7 }, { "cell_type": "code", "collapsed": false, "input": [ "myFrame" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | CVINC_TYPE | \n", "CV_BLOCK_ADD | \n", "OBJECTID | \n", "date | \n", "
---|---|---|---|---|
0 | \n", "LARCENY ALL OTHER | \n", "7800 BLOCK CENTRAL AVE E | \n", "1396551 | \n", "1.405469e+12 | \n", "
1 | \n", "SHOPLIFTING | \n", "7800 BLOCK CENTRAL AV E | \n", "1396552 | \n", "1.405555e+12 | \n", "
2 | \n", "THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE | \n", "4300 BLOCK ZUNI RD SE | \n", "1396553 | \n", "1.405555e+12 | \n", "
3 | \n", "BURGLARY/BREAKING AND ENTERING | \n", "1200 BLOCK DICKERSON DR SE | \n", "1396554 | \n", "1.405469e+12 | \n", "
4 | \n", "THEFT FROM A BUILDING | \n", "1300 BLOCK VALLEY VIEW DR SW | \n", "1396555 | \n", "1.405555e+12 | \n", "
5 | \n", "AUTO BURGLARY | \n", "1500 BLOCK GIBSON BLVD SE | \n", "1396556 | \n", "1.405469e+12 | \n", "
6 | \n", "BURGLARY/BREAKING AND ENTERING | \n", "2000 BLOCK SOUTHERN AVE SE | \n", "1396557 | \n", "1.405469e+12 | \n", "
7 | \n", "VAGRANCY, BEGGING OR LOITERING | \n", "2100 BLOCK CENTRAL AV E | \n", "1396558 | \n", "1.405555e+12 | \n", "
8 | \n", "COMMERCIAL BURGLARY | \n", "1400 BLOCK BROADWAY BL SE | \n", "1396559 | \n", "1.405555e+12 | \n", "
9 | \n", "DRIVING WHILE INTOXICATED | \n", "7600 BLOCK MONTGOMERY BL NE | \n", "1396560 | \n", "1.405642e+12 | \n", "
10 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "7000 BLOCK NATALIE JANAE LN NE | \n", "1396561 | \n", "1.405642e+12 | \n", "
11 | \n", "AUTO BURGLARY | \n", "4800 BLOCK SPRING VALE RD NW | \n", "1396562 | \n", "1.405469e+12 | \n", "
12 | \n", "THEFT FROM A BUILDING | \n", "9500 BLOCK CANDELARIA RD NE | \n", "1396563 | \n", "1.405469e+12 | \n", "
13 | \n", "THEFT FROM A MOTOR VEHICLE | \n", "UNIT BLOCK HOTEL CI NE | \n", "1396564 | \n", "1.405555e+12 | \n", "
14 | \n", "SIMPLE ASSAULT/BATTERY | \n", "13100 BLOCK CENTRAL AV E | \n", "1396565 | \n", "1.405555e+12 | \n", "
15 | \n", "SHOPLIFTING | \n", "3500 BLOCK COORS BLVD SW | \n", "1396566 | \n", "1.405642e+12 | \n", "
16 | \n", "AGGRAVATED ASSAULT | \n", "3300 BLOCK RIO PLATA DR SW | \n", "1396567 | \n", "1.405555e+12 | \n", "
17 | \n", "THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE | \n", "3900 BLOCK 11TH ST NW | \n", "1396568 | \n", "1.405555e+12 | \n", "
18 | \n", "DRIVING WHILE INTOXICATED | \n", "800 BLOCK RIO GRANDE BLVD NW | \n", "1396569 | \n", "1.405555e+12 | \n", "
19 | \n", "DISORDERLY CONDUCT | \n", "200 BLOCK LOMAS BLVD NW | \n", "1396570 | \n", "1.405469e+12 | \n", "
20 | \n", "AUTO BURGLARY | \n", "1300 BLOCK OJO SARCO ST SW | \n", "1396571 | \n", "1.405642e+12 | \n", "
21 | \n", "SHOPLIFTING | \n", "1400 BLOCK RENAISSANCE BL NE | \n", "1396572 | \n", "1.405555e+12 | \n", "
22 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "100 BLOCK UNION SQUARE ST SE | \n", "1396573 | \n", "1.405642e+12 | \n", "
23 | \n", "BURGLARY/BREAKING AND ENTERING | \n", "1000 BLOCK MOUNTAIN RD NW | \n", "1396574 | \n", "1.405555e+12 | \n", "
24 | \n", "DISORDERLY CONDUCT | \n", "3800 BLOCK CENTRAL AV E | \n", "1396575 | \n", "1.405555e+12 | \n", "
25 | \n", "AUTO BURGLARY | \n", "900 BLOCK LOUISIANA BL NE | \n", "1396576 | \n", "1.405555e+12 | \n", "
26 | \n", "AUTO BURGLARY | \n", "2000 BLOCK MENAUL BLVD NE | \n", "1396577 | \n", "1.405642e+12 | \n", "
27 | \n", "AUTO THEFT | \n", "500 BLOCK ORTIZ DR SE | \n", "1396578 | \n", "1.405469e+12 | \n", "
28 | \n", "THEFT FROM A BUILDING | \n", "9100 BLOCK COPPER AV NE | \n", "1396579 | \n", "1.405469e+12 | \n", "
29 | \n", "AUTO THEFT | \n", "3900 BLOCK MONTGOMERY BLVD NE | \n", "1396580 | \n", "1.405469e+12 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
24410 | \n", "CREDIT CARD/ATM FRAUD | \n", "6100 BLOCK FLOR DE RIO NW | \n", "1420961 | \n", "1.420502e+12 | \n", "
24411 | \n", "AUTO THEFT | \n", "5300 BLOCK MONTGOMERY BLVD NE | \n", "1420962 | \n", "1.420502e+12 | \n", "
24412 | \n", "THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE | \n", "1200 BLOCK SILVER AVE SW | \n", "1420963 | \n", "1.420502e+12 | \n", "
24413 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "3000 BLOCK QUAIL POINTE DR NW | \n", "1420964 | \n", "1.420502e+12 | \n", "
24414 | \n", "FRAUD | \n", "2800 BLOCK MADISON ST NE | \n", "1420965 | \n", "1.420502e+12 | \n", "
24415 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "1200 BLOCK SILVER AVE SW | \n", "1420966 | \n", "1.420502e+12 | \n", "
24416 | \n", "AUTO BURGLARY | \n", "6000 BLOCK TOPKE PL NE | \n", "1420967 | \n", "1.420502e+12 | \n", "
24417 | \n", "AUTO THEFT | \n", "500 BLOCK 4TH ST NW | \n", "1420968 | \n", "1.420502e+12 | \n", "
24418 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "4200 BLOCK COE DR NE | \n", "1420969 | \n", "1.420502e+12 | \n", "
24419 | \n", "AUTO THEFT | \n", "3000 BLOCK EUBANK BLVD NE | \n", "1420970 | \n", "1.420502e+12 | \n", "
24420 | \n", "WEAPONS VIOLATION | \n", "100 BLOCK DEPUTY DEAN MIERA DR SW | \n", "1420971 | \n", "1.418774e+12 | \n", "
24421 | \n", "EMBEZZLEMENT, MISAPPROPRIATION | \n", "1600 BLOCK VALLEY RD SW | \n", "1420972 | \n", "1.414454e+12 | \n", "
24422 | \n", "AUTO THEFT | \n", "2000 BLOCK SHIPMAN RD SW | \n", "1420973 | \n", "1.416787e+12 | \n", "
24423 | \n", "LARCENY ALL OTHER | \n", "9900 BLOCK CLEARWATER ST NW | \n", "1420974 | \n", "1.417565e+12 | \n", "
24424 | \n", "DISORDERLY CONDUCT | \n", "4500 BLOCK BROADWAY BLVD SE | \n", "1420975 | \n", "1.417565e+12 | \n", "
24425 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "200 BLOCK SUNNYSLOPE ST SW | \n", "1420976 | \n", "1.417565e+12 | \n", "
24426 | \n", "COMMERCIAL BURGLARY | \n", "8800 BLOCK 2ND ST NW | \n", "1420977 | \n", "1.417565e+12 | \n", "
24427 | \n", "DRUG/NARCOTICS VIOLATIONS | \n", "200 BLOCK WILLOW RD NW | \n", "1420978 | \n", "1.418429e+12 | \n", "
24428 | \n", "LARCENY ALL OTHER | \n", "2200 BLOCK CAMPANA CT SW | \n", "1420979 | \n", "1.418342e+12 | \n", "
24429 | \n", "SHOPLIFTING | \n", "5600 BLOCK EDITH BLVD NE | \n", "1420980 | \n", "1.418342e+12 | \n", "
24430 | \n", "DRUG/NARCOTICS VIOLATIONS | \n", "1000 BLOCK LA VEGA DR SW | \n", "1420981 | \n", "1.417997e+12 | \n", "
24431 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "6000 BLOCK ISLETA BLVD SW | \n", "1420982 | \n", "1.417997e+12 | \n", "
24432 | \n", "POSSESSION OF DRUG PARAPHERNALIA | \n", "N/A | \n", "1420983 | \n", "1.417133e+12 | \n", "
24433 | \n", "POSSESSION OF DRUG PARAPHERNALIA | \n", "2600 BLOCK COORS BLVD NW | \n", "1420984 | \n", "1.418602e+12 | \n", "
24434 | \n", "SIMPLE ASSAULT/BATTERY | \n", "500 BLOCK MUSCATEL AVE NE | \n", "1420985 | \n", "1.417910e+12 | \n", "
24435 | \n", "EMBEZZLEMENT, MISAPPROPRIATION | \n", "600 BLOCK VINEYARD RD NE | \n", "1420986 | \n", "1.419034e+12 | \n", "
24436 | \n", "AUTO THEFT | \n", "3200 BLOCK ISLETA BLVD SW | \n", "1420987 | \n", "1.418947e+12 | \n", "
24437 | \n", "AUTO THEFT | \n", "300 BLOCK DEL AKER RD NW | \n", "1420988 | \n", "1.419034e+12 | \n", "
24438 | \n", "AUTO THEFT | \n", "300 BLOCK EL PUEBLO RD NW | \n", "1420989 | \n", "1.418774e+12 | \n", "
24439 | \n", "LARCENY ALL OTHER | \n", "6000 BLOCK BECK RD SW | \n", "1420990 | \n", "1.410912e+12 | \n", "
24440 rows \u00d7 4 columns
\n", "\n", " | CVINC_TYPE | \n", "CV_BLOCK_ADD | \n", "OBJECTID | \n", "date | \n", "
---|---|---|---|---|
17579 | \n", "DRIVING WHILE INTOXICATED | \n", "9000 BLOCK CENTRAL SW | \n", "1414130 | \n", "1.420934e+12 | \n", "
17585 | \n", "AUTO BURGLARY | \n", "4400 BLOCK THE 25 WAY NE | \n", "1414136 | \n", "1.420934e+12 | \n", "
17605 | \n", "EMBEZZLEMENT, MISAPPROPRIATION | \n", "4300 BLOCK NANDINA CT NW | \n", "1414156 | \n", "1.420934e+12 | \n", "
17620 | \n", "DISTURBANCE | \n", "900 BLOCK SAN PEDRO DR NE | \n", "1414171 | \n", "1.420934e+12 | \n", "
17621 | \n", "AUTO THEFT | \n", "3300 BLOCK WELLESLEY CT NE | \n", "1414172 | \n", "1.420934e+12 | \n", "
17624 | \n", "AUTO BURGLARY | \n", "3300 BLOCK WELLESLEY NE | \n", "1414175 | \n", "1.420934e+12 | \n", "
17636 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "1200 BLOCK CHELWOOD PARK BL NE | \n", "1414187 | \n", "1.420934e+12 | \n", "
17637 | \n", "AUTO BURGLARY | \n", "1600 BLOCK PENNSYLVANIA ST NE | \n", "1414188 | \n", "1.420934e+12 | \n", "
17643 | \n", "AUTO THEFT | \n", "5800 BLOCK HARPER DR NE | \n", "1414194 | \n", "1.420934e+12 | \n", "
17747 | \n", "DISTURBANCE | \n", "3100 BLOCK CENTRAL AVE E | \n", "1414298 | \n", "1.420934e+12 | \n", "
17748 | \n", "SHOPLIFTING | \n", "2200 BLOCK Q ST NE | \n", "1414299 | \n", "1.420934e+12 | \n", "
17749 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "8500 BLOCK VISTA CLARA LN SW | \n", "1414300 | \n", "1.420934e+12 | \n", "
17750 | \n", "DISORDERLY CONDUCT | \n", "900 BLOCK LOUISIANA BL NE | \n", "1414301 | \n", "1.420934e+12 | \n", "
17759 | \n", "THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE | \n", "600 BLOCK CHAMA ST SE | \n", "1414310 | \n", "1.420934e+12 | \n", "
17760 | \n", "COMMERCIAL BURGLARY | \n", "3300 BLOCK COLUMBIA DR. NE | \n", "1414311 | \n", "1.420934e+12 | \n", "
17761 | \n", "DISORDERLY CONDUCT | \n", "1000 BLOCK LOUISIANA BLVD SE | \n", "1414312 | \n", "1.420934e+12 | \n", "
17765 | \n", "SHOPLIFTING | \n", "6600 BLOCK MENAUL BL NE | \n", "1414316 | \n", "1.420934e+12 | \n", "
17766 | \n", "DRUG/NARCOTICS VIOLATIONS | \n", "6600 BLOCK MENAUL BL NE | \n", "1414317 | \n", "1.420934e+12 | \n", "
17778 | \n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI | \n", "1800 BLOCK ZENA LONA CT NE | \n", "1414329 | \n", "1.420934e+12 | \n", "
17779 | \n", "AGGRAVATED ASSAULT | \n", "1100 BLOCK CENTRAL SE | \n", "1414330 | \n", "1.420934e+12 | \n", "