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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141818 | 141818 | 92965 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3650X Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Tree 1 on Rivera St | 5981790.1 | 2100170.3 | 37.7456119015234 | -122.505704709348 | (37.7456119015234, -122.505704709348) | ||
| 145724 | 145724 | 93021 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1403 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | Tree 1 on Judah | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 102885 | 102885 | 56538 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1601 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Removed on Permit No. 49327 | 5990034.81385638 | 2101735.08104673 | 37.750390174718795 | -122.477310384437 | (37.7503901747188, -122.477310384437) | ||||
| 94452 | 94452 | 99756 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 517 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Probably planted at same time/permitted with tree no. 1 | 6001837.0 | 2100870.0 | 37.7486925868246 | -122.436435749617 | (37.7486925868246, -122.436435749617) | |||
| 124809 | 124809 | 54207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 525 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9945 | 5994167.427381 | 2106639.11364061 | 37.7640943000648 | -122.463375455955 | (37.7640943000648, -122.463375455955) | |||
| 171697 | 171697 | 54075 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1682 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 4 | Permit Number 9798 | 5981308.9916 | 2103651.7218 | 37.7551425766668 | -122.507626563979 | (37.7551425766668, -122.507626563979) | ||
| 31447 | 31447 | 54069 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1645 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 8 | Permit Number 9792 | 5981258.5718 | 2103857.679 | 37.7557051061066 | -122.50781621048901 | (37.7557051061066, -122.507816210489) | ||
| 129773 | 129773 | 54065 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1632 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 19 | Permit Number 9788 | 5981297.9909 | 2103950.8792 | 37.7559633296946 | -122.507686804724 | (37.7559633296946, -122.507686804724) | ||
| 30058 | 30058 | 54064 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1619-1621 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 19 | Permit Number 9787 | 5981254.141 | 2104003.8963 | 37.7561063161195 | -122.50784238373001 | (37.7561063161195, -122.50784238373) | ||
| 92787 | 92787 | 54052 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 284 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1972 12:00:00 AM | 12 | 3x3 | Permit Number 9774 | 6009944.92418425 | 2114405.86793531 | 37.7863163497004 | -122.409353602077 | (37.7863163497004, -122.409353602077) | |
| 38151 | 38151 | 53972 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4535 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1972 12:00:00 AM | 9 | Permit Number 9687 | 5981468.436480001 | 2110942.49917 | 37.775170336800606 | -122.507616130998 | (37.7751703368006, -122.507616130998) | ||
| 6183 | 6183 | 53961 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2456 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 14 | 3x3 | Permit Number 9676 | 6002263.92073 | 2116681.1159200002 | 37.7921302538612 | -122.436090735194 | (37.7921302538612, -122.436090735194) | |
| 174301 | 174301 | 53960 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2450 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 17 | Permit Number 9675 | 6002267.14326 | 2116658.3059799997 | 37.7920678067298 | -122.436077952237 | (37.7920678067298, -122.436077952237) | ||
| 177441 | 177441 | 53905 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1092 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1972 12:00:00 AM | 14 | Permit Number 9617 | 6011225.8347 | 2089704.87272 | 37.718564526921895 | -122.403183775326 | (37.7185645269219, -122.403183775326) | ||
| 22879 | 22879 | 53904 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1075 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1972 12:00:00 AM | 15 | Permit Number 9616 | 6011239.099780001 | 2089785.6199599998 | 37.7187869832091 | -122.40314359991301 | (37.7187869832091, -122.403143599913) | ||
| 157949 | 157949 | 53887 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2832 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 14 | Permit Number 9598 | 6000597.067290001 | 2116527.8994 | 37.7916147228868 | -122.441847053694 | (37.7916147228868, -122.441847053694) | ||
| 56707 | 56707 | 53879 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1087 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1972 12:00:00 AM | 11 | Permit Number 9590 | 6011253.4806 | 2089742.6487599998 | 37.7186697961475 | -122.40309086994301 | (37.7186697961475, -122.403090869943) | ||
| 47890 | 47890 | 53819 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2838 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 16 | Permit Number 9516 | 6000579.27661 | 2116524.48723 | 37.791604340213105 | -122.441908364082 | (37.7916043402131, -122.441908364082) | ||
| 28343 | 28343 | 53818 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2820 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 16 | Permit Number 9515 | 6000665.39405 | 2116539.08536 | 37.7916493297009 | -122.44161144753299 | (37.7916493297009, -122.441611447533) | ||
| 42188 | 42188 | 53794 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3501 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1972 12:00:00 AM | 1 | Permit Number 9486 | 5983368.4333 | 2103547.9057 | 37.7549786359111 | -122.500496852361 | (37.7549786359111, -122.500496852361) | ||
| 103636 | 103636 | 53764 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 260 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1972 12:00:00 AM | Permit Number 9447 | 5992873.42694386 | 2095089.10735314 | 37.732306303916204 | -122.467011225343 | (37.7323063039162, -122.467011225343) | |||
| 36191 | 36191 | 53748 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2345 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/1972 12:00:00 AM | 5 | Permit Number 9428 | 6001733.38124 | 2118703.67656 | 37.797653522957 | -122.438071350827 | (37.797653522957, -122.438071350827) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 10140 | 10140 | 58977 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 508 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 9x9 | Permit Number 779525 | 5995325.65714 | 2112056.9249400003 | 37.779036849804 | -122.45976196403 | (37.779036849804, -122.45976196403) | |
| 23422 | 23422 | 54948 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1531 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/1972 12:00:00 AM | 15 | 6x3 | Permit Number 779312 | 5982470.8167 | 2104681.2673 | 37.758037793894204 | -122.503684942327 | (37.7580377938942, -122.503684942327) | |
| 9772 | 9772 | 31954 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 376 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779001 | 6007700.6127 | 2112534.0432 | 37.7810507733068 | -122.41698569087299 | (37.7810507733068, -122.416985690873) | ||
| 92313 | 92313 | 57049 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 507 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 34 | Permit Number 778890 | 5981589.12816 | 2112251.71027 | 37.7787721541621 | -122.507295790862 | (37.7787721541621, -122.507295790862) | ||
| 78124 | 78124 | 117118 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4006 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Permit Number 778373 | 6001804.25600707 | 2102958.17712895 | 37.754424362063396 | -122.43669843201499 | (37.7544243620634, -122.436698432015) | |||
| 104603 | 104603 | 117010 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 584X LOS PALMOS DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778232 | 5996394.0 | 2095944.0 | 37.7348562110144 | -122.454901614723 | (37.7348562110144, -122.454901614723) | |||
| 117187 | 117187 | 117009 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 584X LOS PALMOS DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778232 | 5996394.0 | 2095944.0 | 37.7348562110144 | -122.454901614723 | (37.7348562110144, -122.454901614723) | |||
| 16108 | 16108 | 100712 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 4x4 | Permit Number 777720 | 6012642.07844 | 2113780.85494 | 37.784750955827604 | -122.399978174254 | (37.7847509558276, -122.399978174254) | |
| 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) | |
| 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) | |
| 5744 | 5744 | 117020 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008118.25915 | 2113018.6658799998 | 37.7824049150971 | -122.41557516146601 | (37.7824049150971, -122.415575161466) | |
| 5966 | 5966 | 117017 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008130.7573 | 2112963.51283 | 37.7822541806174 | -122.415528017206 | (37.7822541806174, -122.415528017206) | |
| 6755 | 6755 | 117018 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.664580001 | 2112987.05621 | 37.78231853881321 | -122.415547303188 | (37.7823185388132, -122.415547303188) | |
| 97256 | 97256 | 94315 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 399X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008122.0 | 2112982.0 | 37.7823044496932 | -122.415559622955 | (37.7823044496932, -122.415559622955) | |
| 22954 | 22954 | 114892 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2226 45TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777232 | 5982390.0 | 2099932.0 | 37.7449928846436 | -122.50361273700199 | (37.7449928846436, -122.503612737002) | |
| 101179 | 101179 | 97324 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1033 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777184 | 5990033.0 | 2099023.0 | 37.7429434037475 | -122.477118493804 | (37.7429434037475, -122.477118493804) | |
| 140515 | 140515 | 59223 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 66 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2015 12:00:00 AM | Permit Number 776927 | 6004453.04119062 | 2107386.89201253 | 37.76673473615811 | -122.427853793475 | (37.7667347361581, -122.427853793475) | |||
| 140496 | 140496 | 113312 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 776373 | 5991464.0 | 2104574.1 | 37.7582681973515 | -122.47257516724599 | (37.7582681973515, -122.472575167246) | ||||
| 106295 | 106295 | 113380 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 63 Potomac St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4x4 | Permit Number 776311 | 6003081.0 | 2108682.5 | 37.7702144463181 | -122.432692008068 | (37.7702144463181, -122.432692008068) | |||
| 107122 | 107122 | 115821 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2534 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | Permit Number 775909 | 5981530.3 | 2097817.5 | 37.7391364720768 | -122.506428594252 | (37.7391364720768, -122.506428594252) | ||
| 89532 | 89532 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2224 Baker St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | |||
| 14745 | 14745 | 60410 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1504 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775413 | 6015728.8358 | 2094304.4734 | 37.731444574832295 | -122.387939390578 | (37.7314445748323, -122.387939390578) | |
| 111866 | 111866 | 115177 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1443 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775153 | 5981811.5 | 2105259.8 | 37.7595874928179 | -122.506007994714 | (37.7595874928179, -122.506007994714) | |||
| 97792 | 97792 | 89263 | Section 143 8 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775142 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |
| 126818 | 126818 | 114899 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1545 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | Permit Number 774413 | 5981525.9 | 2104542.4 | 37.7576009016243 | -122.50694250934099 | (37.7576009016243, -122.506942509341) | |||
| 116626 | 116626 | 112767 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 225 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774174 | 5995311.1 | 2091471.4 | 37.7225133523911 | -122.458321927922 | (37.7225133523911, -122.458321927922) | ||
| 10465 | 10465 | 46403 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3725 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/2014 12:00:00 AM | 3 | Permit Number 774152 | 5982443.3691 | 2102154.0013 | 37.7510970192105 | -122.50359271554501 | (37.7510970192105, -122.503592715545) | |
| 12246 | 12246 | 27021 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1485 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 773912 | 6010195.43289 | 2094633.0830400002 | 37.732038764264495 | -122.407092656994 | (37.7320387642645, -122.407092656994) | ||
| 10657 | 10657 | 108540 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401-423X Wheeler Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011963.42578 | 2086819.2708400001 | 37.710682407129795 | -122.400431631316 | (37.7106824071298, -122.400431631316) |
| 11587 | 11587 | 108539 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401-423X Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011972.2839 | 2086844.7313299999 | 37.710752810563996 | -122.400402802668 | (37.710752810564, -122.400402802668) |
| 11809 | 11809 | 108541 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401-423X Wheeler Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011955.27785 | 2086793.07341 | 37.710610019802296 | -122.40045795358999 | (37.7106100198023, -122.40045795359) |
| 124427 | 124427 | 69481 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 975 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773682 | 5991289.37358036 | 2104918.32998629 | 37.7592032524136 | -122.473204200451 | (37.7592032524136, -122.473204200451) | |
| 86851 | 86851 | 107713 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1798X 31st Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773637 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | |
| 95259 | 95259 | 107710 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1798X 31st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773637 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | |
| 96495 | 96495 | 107714 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1798X 31st Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773637 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | |
| 114662 | 114662 | 99364 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | Permit Number 773617 | 5986846.87705 | 2112774.48123 | 37.7805158200694 | -122.489145865965 | (37.7805158200694, -122.489145865965) | |
| 123039 | 123039 | 99363 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | Permit Number 773617 | 5986845.56233 | 2112796.17507 | 37.7805753084335 | -122.489152009534 | (37.7805753084335, -122.489152009534) | |
| 98717 | 98717 | 109187 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8038 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773568 | 5982053.04205 | 2112402.52702 | 37.7792135667625 | -122.505702141836 | (37.7792135667625, -122.505702141836) |
| 8280 | 8280 | 109193 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | |||||
| 186333 | 186333 | 107296 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2690 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 12 | Permit Number 773475 | 5982185.6184 | 2096841.85092 | 37.7364961680662 | -122.504090589396 | (37.7364961680662, -122.504090589396) | ||
| 123286 | 123286 | 109147 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2720 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773448 | 5987109.5 | 2111218.7 | 37.7762594110511 | -122.488122986064 | (37.7762594110511, -122.488122986064) |
| 142881 | 142881 | 109260 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3338X Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773416 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) |
| 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) | |
| 6805 | 6805 | 106911 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3536 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773298 | 5997340.42216 | 2116075.24554 | 37.7901857514154 | -122.45308226334998 | (37.7901857514154, -122.45308226335) | |
| 11696 | 11696 | 15774 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4800 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 773279 | 6001280.0938 | 2090832.0581 | 37.7210990656339 | -122.43764274124901 | (37.7210990656339, -122.437642741249) | ||
| 53479 | 53479 | 108406 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008120.84483 | 2112658.906 | 37.7814172463574 | -122.41554073723302 | (37.7814172463574, -122.415540737233) | |
| 135927 | 135927 | 108405 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008118.29339 | 2112682.65315 | 37.7814823069089 | -122.41555124581001 | (37.7814823069089, -122.41555124581) | |
| 151164 | 151164 | 108408 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.41551621722601 | (37.7812898924571, -122.415516217226) | |
| 170033 | 170033 | 108407 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | |
| 182575 | 182575 | 108410 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 10 | 3x3 | Permit Number 773269 | 6008131.8663 | 2112579.02445 | 37.781198530314995 | -122.41549695101801 | (37.781198530315, -122.415496951018) | |
| 184627 | 184627 | 108409 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.78123313714521 | -122.41550570771601 | (37.7812331371452, -122.415505707716) | |
| 136470 | 136470 | 106320 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1159 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | Permit Number 773066 | 6012249.74614 | 2103033.73104 | 37.7552199015978 | -122.40058031084999 | (37.7552199015978, -122.40058031085) | ||
| 168004 | 168004 | 106319 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1159 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 773066 | 6012250.50894 | 2103016.72008 | 37.7551732357645 | -122.40057647794501 | (37.7551732357645, -122.400576477945) | ||
| 45601 | 45601 | 113946 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | Permit Number 771921 | 5981537.78833 | 2100789.0701 | 37.7472960181729 | -122.506623032754 | (37.7472960181729, -122.506623032754) | |||
| 123778 | 123778 | 113947 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2015 12:00:00 AM | Permit Number 771921 | 5981537.78833 | 2100789.0701 | 37.7472960181729 | -122.506623032754 | (37.7472960181729, -122.506623032754) | |||
| 80665 | 80665 | 105914 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771767 | 6014820.9 | 2116826.5 | 37.7932348296087 | -122.39265323845699 | (37.7932348296087, -122.392653238457) | |||
| 106149 | 106149 | 60802 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1983 12:00:00 AM | 3x3 | Permit Number 771767 | 6014758.50170285 | 2116771.2374418997 | 37.7930796258277 | -122.39286527431801 | (37.7930796258277, -122.392865274318) | ||
| 112765 | 112765 | 105915 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 115 Steuart St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771767 | 6014820.9 | 2116826.5 | 37.7932348296087 | -122.39265323845699 | (37.7932348296087, -122.392653238457) | |||
| 123790 | 123790 | 105913 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771767 | 6014820.9 | 2116826.5 | 37.7932348296087 | -122.39265323845699 | (37.7932348296087, -122.392653238457) | |||
| 85294 | 85294 | 105420 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2310 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771076 | 6003772.4 | 2116466.9 | 37.791627655892206 | -122.430856083318 | (37.7916276558922, -122.430856083318) | |||
| 95228 | 95228 | 105055 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6333 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2013 12:00:00 AM | 3x3 | Permit Number 770390 | 5987343.5 | 2112490.3 | 37.7797645138094 | -122.487406953976 | (37.7797645138094, -122.487406953976) | ||
| 142177 | 142177 | 105056 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6333 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987343.5 | 2112490.3 | 37.7797645138094 | -122.487406953976 | (37.7797645138094, -122.487406953976) | ||
| 111940 | 111940 | 105173 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1601X NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | Arts Commission 14 | 13 | 4x4 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) | |
| 82712 | 82712 | 103945 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 137 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2013 12:00:00 AM | 20 | 3x3 | Permit Number 770063 | 6005598.0 | 2099028.0 | 37.7438478677712 | -122.423299304186 | (37.7438478677712, -122.423299304186) |
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");