Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 5094 | 5094 | 253788 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1663X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991413.0 | 2103963.0 | 37.756587325686105 | -122.472706989611 | (37.7565873256861, -122.472706989611) | ||||
| 5603 | 5603 | 34246 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38056 | ||||||||||
| 5617 | 5617 | 35204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 6825 | 6825 | 35207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 6835 | 6835 | 35197 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7167 | 7167 | 35203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 9038 | 9038 | 173597 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 473 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003668.0 | 2105532.0 | 37.7615972080674 | -122.430436757163 | (37.7615972080674, -122.430436757163) | ||||
| 9503 | 9503 | 173609 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1199x 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015354.0 | 2104874.0 | 37.7604455241109 | -122.38997333788299 | (37.7604455241109, -122.389973337883) | ||||
| 9505 | 9505 | 173606 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1199x 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015354.0 | 2104874.0 | 37.7604455241109 | -122.38997333788299 | (37.7604455241109, -122.389973337883) | ||||
| 9604 | 9604 | 173608 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1199x 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015354.0 | 2104874.0 | 37.7604455241109 | -122.38997333788299 | (37.7604455241109, -122.389973337883) | ||||
| 9610 | 9610 | 173607 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1199x 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015354.0 | 2104874.0 | 37.7604455241109 | -122.38997333788299 | (37.7604455241109, -122.389973337883) | ||||
| 9617 | 9617 | 35183 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 9714 | 9714 | 173648 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4426 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x13 | 6001152.0 | 2101189.0 | 37.7495295372933 | -122.438827325114 | (37.7495295372933, -122.438827325114) | ||||
| 9950 | 9950 | 68298 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2100 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 3x3 | Permit Number 32107 | 5981719.63070527 | 2100774.89065863 | 37.747267790944 | -122.50599319492201 | (37.747267790944, -122.505993194922) | |
| 10155 | 10155 | 173894 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 109 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006959.0 | 2098839.0 | 37.743405633312896 | -122.418579874109 | (37.7434056333129, -122.418579874109) | ||||
| 10243 | 10243 | 173930 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1507 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5982447.0 | 2104825.0 | 37.7584310428159 | -122.503777954019 | (37.7584310428159, -122.503777954019) | ||||
| 10310 | 10310 | 35176 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 11317 | 11317 | 35209 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11570 | 11570 | 174950 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 309 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987294.0 | 2096147.0 | 37.7348873783654 | -122.486377975564 | (37.7348873783654, -122.486377975564) | ||||
| 11988 | 11988 | 35180 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12435 | 12435 | 35178 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12458 | 12458 | 35205 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12489 | 12489 | 35198 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12872 | 12872 | 35210 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 13265 | 13265 | 187636 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 142 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5987141.0 | 2115018.0 | 37.7866930444454 | -122.48829328895599 | (37.7866930444454, -122.488293288956) | ||||
| 13266 | 13266 | 187635 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 142 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5987141.0 | 2115018.0 | 37.7866930444454 | -122.48829328895599 | (37.7866930444454, -122.488293288956) | ||||
| 13328 | 13328 | 63694 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1862 10TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | Permit Number 24352 | 5993137.0 | 2102888.0 | 37.753735299933 | -122.46666669057501 | (37.753735299933, -122.466666690575) | ||
| 14195 | 14195 | 35181 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14347 | 14347 | 87020 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Osceola Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 14575 | 14575 | 35206 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14588 | 14588 | 35174 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16081 | 16081 | 35175 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16133 | 16133 | 35179 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16225 | 16225 | 35208 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16452 | 16452 | 35177 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16638 | 16638 | 35212 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 18195 | 18195 | 121334 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2401x Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001103.0 | 2113984.0 | 37.784658648156295 | -122.439914057191 | (37.7846586481563, -122.439914057191) | ||||
| 18360 | 18360 | 102983 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 555 Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296001 | (37.7822098643106, -122.41823462296) | ||||
| 18560 | 18560 | 37810 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1746 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44738 | 5981328.72954544 | 2103184.35370388 | 37.753860479355396 | -122.50752362923201 | (37.7538604793554, -122.507523629232) | ||
| 18881 | 18881 | 111979 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 39 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987939.0 | 2115796.0 | 37.788875735681 | -122.485589552136 | (37.788875735681, -122.485589552136) | |||||
| 18916 | 18916 | 65141 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 430 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1989 12:00:00 AM | Permit Number 27116 | 5981364.99930459 | 2112708.09753982 | 37.780012054358394 | -122.508105008848 | (37.7800120543584, -122.508105008848) | ||
| 19133 | 19133 | 37103 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.764023420548796 | -122.508237579769 | (37.7640234205488, -122.508237579769) | ||
| 19272 | 19272 | 65062 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 481 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1989 12:00:00 AM | Permit Number 27018 | 5982198.4613122 | 2112526.22921648 | 37.7795617740877 | -122.505208255718 | (37.7795617740877, -122.505208255718) | ||
| 19509 | 19509 | 121071 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600x Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012133.0 | 2117811.0 | 37.795788385255705 | -122.402022845886 | (37.7957883852557, -122.402022845886) | ||||
| 19554 | 19554 | 106481 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 301X LAWTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993233.0 | 2104592.0 | 37.7584195821345 | -122.466458543785 | (37.7584195821345, -122.466458543785) | |||||
| 19555 | 19555 | 63127 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23641 | 6007142.25261762 | 2099206.716095 | 37.7444256145798 | -122.417972293386 | (37.7444256145798, -122.417972293386) | ||
| 19641 | 19641 | 94973 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 5 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | |||
| 19655 | 19655 | 97747 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2685 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | ||||
| 19842 | 19842 | 37102 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.764023420548796 | -122.508237579769 | (37.7640234205488, -122.508237579769) | ||
| 20388 | 20388 | 111086 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 582X Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996560.16999 | 2095740.09269 | 37.7343058616961 | -122.454312386561 | (37.7343058616961, -122.454312386561) | |||||
| 20909 | 20909 | 33583 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37691 | 6007181.85623533 | 2098126.23586774 | 37.741461086055295 | -122.417758780801 | (37.7414610860553, -122.417758780801) | |||
| 22300 | 22300 | 248974 | Property Tree 7 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 716 Goettingen St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010713.0 | 2091306.0 | 37.7229322393396 | -122.405069122237 | (37.7229322393396, -122.405069122237) | ||||
| 26652 | 26652 | 48000 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1901 16th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45728 | 5991233.33873947 | 2102463.46573508 | 37.752459596695 | -122.47321895744 | (37.752459596695, -122.47321895744) | ||
| 27186 | 27186 | 34359 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1827 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38115 | 6004598.72588548 | 2098167.19179023 | 37.7414278382274 | -122.426693274937 | (37.7414278382274, -122.426693274937) | ||
| 28452 | 28452 | 32184 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 191 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35516 | 5984219.12182319 | 2094256.3665376 | 37.7295164954065 | -122.49686924841998 | (37.7295164954065, -122.49686924842) | ||
| 30536 | 30536 | 122761 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 86X Park Hill Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001171.0 | 2107689.0 | 37.7673780360046 | -122.43922745061899 | (37.7673780360046, -122.439227450619) | ||||
| 34309 | 34309 | 68307 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2167 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32118 | 5981682.0022594 | 2100343.28066189 | 37.7460804954734 | -122.50609131195101 | (37.7460804954734, -122.506091311951) | ||
| 40006 | 40006 | 102975 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 555 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296001 | (37.7822098643106, -122.41823462296) | ||||
| 40012 | 40012 | 65709 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 142 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1990 12:00:00 AM | Permit Number 28638 | 6000250.18995538 | 2088032.18663542 | 37.713352638634895 | -122.44100204671999 | (37.7133526386349, -122.44100204672) | ||
| 42975 | 42975 | 67984 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 35 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31708 | 5996379.31437828 | 2088033.23094013 | 37.713134273022 | -122.45438113912901 | (37.713134273022, -122.454381139129) | ||
| 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) | |||
| 47432 | 47432 | 31622 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | Permit Number 35554 | 5992052.25118753 | 2099087.40328319 | 37.7432371814309 | -122.47014123306101 | (37.7432371814309, -122.470141233061) | ||
| 48559 | 48559 | 51982 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 660 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2005 12:00:00 AM | Permit Number 48204 | 6007266.85815782 | 2113345.5415055 | 37.783254541923206 | -122.4185438282 | (37.7832545419232, -122.4185438282) | |||
| 48564 | 48564 | 96352 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 533 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2011 12:00:00 AM | 3x3 | Permit Number 767163 | 5995513.1 | 2106277.2 | 37.763178014785204 | -122.458694995111 | (37.7631780147852, -122.458694995111) | ||
| 49106 | 49106 | 41581 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 291 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2000 12:00:00 AM | Permit Number 42092 | 5990233.66540637 | 2113445.43887164 | 37.7825551838187 | -122.477478543034 | (37.7825551838187, -122.477478543034) | |||
| 51239 | 51239 | 94972 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 4 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | |||
| 51519 | 51519 | 98684 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Bay View St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014207.0 | 2094775.0 | 37.7326521179743 | -122.393233618799 | (37.7326521179743, -122.393233618799) | |||||
| 54659 | 54659 | 97574 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 501x Presidio Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | |||||
| 58679 | 58679 | 51019 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 251 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | Permit Number 47497 | 5992948.45681034 | 2088862.24435583 | 37.7152131901669 | -122.466299454682 | (37.7152131901669, -122.466299454682) | |||
| 60915 | 60915 | 122483 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1295 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5983305.0 | 2106338.0 | 37.7626357248351 | -122.500922549214 | (37.7626357248351, -122.500922549214) | ||||
| 61156 | 61156 | 60431 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 454 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1982 12:00:00 AM | Permit Number 20015 | 6003628.53966279 | 2098964.72203761 | 37.7435627733769 | -122.430104722556 | (37.7435627733769, -122.430104722556) | ||
| 61685 | 61685 | 68469 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2766 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32334 | 6009569.05217042 | 2103972.19360753 | 37.757646840311 | -122.409917225443 | (37.757646840311, -122.409917225443) | ||
| 70836 | 70836 | 38481 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1116 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | Permit Number 40480 | 6017830.40993478 | 2092735.6877236 | 37.727253198437 | -122.38056477357401 | (37.727253198437, -122.380564773574) | |||
| 70844 | 70844 | 35474 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 455 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1998 12:00:00 AM | Permit Number 38887 | 6007396.82109854 | 2112616.81920427 | 37.7812609627381 | -122.418042529741 | (37.7812609627381, -122.418042529741) | |||
| 73843 | 73843 | 104325 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 95X Beaver St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002383.0 | 2106795.0 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | ||||
| 75750 | 75750 | 99729 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2645 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990840.1 | 2094977.0 | 37.731880912373704 | -122.474032655501 | (37.7318809123737, -122.474032655501) | ||||
| 76399 | 76399 | 68359 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 683 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32179 | 5989402.03203954 | 2110700.64294356 | 37.774970446858894 | -122.48015465411899 | (37.7749704468589, -122.480154654119) | ||
| 77321 | 77321 | 120955 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2498x 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5985867.0 | 2098260.0 | 37.740605833831296 | -122.49146702188801 | (37.7406058338313, -122.491467021888) | ||||
| 77391 | 77391 | 92760 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 77397 | 77397 | 112019 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 533 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x4 | 5995513.1 | 2106277.2 | 37.763178014785204 | -122.458694995111 | (37.7631780147852, -122.458694995111) | ||||
| 77512 | 77512 | 48611 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.45586132044201 | (37.7434052350482, -122.455861320442) | ||
| 77534 | 77534 | 38755 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 133 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | Permit Number 40630 | 6012231.96307802 | 2112402.8191024 | 37.780944316304 | -122.401300174029 | (37.780944316304, -122.401300174029) | |||
| 77621 | 77621 | 60394 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1490 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | Permit Number 19974 | 6015495.25589762 | 2094826.0117952998 | 37.7328636713029 | -122.38878332305599 | (37.7328636713029, -122.388783323056) | ||
| 77657 | 77657 | 99736 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Ocean Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.45157991133101 | (37.7230482703916, -122.451579911331) | |||||
| 77702 | 77702 | 69531 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 23 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1997 12:00:00 AM | Permit Number 38565 | 5995300.80915633 | 2090069.63363967 | 37.718663844062796 | -122.458256093312 | (37.7186638440628, -122.458256093312) |
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");