service_requests

Service requests from Arlington VA residents

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

7 rows where name = "Double utility poles" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 7 ✖

name 1

  • Double utility poles · 7 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
92335 92335 135139 Double utility poles   open -77.08459304 38.87407467 80 S Wise St, Arlington VA 2023-10-14 18:13:00 2023-10-18 12:57:58.517000000 public QScend
125994 125994 195557 Double utility poles   open -77.09331201 38.87945101 N Pershing Dr, Arlington VA 2025-02-21 13:55:00 2025-03-12 12:42:11.673000000 public QScend
132062 132062 207182 Double utility poles   open -77.11424097 38.86752261 4743 Arlington Blvd, Arlington VA 2025-06-01 13:12:00 2025-06-02 16:08:00.373000000 public QScend
138798 138798 225781 Double utility poles   open -77.09166321 38.89032904 2717 Franklin Rd, Arlington VA 2025-09-09 21:18:00 2025-09-10 11:00:12.877000000 public QScend
151089 151089 156310 Double utility poles   open -77.13798596 38.89053301 1911 N KENILWORTH ST, Arlington VA 2024-04-02 10:38:00 2024-05-29 20:31:49.707000000 public QScend
154226 154226 173577 Double utility poles   open -77.11006593 38.87142655 4424 4th St N, Arlington VA 2024-08-10 14:06:00 2024-08-11 20:31:59.750000000 public QScend
156766 156766 188110 Double utility poles   open -77.08123067 38.86333923 2200 Columbia Pike, Arlington VA 2024-12-22 11:38:00 2024-12-26 15:54:08.020000000 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]);