service_requests
Data source: Arlington County Open Data Portal · About: DES - Environmental Services
1,306 rows where status = "in progress"
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
name >30
- Downed/Loose wires 763
- Double utility poles 182
- Transportation/Safety Investigation 132
- Concrete/Sidewalk Repair 42
- General Inquiry 22
- Street Surface Damage 17
- Illegal Dumping & Litter 15
- Public Art 13
- Pothole 11
- Storm Drain Blocked, Damaged, Overflowing 10
- Signal Analysis 9
- Flooding or Water Ponding in Street 8
- Utility Cover Damaged/Missing 8
- Blocked Sidewalk, Street, or Bike Lane 7
- Traffic Sign Damaged/Missing 7
- Cart Services 6
- Parking Sign Damaged/Missing 6
- Recent Construction Drainage Changes 6
- Missed Service - Missed Collection 5
- Damaged rack or parking corral 4
- General Park Maintenance 4
- Sinkholes 4
- Streetlight Issue 4
- Bus Shelter Service 2
- Litter in Park/Trail 2
- Metal, E-Waste, & Battery Collection 2
- Suggest a Parking Corral 2
- Tree Inspection/Maintenance 2
- Commercial 1
- Flooding, Runoff or Ponding in Yard 1
- …
status 1
- in progress · 1,306 ✖
| Link | rowid ▼ | service_request_id | name | description | status | longitude | latitude | address | created_at | updated_at | permission | source_system |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17758 | 17758 | 39482 | Litter in Park/Trail | in progress | -77.11091154 | 38.88235779 | 4215 N Fairfax Dr, Arlington VA | 2021-09-12 18:28:00 | 2021-10-02 18:00:58.820000000 | public | QScend | |
| 23237 | 23237 | 48229 | Double utility poles | in progress | -77.09174401 | 38.87939502 | 415 N FILLMORE ST, Arlington VA | 2021-11-19 19:47:00 | 2022-01-18 16:00:56.763000000 | public | QScend | |
| 25098 | 25098 | 48147 | Downed/Loose wires | in progress | -77.11034496 | 38.90445401 | 4124 25th Pl N, Arlington VA | 2021-11-19 10:02:00 | 2022-01-19 18:00:48.347000000 | public | QScend | |
| 25948 | 25948 | 53987 | Downed/Loose wires | in progress | -77.13970400 | 38.88841499 | 5721 18th Rd N, Arlington VA | 2022-01-12 15:24:00 | 2022-01-18 18:00:48.493000000 | public | QScend | |
| 25950 | 25950 | 53820 | Downed/Loose wires | in progress | .00000000 | .00000000 | 2022-01-12 09:17:00 | 2022-01-18 18:00:48.493000000 | public | QScend | ||
| 25976 | 25976 | 53949 | Downed/Loose wires | in progress | -77.06395297 | 38.84601002 | 2819 S JOYCE ST, Arlington VA | 2022-01-12 14:17:00 | 2022-01-18 18:00:48.493000000 | public | QScend | |
| 26655 | 26655 | 54687 | Downed/Loose wires | in progress | -77.08047798 | 38.86944402 | 2025 6TH ST S, Arlington VA | 2022-01-17 14:09:00 | 2022-01-26 18:00:27.067000000 | public | QScend | |
| 27020 | 27020 | 53399 | Downed/Loose wires | in progress | .00000000 | .00000000 | 2022-01-10 14:08:00 | 2022-01-18 18:00:48.493000000 | public | QScend | ||
| 27048 | 27048 | 55372 | Downed/Loose wires | in progress | -77.13914880 | 38.88578560 | 1606 N LEXINGTON ST, Arlington VA | 2022-01-22 11:35:00 | 2022-02-02 14:00:23.887000000 | public | QScend | |
| 27054 | 27054 | 55492 | Downed/Loose wires | in progress | -77.09615800 | 38.89203702 | 1708 N Harvard St, Arlington VA | 2022-01-24 08:54:00 | 2022-02-02 14:00:23.887000000 | public | QScend | |
| 27056 | 27056 | 55542 | Double utility poles | in progress | -77.11037799 | 38.86686499 | 4441 1st St S, Arlington VA | 2022-01-24 12:12:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 27990 | 27990 | 50940 | Downed/Loose wires | in progress | -77.09761998 | 38.88820599 | 1309 N HUDSON ST, Arlington VA | 2021-12-14 15:39:00 | 2021-12-25 16:00:26.903000000 | public | QScend | |
| 28036 | 28036 | 57360 | Downed/Loose wires | in progress | -77.12434668 | 38.89675483 | 4783 21st Rd N, Arlington VA | 2022-02-10 10:33:00 | 2022-03-01 18:00:29.980000000 | public | QScend | |
| 28109 | 28109 | 57374 | Downed/Loose wires | in progress | -77.10931919 | 38.89844123 | 2152 Military Rd, Arlington VA | 2022-02-10 12:28:00 | 2022-07-12 14:00:34.810000000 | public | QScend | |
| 28328 | 28328 | 53238 | Downed/Loose wires | in progress | -77.06351602 | 38.84714799 | 2701 S JOYCE ST, Arlington VA | 2022-01-08 00:12:00 | 2022-01-18 16:00:56.763000000 | public | QScend | |
| 28374 | 28374 | 53563 | Downed/Loose wires | in progress | -77.11772717 | 38.90224184 | 2375 N UTAH ST, Arlington VA | 2022-01-11 12:04:00 | 2022-01-18 18:00:48.493000000 | public | QScend | |
| 28507 | 28507 | 57814 | Downed/Loose wires | in progress | -77.15702171 | 38.89815730 | N Sycamore St, Arlington VA | 2022-02-15 12:57:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 28604 | 28604 | 58760 | Downed/Loose wires | in progress | -77.08979002 | 38.89536300 | 2505 Langston Blvd, Arlington VA | 2022-02-23 15:22:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 28642 | 28642 | 58214 | Downed/Loose wires | in progress | -77.09004701 | 38.88565102 | 1028 N DANVILLE ST, Arlington VA | 2022-02-18 12:46:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 29064 | 29064 | 49179 | Double utility poles | in progress | -77.12516199 | 38.86325801 | 5623 4th St S, Arlington VA | 2021-11-30 10:37:00 | 2022-01-18 16:00:56.763000000 | public | QScend | |
| 29215 | 29215 | 52996 | Double utility poles | in progress | -77.12653997 | 38.87661398 | 5408 Wilson Blvd, Arlington VA | 2022-01-05 18:28:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 29302 | 29302 | 50079 | Downed/Loose wires | in progress | -77.08976001 | 38.86693201 | 619 S Highland St, Arlington VA | 2021-12-07 08:18:00 | 2022-01-18 16:00:56.763000000 | public | QScend | |
| 29433 | 29433 | 53825 | Downed/Loose wires | in progress | -77.06609597 | 38.85287899 | 1111 23rd Rd S, Arlington VA | 2022-01-12 09:29:00 | 2022-01-18 18:00:48.493000000 | public | QScend | |
| 29552 | 29552 | 54334 | Downed/Loose wires | in progress | -77.05979079 | 38.85245243 | 807 24th St S, Arlington VA | 2022-01-14 08:42:00 | 2022-01-19 20:00:56.453000000 | public | QScend | |
| 29567 | 29567 | 54600 | Downed/Loose wires | in progress | -77.10851603 | 38.87866001 | 675 N Randolph St, Arlington VA | 2022-01-16 04:59:00 | 2022-01-26 18:00:27.067000000 | public | QScend | |
| 29617 | 29617 | 54542 | Downed/Loose wires | in progress | -77.10647101 | 38.89364702 | 1814 N OAKLAND ST, Arlington VA | 2022-01-15 10:27:00 | 2022-01-26 18:00:27.067000000 | public | QScend | |
| 29738 | 29738 | 51041 | Downed/Loose wires | in progress | -77.15702045 | 38.89812411 | 2815 N Sycamore St, Arlington VA | 2021-12-15 14:19:00 | 2022-02-20 16:00:23.403000000 | public | QScend | |
| 29859 | 29859 | 58344 | Double utility poles | in progress | -77.13521267 | 38.91292392 | 4707 LITTLE FALLS RD, Arlington VA | 2022-02-20 15:50:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 30275 | 30275 | 51880 | Downed/Loose wires | in progress | -77.08562698 | 38.84486799 | 2607 S Kenmore Ct, Arlington VA | 2021-12-26 09:26:00 | 2022-01-18 16:00:56.763000000 | public | QScend | |
| 30399 | 30399 | 57987 | Downed/Loose wires | in progress | -77.10851603 | 38.87866001 | 675 N Randolph St, Arlington VA | 2022-02-16 23:15:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 30633 | 30633 | 58526 | Downed/Loose wires | in progress | -77.10304801 | 38.89279399 | 3412 18TH ST N, Arlington VA | 2022-02-22 11:47:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 30982 | 30982 | 59231 | Double utility poles | in progress | .00000000 | .00000000 | 2022-02-28 15:23:00 | 2022-03-12 18:00:29.630000000 | public | QScend | ||
| 31020 | 31020 | 55316 | Downed/Loose wires | in progress | -77.05885206 | 38.84967006 | 2615 S Hayes St, Arlington VA | 2022-01-21 13:50:00 | 2022-01-26 18:00:27.067000000 | public | QScend | |
| 31023 | 31023 | 55456 | Double utility poles | in progress | -77.15952890 | 38.89914750 | 6554 Williamsburg Blvd, Arlington VA | 2022-01-23 18:46:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 31456 | 31456 | 53925 | Downed/Loose wires | in progress | -77.09580919 | 38.89229481 | 1718 N Harvard St, Arlington VA | 2022-01-12 13:07:00 | 2022-01-18 18:00:48.493000000 | public | QScend | |
| 31615 | 31615 | 60239 | Downed/Loose wires | in progress | -77.14187683 | 38.87697500 | 948 Patrick Henry Dr, Arlington VA | 2022-03-08 15:35:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 31778 | 31778 | 54592 | Downed/Loose wires | in progress | -77.11754300 | 38.90364700 | 4442 Vacation Ln, Arlington VA | 2022-01-15 18:00:00 | 2022-01-26 18:00:27.067000000 | public | QScend | |
| 31824 | 31824 | 54883 | Downed/Loose wires | in progress | -77.11844810 | 38.87908643 | 4709 Wilson Blvd, Arlington VA | 2022-01-18 14:00:00 | 2022-01-26 18:00:27.067000000 | public | QScend | |
| 31877 | 31877 | 58629 | Double utility poles | in progress | -77.05425100 | 38.85890700 | 1600 S Eads St, Arlington VA | 2022-02-22 22:33:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 31880 | 31880 | 58630 | Downed/Loose wires | in progress | -77.10851603 | 38.87866001 | 675 N Randolph St, Arlington VA | 2022-02-23 03:06:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 31888 | 31888 | 58804 | Downed/Loose wires | in progress | -77.12312803 | 38.85682900 | 5601 8th St S, Arlington VA | 2022-02-24 08:23:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 32055 | 32055 | 60779 | Double utility poles | in progress | -77.15418802 | 38.89119502 | 2325 N Roosevelt St, Arlington VA | 2022-03-14 10:58:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 32149 | 32149 | 61290 | Downed/Loose wires | in progress | -77.09240702 | 38.87805601 | 307 N GARFIELD ST, Arlington VA | 2022-03-17 08:53:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 32254 | 32254 | 59863 | Downed/Loose wires | in progress | -77.07694098 | 38.89299398 | 1600 Clarendon Blvd, Arlington VA | 2022-03-06 14:01:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 32438 | 32438 | 53161 | Downed/Loose wires | in progress | -77.09751000 | 38.89888801 | 2815 23RD RD N, Arlington VA | 2022-01-07 09:55:00 | 2022-01-18 16:00:56.763000000 | public | QScend | |
| 32446 | 32446 | 53358 | Downed/Loose wires | in progress | -77.12249475 | 38.86792780 | 5200 1ST ST N, Arlington VA | 2022-01-10 11:11:00 | 2022-01-19 20:00:56.453000000 | public | QScend | |
| 32526 | 32526 | 61850 | Downed/Loose wires | in progress | -77.10118941 | 38.89323247 | 1875 N Johnson St, Arlington VA | 2022-03-22 09:54:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 32586 | 32586 | 62979 | Double utility poles | in progress | -77.12530004 | 38.89655801 | 2176 N BRANDYWINE ST, Arlington VA | 2022-03-31 13:01:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 32627 | 32627 | 62717 | Downed/Loose wires | in progress | -77.08189351 | 38.89282385 | 1711 N TROY ST, Arlington VA | 2022-03-29 14:23:00 | 2022-04-18 18:00:23.680000000 | public | QScend | |
| 32641 | 32641 | 62809 | Downed/Loose wires | in progress | -77.09962300 | 38.86243302 | 3924 8th St S, Arlington VA | 2022-03-30 11:29:00 | 2022-04-18 18:00:23.680000000 | public | QScend | |
| 32819 | 32819 | 56457 | Downed/Loose wires | in progress | -77.08976836 | 38.89006636 | 2601A Wilson Blvd, Arlington VA | 2022-02-01 16:00:00 | 2022-03-01 18:00:29.980000000 | public | QScend | |
| 33089 | 33089 | 54506 | Downed/Loose wires | in progress | -77.14991802 | 38.89007498 | 6204 22nd Rd N, Arlington VA | 2022-01-14 20:51:00 | 2022-01-26 18:00:27.067000000 | public | QScend | |
| 33134 | 33134 | 57343 | Double utility poles | in progress | -77.12492463 | 38.88689227 | N EDISON ST, Arlington VA | 2022-02-10 08:19:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 33601 | 33601 | 57420 | Downed/Loose wires | in progress | -77.14919902 | 38.89749800 | 6026 27TH ST N, Arlington VA | 2022-02-10 16:04:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 33644 | 33644 | 58610 | Downed/Loose wires | in progress | -77.10774997 | 38.84699619 | 2109 S Columbus St, Arlington VA | 2022-02-22 16:26:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 33792 | 33792 | 65637 | Double utility poles | in progress | -77.13242872 | 38.90129724 | 4937 26TH ST N, Arlington VA | 2022-04-23 19:49:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 33864 | 33864 | 60910 | Downed/Loose wires | in progress | -77.11065400 | 38.86409201 | 4614 3rd St S, Arlington VA | 2022-03-15 07:12:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 33970 | 33970 | 61237 | Downed/Loose wires | in progress | -77.12475768 | 38.89704277 | 4770 Langston Blvd, Arlington VA | 2022-03-16 16:11:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 34033 | 34033 | 58285 | Downed/Loose wires | in progress | -77.12312803 | 38.85682900 | 5601 8th St S, Arlington VA | 2022-02-18 17:59:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 34066 | 34066 | 58932 | Downed/Loose wires | in progress | -77.09679684 | 38.85742845 | 3905 13th St S, Arlington VA | 2022-02-25 09:27:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 34106 | 34106 | 59060 | Downed/Loose wires | in progress | -77.09696803 | 38.86497802 | 3703 7th St S, Arlington VA | 2022-02-26 16:18:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 34382 | 34382 | 62069 | Downed/Loose wires | in progress | -77.08809000 | 38.86942700 | 409 S Fillmore St, Arlington VA | 2022-03-23 15:56:00 | 2022-04-18 16:00:24.700000000 | public | QScend | |
| 34485 | 34485 | 62444 | Double utility poles | in progress | -77.12737799 | 38.87372202 | 616 N JEFFERSON ST, Arlington VA | 2022-03-28 06:53:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 34563 | 34563 | 59604 | Downed/Loose wires | in progress | -77.14628497 | 38.88103799 | 6100 11th Rd N, Arlington VA | 2022-03-03 13:11:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 34567 | 34567 | 59819 | Downed/Loose wires | in progress | -77.09352097 | 38.87365999 | 3125 1st Pl N, Arlington VA | 2022-03-05 16:59:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 34588 | 34588 | 59813 | Downed/Loose wires | in progress | -77.10364003 | 38.87824099 | 543 N OAKLAND ST, Arlington VA | 2022-03-05 14:15:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 34598 | 34598 | 59842 | Downed/Loose wires | in progress | -77.08842160 | 38.84566720 | 3612 Kemper Rd, Arlington VA | 2022-03-06 09:57:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 34641 | 34641 | 60358 | Double utility poles | in progress | -77.15451198 | 38.89961300 | 6300 31st St N, Arlington VA | 2022-03-09 16:08:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 34645 | 34645 | 60414 | Downed/Loose wires | in progress | -77.12083386 | 38.90048687 | 2310 N WAKEFIELD ST, Arlington VA | 2022-03-10 08:43:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 34667 | 34667 | 65252 | Downed/Loose wires | in progress | -77.10010404 | 38.90582701 | 3717 27TH ST N, Arlington VA | 2022-04-20 16:53:00 | 2022-05-31 14:00:31.350000000 | public | QScend | |
| 34726 | 34726 | 66864 | Downed/Loose wires | in progress | -77.10088079 | 38.88125399 | 802 N LINCOLN ST, Arlington VA | 2022-05-03 15:14:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 34770 | 34770 | 67356 | Downed/Loose wires | in progress | -77.08865201 | 38.87212501 | 2724 1st St S, Arlington VA | 2022-05-07 07:52:00 | 2022-05-18 18:00:34.097000000 | public | QScend | |
| 34850 | 34850 | 67602 | Downed/Loose wires | in progress | -77.06177804 | 38.85343601 | 907 23RD ST S, Arlington VA | 2022-05-09 19:49:00 | 2022-05-18 18:00:34.097000000 | public | QScend | |
| 34992 | 34992 | 63106 | Downed/Loose wires | in progress | -77.10851603 | 38.87866001 | 675 N Randolph St, Arlington VA | 2022-04-01 11:02:00 | 2022-04-18 18:00:23.680000000 | public | QScend | |
| 35012 | 35012 | 63374 | Downed/Loose wires | in progress | -77.13877776 | 38.89588484 | 2474 N ILLINOIS ST, Arlington VA | 2022-04-04 14:59:00 | 2022-04-18 18:00:23.680000000 | public | QScend | |
| 35100 | 35100 | 65576 | Downed/Loose wires | in progress | -77.07342100 | 38.84616701 | 2010 27th St S, Arlington VA | 2022-04-23 09:03:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 35128 | 35128 | 60242 | Downed/Loose wires | in progress | -77.14452037 | 38.87772318 | 1000 N Manchester St, Arlington VA | 2022-03-08 15:39:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 35412 | 35412 | 61419 | Downed/Loose wires | in progress | -77.09029784 | 38.89517115 | 2505 Langston Blvd, Arlington VA | 2022-03-18 09:18:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 35443 | 35443 | 59004 | Downed/Loose wires | in progress | -77.06401000 | 38.84926000 | 1020 S Oakcrest Rd, Arlington VA | 2022-02-25 15:21:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 35817 | 35817 | 61418 | Downed/Loose wires | in progress | -77.08835797 | 38.88632002 | 2501 11th St N, Arlington VA | 2022-03-18 09:12:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 35837 | 35837 | 61328 | Downed/Loose wires | in progress | -77.13472498 | 38.86826498 | 5932 3rd St N, Arlington VA | 2022-03-17 12:10:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 36145 | 36145 | 67355 | Double utility poles | in progress | -77.08865201 | 38.87212501 | 2724 1st St S, Arlington VA | 2022-05-07 07:45:00 | 2022-05-18 18:00:34.097000000 | public | QScend | |
| 36445 | 36445 | 63194 | Downed/Loose wires | in progress | -77.12703199 | 38.87308101 | 518 N JEFFERSON ST, Arlington VA | 2022-04-02 12:32:00 | 2022-05-08 22:00:27.867000000 | public | QScend | |
| 36475 | 36475 | 63745 | Downed/Loose wires | in progress | -77.11486893 | 38.87587814 | 4600 N Carlin Springs Rd, Arlington VA | 2022-04-06 22:50:00 | 2022-04-18 18:00:23.680000000 | public | QScend | |
| 36760 | 36760 | 66137 | Downed/Loose wires | in progress | -77.11483305 | 38.87592908 | 494 N WAKEFIELD ST, Arlington VA | 2022-04-27 14:39:00 | 2022-05-11 18:00:25.927000000 | public | QScend | |
| 36867 | 36867 | 67352 | Downed/Loose wires | in progress | -77.12011499 | 38.88486400 | 1122 N Aberdeen St, Arlington VA | 2022-05-07 00:16:00 | 2022-05-18 18:00:34.097000000 | public | QScend | |
| 36938 | 36938 | 67448 | Downed/Loose wires | in progress | -77.12770047 | 38.87658045 | 5513 Wilson Blvd, Arlington VA | 2022-05-08 22:12:00 | 2022-05-18 18:00:34.097000000 | public | QScend | |
| 37016 | 37016 | 68173 | Downed/Loose wires | in progress | -77.07442474 | 38.84993311 | 1718 28th St S, Arlington VA | 2022-05-13 09:46:00 | 2022-05-18 18:00:34.097000000 | public | QScend | |
| 37044 | 37044 | 68479 | Downed/Loose wires | in progress | -77.12252102 | 38.87406899 | 518 N FLORIDA ST, Arlington VA | 2022-05-16 12:27:00 | 2022-05-25 18:00:32.283000000 | public | QScend | |
| 37246 | 37246 | 68815 | Double utility poles | in progress | -77.06093004 | 38.85615300 | 828 19th St S, Arlington VA | 2022-05-17 19:37:00 | 2022-06-22 14:00:31.243000000 | public | QScend | |
| 37479 | 37479 | 68345 | Downed/Loose wires | in progress | -77.13021401 | 38.88012399 | 5517 FAIRFAX DR, Arlington VA | 2022-05-15 12:33:00 | 2022-05-25 18:00:32.283000000 | public | QScend | |
| 37596 | 37596 | 62093 | Downed/Loose wires | in progress | -77.08864322 | 38.88595756 | 2510 11th St N, Arlington VA | 2022-03-23 17:56:00 | 2022-04-18 16:00:24.700000000 | public | QScend | |
| 37689 | 37689 | 61955 | Downed/Loose wires | in progress | -77.11348901 | 38.88764700 | 1308 N Taylor St, Arlington VA | 2022-03-22 17:54:00 | 2022-03-28 18:00:23.260000000 | public | QScend | |
| 37994 | 37994 | 69557 | Downed/Loose wires | in progress | -77.14162597 | 38.90414799 | 5241 YORKTOWN BLVD, Arlington VA | 2022-05-23 08:46:00 | 2022-06-05 18:00:36.777000000 | public | QScend | |
| 38010 | 38010 | 69639 | Downed/Loose wires | in progress | -77.14184994 | 38.87692005 | 9th Rd N, Arlington VA | 2022-05-23 13:02:00 | 2022-06-05 18:00:36.777000000 | public | QScend | |
| 38022 | 38022 | 69393 | Downed/Loose wires | in progress | -77.12757899 | 38.87791498 | 872 N HARRISON ST, Arlington VA | 2022-05-20 20:39:00 | 2022-06-05 18:00:36.777000000 | public | QScend | |
| 38067 | 38067 | 69648 | Downed/Loose wires | in progress | -77.10099000 | 38.87183802 | 32 N OAKLAND ST, Arlington VA | 2022-05-23 13:37:00 | 2022-06-05 18:00:36.777000000 | public | QScend | |
| 38287 | 38287 | 73804 | Downed/Loose wires | in progress | -77.11450993 | 38.87990002 | Wilson Blvd, Arlington VA | 2022-06-13 12:58:00 | 2022-06-22 14:00:31.243000000 | public | QScend | |
| 38474 | 38474 | 62897 | Downed/Loose wires | in progress | -77.12507641 | 38.87251987 | N ILLINOIS ST, Arlington VA | 2022-03-30 19:27:00 | 2022-04-18 18:00:23.680000000 | public | QScend | |
| 38477 | 38477 | 62960 | Downed/Loose wires | in progress | -77.10851603 | 38.87866001 | 675 N Randolph St, Arlington VA | 2022-03-31 11:35:00 | 2022-04-18 18:00:23.680000000 | 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]);