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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 2944 | 2944 | 232231 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 111 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37780 | 6003645.44992 | 2108813.0512099997 | 37.7706049033258 | -122.430748898054 | (37.7706049033258, -122.430748898054) | |
| 2955 | 2955 | 232230 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 111 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37780 | 6003632.85461 | 2108809.4147799998 | 37.7705942049744 | -122.430792205812 | (37.7705942049744, -122.430792205812) | |
| 2983 | 2983 | 250419 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | 8 | Width 4ft | Permit Number 38081 | 5987849.1846199995 | 2115791.00757 | 37.7888567944531 | -122.48589993045601 | (37.7888567944531, -122.485899930456) | |
| 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) | |||
| 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) | |||
| 3167 | 3167 | 210018 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 129 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 10 | Width 3ft | Permit Number 25335 | 5995846.58682 | 2096221.4645200002 | 37.7355866437016 | -122.45681426186701 | (37.7355866437016, -122.456814261867) | |
| 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) | ||
| 3177 | 3177 | 46976 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44996 | ||||||||
| 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) | |||
| 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) | |||
| 3635 | 3635 | 210326 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1515 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 6 | Width 2ft | Permit Number 31364 | 5994586.35542 | 2105191.7373900004 | 37.760144306721 | -122.46182156022499 | (37.760144306721, -122.461821560225) | |
| 3648 | 3648 | 210351 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 15 | Width 4ft | Permit Number 35554 | 5992053.09945 | 2099023.47402 | 37.743061697037895 | -122.470133645862 | (37.7430616970379, -122.470133645862) | |
| 3659 | 3659 | 209947 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 13 | Width 3ft | Permit Number 35554 | 5992051.55672 | 2099045.56782 | 37.7431222717841 | -122.47014058862301 | (37.7431222717841, -122.470140588623) | |
| 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) | |||
| 3833 | 3833 | 246108 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1899 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997166.7764 | 2108416.598 | 37.769147161957605 | -122.453129960901 | (37.7691471619576, -122.453129960901) | |||
| 3844 | 3844 | 246107 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1899 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997126.5002 | 2108412.0556 | 37.7691323812935 | -122.453268945279 | (37.7691323812935, -122.453268945279) | |||
| 3847 | 3847 | 246106 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1899 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997112.57 | 2108409.6329 | 37.769124930744795 | -122.453316953855 | (37.7691249307448, -122.453316953855) | |||
| 3848 | 3848 | 131894 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1902 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5999986.70949 | 2115482.27208 | 37.788708906339295 | -122.443883720452 | (37.7887089063393, -122.443883720452) | |||
| 3861 | 3861 | 253579 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3862 | 3862 | 253583 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3865 | 3865 | 253578 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3866 | 3866 | 253581 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3867 | 3867 | 253577 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3869 | 3869 | 253580 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3870 | 3870 | 253584 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3871 | 3871 | 253582 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 4018 | 4018 | 2214 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1180 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x6 | 6000870.8593 | 2112663.4365 | 37.7810195019401 | -122.440622432274 | (37.7810195019401, -122.440622432274) | |||
| 4275 | 4275 | 24939 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7315 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 10:40:00 AM | 3 | 3X3 | 5984290.37601 | 2112411.90952 | 37.7793707517194 | -122.497963093664 | (37.7793707517194, -122.497963093664) | ||
| 4706 | 4706 | 2834 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 6008517.592999999 | 2116245.0199599997 | 37.791286140299 | -122.414422000399 | (37.791286140299, -122.414422000399) | |||
| 4808 | 4808 | 248401 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 721 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 10 | Width 0ft | Permit Number 35191 | 5998539.5007 | 2108099.8388 | 37.7683559999766 | -122.44835899152099 | (37.7683559999766, -122.448358991521) | |
| 4847 | 4847 | 76692 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 423 Burrows St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1988 12:00:00 AM | 13 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 5296 | 5296 | 117021 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008114.19003 | 2113031.70239 | 37.7824404814865 | -122.415590162171 | (37.7824404814865, -122.415590162171) | |
| 5297 | 5297 | 9909 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1850 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005266.16067 | 2116037.55632 | 37.790533307027296 | -122.425657110207 | (37.7905333070273, -122.425657110207) |
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");