trees
1,194 rows where qSpecies_id = 50 sorted by Police Districts
This data as json, CSV (advanced)
qCaretaker_id ✖
- Private 1,122
- DPW 68
- SFUSD 2
- DPW for City Agency 2
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104 | 260590 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3099x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | ||||||||||||
114 | 251458 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
6953 | 34058 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37960 | ||||||||||||||
8650 | 46584 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2790 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2002 12:00:00 AM | Permit Number 44712 | |||||||||||||
12203 | 260589 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3099x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | ||||||||||||
12527 | 260588 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3099x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | ||||||||||||
12212 | 72455 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 548 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6010352.2868 | 2119601.9151 | 37.8006062535339 | -122.408310850279 | (37.8006062535339, -122.408310850279) | 3 | 1 | 10 | 308 | 23 | |||
18156 | 73673 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1020 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 49743 | 6009009.07055 | 2116016.55074 | 37.7906864165824 | -122.412705335782 | (37.7906864165824, -122.412705335782) | 5 | 1 | 10 | 28857 | 21 | ||
19119 | 71960 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1020 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6008996.95317 | 2116013.92959 | 37.7906785394346 | -122.412747076037 | (37.7906785394346, -122.412747076037) | 5 | 1 | 10 | 28857 | 21 | ||||
33426 | 81978 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2318 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50641 | 6007584.72207 | 2120320.19239 | 37.8024230981 | -122.417938725504 | (37.8024230981, -122.417938725504) | 5 | 1 | 1 | 308 | 32 | |
170851 | 129103 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1306x Montgomery St | 29 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6011435.37643 | 2120050.37627 | 37.8018982087863 | -122.404594484269 | (37.8018982087863, -122.404594484269) | 3 | 1 | 10 | 308 | 23 | |||
852 | 108444 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877 | 2117007 | 37.7937335561349 | -122.392471758503 | (37.7937335561349, -122.392471758503) | 12 | 2 | 9 | 28855 | 6 | |
32924 | 190747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 200 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6011390.12769 | 2107238.80287 | 37.7667181107881 | -122.403849027209 | (37.7667181107881, -122.403849027209) | 8 | 2 | 8 | 28853 | 20 | |||
41443 | 108489 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 131 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773695 | 6008906.91703 | 2111099.40816 | 37.7771793890601 | -122.412711016861 | (37.7771793890601, -122.412711016861) | 8 | 2 | 9 | 28853 | 34 |
46326 | 94953 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 763 Brannan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909 | 2109793 | 37.7737603305178 | -122.402233924084 | (37.7737603305178, -122.402233924084) | 14 | 2 | 9 | 28853 | 34 | ||
86346 | 30658 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 47 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34591 | 6007577.41772 | 2109608.9608 | 37.7730122661246 | -122.417204548653 | (37.7730122661246, -122.417204548653) | 8 | 2 | 9 | 28853 | 19 |
88772 | 94952 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 763 Brannan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909 | 2109793 | 37.7737603305178 | -122.402233924084 | (37.7737603305178, -122.402233924084) | 14 | 2 | 9 | 28853 | 34 | ||
89952 | 190749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 111 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008907.60615 | 2111116.85343 | 37.7772273283225 | -122.412709866562 | (37.7772273283225, -122.412709866562) | 8 | 2 | 9 | 28853 | 34 | |||
109658 | 190748 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 200 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6011391.69355 | 2107207.84436 | 37.7666331931997 | -122.403841432442 | (37.7666331931997, -122.403841432442) | 8 | 2 | 8 | 28853 | 20 | |||
155463 | 36721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39505 | 6005645.10091643 | 2108871.29821034 | 37.7708779241001 | -122.423836216701 | (37.7708779241001, -122.423836216701) | 8 | 2 | 5 | 28853 | 19 | ||
187304 | 228524 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 29 Pearl St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005636.60822 | 2108865.67188 | 37.7708619961085 | -122.42386519304 | (37.7708619961085, -122.42386519304) | 8 | 2 | 5 | 28853 | 19 | |||
779 | 69766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6014547.15395 | 2096165.56329 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
1823 | 162258 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 800 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6011414.80687 | 2091110.91102 | 37.7224357728692 | -122.402629394533 | (37.7224357728692, -122.402629394533) | 10 | 3 | 7 | 309 | 28 | ||
2344 | 190703 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012441.45218 | 2104621.0711 | 37.759589078787 | -122.400028798005 | (37.759589078787, -122.400028798005) | 10 | 3 | 8 | 28856 | 29 | |||
2360 | 190701 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013753.34046 | 2106269.97699 | 37.7641896695377 | -122.395607129171 | (37.7641896695377, -122.395607129171) | 14 | 3 | 8 | 28856 | 29 | |||
3601 | 32960 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 934 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 16 | 6x12 | Permit Number 37274 | 6015218.03519 | 2104239.88822 | 37.7586968478982 | -122.390399274809 | (37.7586968478982, -122.390399274809) | 10 | 3 | 8 | 28856 | 29 |
3966 | 249038 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 22 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013079.09197 | 2090984.85367 | 37.7221824230653 | -122.396867469658 | (37.7221824230653, -122.396867469658) | 10 | 3 | 8 | 58 | 1 | |
4292 | 190709 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012742.49696 | 2104176.10053 | 37.7583840672751 | -122.398956396912 | (37.7583840672751, -122.398956396912) | 10 | 3 | 8 | 28856 | 29 | |||
4309 | 69898 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1019 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011946.5334 | 2103437.3528 | 37.756311243277 | -122.401657284058 | (37.756311243277, -122.401657284058) | 10 | 3 | 8 | 28856 | 29 | |||
5495 | 260381 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1924 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015697 | 2093053 | 37.7280065148754 | -122.387962157958 | (37.7280065148754, -122.387962157958) | 10 | 3 | 8 | 58 | 1 | ||||
7992 | 249041 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 21 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013113.97722 | 2090973.86381 | 37.7221541888428 | -122.396746108866 | (37.7221541888428, -122.396746108866) | 10 | 3 | 8 | 58 | 1 | |
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 | ||
8559 | 264797 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 685 Dwight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009656 | 2091058 | 37.7221921373886 | -122.40870548174 | (37.7221921373886, -122.40870548174) | 10 | 3 | 7 | 309 | 28 | ||||
9289 | 260836 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1536 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015652 | 2095724 | 37.7353380520345 | -122.388304065218 | (37.7353380520345, -122.388304065218) | 10 | 3 | 8 | 58 | 1 | ||||
9391 | 149875 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015583.80084 | 2102690.13073 | 37.7544618261772 | -122.38902607571 | (37.7544618261772, -122.38902607571) | 10 | 3 | 8 | 28856 | 29 | |||
9700 | 261108 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1324 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014006 | 2091032 | 37.7223634274326 | -122.393666646077 | (37.7223634274326, -122.393666646077) | 10 | 3 | 8 | 58 | 1 | |
9747 | 261106 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 85 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013023 | 2090614 | 37.7211610112065 | -122.397035377595 | (37.7211610112065, -122.397035377595) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
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 | |||
10948 | 261107 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1324 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014006 | 2091032 | 37.7223634274326 | -122.393666646077 | (37.7223634274326, -122.393666646077) | 10 | 3 | 8 | 58 | 1 | |
11458 | 35362 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 979 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 6 | Permit Number 38824 | 6011922.43629 | 2103880.66513 | 37.75752713659 | -122.401771780343 | (37.75752713659, -122.401771780343) | 10 | 3 | 8 | 28856 | 29 | |
11826 | 43301 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 515 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 6 | Permit Number 48334 | 6013838.69916 | 2104687.66336 | 37.7598497302126 | -122.395201050183 | (37.7598497302126, -122.395201050183) | 10 | 3 | 8 | 28856 | 29 | |
12291 | 190743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 39 Latona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014419.07803 | 2094437.81167 | 37.7317380471513 | -122.392476830144 | (37.7317380471513, -122.392476830144) | 10 | 3 | 8 | 58 | 1 | |||
12628 | 259370 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1466 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015644.90497 | 2093658.91441 | 37.7296673488753 | -122.388184521919 | (37.7296673488753, -122.388184521919) | 10 | 3 | 8 | 58 | 1 | ||
13205 | 69888 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1094 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012175.72633 | 2103309.76161 | 37.7559736926594 | -122.400855686861 | (37.7559736926594, -122.400855686861) | 10 | 3 | 8 | 28856 | 29 | |||
13592 | 162301 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 238 Olmstead St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 0ft | 6010941.2062 | 2091035.49966 | 37.7222022558199 | -122.404261226995 | (37.7222022558199, -122.404261226995) | 10 | 3 | 7 | 309 | 28 | ||
13967 | 84622 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 382 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013742.24361 | 2105343.88141 | 37.761646197043 | -122.395580621644 | (37.761646197043, -122.395580621644) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |
14592 | 259355 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1924 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | 6015758.71756 | 2093108.46198 | 37.728162221452 | -122.387752664752 | (37.728162221452, -122.387752664752) | 10 | 3 | 8 | 58 | 1 | ||
14660 | 78429 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 744 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 3x3 | 6011805.9335 | 2104893.37298 | 37.7603013058687 | -122.402245896623 | (37.7603013058687, -122.402245896623) | 10 | 3 | 8 | 28856 | 29 | ||
15490 | 264795 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 685 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009656 | 2091058 | 37.7221921373886 | -122.40870548174 | (37.7221921373886, -122.40870548174) | 10 | 3 | 7 | 309 | 28 | ||||
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 | ||||
15985 | 149873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.31236 | 2102734.10944 | 37.7545824999013 | -122.389034293714 | (37.7545824999013, -122.389034293714) | 10 | 3 | 8 | 28856 | 29 | |||
16102 | 261110 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 20 Latona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014376 | 2094477 | 37.7318432579921 | -122.392628501141 | (37.7318432579921, -122.392628501141) | 10 | 3 | 8 | 58 | 1 | ||
16486 | 150546 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012204.80057 | 2103865.42291 | 37.7575010382506 | -122.400794174114 | (37.7575010382506, -122.400794174114) | 10 | 3 | 8 | 28856 | 29 | |||
17028 | 264796 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 685 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009656 | 2091058 | 37.7221921373886 | -122.40870548174 | (37.7221921373886, -122.40870548174) | 10 | 3 | 7 | 309 | 28 | ||||
17504 | 261109 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 20 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014376 | 2094477 | 37.7318432579921 | -122.392628501141 | (37.7318432579921, -122.392628501141) | 10 | 3 | 8 | 58 | 1 | ||
17748 | 78435 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2036 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011985.6646 | 2103761.39443 | 37.7572031738156 | -122.401544727608 | (37.7572031738156, -122.401544727608) | 10 | 3 | 8 | 28856 | 29 | |||
18269 | 149874 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.50669 | 2102715.11316 | 37.7545303509079 | -122.389032295422 | (37.7545303509079, -122.389032295422) | 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 | ||||
19354 | 262188 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 490 Vermont St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784452 | 6011166 | 2106075 | 37.7635100471883 | -122.404542318782 | (37.7635100471883, -122.404542318782) | 8 | 3 | 8 | 28856 | 29 | |
20229 | 37987 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 613 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40209 | 6013866.01576 | 2104192.39502 | 37.7584913501141 | -122.39507188416 | (37.7584913501141, -122.39507188416) | 10 | 3 | 8 | 28856 | 29 | |
21056 | 38279 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013875.32423 | 2104028.43016 | 37.7580416558018 | -122.395028206788 | (37.7580416558018, -122.395028206788) | 10 | 3 | 8 | 28856 | 29 | ||
21580 | 39574 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 863 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40991 | 6011617.31177 | 2104338.8923 | 37.7587682945481 | -122.402859256767 | (37.7587682945481, -122.402859256767) | 10 | 3 | 8 | 28856 | 29 | |
22956 | 27142 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1775 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011388.17267 | 2095338.53753 | 37.7340424699754 | -122.403018675074 | (37.7340424699754, -122.403018675074) | 10 | 3 | 8 | 58 | 1 | |||
23234 | 48401 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1170 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50635 | 6011912.33745 | 2102971.80272 | 37.7550310367587 | -122.401742823998 | (37.7550310367587, -122.401742823998) | 10 | 3 | 8 | 28856 | 29 | |
24333 | 105898 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013868.87409 | 2104163.4691 | 37.758412084763 | -122.395059972665 | (37.758412084763, -122.395059972665) | 10 | 3 | 8 | 28856 | 29 | |||
24397 | 47676 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 434 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 6 | Permit Number 45460 | 6014318.70228 | 2105083.22351 | 37.7609625351244 | -122.393568625994 | (37.7609625351244, -122.393568625994) | 10 | 3 | 8 | 28856 | 29 | |
24742 | 37969 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 601 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40199 | 6013584.10507 | 2104296.87899 | 37.7587625595637 | -122.396054186654 | (37.7587625595637, -122.396054186654) | 10 | 3 | 8 | 28856 | 29 | |
24801 | 35349 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1162 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 12 | Permit Number 38812 | 6012188.57169 | 2103037.28239 | 37.7552262409021 | -122.400792120955 | (37.7552262409021, -122.400792120955) | 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 | ||||
26709 | 201517 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6019123.25931 | 2094488.31096 | 37.7321368236424 | -122.376216835747 | (37.7321368236424, -122.376216835747) | 10 | 3 | 8 | 58 | 1 | |||
26909 | 35338 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 738 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 4 | Permit Number 38803 | 6013013.2913 | 2103555.40384 | 37.7566948554054 | -122.397976322051 | (37.7566948554054, -122.397976322051) | 10 | 3 | 8 | 28856 | 29 | |
27293 | 105894 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6013871.77748 | 2104094.24154 | 37.7582221623537 | -122.395045082568 | (37.7582221623537, -122.395045082568) | 10 | 3 | 8 | 28856 | 29 | |||
28655 | 116872 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013499.86788 | 2106650.27714 | 37.7652197871992 | -122.396510483775 | (37.7652197871992, -122.396510483775) | 14 | 3 | 8 | 28856 | 20 | |||
28919 | 190699 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013438.17718 | 2106819.03274 | 37.7656797193792 | -122.3967356902 | (37.7656797193792, -122.3967356902) | 14 | 3 | 8 | 28856 | 20 | |||
29482 | 104712 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 303 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x4 | 6012983 | 2105615 | 37.7623483675995 | -122.39822557732 | (37.7623483675995, -122.39822557732) | 10 | 3 | 8 | 28856 | 29 | |||
29512 | 190708 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2033 22nd St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6011986.6004 | 2103715.0173 | 37.7570758846471 | -122.401538231824 | (37.7570758846471, -122.401538231824) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |
32204 | 116873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6013484.98836 | 2106649.50082 | 37.7652168275233 | -122.396561894417 | (37.7652168275233, -122.396561894417) | 14 | 3 | 8 | 28856 | 20 | |||
33862 | 106166 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1051 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6012226.18355 | 2103510.52022 | 37.7565277460814 | -122.400695290961 | (37.7565277460814, -122.400695290961) | 10 | 3 | 8 | 28856 | 29 | ||||
34108 | 190689 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6015296.26829 | 2103832.96006 | 37.7575838496448 | -122.390100279027 | (37.7575838496448, -122.390100279027) | 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 | ||||
35715 | 117954 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 75 Bridgeview Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 3 | 2.5x3 | 6013772.99018 | 2095538.96094 | 37.7347256767529 | -122.394787591666 | (37.7347256767529, -122.394787591666) | 10 | 3 | 8 | 58 | 1 | |||
39242 | 49995 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 908@ 20TH ST Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 7 | Permit Number 46738 | 6011567.97706 | 2104146.58896 | 37.7582375173758 | -122.403016353927 | (37.7582375173758, -122.403016353927) | 10 | 3 | 8 | 28856 | 29 | |
40910 | 50150 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 541@ 20TH ST Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/07/2003 12:00:00 AM | 6 | Permit Number 46869 | 6014129.22762 | 2104572.8122 | 37.7595505266559 | -122.394188205843 | (37.7595505266559, -122.394188205843) | 10 | 3 | 8 | 28856 | 29 | |
41324 | 122711 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012928.83224 | 2105933.48701 | 37.7632198451537 | -122.398435273093 | (37.7632198451537, -122.398435273093) | 14 | 3 | 8 | 28856 | 29 | |||
42211 | 37964 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 422 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 6 | Permit Number 40195 | 6013476.64244 | 2105094.41315 | 37.760946434546 | -122.396481747729 | (37.760946434546, -122.396481747729) | 10 | 3 | 8 | 28856 | 29 | |
42631 | 89008 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52629 | 6012436 | 2104662 | 37.7597011565358 | -122.400050528825 | (37.7597011565358, -122.400050528825) | 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 | |
45524 | 67540 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 619 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 5 | Permit Number 31080 | 6012728.40675 | 2104463.00984 | 37.7591710721042 | -122.399025265205 | (37.7591710721042, -122.399025265205) | 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 | ||||
45918 | 190719 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 642 Mississippi St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6014091.45327 | 2104130.33792 | 37.7583334885189 | -122.39428786959 | (37.7583334885189, -122.39428786959) | 10 | 3 | 8 | 28856 | 29 | |||
47404 | 190692 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1007 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6015546.55953 | 2104430.75491 | 37.7592391453969 | -122.389276405591 | (37.7592391453969, -122.389276405591) | 10 | 3 | 8 | 28856 | 29 | |||
48539 | 121582 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6013716 | 2106401 | 37.7645473527506 | -122.395745461209 | (37.7645473527506, -122.395745461209) | 14 | 3 | 8 | 28856 | 29 | |||
49020 | 27140 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1775 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011410.17472 | 2095355.19259 | 37.7340894298873 | -122.40294377776 | (37.7340894298873, -122.40294377776) | 10 | 3 | 8 | 58 | 1 | |||
49110 | 190693 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 949 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6015286.01268 | 2104068.80958 | 37.7582308731831 | -122.390152223841 | (37.7582308731831, -122.390152223841) | 10 | 3 | 8 | 28856 | 29 | |||
51950 | 105895 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013871.69882 | 2104104.53276 | 37.7582504154377 | -122.395046075423 | (37.7582504154377, -122.395046075423) | 10 | 3 | 8 | 28856 | 29 |
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) );