service_requests

Service requests from Arlington VA residents

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

13 rows where name = "Flooding or Water Ponding in Street" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 13 ✖

name 1

  • Flooding or Water Ponding in Street · 13 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
127739 127739 214912 Flooding or Water Ponding in Street   open -77.10528799 38.87313801 4211 2nd Rd N, Arlington VA 2025-07-27 09:20:00 2025-08-01 16:07:55.300000000 public QScend
142293 142293 240189 Flooding or Water Ponding in Street   open -77.13242242 38.87797409 5701 9th St N, Arlington VA 2025-12-26 11:23:00 2025-12-27 06:02:47.427000000 public QScend
147788 147788 240181 Flooding or Water Ponding in Street   open -77.10908132 38.87107303 4372 N Pershing Dr, Arlington VA 2025-12-26 09:22:00 2025-12-27 06:02:47.427000000 public QScend
149361 149361 240400 Flooding or Water Ponding in Street   open -77.12754429 38.91174698 3219 N WAKEFIELD ST, Arlington VA 2025-12-28 12:39:00 2025-12-29 03:00:07.520000000 public QScend
166607 166607 239646 Flooding or Water Ponding in Street   open -77.12700255 38.92159865 3817 N Tazewell St, Arlington VA 2025-12-20 09:21:00 2025-12-24 06:05:48.250000000 public QScend
168784 168784 124833 Flooding or Water Ponding in Street   open -77.09577680 38.88644982 3100 Clarendon Blvd, Arlington VA 2023-07-30 08:44:00 2024-05-29 20:31:49.707000000 public QScend
169149 169149 124662 Flooding or Water Ponding in Street   open -77.09859798 38.88215601 801 N Jackson St, Arlington VA 2023-07-29 17:14:00 2024-02-28 19:32:20.847000000 public QScend
174129 174129 237733 Flooding or Water Ponding in Street   open -77.08442818 38.88960086 2089 14th St N, Arlington VA 2025-12-04 13:05:00 2025-12-06 06:05:52.173000000 public QScend
174629 174629 173020 Flooding or Water Ponding in Street   open -77.11172898 38.85951901 4835 8th St S, Arlington VA 2024-08-05 15:26:00 2025-03-22 06:05:59.853000000 public QScend
174811 174811 182869 Flooding or Water Ponding in Street   open -77.09571703 38.87713802 3200 4th St N, Arlington VA 2024-10-31 10:57:00 2024-11-05 19:38:43.600000000 public QScend
175848 175848 149767 Flooding or Water Ponding in Street   open -77.07755504 38.89718099 Arlington VA 2024-02-01 11:46:00 2024-02-10 19:31:33.803000000 public QScend
177768 177768 205290 Flooding or Water Ponding in Street   open -77.08668802 38.89709124 2201 20th St N, Arlington VA 2025-05-15 15:19:00 2025-05-16 21:06:49.313000000 public QScend
178666 178666 239489 Flooding or Water Ponding in Street   open -77.10547659 38.88661370 1173 N Nelson St, Arlington VA 2025-12-18 18:19:00 2025-12-24 06:05:48.250000000 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]);