Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80999 | 80999 | 21801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 25 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 84691 | 84691 | 21808 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 4x4 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 94842 | 94842 | 21807 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 100165 | 100165 | 21796 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 126832 | 126832 | 21800 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 141869 | 141869 | 21804 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 79727 | 79727 | 99261 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3099X Polk St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x6 | 6005936.6 | 2121383.7 | 37.805250324017294 | -122.42371770971 | (37.8052503240173, -122.42371770971) | ||
| 99943 | 99943 | 95131 | Permitted Site 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 139 | 1500X North Point St | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/29/2010 12:00:00 AM | Permit Number 54065 | 6003452.6 | 2121222.8 | 37.804668002399396 | -122.432302398634 | (37.8046680023994, -122.432302398634) | |||
| 104531 | 104531 | 98773 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003452.6 | 2121222.8 | 37.804668002399396 | -122.432302398634 | (37.8046680023994, -122.432302398634) | ||||
| 92501 | 92501 | 97725 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | |||
| 92726 | 92726 | 97722 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 117800 | 117800 | 97724 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 128722 | 128722 | 97723 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 173136 | 173136 | 98776 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 14 | 3x3 | 6003515.54038 | 2121088.88501 | 37.804303875477096 | -122.43207501857 | (37.8043038754771, -122.43207501857) | |||
| 64709 | 64709 | 98775 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 3x3 | 6003497.24376 | 2121086.80663 | 37.8042971314615 | -122.432138186954 | (37.8042971314615, -122.432138186954) | |||
| 93666 | 93666 | 87151 | Permitted Site 1 | Tree(s) :: 17 | 4 Bellair Pl | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | ||||
| 60569 | 60569 | 98774 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 13 | 3x3 | 6003476.9646 | 2121084.27758 | 37.804289037584205 | -122.432208183857 | (37.8042890375842, -122.432208183857) | |||
| 60591 | 60591 | 98772 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6003427.71574 | 2121076.45183 | 37.804264757687 | -122.432378054112 | (37.804264757687, -122.432378054112) | |||
| 73067 | 73067 | 98771 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6003408.14062 | 2121072.18905 | 37.8042519432217 | -122.432445490669 | (37.8042519432217, -122.432445490669) | |||
| 68935 | 68935 | 98770 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 3x3 | 6003379.21654 | 2121069.1016599997 | 37.8042418258748 | -122.432545363992 | (37.8042418258748, -122.432545363992) | |||
| 173812 | 173812 | 98769 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 20 | 3x3 | 6003355.72677 | 2121066.39367 | 37.8042330583593 | -122.43262645856701 | (37.8042330583593, -122.432626458567) | |||
| 144676 | 144676 | 122851 | Undocumented 2 | Tree(s) :: 17 | 742 Francisco St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007760.0 | 2120975.0 | 37.8042308974981 | -122.417378607523 | (37.8042308974981, -122.417378607523) | ||||
| 154297 | 154297 | 98768 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 14 | 3x3 | 6003334.441219999 | 2121062.9029099997 | 37.8042222665138 | -122.432699869304 | (37.8042222665138, -122.432699869304) | |||
| 187726 | 187726 | 98767 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6003313.437419999 | 2121061.12622 | 37.8042161969888 | -122.432772427524 | (37.8042161969888, -122.432772427524) | |||
| 56785 | 56785 | 98766 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6003296.85169 | 2121058.27535 | 37.804207428580106 | -122.43282961988999 | (37.8042074285801, -122.43282961989) | |||
| 58430 | 58430 | 98765 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 17 | 3x3 | 6003279.0227 | 2121054.95921 | 37.804197312118895 | -122.432891081376 | (37.8041973121189, -122.432891081376) | |||
| 47886 | 47886 | 98764 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6003256.03634 | 2121052.73189 | 37.804189892713 | -122.432970468136 | (37.804189892713, -122.432970468136) | |||
| 129715 | 129715 | 98763 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6003235.74698 | 2121049.71225 | 37.8041804507317 | -122.43304046507299 | (37.8041804507317, -122.433040465073) | |||
| 24209 | 24209 | 98762 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 3x3 | 6003216.22786 | 2121048.1502900003 | 37.8041750548072 | -122.433107900734 | (37.8041750548072, -122.433107900734) | |||
| 161413 | 161413 | 98761 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 3x3 | 6003198.92766 | 2121046.5425 | 37.8041696588781 | -122.43316765437599 | (37.8041696588781, -122.433167654376) | |||
| 181092 | 181092 | 98760 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 19 | 3x3 | 6003175.67956 | 2121043.58403 | 37.8041602168919 | -122.433247894574 | (37.8041602168919, -122.433247894574) | |||
| 118077 | 118077 | 111289 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 306 AVILA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000943.0 | 2121065.0 | 37.804092109664005 | -122.440975765753 | (37.804092109664, -122.440975765753) | ||||
| 24465 | 24465 | 95104 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 5 | 5999633.730169999 | 2120895.6152 | 37.803552367813104 | -122.445494383786 | (37.8035523678131, -122.445494383786) | |||
| 182258 | 182258 | 95105 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 2 | 5999611.3063900005 | 2120892.8119799998 | 37.803543390775296 | -122.445571780333 | (37.8035433907753, -122.445571780333) | |||
| 105665 | 105665 | 95129 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200@Broderick Beach St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 5999690.0 | 2120891.0 | 37.80354290788161 | -122.445299328106 | (37.8035429078816, -122.445299328106) | ||||
| 66044 | 66044 | 95103 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2200@Broderick Beach St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 12 | 5999638.348569999 | 2120885.83168 | 37.8035257685578 | -122.445477697742 | (37.8035257685578, -122.445477697742) | |||
| 265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
| 24884 | 24884 | 109356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 5x45 | 6007464.49344 | 2120601.01033 | 37.8031873860571 | -122.41837469975 | (37.8031873860571, -122.41837469975) | |||
| 173674 | 173674 | 109355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 5x45 | 6007469.51339 | 2120600.5219 | 37.8031863275346 | -122.41835729337299 | (37.8031863275346, -122.418357293373) | |||
| 71497 | 71497 | 109357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 5x45 | 6007459.04695 | 2120599.58062 | 37.8031831538387 | -122.41839344609801 | (37.8031831538387, -122.418393446098) | |||
| 171997 | 171997 | 109358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007454.77295 | 2120598.70497 | 37.8031805089291 | -122.41840817430901 | (37.8031805089291, -122.418408174309) | |||
| 48049 | 48049 | 109359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007452.06537 | 2120598.7604799997 | 37.8031805089269 | -122.41841754792802 | (37.8031805089269, -122.418417547928) | |||
| 147679 | 147679 | 109360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007448.76613 | 2120598.25036 | 37.803178922540205 | -122.418428928878 | (37.8031789225402, -122.418428928878) | |||
| 70565 | 70565 | 109362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007443.52896 | 2120597.58705 | 37.8031768064372 | -122.41844700523701 | (37.8031768064372, -122.418447005237) | |||
| 155176 | 155176 | 109361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007445.84949 | 2120597.53947 | 37.803176806427004 | -122.418438971581 | (37.803176806427, -122.418438971581) | |||
| 75911 | 75911 | 109363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007417.13772 | 2120593.69695 | 37.8031646394947 | -122.418538057081 | (37.8031646394947, -122.418538057081) | |||
| 84341 | 84341 | 107502 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 998 CHESTNUT ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773456 | 6007102.0 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | ||
| 104808 | 104808 | 107501 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 998 CHESTNUT ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773456 | 6007102.0 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | ||
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 4726 | 4726 | 253675 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x14.2 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 79096 | 79096 | 84742 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 147 Alhambra St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001618.0 | 2120311.0 | 37.8020602472718 | -122.438585827087 | (37.8020602472718, -122.438585827087) | ||
| 77533 | 77533 | 95247 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2626 Larkin St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627.0 | 2120193.0 | 37.802019913523004 | -122.421243885087 | (37.802019913523, -122.421243885087) | |
| 89387 | 89387 | 95245 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2626 Larkin St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627.0 | 2120193.0 | 37.802019913523004 | -122.421243885087 | (37.802019913523, -122.421243885087) | |
| 118434 | 118434 | 95246 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2626 Larkin St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627.0 | 2120193.0 | 37.802019913523004 | -122.421243885087 | (37.802019913523, -122.421243885087) | |
| 84179 | 84179 | 98330 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 147 Alhambra St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001593.9 | 2120254.3 | 37.801903193112004 | -122.438665159251 | (37.801903193112, -122.438665159251) | ||
| 104719 | 104719 | 95263 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 112310 | 112310 | 95267 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2245 Jones St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 116005 | 116005 | 95264 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 120920 | 120920 | 95266 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 143508 | 143508 | 95265 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 102660 | 102660 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 125168 | 125168 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 146084 | 146084 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 126302 | 126302 | 109534 | Permitted Site 1 | :: 54 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 66823 | 66823 | 87246 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 236323 Larkin St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 22 | 3x3 | Permit Number 50274 | 6006702.92902 | 2119345.02683 | 37.7996958743116 | -122.420920894495 | (37.7996958743116, -122.420920894495) | |
| 44837 | 44837 | 95043 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 9 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
| 55718 | 55718 | 95037 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Dept of Real Estate 5 | 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
| 91879 | 91879 | 95040 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
| 105794 | 105794 | 95046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
| 111208 | 111208 | 95042 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 11 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
| 115106 | 115106 | 95044 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
| 163077 | 163077 | 87247 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 236323 Larkin St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50274 | 6006692.88945 | 2119331.74907 | 37.7996588510331 | -122.42095469191601 | (37.7996588510331, -122.420954691916) | |
| 45206 | 45206 | 98827 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 3x3 | 6008062.2749 | 2119302.48836 | 37.7996556026694 | -122.416214031774 | (37.7996556026694, -122.416214031774) | |||
| 39918 | 39918 | 98828 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6008042.556030001 | 2119299.03058 | 37.7996449996806 | -122.41628202140801 | (37.7996449996806, -122.416282021408) | |||
| 187249 | 187249 | 98829 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 21 | 3x3 | 6008023.617869999 | 2119295.81426 | 37.7996351035429 | -122.41634732658702 | (37.7996351035429, -122.416347326587) | |||
| 90263 | 90263 | 87249 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 236323 Larkin St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6006714.0 | 2119291.0 | 37.799548154316795 | -122.420878746938 | (37.7995481543168, -122.420878746938) | ||||
| 110503 | 110503 | 87250 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 236323 Larkin St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50274 | 6006714.0 | 2119291.0 | 37.799548154316795 | -122.420878746938 | (37.7995481543168, -122.420878746938) | ||
| 91752 | 91752 | 96831 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2908 Baker St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999535.9 | 2118868.1 | 37.797979769659996 | -122.44568703479601 | (37.79797976966, -122.445687034796) | |||||
| 125685 | 125685 | 96832 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2908 Baker St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999535.9 | 2118868.1 | 37.797979769659996 | -122.44568703479601 | (37.79797976966, -122.445687034796) | |||||
| 89549 | 89549 | 97192 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 18 Bartol St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6011743.0 | 2118577.0 | 37.7978698622465 | -122.40342624167499 | (37.7978698622465, -122.403426241675) | |||||
| 5925 | 5925 | 95365 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647796996 | -122.40779910526899 | (37.797637647797, -122.407799105269) | ||
| 53643 | 53643 | 95364 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.4790000003 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | ||
| 49 | 49 | 251186 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3042 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002010.0 | 2118654.0 | 37.7975328515761 | -122.437110618013 | (37.7975328515761, -122.437110618013) | ||||
| 99837 | 99837 | 99918 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 102643 | 102643 | 99920 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1740 Jones St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 107709 | 107709 | 99917 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 107724 | 107724 | 99916 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 114105 | 114105 | 99919 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 75773 | 75773 | 112613 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2195 Green St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 13 | 6002622.24642 | 2118135.4932 | 37.796143948849796 | -122.434954984102 | (37.7961439488498, -122.434954984102) | ||||
| 34222 | 34222 | 112612 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2195 Green St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 6002608.57385 | 2118132.38825 | 37.7961346471419 | -122.435002071707 | (37.7961346471419, -122.435002071707) | ||||
| 159418 | 159418 | 112611 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2195 Green St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6002596.08972 | 2118131.51512 | 37.7961315408952 | -122.435045206767 | (37.7961315408952, -122.435045206767) | ||||
| 6802 | 6802 | 94826 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2195 Green St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/09/2010 12:00:00 AM | 14 | Permit Number 53924 | 6002581.43638 | 2118129.72292 | 37.7961257879313 | -122.435095781947 | (37.7961257879313, -122.435095781947) | ||
| 18683 | 18683 | 108105 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2390X Green St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | |||||
| 78260 | 78260 | 108099 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2390X Green St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | ||
| 80499 | 80499 | 108103 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2390X Green St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | |||||
| 109608 | 109608 | 108101 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2390X Green St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | |||||
| 105016 | 105016 | 87475 | Permitted Site 1 | Cedrus atlantica :: Atlas Cedar 304 | 2170 Vallejo St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/13/2008 12:00:00 AM | 3x3 | Permit Number 50384 | 6003181.0 | 2117910.0 | 37.7955565121873 | -122.433005467627 | (37.7955565121873, -122.433005467627) |
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");