trees
208 rows where Police Districts = 9 and qLegalStatus_id = 6 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
803 | 105089 | Significant Tree 6 | :: 45 | 344 Fulton St | 9 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
3436 | 103654 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
4164 | 260061 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
8078 | 260059 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
9215 | 260060 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
12063 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
15911 | 105081 | Significant Tree 6 | :: 45 | 344 Fulton St | 1 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
17108 | 105086 | Significant Tree 6 | :: 45 | 344 Fulton St | 6 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
18171 | 260058 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
22312 | 116999 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 880x MCALLISTER ST | 2 | Front Yard : Cutout | Tree | Private 2 | 6005306 | 2112177 | 37.779935428414 | -122.425244441442 | (37.779935428414, -122.425244441442) | 7 | 9 | 11 | 28852 | 41 | |||||
22976 | 103600 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 50X Hermann St | 1 | Front Yard : Yard | Tree | Private 2 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | |||||
29114 | 103653 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
31523 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 302 Ivy St | 18 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
41224 | 258232 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||
43239 | 258527 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Hermann St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
44345 | 253366 | Significant Tree 6 | Ficus carica :: Edible Fig 341 | 20 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004582 | 2109434 | 37.7723628942784 | -122.427553605007 | (37.7723628942784, -122.427553605007) | 7 | 9 | 11 | 28852 | 10 | ||||
48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
53621 | 258239 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
60038 | 258526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 50 Hermann St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
60074 | 98947 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 7 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
60332 | 112420 | Significant Tree 6 | Picea Spp :: Spruce Spp 200 | 268 Lily St | 2 | Back Yard : Yard | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | |||
60900 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 201X Haight St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
65723 | 108022 | Significant Tree 6 | Grevillea robusta :: Silk Oak Tree 76 | 455X Ivy St | 2 | Front Yard : Cutout | Tree | Private 2 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | 7 | 9 | 11 | 28852 | 10 | |||||
66091 | 100771 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
67916 | 258235 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
69454 | 98948 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 8 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
71208 | 98953 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 302 Ivy St | 19 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
71526 | 258236 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
74407 | 121161 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 5 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
75459 | 105084 | Significant Tree 6 | :: 45 | 344 Fulton St | 4 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
75842 | 103617 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 201X Haight St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
79081 | 121163 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 7 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
80590 | 98954 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 302 Ivy St | 20 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
83376 | 121162 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 6 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
88383 | 103615 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
91093 | 105091 | Significant Tree 6 | :: 45 | 344 Fulton St | 11 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
92359 | 120121 | Significant Tree 6 | Juglans hindsii :: Walnut: Black (n.calif) 457 | 444 Page St | 1 | Front Yard : Yard | Tree | Private 2 | 6004415 | 2109849 | 37.7734929358756 | -122.428160854421 | (37.7734929358756, -122.428160854421) | 7 | 9 | 11 | 28852 | 10 | |||||
94077 | 103591 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 55X Laguna St | 3 | Front Yard : Yard | Tree | Private 2 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | |||||
95437 | 103618 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 201X Haight St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
96773 | 92813 | Significant Tree 6 | Tree(s) :: 17 | 365 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 53020 | 6006011 | 2111744 | 37.7787863189721 | -122.42277474798 | (37.7787863189721, -122.42277474798) | 7 | 9 | 11 | 28852 | 10 | |||
99529 | 103588 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 101X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | |||||
99672 | 121159 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 3 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
99950 | 117000 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 880x MCALLISTER ST | 3 | Front Yard : Cutout | Tree | Private 2 | 6005306 | 2112177 | 37.779935428414 | -122.425244441442 | (37.779935428414, -122.425244441442) | 7 | 9 | 11 | 28852 | 41 | |||||
100242 | 106956 | Significant Tree 6 | Tree(s) :: 17 | 50 Fell St | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 10x10 | 6007226 | 2110908 | 37.7765593411304 | -122.418512280303 | (37.7765593411304, -122.418512280303) | 7 | 9 | 9 | 28852 | 36 | |||
100606 | 100772 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 3 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
103945 | 258237 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
105893 | 116998 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 880x MCALLISTER ST | 1 | Front Yard : Cutout | Tree | Private 2 | 6005306 | 2112177 | 37.779935428414 | -122.425244441442 | (37.779935428414, -122.425244441442) | 7 | 9 | 11 | 28852 | 41 | |||||
106415 | 121157 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 1 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
108684 | 103655 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
109250 | 107818 | Significant Tree 6 | Ficus Spp. :: 101 | 474 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 6004715.2 | 2110227.8 | 37.7745500089947 | -122.427149405032 | (37.7745500089947, -122.427149405032) | 7 | 9 | 11 | 28852 | 10 | ||||
109449 | 103656 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
110134 | 103612 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
113506 | 108002 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 461X Ivy St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005199.36333 | 2111122.83043 | 37.7770349120596 | -122.425538300101 | (37.7770349120596, -122.425538300101) | 7 | 9 | 11 | 28852 | 10 | |||||
120358 | 103590 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 55X Laguna St | 2 | Front Yard : Yard | Tree | Private 2 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | |||||
120900 | 258240 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
121235 | 86895 | Significant Tree 6 | Tree(s) :: 17 | 321 Haight St | Front Yard : Yard | Tree | Private 2 | 10/26/2007 12:00:00 AM | Permit Number 49844 | 6004599.9 | 2109420.1 | 37.7723257406977 | -122.427490696784 | (37.7723257406977, -122.427490696784) | 7 | 9 | 11 | 28852 | 10 | ||||
123818 | 121160 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 4 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
125282 | 110236 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x20 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
126537 | 105082 | Significant Tree 6 | :: 45 | 344 Fulton St | 2 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
138832 | 258234 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
140823 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 401 Grove St | 11 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
144064 | 103614 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
145102 | 105085 | Significant Tree 6 | :: 45 | 344 Fulton St | 5 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
147643 | 100770 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
151632 | 95299 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
152489 | 103652 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
154153 | 105087 | Significant Tree 6 | :: 45 | 344 Fulton St | 7 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
154569 | 103589 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 55X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | |||||
155172 | 258233 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
157383 | 110560 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 320x FULTON ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x36 | 6006080 | 2112015 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | 7 | 9 | 11 | 28852 | 10 | ||||
157916 | 110559 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 320x FULTON ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x36 | 6006080 | 2112015 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | 7 | 9 | 11 | 28852 | 10 | ||||
160060 | 258238 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
161677 | 105090 | Significant Tree 6 | :: 45 | 344 Fulton St | 10 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
166073 | 112419 | Significant Tree 6 | Picea Spp :: Spruce Spp 200 | 268 Lily St | 1 | Back Yard : Yard | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | |||
167444 | 105083 | Significant Tree 6 | :: 45 | 344 Fulton St | 3 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
167525 | 258528 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Hermann St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
170978 | 108021 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 455X Ivy St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | 7 | 9 | 11 | 28852 | 10 | |||||
172262 | 103613 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
174521 | 258525 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 50 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
176793 | 98949 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 9 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
182332 | 258021 | Significant Tree 6 | Tree(s) :: 17 | 201x Gough St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006013 | 2110374 | 37.7750247439455 | -122.422670446803 | (37.7750247439455, -122.422670446803) | 7 | 9 | 11 | 28852 | 10 | ||||
182906 | 103611 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
186789 | 105088 | Significant Tree 6 | :: 45 | 344 Fulton St | 8 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
194054 | 121158 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 2 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
5414 | 261208 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1131 Sutter St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2115019 | 37.7878442781586 | -122.418980353142 | (37.7878442781586, -122.418980353142) | 13 | 9 | 10 | 28858 | 21 | ||||
10123 | 257894 | Significant Tree 6 | Metrosideros robusta :: Northern Rata Tree 335 | 1776 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 01/27/2020 12:00:00 AM | 3 | 6005064 | 2118169 | 37.7963742870274 | -122.426508408066 | (37.7963742870274, -122.426508408066) | 13 | 9 | 1 | 28858 | 17 | |||
10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
15160 | 260680 | Significant Tree 6 | Tree(s) :: 17 | 1450x Laguna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6004617 | 2113883 | 37.7845807327875 | -122.42774958855 | (37.7845807327875, -122.42774958855) | 13 | 9 | 11 | 28858 | 41 | ||||
20207 | 105239 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 6 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
27012 | 255276 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 263 Willow St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 6006404.75096 | 2113360.62408 | 37.7832473828943 | -122.421527451234 | (37.7832473828943, -122.421527451234) | 7 | 9 | 11 | 28858 | 41 | ||||
27763 | 105240 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 10 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
33858 | 255597 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
36041 | 255248 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
55812 | 101740 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1590 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | 10 | Permit Number 769428 | 6006182.95151 | 2117984.64817 | 37.7959312951427 | -122.42262348649 | (37.7959312951427, -122.42262348649) | 13 | 9 | 10 | 28858 | 32 | ||
63716 | 101743 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1590 Broadway | 4 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | 12 | Permit Number 769428 | 6006129.33795 | 2117976.30804 | 37.7959053703882 | -122.422808406898 | (37.7959053703882, -122.422808406898) | 13 | 9 | 10 | 28858 | 32 | ||
72516 | 258223 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 53 Starr King Way | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | Permit Number 782966 | 6005764 | 2113984 | 37.784922869937 | -122.423788535241 | (37.784922869937, -122.423788535241) | 13 | 9 | 11 | 28858 | 41 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );