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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7799 | 7799 | 36854 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9099 | 9099 | 36836 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 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 | |||||||||
| 13906 | 13906 | 36837 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15723 | 15723 | 36838 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16572 | 16572 | 36840 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 78340 | 78340 | 38765 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | ||||
| 88580 | 88580 | 38767 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | ||||
| 89240 | 89240 | 38763 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | ||||
| 112711 | 112711 | 38766 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | ||||
| 125029 | 125029 | 38764 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | ||||
| 114410 | 114410 | 37147 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.42142816381799 | (37.7471576573064, -122.421428163818) | ||
| 122248 | 122248 | 37149 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.42142816381799 | (37.7471576573064, -122.421428163818) | ||
| 145907 | 145907 | 37148 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 27th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.42142816381799 | (37.7471576573064, -122.421428163818) | ||
| 117708 | 117708 | 36932 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/2003 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | ||
| 142370 | 142370 | 36933 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | ||
| 145075 | 145075 | 36931 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | ||
| 32239 | 32239 | 68739 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1993 12:00:00 AM | 8 | Permit Number 32659 | 5997216.23373 | 2086785.97531 | 37.709757556936495 | -122.45139857511101 | (37.7097575569365, -122.451398575111) | ||
| 30093 | 30093 | 30664 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006594.41261 | 2109123.24947 | 37.7716232677391 | -122.420570406196 | (37.7716232677391, -122.420570406196) | |
| 56201 | 56201 | 30662 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006559.28152 | 2109117.66624 | 37.771605957578394 | -122.42069153050801 | (37.7716059575784, -122.420691530508) | |
| 113758 | 113758 | 30668 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 141337 | 141337 | 30667 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 168897 | 168897 | 30669 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006474.54027 | 2109116.5589 | 37.7715981406638 | -122.42098457729999 | (37.7715981406638, -122.4209845773) | |
| 177721 | 177721 | 30663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006564.909030001 | 2109121.1634 | 37.7716158771129 | -122.420672312891 | (37.7716158771129, -122.420672312891) | |
| 98645 | 98645 | 91174 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2008 12:00:00 AM | 3X3 | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | ||
| 104332 | 104332 | 91175 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |||
| 131697 | 131697 | 84175 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50693 | 6010501.10356 | 2090044.1422599999 | 37.7194555904939 | -122.405712770528 | (37.7194555904939, -122.405712770528) | |
| 62981 | 62981 | 56298 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 7 | Permit Number 32247 | 5993056.25051 | 2114776.86302 | 37.7863742905451 | -122.467810568951 | (37.7863742905451, -122.467810568951) | |
| 94536 | 94536 | 36309 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 96299 | 96299 | 36312 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 113904 | 113904 | 36310 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 142467 | 142467 | 36308 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 145414 | 145414 | 36311 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 54271 | 54271 | 82877 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52475 | 6010467.51259 | 2094188.12138 | 37.730832215827 | -122.406120676945 | (37.730832215827, -122.406120676945) | |
| 117282 | 117282 | 82874 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Girard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52475 | 6010457.79461314 | 2094219.31159395 | 37.730917314013 | -122.40615647032601 | (37.730917314013, -122.406156470326) | ||
| 119559 | 119559 | 82873 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Girard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52475 | 6010457.79461314 | 2094219.31159395 | 37.730917314013 | -122.40615647032601 | (37.730917314013, -122.406156470326) | ||
| 125257 | 125257 | 82875 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Girard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52475 | 6010457.79461314 | 2094219.31159395 | 37.730917314013 | -122.40615647032601 | (37.730917314013, -122.406156470326) | ||
| 125487 | 125487 | 82876 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52475 | 6010457.79461314 | 2094219.31159395 | 37.730917314013 | -122.40615647032601 | (37.730917314013, -122.406156470326) | ||
| 9282 | 9282 | 14446 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2012 12:00:00 AM | 3 | 3x3 | 5998938.7246 | 2112487.711 | 37.780426790070706 | -122.44729396725201 | (37.7804267900707, -122.447293967252) | ||
| 21616 | 21616 | 25457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/10/1997 12:00:00 AM | 6 | 3X3 | 5993681.7949 | 2088543.8714 | 37.7143812997511 | -122.463741645146 | (37.7143812997511, -122.463741645146) | ||
| 21638 | 21638 | 18577 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/12/1998 12:00:00 AM | 6 | 3X3 | 5993712.2633 | 2088544.8235 | 37.7143856696584 | -122.46363640417201 | (37.7143856696584, -122.463636404172) | ||
| 87998 | 87998 | 78960 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50072 | 6007769.24409179 | 2106089.05083821 | 37.7633582084166 | -122.41629164267599 | (37.7633582084166, -122.416291642676) | |
| 91659 | 91659 | 87769 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Chenery St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50473 | 6000787.0 | 2096209.0 | 37.7358348629687 | -122.439732514448 | (37.7358348629687, -122.439732514448) | |||
| 17015 | 17015 | 17008 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2006 12:00:00 AM | 3 | 3x3 | 6002174.9677 | 2109860.4544 | 37.7733973919924 | -122.435910261161 | (37.7733973919924, -122.435910261161) | ||
| 134966 | 134966 | 63038 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1986 12:00:00 AM | 7 | Permit Number 23508 | 6007306.538930001 | 2114741.30314 | 37.7870891967428 | -122.41850555290002 | (37.7870891967428, -122.4185055529) | |
| 169515 | 169515 | 52021 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2005 12:00:00 AM | 3 | Permit Number 48237 | 6009039.147580001 | 2115969.08388 | 37.7905577721826 | -122.412597913578 | (37.7905577721826, -122.412597913578) | ||
| 7925 | 7925 | 22616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | |||
| 106939 | 106939 | 83172 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52725 | 5993010.18342246 | 2098349.46528224 | 37.74126632336 | -122.46677535093599 | (37.74126632336, -122.466775350936) | ||
| 15948 | 15948 | 101850 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001X Rhode Island St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 2 | 3x3 | Permit Number 774983 | 6011937.4679 | 2103668.00433 | 37.7569440557359 | -122.401704847401 | (37.7569440557359, -122.401704847401) | |
| 37305 | 37305 | 31761 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35247 | 5990066.9971 | 2099007.5245 | 37.7429028843685 | -122.47699981190901 | (37.7429028843685, -122.476999811909) | |
| 37903 | 37903 | 31762 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35247 | 5990024.3559 | 2099006.1709 | 37.7428966939048 | -122.477147152853 | (37.7428966939048, -122.477147152853) | |
| 180419 | 180419 | 97315 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35247 | 5990088.3176 | 2099007.1861 | 37.7429031920496 | -122.476926067611 | (37.7429031920496, -122.476926067611) | ||
| 102497 | 102497 | 32364 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36916 | 6005767.33287279 | 2099031.81897703 | 37.743867909048205 | -122.422714061246 | (37.7438679090482, -122.422714061246) | |||
| 127405 | 127405 | 32365 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36916 | 6005767.33287279 | 2099031.81897703 | 37.743867909048205 | -122.422714061246 | (37.7438679090482, -122.422714061246) | |||
| 86968 | 86968 | 60636 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1991 12:00:00 AM | 3x3 | Permit Number 29895 | 6004821.44439287 | 2097233.75118826 | 37.738877411473105 | -122.42585676358601 | (37.7388774114731, -122.425856763586) | |
| 141734 | 141734 | 112979 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Fairmount St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6004821.44439287 | 2097233.75118826 | 37.738877411473105 | -122.42585676358601 | (37.7388774114731, -122.425856763586) | |||
| 144971 | 144971 | 112978 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Fairmount St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6004821.44439287 | 2097233.75118826 | 37.738877411473105 | -122.42585676358601 | (37.7388774114731, -122.425856763586) | |||
| 82924 | 82924 | 32545 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 83121 | 83121 | 32550 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 86753 | 86753 | 32544 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 90973 | 90973 | 32551 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 103567 | 103567 | 32552 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 113135 | 113135 | 32553 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 35520 | 35520 | 59616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1011 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2011 12:00:00 AM | 2 | Permit Number 767194 | 6015550.11535 | 2104384.66837 | 37.7591127987462 | -122.389260889583 | (37.7591127987462, -122.389260889583) | ||
| 122325 | 122325 | 42193 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1016 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42470 | 6010410.48288619 | 2109291.59089856 | 37.772299817533 | -122.407382201369 | (37.772299817533, -122.407382201369) | ||
| 123581 | 123581 | 42194 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1016 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42470 | 6010410.48288619 | 2109291.59089856 | 37.772299817533 | -122.407382201369 | (37.772299817533, -122.407382201369) | ||
| 86392 | 86392 | 31763 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35248 | 5990018.1797 | 2099070.5556 | 37.7430731192473 | -122.477173212243 | (37.7430731192473, -122.477173212243) | |
| 88740 | 88740 | 31764 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35248 | 5990072.01927063 | 2099066.23490799 | 37.7430643792619 | -122.476986735886 | (37.7430643792619, -122.476986735886) | ||
| 43466 | 43466 | 61653 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2015 12:00:00 AM | 1 | Permit Number 773687 | 5993009.87039 | 2114787.90553 | 37.7864019320171 | -122.467971834489 | (37.7864019320171, -122.467971834489) | |
| 106370 | 106370 | 41975 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X NORTHGATE DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51393 | 5994409.0 | 2094096.0 | 37.7296679875594 | -122.461630458557 | (37.7296679875594, -122.461630458557) | ||
| 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) | |||
| 86160 | 86160 | 49033 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1026 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51460 | 6003769.51621429 | 2102291.73865454 | 37.7527059694214 | -122.429854522688 | (37.7527059694214, -122.429854522688) | ||
| 179341 | 179341 | 32366 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 103 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 5 | Permit Number 36916 | 6005686.90758 | 2099028.442 | 37.7438540987038 | -122.422991913571 | (37.7438540987038, -122.422991913571) | ||
| 145472 | 145472 | 38184 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 103 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2013 12:00:00 AM | Permit Number 769585 | 6011280.82748459 | 2091572.16346792 | 37.7236947961561 | -122.403124961994 | (37.7236947961561, -122.403124961994) | ||
| 17304 | 17304 | 17016 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1030 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2014 10:45:00 AM | 3 | 3x3 | 6002064.7067 | 2109844.0931 | 37.7733462037226 | -122.436290497808 | (37.7733462037226, -122.436290497808) | ||
| 159628 | 159628 | 52470 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1030@ 11th AVE Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51589 | 5992346.66414 | 2111391.66807 | 37.777038472757 | -122.470018958474 | (37.777038472757, -122.470018958474) | |
| 132162 | 132162 | 67370 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1033 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | 2 | Permit Number 30863 | 5992388.573530001 | 2110655.28285 | 37.7750189809249 | -122.46982035623199 | (37.7750189809249, -122.469820356232) | |
| 155654 | 155654 | 82866 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1034 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52362 | 6013991.3555 | 2090013.1137 | 37.7195649546626 | -122.393645991886 | (37.7195649546626, -122.393645991886) | |
| 20520 | 20520 | 10173 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1037 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X3 | 6005774.28865 | 2102689.4092599996 | 37.75391120633721 | -122.422949914307 | (37.7539112063372, -122.422949914307) | ||
| 17919 | 17919 | 28633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1039 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 3 | 3X3 | 5996629.3483 | 2091727.1978 | 37.7232913778043 | -122.45378352969401 | (37.7232913778043, -122.453783529694) | ||
| 146929 | 146929 | 42195 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1045 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42471 | 6010370.94214 | 2109173.76071 | 37.771974069876705 | -122.407510668177 | (37.7719740698767, -122.407510668177) | |
| 8662 | 8662 | 52583 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1047 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2006 12:00:00 AM | 4 | 3x3 | Permit Number 48677 | 6009673.58749 | 2117095.63602 | 37.7936865972027 | -122.41048236278499 | (37.7936865972027, -122.410482362785) | |
| 143658 | 143658 | 57355 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1048 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51822 | 6003777.0368564 | 2102155.772975 | 37.7523330655121 | -122.42981881773198 | (37.7523330655121, -122.429818817732) | ||
| 52787 | 52787 | 68366 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 9 | 6x4 | Permit Number 32187 | 6003399.15519 | 2094463.9674799999 | 37.731191735989206 | -122.43057679118999 | (37.7311917359892, -122.43057679119) |
| 20742 | 20742 | 4833 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2000 12:00:00 AM | 3 | 3X3 | 6006343.81219 | 2097681.02702 | 37.7401914459849 | -122.420624856565 | (37.7401914459849, -122.420624856565) | ||
| 7561 | 7561 | 2191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1059 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1998 12:00:00 AM | 6 | 4X4 | 6000860.0298 | 2112380.5159 | 37.780242057456704 | -122.440639597689 | (37.7802420574567, -122.440639597689) | ||
| 82368 | 82368 | 31007 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34781 | 6001462.17793128 | 2086756.21041895 | 37.7099180463866 | -122.43672172056601 | (37.7099180463866, -122.436721720566) | ||
| 186238 | 186238 | 66350 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50525 | 6000670.661119999 | 2093317.15683 | 37.727887909175294 | -122.439927459785 | (37.7278879091753, -122.439927459785) | |
| 83812 | 83812 | 47246 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 95926 | 95926 | 47247 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 96087 | 96087 | 47244 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 103547 | 103547 | 47245 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 107163 | 107163 | 47250 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 108910 | 108910 | 47249 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 18646 | 18646 | 5581 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1061 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005153.1959 | 2102184.2823799998 | 37.752489179437205 | -122.425061862427 | (37.7524891794372, -122.425061862427) | |||
| 183271 | 183271 | 34939 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1064 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1997 12:00:00 AM | 6 | Permit Number 38536 | 6011885.96785 | 2103445.77889 | 37.75633099959 | -122.401867334221 | (37.75633099959, -122.401867334221) | ||
| 163939 | 163939 | 46311 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1066 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2002 12:00:00 AM | 6 | Permit Number 44566 | 6013661.4196 | 2089907.6052 | 37.7192569100927 | -122.394779083836 | (37.7192569100927, -122.394779083836) | ||
| 176173 | 176173 | 83286 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 107 Venus St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52358 | 6012899.6328300005 | 2094298.4658400002 | 37.731270935689295 | -122.39772012589701 | (37.7312709356893, -122.397720125897) | |
| 23099 | 23099 | 10175 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1070 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53293 | 6005702.267530001 | 2102743.9562 | 37.7540569153999 | -122.42320285762301 | (37.7540569153999, -122.423202857623) | |
| 129154 | 129154 | 10176 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1070 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2010 12:00:00 AM | 0 | 3x3 | Permit Number 53294 | 6005702.26311 | 2102736.9430799 | 37.7540376587481 | -122.423202374429 | (37.7540376587481, -122.423202374429) |
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");