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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69713 | 69713 | 50679 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011906.20035 | 2112760.01525 | 37.781906913717705 | -122.40245227846 | (37.7819069137177, -122.40245227846) | ||
| 69920 | 69920 | 49378 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005189.74904 | 2086240.2488 | 37.7087124637721 | -122.423801855593 | (37.7087124637721, -122.423801855593) | |||
| 70138 | 70138 | 38959 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3186 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | 6 | Permit Number 40754 | 5999542.34025 | 2115724.95595 | 37.7893498954312 | -122.445438624911 | (37.7893498954312, -122.445438624911) | ||
| 71869 | 71869 | 49375 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005207.53082 | 2086275.43702 | 37.708810086982396 | -122.423742899628 | (37.7088100869824, -122.423742899628) | |||
| 72048 | 72048 | 96285 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3237 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011917.425009999 | 2090666.70864 | 37.721244132491606 | -122.40086075544501 | (37.7212441324916, -122.400860755445) | |
| 72529 | 72529 | 56057 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2857 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2012 12:00:00 AM | Permit Number 769384 | 6009126.12851397 | 2103311.62297626 | 37.7558082292146 | -122.41140237591999 | (37.7558082292146, -122.41140237592) | |||
| 74041 | 74041 | 82635 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1363 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52502 | 6016495.7737 | 2093658.9613 | 37.7297145851124 | -122.385242953388 | (37.7297145851124, -122.385242953388) | |
| 75843 | 75843 | 50681 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011867.27865 | 2112722.46624 | 37.7818016399861 | -122.402584289042 | (37.7818016399861, -122.402584289042) | ||
| 76766 | 76766 | 50680 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011881.28809 | 2112735.18958 | 37.7818373574415 | -122.40253671761002 | (37.7818373574415, -122.40253671761) | ||
| 76923 | 76923 | 96282 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3219 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58765 | 6011894.72872 | 2090742.0865599997 | 37.7214498389136 | -122.400944503905 | (37.7214498389136, -122.400944503905) | |
| 76989 | 76989 | 88169 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011742.09911 | 2112601.7739 | 37.781463257472794 | -122.403008862566 | (37.7814632574728, -122.403008862566) | |
| 78053 | 78053 | 28122 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1640 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2005 12:00:00 AM | 6 | 3X3 | 6006494.4461 | 2099888.88551 | 37.746262217205896 | -122.42026068535601 | (37.7462622172059, -122.420260685356) | ||
| 78362 | 78362 | 84892 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 78501 | 78501 | 48548 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 79061 | 79061 | 88150 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 79454 | 79454 | 49231 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 79775 | 79775 | 51960 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3953 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2005 12:00:00 AM | Permit Number 48181 | 6003479.49286747 | 2101832.63497006 | 37.7514289506507 | -122.43082471383002 | (37.7514289506507, -122.43082471383) | |||
| 80273 | 80273 | 48549 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 80390 | 80390 | 91046 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2574 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2008 12:00:00 AM | 3x3 | Permit Number 51958 | 6010972.0 | 2093540.2 | 37.7290813641679 | -122.404330986626 | (37.7290813641679, -122.404330986626) | ||
| 81914 | 81914 | 87428 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 688X McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005853.5155 | 2112100.03893 | 37.7797550282384 | -122.423344866205 | (37.7797550282384, -122.423344866205) | |||
| 81986 | 81986 | 49242 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 82518 | 82518 | 24875 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2559 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 3 | 3x3 | 6010991.150909299 | 2093686.6170284 | 37.7294844648724 | -122.404275081222 | (37.7294844648724, -122.404275081222) | ||
| 83002 | 83002 | 100776 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 83228 | 83228 | 116467 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 83235 | 83235 | 87549 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2895 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 9x3 | 6011453.6953529995 | 2092165.7677830001 | 37.7253343637789 | -122.40256910651001 | (37.7253343637789, -122.40256910651) | |||
| 83551 | 83551 | 28663 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2826 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011313.9934641 | 2092464.2100286998 | 37.7261460240505 | -122.40307302798 | (37.7261460240505, -122.40307302798) | |||
| 83994 | 83994 | 88168 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 366 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675.0 | 2112537.0 | 37.7812816562818 | -122.40323643650801 | (37.7812816562818, -122.403236436508) | ||
| 84055 | 84055 | 100778 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 85504 | 85504 | 116466 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 86826 | 86826 | 29064 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1000X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 03/02/2006 12:00:00 AM | 3 | 3x3 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 87355 | 87355 | 28686 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2955 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011473.964837001 | 2092116.8636216999 | 37.725201214643995 | -122.402495599163 | (37.725201214644, -122.402495599163) | |||
| 87911 | 87911 | 29065 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 88009 | 88009 | 28705 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3028 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2009 12:00:00 AM | 3 | 3X3 | 6011599.0463446 | 2091533.0938880001 | 37.7236052850781 | -122.40202218213498 | (37.7236052850781, -122.402022182135) | ||
| 88800 | 88800 | 116464 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 89006 | 89006 | 85376 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2601X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009781.5092319995 | 2102185.131738 | 37.752751873221 | -122.409056366206 | (37.752751873221, -122.409056366206) | |||
| 90255 | 90255 | 1204 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3101X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 90357 | 90357 | 96783 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 91672 | 91672 | 24886 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2750 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2X2 | 6011218.493881401 | 2092777.6374656002 | 37.727001297273205 | -122.403425206874 | (37.7270012972732, -122.403425206874) | |||
| 91946 | 91946 | 84890 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 92136 | 92136 | 28684 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2961 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6011474.8425665 | 2092113.9713098 | 37.725193321952894 | -122.402492361636 | (37.7251933219529, -122.402492361636) | |||
| 93119 | 93119 | 1205 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3101X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 93788 | 93788 | 96781 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 94543 | 94543 | 8241 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 95494 | 95494 | 1203 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3111X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 96231 | 96231 | 100775 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 96505 | 96505 | 101990 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 96690 | 96690 | 88153 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 97849 | 97849 | 84895 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 98797 | 98797 | 84896 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 99081 | 99081 | 49229 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 99224 | 99224 | 116470 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 99260 | 99260 | 60333 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 4051 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1982 12:00:00 AM | Permit Number 19906 | 6002674.88696195 | 2104708.78701715 | 37.7592805573459 | -122.433812685394 | (37.7592805573459, -122.433812685394) | |||
| 99509 | 99509 | 49215 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 100125 | 100125 | 94790 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1985 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | Permit Number 53888 | 5993755.4 | 2101986.9 | 37.751296778417 | -122.464462718314 | (37.751296778417, -122.464462718314) | |||
| 100649 | 100649 | 84893 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 100904 | 100904 | 88193 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 364 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51197 | 6011427.8 | 2112687.4 | 37.781680810769295 | -122.40410221959 | (37.7816808107693, -122.40410221959) | ||
| 101129 | 101129 | 100774 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 101153 | 101153 | 100779 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 101439 | 101439 | 14797 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1135 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | 0 | 4X4 | 6003741.3117055 | 2111761.9657456 | 37.77870732769679 | -122.43062777021099 | (37.7787073276968, -122.430627770211) | ||
| 101619 | 101619 | 8243 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 101818 | 101818 | 116469 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 102214 | 102214 | 88176 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 366 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675.0 | 2112537.0 | 37.7812816562818 | -122.40323643650801 | (37.7812816562818, -122.403236436508) | ||
| 103316 | 103316 | 87277 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2417 Bryant St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2008 12:00:00 AM | 3x3 | Permit Number 50297 | 6009714.0 | 2103272.0 | 37.7557323884753 | -122.409366521735 | (37.7557323884753, -122.409366521735) | |||
| 103382 | 103382 | 64005 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 443 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | 5x9 | Permit Number 24752 | 6002309.37367781 | 2100887.25267027 | 37.7487667887863 | -122.434803521117 | (37.7487667887863, -122.434803521117) | |
| 103568 | 103568 | 24842 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 200X Alemany Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 3 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 103670 | 103670 | 46480 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 425 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2002 12:00:00 AM | Permit Number 44673 | 6005932.49263568 | 2107829.56696454 | 37.7680337988036 | -122.42276807616501 | (37.7680337988036, -122.422768076165) | |||
| 103876 | 103876 | 94416 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 105171 | 105171 | 116465 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 105474 | 105474 | 87551 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3195 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6011859.438328 | 2090836.432048 | 37.7217069237885 | -122.401073119638 | (37.7217069237885, -122.401073119638) | ||||
| 106147 | 106147 | 96782 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 106998 | 106998 | 92755 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 108123 | 108123 | 49228 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 108199 | 108199 | 84894 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 108943 | 108943 | 88154 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 108969 | 108969 | 100773 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 109224 | 109224 | 48551 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 109241 | 109241 | 14667 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 716 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | ||
| 111076 | 111076 | 84891 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 113409 | 113409 | 104203 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3135 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | |
| 113872 | 113872 | 14858 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1365 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3x3 | 6002643.52073 | 2111588.23646 | 37.778168057391206 | -122.434413027102 | (37.7781680573912, -122.434413027102) | ||
| 113978 | 113978 | 29066 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 114320 | 114320 | 24838 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 200X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 6 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 114525 | 114525 | 101994 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 115363 | 115363 | 88192 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 364 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51197 | 6011427.8 | 2112687.4 | 37.781680810769295 | -122.40410221959 | (37.7816808107693, -122.40410221959) | ||
| 116267 | 116267 | 85375 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2601X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009781.5092319995 | 2102185.131738 | 37.752751873221 | -122.409056366206 | (37.752751873221, -122.409056366206) | |||
| 116745 | 116745 | 87547 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2713 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x3 | 6011213.1328839995 | 2092950.939207 | 37.7274768484357 | -122.40345592690399 | (37.7274768484357, -122.403455926904) | |||
| 117398 | 117398 | 28123 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1640 Valencia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2005 12:00:00 AM | 6 | 3X3 | 6006494.4461 | 2099888.88551 | 37.746262217205896 | -122.42026068535601 | (37.7462622172059, -122.420260685356) | ||
| 117985 | 117985 | 100777 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 4x3 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 119759 | 119759 | 94415 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 120312 | 120312 | 1128 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2525 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 5998741.2887 | 2088615.01895 | 37.7148669056281 | -122.446259214537 | (37.7148669056281, -122.446259214537) | ||
| 122078 | 122078 | 24846 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 200X Alemany Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/29/1998 12:00:00 AM | 3 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 122108 | 122108 | 101992 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 122330 | 122330 | 104202 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3135 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | |
| 122354 | 122354 | 84887 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 123177 | 123177 | 6288 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 124823 | 124823 | 92756 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 125610 | 125610 | 48550 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 127098 | 127098 | 84889 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 127194 | 127194 | 101993 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 127570 | 127570 | 28674 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3130 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x3 | 6011742.0620525 | 2091064.4440916001 | 37.7223264497375 | -122.401494877675 | (37.7223264497375, -122.401494877675) |
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");