trees
7,322 rows where qSpecies_id = 1 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7570 | 36838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
7844 | 36854 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
13636 | 36840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
14357 | 36839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
14394 | 36837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
18459 | 36836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
38541 | 38764 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | 9 | 7 | 4 | 28861 | 25 | ||||
55699 | 38765 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | 9 | 7 | 4 | 28861 | 25 | ||||
64791 | 38763 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | 9 | 7 | 4 | 28861 | 25 | ||||
68229 | 38767 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | 9 | 7 | 4 | 28861 | 25 | ||||
147908 | 38766 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | 9 | 7 | 4 | 28861 | 25 | ||||
143137 | 37147 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.421428163818 | (37.7471576573064, -122.421428163818) | 2 | 7 | 7 | 28859 | 2 | ||
167200 | 37149 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.421428163818 | (37.7471576573064, -122.421428163818) | 2 | 7 | 7 | 28859 | 2 | ||
189763 | 37148 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 27th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.421428163818 | (37.7471576573064, -122.421428163818) | 2 | 7 | 7 | 28859 | 2 | ||
102413 | 242192 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Castro St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002211.39696 | 2108163.69762 | 37.7687405871237 | -122.435662832375 | (37.7687405871237, -122.435662832375) | 15 | 5 | 5 | 28862 | 3 | |||
143098 | 242191 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002232.11086 | 2107759.61358 | 37.7676322482692 | -122.435562272887 | (37.7676322482692, -122.435562272887) | 15 | 5 | 5 | 28862 | 3 | |||
159724 | 36932 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/2003 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | 2 | 4 | 5 | 28862 | 22 | ||
184556 | 36933 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | 2 | 4 | 5 | 28862 | 22 | ||
191144 | 36931 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | 2 | 4 | 5 | 28862 | 22 | ||
28181 | 241968 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Holly Park Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006548.82894 | 2096926.63546 | 37.7381316072746 | -122.419862472475 | (37.7381316072746, -122.419862472475) | 2 | 7 | 7 | 28859 | 2 | |||
47450 | 241966 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006454.12488 | 2096966.70901 | 37.7382363045723 | -122.420192755695 | (37.7382363045723, -122.420192755695) | 2 | 7 | 7 | 28859 | 2 | |||
118127 | 241967 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006413.05624 | 2096945.13113 | 37.7381747423726 | -122.420333219896 | (37.7381747423726, -122.420333219896) | 2 | 7 | 7 | 28859 | 2 | |||
180187 | 112262 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x15 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | 2 | 7 | 7 | 28859 | 2 | |||
132693 | 200596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016417.1805 | 2094923.5303 | 37.7331824919173 | -122.385602758378 | (37.7331824919173, -122.385602758378) | 10 | 3 | 8 | 58 | 1 | |||
10319 | 180008 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997232.2014 | 2086767.6701 | 37.7097082093476 | -122.451342068885 | (37.7097082093476, -122.451342068885) | 9 | 7 | 6 | 28861 | 25 | |||
49352 | 180011 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997275.603 | 2086720.88269 | 37.7095822269181 | -122.451188694021 | (37.7095822269181, -122.451188694021) | 9 | 7 | 6 | 28861 | 25 | |||
93974 | 180009 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997247.3865 | 2086752.55268 | 37.7096675698642 | -122.451288497174 | (37.7096675698642, -122.451288497174) | 9 | 7 | 6 | 28861 | 25 | |||
97740 | 180010 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997262.56254 | 2086737.01263 | 37.7096257693921 | -122.451234926375 | (37.7096257693921, -122.451234926375) | 9 | 7 | 6 | 28861 | 25 | |||
121029 | 68739 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1993 12:00:00 AM | 8 | Permit Number 32659 | 5997216.23373 | 2086785.97531 | 37.7097575569365 | -122.451398575111 | (37.7097575569365, -122.451398575111) | 9 | 7 | 6 | 28861 | 25 | ||
20190 | 90411 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006552.3 | 2109010.7 | 37.771311860318 | -122.420708085152 | (37.771311860318, -122.420708085152) | 8 | 2 | 9 | 28853 | 19 | ||
21325 | 90408 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | 8 | 2 | 9 | 28853 | 19 | ||
43168 | 242860 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006601.51384 | 2109123.7876 | 37.7716251455168 | -122.420545880782 | (37.7716251455168, -122.420545880782) | 8 | 2 | 9 | 28853 | 19 | |||
91023 | 30664 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006594.41261 | 2109123.24947 | 37.7716232677391 | -122.420570406196 | (37.7716232677391, -122.420570406196) | 8 | 2 | 9 | 28853 | 19 | |
129046 | 90410 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | 8 | 2 | 9 | 28853 | 19 | ||
131860 | 90409 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | 8 | 2 | 9 | 28853 | 19 | ||
147727 | 30668 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | 8 | 2 | 9 | 28853 | 19 | ||
155721 | 30663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006564.90903 | 2109121.1634 | 37.7716158771129 | -122.420672312891 | (37.7716158771129, -122.420672312891) | 8 | 2 | 9 | 28853 | 19 | |
167676 | 30662 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006559.28152 | 2109117.66624 | 37.7716059575784 | -122.420691530508 | (37.7716059575784, -122.420691530508) | 8 | 2 | 9 | 28853 | 19 | |
173352 | 30667 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | 8 | 2 | 9 | 28853 | 19 | ||
192592 | 242859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006473.64318 | 2109116.62874 | 37.7715982818596 | -122.420987685352 | (37.7715982818596, -122.420987685352) | 8 | 2 | 9 | 28853 | 19 | |||
192851 | 30669 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006474.54027 | 2109116.5589 | 37.7715981406638 | -122.4209845773 | (37.7715981406638, -122.4209845773) | 8 | 2 | 9 | 28853 | 19 | |
101250 | 91174 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2008 12:00:00 AM | 3X3 | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | ||
131757 | 91175 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |||
189326 | 139587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6000732.3602 | 2112121.031 | 37.7795223070318 | -122.441062642932 | (37.7795223070318, -122.441062642932) | 15 | 5 | 1 | 29490 | 16 | |||
10561 | 261942 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Verna St | 7 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
32166 | 246604 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6005614.48903 | 2109249.34773 | 37.7719142289884 | -122.423968991887 | (37.7719142289884, -122.423968991887) | 7 | 9 | 5 | 28852 | 10 | |||
108036 | 246600 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6005541.07514 | 2109239.29711 | 37.771882487431 | -122.424222221193 | (37.771882487431, -122.424222221193) | 7 | 9 | 5 | 28852 | 10 | |||
146024 | 246601 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 3 | : | Tree | Private 2 | 2 | Width 4ft | 6005553.21097 | 2109241.87873 | 37.7718902611687 | -122.424180426085 | (37.7718902611687, -122.424180426085) | 7 | 9 | 5 | 28852 | 10 | |||
146231 | 246603 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 5 | : | Tree | Private 2 | 2 | Width 4ft | 6005584.08918 | 2109245.72637 | 37.7719025692852 | -122.424073889709 | (37.7719025692852, -122.424073889709) | 7 | 9 | 5 | 28852 | 10 | |||
180835 | 246602 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 4 | : | Tree | Private 2 | 2 | Width 4ft | 6005566.51625 | 2109243.72851 | 37.7718960914643 | -122.424134533696 | (37.7718960914643, -122.424134533696) | 7 | 9 | 5 | 28852 | 10 | |||
180951 | 246605 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 7 | : | Tree | Private 2 | 3 | Width 4ft | 6005631.61729 | 2109252.77035 | 37.7719245936684 | -122.423909987349 | (37.7719245936684, -122.423909987349) | 7 | 9 | 5 | 28852 | 10 | |||
47073 | 198129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Apollo St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013057.33243 | 2094752.72387 | 37.7325270152047 | -122.397206767679 | (37.7325270152047, -122.397206767679) | 10 | 3 | 8 | 58 | 1 | |||
143644 | 218543 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Elmhurst Dr | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991239.17772 | 2094375.63397 | 37.7302528212926 | -122.472609144905 | (37.7302528212926, -122.472609144905) | 9 | 8 | 4 | 64 | 40 | |||
5210 | 240637 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6005372.47745 | 2108674.6931 | 37.7703226996495 | -122.424765239935 | (37.7703226996495, -122.424765239935) | 8 | 2 | 5 | 28853 | 19 | ||
163336 | 200585 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016408.3895 | 2094976.9039 | 37.7333285587394 | -122.38563687008 | (37.7333285587394, -122.38563687008) | 10 | 3 | 8 | 58 | 1 | |||
56551 | 242238 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Loma Vista Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999968.62465 | 2106925.5157 | 37.7652132050475 | -122.443331442302 | (37.7652132050475, -122.443331442302) | 15 | 5 | 5 | 29492 | 3 | |||
150166 | 242236 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Loma Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999958.34407 | 2106938.77843 | 37.7652490349443 | -122.443367952968 | (37.7652490349443, -122.443367952968) | 15 | 5 | 5 | 29492 | 3 | |||
157478 | 242237 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Loma Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999962.96113 | 2106933.24517 | 37.7652341052825 | -122.443351586234 | (37.7652341052825, -122.443351586234) | 15 | 5 | 5 | 29492 | 3 | |||
169463 | 242239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Loma Vista Ter | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999972.43901 | 2106916.37432 | 37.765188322609 | -122.443317592742 | (37.765188322609, -122.443317592742) | 15 | 5 | 5 | 29492 | 3 | |||
64481 | 84175 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50693 | 6010501.10356 | 2090044.14226 | 37.7194555904939 | -122.405712770528 | (37.7194555904939, -122.405712770528) | 10 | 7 | 8 | 309 | 39 | |
42548 | 180161 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000203.12908 | 2088838.03405 | 37.7155626339762 | -122.441222488037 | (37.7155626339762, -122.441222488037) | 9 | 7 | 6 | 28861 | 5 | |||
100428 | 180160 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000171.58523 | 2088857.19454 | 37.7156134474691 | -122.441332891512 | (37.7156134474691, -122.441332891512) | 9 | 7 | 6 | 28861 | 5 | |||
12677 | 259879 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Romain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2019 12:00:00 AM | 3 | 3x3 | Permit Number 776294 | 6001192.18773 | 2103413.52714 | 37.7556398401092 | -122.438847746407 | (37.7556398401092, -122.438847746407) | 2 | 4 | 5 | 28862 | 3 | |
42744 | 214935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 San Andreas Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993803.05703 | 2095767.77574 | 37.7342233740152 | -122.463846549273 | (37.7342233740152, -122.463846549273) | 9 | 8 | 4 | 59 | 40 | |||
59931 | 214933 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 San Andreas Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993794.55323 | 2095807.54269 | 37.7343320741677 | -122.463878834949 | (37.7343320741677, -122.463878834949) | 9 | 8 | 4 | 59 | 40 | |||
72313 | 214934 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 San Andreas Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993802.59672 | 2095785.69059 | 37.7342725372347 | -122.463849440612 | (37.7342725372347, -122.463849440612) | 9 | 8 | 4 | 59 | 40 | |||
76081 | 214936 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 San Andreas Way | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993805.7734 | 2095746.05674 | 37.7341638955498 | -122.463835582055 | (37.7341638955498, -122.463835582055) | 9 | 8 | 4 | 59 | 40 | |||
104235 | 214931 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 San Andreas Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993780.73912 | 2095831.5977 | 37.7343973271827 | -122.463928339945 | (37.7343973271827, -122.463928339945) | 9 | 8 | 4 | 59 | 40 | |||
162877 | 214932 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 San Andreas Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993788.65441 | 2095818.87006 | 37.7343628363837 | -122.463900050863 | (37.7343628363837, -122.463900050863) | 9 | 8 | 4 | 59 | 40 | |||
76506 | 56298 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1993 12:00:00 AM | 7 | Permit Number 32247 | 5993056.25051 | 2114776.86302 | 37.7863742905451 | -122.467810568951 | (37.7863742905451, -122.467810568951) | 11 | 6 | 2 | 54 | 11 | |
161754 | 140247 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Ashbury St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998760.3863 | 2110325.7376 | 37.7744803767388 | -122.447755234881 | (37.7744803767388, -122.447755234881) | 15 | 5 | 11 | 29492 | 16 | |||
19635 | 218683 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996159.63142 | 2093800.06179 | 37.7289560267814 | -122.455556993487 | (37.7289560267814, -122.455556993487) | 9 | 7 | 4 | 28861 | 40 | |||
76761 | 36309 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.7288745967493 | -122.455513542245 | (37.7288745967493, -122.455513542245) | 9 | 7 | 4 | 28861 | 40 | ||
95124 | 36312 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.7288745967493 | -122.455513542245 | (37.7288745967493, -122.455513542245) | 9 | 7 | 4 | 28861 | 40 | ||
131715 | 218684 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996159.93427 | 2093814.55265 | 37.7289958325848 | -122.455556993472 | (37.7289958325848, -122.455556993472) | 9 | 7 | 4 | 28861 | 40 | |||
142635 | 36310 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.7288745967493 | -122.455513542245 | (37.7288745967493, -122.455513542245) | 9 | 7 | 4 | 28861 | 40 | ||
182674 | 36308 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.7288745967493 | -122.455513542245 | (37.7288745967493, -122.455513542245) | 9 | 7 | 4 | 28861 | 40 | ||
193815 | 36311 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.7288745967493 | -122.455513542245 | (37.7288745967493, -122.455513542245) | 9 | 7 | 4 | 28861 | 40 | ||
14307 | 175031 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/30/2019 12:00:00 AM | 3 | Width 3ft | 6010533.91342 | 2086822.61219 | 37.7106117590847 | -122.405372606475 | (37.7106117590847, -122.405372606475) | 9 | 7 | 8 | 309 | 39 | |
23436 | 82875 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52475 | 6010457.79461314 | 2094219.31159395 | 37.730917314013 | -122.406156470326 | (37.730917314013, -122.406156470326) | 10 | 3 | 7 | 309 | 28 | ||
34408 | 82876 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52475 | 6010457.79461314 | 2094219.31159395 | 37.730917314013 | -122.406156470326 | (37.730917314013, -122.406156470326) | 10 | 3 | 7 | 309 | 28 | ||
152955 | 82877 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52475 | 6010467.51259 | 2094188.12138 | 37.730832215827 | -122.406120676945 | (37.730832215827, -122.406120676945) | 10 | 3 | 7 | 309 | 28 | |
154357 | 82874 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Girard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52475 | 6010457.79461314 | 2094219.31159395 | 37.730917314013 | -122.406156470326 | (37.730917314013, -122.406156470326) | 10 | 3 | 7 | 309 | 28 | ||
165270 | 82873 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Girard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52475 | 6010457.79461314 | 2094219.31159395 | 37.730917314013 | -122.406156470326 | (37.730917314013, -122.406156470326) | 10 | 3 | 7 | 309 | 28 | ||
17843 | 75713 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009899.57579 | 2093995.19407 | 37.7302706953269 | -122.408070533924 | (37.7302706953269, -122.408070533924) | 10 | 3 | 7 | 309 | 28 | |||
90987 | 218682 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996235.99067 | 2093774.30409 | 37.7288896838048 | -122.455291154777 | (37.7288896838048, -122.455291154777) | 9 | 7 | 4 | 28861 | 40 | |||
116575 | 218681 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996249.01925 | 2093772.54485 | 37.7288856008733 | -122.455245987239 | (37.7288856008733, -122.455245987239) | 9 | 7 | 4 | 28861 | 40 | |||
47777 | 138203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 MASONIC AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998926.8799 | 2112606.4971 | 37.780752269091 | -122.447343495542 | (37.780752269091, -122.447343495542) | 15 | 5 | 1 | 54 | 16 | |||
79714 | 138200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 MASONIC AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998935.002 | 2112526.6295 | 37.7805334374744 | -122.447309647334 | (37.7805334374744, -122.447309647334) | 15 | 5 | 1 | 54 | 16 | |||
154991 | 138202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 MASONIC AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998931.6178 | 2112562.5022 | 37.7806317412334 | -122.447323937494 | (37.7806317412334, -122.447323937494) | 15 | 5 | 1 | 54 | 16 | |||
5997 | 14446 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2012 12:00:00 AM | 3 | 3x3 | 5998938.7246 | 2112487.711 | 37.7804267900707 | -122.447293967252 | (37.7804267900707, -122.447293967252) | 15 | 5 | 1 | 54 | 16 | ||
45578 | 14449 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2012 12:00:00 AM | 3 | 3x3 | 5998904.0552777 | 2112732.9517082 | 37.7810981763644 | -122.447431561272 | (37.7810981763644, -122.447431561272) | 15 | 5 | 1 | 54 | 16 | ||
114734 | 14451 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Masonic Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2012 12:00:00 AM | 3 | 3x3 | 5998904.0552777 | 2112732.9517082 | 37.7810981763644 | -122.447431561272 | (37.7810981763644, -122.447431561272) | 15 | 5 | 1 | 54 | 16 | ||
136553 | 14447 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2012 12:00:00 AM | 3 | 3x3 | 5998904.0552777 | 2112732.9517082 | 37.7810981763644 | -122.447431561272 | (37.7810981763644, -122.447431561272) | 15 | 5 | 1 | 54 | 16 | ||
50127 | 241239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 McCoppin St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6005928.36777 | 2109150.09439 | 37.7716594186857 | -122.422876205876 | (37.7716594186857, -122.422876205876) | 8 | 2 | 9 | 28853 | 19 | |||
51712 | 241238 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 McCoppin St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6005908.08699 | 2109147.66491 | 37.7716516035611 | -122.422946185717 | (37.7716516035611, -122.422946185717) | 8 | 2 | 9 | 28853 | 19 | |||
78905 | 179323 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Merrill St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 3ft | 6009520.85663 | 2094768.87857 | 37.7323738561678 | -122.409434403484 | (37.7323738561678, -122.409434403484) | 10 | 3 | 7 | 309 | 28 | |||
139013 | 179324 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Merrill St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6009528.37304 | 2094747.88556 | 37.7323166349901 | -122.409406936389 | (37.7323166349901, -122.409406936389) | 10 | 3 | 7 | 309 | 28 | |||
71016 | 242259 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Oak St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006155.99242 | 2110416.55826 | 37.7751496650453 | -122.422178828403 | (37.7751496650453, -122.422178828403) | 7 | 9 | 11 | 28852 | 10 | |||
75768 | 242257 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006301.70753 | 2110434.24272 | 37.7752064401631 | -122.421676022844 | (37.7752064401631, -122.421676022844) | 7 | 9 | 11 | 28852 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );