Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45 | 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 | 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 | 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 | 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) | |||
124 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | ||||
242 | 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 | 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 | 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) | |||
447 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | ||||||||
811 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
1606 | 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 | 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 | 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 | 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) | |||||
1855 | 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 | 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 | 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 | 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) | |||
1900 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | ||
2451 | 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) | |||
2499 | 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 | 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 | 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 | 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) | ||
2671 | 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) | ||
2742 | 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 | 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 | 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) | ||
2845 | 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 | 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 | 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) | |||
2940 | 2940 | 250421 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5987880.27353 | 2115792.69032 | 37.788863226412296 | -122.485792492053 | (37.7888632264123, -122.485792492053) | |||
2967 | 2967 | 90257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3230 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5985539.08481 | 2111145.48476 | 37.775966641531504 | -122.49355000935199 | (37.7759666415315, -122.493550009352) | ||
2985 | 2985 | 250408 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Seacliff Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5988046.91633 | 2115796.65095 | 37.7888838100916 | -122.485216228949 | (37.7888838100916, -122.485216228949) | |||
2987 | 2987 | 250422 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987891.12003 | 2115793.8659200002 | 37.7888670862959 | -122.48575505145399 | (37.7888670862959, -122.485755051454) | |||
3001 | 3001 | 7734 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006417.36011 | 2111247.6082200003 | 37.777446266458 | -122.42133372647699 | (37.777446266458, -122.421333726477) | |||
3017 | 3017 | 250423 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987905.22883 | 2115793.56651 | 37.7888670863011 | -122.485706215587 | (37.7888670863011, -122.485706215587) | |||
3089 | 3089 | 2184 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1030 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6000920.2689 | 2112277.9741 | 37.779963933965995 | -122.440423847121 | (37.779963933966, -122.440423847121) | |||
3157 | 3157 | 6076 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1950 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001110.3773 | 2112486.1881 | 37.780546459454996 | -122.439781110889 | (37.780546459455, -122.439781110889) | |||
3173 | 3173 | 6353 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1985 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1992 12:00:00 AM | 6 | 3X3 | 6001392.1135 | 2112821.0565 | 37.7814819554931 | -122.43883045753701 | (37.7814819554931, -122.438830457537) | ||
3175 | 3175 | 10515 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1801 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2017 12:00:00 AM | 3 | 3X3 | 5997497.7686 | 2108463.8393 | 37.7692958388006 | -122.451988492124 | (37.7692958388006, -122.451988492124) | ||
3232 | 3232 | 253369 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 449X Trumbull St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Width 10ft | 6005840.0 | 2094317.0 | 37.730926169648 | -122.42212790794599 | (37.730926169648, -122.422127907946) | ||||
3314 | 3314 | 8704 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3040 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997630.7244 | 2113099.07 | 37.7820305944204 | -122.45186304771099 | (37.7820305944204, -122.451863047711) | |||
3381 | 3381 | 8153 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1052 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6002732.6953 | 2111326.1234 | 37.777453421805895 | -122.434085798199 | (37.7774534218059, -122.434085798199) | |||
3426 | 3426 | 8640 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5999291.3601 | 2113278.772 | 37.782618982387596 | -122.446130957827 | (37.7826189823876, -122.446130957827) | |||
3470 | 3470 | 8669 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998067.7961 | 2113159.1399 | 37.7822205542064 | -122.450355317805 | (37.7822205542064, -122.450355317805) | |||
3476 | 3476 | 8169 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1178 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6002155.3413 | 2111245.817 | 37.7772001368339 | -122.436077305312 | (37.7772001368339, -122.436077305312) | |||
3477 | 3477 | 22794 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1015X Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6000886.4267 | 2112199.4602 | 37.7797464277805 | -122.440535289267 | (37.7797464277805, -122.440535289267) | |||
3487 | 3487 | 18489 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 29 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6010385.55842 | 2113872.45132 | 37.784876392368396 | -122.40779148690201 | (37.7848763923684, -122.407791486902) | |||
3529 | 3529 | 6070 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/2015 11:12:00 AM | 3 | 3X3 | 6001158.0948 | 2112492.6181 | 37.78056683058671 | -122.43961649489799 | (37.7805668305867, -122.439616494898) | ||
3677 | 3677 | 210350 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992051.8911 | 2099003.24187 | 37.7430060748628 | -122.470136351038 | (37.7430060748628, -122.470136351038) | |||
3734 | 3734 | 118035 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 5984123.0 | 2112760.0 | 37.7803166927985 | -122.498567828267 | (37.7803166927985, -122.498567828267) | |||
3770 | 3770 | 94964 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3098 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2010 12:00:00 AM | 12 | 5999368.8526 | 2116683.0767599996 | 37.791970737501 | -122.446107814943 | (37.791970737501, -122.446107814943) | |||
3807 | 3807 | 90290 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4825X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980449.0 | 2110794.0 | 37.7747024934985 | -122.51113148443301 | (37.7747024934985, -122.511131484433) | ||
3811 | 3811 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 37 | 5998700.41574 | 2091522.98281 | 37.722849171448395 | -122.446609585371 | (37.7228491714484, -122.446609585371) |
JSON shape: default, array, newline-delimited
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");