Police - Motor Vehicle Citations

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.somervillema.gov
Id 3md9-rv67
Name Police - Motor Vehicle Citations
Category Public Safety
Tags traffic, motor vehicle, violations, citations
Created 2016-02-02T18:28:47Z
Publication Date 2016-02-04T16:54:24Z

Description

Citations filed since 2010.

Columns

| Included | Schema Type    | Field Name  | Name        | Data Type     | Render Type   |
| ======== | ============== | =========== | =========== | ============= | ============= |
| Yes      | numeric metric | sernum      | sernum      | number        | number        |
| Yes      | series tag     | citationnum | citationnum | text          | text          |
| Yes      | time           | dtissued    | dtissued    | calendar_date | calendar_date |
| Yes      | series tag     | stnum       | stnum       | text          | text          |
| Yes      | series tag     | stname1     | stname1     | text          | text          |
| Yes      | series tag     | stname2     | stname2     | text          | text          |
| Yes      | numeric metric | seqnum      | seqnum      | number        | number        |
| Yes      | series tag     | chgcode     | chgcode     | text          | text          |
| Yes      | series tag     | chgdesc     | chgdesc     | text          | text          |
| Yes      | series tag     | vehiclemph  | vehiclemph  | text          | text          |
| Yes      | series tag     | mphzone     | mphzone     | text          | text          |
| Yes      | series tag     | warning     | warning     | text          | text          |
| Yes      | series tag     | noncriminal | noncriminal | text          | text          |
| Yes      | series tag     | compl       | compl       | text          | text          |
| Yes      | series tag     | arrest      | arrest      | text          | text          |
| Yes      | series tag     | voided      | voided      | text          | text          |
| No       |                | x           | X           | number        | number        |
| No       |                | y           | Y           | number        | number        |

Time Field

Value = dtissued
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = x,y

Data Commands

series e:3md9-rv67 d:2012-09-12T08:54:00.000Z t:chgcode=90/10/A t:chgdesc="UNLICENSED OPERATION OF MV c90 S10" t:citationnum=R2516232 t:mphzone=NA t:vehiclemph=NA t:stnum=XX t:stname1="A ALFRED LOMBARDI ST" t:warning=Y m:sernum=293192 m:seqnum=2

series e:3md9-rv67 d:2010-03-24T00:53:00.000Z t:chgcode=89/9 t:noncriminal=Y t:chgdesc="STOP,YIELD, FAIL TO C89 S9" t:citationnum=M8292276 t:mphzone=NA t:vehiclemph=NA t:stnum=XX t:stname1="A ALFRED LOMBARDI ST" m:sernum=270159 m:seqnum=1

series e:3md9-rv67 d:2015-04-26T09:40:00.000Z t:chgcode=89/9 t:chgdesc="STOP/YIELD, FAIL TO c89 S9" t:citationnum=R2423275 t:mphzone=NA t:vehiclemph=NA t:stnum=XX t:stname1="A ALFRED LOMBARDI ST" t:warning=Y m:sernum=318743 m:seqnum=1

Meta Commands

metric m:sernum p:integer l:sernum t:dataTypeName=number

metric m:seqnum p:integer l:seqnum t:dataTypeName=number

entity e:3md9-rv67 l:"Police - Motor Vehicle Citations" t:url=https://data.somervillema.gov/api/views/3md9-rv67

property e:3md9-rv67 t:meta.view v:id=3md9-rv67 v:category="Public Safety" v:averageRating=0 v:name="Police - Motor Vehicle Citations"

property e:3md9-rv67 t:meta.view.license v:name="Open Data Commons Open Database License" v:termsLink=http://opendatacommons.org/licenses/odbl/1.0/

property e:3md9-rv67 t:meta.view.owner v:id=ta4g-utcf v:profileImageUrlMedium=/api/users/ta4g-utcf/profile_images/THUMB v:profileImageUrlLarge=/api/users/ta4g-utcf/profile_images/LARGE v:screenName="Steve Craig" v:profileImageUrlSmall=/api/users/ta4g-utcf/profile_images/TINY v:displayName="Steve Craig"

property e:3md9-rv67 t:meta.view.tableauthor v:id=ta4g-utcf v:profileImageUrlMedium=/api/users/ta4g-utcf/profile_images/THUMB v:profileImageUrlLarge=/api/users/ta4g-utcf/profile_images/LARGE v:screenName="Steve Craig" v:profileImageUrlSmall=/api/users/ta4g-utcf/profile_images/TINY v:roleName=administrator v:displayName="Steve Craig"

Top Records

| sernum | citationnum | dtissued            | stnum | stname1              | stname2 | seqnum | chgcode | chgdesc                                         | vehiclemph | mphzone | warning | noncriminal | compl | arrest | voided | x           | y          | 
| ====== | =========== | =================== | ===== | ==================== | ======= | ====== | ======= | =============================================== | ========== | ======= | ======= | =========== | ===== | ====== | ====== | =========== | ========== | 
| 293192 | R2516232    | 2012-09-12T08:54:00 | XX    | A ALFRED LOMBARDI ST |         | 2      | 90/10/A | UNLICENSED OPERATION OF MV c90 S10              | NA         | NA      | Y       |             |       |        |        | -71.0783489 | 42.3866409 | 
| 270159 | M8292276    | 2010-03-24T00:53:00 | XX    | A ALFRED LOMBARDI ST |         | 1      | 89/9    | STOP,YIELD, FAIL TO C89 S9                      | NA         | NA      |         | Y           |       |        |        | -71.0783489 | 42.3866409 | 
| 318743 | R2423275    | 2015-04-26T09:40:00 | XX    | A ALFRED LOMBARDI ST |         | 1      | 89/9    | STOP/YIELD, FAIL TO c89 S9                      | NA         | NA      | Y       |             |       |        |        | -71.0783489 | 42.3866409 | 
| 315033 | R5390807    | 2014-12-03T09:05:00 | XX    | A ALFRED LOMBARDI ST |         | 2      | 89/9    | STOP/YIELD, FAIL TO c89 S9                      | NA         | NA      |         | Y           |       |        |        | -71.0783489 | 42.3866409 | 
| 310373 | R4902427    | 2014-07-18T16:48:00 | XX    | A ALFRED LOMBARDI ST |         | 1      | 89/4A   | MARKED LANES VIOLATION c89 S4A                  | NA         | NA      |         | Y           |       |        |        | -71.0783489 | 42.3866409 | 
| 270159 | M8292276    | 2010-03-24T00:53:00 | XX    | A ALFRED LOMBARDI ST |         | 2      | 90/20/B | INSPECTION,STICKER, NO C90 S20                  | NA         | NA      |         | Y           |       |        |        | -71.0783489 | 42.3866409 | 
| 318007 | R5381853    | 2015-04-07T18:55:00 | XX    | A ALFRED LOMBARDI ST |         | 1      | 89/4A   | MARKED LANES VIOLATION c89 S4A                  | NA         | NA      |         | Y           |       |        |        | -71.0783489 | 42.3866409 | 
| 280248 | R1496601    | 2011-08-31T10:10:00 | XX    | A ALFRED LOMBARDI ST |         | 1      | 90/13B  | ELECTRONIC MESSAGE, OPERATOR SEND/READ C90 S13B | NA         | NA      |         | Y           |       |        |        | -71.0783489 | 42.3866409 | 
| 309460 | R4902343    | 2014-06-16T16:47:00 | XX    | A ALFRED LOMBARDI ST |         | 1      | 85/11B  | BICYCLE VIOLATION c85 S11B                      | NA         | NA      |         | Y           |       |        |        | -71.0783489 | 42.3866409 | 
| 299429 | R3068292    | 2013-05-21T08:04:00 | XX    | A ALFRED LOMBARDI ST |         | 1      | 89/9    | STOP,YIELD, FAIL TO C89 S9                      | NA         | NA      | Y       |             |       |        |        | -71.0783489 | 42.3866409 |