service_requests

Service requests from Arlington VA residents

Data source: Arlington County Open Data Portal · About: DES - Environmental Services

8 rows where name = "Pollution in Streams or into Storm Drains" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

status 1

  • open · 8 ✖

name 1

  • Pollution in Streams or into Storm Drains · 8 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
117720 117720 196465 Pollution in Streams or into Storm Drains   open -77.12231113 38.89848467 4709 Langston Blvd, Arlington VA 2025-03-01 09:33:00 2025-03-12 12:42:11.673000000 public QScend
128614 128614 212823 Pollution in Streams or into Storm Drains   open -77.10712799 38.85604500 4603 S Four Mile Run Dr, Arlington VA 2025-07-11 09:43:00 2025-07-29 06:10:15.480000000 public QScend
130415 130415 219483 Pollution in Streams or into Storm Drains   open -77.12534480 38.91994796 3746 N Tazewell St, Arlington VA 2025-08-09 21:32:00 2025-08-13 06:14:59.370000000 public QScend
132948 132948 217140 Pollution in Streams or into Storm Drains   open -77.08792756 38.89571601 1849 N Wayne St, Arlington VA 2025-08-05 21:28:00 2025-08-07 18:25:07.840000000 public QScend
139549 139549 218391 Pollution in Streams or into Storm Drains   open -77.05813457 38.84253314 Four Mile Run Trl, Arlington VA 2025-08-07 18:19:00 2025-08-08 21:23:04.747000000 public QScend
141725 141725 219873 Pollution in Streams or into Storm Drains   open -77.10600529 38.85247672 1666 S George Mason Dr, Arlington VA 2025-08-11 19:37:00 2025-08-12 21:14:59.807000000 public QScend
162110 162110 212503 Pollution in Streams or into Storm Drains   open -77.10527499 38.87294055 4209 2nd Rd N, Arlington VA 2025-07-09 12:03:00 2025-07-10 16:09:58.617000000 public QScend
163924 163924 227965 Pollution in Streams or into Storm Drains   open -77.11582154 38.86715125 Arlington Blvd, Arlington VA 2025-09-23 14:35:00 2025-09-25 06:07:49.007000000 public QScend

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [service_requests] (
   [service_request_id] TEXT,
   [name] TEXT,
   [description] TEXT,
   [status] TEXT,
   [longitude] TEXT,
   [latitude] TEXT,
   [address] TEXT,
   [created_at] TEXT,
   [updated_at] TEXT,
   [permission] TEXT,
   [source_system] TEXT
);
CREATE INDEX [idx_service_requests_name_status_created_at]
    ON [service_requests] ([name], [status], [created_at]);
CREATE INDEX [idx_service_requests_status]
    ON [service_requests] ([status]);
CREATE INDEX [idx_service_requests_name]
    ON [service_requests] ([name]);
CREATE INDEX [idx_service_requests_created_at]
    ON [service_requests] ([created_at]);