Alternate Parking Citations Dataset

[Chris Metcalf]

Since we don't have lat/lons yet for all the 1.5M parking tickets in
the Citations dataset, I extracted the ~70K tickets issued in 2011
into a separate dataset and did a geocoder run on it last night:

http://opendata.socrata.com/Government/Alternate-Baltimore-Parking-Citations/erkh-icbb

A lot of their addresses are intersections, so there likely are some
that didn't geocode correctly, but this will give the people
interested in the Citation data something to play with until we can
get a Location column into the official dataset.

Thanks,
Chris

[Chris Metcalf]

I just helped a team set up a query against the Citations dataset so I
thought I'd share it with the group.

Note that this is against the official, data.baltimorecity.gov
dataset, not the alternate copy:

{
"originalViewId" : "n4ma-fj3m",
"name" : "Inline Filter",
"query" : {
"filterCondition" : {
"type" : "operator",
"value" : "OR",
"children" : [ {
"type" : "operator",
"value" : "CONTAINS",
"children" : [ {
"columnId" : 2629546,
"type" : "column"
}, {
"type" : "literal",
"value" : "1EBR38"
} ]
} ]
}
}
}

Post that to the inline filter URL and you'll get back only the
matching rows:

curl --data @tag.json -X POST --header "Content-type: application/
json" "http://data.baltimorecity.gov/api/views/INLINE/rows.json?
method=index"

Make sure you include your app token too.

If you want to perform the same thing against the alt version, change
the original view ID to "erkh-icbb", the column ID to "2648918", and
the domain name to "opendata.socrata.com".

- Chris

On Feb 12, 11:29 am, Chris Metcalf <chrismetc...@gmail.com> wrote:
> Since we don't have lat/lons yet for all the 1.5M parking tickets in
> the Citations dataset, I extracted the ~70K tickets issued in 2011
> into a separate dataset and did a geocoder run on it last night:
>

> http://opendata.socrata.com/Government/Alternate-Baltimore-Parking-Ci...