trees
353 rows where Supervisor Districts = 8 and qSpecies_id = 50 sorted by Latitude
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8065 | 255771 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
8434 | 255770 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
71449 | 255772 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
172142 | 255773 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
15582 | 34308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
19118 | 34336 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
25134 | 34329 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
34493 | 34309 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
45805 | 34314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
52340 | 34319 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
56528 | 34320 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
58181 | 34312 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
60736 | 34327 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
72978 | 34338 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
81858 | 34307 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
89178 | 34318 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
99407 | 34313 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
100567 | 34321 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
107938 | 34311 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
110878 | 34326 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
111213 | 34335 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
139065 | 34317 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
142907 | 34337 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
148478 | 34331 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
150302 | 34324 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
156109 | 34315 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
157772 | 34316 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
160328 | 34333 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
162785 | 34322 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
163887 | 34330 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
165341 | 34325 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
167135 | 34334 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
179728 | 34310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
184316 | 34332 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
189461 | 34328 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
191516 | 34323 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
77587 | 190707 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2221 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011869.78299 | 2101342.9203 | 37.7505561064965 | -122.401775500866 | (37.7505561064965, -122.401775500866) | 10 | 3 | 8 | 28856 | 1 | |||
61215 | 190706 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2221 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011852.8073 | 2101343.3115 | 37.7505562332917 | -122.401834231975 | (37.7505562332917, -122.401834231975) | 10 | 3 | 8 | 28856 | 1 | |||
14099 | 38381 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1464 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/17/2005 12:00:00 AM | 5 | Permit Number 48279 | 6011990.10357 | 2101552.61207 | 37.7511385883967 | -122.401374155011 | (37.7511385883967, -122.401374155011) | 10 | 3 | 8 | 28856 | 29 | |
90656 | 190704 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1446 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6011711.12531 | 2101607.11223 | 37.7512726647182 | -122.402342728461 | (37.7512726647182, -122.402342728461) | 10 | 3 | 8 | 28856 | 29 | |||
161348 | 44333 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2516 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2001 12:00:00 AM | Permit Number 43718 | 6011390.61929335 | 2101865.00809081 | 37.7519628937204 | -122.403469222223 | (37.7519628937204, -122.403469222223) | 10 | 4 | 8 | 28859 | 19 | ||
80273 | 190705 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2207 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012167.67259 | 2101868.22715 | 37.7520151045386 | -122.400782269783 | (37.7520151045386, -122.400782269783) | 10 | 3 | 8 | 28856 | 29 | |||
167994 | 229785 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1366 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010846.06079 | 2101951.02013 | 37.7521686322761 | -122.405358450228 | (37.7521686322761, -122.405358450228) | 10 | 4 | 8 | 28859 | 19 | |||
103487 | 80120 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1368 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53583 | 6010852.51966051 | 2101957.65368141 | 37.7521872076664 | -122.405336581456 | (37.7521872076664, -122.405336581456) | 10 | 4 | 8 | 28859 | 19 | ||
10612 | 78436 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1379 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6012015.72942 | 2101977.35144 | 37.7523062600388 | -122.401315382525 | (37.7523062600388, -122.401315382525) | 10 | 3 | 8 | 28856 | 29 | |||
117745 | 229784 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1350 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010843.40414 | 2102039.00655 | 37.7524100750712 | -122.405373833155 | (37.7524100750712, -122.405373833155) | 10 | 4 | 8 | 28859 | 19 | |||
13018 | 121737 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
31864 | 121730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 5 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
34391 | 121731 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
61704 | 121736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
77220 | 121726 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
90226 | 121729 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
104984 | 121733 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
138812 | 121727 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
152066 | 121728 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
189598 | 121735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
164341 | 229751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011465.75975 | 2102083.13702 | 37.7525660247145 | -122.40322471697 | (37.7525660247145, -122.40322471697) | 10 | 4 | 8 | 28859 | 19 | |||
88805 | 229752 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011465.52618 | 2102102.51804 | 37.7526192277045 | -122.403226887931 | (37.7526192277045, -122.403226887931) | 10 | 4 | 8 | 28859 | 19 | |||
120093 | 229753 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011465.79162 | 2102125.84808 | 37.7526833017063 | -122.403227610989 | (37.7526833017063, -122.403227610989) | 10 | 4 | 8 | 28859 | 19 | |||
120945 | 229754 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.93054 | 2102145.24186 | 37.7527365046859 | -122.403231952908 | (37.7527365046859, -122.403231952908) | 10 | 4 | 8 | 28859 | 19 | |||
193911 | 229755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.24481 | 2102169.9708 | 37.7528043666378 | -122.403236063707 | (37.7528043666378, -122.403236063707) | 10 | 4 | 8 | 28859 | 19 | |||
183793 | 58933 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1330 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/1980 12:00:00 AM | 7 | Permit Number 18211 | 6011958.83687 | 2102173.28777 | 37.7528410841477 | -122.401525896729 | (37.7528410841477, -122.401525896729) | 10 | 3 | 8 | 28856 | 29 | ||
29151 | 229756 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.15557 | 2102190.87321 | 37.7528617550894 | -122.403237842573 | (37.7528617550894, -122.403237842573) | 10 | 4 | 8 | 28859 | 19 | |||
165791 | 229757 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011461.99954 | 2102213.77594 | 37.752924520553 | -122.403246909533 | (37.752924520553, -122.403246909533) | 10 | 4 | 8 | 28859 | 19 | |||
102641 | 229758 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011460.45759 | 2102239.71319 | 37.7529956524374 | -122.403254066338 | (37.7529956524374, -122.403254066338) | 10 | 4 | 8 | 28859 | 19 | |||
187690 | 229759 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011459.21947 | 2102251.51401 | 37.753027985753 | -122.403259178089 | (37.753027985753, -122.403259178089) | 10 | 4 | 8 | 28859 | 19 | |||
54681 | 229760 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011458.91565 | 2102265.65077 | 37.7530667852271 | -122.403261223145 | (37.7530667852271, -122.403261223145) | 10 | 4 | 8 | 28859 | 19 | |||
10911 | 78495 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1300 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011953.72275 | 2102256.16538 | 37.7530683626141 | -122.401549406774 | (37.7530683626141, -122.401549406774) | 10 | 3 | 8 | 28856 | 29 | |||
44753 | 78724 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1300 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53574 | 6011950.73154 | 2102276.22736 | 37.7531232815236 | -122.401561160927 | (37.7531232815236, -122.401561160927) | 10 | 3 | 8 | 28856 | 29 | |
18290 | 229761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011456.4035 | 2102287.48645 | 37.7531266009123 | -122.403271446634 | (37.7531266009123, -122.403271446634) | 10 | 4 | 8 | 28859 | 19 | |||
31469 | 78725 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1300 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53574 | 6011951.34663 | 2102291.29231 | 37.7531646809082 | -122.401560092537 | (37.7531646809082, -122.401560092537) | 10 | 3 | 8 | 28856 | 29 | |
159856 | 229762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011454.29465 | 2102314.61303 | 37.7532009667707 | -122.403280647606 | (37.7532009667707, -122.403280647606) | 10 | 4 | 8 | 28859 | 19 | |||
38692 | 229763 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6011453.21392 | 2102329.36922 | 37.7532414236718 | -122.403285422977 | (37.7532414236718, -122.403285422977) | 10 | 4 | 8 | 28859 | 19 | |||
1622 | 78494 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2131 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6012056.35315 | 2102319.00627 | 37.7532466361332 | -122.401198904113 | (37.7532466361332, -122.401198904113) | 10 | 3 | 8 | 28856 | 29 | |||
107367 | 229764 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011452.97986 | 2102350.02958 | 37.753298139414 | -122.403287685686 | (37.753298139414, -122.403287685686) | 10 | 4 | 8 | 28859 | 19 | |||
70055 | 229765 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011453.42278 | 2102371.80516 | 37.7533579551144 | -122.403287685694 | (37.7533579551144, -122.403287685694) | 10 | 4 | 8 | 28859 | 19 | |||
41300 | 229766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011452.91917 | 2102390.65584 | 37.7534096868171 | -122.403290753279 | (37.7534096868171, -122.403290753279) | 10 | 4 | 8 | 28859 | 19 | |||
122297 | 229767 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011451.55336 | 2102410.70185 | 37.7534646524788 | -122.403296886638 | (37.7534646524788, -122.403296886638) | 10 | 4 | 8 | 28859 | 19 | |||
143926 | 229768 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011450.10406 | 2102428.33109 | 37.7535129775571 | -122.403303138733 | (37.7535129775571, -122.403303138733) | 10 | 4 | 8 | 28859 | 19 | |||
170096 | 229769 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011449.91996 | 2102448.35306 | 37.7535679432079 | -122.403305183785 | (37.7535679432079, -122.403305183785) | 10 | 4 | 8 | 28859 | 19 | |||
130053 | 229786 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1254 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010820.80874 | 2102463.77247 | 37.7535751252085 | -122.405481884883 | (37.7535751252085, -122.405481884883) | 10 | 4 | 8 | 28859 | 19 | |||
36074 | 229770 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011448.51225 | 2102466.33912 | 37.753617250357 | -122.403311317166 | (37.753617250357, -122.403311317166) | 10 | 4 | 8 | 28859 | 19 | |||
85653 | 34305 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1254 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38093 | 6010822.82923264 | 2102485.1673324 | 37.7536339837486 | -122.405476404222 | (37.7536339837486, -122.405476404222) | 10 | 4 | 8 | 28859 | 19 | ||
95325 | 229771 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011447.67718 | 2102483.4305 | 37.7536641328931 | -122.403315407293 | (37.7536641328931, -122.403315407293) | 10 | 4 | 8 | 28859 | 19 | |||
55327 | 229772 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011446.86383 | 2102500.86077 | 37.7537119471592 | -122.403319446151 | (37.7537119471592, -122.403319446151) | 10 | 4 | 8 | 28859 | 19 | |||
15057 | 229773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011446.65854 | 2102520.54386 | 37.7537659811344 | -122.403321540662 | (37.7537659811344, -122.403321540662) | 10 | 4 | 8 | 28859 | 19 | |||
2399 | 121749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
4736 | 121804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 22 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
15956 | 121747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
19632 | 121745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
34062 | 121740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
52895 | 121751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 14 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
60196 | 121738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
66845 | 121803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 21 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
74982 | 121755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 18 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
76026 | 121748 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
89672 | 121756 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 19 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
110905 | 121743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
116126 | 121744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 7 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
138150 | 121741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );