1,377 rows where qSpecies_id = 61 sorted by SiteOrder

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
19744 138921 DPW Maintained 1 Tristania conferta :: 61 631 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004505.2517 2110712.757 37.7758697074358 -122.427910221054 (37.7758697074358, -122.427910221054) 7 9 11 28852 10
19778 137930 DPW Maintained 1 Tristania conferta :: 61 1977 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004477.3196 2115333.9095 37.7885566643943 -122.428336281189 (37.7885566643943, -122.428336281189) 13 9 11 28858 27
20401 140131 Permitted Site 7 Tristania conferta :: 61 501 GOUGH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM 5 Width 0ft   6005847.0047 2111508.1975 37.7781296085056 -122.423325305774 (37.7781296085056, -122.423325305774) 7 9 11 28852 10
20510 142108 DPW Maintained 1 Tristania conferta :: 61 758 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6001607.3106 2111115.6492 37.7768115789366 -122.437963788403 (37.7768115789366, -122.437963788403) 15 5 11 29492 10
20668 142244 DPW Maintained 1 Tristania conferta :: 61 419 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6005364 2110769 37.7760726809274 -122.424943590033 (37.7760726809274, -122.424943590033) 7 9 11 28852 10
21423 143427 DPW Maintained 1 Tristania conferta :: 61 855 SACRAMENTO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6010650.0101 2116903.247 37.7932130339503 -122.407090272453 (37.7932130339503, -122.407090272453) 3 1 10 28857 4
21688 24501 DPW Maintained 1 Tristania conferta :: 61 901 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/24/1995 12:00:00 AM 6 3X3   6003042.5941 2110274.0021 37.7745821407981 -122.43293857186 (37.7745821407981, -122.43293857186) 15 5 11 29492 10
21708 30437 DPW Maintained 1 Tristania conferta :: 61 567 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 12   Permit Number 90 6010234.0616 2119544.2672 37.8004413456091 -122.40871589046 (37.8004413456091, -122.40871589046) 3 1 10 308 23
21816 29421 DPW Maintained 1 Tristania conferta :: 61 2501X Ingalls St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 4 3x3   6015238.3862 2091224.5002 37.7229603992916 -122.389419974154 (37.7229603992916, -122.389419974154) 10 3 8 58 1
21861 22334 DPW Maintained 1 Tristania conferta :: 61 5201 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/17/2015 02:59:00 PM 3 3X3   6014532.0059 2093984.9826 37.7305009408534 -122.392054756971 (37.7305009408534, -122.392054756971) 10 3 8 58 1
22006 6951 DPW Maintained 1 Tristania conferta :: 61 603 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/11/1990 12:00:00 AM 6 3x3   6004469.2574 2110472.8506 37.7752089468863 -122.428017634821 (37.7752089468863, -122.428017634821) 7 9 11 28852 10
22324 141816 DPW Maintained 1 Tristania conferta :: 61 1218 EDDY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004565.725 2112968.4018 37.7820665729689 -122.427861790691 (37.7820665729689, -122.427861790691) 7 9 11 29490 41
22349 29469 DPW Maintained 1 Tristania conferta :: 61 1609 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2006 12:00:00 AM 8 3X3   6016821.7398 2093350.8961 37.7288867261126 -122.384094597711 (37.7288867261126, -122.384094597711) 10 3 8 58 1
22456 25279 DPW Maintained 1 Tristania conferta :: 61 1940 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5993856.5207 2092712.5569 37.7258375734043 -122.463440067194 (37.7258375734043, -122.463440067194) 9 8 4 59 40
23279 22495 DPW Maintained 1 Tristania conferta :: 61 6315 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/07/2011 12:00:00 AM 1 3x3   6013233.044 2090405.2973 37.7205996457096 -122.396294690849 (37.7205996457096, -122.396294690849) 10 3 8 58 1
23965 141511 DPW Maintained 1 Tristania conferta :: 61 29 KITTREDGE TER 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5997955.5108 2111504.1279 37.7776698962407 -122.450624415537 (37.7776698962407, -122.450624415537) 15 6 2 54 16
24535 141271 DPW Maintained 1 Tristania conferta :: 61 381 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997841.2227 2112537.9666 37.7805020054221 -122.45109434754 (37.7805020054221, -122.45109434754) 15 6 2 54 16
24618 51914 DPW Maintained 1 Tristania conferta :: 61 1738 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2008 12:00:00 AM 3 3x3 Permit Number 50190 6004049.1514 2119767.1187 37.8007048866604 -122.43013406377 (37.8007048866604, -122.43013406377) 13 9 1 57 17
24759 200143 DPW Maintained 1 Tristania conferta :: 61 6215 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6013445.5739 2090955.2697 37.7221215837156 -122.395598549244 (37.7221215837156, -122.395598549244) 10 3 8 58 1
24778 115380 Permitted Site 7 Tristania conferta :: 61 1657X York St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 775521 6010720.61658 2099977.21326 37.7467419766429 -122.405653246985 (37.7467419766429, -122.405653246985) 2 7 7 28859 2
25025 12266 DPW Maintained 1 Tristania conferta :: 61 649 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/1991 12:00:00 AM 16 3X3   6004915.2268 2111219.2684 37.7772836485499 -122.426528085844 (37.7772836485499, -122.426528085844) 7 9 11 28852 10
25196 138756 DPW Maintained 1 Tristania conferta :: 61 2323 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6001466.9262 2114221.5245 37.7853315391503 -122.438672022334 (37.7853315391503, -122.438672022334) 15 6 11 29490 13
25766 245935 DPW Maintained 1 Tristania conferta :: 61 188 Beulah St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5997227.0394 2107780.5055 37.7674040687868 -122.452875596673 (37.7674040687868, -122.452875596673) 15 5 11 29492 9
25849 10432 DPW Maintained 1 Tristania conferta :: 61 1441 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/1999 12:00:00 AM 18 3X3   5999180.1356 2108696.8663 37.7700318922285 -122.446186054388 (37.7700318922285, -122.446186054388) 15 5 11 29492 9
26175 138912 DPW Maintained 1 Tristania conferta :: 61 719 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004292.6341 2110798.4737 37.7760930338959 -122.428651831595 (37.7760930338959, -122.428651831595) 7 9 11 28852 10
26472 6077 DPW Maintained 1 Tristania conferta :: 61 1966 Eddy St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/06/2007 12:00:00 AM 18 4X4   6001073.8278 2112479.7581 37.7805267238289 -122.439907091482 (37.7805267238289, -122.439907091482) 15 5 11 29490 41
26557 7067 DPW Maintained 1 Tristania conferta :: 61 1600 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/26/2016 12:00:00 AM 3 3x3   5999719.0796 2109864.829 37.7732695858551 -122.444405811275 (37.7732695858551, -122.444405811275) 15 5 11 29492 16
26593 65948 DPW Maintained 1 Tristania conferta :: 61 550 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM 12   Permit Number 28969 6007606.7794 2113206.8791 37.7828929393541 -122.417358003683 (37.7828929393541, -122.417358003683) 7 9 9 28852 36
26936 10692 DPW Maintained 1 Tristania conferta :: 61 1249 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6001880.3859 2110463.9678 37.7750377503654 -122.436972474402 (37.7750377503654, -122.436972474402) 15 5 11 29492 10
27028 68142 DPW Maintained 1 Tristania conferta :: 61 2532 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM 1   Permit Number 31896 6000452.2737 2114128.7986 37.785019164077 -122.442175744115 (37.785019164077, -122.442175744115) 15 6 1 29490 27
27170 68157 DPW Maintained 1 Tristania conferta :: 61 1515 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/1994 12:00:00 AM 8   Permit Number 33474 6005184.9642 2114742.2338 37.7869720870456 -122.425845804507 (37.7869720870456, -122.425845804507) 13 9 11 28858 13
27258 139975 DPW Maintained 1 Tristania conferta :: 61 1000 SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6001951.2709 2111948.8589 37.7791189172983 -122.436833589276 (37.7791189172983, -122.436833589276) 15 5 11 29490 41
27421 140039 DPW Maintained 1 Tristania conferta :: 61 555 GOUGH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005821.2941 2111685.5479 37.7786151184258 -122.423426859428 (37.7786151184258, -122.423426859428) 7 9 11 28852 10
27583 140342 DPW Maintained 1 Tristania conferta :: 61 1335 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6004604.4556 2113518.6258 37.7835795423556 -122.42776701682 (37.7835795423556, -122.42776701682) 7 9 11 29490 41
27653 141272 DPW Maintained 1 Tristania conferta :: 61 365 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997908.5687 2112548.4577 37.7805346667324 -122.450862123717 (37.7805346667324, -122.450862123717) 15 6 2 54 16
27716 15565 DPW Maintained 1 Tristania conferta :: 61 2871 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2005 12:00:00 AM 3 4X4   6007116.1618 2101629.0258 37.7510752616521 -122.418234216284 (37.7510752616521, -122.418234216284) 2 4 7 28859 19
27995 139342 DPW Maintained 1 Tristania conferta :: 61 1400 GEARY BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005040.0715 2114155.1684 37.7853519625541 -122.426305287483 (37.7853519625541, -122.426305287483) 13 9 11 28858 13
28152 138780 DPW Maintained 1 Tristania conferta :: 61 1600 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6003615.8018 2114245.3723 37.785519029862 -122.431239269571 (37.785519029862, -122.431239269571) 13 9 11 29490 13
28177 22470 DPW Maintained 1 Tristania conferta :: 61 6227 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/1995 12:00:00 AM 5 3x3   6013423.3351 2090899.6727 37.7219676884588 -122.395671530407 (37.7219676884588, -122.395671530407) 10 3 8 58 1
28272 141813 DPW Maintained 1 Tristania conferta :: 61 631 WILLOW ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004531.7581 2113098.1631 37.7824209436961 -122.42798855036 (37.7824209436961, -122.42798855036) 7 9 11 29490 41
28616 248567 DPW Maintained 1 Tristania conferta :: 61 809 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5997620.5658 2107720.8482 37.7672628081675 -122.451510146252 (37.7672628081675, -122.451510146252) 15 5 11 29492 9
29000 142193 DPW Maintained 1 Tristania conferta :: 61 1642 FELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999555.7794 2109844.0818 37.7732033006663 -122.444969195074 (37.7732033006663, -122.444969195074) 15 5 11 29492 16
29646 10511 DPW Maintained 1 Tristania conferta :: 61 1800 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2007 12:00:00 AM 6 3X3   5997484.5237 2108509.319 37.7694199557275 -122.452037587086 (37.7694199557275, -122.452037587086) 15 5 11 29492 9
29736 12282 DPW Maintained 1 Tristania conferta :: 61 745 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x10   6004875.3929 2111529.8441 37.7781341613075 -122.426688006249 (37.7781341613075, -122.426688006249) 7 9 11 28852 10
30192 184232 DPW Maintained 1 Tristania conferta :: 61 1500 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5983211.3452 2104903.2019 37.7586906757833 -122.501140335143 (37.7586906757833, -122.501140335143) 1 8 3 56 35
30243 13145 DPW Maintained 1 Tristania conferta :: 61 1801 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/1996 12:00:00 AM 8 3X3   6003646.5026 2119634.2054 37.8003171280845 -122.431517900376 (37.8003171280845, -122.431517900376) 13 9 1 57 17
30494 199816 DPW Maintained 1 Tristania conferta :: 61 2240 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015734.8816 2091975.4915 37.7250499884833 -122.387756049526 (37.7250499884833, -122.387756049526) 10 3 8 58 1
30683 6223 DPW Maintained 1 Tristania conferta :: 61 1220 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/13/1997 12:00:00 AM 12 3X4   6005122.7706 2113389.4093 37.7832540522328 -122.425964643575 (37.7832540522328, -122.425964643575) 7 9 11 28858 41
30694 248608 DPW Maintained 1 Tristania conferta :: 61 432 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   5997774.403 2107510.382 37.7666937298525 -122.450962870008 (37.7666937298525, -122.450962870008) 15 5 11 29492 9
31489 8187 DPW Maintained 1 Tristania conferta :: 61 1255 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001743.6158 2111134.8252 37.7768719817661 -122.437493642173 (37.7768719817661, -122.437493642173) 15 5 11 29492 10
31759 141280 DPW Maintained 1 Tristania conferta :: 61 327 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5998124.1433 2112580.2694 37.7806343517008 -122.450118646064 (37.7806343517008, -122.450118646064) 15 6 2 54 16

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