service_requests
Data source: Arlington County Open Data Portal · About: DES - Environmental Services
675 rows where name = "Signal Analysis" and status = "closed"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 873 | 873 | 10622 | Signal Analysis | closed | -77.07853223 | 38.89307499 | N Quinn St, Arlington VA | 2021-01-21 12:28:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 5108 | 5108 | 11433 | Signal Analysis | closed | -77.09969994 | 38.88494002 | N Fairfax Dr, Arlington VA | 2021-01-30 20:59:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 8064 | 8064 | 22183 | Signal Analysis | closed | -77.15753994 | 38.89454002 | N Sycamore St, Arlington VA | 2021-05-09 08:02:00 | 2021-07-18 08:01:11.180000000 | public | QScend | |
| 10643 | 10643 | 25721 | Signal Analysis | closed | -77.09966495 | 38.88482502 | N Kirkwood Rd, Arlington VA | 2021-06-04 15:43:00 | 2021-06-16 14:00:45.833000000 | public | QScend | |
| 12916 | 12916 | 25591 | Signal Analysis | closed | -77.08559991 | 38.84986004 | 22nd St S, Arlington VA | 2021-06-03 15:52:00 | 2021-06-08 18:00:46.347000000 | public | QScend | |
| 19223 | 19223 | 43228 | Signal Analysis | closed | -77.12817989 | 38.88766003 | 16th St N, Arlington VA | 2021-10-07 14:19:00 | 2021-10-13 12:00:53.430000000 | public | QScend | |
| 20662 | 20662 | 34293 | Signal Analysis | closed | -77.10823769 | 38.89692033 | Langston Blvd, Arlington VA | 2021-08-06 12:23:00 | 2021-08-11 16:00:53.570000000 | public | QScend | |
| 21618 | 21618 | 23959 | Signal Analysis | closed | -77.11315418 | 38.89691877 | 4295 Langston Blvd, Arlington VA | 2021-05-21 11:50:00 | 2021-05-29 12:01:03.600000000 | public | QScend | |
| 24380 | 24380 | 43074 | Signal Analysis | closed | -77.08569990 | 38.84298005 | S Shirlington Rd, Arlington VA | 2021-10-06 17:03:00 | 2021-10-16 12:01:25.120000000 | public | QScend | |
| 24672 | 24672 | 50641 | Signal Analysis | closed | .00000000 | .00000000 | 2021-12-12 16:27:00 | 2022-02-08 20:00:26.323000000 | public | QScend | ||
| 26833 | 26833 | 50718 | Signal Analysis | closed | -77.12360991 | 38.89762004 | Langston Blvd, Arlington VA | 2021-12-13 10:42:00 | 2021-12-20 14:00:23.563000000 | public | QScend | |
| 27299 | 27299 | 46333 | Signal Analysis | closed | -77.10072451 | 38.87009865 | 10 S Glebe Rd, Arlington VA | 2021-11-01 20:40:00 | 2022-02-08 20:00:26.323000000 | public | QScend | |
| 27708 | 27708 | 50384 | Signal Analysis | closed | -77.11663032 | 38.92935948 | 2021-12-09 13:54:00 | 2022-04-10 16:00:27.700000000 | public | QScend | ||
| 28159 | 28159 | 46844 | Signal Analysis | closed | -77.05245579 | 38.85328625 | Richmond Hwy, Arlington VA | 2021-11-05 21:20:00 | 2022-02-08 20:00:26.323000000 | public | QScend | |
| 28219 | 28219 | 47440 | Signal Analysis | closed | .00000000 | .00000000 | 2021-11-12 07:30:00 | 2021-11-17 14:00:27.083000000 | public | QScend | ||
| 28711 | 28711 | 47896 | Signal Analysis | closed | -77.08562935 | 38.82985179 | Fern St, Alexandria VA | 2021-11-16 20:06:00 | 2021-11-22 10:00:42.683000000 | public | QScend | |
| 34557 | 34557 | 59691 | Signal Analysis | closed | .00000000 | .00000000 | 2022-03-04 09:51:00 | 2022-03-12 14:00:32.027000000 | public | QScend | ||
| 35175 | 35175 | 60927 | Signal Analysis | closed | -77.07078640 | 38.89615180 | 1747 N Lynn St, Arlington VA | 2022-03-15 08:55:00 | 2022-03-21 12:00:44.147000000 | public | QScend | |
| 37204 | 37204 | 34952 | Signal Analysis | closed | .00000000 | .00000000 | 2021-08-11 16:27:00 | 2021-10-09 10:00:59.977000000 | public | QScend | ||
| 38097 | 38097 | 34465 | Signal Analysis | closed | -77.10575933 | 38.83995027 | 4495 King St, Alexandria VA | 2021-08-08 21:08:00 | 2021-08-14 14:01:08.630000000 | public | QScend | |
| 39254 | 39254 | 71539 | Signal Analysis | closed | -77.05585067 | 38.85964503 | 594 15th St S, Arlington VA | 2022-06-03 17:39:00 | 2022-10-04 12:01:51.587000000 | public | QScend | |
| 40882 | 40882 | 75213 | Signal Analysis | closed | -77.08858748 | 38.84190136 | 2768 S Arlington Mill Dr, Arlington VA | 2022-06-23 09:23:00 | 2022-06-28 12:01:55.617000000 | public | QScend | |
| 41784 | 41784 | 77089 | Signal Analysis | closed | -77.09300454 | 38.88789769 | 2800 Clarendon Blvd, Arlington VA | 2022-07-06 19:43:00 | 2022-07-23 18:00:37.930000000 | public | QScend | |
| 43231 | 43231 | 72084 | Signal Analysis | closed | -77.09049988 | 38.88079006 | WASHINGTON BLVD, Arlington VA | 2022-06-07 16:25:00 | 2022-06-12 20:00:38.457000000 | public | QScend | |
| 51667 | 51667 | 43205 | Signal Analysis | closed | -77.10420313 | 38.85800235 | 4307 Columbia Pike, Arlington VA | 2021-10-07 12:57:00 | 2021-10-13 10:00:57.537000000 | public | QScend | |
| 51876 | 51876 | 43772 | Signal Analysis | closed | -77.09683996 | 38.88600004 | WASHINGTON BLVD, Arlington VA | 2021-10-12 14:31:00 | 2022-02-08 20:00:26.323000000 | public | QScend | |
| 60015 | 60015 | 51288 | Signal Analysis | closed | -77.12366844 | 38.89711917 | 4746 Langston Blvd, Arlington VA | 2021-12-17 15:42:00 | 2021-12-28 14:00:22.067000000 | public | QScend | |
| 65574 | 65574 | 60745 | Signal Analysis | closed | -77.05148823 | 38.84858326 | 2799 Richmond Hwy, Arlington VA | 2022-03-14 08:05:00 | 2022-03-21 12:00:44.147000000 | public | QScend | |
| 66416 | 66416 | 61874 | Signal Analysis | closed | .00000000 | .00000000 | 2022-03-22 11:37:00 | 2022-03-29 16:00:24.967000000 | public | QScend | ||
| 76597 | 76597 | 128672 | Signal Analysis | closed | .00000000 | .00000000 | 2023-08-23 11:52:00 | 2024-08-21 20:33:08.243000000 | public | QScend | ||
| 83524 | 83524 | 77680 | Signal Analysis | closed | -77.08568434 | 38.84400947 | S Shirlington Rd, Arlington VA | 2022-07-11 12:05:00 | 2022-07-23 18:00:37.930000000 | public | QScend | |
| 84740 | 84740 | 138080 | Signal Analysis | closed | -77.04929202 | 38.86186401 | 1300 Crystal Dr, Arlington VA | 2023-11-01 16:23:00 | 2025-09-04 06:08:53.853000000 | public | QScend | |
| 98251 | 98251 | 159001 | Signal Analysis | closed | -77.06831770 | 38.85312783 | 1294 23RD ST S, Arlington VA | 2024-04-24 14:50:00 | 2024-08-21 20:33:08.243000000 | public | QScend | |
| 98635 | 98635 | 159845 | Signal Analysis | closed | -77.06872898 | 38.85264400 | 2310 S Arlington Ridge Rd, Arlington VA | 2024-05-01 10:25:00 | 2025-11-19 06:08:20.413000000 | public | QScend | |
| 98969 | 98969 | 161071 | Signal Analysis | closed | -77.12873781 | 38.90419190 | Old Dominion Dr, Arlington VA | 2024-05-10 23:42:00 | 2024-08-21 20:33:08.243000000 | public | QScend | |
| 108234 | 108234 | 184822 | Signal Analysis | closed | -77.15644903 | 38.89032598 | Langston Blvd, Arlington VA | 2024-11-19 13:30:00 | 2024-11-20 19:42:55.333000000 | public | QScend | |
| 110589 | 110589 | 188058 | Signal Analysis | closed | -77.05152102 | 38.84819501 | Potomac Ave, Arlington VA | 2024-12-20 18:51:00 | 2025-02-15 06:05:57.313000000 | public | QScend | |
| 112208 | 112208 | 169616 | Signal Analysis | closed | -77.09792801 | 38.86847639 | 3617 2nd St S, Arlington VA | 2024-07-08 10:21:00 | 2024-07-10 20:31:51.780000000 | public | QScend | |
| 115699 | 115699 | 190855 | Signal Analysis | closed | -77.13922799 | 38.91024800 | Old Dominion Dr, Arlington VA | 2025-01-10 07:06:00 | 2025-05-17 06:06:49.860000000 | public | QScend | |
| 118246 | 118246 | 197522 | Signal Analysis | closed | -77.09169070 | 38.85952689 | S Glebe Rd, Arlington VA | 2025-03-11 09:30:00 | 2025-06-24 16:09:00.327000000 | public | QScend | |
| 118692 | 118692 | 202868 | Signal Analysis | closed | .00000000 | .00000000 | 2025-04-26 13:45:00 | 2025-04-29 06:08:54.403000000 | public | QScend | ||
| 122211 | 122211 | 185235 | Signal Analysis | closed | -77.13789938 | 38.89636317 | 2374 N HARRISON ST, Arlington VA | 2024-11-22 15:46:00 | 2024-11-27 23:11:36.980000000 | public | QScend | |
| 123476 | 123476 | 185234 | Signal Analysis | closed | -77.13789938 | 38.89636317 | 2374 N HARRISON ST, Arlington VA | 2024-11-22 15:45:00 | 2024-11-27 23:11:36.980000000 | public | QScend | |
| 124118 | 124118 | 189013 | Signal Analysis | closed | -77.05223907 | 38.85610263 | 20th St S, Arlington VA | 2025-01-01 15:04:00 | 2025-05-17 06:06:49.860000000 | public | QScend | |
| 126288 | 126288 | 210956 | Signal Analysis | closed | -77.11578297 | 38.88212400 | N GLEBE RD, Arlington VA | 2025-06-27 18:25:00 | 2025-07-02 06:10:56.153000000 | public | QScend | |
| 126874 | 126874 | 212235 | Signal Analysis | closed | -77.06282804 | 38.86599101 | Army Navy Dr, Arlington VA | 2025-07-07 17:18:00 | 2025-07-09 06:06:55.950000000 | public | QScend | |
| 127291 | 127291 | 212688 | Signal Analysis | closed | -77.14097191 | 38.86632700 | Arlington Blvd, Arlington VA | 2025-07-10 14:00:00 | 2025-12-20 07:00:08.797000000 | public | QScend | |
| 129621 | 129621 | 202643 | Signal Analysis | closed | -77.10055102 | 38.85600459 | 4200 13th St S, Arlington VA | 2025-04-24 13:17:00 | 2025-05-17 06:06:49.860000000 | public | QScend | |
| 132043 | 132043 | 207010 | Signal Analysis | closed | -77.10043898 | 38.85618402 | 13th St S, Arlington VA | 2025-05-30 11:02:00 | 2025-05-31 06:06:55.953000000 | public | QScend | |
| 132290 | 132290 | 222736 | Signal Analysis | closed | -77.11765901 | 38.92913599 | Chain Bridge Rd, Mc Lean VA | 2025-08-25 12:30:00 | 2025-11-20 07:00:14.430000000 | public | QScend | |
| 137397 | 137397 | 231334 | Signal Analysis | closed | -77.07745697 | 38.84418700 | S Four Mile Run Dr, Arlington VA | 2025-10-16 21:08:00 | 2025-11-20 07:00:14.430000000 | public | QScend | |
| 147406 | 147406 | 233794 | Signal Analysis | closed | -77.06380313 | 38.86898487 | S JOYCE ST, Arlington VA | 2025-11-05 12:55:00 | 2025-11-21 06:06:50.907000000 | public | QScend | |
| 147937 | 147937 | 136177 | Signal Analysis | closed | -77.11396440 | 38.87383741 | N GEORGE MASON DR, Arlington VA | 2023-10-23 17:13:00 | 2024-08-21 20:33:08.243000000 | public | QScend | |
| 151407 | 151407 | 157694 | Signal Analysis | closed | -77.07074040 | 38.89898546 | 1976 N Lynn St, Arlington VA | 2024-04-14 11:06:00 | 2024-08-21 20:33:08.243000000 | public | QScend | |
| 152740 | 152740 | 165676 | Signal Analysis | closed | -77.15457437 | 38.89149390 | Langston Blvd, Arlington VA | 2024-06-07 06:03:00 | 2024-08-21 20:33:08.243000000 | public | QScend | |
| 154627 | 154627 | 175797 | Signal Analysis | closed | -77.11630802 | 38.89942802 | Lorcom Ln, Arlington VA | 2024-08-29 12:35:00 | 2025-05-17 06:06:49.860000000 | public | QScend | |
| 155323 | 155323 | 179571 | Signal Analysis | closed | .00000000 | .00000000 | 2024-10-01 19:21:00 | 2025-05-17 06:06:49.860000000 | public | QScend | ||
| 155508 | 155508 | 181050 | Signal Analysis | closed | -77.12093298 | 38.87824301 | Wilson Blvd, Arlington VA | 2024-10-14 13:03:00 | 2024-10-16 20:31:51.587000000 | public | QScend | |
| 155764 | 155764 | 182051 | Signal Analysis | closed | -77.11578297 | 38.88212400 | N Fairfax Dr, Arlington VA | 2024-10-23 15:20:00 | 2025-05-17 06:06:49.860000000 | public | QScend | |
| 156681 | 156681 | 179714 | Signal Analysis | closed | .00000000 | .00000000 | 2024-10-02 17:37:00 | 2025-05-17 06:06:49.860000000 | public | QScend | ||
| 156695 | 156695 | 187405 | Signal Analysis | closed | -77.10002531 | 38.88594899 | WASHINGTON BLVD, Arlington VA | 2024-12-15 15:30:00 | 2025-05-17 06:06:49.860000000 | public | QScend | |
| 159789 | 159789 | 206709 | Signal Analysis | closed | -77.08521690 | 38.89314700 | 2107 Wilson Blvd, Arlington VA | 2025-05-28 10:16:00 | 2025-05-29 16:07:58.857000000 | public | QScend | |
| 162467 | 162467 | 214453 | Signal Analysis | closed | .00000000 | .00000000 | 2025-07-23 11:16:00 | 2025-07-29 06:10:15.480000000 | public | QScend | ||
| 165271 | 165271 | 236029 | Signal Analysis | closed | -77.05114048 | 38.85620200 | S Bell St, Arlington VA | 2025-11-21 15:12:00 | 2025-12-20 06:06:49.477000000 | public | QScend | |
| 166412 | 166412 | 111595 | Signal Analysis | closed | -77.12095997 | 38.87823001 | N GEORGE MASON DR, Arlington VA | 2023-04-30 14:47:00 | 2023-05-07 14:01:15.510000000 | public | QScend | |
| 166481 | 166481 | 87122 | Signal Analysis | closed | -77.05288995 | 38.84538004 | 33rd St, Arlington VA | 2022-09-16 13:15:00 | 2022-09-27 18:00:47.887000000 | public | QScend | |
| 166559 | 166559 | 23074 | Signal Analysis | closed | -77.10318231 | 38.85278091 | S George Mason Dr, Arlington VA | 2021-05-14 16:36:00 | 2023-01-30 14:00:26.727000000 | public | QScend | |
| 166610 | 166610 | 238044 | Signal Analysis | closed | -77.07425532 | 38.86597249 | Columbia Pike, Arlington VA | 2025-12-08 09:14:00 | 2025-12-10 06:05:49.430000000 | public | QScend | |
| 166645 | 166645 | 88255 | Signal Analysis | closed | -77.11655897 | 38.88247398 | 1000 N GLEBE RD, Arlington VA | 2022-09-23 17:55:00 | 2022-10-04 12:01:51.587000000 | public | QScend | |
| 166649 | 166649 | 188112 | Signal Analysis | closed | -77.05029715 | 38.84270196 | 3692 S Glebe Rd, Arlington VA | 2024-12-22 12:57:00 | 2024-12-27 19:41:23.750000000 | public | QScend | |
| 166650 | 166650 | 211962 | Signal Analysis | closed | -77.06345961 | 38.86199940 | S JOYCE ST, Arlington VA | 2025-07-06 10:56:00 | 2025-07-08 06:10:57.910000000 | public | QScend | |
| 166659 | 166659 | 187233 | Signal Analysis | closed | -77.09986825 | 38.88445395 | 3300 FAIRFAX DR, Arlington VA | 2024-12-13 11:27:00 | 2024-12-17 19:41:35.483000000 | public | QScend | |
| 166670 | 166670 | 141259 | Signal Analysis | closed | -77.05271996 | 38.84250999 | S Glebe Rd, Arlington VA | 2023-11-30 09:48:00 | 2023-12-02 19:32:20.883000000 | public | QScend | |
| 166692 | 166692 | 166027 | Signal Analysis | closed | -77.05617092 | 38.85965130 | 15th St S, Arlington VA | 2024-06-07 09:04:00 | 2024-07-10 20:31:51.780000000 | public | QScend | |
| 166731 | 166731 | 18516 | Signal Analysis | closed | -77.05954702 | 38.84501798 | 3101 S High St, Arlington VA | 2021-04-09 20:47:00 | 2021-04-17 12:00:57.050000000 | public | QScend | |
| 166752 | 166752 | 113897 | Signal Analysis | closed | -77.06013121 | 38.86052435 | 816 15th St S, Arlington VA | 2023-05-16 21:40:00 | 2023-06-04 18:01:23.583000000 | public | QScend | |
| 166759 | 166759 | 138868 | Signal Analysis | closed | -77.11287089 | 38.86773986 | N Henderson Rd, Arlington VA | 2023-11-08 11:17:00 | 2023-11-14 19:32:42.553000000 | public | QScend | |
| 166760 | 166760 | 191725 | Signal Analysis | closed | -77.05356067 | 38.86003772 | 1425 S Eads St, Arlington VA | 2025-01-16 11:37:00 | 2025-03-25 06:09:01.033000000 | public | QScend | |
| 166772 | 166772 | 133356 | Signal Analysis | closed | -77.11393559 | 38.88004207 | Wilson Blvd, Arlington VA | 2023-09-29 15:10:00 | 2025-02-14 06:04:54.583000000 | public | QScend | |
| 166790 | 166790 | 41579 | Signal Analysis | closed | -77.08648990 | 38.89604005 | Langston Blvd, Arlington VA | 2021-09-26 07:58:00 | 2021-10-02 12:01:28.067000000 | public | QScend | |
| 166836 | 166836 | 81528 | Signal Analysis | closed | -77.05180994 | 38.85982004 | Jefferson Davis Hwy, Arlington VA | 2022-08-08 12:31:00 | 2022-08-15 12:00:45.980000000 | public | QScend | |
| 166855 | 166855 | 232573 | Signal Analysis | closed | -77.06937548 | 38.89477409 | Wilson Blvd, Arlington VA | 2025-10-27 13:33:00 | 2025-10-28 03:00:11.650000000 | public | QScend | |
| 166862 | 166862 | 229185 | Signal Analysis | closed | -77.09307673 | 38.88452570 | WASHINGTON BLVD, Arlington VA | 2025-10-01 11:38:00 | 2025-11-13 06:06:48.993000000 | public | QScend | |
| 166872 | 166872 | 90254 | Signal Analysis | closed | -77.10857619 | 38.85666292 | 4697 S Four Mile Run Dr, Arlington VA | 2022-10-07 19:46:00 | 2022-10-15 12:01:23.803000000 | public | QScend | |
| 166902 | 166902 | 22104 | Signal Analysis | closed | -77.08615329 | 38.89365494 | N Veitch St, Arlington VA | 2021-05-07 14:41:00 | 2021-05-29 14:00:55.780000000 | public | QScend | |
| 166904 | 166904 | 205571 | Signal Analysis | closed | -77.07437257 | 38.86571367 | 1710 Columbia Pike, Arlington VA | 2025-05-18 14:45:00 | 2025-05-20 06:08:51.890000000 | public | QScend | |
| 166934 | 166934 | 197227 | Signal Analysis | closed | -77.10700704 | 38.86930798 | George Mason Dr, Arlington VA | 2025-03-08 10:51:00 | 2025-03-12 12:42:11.673000000 | public | QScend | |
| 166968 | 166968 | 184670 | Signal Analysis | closed | -77.13778330 | 38.89635520 | 2372 N HARRISON ST, Arlington VA | 2024-11-18 13:54:00 | 2024-11-27 23:11:36.980000000 | public | QScend | |
| 166974 | 166974 | 160645 | Signal Analysis | closed | -77.05201792 | 38.86008431 | 15th St S, Arlington VA | 2024-05-08 06:57:00 | 2024-05-14 20:32:12.907000000 | public | QScend | |
| 166996 | 166996 | 18939 | Signal Analysis | closed | -77.09869202 | 38.89952101 | 2346 N FILLMORE ST, Arlington VA | 2021-04-13 14:50:00 | 2021-04-18 18:00:47.117000000 | public | QScend | |
| 166999 | 166999 | 207959 | Signal Analysis | closed | -77.12776450 | 38.92132000 | 4133 N Old Glebe Rd, Arlington VA | 2025-06-05 23:39:00 | 2025-11-26 06:05:53.713000000 | public | QScend | |
| 167036 | 167036 | 95201 | Signal Analysis | closed | -77.07844962 | 38.89601955 | 1812 N Quinn St, Arlington VA | 2022-11-21 12:06:00 | 2022-12-03 14:00:39.813000000 | public | QScend | |
| 167046 | 167046 | 96733 | Signal Analysis | closed | -77.09049997 | 38.88079002 | N Pershing Dr, Arlington VA | 2022-12-07 11:08:00 | 2022-12-19 16:00:34.850000000 | public | QScend | |
| 167061 | 167061 | 14215 | Signal Analysis | closed | -77.08700991 | 38.86257006 | Columbia Pike, Arlington VA | 2021-03-04 12:21:00 | 2021-03-21 12:00:43.060000000 | public | QScend | |
| 167114 | 167114 | 12005 | Signal Analysis | closed | -77.06501990 | 38.84537006 | S Arlington Ridge Rd, Arlington VA | 2021-02-08 11:26:00 | 2021-09-18 12:01:15.970000000 | public | QScend | |
| 167119 | 167119 | 142541 | Signal Analysis | closed | -77.09744180 | 38.87758888 | 407 N Jackson St, Arlington VA | 2023-12-12 17:11:00 | 2024-03-02 19:31:44.417000000 | public | QScend | |
| 167124 | 167124 | 75819 | Signal Analysis | closed | -77.13415988 | 38.86630005 | Arlington Blvd, Arlington VA | 2022-06-28 09:52:00 | 2022-07-11 14:00:39.257000000 | public | QScend | |
| 167128 | 167128 | 206804 | Signal Analysis | closed | -77.08917301 | 38.86212849 | 982 S Highland St, Arlington VA | 2025-05-28 20:18:00 | 2025-05-31 06:06:55.953000000 | public | QScend | |
| 167155 | 167155 | 239809 | Signal Analysis | closed | -77.05140473 | 38.86288862 | 372 12th St S, Arlington VA | 2025-12-22 11:18:00 | 2025-12-23 06:06:48.260000000 | public | QScend | |
| 167227 | 167227 | 208699 | Signal Analysis | closed | -77.05272992 | 38.84251793 | S Glebe Rd, Arlington VA | 2025-06-11 14:34:00 | 2025-11-26 06:05:53.713000000 | 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]);