Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2365 | 2365 | 253069 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2380 | 2380 | 253068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2382 | 2382 | 253067 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2384 | 2384 | 253066 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2487 | 2487 | 33316 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1443-1443X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 774619 | 6004409.7027 | 2120463.36257 | 37.8026370063559 | -122.42893607346001 | (37.8026370063559, -122.42893607346) | |
| 2731 | 2731 | 49968 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 250 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 773269 | 6007921.5580400005 | 2112390.20722 | 37.7806682603601 | -122.416211138647 | (37.7806682603601, -122.416211138647) | |
| 3517 | 3517 | 33317 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1443-1443X Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 774619 | 6004424.04227 | 2120465.37019 | 37.8026433303993 | -122.42888659453699 | (37.8026433303993, -122.428886594537) | |
| 4834 | 4834 | 50011 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | Permit Number 46742 | ||||||||
| 5529 | 5529 | 49969 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 250 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 773269 | 6007906.3079699995 | 2112391.06257 | 37.780669751438296 | -122.416263956709 | (37.7806697514383, -122.416263956709) | ||
| 6258 | 6258 | 36871 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 6582 | 6582 | 58810 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3199 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 772746 | 6002363.40081 | 2119107.0408799998 | 37.7987968652491 | -122.435920192279 | (37.7987968652491, -122.435920192279) | |
| 7551 | 7551 | 108147 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3322 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2014 12:00:00 AM | 3 | Permit Number 774253 | 6003296.86852 | 2119720.45859 | 37.800534134189 | -122.43273393652399 | (37.800534134189, -122.432733936524) | ||
| 8113 | 8113 | 75258 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 288 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 04:17:00 PM | 3 | 6009102.38385 | 2113598.35596 | 37.7840518741506 | -122.41221149286699 | (37.7840518741506, -122.412211492867) | |||
| 10247 | 10247 | 46477 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 195 Erie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779295 | 6006760.77877473 | 2108157.52189336 | 37.7689809837181 | -122.419926393368 | (37.7689809837181, -122.419926393368) | ||
| 10249 | 10249 | 46478 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 195 Erie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779295 | 6006760.77877473 | 2108157.52189336 | 37.7689809837181 | -122.419926393368 | (37.7689809837181, -122.419926393368) | ||
| 10370 | 10370 | 107580 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.709603859212706 | -122.468025367885 | (37.7096038592127, -122.468025367885) | ||
| 10524 | 10524 | 107581 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.946819999 | 2086830.9956900002 | 37.7096038591978 | -122.46806839775299 | (37.7096038591978, -122.468068397753) | ||
| 11907 | 11907 | 107582 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.4734200002 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | ||
| 12077 | 12077 | 94990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.40477981842301 | (37.7116594240627, -122.404779818423) | ||||
| 12169 | 12169 | 107579 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | ||
| 12355 | 12355 | 36869 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12587 | 12587 | 40943 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 337 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773706 | 6001124.10704 | 2092689.0932900002 | 37.726189192361005 | -122.438314913304 | (37.726189192361, -122.438314913304) | |
| 12626 | 12626 | 36872 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12794 | 12794 | 95013 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.40564982910401 | (37.7118779294401, -122.405649829104) | ||||
| 13338 | 13338 | 187686 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 388 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2017 12:00:00 AM | 3 | 6005900.60365 | 2111761.43845 | 37.7788279713562 | -122.42315789265301 | (37.7788279713562, -122.423157892653) | |||
| 13687 | 13687 | 50152 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 13731 | 13731 | 34850 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1016 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1997 12:00:00 AM | 8 | Permit Number 38472 | 6015493.82496 | 2104313.14645 | 37.7589132940426 | -122.38945057548099 | (37.7589132940426, -122.389450575481) | ||
| 14108 | 14108 | 50151 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 14259 | 14259 | 36873 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14733 | 14733 | 50153 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 14932 | 14932 | 50157 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 15084 | 15084 | 50154 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 15431 | 15431 | 50155 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 15446 | 15446 | 62467 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 710 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 10 | Permit Number 22636 | 6011241.19795 | 2104960.20112 | 37.760453261625 | -122.404203766595 | (37.760453261625, -122.404203766595) | |
| 16441 | 16441 | 34987 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | Permit Number 41601 | 6011225.3523699995 | 2111221.4707400003 | 37.7776443970062 | -122.404699365001 | (37.7776443970062, -122.404699365001) | |||
| 18564 | 18564 | 49087 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | Permit Number 46237 | 6012085.19773634 | 2105185.1896516997 | 37.761118154139204 | -122.401300553818 | (37.7611181541392, -122.401300553818) | |||
| 18639 | 18639 | 61241 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.42961302050301 | (37.7580658175007, -122.429613020503) | ||
| 18641 | 18641 | 41156 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 455 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2004 12:00:00 AM | Permit Number 47674 | 6009883.81375688 | 2109165.06157558 | 37.7719229056173 | -122.409195075279 | (37.7719229056173, -122.409195075279) | |||
| 18688 | 18688 | 67850 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 485 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31520 | 6002735.666769001 | 2098756.82734478 | 37.742941332905396 | -122.433177202226 | (37.7429413329054, -122.433177202226) | ||
| 18893 | 18893 | 7422 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301X 07TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1991 12:00:00 AM | 8 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | |||
| 19406 | 19406 | 44045 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 442 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2000 12:00:00 AM | Permit Number 43576 | 6010366.61752859 | 2089364.49737601 | 37.7175819036471 | -122.406129784758 | (37.7175819036471, -122.406129784758) | |||
| 19494 | 19494 | 68790 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32727 | 5991985.43941061 | 2099518.6478439 | 37.744417405952 | -122.470403648157 | (37.744417405952, -122.470403648157) | ||
| 19619 | 19619 | 35520 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.754456203079705 | -122.422896805421 | (37.7544562030797, -122.422896805421) | ||
| 19635 | 19635 | 36019 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39165 | 6006729.30953986 | 2099082.13183863 | 37.744060284741295 | -122.419391331569 | (37.7440602847413, -122.419391331569) | ||
| 20468 | 20468 | 62857 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 179 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23225 | 6008674.53760188 | 2097751.18669018 | 37.740515170519295 | -122.412571078994 | (37.7405151705193, -122.412571078994) | ||
| 23143 | 23143 | 5166 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 300 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 6001808.2976 | 2109504.736 | 37.7723998416689 | -122.437153148887 | (37.7723998416689, -122.437153148887) | ||||
| 24658 | 24658 | 69418 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 156 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 6 | Permit Number 33523 | 6001409.83218 | 2087347.5533200002 | 37.7115387685699 | -122.436944943671 | (37.7115387685699, -122.436944943671) | |
| 24857 | 24857 | 97204 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 173 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/2011 12:00:00 AM | 1 | Permit Number 768071 | 5996213.20813 | 2113152.77904 | 37.7820967750245 | -122.456770862489 | (37.7820967750245, -122.456770862489) | ||
| 25358 | 25358 | 31407 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4305 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 34997 | 6002016.45582 | 2104087.39785 | 37.7575369877622 | -122.436045390491 | (37.7575369877622, -122.436045390491) | |
| 25448 | 25448 | 102374 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 5983888.78905 | 2110020.99125 | 37.7727824290992 | -122.499175615397 | (37.7727824290992, -122.499175615397) | ||||
| 25647 | 25647 | 58743 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2142 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2012 12:00:00 AM | 3 | Permit Number 769347 | 6007661.70452 | 2119773.9783400004 | 37.800927664050995 | -122.417633590924 | (37.800927664051, -122.417633590924) | ||
| 26127 | 26127 | 110046 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 288 Eddy St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 6009043.83179 | 2113590.50747 | 37.7840270384566 | -122.412413507572 | (37.7840270384566, -122.412413507572) | ||||
| 26133 | 26133 | 71422 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 658 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 6 | 6009722.2927 | 2120212.6608 | 37.802247912275206 | -122.41053404810499 | (37.8022479122752, -122.410534048105) | ||
| 26593 | 26593 | 31486 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 581 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 35050 | 6001574.757780001 | 2102471.63758 | 37.7530753962346 | -122.437457255946 | (37.7530753962346, -122.437457255946) | |
| 26799 | 26799 | 41157 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 455 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2004 12:00:00 AM | 1 | Permit Number 47674 | 6009915.435930001 | 2109145.10555 | 37.7718698825212 | -122.40908428303699 | (37.7718698825212, -122.409084283037) | ||
| 26851 | 26851 | 49941 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2474@ ULLOA 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 1 | Permit Number 46699 | 5988007.7004 | 2098472.4797 | 37.741314111571796 | -122.48408097239401 | (37.7413141115718, -122.484080972394) | |
| 27999 | 27999 | 53556 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 155 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1969 12:00:00 AM | 5 | Permit Number 6468 | 5990822.61349 | 2114386.11588 | 37.7851721782666 | -122.47550976424 | (37.7851721782666, -122.47550976424) | ||
| 28043 | 28043 | 51306 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 87 McLea Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2004 12:00:00 AM | 2 | Permit Number 47673 | 6010064.68289 | 2109219.48748 | 37.7720824777545 | -122.40857327294901 | (37.7720824777545, -122.408573272949) | ||
| 28143 | 28143 | 87300 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 2 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 6 | Permit Number 50312 | 6011877.987480001 | 2100898.0514700003 | 37.749335051069004 | -122.401715863223 | (37.749335051069, -122.401715863223) | |||
| 28472 | 28472 | 63001 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1223 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1986 12:00:00 AM | 3 | Permit Number 23409 | 5983019.7565 | 2106777.9999 | 37.7638270872907 | -122.50194164610599 | (37.7638270872907, -122.501941646106) | ||
| 29094 | 29094 | 51629 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3100ON LYON ST Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2010 12:00:00 AM | 3 | Permit Number 53623 | 5999225.71389 | 2116662.32922 | 37.79190559512271 | -122.446601580509 | (37.7919055951227, -122.446601580509) | ||
| 29469 | 29469 | 33117 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2699 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000101.0018 | 2118475.17057 | 37.7969331372011 | -122.443703383925 | (37.7969331372011, -122.443703383925) | |
| 30033 | 30033 | 49086 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 696 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | 2 | Permit Number 46236 | 6012080.74961 | 2105187.09966 | 37.7611231504286 | -122.401316072295 | (37.7611231504286, -122.401316072295) | ||
| 30493 | 30493 | 226043 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6003683.45226 | 2095797.6378400002 | 37.7348697950059 | -122.42968901103399 | (37.7348697950059, -122.429689011034) | ||||
| 30586 | 30586 | 33230 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2740 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/2002 12:00:00 AM | 2 | Permit Number 37416 | 6000651.12195 | 2117750.4280000003 | 37.7949745459919 | -122.441747802734 | (37.7949745459919, -122.441747802734) | |
| 30632 | 30632 | 73445 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 900 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 4 | 6007755.78016 | 2114801.18136 | 37.787278888055894 | -122.41695551739201 | (37.7872788880559, -122.416955517392) | ||
| 30917 | 30917 | 34609 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3222 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38294 | 5999276.61013 | 2116016.0035200003 | 37.7901338623233 | -122.44637896321899 | (37.7901338623233, -122.446378963219) | |
| 31104 | 31104 | 31874 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 650 Delancey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 5 | Permit Number 35313 | 6015646.39129 | 2113195.50947 | 37.783310769824794 | -122.389543258739 | (37.7833107698248, -122.389543258739) | ||
| 31105 | 31105 | 46360 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 514 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2004 12:00:00 AM | 2 | Permit Number 44598 | 5988790.17087 | 2111781.3196900003 | 37.7779021128043 | -122.48235038480101 | (37.7779021128043, -122.482350384801) | |
| 31180 | 31180 | 35375 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 724 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38833 | 6010961.80116 | 2104934.52019 | 37.7603671317669 | -122.405168267915 | (37.7603671317669, -122.405168267915) | |
| 31445 | 31445 | 50609 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 307 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2003 12:00:00 AM | 5 | Permit Number 47207 | 5997116.52559 | 2115267.78958 | 37.7879558590154 | -122.45379859043001 | (37.7879558590154, -122.45379859043) | ||
| 31569 | 31569 | 68012 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1137 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 8 | Permit Number 31742 | 6011522.7953699995 | 2119247.92417 | 37.799699755809705 | -122.404235461403 | (37.7996997558097, -122.404235461403) | ||
| 32644 | 32644 | 99898 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2101X Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 768908 | 6004438.52556 | 2116689.23299 | 37.7922758451055 | -122.42856714995101 | (37.7922758451055, -122.428567149951) | |||
| 33123 | 33123 | 68588 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1322 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32489 | 5988666.672 | 2106296.8366 | 37.762836050815395 | -122.482375658001 | (37.7628360508154, -122.482375658001) | ||
| 33621 | 33621 | 102375 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 5983887.37527 | 2110050.4929400003 | 37.7728633493226 | -122.499182686047 | (37.7728633493226, -122.499182686047) | ||||
| 33624 | 33624 | 35590 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2808 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1998 12:00:00 AM | 6 | Permit Number 38953 | 6000039.2737 | 2114426.5269 | 37.7858131029776 | -122.44362598405701 | (37.7858131029776, -122.443625984057) | |
| 33816 | 33816 | 48383 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011710.50026 | 2106657.48632 | 37.7651398392626 | -122.40270002101299 | (37.7651398392626, -122.402700021013) | ||
| 33881 | 33881 | 48373 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011696.05112 | 2106912.09 | 37.7658381169537 | -122.40276790450899 | (37.7658381169537, -122.402767904509) | ||
| 34307 | 34307 | 59035 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3367 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1980 12:00:00 AM | Permit Number 18327; Original species unknown. Removed and replaced without permit in 2000 | 6005902.92482081 | 2103717.90003873 | 37.7567424611364 | -122.42257813887699 | (37.7567424611364, -122.422578138877) | |||
| 34484 | 34484 | 58254 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 588 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | 12 | Permit Number 772841 | 6014358.43843 | 2104381.36252 | 37.759037584827496 | -122.393382076919 | (37.7590375848275, -122.393382076919) | ||
| 34521 | 34521 | 33116 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2699 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000083.684859999 | 2118474.07473 | 37.7969291406212 | -122.44376322569299 | (37.7969291406212, -122.443763225693) | |
| 35534 | 35534 | 31870 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 166 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 1 | Permit Number 35311 | 6000197.09638 | 2104898.61091 | 37.7596608518971 | -122.442395687819 | (37.7596608518971, -122.442395687819) | ||
| 35761 | 35761 | 46083 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 678 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2001 12:00:00 AM | 1 | Permit Number 44461 | 6009646.5972 | 2120203.7861 | 37.8022193006044 | -122.4107953652 | (37.8022193006044, -122.4107953652) | ||
| 35802 | 35802 | 71599 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.45997012143101 | (37.7083363538073, -122.459970121431) | ||
| 36070 | 36070 | 70557 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 20 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 1 | 6004148.34946 | 2093373.6236 | 37.7282403094269 | -122.42790902788 | (37.7282403094269, -122.42790902788) | ||
| 36592 | 36592 | 44200 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015644.9623 | 2115187.5878 | 37.7887804851876 | -122.389687383164 | (37.7887804851876, -122.389687383164) | ||
| 36900 | 36900 | 50869 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2626 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Permit Number 47381 | 6000989.97476 | 2117606.3009599997 | 37.7945981122598 | -122.44056498289301 | (37.7945981122598, -122.440564982893) | |||
| 37727 | 37727 | 84237 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 382-384 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 2 | 5988116.70798 | 2113371.1409 | 37.7822281155783 | -122.484796757861 | (37.7822281155783, -122.484796757861) | ||
| 38026 | 38026 | 68360 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 716 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 2 | Permit Number 32180 | 5990389.00128 | 2110476.58792 | 37.774412551740205 | -122.476724178706 | (37.7744125517402, -122.476724178706) | |
| 38109 | 38109 | 30714 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 111 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 2 | Permit Number 34618 | 6005877.6805 | 2109983.4249 | 37.7739446835862 | -122.423110779148 | (37.7739446835862, -122.423110779148) | |
| 38740 | 38740 | 31479 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 329 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 35045 | 6001505.884980001 | 2103717.19104 | 37.75649147012629 | -122.437784632575 | (37.7564914701263, -122.437784632575) | |
| 39184 | 39184 | 71328 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 228 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 9 | 6004151.959980001 | 2089814.42795 | 37.718467747275795 | -122.427643069565 | (37.7184677472758, -122.427643069565) | ||
| 39620 | 39620 | 124187 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 40 Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5995896.10311 | 2112493.6287599998 | 37.7802687106807 | -122.45782018278999 | (37.7802687106807, -122.45782018279) | ||||
| 39802 | 39802 | 36959 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 27 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 18 | Permit Number 39589 | 5994225.97611 | 2115422.85475 | 37.7882154815281 | -122.463810552441 | (37.7882154815281, -122.463810552441) | |
| 39819 | 39819 | 64940 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2157 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 5 | Permit Number 25969 | 5997552.9152 | 2109862.9805 | 37.77314067902729 | -122.451898696297 | (37.7731406790273, -122.451898696297) | |
| 39888 | 39888 | 102373 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 5983890.730690001 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | ||||
| 40054 | 40054 | 47269 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1463 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 1 | Permit Number 45210 | 5988654.8409 | 2105376.6422 | 37.7603087586576 | -122.482349152365 | (37.7603087586576, -122.482349152365) | |
| 40348 | 40348 | 68689 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 162 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 4 | Permit Number 32599 | 5992138.9687 | 2114381.7472 | 37.7852364025335 | -122.47095530753 | (37.7852364025335, -122.47095530753) | |
| 41003 | 41003 | 100211 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 701 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2012 12:00:00 AM | 1 | Permit Number 769013 | 6011855.60136 | 2105068.89592 | 37.7607860251716 | -122.40208645763799 | (37.7607860251716, -122.402086457638) | ||
| 41672 | 41672 | 81720 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 998 Indiana St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 3 | 6014948.390319999 | 2104075.36829 | 37.758230150117505 | -122.39132033706001 | (37.7582301501175, -122.39132033706) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");