1,377 rows where qSpecies_id = 61 sorted by qLegalStatus_id

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)
130 13128 DPW Maintained 1 Tristania conferta :: 61 1714 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6004131.2449 2119777.2826 37.8007374433085 -122.429850711739 (37.8007374433085, -122.429850711739) 13 9 1 57 17
209 138219 DPW Maintained 1 Tristania conferta :: 61 101 Anza St 14 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5998675.4325 2112652.6916 37.7808647356786 -122.448216697429 (37.7808647356786, -122.448216697429) 15 6 2 54 16
303 87474 DPW Maintained 1 Tristania conferta :: 61 6290 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x5   6013182.5276 2090518.895 37.7209087510834 -122.39647726989 (37.7209087510834, -122.39647726989) 10 3 8 58 1
788 200933 DPW Maintained 1 Tristania conferta :: 61 4210 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 Width 0ft   6015403.5213 2097186.1672 37.7393390938031 -122.389265224086 (37.7393390938031, -122.389265224086) 10 3 8 58 1
899 9520 DPW Maintained 1 Tristania conferta :: 61 1046 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2000 12:00:00 AM 3 3X3   6004532.0878 2112270.4724 37.7801483287397 -122.427928412048 (37.7801483287397, -122.427928412048) 7 9 11 29490 41
1099 138916 DPW Maintained 1 Tristania conferta :: 61 707 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004396.0968 2110813.5411 37.7761402601039 -122.428295000541 (37.7761402601039, -122.428295000541) 7 9 11 28852 10
1178 7095 DPW Maintained 1 Tristania conferta :: 61 1970 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1994 12:00:00 AM 18 3X3   5998027.6156 2109626.606 37.7725188329855 -122.45023961224 (37.7725188329855, -122.45023961224) 15 5 11 29492 16
1224 81614 DPW Maintained 1 Tristania conferta :: 61 1450@ Shafter Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6017097.2029 2092677.3305 37.7270524726432 -122.383095431375 (37.7270524726432, -122.383095431375) 10 3 8 58 1
1445 140697 DPW Maintained 1 Tristania conferta :: 61 859 MASONIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999231.335 2109939.9835 37.7734481000077 -122.446098386426 (37.7734481000077, -122.446098386426) 15 5 11 29492 16
1715 122822 DPW Maintained 1 Tristania conferta :: 61 1736 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6010044.5984 2120081.0225 37.8019045299018 -122.409409413578 (37.8019045299018, -122.409409413578) 3 1 10 308 23
2490 195264 DPW Maintained 1 Tristania conferta :: 61 681 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/14/2020 12:00:00 AM 3 Width 4ft Permit Number 771659 6011775.98455 2114888.82062 37.7877448438967 -122.403052549837 (37.7877448438967, -122.403052549837) 12 2 9 28855 6
2931 6985 DPW Maintained 1 Tristania conferta :: 61 819 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/22/2008 12:00:00 AM 3 3X3   6003479.628 2110333.4443 37.7747701331995 -122.431431030712 (37.7747701331995, -122.431431030712) 15 9 11 29492 10
3148 24262 DPW Maintained 1 Tristania conferta :: 61 600X Willow St 6 Sidewalk: Curb side : Cutout Tree DPW 1   11/19/2004 12:00:00 AM 3 3X3   6004514.0905 2113119.5269 37.7824786038336 -122.428051195433 (37.7824786038336, -122.428051195433) 7 9 11 29490 41
3420 79436 DPW Maintained 1 Tristania conferta :: 61 606 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6004047.0413 2110853.2815 37.7762296204821 -122.429505312147 (37.7762296204821, -122.429505312147) 7 9 11 28852 10
3600 23929 DPW Maintained 1 Tristania conferta :: 61 1715 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/06/1992 12:00:00 AM 20 4X4   6003463.555 2114659.6298 37.7866478474124 -122.431795587112 (37.7866478474124, -122.431795587112) 13 9 11 29490 27
3625 22438 DPW Maintained 1 Tristania conferta :: 61 6025 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6013608.4406 2091403.3166 37.7233608886837 -122.395066921688 (37.7233608886837, -122.395066921688) 10 3 8 58 1
3754 261321 DPW Maintained 1 Tristania conferta :: 61 2353 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001169.3018 2119289.54 37.7992300540772 -122.440065245785 (37.7992300540772, -122.440065245785) 13 9 1 57 17
3757 29485 DPW Maintained 1 Tristania conferta :: 61 1608 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2006 12:00:00 AM 12 3x3   6016787.6638 2093383.8729 37.7289753898862 -122.38421469762 (37.7289753898862, -122.38421469762) 10 3 8 58 1
4020 22395 DPW Maintained 1 Tristania conferta :: 61 5700 03rd St 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/31/2011 12:00:00 AM 6 3x3   6013894.8509 2092365.7305 37.7260194067343 -122.394144192498 (37.7260194067343, -122.394144192498) 10 3 8 58 1
4029 138227 DPW Maintained 1 Tristania conferta :: 61 101 Anza St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5998554.9543 2112632.7248 37.7808030238066 -122.448632050181 (37.7808030238066, -122.448632050181) 15 6 2 54 16
4086 69819 DPW Maintained 1 Tristania conferta :: 61 3521 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5983899.4988 2104926.7311 37.7587956653789 -122.498762161048 (37.7587956653789, -122.498762161048) 1 8 3 56 35
4210 29504 DPW Maintained 1 Tristania conferta :: 61 1800X Ingalls St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2006 12:00:00 AM 12 3x3   6016442.8409 2092919.0689 37.7276800583286 -122.385374410624 (37.7276800583286, -122.385374410624) 10 3 8 58 1
4257 4614 DPW Maintained 1 Tristania conferta :: 61 347 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1991 12:00:00 AM 30 3x3   6010525.6854 2118803.2675 37.7984230708943 -122.407654474652 (37.7984230708943, -122.407654474652) 3 1 10 308 4
4598 140349 DPW Maintained 1 Tristania conferta :: 61 1314 ELLIS ST 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6004502.4614 2113302.7614 37.7829810622913 -122.428104489199 (37.7829810622913, -122.428104489199) 7 9 11 29490 41
4786 70866 DPW Maintained 1 Tristania conferta :: 61 499 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6005878.7494 2111261.8484 37.7774549853258 -122.423197973584 (37.7774549853258, -122.423197973584) 7 9 11 28852 10
4802 65984 DPW Maintained 1 Tristania conferta :: 61 1520 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1990 12:00:00 AM 14   Permit Number 29013 6010137.4433 2119339.4921 37.7998736715658 -122.409035773182 (37.7998736715658, -122.409035773182) 3 1 10 308 23
4874 143132 DPW Maintained 1 Tristania conferta :: 61 2435 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000754.0798 2119231.0352 37.7990457686205 -122.441497852636 (37.7990457686205, -122.441497852636) 13 9 1 57 17
4880 10701 DPW Maintained 1 Tristania conferta :: 61 1290 Hayes St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6001704.3359 2110485.9297 37.7750880443133 -122.437583041692 (37.7750880443133, -122.437583041692) 15 5 11 29492 10
5148 247454 DPW Maintained 1 Tristania conferta :: 61 563 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003114.7156 2110238.7499 37.7744894374273 -122.432686570898 (37.7744894374273, -122.432686570898) 15 9 11 29492 10
5348 72411 DPW Maintained 1 Tristania conferta :: 61 475 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10 6x6   6010101.0381 2120567.585 37.8032436723817 -122.409248460006 (37.8032436723817, -122.409248460006) 3 1 10 308 23
5368 73913 DPW Maintained 1 Tristania conferta :: 61 499 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6005876.1258 2111280.7378 37.7775067029674 -122.423208392543 (37.7775067029674, -122.423208392543) 7 9 11 28852 10
5423 138217 DPW Maintained 1 Tristania conferta :: 61 101 Anza St 12 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5998640.9134 2112646.2616 37.7808451071221 -122.448335652205 (37.7808451071221, -122.448335652205) 15 6 2 54 16
5658 6307 DPW Maintained 1 Tristania conferta :: 61 1804 Ellis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 4x4   6002139.3488 2112974.3616 37.781945376326 -122.436256362281 (37.781945376326, -122.436256362281) 15 5 11 29490 41
5852 83783 DPW Maintained 1 Tristania conferta :: 61 606 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6004048.7127 2110839.5763 37.7761920840099 -122.429498552699 (37.7761920840099, -122.429498552699) 7 9 11 28852 10
5894 29427 DPW Maintained 1 Tristania conferta :: 61 2501X Ingalls St 7 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 6 3X3   6015373.5361 2091407.2745 37.7234697537221 -122.388965539304 (37.7234697537221, -122.388965539304) 10 3 8 58 1
5979 137873 DPW Maintained 1 Tristania conferta :: 61 1805 PINE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6005262.4155 2115445.1649 37.7889065369741 -122.425627888461 (37.7889065369741, -122.425627888461) 13 9 11 28858 27
6244 138902 DPW Maintained 1 Tristania conferta :: 61 518 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6004070.6412 2110683.9615 37.7757660455959 -122.42941159626 (37.7757660455959, -122.42941159626) 7 9 11 28852 10
6267 200934 DPW Maintained 1 Tristania conferta :: 61 4220 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 0ft   6015398.3252 2097166.7998 37.7392856268198 -122.389281837998 (37.7392856268198, -122.389281837998) 10 3 8 58 1
6338 141477 DPW Maintained 1 Tristania conferta :: 61 25 KITTREDGE TER 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5997952.6249 2111528.1769 37.777735763362 -122.450636133087 (37.777735763362, -122.450636133087) 15 6 2 54 16
6704 13114 DPW Maintained 1 Tristania conferta :: 61 1618 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2005 12:00:00 AM 12 3x3   6004576.6984 2119842.3294 37.800941260536 -122.428313896065 (37.800941260536, -122.428313896065) 13 9 1 57 17
6717 138911 DPW Maintained 1 Tristania conferta :: 61 723 HAYES ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004266.8521 2110794.1209 37.776079623036 -122.428740708053 (37.776079623036, -122.428740708053) 7 9 11 28852 10
6940 140679 DPW Maintained 1 Tristania conferta :: 61 1303 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004187.9883 2112981.79 37.7820819575387 -122.429169542785 (37.7820819575387, -122.429169542785) 7 9 11 29490 41
7492 138882 DPW Maintained 1 Tristania conferta :: 61 510 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6004088.2198 2110564.2595 37.7754383685459 -122.429342249625 (37.7754383685459, -122.429342249625) 7 9 11 28852 10
7542 247487 DPW Maintained 1 Tristania conferta :: 61 312 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6002757.5424 2109611.6714 37.772747372498 -122.433877269198 (37.772747372498, -122.433877269198) 15 5 11 29492 9
7868 140649 DPW Maintained 1 Tristania conferta :: 61 109 Shrader St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5997299.8022 2110011.7822 37.7735347493893 -122.452784984309 (37.7735347493893, -122.452784984309) 15 5 2 29492 16
8629 29437 DPW Maintained 1 Tristania conferta :: 61 2307X Ingalls St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 6 3X3   6015612.318 2091732.5629 37.7243761643823 -122.388162796666 (37.7243761643823, -122.388162796666) 10 3 8 58 1
8657 6306 DPW Maintained 1 Tristania conferta :: 61 1804 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6002160.6694 2112978.761 37.7819586673159 -122.436182917866 (37.7819586673159, -122.436182917866) 15 5 11 29490 41
8686 199711 DPW Maintained 1 Tristania conferta :: 61 1510 Wallace Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015245.4888 2092572.1176 37.7266610833371 -122.389489489481 (37.7266610833371, -122.389489489481) 10 3 8 58 1
8843 57906 DPW Maintained 1 Tristania conferta :: 61 643 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1982 12:00:00 AM 13   Permit Number 20197 6000071.8454 2111132.0779 37.7767692506982 -122.443276587526 (37.7767692506982, -122.443276587526) 15 5 11 29492 16
8845 21605 DPW Maintained 1 Tristania conferta :: 61 1521 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6005164.0288 2114740.1913 37.7869652957353 -122.425918090858 (37.7869652957353, -122.425918090858) 13 9 11 28858 13
8910 74145 DPW Maintained 1 Tristania conferta :: 61 499 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6005875.6011 2111298.5777 37.7775556573861 -122.423211476089 (37.7775556573861, -122.423211476089) 7 9 11 28852 10
9366 13179 DPW Maintained 1 Tristania conferta :: 61 1976 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/14/1997 12:00:00 AM 14 3X3   6002902.1538 2119607.7128 37.8002021701058 -122.434091743886 (37.8002021701058, -122.434091743886) 13 9 1 57 17
10009 141171 DPW Maintained 1 Tristania conferta :: 61 1804 ELLIS ST 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6002115.9977 2112972.331 37.7819384740439 -122.436337000836 (37.7819384740439, -122.436337000836) 15 5 11 29490 41
10110 13676 DPW Maintained 1 Tristania conferta :: 61 681 Market St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2020 12:00:00 AM 3 4X4 Permit Number 771659 6011822.15902 2114934.32739 37.7878723731553 -122.402895995877 (37.7878723731553, -122.402895995877) 12 2 9 28855 6
10761 60596 DPW Maintained 1 Tristania conferta :: 61 1773 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1982 12:00:00 AM 18   Permit Number 20216 6000702.1439 2111336.8084 37.7773673101232 -122.441110894469 (37.7773673101232, -122.441110894469) 15 5 11 29492 41
10876 13180 DPW Maintained 1 Tristania conferta :: 61 1990 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1993 12:00:00 AM 15 3X3   6002882.226 2119605.2218 37.8001941994801 -122.434160523596 (37.8001941994801, -122.434160523596) 13 9 1 57 17
10885 13675 DPW Maintained 1 Tristania conferta :: 61 681 Market St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2020 12:00:00 AM 3 4X4 Permit Number 771659 6011805.84433 2114919.40836 37.7878304980227 -122.402951392291 (37.7878304980227, -122.402951392291) 12 2 9 28855 6
10938 28832 DPW Maintained 1 Tristania conferta :: 61 1500 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2005 12:00:00 AM 12 4x4   6016972.3335 2093632.2976 37.7296677240114 -122.383593562534 (37.7296677240114, -122.383593562534) 10 3 8 58 1
11077 141992 DPW Maintained 1 Tristania conferta :: 61 818 Webster St 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/31/1991 12:00:00 AM 9 Width 0ft   6003994.291 2111559.6951 37.7781662710742 -122.429738185966 (37.7781662710742, -122.429738185966) 7 9 11 29490 41
11172 82387 DPW Maintained 1 Tristania conferta :: 61 615 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6010004.402 2119511.4587 37.8003383958996 -122.409508291437 (37.8003383958996, -122.409508291437) 3 1 10 308 23
11372 121012 DPW Maintained 1 Tristania conferta :: 61 199X Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 4x4   6015178.5737 2115521.0723 37.7896702844128 -122.391324356251 (37.7896702844128, -122.391324356251) 6 2 9 28855 6
11870 245936 DPW Maintained 1 Tristania conferta :: 61 188 Beulah St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997210.9895 2107777.1744 37.76739400269 -122.452930870305 (37.76739400269, -122.452930870305) 15 5 11 29492 9
11906 13674 DPW Maintained 1 Tristania conferta :: 61 681 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2020 12:00:00 AM 3 4X4 Permit Number 771659 6011788.8197 2114903.8104 37.787786719038 -122.403009197144 (37.787786719038, -122.403009197144) 12 2 9 28855 6
12207 6322 DPW Maintained 1 Tristania conferta :: 61 1864 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6001909.5604 2112942.2115 37.7818440417219 -122.43704902047 (37.7818440417219, -122.43704902047) 15 5 11 29490 41
12388 6901 DPW Maintained 1 Tristania conferta :: 61 333 Fell St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/14/2015 12:30:00 PM 3 3x3   6005680.1943 2110643.4354 37.775745766228 -122.423840858061 (37.775745766228, -122.423840858061) 7 9 11 28852 10
12548 142282 DPW Maintained 1 Tristania conferta :: 61 1670 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999823.8892 2110575.119 37.7752258412107 -122.444094309435 (37.7752258412107, -122.444094309435) 15 5 11 29492 16
12950 138781 DPW Maintained 1 Tristania conferta :: 61 1600 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003611.2673 2114261.243 37.785562349837 -122.431256090862 (37.785562349837, -122.431256090862) 13 9 11 29490 13
13390 200988 DPW Maintained 1 Tristania conferta :: 61 75 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6015383.195 2115715.4111 37.7902152482092 -122.390629967009 (37.7902152482092, -122.390629967009) 6 2 9 28855 6
13435 71273 DPW Maintained 1 Tristania conferta :: 61 2480 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6000737.6791 2114169.5665 37.7851473635462 -122.441191260636 (37.7851473635462, -122.441191260636) 15 6 1 29490 27
13783 244951 DPW Maintained 1 Tristania conferta :: 61 251 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6005979.0205 2110582.4222 37.7755951037998 -122.422802804782 (37.7755951037998, -122.422802804782) 7 9 11 28852 10
13880 141551 DPW Maintained 1 Tristania conferta :: 61 54 Kittredge Ter 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5998011.3045 2111395.4264 37.7773746235344 -122.450423568924 (37.7773746235344, -122.450423568924) 15 6 2 54 16
14066 141995 DPW Maintained 1 Tristania conferta :: 61 818 WEBSTER ST 5 Sidewalk: Curb side : Cutout Tree DPW 1   01/21/1999 12:00:00 AM 5 Width 0ft   6003983.7554 2111636.8614 37.778377554053 -122.429780137803 (37.778377554053, -122.429780137803) 7 9 11 29490 41
14129 71258 DPW Maintained 1 Tristania conferta :: 61 923 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13 3x3   6001950.0126 2111666.817 37.778344429762 -122.436817746544 (37.778344429762, -122.436817746544) 15 5 11 29490 41
14541 65945 DPW Maintained 1 Tristania conferta :: 61 528 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM 12   Permit Number 28966 6007615.5081 2113146.6876 37.7827281591619 -122.417323539063 (37.7827281591619, -122.417323539063) 7 9 9 28852 36
14783 200936 DPW Maintained 1 Tristania conferta :: 61 4240 03rd St 4 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 0ft   6015378.4854 2097095.9435 37.7390899699971 -122.389345489075 (37.7390899699971, -122.389345489075) 10 3 8 58 1
15026 60579 DPW Maintained 1 Tristania conferta :: 61 556 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1982 12:00:00 AM 13   Permit Number 20193 6000143.5821 2110857.5211 37.7760194779825 -122.443008707696 (37.7760194779825, -122.443008707696) 15 5 11 29492 16
15166 10340 DPW Maintained 1 Tristania conferta :: 61 914 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X4   6001716.4806 2109101.7503 37.7712881236094 -122.437441889428 (37.7712881236094, -122.437441889428) 15 5 11 29492 9
15536 200935 DPW Maintained 1 Tristania conferta :: 61 4230 03rd St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 Width 0ft   6015383.6815 2097122.3965 37.7391628925988 -122.389329369915 (37.7391628925988, -122.389329369915) 10 3 8 58 1
15605 6319 DPW Maintained 1 Tristania conferta :: 61 1860 Ellis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6001987.059 2112951.3489 37.7818735354474 -122.436781566115 (37.7818735354474, -122.436781566115) 15 5 11 29490 41
15729 247461 DPW Maintained 1 Tristania conferta :: 61 756 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6002953.7505 2109617.4268 37.7727743077426 -122.433198975484 (37.7727743077426, -122.433198975484) 15 5 11 29492 9
15889 245992 DPW Maintained 1 Tristania conferta :: 61 1250 Waller St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5999690.8568 2108469.5931 37.7694370106113 -122.444403147816 (37.7694370106113, -122.444403147816) 15 5 11 29492 9
16548 143139 DPW Maintained 1 Tristania conferta :: 61 2520 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000358 2119336 37.7993114011756 -122.442875959315 (37.7993114011756, -122.442875959315) 13 9 1 57 17
16713 137874 DPW Maintained 1 Tristania conferta :: 61 1635 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6005298.8871 2115425.6162 37.7888549218974 -122.425500309796 (37.7888549218974, -122.425500309796) 13 9 11 28858 27
16824 13677 DPW Maintained 1 Tristania conferta :: 61 681 Market St 5 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2020 12:00:00 AM 3 4X4 Permit Number 771659 6011836.71983 2114948.58904 37.7879123453203 -122.402846621288 (37.7879123453203, -122.402846621288) 12 2 9 28855 6
16944 1665 DPW Maintained 1 Tristania conferta :: 61 1400X Fell St 6 Sidewalk: Curb side : Cutout Tree DPW 1   05/06/1992 12:00:00 AM 18 3X3   6000409.8977 2109962.9335 37.7735783473195 -122.442023227789 (37.7735783473195, -122.442023227789) 15 5 11 29492 16
16954 259600 DPW Maintained 1 Tristania conferta :: 61 1595 Newcomb Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6015285.2988 2095613.9245 37.7350154810982 -122.389564212737 (37.7350154810982, -122.389564212737) 10 3 8 58 1
17145 139804 DPW Maintained 1 Tristania conferta :: 61 1101 GOUGH ST 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005645.4415 2112973.1088 37.7821405184571 -122.424126793395 (37.7821405184571, -122.424126793395) 7 9 11 28852 41
17166 140743 DPW Maintained 1 Tristania conferta :: 61 2075 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6001328.1518 2113161.5088 37.7824131116074 -122.439076141092 (37.7824131116074, -122.439076141092) 15 5 11 29490 41
17209 13251 DPW Maintained 1 Tristania conferta :: 61 2395 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6000984.849 2119261.9127 37.7991436944439 -122.440701531677 (37.7991436944439, -122.440701531677) 13 9 1 57 17
17245 245465 DPW Maintained 1 Tristania conferta :: 61 2601 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008856.7977 2106814.5159 37.7654112631592 -122.412581421905 (37.7654112631592, -122.412581421905) 8 4 7 28859 19
17387 216652 DPW Maintained 1 Tristania conferta :: 61 329 Faxon Ave 1 Sidewalk: Curb side : Yard Tree Private 2   09/23/2020 12:00:00 AM 3 Width 4ft   5994725.9247 2090785.70947 37.7205969659665 -122.460295076156 (37.7205969659665, -122.460295076156) 9 8 6 28861 24
17424 9664 DPW Maintained 1 Tristania conferta :: 61 115 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/07/1995 12:00:00 AM 18 3X3   6006036.6387 2110130.4049 37.7743572242045 -122.422571361821 (37.7743572242045, -122.422571361821) 7 9 11 28852 10
17454 55475 DPW Maintained 1 Tristania conferta :: 61 1290 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1972 12:00:00 AM 9   Permit Number 11427 6001668.0931 2110827.7285 37.7760244773884 -122.437732898122 (37.7760244773884, -122.437732898122) 15 5 11 29492 10
18356 22489 DPW Maintained 1 Tristania conferta :: 61 6283 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/21/2008 12:00:00 AM 6 3x3   6013301.3486 2090589.3102 37.7211087088425 -122.396071470667 (37.7211087088425, -122.396071470667) 10 3 8 58 1
18491 141846 DPW Maintained 1 Tristania conferta :: 61 1273 EDDY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004395.0795 2112899.1361 37.781866731536 -122.428447208044 (37.781866731536, -122.428447208044) 7 9 11 29490 41
18493 199818 DPW Maintained 1 Tristania conferta :: 61 2226 Ingalls St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6015709.0498 2091939.7667 37.7249504642567 -122.387842856465 (37.7249504642567, -122.387842856465) 10 3 8 58 1
18547 41551 DPW Maintained 1 Tristania conferta :: 61 627 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1982 12:00:00 AM 11   Permit Number 42073 6000076.2449 2111080.2993 37.7766273307268 -122.443257648559 (37.7766273307268, -122.443257648559) 15 5 11 29492 16
18999 29494 DPW Maintained 1 Tristania conferta :: 61 1700X Ingalls St 5 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 12 3X3   6016622.9685 2093155.934 37.7283404071211 -122.384768194628 (37.7283404071211, -122.384768194628) 10 3 8 58 1
19251 142786 DPW Maintained 1 Tristania conferta :: 61 730 POLK ST 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6007071.7839 2113562.2092 37.7838384745362 -122.419234083256 (37.7838384745362, -122.419234083256) 7 9 9 28858 36
19333 244143 DPW Maintained 1 Tristania conferta :: 61 423 Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004418.4707 2109613.03 37.7728452161751 -122.428132029093 (37.7728452161751, -122.428132029093) 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)
);