trees

8,298 rows where qLegalStatus_id = 4 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID ▼ qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
83100 100731 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 11 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
67936 100732 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 12 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
85778 100733 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 13 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
24006 100734 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 14 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
183102 100735 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 15 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
82722 100736 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 16 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
107481 100737 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 17 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
77999 100738 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 18 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
27337 100740 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 20 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
105540 100741 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 21 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
124675 100742 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 22 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
100553 100750 Undocumented 4 Schinus molle :: California Pepper 91 757 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002448 2103795 37.7567586405263 -122.434532032094 (37.7567586405263, -122.434532032094) 2 4 5 28862 3
94390 100751 Undocumented 4 Schinus molle :: California Pepper 91 767 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002451 2103738 37.7566023024977 -122.434517581577 (37.7566023024977, -122.434517581577) 2 4 5 28862 3
74315 100752 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700X Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
126046 100753 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700X Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
184122 100754 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700X Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
121450 100755 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700X Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
52913 100756 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700X Brannan St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
45330 100757 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700X Brannan St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
4689 100758 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700X Brannan St 7 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
120817 100762 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1043 Clayton St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998810.4 2106255.2 37.7633065709297 -122.447289199162 (37.7633065709297, -122.447289199162) 15 5 11 29492 9
106800 100763 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1043 Clayton St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998810.4 2106255.2 37.7633065709297 -122.447289199162 (37.7633065709297, -122.447289199162) 15 5 11 29492 9
23833 100765 Undocumented 4 Tree(s) :: 17 5 Bernice St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008581 2108519.7 37.7700778198991 -122.413655963874 (37.7700778198991, -122.413655963874) 8 2 9 28853 19
125152 100768 Undocumented 4 Tree(s) :: 17 5 Bernice St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008581 2108519.7 37.7700778198991 -122.413655963874 (37.7700778198991, -122.413655963874) 8 2 9 28853 19
191057 100769 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 3701 21st St   Front Yard : Yard Tree Private 2     55   Street tree w/in RoW 6003717 2103606 37.7563116466144 -122.43012988292 (37.7563116466144, -122.43012988292) 2 4 5 28862 22
98061 100791 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 1221 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM 2 3x3 Permit Number 769131 6009961 2109679 37.773338385175 -122.408964349313 (37.773338385175, -122.408964349313) 14 2 9 28853 34
159492 100792 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 1221 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM 2 3x3 Permit Number 769131 6009961 2109679 37.773338385175 -122.408964349313 (37.773338385175, -122.408964349313) 14 2 9 28853 34
26290 100794 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2499X Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002707 2116776 37.7924159434372 -122.434564464045 (37.7924159434372, -122.434564464045) 13 9 1 29490 27
184605 100795 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2499X Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002249.4 2116712.1 37.7922145031838 -122.436143195286 (37.7922145031838, -122.436143195286) 13 9 1 29490 27
14879 100801 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2447 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002488 2116745 37.7923183909502 -122.435319990545 (37.7923183909502, -122.435319990545) 13 9 1 29490 27
75759 100809 Undocumented 4 Tree(s) :: 17 494X Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x4   6010843.5 2111760.1 37.7791019977843 -122.406058284082 (37.7791019977843, -122.406058284082) 14 2 9 28853 34
157595 100811 Undocumented 4 Tree(s) :: 17 494X Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x4   6010843.5 2111760.1 37.7791019977843 -122.406058284082 (37.7791019977843, -122.406058284082) 14 2 9 28853 34
89559 100812 Undocumented 4 Tree(s) :: 17 488X Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6010881.6 2111796.1 37.7792029762807 -122.405929016686 (37.7792029762807, -122.405929016686) 14 2 9 28853 34
563 100819 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2430X Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6002728 2116798 37.7924775418689 -122.434493377265 (37.7924775418689, -122.434493377265) 13 9 1 29490 27
128271 100820 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2430X Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6002728 2116798 37.7924775418689 -122.434493377265 (37.7924775418689, -122.434493377265) 13 9 1 29490 27
159964 100837 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 10X Tulane St 1 Sidewalk: Curb side : Cutout Tree Private 2       2.5x9   6007491.7 2093814.7 37.7296399852574 -122.416382127882 (37.7296399852574, -122.416382127882) 9 3 7 309 28
57232 100838 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 10X Tulane St 2 Sidewalk: Curb side : Cutout Tree Private 2       2.5x9   6007491.7 2093814.7 37.7296399852574 -122.416382127882 (37.7296399852574, -122.416382127882) 9 3 7 309 28
65619 100841 Undocumented 4 Tree(s) :: 17 139 Stillman St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014008 2112974 37.782611576233 -122.39519596309 (37.782611576233, -122.39519596309) 6 2 9 28856 6
22418 100843 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 1 Estero Ave 1 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
134613 100844 Undocumented 4 Araucaria columnaris :: Coral reef araucaria 323 1 Estero Ave 2 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
118486 100845 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1 Estero Ave 3 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
125598 100846 Undocumented 4 Cordyline australis :: Dracena Palm 64 1 Estero Ave 4 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
48775 100847 Undocumented 4 Cordyline australis :: Dracena Palm 64 1 Estero Ave 5 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
14324 100848 Undocumented 4 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 1 Estero Ave 5 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
43129 100849 Undocumented 4 Taxus baccata :: Irish Yew 86 1 Estero Ave 6 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
35668 100851 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1043-1049 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003181 2102169 37.7523356131155 -122.431880952183 (37.7523356131155, -122.431880952183) 2 4 5 28862 22
103587 100852 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1043-1049 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003181 2102169 37.7523356131155 -122.431880952183 (37.7523356131155, -122.431880952183) 2 4 5 28862 22
188219 100853 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 490X Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003181 2102169 37.7523356131155 -122.431880952183 (37.7523356131155, -122.431880952183) 2 4 5 28862 22
109526 100854 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 496X Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769289 6003126.9 2103316.7 37.7554838581871 -122.432149992401 (37.7554838581871, -122.432149992401) 2 4 5 28862 22
168482 100855 Undocumented 4 Tree(s) :: 17 477 29th St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x3   6003495.6 2098911.2 37.7434082840478 -122.43056057664 (37.7434082840478, -122.43056057664) 2 7 5 63 22
173006 100859 Undocumented 4 Tree(s) :: 17 665 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014545 2111762 37.7793135483428 -122.393253321297 (37.7793135483428, -122.393253321297) 6 2 9 28856 6
71086 100862 Undocumented 4 Tree(s) :: 17 655 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011836.4 2114966.7 37.7879620558848 -122.402849002098 (37.7879620558848, -122.402849002098) 12 2 9 28855 6
130088 100868 Undocumented 4 Tree(s) :: 17 655 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014591.2 2111956.1 37.7798490696224 -122.393107079978 (37.7798490696224, -122.393107079978) 6 2 9 28856 6
118949 100881 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 529 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011246 2105894 37.7630175324873 -122.404252882786 (37.7630175324873, -122.404252882786) 8 3 8 28856 29
116497 100889 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 91 Welsh St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6013566.08678 2111954.86803 37.7797886874229 -122.396653338395 (37.7797886874229, -122.396653338395) 6 2 9 28856 34
61492 100911 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1400x 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007975 2107432 37.7670572023826 -122.415675090491 (37.7670572023826, -122.415675090491) 8 4 7 28853 19
82382 100966 Undocumented 4 Tree(s) :: 17 498X 06th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011828 2110616 37.7760155781 -122.402572002689 (37.7760155781, -122.402572002689) 14 2 9 28853 34
154778 100967 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2655 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006143 2119878 37.8011277057339 -122.422896356717 (37.8011277057339, -122.422896356717) 13 9 1 28858 32
119881 100968 Undocumented 4 Tree(s) :: 17 1680 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006808.6 2108780.2 37.7706934041213 -122.419805171919 (37.7706934041213, -122.419805171919) 8 2 9 28853 19
81005 100989 Undocumented 4 Tree(s) :: 17 1675 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
5249 100990 Undocumented 4 Tree(s) :: 17 1675 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
137157 100991 Undocumented 4 Tree(s) :: 17 1675 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
19485 100992 Undocumented 4 Tree(s) :: 17 1675 Bryant St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
15091 100993 Undocumented 4 Tree(s) :: 17 1675 Bryant St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
7623 100994 Undocumented 4 Tree(s) :: 17 1675 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
21419 100996 Undocumented 4 Tree(s) :: 17 1675 Bryant St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
68588 101001 Undocumented 4 Tree(s) :: 17 500X Ogden Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/2012 12:00:00 AM     Permit Number 769389 6008398.5 2096033.1 37.7357821841588 -122.413404038925 (37.7357821841588, -122.413404038925) 10 7 7 28859 2
167296 101002 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2801X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
139471 101005 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2801X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
69214 101006 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2801X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
116351 101007 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2801X Buchanan St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
170998 101008 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2801X Buchanan St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
145004 101009 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2801X Buchanan St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
165399 101010 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2801X Buchanan St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
17877 101023 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3024 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999465 2119192 37.7988650643156 -122.445955676486 (37.7988650643156, -122.445955676486) 13 9 1 57 17
138241 101025 Undocumented 4 Tree(s) :: 17 512X Powhattan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008343.2 2098096.8 37.7414455475543 -122.41374115961 (37.7414455475543, -122.41374115961) 2 7 7 28859 2
42117 101026 Undocumented 4 Tree(s) :: 17 512X Powhattan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008343.2 2098096.8 37.7414455475543 -122.41374115961 (37.7414455475543, -122.41374115961) 2 7 7 28859 2
60139 101048 Undocumented 4 Maytenus boaria :: Mayten 58 3050 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008765 2105072 37.7606215625409 -122.412775728101 (37.7606215625409, -122.412775728101) 2 4 7 28859 19
127214 101049 Undocumented 4 Maytenus boaria :: Mayten 58 3050 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008765 2105072 37.7606215625409 -122.412775728101 (37.7606215625409, -122.412775728101) 2 4 7 28859 19
101268 101053 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 746 Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008144 2114503 37.7864819845184 -122.415591235338 (37.7864819845184, -122.415591235338) 13 1 9 28858 36
25618 101054 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 760 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008077 2114493 37.7864507606031 -122.415822330961 (37.7864507606031, -122.415822330961) 13 1 9 28858 36
2261 101055 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 760 Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008077 2114493 37.7864507606031 -122.415822330961 (37.7864507606031, -122.415822330961) 13 1 9 28858 36
7669 101056 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 746 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008144 2114503 37.7864819845184 -122.415591235338 (37.7864819845184, -122.415591235338) 13 1 9 28858 36
329 101063 Undocumented 4 Tree(s) :: 17 710 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001857 2102025 37.7518650783703 -122.436449244442 (37.7518650783703, -122.436449244442) 2 4 5 28862 22
147848 101072 Undocumented 4 Ficus nitida :: Laurel Fig 53 1828 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004239 2118751 37.7979256371892 -122.429404607028 (37.7979256371892, -122.429404607028) 13 9 1 57 17
95349 101079 Undocumented 4 Tree(s) :: 17 2619 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769685 5999618 2117805 37.7950654667929 -122.445326468891 (37.7950654667929, -122.445326468891) 13 9 1 57 17
138225 101082 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1699X Tennessee St 8 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6015823 2101385 37.7508914678049 -122.388107781388 (37.7508914678049, -122.388107781388) 10 3 8 28856 1
172696 101083 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1699X Tennessee St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6015823 2101385 37.7508914678049 -122.388107781388 (37.7508914678049, -122.388107781388) 10 3 8 28856 1
180885 101092 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1200 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2           5990310.3 2103151.6 37.7542955428806 -122.476461210066 (37.7542955428806, -122.476461210066) 1 8 3 56 35
139756 101093 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1200 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2           5990310.3 2103151.6 37.7542955428806 -122.476461210066 (37.7542955428806, -122.476461210066) 1 8 3 56 35
113561 101101 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1450 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989527 2103139 37.7542154865121 -122.479169107121 (37.7542154865121, -122.479169107121) 1 8 3 56 35
72789 101152 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1400X 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
114642 101153 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1400X 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
37971 101154 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1400X 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 6x5   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
7441 101155 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1400X 19th St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
151798 101166 Undocumented 4 Tree(s) :: 17 325 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001445 2096200 37.7358475821287 -122.437456909606 (37.7358475821287, -122.437456909606) 2 7 5 63 7
27811 101170 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 420 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769436 6002934 2105795 37.7622777366985 -122.432994152167 (37.7622777366985, -122.432994152167) 15 4 5 28862 3
69366 101171 Undocumented 4 Cordyline australis :: Dracena Palm 64 420 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002934 2105795 37.7622777366985 -122.432994152167 (37.7622777366985, -122.432994152167) 15 4 5 28862 3
136545 101172 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 445 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994418 2106645 37.7641248955045 -122.462509231781 (37.7641248955045, -122.462509231781) 1 5 11 56 12
100056 101173 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 445 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994418 2106645 37.7641248955045 -122.462509231781 (37.7641248955045, -122.462509231781) 1 5 11 56 12

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);