service_requests
Data source: Arlington County Open Data Portal · About: DES - Environmental Services
9 rows where name = "Signal Analysis" and status = "in progress"
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
| Link | rowid ▼ | service_request_id | name | description | status | longitude | latitude | address | created_at | updated_at | permission | source_system |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145712 | 145712 | 235562 | Signal Analysis | in progress | -77.09380081 | 38.88513813 | WASHINGTON BLVD, Arlington VA | 2025-11-18 16:40:00 | 2025-12-19 07:00:09.883000000 | public | QScend | |
| 165812 | 165812 | 238898 | Signal Analysis | in progress | -77.10123702 | 38.85880399 | Columbia Pike, Arlington VA | 2025-12-15 07:55:00 | 2025-12-16 07:00:11.120000000 | public | QScend | |
| 167667 | 167667 | 127586 | Signal Analysis | in progress | -77.09280158 | 38.89862978 | Spout Run Pkwy, Arlington VA | 2023-08-15 19:10:00 | 2023-08-26 18:01:00.513000000 | public | QScend | |
| 170583 | 170583 | 198873 | Signal Analysis | in progress | -77.09686693 | 38.88445011 | 3201 10TH ST N, Arlington VA | 2025-03-21 23:37:00 | 2025-03-26 18:06:53.963000000 | public | QScend | |
| 171759 | 171759 | 230024 | Signal Analysis | in progress | -77.08542927 | 38.86859192 | 602 S Barton St, Arlington VA | 2025-10-07 10:57:00 | 2025-10-24 07:00:10.737000000 | public | QScend | |
| 172148 | 172148 | 206251 | Signal Analysis | in progress | -77.12673019 | 38.88515770 | N GEORGE MASON DR, Arlington VA | 2025-05-23 11:02:00 | 2025-06-13 06:08:56.060000000 | public | QScend | |
| 172846 | 172846 | 235566 | Signal Analysis | in progress | -77.05194479 | 38.86294815 | 12th St S, Arlington VA | 2025-11-18 17:01:00 | 2025-12-05 07:00:10.480000000 | public | QScend | |
| 173651 | 173651 | 221085 | Signal Analysis | in progress | -77.05550332 | 38.85629851 | 1859 S Fern St, Arlington VA | 2025-08-15 19:47:00 | 2025-09-20 07:00:10.943000000 | public | QScend | |
| 174850 | 174850 | 201287 | Signal Analysis | in progress | -77.13249397 | 38.88102198 | 5600 11th St N, Arlington VA | 2025-04-12 16:53:00 | 2025-04-17 06:07:57.577000000 | public | QScend |
Advanced export
JSON shape: default, array, newline-delimited
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]);