Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9310 | 9310 | 26227 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9326 | 9326 | 26258 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1530 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005847.527000001 | 2100032.50262 | 37.746620083181796 | -122.42250785943199 | (37.7466200831818, -122.422507859432) | |||
| 9328 | 9328 | 10963 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1431 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | ||
| 9331 | 9331 | 26267 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700X San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005755.6616802 | 2099067.9825513 | 37.7439665475249 | -122.422756987055 | (37.7439665475249, -122.422756987055) | |||
| 9333 | 9333 | 26225 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9340 | 9340 | 26223 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2009 12:00:00 AM | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | ||
| 9350 | 9350 | 72948 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 510 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1999 12:00:00 AM | 3 | 6004536.11910305 | 2110188.83574422 | 37.7744328940259 | -122.427766104146 | (37.7744328940259, -122.427766104146) | |||
| 9351 | 9351 | 29078 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2265 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 4 | 3x3 | 6009683.3465759 | 2104161.2014379 | 37.758172218127704 | -122.40953528653 | (37.7581722181277, -122.40953528653) | ||
| 9380 | 9380 | 12155 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016212.874009999 | 2095683.59001 | 37.7352581567374 | -122.38636208157301 | (37.7352581567374, -122.386362081573) | ||
| 9384 | 9384 | 26268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700X San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6005755.6616802 | 2099067.9825513 | 37.7439665475249 | -122.422756987055 | (37.7439665475249, -122.422756987055) | |||
| 9394 | 9394 | 19116 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 507X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2001 12:00:00 AM | 20 | 3X3 | 6003392.0492998 | 2108320.088346 | 37.769236987964604 | -122.431590213757 | (37.7692369879646, -122.431590213757) | ||
| 9404 | 9404 | 26230 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9416 | 9416 | 2543 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1580 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6016211.0400559995 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | |||
| 9439 | 9439 | 995 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1682 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6001498.326169999 | 2092340.4216099998 | 37.725253096867206 | -122.436996309494 | (37.7252530968672, -122.436996309494) | ||
| 9462 | 9462 | 26266 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005755.6616802 | 2099067.9825513 | 37.7439665475249 | -122.422756987055 | (37.7439665475249, -122.422756987055) | |||
| 9484 | 9484 | 29081 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2230 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 6 | 3x3 | 6009630.0 | 2104353.0 | 37.7586958643533 | -122.409733320805 | (37.7586958643533, -122.409733320805) | ||
| 9487 | 9487 | 2233 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1217 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1993 12:00:00 AM | 9 | 4X4 | 6000793.5299 | 2112868.6894 | 37.781578670102704 | -122.440904680944 | (37.7815786701027, -122.440904680944) | ||
| 9496 | 9496 | 19512 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6000653.0003 | 2112676.212 | 37.781042171769705 | -122.441377029637 | (37.7810421717697, -122.441377029637) | |||
| 9509 | 9509 | 105278 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 568-570 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6x9 | Permit Number 771026 | 6002982.0 | 2104934.0 | 37.7599163606325 | -122.43276662907101 | (37.7599163606325, -122.432766629071) | ||
| 9535 | 9535 | 36839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9540 | 9540 | 26551 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 90X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6000745.8124 | 2112342.7819 | 37.780131944670295 | -122.441032019327 | (37.7801319446703, -122.441032019327) | |||
| 9547 | 9547 | 68821 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 770629 | 5999450.20473491 | 2094083.18160524 | 37.7299216843992 | -122.44420161479799 | (37.7299216843992, -122.444201614798) | ||
| 9548 | 9548 | 22798 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 16 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6000767.4714 | 2112175.6015 | 37.7796741435255 | -122.440945094511 | (37.7796741435255, -122.440945094511) | |||
| 9560 | 9560 | 19503 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 90X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6000748.1814 | 2112325.5224 | 37.78008468941729 | -122.441022585328 | (37.7800846894173, -122.441022585328) | |||
| 9582 | 9582 | 105279 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 568-570 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6x9 | Permit Number 771026 | 6002982.0 | 2104934.0 | 37.7599163606325 | -122.43276662907101 | (37.7599163606325, -122.432766629071) | ||
| 9660 | 9660 | 87030 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49973 | 6006766.5 | 2109389.9 | 37.7723651233427 | -122.419994070446 | (37.7723651233427, -122.419994070446) | |
| 9877 | 9877 | 28444 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1995 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5993681.5609 | 2092723.2933 | 37.725856971051 | -122.464045665001 | (37.725856971051, -122.464045665001) | ||
| 10142 | 10142 | 10120 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 851 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X3 | 6005704.55717 | 2103950.70668 | 37.7573705007718 | -122.42328071642599 | (37.7573705007718, -122.423280716426) | ||
| 10296 | 10296 | 15853 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5318 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1995 12:00:00 AM | 6 | 3x3 | 5999670.30739 | 2088411.8860799999 | 37.7143621622611 | -122.44303356793999 | (37.7143621622611, -122.44303356794) | ||
| 10359 | 10359 | 26782 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6010979.6007 | 2087065.0465 | 37.711302344066 | -122.403849252944 | (37.711302344066, -122.403849252944) | ||||
| 10473 | 10473 | 15795 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4929 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1995 12:00:00 AM | 6 | 3x3 | 6000991.1672 | 2090255.6537 | 37.7194999571484 | -122.438600194662 | (37.7194999571484, -122.438600194662) | ||
| 10490 | 10490 | 67643 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 92 Del Monte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1992 12:00:00 AM | 9 | 3x3 | Permit Number 31242 | 5999452.95797 | 2088894.8093 | 37.715675765098794 | -122.44381948549601 | (37.7156757650988, -122.443819485496) | |
| 10523 | 10523 | 15830 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5169 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2007 12:00:00 AM | 3 | 3X3 | 6000193.89224 | 2088987.9069599998 | 37.715973625047205 | -122.44126516177 | (37.7159736250472, -122.44126516177) | ||
| 10589 | 10589 | 15891 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5630 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1995 12:00:00 AM | 3 | 3x3 | 5998430.505059999 | 2087245.52015 | 37.711088819775895 | -122.44723490289499 | (37.7110888197759, -122.447234902895) | ||
| 10635 | 10635 | 37208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1890 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | 3X3 | Permit Number 39774 | 5986318.0892 | 2102397.4434 | 37.751992489797004 | -122.49021162161101 | (37.751992489797, -122.490211621611) |
| 10683 | 10683 | 15723 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4374 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1995 12:00:00 AM | 6 | 3X3 | 6002783.0002 | 2093176.1526 | 37.7276207625859 | -122.432614991581 | (37.7276207625859, -122.432614991581) | ||
| 10686 | 10686 | 15870 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5440 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1995 12:00:00 AM | 6 | 3x3 | 5999309.23485 | 2088003.6513200002 | 37.7132206482771 | -122.44425225454701 | (37.7132206482771, -122.444252254547) | ||
| 10689 | 10689 | 44737 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 220 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 10 | Permit Number 43854 | 5992028.1183 | 2086972.4785799999 | 37.7099712034746 | -122.469343044645 | (37.7099712034746, -122.469343044645) | |
| 10820 | 10820 | 15852 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5312 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1995 12:00:00 AM | 6 | 3x3 | 5999685.48283 | 2088430.99674 | 37.714415501058 | -122.44298248737499 | (37.714415501058, -122.442982487375) | ||
| 10844 | 10844 | 43316 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 263 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51344 | 6004441.12036 | 2091738.6459 | 37.7237675806909 | -122.426780519916 | (37.7237675806909, -122.426780519916) | |
| 10882 | 10882 | 15832 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5172 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000113.1533 | 2088967.78634 | 37.7159137787676 | -122.441542789662 | (37.7159137787676, -122.441542789662) | |||
| 10923 | 10923 | 108952 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2912 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769302 | 5990002.93775 | 2095864.20098 | 37.7342684111434 | -122.47699167433399 | (37.7342684111434, -122.476991674334) |
| 10943 | 10943 | 117432 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776914 | 6001483.3943300005 | 2089635.3140599998 | 37.717824632186705 | -122.436854363943 | (37.7178246321867, -122.436854363943) | ||
| 10959 | 10959 | 15698 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4224 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1995 12:00:00 AM | 8 | 3X3 | 6003399.48593 | 2093901.3092900002 | 37.729646822132004 | -122.43053551500799 | (37.729646822132, -122.430535515008) | ||
| 11038 | 11038 | 15861 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5365 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3x3 | 5999617.74229 | 2088257.5708 | 37.71393545013021 | -122.443204176537 | (37.7139354501302, -122.443204176537) | ||
| 11067 | 11067 | 1190 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3034 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5996528.95527 | 2087256.53034 | 37.7110102136125 | -122.45380787863199 | (37.7110102136125, -122.453807878632) | ||
| 11131 | 11131 | 39203 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3073X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996355.3852 | 2087072.36701 | 37.7104945909167 | -122.454394480343 | (37.7104945909167, -122.454394480343) | |
| 11142 | 11142 | 15834 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5199X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000075.39694 | 2088803.4795400002 | 37.715460478198295 | -122.44166150827299 | (37.7154604781983, -122.441661508273) | |||
| 11154 | 11154 | 25432 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2436 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 3 | 3X3 | 6010891.05193 | 2086887.1809599998 | 37.7108090136865 | -122.404142791654 | (37.7108090136865, -122.404142791654) | ||
| 11208 | 11208 | 15921 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5718 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1999 12:00:00 AM | 3 | 3X3 | 5997690.80196 | 2086825.40786 | 37.7098929930475 | -122.44976122890499 | (37.7098929930475, -122.449761228905) | ||
| 11213 | 11213 | 893 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1162X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1997 12:00:00 AM | 8 | 3X6 | 6003397.35641 | 2094349.3863099997 | 37.730877020048 | -122.430574836985 | (37.730877020048, -122.430574836985) | ||
| 11225 | 11225 | 952 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | 6002047.349219999 | 2093382.65925 | 37.7281460362049 | -122.435172906015 | (37.7281460362049, -122.435172906015) | |||
| 11248 | 11248 | 15879 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5530 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5998998.87256 | 2087652.2430599998 | 37.712238049012896 | -122.44529971831601 | (37.7122380490129, -122.445299718316) | ||
| 11291 | 11291 | 15833 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5173 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1992 12:00:00 AM | 6 | 3x3 | 6000184.12065 | 2088972.8048900003 | 37.71593160152771 | -122.441297853914 | (37.7159316015277, -122.441297853914) | ||
| 11297 | 11297 | 95009 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 151 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010165.2261 | 2087437.3639 | 37.712279121941 | -122.40669017224899 | (37.712279121941, -122.406690172249) | ||||
| 11310 | 11310 | 15873 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5455 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999368.29855 | 2087974.0106400002 | 37.713142631210395 | -122.444045982438 | (37.7131426312104, -122.444045982438) | ||
| 11340 | 11340 | 237 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3007 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990538.44703 | 2095140.6475 | 37.732312768812896 | -122.47508746420799 | (37.7323127688129, -122.475087464208) | ||
| 11370 | 11370 | 39202 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2188 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996345.10254 | 2087018.18263 | 37.7103452234142 | -122.454426107682 | (37.7103452234142, -122.454426107682) | |
| 11380 | 11380 | 928 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1285 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1992 12:00:00 AM | 10 | 3X4 | 6002746.05074 | 2094024.26586 | 37.729947394457604 | -122.432803287742 | (37.7299473944576, -122.432803287742) | ||
| 11424 | 11424 | 15909 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5672 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5998073.09723 | 2087015.06883 | 37.7104356241859 | -122.448453600256 | (37.7104356241859, -122.448453600256) | ||
| 11452 | 11452 | 39206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3073X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996317.12895 | 2087059.6351599998 | 37.7104574381327 | -122.454525782264 | (37.7104574381327, -122.454525782264) | |
| 11472 | 11472 | 15829 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5163 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000211.93935 | 2089017.25913 | 37.7160552475202 | -122.441204887393 | (37.7160552475202, -122.441204887393) | |||
| 11521 | 11521 | 15847 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5259 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999845.39601 | 2088516.8586799998 | 37.7146603747428 | -122.442435926184 | (37.7146603747428, -122.442435926184) | ||
| 11552 | 11552 | 1195 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3062-3062 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 8 | 3x3 | 5996475.62372 | 2087226.6805900002 | 37.710925195309294 | -122.453990049815 | (37.7109251953093, -122.453990049815) | ||
| 11556 | 11556 | 15959 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5865 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997123.14276 | 2086529.76075 | 37.7090487194007 | -122.45170184265899 | (37.7090487194007, -122.451701842659) | ||
| 11586 | 11586 | 15945 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5805 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997438.4638 | 2086653.8674299999 | 37.7094075417074 | -122.450620993373 | (37.7094075417074, -122.450620993373) | ||
| 11654 | 11654 | 81227 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1206 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50169 | 5981508.8658 | 2106840.309 | 37.7639092979165 | -122.50717188863001 | (37.7639092979165, -122.50717188863) | |
| 11655 | 11655 | 15767 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4773 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2000 12:00:00 AM | 12 | 3x3 | 6001546.826 | 2091137.701 | 37.721953454565394 | -122.43674259522801 | (37.7219534545654, -122.436742595228) | ||
| 11711 | 11711 | 1236 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3702X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5993199.6595 | 2087639.3681700001 | 37.711869955605394 | -122.465342418633 | (37.7118699556054, -122.465342418633) | ||
| 11756 | 11756 | 66531 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3712 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51731 | 5984484.0259 | 2098196.2697 | 37.740349933336795 | -122.496244041207 | (37.7403499333368, -122.496244041207) | |
| 11761 | 11761 | 15695 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4218 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1995 12:00:00 AM | 6 | 3X3 | 6003413.60816 | 2093919.54954 | 37.7296977057651 | -122.43048799395001 | (37.7296977057651, -122.43048799395) | ||
| 11768 | 11768 | 15855 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5323 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999648.00788 | 2088291.6735200002 | 37.7140308142474 | -122.44310201534799 | (37.7140308142474, -122.443102015348) | ||
| 11813 | 11813 | 15849 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5268 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1995 12:00:00 AM | 6 | 3X3 | 5999862.61335 | 2088620.10475 | 37.7149448465141 | -122.442383823979 | (37.7149448465141, -122.442383823979) | ||
| 11823 | 11823 | 15739 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4519 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6002428.302 | 2092537.6524 | 37.7258474635465 | -122.433795568906 | (37.7258474635465, -122.433795568906) | ||
| 11834 | 11834 | 15858 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5360 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2009 12:00:00 AM | 3 | 3X3 | 5999561.44324 | 2088284.73015 | 37.7140068131504 | -122.443400716192 | (37.7140068131504, -122.443400716192) | ||
| 11913 | 11913 | 108546 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 174 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773708 | 6002822.5324 | 2094312.8770599999 | 37.7307441928912 | -122.432559488737 | (37.7307441928912, -122.432559488737) |
| 11958 | 11958 | 47795 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2534 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778248 | 5985848.7969 | 2097974.9667 | 37.739822144816706 | -122.49150898506001 | (37.7398221448167, -122.49150898506) | |
| 11967 | 11967 | 15840 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5233 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999921.34748 | 2088601.8147599997 | 37.714897973849396 | -122.44217950248999 | (37.7148979738494, -122.44217950249) | |||
| 12004 | 12004 | 97326 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1111 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 1 | 3x3 | 5989724.8526 | 2098996.695 | 37.742853294666205 | -122.47818204792 | (37.7428532946662, -122.47818204792) | ||
| 12014 | 12014 | 15839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5216 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1995 12:00:00 AM | 3 | 3X3 | 5999984.68408 | 2088776.8021200001 | 37.7153820591231 | -122.441973137768 | (37.7153820591231, -122.441973137768) | ||
| 12023 | 12023 | 95021 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010652.9596 | 2087185.8102 | 37.711615683002 | -122.404986710459 | (37.711615683002, -122.404986710459) | ||||
| 12030 | 12030 | 1064 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2073X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1992 12:00:00 AM | 12 | 3X3 | 6000384.95261 | 2090073.81885 | 37.7189661758191 | -122.44068261512399 | (37.7189661758191, -122.440682615124) | ||
| 12064 | 12064 | 15864 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5400 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2011 12:00:00 AM | 3 | 3X3 | 5999414.86316 | 2088124.28098 | 37.7135578958457 | -122.44389582982402 | (37.7135578958457, -122.443895829824) | ||
| 12091 | 12091 | 39208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3073X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996328.55685 | 2087062.4339700001 | 37.7104657784446 | -122.45448648728001 | (37.7104657784446, -122.45448648728) | |
| 12094 | 12094 | 15685 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4180 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1995 12:00:00 AM | 6 | 3X3 | 6003576.06888 | 2094116.67673 | 37.7302481745086 | -122.42994040572201 | (37.7302481745086, -122.429940405722) | ||
| 12189 | 12189 | 15865 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5425 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2011 12:00:00 AM | 3 | 3X3 | 5999446.659440001 | 2088060.9774900002 | 37.7133858924291 | -122.443781385728 | (37.7133858924291, -122.443781385728) | ||
| 12208 | 12208 | 95022 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 45 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010735.1769 | 2087146.3726 | 37.7115119909256 | -122.404699769405 | (37.7115119909256, -122.404699769405) | ||||
| 12218 | 12218 | 246 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3039 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990544.75562 | 2094979.28403 | 37.7318700712305 | -122.47505387905599 | (37.7318700712305, -122.475053879056) | ||
| 12285 | 12285 | 15700 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4234 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1995 12:00:00 AM | 6 | 3X3 | 6003362.14179 | 2093854.2762099998 | 37.7295155642727 | -122.43066126271201 | (37.7295155642727, -122.430661262712) | ||
| 12290 | 12290 | 39207 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3073X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996341.69967 | 2087067.68226 | 37.7104809428024 | -122.454441442017 | (37.7104809428024, -122.454441442017) | |
| 12320 | 12320 | 15869 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5440 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1995 12:00:00 AM | 6 | 3x3 | 5999342.986819999 | 2088043.22045 | 37.713331221735295 | -122.444138438145 | (37.7133312217353, -122.444138438145) | ||
| 12325 | 12325 | 26787 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 58 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 3 | 6010687.7182 | 2087215.2212 | 37.711698382632605 | -122.404868644189 | (37.7116983826326, -122.404868644189) | |||
| 12334 | 12334 | 15721 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4372 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2011 12:00:00 AM | 3 | 3x3 | 6002806.603999999 | 2093197.3146 | 37.7276802072309 | -122.432534903957 | (37.7276802072309, -122.432534903957) | ||
| 12346 | 12346 | 46852 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 450 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 773811 | 6003293.98042 | 2090989.1519900002 | 37.7216447112248 | -122.43069253035101 | (37.7216447112248, -122.430692530351) | |
| 12411 | 12411 | 15844 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5253 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3x3 | 5999859.35284 | 2088534.2286900003 | 37.7147088643879 | -122.44238893209999 | (37.7147088643879, -122.4423889321) | ||
| 12413 | 12413 | 1191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3044 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 12 | 3X3 | 5996503.24503 | 2087241.9631400001 | 37.710968741375105 | -122.45389568755199 | (37.7109687413751, -122.453895687552) | ||
| 12441 | 12441 | 109572 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003097.99881 | 2091486.06514 | 37.72299801913329 | -122.431405440927 | (37.7229980191333, -122.431405440927) |
| 12460 | 12460 | 95000 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 160 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 9x15 | 6010171.1456 | 2087482.6157 | 37.712403705394 | -122.40667289956998 | (37.712403705394, -122.40667289957) | |||
| 12472 | 12472 | 15726 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4388 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1995 12:00:00 AM | 6 | 3X3 | 6002722.77 | 2093108.5971 | 37.7274318545278 | -122.432818383885 | (37.7274318545278, -122.432818383885) | ||
| 12482 | 12482 | 15886 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5615 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 12 | 3X3 | 5998604.59645 | 2087281.1195099999 | 37.7111965135701 | -122.446635762852 | (37.7111965135701, -122.446635762852) |
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");