service_requests

Service requests from Arlington VA residents

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

3 rows where name = "Graffiti on Park Building/Trail/Park Grounds" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 3 ✖

name 1

  • Graffiti on Park Building/Trail/Park Grounds · 3 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
93695 93695 167060 Graffiti on Park Building/Trail/Park Grounds   open -77.10062326 38.84983898 4180 S Four Mile Run Dr, Arlington VA 2024-06-15 19:55:00 2024-06-16 20:31:38.850000000 public QScend
113289 113289 171271 Graffiti on Park Building/Trail/Park Grounds   open -77.10749250 38.87810130 538 N Pollard St, Arlington VA 2024-07-22 10:25:00 2024-07-23 20:32:20.777000000 public QScend
122121 122121 184491 Graffiti on Park Building/Trail/Park Grounds   open -77.04417270 38.87436250 Exit 10C, Washington VA 2024-11-16 14:12:00 2024-11-17 19:33:18.873000000 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]);