Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| 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) | ||||
| 137783 | 137783 | 247787 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 0 30th St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004405.04711 | 2098420.28659 | 37.74211182679821 | -122.42738097477199 | (37.7421118267982, -122.427380974772) | |||
| 154157 | 154157 | 247786 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 0 30th St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004434.4666 | 2098422.1705099996 | 37.7421186634473 | -122.42727938556101 | (37.7421186634473, -122.427279385561) | |||
| 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) | ||
| 33541 | 33541 | 242192 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Castro St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002211.39696 | 2108163.69762 | 37.7687405871237 | -122.43566283237499 | (37.7687405871237, -122.435662832375) | |||
| 99159 | 99159 | 242191 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002232.110859999 | 2107759.61358 | 37.76763224826921 | -122.435562272887 | (37.7676322482692, -122.435562272887) | |||
| 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) | ||
| 30078 | 30078 | 241966 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006454.12488 | 2096966.7090099999 | 37.7382363045723 | -122.420192755695 | (37.7382363045723, -122.420192755695) | |||
| 70391 | 70391 | 241968 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Holly Park Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006548.82894 | 2096926.6354599998 | 37.7381316072746 | -122.41986247247499 | (37.7381316072746, -122.419862472475) | |||
| 76854 | 76854 | 241967 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006413.05624 | 2096945.1311299999 | 37.73817474237261 | -122.420333219896 | (37.7381747423726, -122.420333219896) | |||
| 139627 | 139627 | 112262 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x15 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | |||
| 115951 | 115951 | 200596 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016417.1805 | 2094923.5303 | 37.7331824919173 | -122.38560275837798 | (37.7331824919173, -122.385602758378) | |||
| 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) | ||
| 37301 | 37301 | 180009 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997247.3865 | 2086752.55268 | 37.7096675698642 | -122.45128849717399 | (37.7096675698642, -122.451288497174) | |||
| 74913 | 74913 | 180008 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997232.2014 | 2086767.6701 | 37.7097082093476 | -122.451342068885 | (37.7097082093476, -122.451342068885) | |||
| 151119 | 151119 | 180011 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997275.602999999 | 2086720.88269 | 37.7095822269181 | -122.451188694021 | (37.7095822269181, -122.451188694021) | |||
| 174890 | 174890 | 180010 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997262.56254 | 2086737.01263 | 37.7096257693921 | -122.45123492637501 | (37.7096257693921, -122.451234926375) | |||
| 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) | |
| 46052 | 46052 | 242860 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006601.51384 | 2109123.7876 | 37.77162514551679 | -122.420545880782 | (37.7716251455168, -122.420545880782) | |||
| 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) | |
| 76817 | 76817 | 90411 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006552.3 | 2109010.7 | 37.771311860318 | -122.420708085152 | (37.771311860318, -122.420708085152) | ||
| 77634 | 77634 | 90408 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462001 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | ||
| 104896 | 104896 | 90409 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462001 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | ||
| 109635 | 109635 | 90410 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462001 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | ||
| 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) | ||
| 132534 | 132534 | 242859 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006473.643180001 | 2109116.62874 | 37.7715982818596 | -122.420987685352 | (37.7715982818596, -122.420987685352) | |||
| 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) | |||
| 1952 | 1952 | 139587 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6000732.3602 | 2112121.031 | 37.7795223070318 | -122.441062642932 | (37.7795223070318, -122.441062642932) | |||
| 49912 | 49912 | 246603 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005584.08918 | 2109245.7263700003 | 37.7719025692852 | -122.42407388970899 | (37.7719025692852, -122.424073889709) | |||
| 76509 | 76509 | 246605 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6005631.61729 | 2109252.77035 | 37.7719245936684 | -122.42390998734899 | (37.7719245936684, -122.423909987349) | |||
| 132570 | 132570 | 246600 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005541.07514 | 2109239.2971099997 | 37.771882487431 | -122.424222221193 | (37.771882487431, -122.424222221193) | |||
| 149193 | 149193 | 246604 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005614.489030001 | 2109249.34773 | 37.7719142289884 | -122.423968991887 | (37.7719142289884, -122.423968991887) | |||
| 156968 | 156968 | 246602 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005566.51625 | 2109243.72851 | 37.77189609146429 | -122.424134533696 | (37.7718960914643, -122.424134533696) | |||
| 165531 | 165531 | 246601 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005553.210969999 | 2109241.87873 | 37.77189026116871 | -122.424180426085 | (37.7718902611687, -122.424180426085) | |||
| 131719 | 131719 | 198129 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Apollo St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013057.33243 | 2094752.72387 | 37.7325270152047 | -122.39720676767901 | (37.7325270152047, -122.397206767679) | |||
| 173422 | 173422 | 218543 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Elmhurst Dr | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991239.17772 | 2094375.63397 | 37.7302528212926 | -122.472609144905 | (37.7302528212926, -122.472609144905) | |||
| 69581 | 69581 | 200585 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016408.3895 | 2094976.9039 | 37.7333285587394 | -122.38563687008002 | (37.7333285587394, -122.38563687008) | |||
| 54166 | 54166 | 242236 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Loma Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999958.34407 | 2106938.77843 | 37.7652490349443 | -122.443367952968 | (37.7652490349443, -122.443367952968) | |||
| 153763 | 153763 | 242239 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Loma Vista Ter | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999972.43901 | 2106916.37432 | 37.765188322609 | -122.443317592742 | (37.765188322609, -122.443317592742) | |||
| 159937 | 159937 | 242238 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Loma Vista Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999968.62465 | 2106925.5157 | 37.765213205047495 | -122.443331442302 | (37.7652132050475, -122.443331442302) | |||
| 185581 | 185581 | 242237 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Loma Vista Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999962.961130001 | 2106933.24517 | 37.7652341052825 | -122.443351586234 | (37.7652341052825, -122.443351586234) | |||
| 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) | |
| 155589 | 155589 | 180161 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Rolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000203.12908 | 2088838.03405 | 37.715562633976205 | -122.441222488037 | (37.7155626339762, -122.441222488037) | |||
| 187322 | 187322 | 180160 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000171.58523 | 2088857.19454 | 37.7156134474691 | -122.44133289151199 | (37.7156134474691, -122.441332891512) | |||
| 41151 | 41151 | 214936 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993805.7734 | 2095746.0567400001 | 37.7341638955498 | -122.463835582055 | (37.7341638955498, -122.463835582055) | |||
| 67261 | 67261 | 214931 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993780.73912 | 2095831.5977 | 37.734397327182705 | -122.46392833994499 | (37.7343973271827, -122.463928339945) | |||
| 69575 | 69575 | 214932 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993788.65441 | 2095818.8700599999 | 37.7343628363837 | -122.463900050863 | (37.7343628363837, -122.463900050863) | |||
| 155414 | 155414 | 214934 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993802.59672 | 2095785.6905900002 | 37.7342725372347 | -122.463849440612 | (37.7342725372347, -122.463849440612) | |||
| 168514 | 168514 | 214935 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993803.057030001 | 2095767.7757400002 | 37.7342233740152 | -122.463846549273 | (37.7342233740152, -122.463846549273) | |||
| 182128 | 182128 | 214933 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993794.553230001 | 2095807.5426900003 | 37.7343320741677 | -122.463878834949 | (37.7343320741677, -122.463878834949) | |||
| 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) | |
| 834 | 834 | 140247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Ashbury St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998760.3863 | 2110325.7376 | 37.77448037673879 | -122.447755234881 | (37.7744803767388, -122.447755234881) | |||
| 38216 | 38216 | 218684 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996159.93427 | 2093814.55265 | 37.72899583258479 | -122.455556993472 | (37.7289958325848, -122.455556993472) | |||
| 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) | ||
| 130664 | 130664 | 218683 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996159.6314199995 | 2093800.0617900002 | 37.7289560267814 | -122.455556993487 | (37.7289560267814, -122.455556993487) | |||
| 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) | ||
| 166038 | 166038 | 75713 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009899.57579 | 2093995.19407 | 37.7302706953269 | -122.408070533924 | (37.7302706953269, -122.408070533924) | ||
| 26332 | 26332 | 218682 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996235.990669999 | 2093774.3040900002 | 37.728889683804795 | -122.45529115477699 | (37.7288896838048, -122.455291154777) | |||
| 157139 | 157139 | 218681 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996249.01925 | 2093772.54485 | 37.7288856008733 | -122.455245987239 | (37.7288856008733, -122.455245987239) | |||
| 151356 | 151356 | 138200 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 MASONIC AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998935.002 | 2112526.6295 | 37.780533437474396 | -122.44730964733401 | (37.7805334374744, -122.447309647334) | |||
| 178724 | 178724 | 138203 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 MASONIC AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998926.8799 | 2112606.4971 | 37.780752269091 | -122.44734349554199 | (37.780752269091, -122.447343495542) | |||
| 184909 | 184909 | 138202 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 MASONIC AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998931.6178 | 2112562.5022 | 37.7806317412334 | -122.44732393749399 | (37.7806317412334, -122.447323937494) | |||
| 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) | ||
| 83922 | 83922 | 14449 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/2012 12:00:00 AM | 3 | 3x3 | 5998904.0552777 | 2112732.9517082 | 37.781098176364395 | -122.447431561272 | (37.7810981763644, -122.447431561272) | ||
| 107949 | 107949 | 14451 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/2012 12:00:00 AM | 3 | 3x3 | 5998904.0552777 | 2112732.9517082 | 37.781098176364395 | -122.447431561272 | (37.7810981763644, -122.447431561272) | ||
| 115635 | 115635 | 14447 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/2012 12:00:00 AM | 3 | 3x3 | 5998904.0552777 | 2112732.9517082 | 37.781098176364395 | -122.447431561272 | (37.7810981763644, -122.447431561272) | ||
| 27867 | 27867 | 241239 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005928.367769999 | 2109150.09439 | 37.7716594186857 | -122.42287620587601 | (37.7716594186857, -122.422876205876) | |||
| 150338 | 150338 | 241238 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 McCoppin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005908.08699 | 2109147.66491 | 37.771651603561104 | -122.422946185717 | (37.7716516035611, -122.422946185717) | |||
| 23837 | 23837 | 242256 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006379.216440001 | 2110444.9043099997 | 37.77524008469361 | -122.421408658888 | (37.7752400846936, -122.421408658888) | |||
| 24065 | 24065 | 242257 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006301.70753 | 2110434.24272 | 37.7752064401631 | -122.42167602284401 | (37.7752064401631, -122.421676022844) | |||
| 36493 | 36493 | 242259 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006155.99242 | 2110416.55826 | 37.7751496650453 | -122.42217882840299 | (37.7751496650453, -122.422178828403) | |||
| 49845 | 49845 | 242255 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006442.072269999 | 2110453.56934 | 37.7752674204858 | -122.421191841332 | (37.7752674204858, -122.421191841332) | |||
| 157428 | 157428 | 242260 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006119.6892099995 | 2110408.87993 | 37.77512653448729 | -122.422303863832 | (37.7751265344873, -122.422303863832) | |||
| 187925 | 187925 | 242258 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006281.32025 | 2110433.89565 | 37.7752043375461 | -122.42174652250401 | (37.7752043375461, -122.421746522504) |
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");