regex101: Extract Lat/Lon Baltimore Crime Data

location_1_coordinatesthe literal text location_1_coordinates (case sensitive)

\=the literal = (61₁₀ / 75₈ / 3D₁₆)

\"the literal " (34₁₀ / 42₈ / 22₁₆)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

Group longitude(?<longitude>[-\.\d]*)

Character Class[-\.\d]*

*matches any number of characters from the set below:

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

\da digit

\,the literal , (44₁₀ / 54₈ / 2C₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

Group latitude(?<latitude>[-\.\d]*)

Character Class[-\.\d]*

*matches any number of characters from the set below:

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

\da digit

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Search reference

Regular Expression

location_1_coordinates\=\"\[(?<longitude>[-\.\d]*)\, (?<latitude>[-\.\d]*)

New

01/28/2017 23:50:00 -0500, search_name="Update Baltimore Incidents", search_now=1486130400.000, info_max_time=1486130400.000, info_search_time=1486130401.183, crimecode=3AF, crimedate="2017-01-28T00:00:00.000", crimetime="23:50:00", ctime="2017-01-28T23:50:00", description="ROBBERY - STREET", district=WESTERN, inside_outside=O, location="2700 PENNSYLVANIA AVE", location_1="{u'coordinates': [-76.64548, 39.31253], u'type': u'Point'}", location_1_coordinates="[-76.64548, 39.31253]", location_1_type=Point, neighborhood="Penn North", post=733, premise=STREET, total_incidents=1, weapon=FIREARM