Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 384 | 384 | 85806 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) | |
| 1377 | 1377 | 8105 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 780 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 8 | 3X3 | 6004061.6732 | 2111513.0828 | 37.7780421005615 | -122.42950176141899 | (37.7780421005615, -122.429501761419) | ||
| 3264 | 3264 | 253390 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2529x Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 10649 | 10649 | 87528 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2684 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 4x4 | 6011133.0386 | 2093058.8298 | 37.727768619555896 | -122.403740403083 | (37.7277686195559, -122.403740403083) | ||
| 10876 | 10876 | 28683 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2961 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3X3 | 6011553.9607 | 2091855.0708 | 37.7244868510493 | -122.402200662543 | (37.7244868510493, -122.402200662543) | ||
| 12783 | 12783 | 24849 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2354 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2011 12:00:00 AM | 3 | 2x2 | 6010506.727580001 | 2094990.7524400002 | 37.7330382644924 | -122.40604162653 | (37.7330382644924, -122.40604162653) | ||
| 13682 | 13682 | 86688 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011619.91608 | 2110365.80085 | 37.7753169695418 | -122.403274219231 | (37.7753169695418, -122.403274219231) | ||
| 14524 | 14524 | 52852 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014360.0420699995 | 2114216.81563 | 37.7860436350529 | -122.394065071555 | (37.7860436350529, -122.394065071555) | |
| 14664 | 14664 | 27459 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1601 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 6X6 | 6015175.2959199995 | 2101002.60795 | 37.749805592554104 | -122.39032090789 | (37.7498055925541, -122.39032090789) | |||
| 14670 | 14670 | 108060 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014722.47105 | 2114748.4926400003 | 37.7875236349662 | -122.39284836525299 | (37.7875236349662, -122.392848365253) | ||
| 14698 | 14698 | 27453 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6X6 | 6015188.65813 | 2100719.92865 | 37.7490301557222 | -122.390254953405 | (37.7490301557222, -122.390254953405) | |||
| 15710 | 15710 | 86672 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1155 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009883.68707 | 2108705.67197 | 37.77066152104221 | -122.409163091525 | (37.7706615210422, -122.409163091525) | ||
| 16093 | 16093 | 86683 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 925 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011000.86666 | 2109774.4042 | 37.7736585378513 | -122.40537400761299 | (37.7736585378513, -122.405374007613) | ||
| 16266 | 16266 | 115349 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014896.08459 | 2114567.05321 | 37.787035085459706 | -122.392234997951 | (37.7870350854597, -122.392234997951) | |
| 17525 | 17525 | 654 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3255X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6007301.1492800005 | 2102040.7128 | 37.7522160715366 | -122.417623684893 | (37.7522160715366, -122.417623684893) | ||
| 18035 | 18035 | 101991 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 18312 | 18312 | 122646 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18757 | 18757 | 25477 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6009744.3885699995 | 2103075.41158 | 37.7551943032962 | -122.40924755584999 | (37.7551943032962, -122.40924755585) | ||
| 21457 | 21457 | 28119 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1640 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2005 12:00:00 AM | 6 | 3X3 | 6006505.97749 | 2099880.4421900003 | 37.7462396835255 | -122.42022021199301 | (37.7462396835255, -122.420220211993) | ||
| 24424 | 24424 | 84888 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 25823 | 25823 | 187931 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6015237.31948 | 2115756.16147 | 37.790319045339 | -122.391137539076 | (37.790319045339, -122.391137539076) | |||
| 26030 | 26030 | 118375 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x6 | 6014712.487269999 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | |||
| 28247 | 28247 | 187919 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013100.51395 | 2115046.75094 | 37.7882523600964 | -122.398480985606 | (37.7882523600964, -122.398480985606) | |||
| 30838 | 30838 | 187949 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | ||||
| 32646 | 32646 | 203423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993355.35449 | 2097236.83517 | 37.7382312350687 | -122.465501072513 | (37.7382312350687, -122.465501072513) | |||
| 34428 | 34428 | 187860 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014887.824680001 | 2103924.74261 | 37.7578132028277 | -122.391519270711 | (37.7578132028277, -122.391519270711) | |||
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 35513 | 35513 | 220479 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Prentiss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008820.53272 | 2097501.66791 | 37.7398382390396 | -122.41204865353501 | (37.7398382390396, -122.412048653535) | |||
| 36136 | 36136 | 125413 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 677 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005987.46942 | 2112075.6403900003 | 37.7796955950146 | -122.42287972583999 | (37.7796955950146, -122.42287972584) | |||
| 36568 | 36568 | 125406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2650 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001656.15712 | 2117548.20785 | 37.794476515841495 | -122.43825574691799 | (37.7944765158415, -122.438255746918) | |||
| 36889 | 36889 | 220442 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2601 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009796.152509999 | 2102134.77376 | 37.752614421718505 | -122.40900217402799 | (37.7526144217185, -122.409002174028) | |||
| 38232 | 38232 | 175141 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6009144.52669 | 2093573.47642 | 37.7290704439367 | -122.410651080984 | (37.7290704439367, -122.410651080984) | |||
| 39100 | 39100 | 189065 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013721.13353 | 2112372.28155 | 37.78094343761921 | -122.396146221471 | (37.7809434376192, -122.396146221471) | |||
| 39772 | 39772 | 187904 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011967.30497 | 2114536.3793599997 | 37.7867878051538 | -122.402365823018 | (37.7867878051538, -122.402365823018) | |||
| 41056 | 41056 | 138174 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001486.0255 | 2111568.0498 | 37.778046859007894 | -122.438415769146 | (37.7780468590079, -122.438415769146) | |||
| 41437 | 41437 | 189071 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1157 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009822.97122 | 2108648.63961 | 37.7705015217488 | -122.40936908392 | (37.7705015217488, -122.40936908392) | |||
| 41565 | 41565 | 244890 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001780.4834 | 2109546.7964 | 37.772513747957 | -122.43725237282601 | (37.772513747957, -122.437252372826) | |||
| 42570 | 42570 | 141373 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001678.0066 | 2110208.8368 | 37.7743257195795 | -122.437654271553 | (37.7743257195795, -122.437654271553) | |||
| 43028 | 43028 | 141617 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001580.3173 | 2110897.2965 | 37.776210502271105 | -122.43804152155 | (37.7762105022711, -122.43804152155) | |||
| 46703 | 46703 | 220409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1504 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009386.52953 | 2107743.37871 | 37.7679914221935 | -122.410814800755 | (37.7679914221935, -122.410814800755) | |||
| 47402 | 47402 | 187941 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015065.49236 | 2115322.58848 | 37.7891190169896 | -122.391701726057 | (37.7891190169896, -122.391701726057) | ||||
| 51020 | 51020 | 220412 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1650 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009419.37169 | 2107143.6677099997 | 37.766346595437 | -122.410658846644 | (37.766346595437, -122.410658846644) | |||
| 56668 | 56668 | 137724 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001530.3588 | 2111236.3964 | 37.7771387440026 | -122.438238639478 | (37.7771387440026, -122.438238639478) | |||
| 56914 | 56914 | 220415 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009485.58878 | 2106996.6595099997 | 37.7659466570249 | -122.410419431833 | (37.7659466570249, -122.410419431833) | |||
| 59216 | 59216 | 185222 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2507 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985796.7937 | 2098135.752 | 37.740260579141 | -122.491700620712 | (37.740260579141, -122.491700620712) | |||
| 61724 | 61724 | 187953 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 350 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014758.29255 | 2114615.93494 | 37.787161651545205 | -122.392715152285 | (37.7871616515452, -122.392715152285) | |||
| 62145 | 62145 | 220491 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3316 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007001.80578 | 2102071.34633 | 37.752283335412706 | -122.418661035797 | (37.7522833354127, -122.418661035797) | |||
| 63219 | 63219 | 189073 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1111 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009955.51496 | 2108774.3382900003 | 37.770854086583796 | -122.40891948225 | (37.7708540865838, -122.40891948225) | |||
| 63718 | 63718 | 203407 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993759.21038 | 2102270.66076 | 37.7520761325235 | -122.46447014280899 | (37.7520761325235, -122.464470142809) | |||
| 64172 | 64172 | 38793 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 655 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | 6 | Permit Number 40642 | 6012718.22828 | 2111411.20954 | 37.7782487018563 | -122.39954829202499 | (37.7782487018563, -122.399548292025) | ||
| 64431 | 64431 | 203399 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1898 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993788.70878 | 2102627.32377 | 37.7530571381766 | -122.464394026856 | (37.7530571381766, -122.464394026856) | |||
| 66367 | 66367 | 187886 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1798 Indiana St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6015167.00373 | 2100296.44162 | 37.7478661479108 | -122.39030025137698 | (37.7478661479108, -122.390300251377) | |||
| 69432 | 69432 | 220483 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3135 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008148.36276 | 2102088.69137 | 37.7523954467163 | -122.41469727478399 | (37.7523954467163, -122.414697274784) | |||
| 70136 | 70136 | 187903 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 47 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6013582.62491 | 2115938.98616 | 37.790729075944206 | -122.396875529384 | (37.7907290759442, -122.396875529384) | |||
| 72048 | 72048 | 96285 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3237 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011917.425009999 | 2090666.70864 | 37.721244132491606 | -122.40086075544501 | (37.7212441324916, -122.400860755445) | |
| 74004 | 74004 | 189061 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 670 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011084.455490001 | 2108738.6767700003 | 37.770819341272 | -122.40501191898399 | (37.770819341272, -122.405011918984) | |||
| 76376 | 76376 | 220427 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1501 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009439.69021 | 2107723.53455 | 37.76793991532671 | -122.410629521551 | (37.7679399153267, -122.410629521551) | |||
| 76923 | 76923 | 96282 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3219 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58765 | 6011894.72872 | 2090742.0865599997 | 37.7214498389136 | -122.400944503905 | (37.7214498389136, -122.400944503905) | |
| 76989 | 76989 | 88169 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011742.09911 | 2112601.7739 | 37.781463257472794 | -122.403008862566 | (37.7814632574728, -122.403008862566) | |
| 82637 | 82637 | 671 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3300X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 4X4 | 6007057.4653098 | 2102078.7676165 | 37.7523068461089 | -122.41846908204701 | (37.7523068461089, -122.418469082047) | ||
| 82990 | 82990 | 122582 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2500X Lyon St | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 6 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 84517 | 84517 | 14652 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 655X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2008 12:00:00 AM | 3 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | ||
| 86745 | 86745 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 87355 | 87355 | 28686 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2955 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011473.964837001 | 2092116.8636216999 | 37.725201214643995 | -122.402495599163 | (37.725201214644, -122.402495599163) | |||
| 87832 | 87832 | 14784 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1067 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 4X4 | 6004083.630320299 | 2111809.5297481003 | 37.7788573137505 | -122.429446949988 | (37.7788573137505, -122.429446949988) | ||
| 89006 | 89006 | 85376 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2601X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009781.5092319995 | 2102185.131738 | 37.752751873221 | -122.409056366206 | (37.752751873221, -122.409056366206) | |||
| 91145 | 91145 | 87431 | Acer rubrum :: Red Maple 6 | 522X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006584.964111 | 2094794.1521 | 37.732278314780295 | -122.419586279513 | (37.7322783147803, -122.419586279513) | |||
| 91672 | 91672 | 24886 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2750 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2X2 | 6011218.493881401 | 2092777.6374656002 | 37.727001297273205 | -122.403425206874 | (37.7270012972732, -122.403425206874) | |||
| 93119 | 93119 | 1205 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3101X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 93822 | 93822 | 8255 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1525 GALVEZ AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 07:01:00 AM | 3 | 3x3 | 6016246.0 | 2097351.0 | 37.739838361172204 | -122.38636376878901 | (37.7398383611722, -122.386363768789) | ||
| 94366 | 94366 | 1221 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3600X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 99988 | 99988 | 107153 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 100904 | 100904 | 88193 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 364 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51197 | 6011427.8 | 2112687.4 | 37.781680810769295 | -122.40410221959 | (37.7816808107693, -122.40410221959) | ||
| 101129 | 101129 | 100774 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 102281 | 102281 | 1264 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3995X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1992 12:00:00 AM | 3 | 3x3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||
| 103313 | 103313 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225.0 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | ||
| 104112 | 104112 | 87433 | Acer rubrum :: Red Maple 6 | 598X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557364995 | -122.421262171784 | (37.732170557365, -122.421262171784) | |||
| 104211 | 104211 | 112085 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 105171 | 105171 | 116465 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 106147 | 106147 | 96782 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 113978 | 113978 | 29066 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 114101 | 114101 | 142930 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 581 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010719.0959 | 2118913.2737 | 37.7987359458828 | -122.40699296942499 | (37.7987359458828, -122.406992969425) | |||
| 116745 | 116745 | 87547 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2713 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x3 | 6011213.1328839995 | 2092950.939207 | 37.7274768484357 | -122.40345592690399 | (37.7274768484357, -122.403455926904) | |||
| 117008 | 117008 | 102934 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 801X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.757774211767796 | -122.427824502367 | (37.7577742117678, -122.427824502367) | |||
| 119759 | 119759 | 94415 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 120312 | 120312 | 1128 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2525 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 5998741.2887 | 2088615.01895 | 37.7148669056281 | -122.446259214537 | (37.7148669056281, -122.446259214537) | ||
| 122330 | 122330 | 104202 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3135 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | |
| 123177 | 123177 | 6288 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 123779 | 123779 | 8251 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1515 Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2014 12:00:00 AM | 3 | 3x3 | 6016234.0 | 2097322.0 | 37.7397580688138 | -122.38640323868799 | (37.7397580688138, -122.386403238688) | ||
| 125610 | 125610 | 48550 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 132233 | 132233 | 187912 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013728.03817 | 2115347.11788 | 37.7891120364521 | -122.396330901758 | (37.7891120364521, -122.396330901758) | |||
| 132785 | 132785 | 203421 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993401.40723 | 2097258.40143 | 37.738293106632 | -122.46534341236799 | (37.738293106632, -122.465343412368) | |||
| 133115 | 133115 | 187891 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6015208.193580001 | 2100413.69272 | 37.7481903795776 | -122.390166007757 | (37.7481903795776, -122.390166007757) | |||
| 133287 | 133287 | 141982 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 961 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004375.3351 | 2111847.7501 | 37.7789787686216 | -122.42844055250099 | (37.7789787686216, -122.428440552501) | |||
| 134499 | 134499 | 125410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005899.660080001 | 2112113.57436 | 37.77979479743679 | -122.423186194101 | (37.7797947974368, -122.423186194101) | |||
| 134632 | 134632 | 187925 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013571.0237 | 2115195.4234 | 37.7886867803215 | -122.396863516254 | (37.7886867803215, -122.396863516254) | |||
| 135416 | 135416 | 141317 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001294.3096 | 2112929.1823 | 37.781773276597 | -122.439176563192 | (37.781773276597, -122.439176563192) | |||
| 137409 | 137409 | 138251 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1400x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001249.9763 | 2113269.973 | 37.782706478132894 | -122.43935437054701 | (37.7827064781329, -122.439354370547) | |||
| 139076 | 139076 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 776555 | 5993732.7 | 2097034.0 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | ||||
| 139982 | 139982 | 9750 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 688X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/25/2006 12:00:00 AM | 3 | 3x3 | 6005981.3683502 | 2112123.5425617 | 37.7798267784404 | -122.422904237561 | (37.7798267784404, -122.422904237561) |
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");