7,322 rows where qSpecies_id = 1 sorted by qAddress

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);