trees
3,247 rows where qSpecies_id = 22 sorted by PlantDate descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190931 | 65419 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 790 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1989 12:00:00 AM | 7 | Permit Number 28277 | 6010596.9458 | 2116598.4716 | 37.7923732244726 | -122.407252384703 | (37.7923732244726, -122.407252384703) | 3 | 1 | 10 | 28857 | 4 | |
168588 | 108147 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2014 12:00:00 AM | 3 | Permit Number 774253 | 6003296.86852 | 2119720.45859 | 37.800534134189 | -122.432733936524 | (37.800534134189, -122.432733936524) | 13 | 9 | 1 | 57 | 17 | ||
100979 | 29898 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 462 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/26/2008 12:00:00 AM | 3 | 3x3 | 6002305.9366121 | 2105543.9648718 | 37.7615528104262 | -122.435148428343 | (37.7615528104262, -122.435148428343) | 15 | 4 | 5 | 28862 | 3 | ||
121017 | 29899 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 584 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2008 12:00:00 AM | 3 | 3x3 | 6002334.75253 | 2104838.51742 | 37.7596174587106 | -122.434998311621 | (37.7596174587106, -122.434998311621) | 2 | 4 | 5 | 28862 | 3 | ||
90865 | 48951 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2973 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2002 12:00:00 AM | Permit Number 46136 | 6009074.16570878 | 2102723.16888888 | 37.7541895521884 | -122.411540507209 | (37.7541895521884, -122.411540507209) | 2 | 4 | 7 | 28859 | 19 | ||
73433 | 48929 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 797 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46118 | 6010177.49860621 | 2104588.91884778 | 37.7593743105767 | -122.407856447489 | (37.7593743105767, -122.407856447489) | 10 | 4 | 8 | 28859 | 19 | ||
80819 | 48928 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 797 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46118 | 6010177.49860621 | 2104588.91884778 | 37.7593743105767 | -122.407856447489 | (37.7593743105767, -122.407856447489) | 10 | 4 | 8 | 28859 | 19 | ||
144151 | 48925 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1063 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46115 | 6009210.28218352 | 2102976.55633633 | 37.7548929313086 | -122.411087677797 | (37.7548929313086, -122.411087677797) | 2 | 4 | 7 | 28859 | 19 | ||
181951 | 48930 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 797 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46118 | 6010177.49860621 | 2104588.91884778 | 37.7593743105767 | -122.407856447489 | (37.7593743105767, -122.407856447489) | 10 | 4 | 8 | 28859 | 19 | ||
144777 | 33516 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 71 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37622 | 6006841.28838003 | 2099288.89246051 | 37.7446343092486 | -122.419018795175 | (37.7446343092486, -122.419018795175) | 2 | 7 | 7 | 28859 | 2 | ||
133722 | 114549 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015846.45477 | 2106262.10927 | 37.7642842728198 | -122.388367034517 | (37.7642842728198, -122.388367034517) | 14 | 3 | 8 | 28856 | 29 | ||
158146 | 114548 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015820.59236 | 2106259.92484 | 37.7642768417202 | -122.38845633359 | (37.7642768417202, -122.38845633359) | 14 | 3 | 8 | 28856 | 29 | ||
167912 | 114550 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015870.34934 | 2106264.23944 | 37.764291445828 | -122.388284537902 | (37.764291445828, -122.388284537902) | 14 | 3 | 8 | 28856 | 29 | ||
3819 | 6627 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016607.54293 | 2097762.50213 | 37.7409882686849 | -122.385142357926 | (37.7409882686849, -122.385142357926) | 10 | 3 | 8 | 58 | 1 | ||
99616 | 6560 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1275 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/1998 12:00:00 AM | 5 | 3X3 | 6017410.00107 | 2097164.07797 | 37.7393894737512 | -122.38232610038 | (37.7393894737512, -122.38232610038) | 10 | 3 | 8 | 58 | 1 | ||
146898 | 6625 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016564.1874 | 2097795.2525 | 37.7410757961225 | -122.385294548421 | (37.7410757961225, -122.385294548421) | 10 | 3 | 8 | 58 | 1 | ||
176485 | 6626 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016580.82562 | 2097781.51455 | 37.7410389949512 | -122.38523606192 | (37.7410389949512, -122.38523606192) | 10 | 3 | 8 | 58 | 1 | ||
20200 | 109784 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
35944 | 109787 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
55490 | 109788 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
66352 | 109786 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
85608 | 109785 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
179319 | 109789 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
63617 | 48898 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2220 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2002 12:00:00 AM | 3 | Permit Number 46101 | 6003904.89835 | 2116333.07844 | 37.7912677221834 | -122.430388088265 | (37.7912677221834, -122.430388088265) | 13 | 9 | 1 | 29490 | 27 | |
17856 | 68790 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2339 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32727 | 5991985.43941061 | 2099518.6478439 | 37.744417405952 | -122.470403648157 | (37.744417405952, -122.470403648157) | 1 | 8 | 4 | 29491 | 40 | ||
67347 | 60847 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2345 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32728 | 5991986.7837073 | 2099479.42782761 | 37.7443097955565 | -122.470396144192 | (37.7443097955565, -122.470396144192) | 1 | 8 | 4 | 29491 | 40 | ||
26639 | 4433 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1238 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2008 12:00:00 AM | 3 | 3X3 | 6004437.55444 | 2101698.90078 | 37.7511159830235 | -122.427502095444 | (37.7511159830235, -122.427502095444) | 2 | 4 | 5 | 28862 | 22 | ||
38 | 167409 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 4 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6001979.94285 | 2107686.90453 | 37.7674182815445 | -122.436429284105 | (37.7674182815445, -122.436429284105) | 15 | 5 | 5 | 29492 | 3 | |
56 | 124 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6002037.12702 | 2107659.05322 | 37.7673450578674 | -122.436229498819 | (37.7673450578674, -122.436229498819) | 15 | 5 | 5 | 29492 | 3 | |
191973 | 6447 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1199 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2015 07:28:00 AM | 3 | 3X3 | 6017815.25315 | 2096866.67001 | 37.7385952266854 | -122.380904232644 | (37.7385952266854, -122.380904232644) | 10 | 3 | 8 | 58 | 1 | ||
65305 | 33441 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 220 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37543 | 6006379.64079158 | 2098541.7631108 | 37.7425568534401 | -122.420562059553 | (37.7425568534401, -122.420562059553) | 2 | 7 | 7 | 28859 | 2 | |||
70420 | 33444 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 254 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37546 | 6006325.55721973 | 2098438.92795554 | 37.7422714430944 | -122.420741766146 | (37.7422714430944, -122.420741766146) | 2 | 7 | 7 | 28859 | 2 | |||
123156 | 33447 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 268 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37548 | 6006296.64769337 | 2098385.5559831 | 37.7421232662097 | -122.420837938275 | (37.7421232662097, -122.420837938275) | 2 | 7 | 7 | 28859 | 2 | |||
126557 | 33445 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 254 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37546 | 6006325.55721973 | 2098438.92795554 | 37.7422714430944 | -122.420741766146 | (37.7422714430944, -122.420741766146) | 2 | 7 | 7 | 28859 | 2 | |||
164557 | 33469 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/1996 12:00:00 AM | Permit Number 37568 | 6006683.58482984 | 2099106.89574168 | 37.7441257054073 | -122.419551194294 | (37.7441257054073, -122.419551194294) | 2 | 7 | 7 | 28859 | 2 | ||
68349 | 39185 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1076 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40839 | 6007597.93997947 | 2103393.82057079 | 37.7559480933237 | -122.416693182116 | (37.7559480933237, -122.416693182116) | 2 | 4 | 7 | 28859 | 19 | ||
136157 | 39184 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1076 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40839 | 6007597.93997947 | 2103393.82057079 | 37.7559480933237 | -122.416693182116 | (37.7559480933237, -122.416693182116) | 2 | 4 | 7 | 28859 | 19 | ||
54935 | 64594 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3351 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | Permit Number 31334 | 6006004.81140663 | 2103137.43294391 | 37.7551543807062 | -122.422184539111 | (37.7551543807062, -122.422184539111) | 2 | 4 | 5 | 28859 | 19 | ||
127297 | 63048 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 714 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1986 12:00:00 AM | Permit Number 23519 | 5992694.24669734 | 2105281.3308429 | 37.760281201526 | -122.468371925534 | (37.760281201526, -122.468371925534) | 1 | 8 | 4 | 56 | 12 | ||
95030 | 27280 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 634 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1999 12:00:00 AM | 3 | 3X3 | 6003944.74418 | 2110118.79911 | 37.774207119954 | -122.429806785346 | (37.774207119954, -122.429806785346) | 7 | 9 | 11 | 29492 | 10 | ||
119560 | 41142 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | Permit Number 41877 | 5997416.72400274 | 2109142.90365491 | 37.7711557324301 | -122.452317827144 | (37.7711557324301, -122.452317827144) | 15 | 5 | 11 | 29492 | 9 | |||
155027 | 41144 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | Permit Number 41877 | 5997416.72400274 | 2109142.90365491 | 37.7711557324301 | -122.452317827144 | (37.7711557324301, -122.452317827144) | 15 | 5 | 11 | 29492 | 9 | |||
67392 | 39076 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2280X Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
191093 | 39074 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2280X Alameda St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
82483 | 240000 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3861 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2018 12:00:00 AM | 3 | 6x6 | Permit Number 782241 | 6004016.32481 | 2101862.01887 | 37.7515400331665 | -122.428970379877 | (37.7515400331665, -122.428970379877) | 2 | 4 | 5 | 28862 | 22 | |
143589 | 240001 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3861 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2018 12:00:00 AM | 3 | 6x6 | Permit Number 782241 | 6004050.96962 | 2101863.58561 | 37.7515462960277 | -122.428850685506 | (37.7515462960277, -122.428850685506) | 2 | 4 | 5 | 28862 | 22 | |
81706 | 122697 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
101909 | 122699 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
183675 | 122698 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
108157 | 6453 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1199 Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2009 12:00:00 AM | 3 | 3X3 | 6017908.60089 | 2096791.35092 | 37.7383935672065 | -122.380576243601 | (37.7383935672065, -122.380576243601) | 10 | 3 | 8 | 58 | 1 | ||
8046 | 261018 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Cragmont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774761 | 5992858 | 2101375 | 37.749564886931 | -122.467521508976 | (37.749564886931, -122.467521508976) | 1 | 8 | 4 | 29491 | 12 | |
11989 | 261017 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774761 | 5992858 | 2101375 | 37.749564886931 | -122.467521508976 | (37.749564886931, -122.467521508976) | 1 | 8 | 4 | 29491 | 12 | |
76394 | 66849 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 231 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30153 | 5997810.64306874 | 2109807.59262788 | 37.77300335648 | -122.451003191753 | (37.77300335648, -122.451003191753) | 15 | 5 | 11 | 29492 | 16 | ||
87617 | 89351 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51933 | 5997595.15634 | 2115324.46751 | 37.7881389106226 | -122.452146713906 | (37.7881389106226, -122.452146713906) | 11 | 6 | 1 | 54 | 31 | |
114307 | 89349 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51933 | 5997587.89515 | 2115375.85191 | 37.7882795825748 | -122.452175545264 | (37.7882795825748, -122.452175545264) | 11 | 6 | 1 | 54 | 31 | |
144037 | 89350 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51933 | 5997591.01268 | 2115351.61353 | 37.7882132090129 | -122.452163009619 | (37.7882132090129, -122.452163009619) | 11 | 6 | 1 | 54 | 31 | |
13302 | 231498 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2516 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 02:05:00 PM | 3 | Width 3ft | 6011317.42279 | 2101858.91316 | 37.7519420696849 | -122.403721918837 | (37.7519420696849, -122.403721918837) | 10 | 4 | 8 | 28859 | 19 | ||
7494 | 243413 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998151.68157 | 2104894.95588 | 37.7595340204918 | -122.449469463666 | (37.7595340204918, -122.449469463666) | 15 | 5 | 11 | 28862 | 12 | |
16371 | 260999 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | |
116754 | 107580 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.7096038592127 | -122.468025367885 | (37.7096038592127, -122.468025367885) | 9 | 8 | 4 | 64 | 24 | ||
153512 | 107579 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | 9 | 8 | 4 | 64 | 24 | ||
175627 | 107582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.47342 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | 9 | 8 | 4 | 64 | 24 | ||
182443 | 107581 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.94682 | 2086830.99569 | 37.7096038591978 | -122.468068397753 | (37.7096038591978, -122.468068397753) | 9 | 8 | 4 | 64 | 24 | ||
35687 | 226168 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 157 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2012 12:00:00 AM | 1 | Width 3ft | Permit Number 769431 | 5999386.56682 | 2107303.78218 | 37.7662186210304 | -122.445371834049 | (37.7662186210304, -122.445371834049) | 15 | 5 | 5 | 29492 | 9 | |
81674 | 57586 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 319 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2005 12:00:00 AM | Permit Number 16454 | 6013506.83983599 | 2105596.1472288 | 37.7623257667413 | -122.396412476253 | (37.7623257667413, -122.396412476253) | 10 | 3 | 8 | 28856 | 29 | ||
116984 | 12700 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1403 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/1994 12:00:00 AM | 6 | 3X3 | 5991113.63066 | 2114737.21771 | 37.7861530717359 | -122.474528577552 | (37.7861530717359, -122.474528577552) | 11 | 6 | 2 | 54 | 26 | ||
122267 | 12712 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1462 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/1994 12:00:00 AM | 12 | 3X3 | 5990903.08198 | 2114785.23215 | 37.7862727045665 | -122.475260519465 | (37.7862727045665, -122.475260519465) | 11 | 6 | 1 | 54 | 33 | ||
79128 | 29900 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 462 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2006 12:00:00 AM | 3 | 3x3 | 6002297.37769 | 2105522.3804 | 37.7614930586819 | -122.435176486218 | (37.7614930586819, -122.435176486218) | 15 | 4 | 5 | 28862 | 3 | ||
84146 | 14472 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 235 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/09/1990 12:00:00 AM | 40 | 2X2 | 5998919.6038 | 2112167.2256 | 37.7795457275321 | -122.447337041315 | (37.7795457275321, -122.447337041315) | 15 | 5 | 2 | 54 | 16 | ||
173439 | 52200 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 558 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2005 12:00:00 AM | 1 | Permit Number 48388 | 6010241.4146 | 2120284.6971 | 37.8024747955984 | -122.408742711308 | (37.8024747955984, -122.408742711308) | 3 | 1 | 10 | 308 | 23 | ||
86430 | 54612 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 525 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/1992 12:00:00 AM | Permit Number 28923 | 5994155.70344908 | 2106980.35394559 | 37.7650305813317 | -122.463440770738 | (37.7650305813317, -122.463440770738) | 11 | 5 | 11 | 56 | 12 | ||
87989 | 86916 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2300 28th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | 1 | 8 | 3 | 29491 | 35 | ||
106130 | 86915 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2300 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | 1 | 8 | 3 | 29491 | 35 | ||
160182 | 86914 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2300 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | 1 | 8 | 3 | 29491 | 35 | ||
186117 | 86913 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2300 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | 1 | 8 | 3 | 29491 | 35 | ||
100427 | 55347 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1357 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1972 12:00:00 AM | 12 | Permit Number 11278 | 6008237.04974 | 2116897.5275 | 37.7930620018618 | -122.415438890802 | (37.7930620018618, -122.415438890802) | 5 | 1 | 10 | 28858 | 21 | ||
31468 | 33116 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000083.68486 | 2118474.07473 | 37.7969291406212 | -122.443763225693 | (37.7969291406212, -122.443763225693) | 13 | 9 | 1 | 57 | 17 | |
35203 | 33014 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37305 | 6005620.98142938 | 2101949.23575785 | 37.7518702093111 | -122.423427471135 | (37.7518702093111, -122.423427471135) | 2 | 4 | 5 | 28859 | 19 | |||
50985 | 33117 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000101.0018 | 2118475.17057 | 37.7969331372011 | -122.443703383925 | (37.7969331372011, -122.443703383925) | 13 | 9 | 1 | 57 | 17 | |
77850 | 33012 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37305 | 6005620.98142938 | 2101949.23575785 | 37.7518702093111 | -122.423427471135 | (37.7518702093111, -122.423427471135) | 2 | 4 | 5 | 28859 | 19 | |||
85402 | 33015 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37305 | 6005620.98142938 | 2101949.23575785 | 37.7518702093111 | -122.423427471135 | (37.7518702093111, -122.423427471135) | 2 | 4 | 5 | 28859 | 19 | |||
177770 | 33011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37305 | 6005620.98142938 | 2101949.23575785 | 37.7518702093111 | -122.423427471135 | (37.7518702093111, -122.423427471135) | 2 | 4 | 5 | 28859 | 19 | |||
177946 | 33016 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37305 | 6005620.98142938 | 2101949.23575785 | 37.7518702093111 | -122.423427471135 | (37.7518702093111, -122.423427471135) | 2 | 4 | 5 | 28859 | 19 | |||
183078 | 33013 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37305 | 6005620.98142938 | 2101949.23575785 | 37.7518702093111 | -122.423427471135 | (37.7518702093111, -122.423427471135) | 2 | 4 | 5 | 28859 | 19 | |||
132323 | 64427 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 82 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1995 12:00:00 AM | Permit Number 25348 | 6007836.2713507 | 2099962.02526968 | 37.7465385606002 | -122.41562598072 | (37.7465385606002, -122.41562598072) | 2 | 7 | 7 | 28859 | 2 | ||
43350 | 190564 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1748 Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011532.83475 | 2107953.47602 | 37.7686884129717 | -122.403405708214 | (37.7686884129717, -122.403405708214) | 8 | 2 | 8 | 28853 | 20 | ||
63871 | 190563 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1748 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011562.23742 | 2107955.71991 | 37.7686962163789 | -122.403304163964 | (37.7686962163789, -122.403304163964) | 8 | 2 | 8 | 28853 | 20 | ||
66001 | 190565 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1748 Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011489.99866 | 2107952.31705 | 37.7686828380703 | -122.403553794194 | (37.7686828380703, -122.403553794194) | 8 | 2 | 8 | 28853 | 20 | ||
67103 | 253756 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 41x Division St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
104390 | 190562 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1748 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011586.29241 | 2107955.63677 | 37.7686973315464 | -122.403220953295 | (37.7686973315464, -122.403220953295) | 8 | 2 | 8 | 28853 | 20 | ||
134719 | 253755 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 41x Division St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
11856 | 107887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
38991 | 107888 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
171481 | 107886 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
181881 | 52195 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1209 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2005 12:00:00 AM | 3 | Permit Number 48386 | 6007084.31165 | 2119457.46133 | 37.8000260811036 | -122.419609149648 | (37.8000260811036, -122.419609149648) | 5 | 1 | 1 | 28858 | 32 | ||
80430 | 38718 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 316 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 40621 | 6002284.90067424 | 2109567.58352939 | 37.7725994856416 | -122.43550903266 | (37.7725994856416, -122.43550903266) | 15 | 5 | 11 | 29492 | 9 | ||
24870 | 44098 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2000 12:00:00 AM | 2 | Permit Number 43610 | 6012077.83882 | 2105236.36448 | 37.7612582582864 | -122.401329601683 | (37.7612582582864, -122.401329601683) | 10 | 3 | 8 | 28856 | 29 | ||
64566 | 572 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2980X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776380 | 6009061.0945003 | 2102187.7119023 | 37.75271857431 | -122.411547882163 | (37.75271857431, -122.411547882163) | 2 | 4 | 7 | 28859 | 19 | |
56679 | 53154 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1785@ 3RD ST Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | 2 | Permit Number 49078 | 6014221.25733 | 2095350.49345 | 37.7342330974602 | -122.393224583156 | (37.7342330974602, -122.393224583156) | 10 | 3 | 8 | 58 | 1 | ||
174857 | 53142 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1498@ KEITH Underwood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 10 | 3 | 8 | 58 | 1 |
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) );