Street_Tree_List

Data source: data.sfgov.org

994 rows where qSpecies = 39 sorted by SiteOrder

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1985 252841 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1763 Golden Gate Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/1998 12:00:00 AM   3x3 Permit Number 40601 6001163.0 2111730.0 37.7784731541065 -122.43954484007 (37.7784731541065, -122.43954484007)
19560 103375 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 22 VANDEWATER ST   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       2.5x2.5 Permit Number 770057 6009069.0 2121391.0 37.8054466905223 -122.41287812458401 (37.8054466905223, -122.412878124584)
340 191854 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 573 10th St 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     24 Width 6ft tree is in ROW therefore DPW maintained 6009977.72395 2108375.30106 37.7697596664942 -122.408814503513 (37.7697596664942, -122.408814503513)
669 251343 Property Tree 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 934 Brannan St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
1583 251593 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3698 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
4251 246122 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1518 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft Permit Number 46036 5998379.9097 2108286.3815 37.768859073318 -122.448924438468 (37.768859073318, -122.448924438468)
4764 253679 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 94 Teresita Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       4x8   5997405.0 2099153.0 37.7437252916895 -122.45163765514201 (37.7437252916895, -122.451637655142)
5380 23543 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2800X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2     35 9   6005659.04127 2120027.6333 37.8015112413055 -122.424581715282 (37.8015112413055, -122.424581715282)
6534 23551 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2900X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2     30     6005612.78895 2120375.11437 37.802462723129395 -122.424766503478 (37.8024627231294, -122.424766503478)
8259 23442 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2100X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2     24 9   6005990.50725 2117651.28863 37.795005114851 -122.42326567258301 (37.795005114851, -122.423265672583)
8274 41820 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 848 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/2016 12:00:00 AM 3   Permit Number 42207 6000005.683999999 2111868.9913 37.7787888536845 -122.44355840768 (37.7787888536845, -122.44355840768)
9470 105079 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3770 24TH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3x3   6004633.1 2101955.7 37.7518321521274 -122.426844164794 (37.7518321521274, -122.426844164794)
9974 173765 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1100x Bacon St 1 Front Yard : Yard 7 Tree 1 Private 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
11387 104350 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 349 Guttenberg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3x3   5999840.77458 2086361.4281900001 37.708741782568104 -122.44229725703 (37.7087417825681, -122.44229725703)
11531 43168 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 285 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 14 3x3 Permit Number 42977 6005738.99154 2092366.96158 37.7255660943895 -122.422338611837 (37.7255660943895, -122.422338611837)
12964 44723 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1946 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2001 12:00:00 AM 13   Permit Number 43842 5989432.8015 2102080.7043 37.751304216428 -122.47941744514699 (37.751304216428, -122.479417445147)
13250 187606 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 101 Northridge Rd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13296 187658 Property Tree 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 600X Clarendon Ave 1 Front Yard : Yard 7 Tree 1 Private 1       3x3   5995637.0 2102382.0 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932)
14018 99640 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1000X Gilman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3 City Owned Lot 6015553.4063 2089548.4030000002 37.7183756251523 -122.38821408703001 (37.7183756251523, -122.38821408703)
14426 4895 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Rosie Lee Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/19/1993 12:00:00 AM 12 3X4   6018140.882180001 2094365.07214 37.7317442992597 -122.379604608867 (37.7317442992597, -122.379604608867)
15438 104819 Planning Code 138.1 required 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 468 Clementina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/07/2016 12:00:00 AM 3 3X3 Permit Number 770905 6011018.41682 2111922.08536 37.7795565535331 -122.405464583724 (37.7795565535331, -122.405464583724)
16356 11215 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X4   6018142.31163 2094695.6186 37.732651993985705 -122.37962262229799 (37.7326519939857, -122.379622622298)
16971 4468 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1497 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004583.98516 2100211.8834700002 37.7470412591526 -122.426889829809 (37.7470412591526, -122.426889829809)
17255 32525 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 864 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/15/1996 12:00:00 AM 14 3x3 Permit Number 37027 6007539.30835 2095267.7389900002 37.7336323917164 -122.41632041617399 (37.7336323917164, -122.416320416174)
17421 4245 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4038 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003639.78589 2100421.5344700003 37.7475634792894 -122.430169743652 (37.7475634792894, -122.430169743652)
17771 16032 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 155 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5993339.50797 2095294.7939400002 37.7328979594755 -122.465414825734 (37.7328979594755, -122.465414825734)
18999 4466 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1484 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6004525.42539 2100206.65772 37.747023599154204 -122.427091952431 (37.7470235991542, -122.427091952431)
19052 22819 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 61 Turquoise Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 2X2 10/31/08 5999145.766480001 2099274.26515 37.7441577943622 -122.445627242426 (37.7441577943622, -122.445627242426)
19220 4482 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1551 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004606.71516 2099825.83197 37.7459825358766 -122.426783743093 (37.7459825358766, -122.426783743093)
19342 26905 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Caine Ave 1 Median : Cutout 11 Tree 1 DPW 2     12 10   5997683.40035 2089758.8108400002 37.7179470200262 -122.449998089654 (37.7179470200262, -122.449998089654)
19568 26708 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 88X Noe St 1 Median : Cutout 11 Tree 1 DPW 2     12 3   6002857.07874 2107723.1475299997 37.767567597789295 -122.43339798423 (37.7675675977893, -122.43339798423)
20209 4252 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4072 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003430.396430001 2100411.11399 37.747523005287206 -122.430893055767 (37.7475230052872, -122.430893055767)
21257 4479 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1542 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6004543.28364 2099929.0819200003 37.7462624498637 -122.427010433384 (37.7462624498637, -122.427010433384)
21291 2046 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 701X Bosworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6001912.87216 2095420.3332200001 37.733733385587 -122.43578352768299 (37.733733385587, -122.435783527683)
22187 4461 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1451 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6004572.77209 2100404.42204 37.74756929159079 -122.42694231424299 (37.7475692915908, -122.426942314243)
22909 209066 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 San Aleso Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5993360.06028 2094684.7320599998 37.7312240657298 -122.46529947329901 (37.7312240657298, -122.465299473299)
23224 4372 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1007 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 3X3   6000961.422590001 2096155.46194 37.7356977864326 -122.439125632357 (37.7356977864326, -122.439125632357)
23439 209167 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 102 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   5992842.6234800005 2095968.7682299998 37.7347198555328 -122.46718165450599 (37.7347198555328, -122.467181654506)
23691 126591 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2547 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6002516.512 2116417.22855 37.7914200340546 -122.435197883791 (37.7914200340546, -122.435197883791)
23961 247944 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 21 Joy St 1 Front Yard : Yard 7 Tree 1 Private 1     23     6010317.99645 2098902.9194900002 37.7437696775404 -122.40696976733999 (37.7437696775404, -122.40696976734)
24101 141230 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 16 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 0ft   5996536.7759 2114447.1732 37.7856694107907 -122.45574506618999 (37.7856694107907, -122.45574506619)
24217 206259 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 125 Congo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6000067.98121 2094222.9592799998 37.73034070664679 -122.442075923983 (37.7303407066468, -122.442075923983)
24482 223960 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 646 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002361.48335 2104431.90571 37.75850251878121 -122.434876784451 (37.7585025187812, -122.434876784451)
24685 32723 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1082 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/1996 12:00:00 AM 12   Permit Number 37114 6007012.43686 2114697.78275 37.786953139214894 -122.419519994465 (37.7869531392149, -122.419519994465)
24829 126588 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 116 Alhambra St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 4ft   6001687.928040001 2120423.89073 37.8023741929754 -122.438351935704 (37.8023741929754, -122.438351935704)
25083 250988 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 401 45th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5981857.67732 2112961.27677 37.780736228431394 -122.50641942431999 (37.7807362284314, -122.50641942432)
26017 82939 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 741 Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2009 12:00:00 AM 7 3x3 Permit Number 52449 6009171.80953 2110382.94472 37.775227013061 -122.411744028881 (37.775227013061, -122.411744028881)
26861 223941 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2920 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 5ft   6008707.1886599995 2103338.13414 37.755857516419795 -122.412853084526 (37.7558575164198, -122.412853084526)
26878 182670 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3130 Pacheco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5985221.0937 2101626.7981 37.749812382761604 -122.493948347017 (37.7498123827616, -122.493948347017)
27432 66268 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2008 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/1990 12:00:00 AM 12   Permit Number 29375 5986711.6119 2096941.9622 37.7370361716902 -122.488449873835 (37.7370361716902, -122.488449873835)
28127 191847 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2101 Newcomb Ave 1 Side Yard : Yard 17 Tree 1 Private 1     23 Width 10ft   6012411.60288 2097770.43241 37.7407770404189 -122.39965102878901 (37.7407770404189, -122.399651028789)
29057 209157 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 521 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5994454.52173 2099702.14157 37.7450636850368 -122.46187943880501 (37.7450636850368, -122.461879438805)
29272 206257 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 470 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998979.032869999 2094999.63504 37.7324111582444 -122.44589639242099 (37.7324111582444, -122.445896392421)
29750 192007 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1201 Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   6017817.46724 2093902.85475 37.730457297459395 -122.38069061399099 (37.7304572974594, -122.380690613991)
29776 209070 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 San Benito Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 8ft   5992811.17187 2096755.1283099998 37.7368771879369 -122.467347553363 (37.7368771879369, -122.467347553363)
30141 42966 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 160 Belgrave Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/13/2000 12:00:00 AM     Permit Number 42854 5997814.60948514 2104925.35351079 37.75959819679839 -122.45063741216002 (37.7595981967984, -122.45063741216)
30876 37950 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 609 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/08/1998 12:00:00 AM 17   Permit Number 40190 6013298.71774 2104246.1656 37.7586074292188 -122.397037638472 (37.7586074292188, -122.397037638472)
30956 191848 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1951 Revere Ave 1 Front Yard : Yard 7 Tree 1 Private 1     12     6013055.009930001 2095902.15156 37.735682976376204 -122.397295372485 (37.7356829763762, -122.397295372485)
31651 209143 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 338 Grafton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995743.47227 2090580.0284400003 37.7200906944019 -122.456762889002 (37.7200906944019, -122.456762889002)
31782 223948 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 469 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6003275.133640001 2103282.37568 37.755398015022 -122.43163490472601 (37.755398015022, -122.431634904726)
31873 209098 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 65 Terrace Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 10ft   5993139.75731 2097020.83026 37.7376257026686 -122.46623080131201 (37.7376257026686, -122.466230801312)
32610 176356 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 450 Italy Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 2ft   6001754.19818 2089213.77814 37.716682575925 -122.43588817192101 (37.716682575925, -122.435888171921)
33569 209056 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1364 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 2ft   5992426.38178 2106168.37832 37.7627013248255 -122.469362904392 (37.7627013248255, -122.469362904392)
34621 142349 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 101 Jean Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 0ft   5998390.8197 2112613.6039 37.780741136182996 -122.44919849112499 (37.780741136183, -122.449198491125)
34903 209050 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1957 11th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   5992832.0563900005 2102279.47717 37.752046850582104 -122.46767699299299 (37.7520468505821, -122.467676992993)
35579 191894 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1195 La Salle Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6017504.55596 2094293.80074 37.731513484662706 -122.381799585104 (37.7315134846627, -122.381799585104)
35740 223964 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 90 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6001033.19206 2105884.60415 37.7624157676075 -122.439574740289 (37.7624157676075, -122.439574740289)
35963 140902 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2301 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6000347.067000001 2113317.3521 37.782785144864 -122.442481446452 (37.782785144864, -122.442481446452)
36449 176377 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Crespi Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5989839.20092 2090334.4554299999 37.7190756251255 -122.47715379871201 (37.7190756251255, -122.477153798712)
37159 249463 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Van Ness Ave 1 Median : Yard 3 Tree 1 DPW 2     27     6006539.42856 2113694.50869 37.7841717411666 -122.421085234814 (37.7841717411666, -122.421085234814)
37535 223924 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1013 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6008041.687530001 2101929.49372 37.751952331841295 -122.41505490906601 (37.7519523318413, -122.415054909066)
37598 223959 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 642 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002363.563630001 2104457.3204 37.7585724195079 -122.434871407414 (37.7585724195079, -122.434871407414)
37807 32670 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 450 Clementina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 25   Permit Number 37094 6011135.7894 2112024.86418 37.7798453222359 -122.405065778479 (37.7798453222359, -122.405065778479)
38827 191997 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1301 Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 3ft   6017389.868919999 2093956.67155 37.7305814605653 -122.382172640078 (37.7305814605653, -122.382172640078)
40152 223947 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4261 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6001509.65338 2101728.3731 37.7510308684778 -122.437629173946 (37.7510308684778, -122.437629173946)
40220 223962 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 393 Cumberland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6003123.78162 2104447.14367 37.7585876099598 -122.432241505563 (37.7585876099598, -122.432241505563)
40488 32598 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1488 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/23/1996 12:00:00 AM 10   Permit Number 770751 5985603.1005 2105094.5695 37.759356274150704 -122.492882766578 (37.7593562741507, -122.492882766578)
41202 191993 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1395 Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 3ft   6017281.31768 2093927.6967 37.7304959053633 -122.382545906371 (37.7304959053633, -122.382545906371)
41375 45055 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2311 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/23/2011 12:00:00 AM 1   Permit Number 767715 5988234.443 2099548.661 37.7442822204704 -122.483375858058 (37.7442822204704, -122.483375858058)
41800 137854 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 411 Austin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005199.1009 2115273.8946 37.788432693763795 -122.425834752578 (37.7884326937638, -122.425834752578)
42119 209145 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 28 Majestic Ave 1 : 4 Tree 1 Private 1     14 Width 3ft   5997357.5739 2089785.01334 37.7180003165514 -122.451126211806 (37.7180003165514, -122.451126211806)
42307 191856 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 456 Clementina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6011076.636030001 2111968.79366 37.7796880587057 -122.405266467595 (37.7796880587057, -122.405266467595)
43047 223922 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 515 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 2ft   6008751.14377 2096401.61685 37.7368138450695 -122.41221084445299 (37.7368138450695, -122.412210844453)
43280 202107 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1833 Egbert Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 5ft   6011947.78492 2092850.2983099998 37.727241516067 -122.40090914794399 (37.727241516067, -122.400909147944)
43783 191833 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1900 Jerrold Ave 1 : 4 Tree 1 Private 1     27 Width 5ft   6013734.98018 2098203.9555900004 37.74204108523121 -122.395105613257 (37.7420410852312, -122.395105613257)
43785 209158 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 290 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992876.2231 2094948.79884 37.731921212982606 -122.46699136156799 (37.7319212129826, -122.466991361568)
43900 31372 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 608 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/13/1997 12:00:00 AM 16   Permit Number 34974 5991288.7498699995 2099114.74799 37.7432680941565 -122.472783188016 (37.7432680941565, -122.472783188016)
44468 176364 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5988874.21496 2090711.48965 37.720054833031504 -122.480516928613 (37.7200548330315, -122.480516928613)
44668 209162 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 170 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 3ft   5992852.82391 2095595.8351099999 37.733696463012706 -122.467119282923 (37.7336964630127, -122.467119282923)
45086 209100 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 45 Terrace Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 10ft   5993050.40784 2097059.35291 37.737726320615295 -122.466542521627 (37.7377263206153, -122.466542521627)
45093 176361 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 33 Burr Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 3ft   6007913.680380001 2086634.77605 37.70994915030529 -122.414415456032 (37.7099491503053, -122.414415456032)
46240 103374 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 22 Vandewater St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 2.5x2.5   6009121.9449 2121331.1603 37.805285357407996 -122.41269066800301 (37.805285357408, -122.412690668003)
46492 209168 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 380 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5993162.82145 2095507.94879 37.7334730381415 -122.466041155002 (37.7334730381415, -122.466041155002)
46808 209073 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 44 San Benito Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 8ft   5992818.00248 2096487.9953 37.736144101953705 -122.467304518983 (37.7361441019537, -122.467304518983)
46907 68269 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 424 Somerset St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 13   Permit Number 32076 6010049.762159999 2092483.07672 37.7261271472388 -122.40744475327499 (37.7261271472388, -122.407444753275)
47117 191814 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1301 Iowa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 9ft   6014800.46205 2101999.0803099996 37.752520895829704 -122.391686773025 (37.7525208958297, -122.391686773025)
47483 223974 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2 Miguel St 1 Front Yard : Yard 7 Tree 1 Private 1     41     6003823.8109 2097275.5293400004 37.7389356956285 -122.429309094259 (37.7389356956285, -122.429309094259)
48443 209142 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 436 Holloway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5995442.598040001 2091242.1505900002 37.7218914438109 -122.457850790783 (37.7218914438109, -122.457850790783)
48476 36977 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 181 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM 16   Permit Number 39602 5993647.32145 2114324.1067 37.7851652576674 -122.46573272346599 (37.7851652576674, -122.465732723466)
49266 209178 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2023 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5993462.72736 2101706.8649 37.750510998299106 -122.465454464278 (37.7505109982991, -122.465454464278)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 730.579ms · Data source: data.sfgov.org