406 rows where qSpecies_id = 47 sorted by YCoord descending

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)
145003 129486 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 5 Sidewalk: Curb side : Yard Tree Private 2     13     6012297.60436 2120565.6201 37.803361093695 -122.401646988622 (37.803361093695, -122.401646988622) 3 1 10 28860 6
33940 129485 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 4 Sidewalk: Curb side : Yard Tree Private 2     10     6012301.33061 2120559.21941 37.803343726885 -122.401633643571 (37.803343726885, -122.401633643571) 3 1 10 28860 6
98776 129484 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 3 Sidewalk: Curb side : Yard Tree Private 2     14     6012303.28877 2120555.11364 37.8033325627054 -122.401626578498 (37.8033325627054, -122.401626578498) 3 1 10 28860 6
145811 129483 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 1 Sidewalk: Curb side : Yard Tree Private 2     17     6012307.75016 2120551.40866 37.8033226386787 -122.401610879045 (37.8033226386787, -122.401610879045) 3 1 10 28860 6
182552 129482 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Greenwich St 5 Sidewalk: Curb side : Yard Tree Private 2     8     6012315.37501 2120537.75286 37.803285568636 -122.401583532467 (37.803285568636, -122.401583532467) 3 1 10 28860 6
69319 129481 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Greenwich St 4 Sidewalk: Curb side : Yard Tree Private 2     5     6012317.54236 2120532.77652 37.8032720257522 -122.401575682271 (37.8032720257522, -122.401575682271) 3 1 10 28860 6
80039 129480 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Greenwich St 3 Sidewalk: Curb side : Yard Tree Private 2     18     6012320.77236 2120522.45554 37.8032438670795 -122.401563778859 (37.8032438670795, -122.401563778859) 3 1 10 28860 6
93238 129477 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Filbert St 1 Sidewalk: Curb side : Yard Tree Private 2     15     6012514.7758 2120236.23138 37.8024687881724 -122.400872298239 (37.8024687881724, -122.400872298239) 3 1 10 28860 6
54154 129479 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Filbert St 3 Sidewalk: Curb side : Yard Tree Private 2     10     6012506.13221 2120230.97584 37.8024538756 -122.400901840066 (37.8024538756, -122.400901840066) 3 1 10 28860 6
152884 129478 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Filbert St 2 Sidewalk: Curb side : Yard Tree Private 2     17     6012509.68294 2120230.66756 37.8024532271953 -122.400889531035 (37.8024532271953, -122.400889531035) 3 1 10 28860 6
2211 129471 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Filbert St 3 Sidewalk: Curb side : Yard Tree Private 2     9     6012526.59847 2120207.76193 37.8023912773999 -122.400829384367 (37.8023912773999, -122.400829384367) 3 1 10 28860 6
54058 129472 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Filbert St 4 Sidewalk: Curb side : Yard Tree Private 2     7     6012528.94679 2120206.6635 37.8023883923599 -122.400821180758 (37.8023883923599, -122.400821180758) 3 1 10 28860 6
138353 129473 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Filbert St 5 Sidewalk: Curb side : Yard Tree Private 2     14     6012532.2991 2120205.04389 37.8023841322847 -122.400809466192 (37.8023841322847, -122.400809466192) 3 1 10 28860 6
20311 129474 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Filbert St 6 Sidewalk: Curb side : Yard Tree Private 2     25     6012536.27851 2120200.91706 37.8023730229664 -122.400795405292 (37.8023730229664, -122.400795405292) 3 1 10 28860 6
156277 129475 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1077 Front St 4 Sidewalk: Curb side : Yard Tree Private 2     19     6012586.09993 2120128.51859 37.8021770130129 -122.4006179088 (37.8021770130129, -122.4006179088) 3 1 10 28860 6
112053 129476 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1077 Front St 5 Sidewalk: Curb side : Yard Tree Private 2     17     6012591.30532 2120127.94056 37.8021757161919 -122.4005998549 (37.8021757161919, -122.4005998549) 3 1 10 28860 6
14177 129468 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1151 Lombard St 5 Sidewalk: Property side : Yard Tree Private 2     11     6006718.96895 2120094.36111 37.8017542606157 -122.420918621021 (37.8017542606157, -122.420918621021) 5 1 1 28858 32
174774 249938 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 339 Filbert St 3 Front Yard : Yard Tree Private 2     8 Width 0ft   6011244.68883 2120032.52194 37.8018385261831 -122.405253098256 (37.8018385261831, -122.405253098256) 3 1 10 308 23
115683 129467 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1331 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   6006504.31748 2119710.78815 37.8006889650949 -122.421634156713 (37.8006889650949, -122.421634156713) 13 9 1 28858 32
80079 129470 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 45 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     10     6008463.14234 2119145.61201 37.7992473914164 -122.414815771241 (37.7992473914164, -122.414815771241) 5 1 10 308 32
155046 129469 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1085 Vallejo St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6008359.28826 2118585.88506 37.7977046844857 -122.415135501808 (37.7977046844857, -122.415135501808) 5 1 10 308 21
83035 33301 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1120 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37453 6009052.27411403 2116787.86536385 37.7928066833324 -122.412610401728 (37.7928066833324, -122.412610401728) 3 1 10 28857 21
148893 42597 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1950 Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM 7   Permit Number 42667 6005420.67346 2116544.61332 37.7919342879744 -122.425158599805 (37.7919342879744, -122.425158599805) 13 9 1 28858 27
30568 129464 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1974 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6005282.18317 2116523.47353 37.7918684189526 -122.425636272008 (37.7918684189526, -122.425636272008) 13 9 1 28858 27
122863 129465 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1974 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6005261.30695 2116522.05783 37.791863352156 -122.425708403014 (37.791863352156, -122.425708403014) 13 9 1 28858 27
105151 129466 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1974 Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6005243.67184 2116520.57545 37.7918582853821 -122.425769315008 (37.7918582853821, -122.425769315008) 13 9 1 28858 27
104265 129463 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2451 Steiner St 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6002236.13059 2116512.00902 37.7916643510872 -122.436174782264 (37.7916643510872, -122.436174782264) 13 9 1 29490 27
169833 2477 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2307X Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x4   6003648.68016 2115921.80581 37.7901239554137 -122.43124522669 (37.7901239554137, -122.43124522669) 13 9 1 29490 27
50220 18882 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2323 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 2X2   6003557.0695 2115907.13274 37.7900784748972 -122.43156114415 (37.7900784748972, -122.43156114415) 13 9 1 29490 27
128589 18878 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2305 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     26 3X3   6003659.52132 2115878.15996 37.7900047293604 -122.431204600475 (37.7900047293604, -122.431204600475) 13 9 1 29490 27
107523 123588 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 50 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   5994278.22027 2115268.89087 37.7877957491728 -122.463618619297 (37.7877957491728, -122.463618619297) 11 6 1 54 11
98973 250332 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 141 27th Ave 1 : Tree Private 2   05/08/2002 12:00:00 AM 4 Width 3ft Permit Number 45150 5987387.77846 2115003.34197 37.7866671925889 -122.487438428541 (37.7866671925889, -122.487438428541) 11 6 1 55 33
161986 122182 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 14th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10     5991497.78568 2114857.01928 37.7865042639669 -122.473208256238 (37.7865042639669, -122.473208256238) 11 6 1 54 33
79169 56335 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 354 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2016 12:00:00 AM 3 3x3 Permit Number 777757 5987487.44856113 2113581.55129815 37.7827691737362 -122.486989143207 (37.7827691737362, -122.486989143207) 11 6 2 55 26
69315 138260 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2600 GEARY BLVD 28 unknown : Yard Tree Private 2     2 Width 0ft   5999060.2181 2113180.9681 37.7823372358083 -122.446923566676 (37.7823372358083, -122.446923566676) 15 5 1 54 16
47779 138264 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2600 GEARY BLVD 32 unknown : Yard Tree Private 2     1 Width 0ft   5999039.2359 2113177.9223 37.7823276740968 -122.446995936272 (37.7823276740968, -122.446995936272) 15 5 1 54 16
118542 138270 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 218 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5998383.8821 2112677.2272 37.7809154323836 -122.449227076582 (37.7809154323836, -122.449227076582) 15 6 2 54 16
121491 31546 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 220 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 6   Permit Number 35095 5998394.38199367 2112672.66987383 37.7809035197163 -122.449190424029 (37.7809035197163, -122.449190424029) 15 6 2 54 16
180157 24738 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 7700 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/09/1996 12:00:00 AM 3 3X3   5983089.13202 2112566.68135 37.7797252106941 -122.502130088809 (37.7797252106941, -122.502130088809) 11 6 2 55 26
134083 24808 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 7117 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/22/1996 12:00:00 AM 3 3X3   5984967.23631 2112432.54215 37.7794670623637 -122.495623106999 (37.7794670623637, -122.495623106999) 11 6 2 55 26
83616 68575 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 7633 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32467 5983299.26193695 2112364.72668983 37.7791830450299 -122.501388226383 (37.7791830450299, -122.501388226383) 11 6 2 55 26
61805 47082 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 175 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 5   Permit Number 45068 5996827.60082146 2111762.20695793 37.7783138890322 -122.45454486672 (37.7783138890322, -122.45454486672) 15 6 2 54 16
73341 47451 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 5049 Anza St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45359 5983034.2663237 2111680.83899779 37.7772897229163 -122.502254315782 (37.7772897229163, -122.502254315782) 11 6 2 55 26
118845 47453 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 5049 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45359 5983034.2663237 2111680.83899779 37.7772897229163 -122.502254315782 (37.7772897229163, -122.502254315782) 11 6 2 55 26
67268 118441 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 5201 Anza St 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5982477.73735 2111660.7356 37.7772018111581 -122.504178007129 (37.7772018111581, -122.504178007129) 11 6 2 55 26
188923 34718 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 626 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38373 5981358.16274912 2111480.6327423 37.7766413961782 -122.508037533581 (37.7766413961782, -122.508037533581) 11 6 2 55 26
157305 34725 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 114 Sutro Heights Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38379 5981286.97907127 2111325.91865707 37.776212402307 -122.508272287748 (37.776212402307, -122.508272287748) 11 6 2 55 26
113945 50219 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2726 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2004 12:00:00 AM 8 3x3 Permit Number 46926 5987073.25597 2111201.47184 37.776209992885 -122.488247096133 (37.776209992885, -122.488247096133) 11 6 2 55 26
107383 54526 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4530 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 3   Permit Number 777496 5981479.33824 2110998.92324 37.7753259029383 -122.507582607669 (37.7753259029383, -122.507582607669) 11 6 2 55 26
164867 118789 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 718 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   5981995.4955 2110847.43445 37.7749403522663 -122.505785898051 (37.7749403522663, -122.505785898051) 11 6 2 55 26
99585 59481 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 701 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2019 12:00:00 AM 3   Permit Number 768498 5994707.05513 2110730.54303 37.7753593652253 -122.461805741777 (37.7753593652253, -122.461805741777) 11 6 2 54 11
102767 109138 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 759 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773583 5985365.40132 2110729.9835 37.7748156320332 -122.494120186241 (37.7748156320332, -122.494120186241) 11 6 2 55 26
126484 118250 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 759 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5985366.8002 2110712.822 37.7747685933044 -122.494114082166 (37.7747685933044, -122.494114082166) 11 6 2 55 26
76135 98307 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 701 04th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2019 12:00:00 AM 3   Permit Number 768498 5994707.05848 2110712.18551 37.7753089605415 -122.461804398804 (37.7753089605415, -122.461804398804) 11 6 2 54 11
190719 109133 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 774 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773526 5985442.4 2110611.6 37.7744950899459 -122.493845109753 (37.7744950899459, -122.493845109753) 11 6 2 55 26
3158 44124 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 751 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/29/2000 12:00:00 AM     Permit Number 43628 5981028.36208653 2110606.15983469 37.774220913121 -122.509113438342 (37.774220913121, -122.509113438342) 11 6 2 55 26
58696 119085 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 886 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5982037.396 2109722.65545 37.7718545033558 -122.505557564286 (37.7718545033558, -122.505557564286) 11 6 2 55 26
24415 119095 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 6700 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   5982534.89521 2109675.70682 37.7717548615052 -122.503833231018 (37.7717548615052, -122.503833231018) 11 6 2 55 26
163946 117519 Undocumented 4 Leptospermum laevigatum :: Australian Tea Tree 47 1601 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998904 2109014 37.7708868872166 -122.447164026359 (37.7708868872166, -122.447164026359) 15 5 11 29492 9
166333 244098 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1601 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5998815.2972 2108995.6351 37.7708313932465 -122.447469528169 (37.7708313932465, -122.447469528169) 15 5 11 29492 9
145982 227697 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 109 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003800.52049 2108768.8119 37.7704922173631 -122.430209350707 (37.7704922173631, -122.430209350707) 15 9 11 29492 10
174440 246123 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 35 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2017 12:00:00 AM 3 Width 0ft Permit Number 779621 5998184.8878 2108385.4066 37.7691198159889 -122.449606139087 (37.7691198159889, -122.449606139087) 15 5 11 29492 9
147419 227696 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 50 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6003774.74871 2108065.24722 37.7685589402651 -122.43024829315 (37.7685589402651, -122.43024829315) 7 9 5 28862 3
66446 191396 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 2 Front Yard : Yard Tree Private 2     6     6010761.04996 2107917.30957 37.7685459711594 -122.406072716988 (37.7685459711594, -122.406072716988) 8 4 8 28853 19
179306 191395 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 1 Front Yard : Yard Tree Private 2     22     6010771.29847 2107917.19939 37.7685462418407 -122.406037260315 (37.7685462418407, -122.406037260315) 8 4 8 28853 19
16955 191397 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 3 Front Yard : Yard Tree Private 2     9     6010751.13717 2107916.66974 37.768543659889 -122.406106959582 (37.768543659889, -122.406106959582) 8 4 8 28853 19
113892 191398 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 4 Front Yard : Yard Tree Private 2     14     6010740.07849 2107915.77093 37.7685405734149 -122.406145147482 (37.7685405734149, -122.406145147482) 8 4 8 28853 19
154411 191399 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 5 Front Yard : Yard Tree Private 2     5     6010727.66479 2107914.72417 37.7685370048986 -122.406188011877 (37.7685370048986, -122.406188011877) 8 4 8 28853 19
56934 191400 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 6 Front Yard : Yard Tree Private 2     18     6010721.65743 2107914.21049 37.7685352584272 -122.406208754734 (37.7685352584272, -122.406208754734) 8 4 8 28853 19
53776 191401 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 7 Front Yard : Yard Tree Private 2     8     6010711.19096 2107913.74245 37.7685333878424 -122.406244924566 (37.7685333878424, -122.406244924566) 8 4 8 28853 19
10441 191402 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 8 Front Yard : Yard Tree Private 2     7     6010700.42675 2107913.45144 37.7685319866755 -122.406282136733 (37.7685319866755, -122.406282136733) 8 4 8 28853 19
181779 191403 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 9 Front Yard : Yard Tree Private 2     5     6010692.20162 2107913.0668 37.7685304704432 -122.406310559796 (37.7685304704432, -122.406310559796) 8 4 8 28853 19
4749 227685 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1001 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5997626.03081 2107071.20572 37.765479368391 -122.451444382046 (37.765479368391, -122.451444382046) 15 5 11 29492 9
62642 227686 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1001 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5997629.48637 2107046.84316 37.7654126728718 -122.451430672783 (37.7654126728718, -122.451430672783) 15 5 11 29492 9
43157 227687 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1003 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5997630.84664 2107024.34604 37.7653509793933 -122.451424345184 (37.7653509793933, -122.451424345184) 15 5 11 29492 9
133352 186762 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984853.5932 2106716.1156 37.7637647274179 -122.495594492387 (37.7637647274179, -122.495594492387) 1 8 3 56 35
55330 186759 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 25 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984850.1974 2106711.7495 37.7637525404811 -122.495605915184 (37.7637525404811, -122.495605915184) 1 8 3 56 35
185713 186760 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984860.8701 2106711.7495 37.7637531654529 -122.495569002148 (37.7637531654529, -122.495569002148) 1 8 3 56 35
17241 186756 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 22 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984857.4742 2106702.5322 37.7637276584797 -122.495580067458 (37.7637276584797, -122.495580067458) 1 8 3 56 35
157835 186754 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984863.7808 2106693.8 37.763704051609 -122.495557611102 (37.763704051609, -122.495557611102) 1 8 3 56 35
138219 186752 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984851.1676 2106688.9488 37.7636899929755 -122.495600877764 (37.7636899929755, -122.495600877764) 1 8 3 56 35
149988 186750 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 16 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984851.1676 2106678.2761 37.7636606887382 -122.495600090514 (37.7636606887382, -122.495600090514) 1 8 3 56 35
192203 186749 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984860.385 2106678.2761 37.7636612284897 -122.495568210877 (37.7636612284897, -122.495568210877) 1 8 3 56 35
127928 186748 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984868.1469 2106676.3356 37.7636563549354 -122.495541222153 (37.7636563549354, -122.495541222153) 1 8 3 56 35
136020 186747 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984869.1172 2106666.6331 37.7636297714118 -122.495537150576 (37.7636297714118, -122.495537150576) 1 8 3 56 35
49589 186745 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 11 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984852.3804 2106661.5394 37.763614805479 -122.495594661337 (37.763614805479, -122.495594661337) 1 8 3 56 35
154772 85386 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1239 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49657 5981144.8 2106623.2 37.7632917298848 -122.508414943002 (37.7632917298848, -122.508414943002) 1 8 3 56 35
63925 167503 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3512 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2018 12:00:00 AM 3 3x3 Permit Number 782138 6003389.60758 2106563.82057 37.7644145648084 -122.431473265088 (37.7644145648084, -122.431473265088) 15 4 5 28862 3
174016 167504 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3512 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2018 12:00:00 AM 3 3x3 Permit Number 782138 6003358.46768 2106563.63668 37.7644122949287 -122.431580956196 (37.7644122949287, -122.431580956196) 15 4 5 28862 3
62191 255989 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3512 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2018 12:00:00 AM 3 3x3 Permit Number 782138 6003384.96446 2106555.65654 37.7643918851964 -122.431488741482 (37.7643918851964, -122.431488741482) 15 4 5 28862 3
141612 183278 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1255 42nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5983028.2339 2106536.9311 37.7631656789881 -122.501894487796 (37.7631656789881, -122.501894487796) 1 8 3 56 35
158350 37082 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1268 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/2002 12:00:00 AM 6   Permit Number 44549 5982146.28824129 2106471.58463776 37.7629344086854 -122.504939947841 (37.7629344086854, -122.504939947841) 1 8 3 56 35
94578 207099 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5990478.55232 2106260.78747 37.7628423007597 -122.476106431162 (37.7628423007597, -122.476106431162) 1 8 3 56 12
120655 207100 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5990476.61635 2106239.99978 37.7627851110794 -122.476111608564 (37.7627851110794, -122.476111608564) 1 8 3 56 12
30167 207101 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5990477.30542 2106226.48097 37.7627480320102 -122.476108237903 (37.7627480320102, -122.476108237903) 1 8 3 56 12
49514 227681 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 145 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5997959.25406 2106183.43699 37.7630608557823 -122.450227846644 (37.7630608557823, -122.450227846644) 15 5 11 29492 9
77823 31942 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1300 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39715 5980916.9213303 2106151.77480086 37.761983899941 -122.50916807627 (37.761983899941, -122.50916807627) 1 8 3 56 35
52711 207102 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5990480.89082 2106148.89617 37.7625352128593 -122.476090170539 (37.7625352128593, -122.476090170539) 1 8 3 56 12
58446 183252 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1300 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5980914.4873 2106074.217 37.7617708050911 -122.509170734828 (37.7617708050911, -122.509170734828) 1 8 3 56 35
34278 181438 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1319 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5981181.6009 2106068.5638 37.761771027502 -122.508246492496 (37.761771027502, -122.508246492496) 1 8 3 56 35

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