Data source: data.sfgov.org
This data as json, CSV (advanced)
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 | 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 | 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) | |||
| 121 | 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 | 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) | ||||
| 224 | 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 | 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) | |||
| 441 | 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 | 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 | ||||||||
| 802 | 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 | 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) | |||
| 1564 | 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 | 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) | |||||
| 1794 | 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 | 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) | |||
| 1880 | 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 | 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 | 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 | 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 | 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) | ||
| 2153 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | ||
| 2640 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | ||
| 2808 | 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 | 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 | 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) | |||
| 2934 | 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) |
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");