home / sf-trees

Street_Tree_List

8,683 rows where qSpecies = 2

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
2 232565 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 940 Elizabeth St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/20/2017 12:00:00 AM 3 Width 4ft Permit Number 779625 6000396.48544 2101998.8644 37.7517102172731 -122.441498017841 (37.7517102172731, -122.441498017841)
45 27522 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 3201 California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3X3   5998967.7443 2114917.3257 37.787099536792 -122.44736849888001 (37.787099536792, -122.44736849888)
79 251205 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000X Market St 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       4X4   6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
88 251208 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4115 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5982071.0 2104840.0 37.758450113202294 -122.505079418654 (37.7584501132023, -122.505079418654)
110 97646 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1824 Noriega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   5988290.0 2103126.0 37.7541078738982 -122.48344595561899 (37.7541078738982, -122.483445955619)
121 59839 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1201 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/1981 12:00:00 AM 3   Permit Number 19293 6016946.5018 2093669.1216 37.729767407645895 -122.383685429115 (37.7297674076459, -122.383685429115)
124 20281 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 20X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
140 6337 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1916 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6001700.9234 2112915.307 37.7817583075946 -122.437768878541 (37.7817583075946, -122.437768878541)
148 175046 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 80X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 Width 3ft   5991566.54873 2087591.2585200001 37.7116435395983 -122.47098334961399 (37.7116435395983, -122.470983349614)
173 175044 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 80x Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 Width 3ft   5991568.948890001 2087568.2224599998 37.7115804269636 -122.470973377029 (37.7115804269636, -122.470973377029)
193 6069 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1930 Eddy St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/2015 12:00:00 AM 3 3X3   6001175.3543 2112495.6639 37.7805761758993 -122.439557004629 (37.7805761758993, -122.439557004629)
196 251246 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 722X Mendell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
218 11423 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 722X Mendell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     0 3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
222 251247 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 722X Mendell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
224 117019 Planning Code 138.1 required 4 Metrosideros excelsa :: New Zealand Xmas Tree 2 168 Hyde St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.41556230388201 (37.782365960952, -122.415562303882)
242 194017 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 717 Mendell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 Width 4ft   6016141.23024 2096883.95841 37.7385501598741 -122.386693461838 (37.7385501598741, -122.386693461838)
244 9908 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1809 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 6x6   6005225.98494 2115998.17525 37.79042290624211 -122.425793311632 (37.7904229062421, -122.425793311632)
275 818 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1385 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   5982124.8821 2105687.3873 37.7607799675436 -122.504955867812 (37.7607799675436, -122.504955867812)
441 251295 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 220 Point Lobos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1989 12:00:00 AM   3x3 Permit Number 27117 5982087.0 2112698.0 37.7800268469822 -122.50560657808902 (37.7800268469822, -122.505606578089)
447 27524 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 3201 California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 3X3   5999021.2149 2114925.4479 37.787124893549795 -122.447184087894 (37.7871248935498, -122.447184087894)
475 6052 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1900 Eddy St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/2003 12:00:00 AM 3 3X3   6001270.4508 2112511.2313 37.7806243318768 -122.439229137442 (37.7806243318768, -122.439229137442)
497 14419 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2X Masonic Ave 7 Median : Cutout 11 Tree 1 DPW 2     35     5998835.1676 2113089.5942 37.7820734871416 -122.447695558807 (37.7820734871416, -122.447695558807)
579 2702 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 2121 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6003192.7078 2114808.0993 37.7870401500361 -122.432743262211 (37.7870401500361, -122.432743262211)
651 251359 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4050 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5994421.0 2112898.0 37.7812941506761 -122.462952553035 (37.7812941506761, -122.462952553035)
704 2199 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1100 Broderick St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000885.4114 2112518.5919999997 37.7806226245627 -122.440561697516 (37.7806226245627, -122.440561697516)
706 2833 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1200 California St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6008452.59238 2116301.4374700002 37.7914373972624 -122.41465089583099 (37.7914373972624, -122.414650895831)
738 20446 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 495X Sunset Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15            
802 64866 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 2185 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/02/1989 12:00:00 AM 13   Permit Number 25884 5997401.9097 2109840.7512 37.773070992957 -122.45241943675501 (37.773070992957, -122.452419436755)
811 175379 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 80X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 Width 3ft   5991355.5778 2088944.15197 37.7153460520673 -122.47181104966499 (37.7153460520673, -122.471811049665)
822 177714 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 80X Junipero Serra Blvd 20 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 4ft   5991271.7328699995 2089255.2484 37.7161953951732 -122.472123514597 (37.7161953951732, -122.472123514597)
848 2190 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1055 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6000864.0909 2112351.4116 37.7801623757286 -122.44062346036199 (37.7801623757286, -122.440623460362)
872 5299 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1635 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   6001101.8528 2114070.3216 37.7848955998057 -122.43992421757 (37.7848955998057, -122.43992421757)
1006 232567 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 947 Elizabeth St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   6000330.76798 2101953.15424 37.751580964011204 -122.441721996685 (37.7515809640112, -122.441721996685)
1031 8753 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 3330 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/12/1993 12:00:00 AM 6 3X3   5996823.9268 2112988.7445 37.7816814274235 -122.45464621041799 (37.7816814274235, -122.454646210418)
1071 177641 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 5900 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     0 Width 4ft   5996637.80016 2086397.8441299999 37.708658698704795 -122.45336973165199 (37.7086586987048, -122.453369731652)
1081 3617 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 100X Cargo Way 53 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:16:00 PM 3 3X3   6017937.25359 2098269.56212 37.742454020638796 -122.380579893948 (37.7424540206388, -122.380579893948)
1114 232676 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 73 Montezuma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x5   6007815.58423 2099781.3356 37.7460412642866 -122.41568472316901 (37.7460412642866, -122.415684723169)
1141 251461 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 6400 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/01/1993 12:00:00 AM   3x3   5987191.0 2112582.0 37.7800074013317 -122.48794125088699 (37.7800074013317, -122.487941250887)
1245 6073 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1944 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001125.2679 2112488.2186 37.7805528822601 -122.439729742976 (37.7805528822601, -122.439729742976)
1352 8658 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2807 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/1994 12:00:00 AM 6 3X3   5998399.1111 2113100.5929 37.7820787552534 -122.44920490204599 (37.7820787552534, -122.449204902046)
1370 141258 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 51 COMMONWEALTH AVE 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5996495.6576 2114088.9538 37.7846834760254 -122.455861417999 (37.7846834760254, -122.455861417999)
1426 5257 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1199 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6001336.2739 2112445.4083 37.780447344039395 -122.43899670569701 (37.7804473440394, -122.438996705697)
1437 111252 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 3129x Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   5983208.5024 2097401.5189 37.7380929647396 -122.500595473335 (37.7380929647396, -122.500595473335)
1442 111247 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 3101x Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x4   5983327.0508 2097406.6113 37.738113905777794 -122.500185975345 (37.7381139057778, -122.500185975345)
1490 8186 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1247 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6001773.6755 2111139.4897 37.7768864982616 -122.437389990835 (37.7768864982616, -122.437389990835)
1497 20382 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 262X Sunset Blvd 28 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
1538 3145 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 3333 California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X3   5998356.8929 2114831.5358 37.7868290555036 -122.449475716773 (37.7868290555036, -122.449475716773)
1542 6967 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 720 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003956.4801 2110455.6856 37.7751327920886 -122.42979022245899 (37.7751327920886, -122.429790222459)
1564 106910 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 3536 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/23/2014 12:00:00 AM 3 4x4 Permit Number 773298 5997359.139830001 2116076.9553400003 37.7901915187728 -122.453017625461 (37.7901915187728, -122.453017625461)
1606 8736 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 3240 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/1986 12:00:00 AM 3 3X3   5997038.8246 2113016.8335 37.781770875875004 -122.45390479883801 (37.781770875875, -122.453904798838)
1653 14428 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2X Masonic Ave 4 Median : Cutout 11 Tree 1 DPW 2     70 12   5998837.5365 2113112.2684 37.782135879985205 -122.447688996293 (37.7821358799852, -122.447688996293)
1760 14433 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2X Masonic Ave 5 Median : Cutout 11 Tree 1 DPW 2     50 3X3   5998837.1981 2113100.4237 37.7821033381799 -122.447689314061 (37.7821033381799, -122.447689314061)
1769 251689 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 355 Silver Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003702.0 2093526.0 37.728633439635104 -122.429462937782 (37.7286334396351, -122.429462937782)
1794 81999 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1150 Francisco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005960.45556 2120727.0973099996 37.803448808170295 -122.423588442877 (37.8034488081703, -122.423588442877)
1855 231238 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000 Bryant St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009516.72537 2105318.46782 37.7613404716081 -122.41019324155 (37.7613404716081, -122.41019324155)
1862 107591 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2760 Broderick St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6000103.81735 2118107.41373 37.7959235348996 -122.443667208689 (37.7959235348996, -122.443667208689)
1866 231240 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000 Bryant St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6009523.77815 2105243.21899 37.7611342507514 -122.410163536041 (37.7611342507514, -122.410163536041)
1868 231236 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000 Bryant St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6009517.72345 2105367.35909 37.7614747718611 -122.41019324152599 (37.7614747718611, -122.410193241526)
1880 231235 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000 Bryant St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft Permit Number 779645 6009517.2839 2105385.27542 37.7615239413898 -122.41019602672701 (37.7615239413898, -122.410196026727)
1886 231239 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000 Bryant St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft Permit Number 779645 6009523.6668300005 2105264.06886 37.7611914935157 -122.410165393114 (37.7611914935157, -122.410165393114)
1889 231241 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000 Bryant St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft Permit Number 779645 6009524.44231 2105223.15964 37.7610792095625 -122.410159822741 (37.7610792095625, -122.410159822741)
1894 231237 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000 Bryant St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft Permit Number 779645 6009518.21853 2105339.01767 37.7613969805183 -122.410189528218 (37.7613969805183, -122.410189528218)
1900 8769 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 3416 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1992 12:00:00 AM 3 3X3   5996444.0483 2112944.9189 37.78153929807 -122.455957233363 (37.78153929807, -122.455957233363)
1953 10672 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1099X Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002688.4855 2110577.4857 37.775395340044 -122.43418520195 (37.775395340044, -122.43418520195)
1976 8649 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2800 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   5998323.3892 2113195.774 37.7823357663321 -122.449473724518 (37.7823357663321, -122.449473724518)
2034 138249 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1599 Scott St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6001639.6094 2113829.7369999997 37.784265612888206 -122.438046517704 (37.7842656128882, -122.438046517704)
2067 252866 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1660 Masonic Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6000023.0 2106990.0 37.7653933634599 -122.443148003218 (37.7653933634599, -122.443148003218)
2073 252864 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1660 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000023.0 2106990.0 37.7653933634599 -122.443148003218 (37.7653933634599, -122.443148003218)
2075 252867 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1660 Masonic Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6000023.0 2106990.0 37.7653933634599 -122.443148003218 (37.7653933634599, -122.443148003218)
2083 252865 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1660 Masonic Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6000023.0 2106990.0 37.7653933634599 -122.443148003218 (37.7653933634599, -122.443148003218)
2125 117673 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 7600x Geary Blvd 2 Median : Cutout 11 Tree 1 DPW 2     23 Width 6ft   5983555.0 2112529.0 37.779649107322506 -122.50051568716002 (37.7796491073225, -122.50051568716)
2128 114975 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 25 Point Lobos Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 3x3   5982783.76519 2112486.06679 37.7794859217892 -122.50318049806101 (37.7794859217892, -122.503180498061)
2136 24780 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 25 Point Lobos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   5982810.69991 2112498.67348 37.779522119266204 -122.503088254558 (37.7795221192662, -122.503088254558)
2138 113191 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 25 Point Lobos Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2016 11:27:00 AM 3 3X3   5982732.526959999 2112491.91452 37.7794989659934 -122.50335818303499 (37.7794989659934, -122.503358183035)
2145 113190 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 25 Point Lobos Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2016 11:22:00 AM 3 3X3   5982767.26188 2112487.6869200002 37.7794894001028 -122.503237709063 (37.7794894001028, -122.503237709063)
2153 251201 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000X Market St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/27/2017 12:00:00 AM 3   Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2158 251202 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000X Market St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/27/2017 12:00:00 AM 3 4X4 Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2159 251203 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000X Market St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/27/2017 12:00:00 AM 3 4X4 Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2162 251204 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000X Market St 4 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/27/2017 12:00:00 AM 3 4X4 Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2451 2187 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1040 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   6000917.5615 2112301.3252 37.7800278959817 -122.440434888409 (37.7800278959817, -122.440434888409)
2475 213240 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 72 Majestic Ave 1 : 4 Tree 1 Private 1   11/24/1982 12:00:00 AM 14 Width 3ft Permit Number 20046 5997197.846969999 2089560.74227 37.7173753740534 -122.451662146612 (37.7173753740534, -122.451662146612)
2499 8641 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2600X Geary Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   5999196.602000001 2113264.8967 37.7825754726316 -122.446457780402 (37.7825754726316, -122.446457780402)
2559 19580 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 100 STAIRWAY4 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 8            
2599 56658 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 2436 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13     5987881.10051 2113316.56801 37.7820645490157 -122.485607837735 (37.7820645490157, -122.485607837735)
2609 23699 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 2100X Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/08/2006 12:00:00 AM 3 3X3   6005145.75001 2116914.64586 37.7929347693837 -122.42613619164301 (37.7929347693837, -122.426136191643)
2640 183247 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2890 Rivera St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984262.8939 2100232.1038 37.7459268239815 -122.49715885534201 (37.7459268239815, -122.497158855342)
2648 183237 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2001 37th Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984780.1717 2100543.2827 37.7468115375468 -122.495393151852 (37.7468115375468, -122.495393151852)
2656 183240 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2001 37th Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984790.3243 2100348.3517 37.7462769046122 -122.495343672098 (37.7462769046122, -122.495343672098)
2668 183245 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2706 Rivera St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984600.1313 2100244.4562 37.745980498085295 -122.495993663284 (37.7459804980853, -122.495993663284)
2671 8707 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 3100 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/1986 12:00:00 AM 12 3X3   5997465.2361 2113075.7189 37.781956998716396 -122.452433873123 (37.7819569987164, -122.452433873123)
2672 183250 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2107 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984200.2859 2100804.8827 37.7474958486327 -122.497417620086 (37.7474958486327, -122.497417620086)
2742 2689 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 2103 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3X3   6003388.0503 2114834.422 37.7871235022131 -122.43206930161199 (37.7871235022131, -122.432069301612)
2755 2701 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 2121 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6003174.2357 2114805.7903 37.787032762464705 -122.432807006492 (37.7870327624647, -122.432807006492)
2803 8755 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 3330 Geary Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/12/1993 12:00:00 AM 3 3X3   5996762.334 2112977.2381 37.7816463009434 -122.454858459552 (37.7816463009434, -122.454858459552)
2808 232604 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 509 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/1989 12:00:00 AM 14 Width 3ft Permit Number 28219 6003467.96193 2095980.6299 37.7353600451305 -122.430447088284 (37.7353600451305, -122.430447088284)
2832 232603 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 519 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/1989 12:00:00 AM 15 Width 3ft Permit Number 28180 6003417.91848 2095942.05224 37.7352512847143 -122.430617355104 (37.7352512847143, -122.430617355104)
2845 2651 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1958 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004155.6542 2114999.6285 37.787620606441294 -122.429425346374 (37.7876206064413, -122.429425346374)
2851 18919 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2645 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002161.66396 2115714.10413 37.7894692786198 -122.43637530499201 (37.7894692786198, -122.436375304992)
2870 2203 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1120 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 7x5   6000884.7346 2112533.821 37.780664400973 -122.440565131493 (37.780664400973, -122.440565131493)
2934 250407 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 25 Seacliff Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/16/1997 12:00:00 AM 12 Width 4ft Permit Number 38521 5987994.17396 2115794.4903599997 37.78887480516529 -122.485398549405 (37.7888748051653, -122.485398549405)

Next page

Advanced export

JSON shape: default, array

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))
Powered by Datasette · Query took 130.532ms