trees
274 rows where Supervisor Districts = 9 and qLegalStatus_id = 2 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11745 | 260192 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Market St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 4X4 | 6006124.91889 | 2109483.72494 | 37.7725865765291 | -122.422220029928 | (37.7725865765291, -122.422220029928) | 8 | 2 | 9 | 28853 | 19 | ||
18138 | 260191 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Market St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 4X4 | 6006124.91889 | 2109483.72494 | 37.7725865765291 | -122.422220029928 | (37.7725865765291, -122.422220029928) | 8 | 2 | 9 | 28853 | 19 | ||
642 | 260182 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
8102 | 260181 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
14403 | 260183 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
1080 | 169338 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1029 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2019 12:00:00 AM | 3 | Width 4ft | 6006781.41851 | 2114264.09095 | 37.7857493130165 | -122.420288474132 | (37.7857493130165, -122.420288474132) | 13 | 9 | 9 | 28858 | 36 | ||
16066 | 260290 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1029 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2019 12:00:00 AM | 3 | Width 4ft | 6006781.41851 | 2114264.09095 | 37.7857493130165 | -122.420288474132 | (37.7857493130165, -122.420288474132) | 13 | 9 | 9 | 28858 | 36 | ||
64870 | 255402 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 150 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
72419 | 255414 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
87472 | 255403 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 150 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
108535 | 255409 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
109022 | 255406 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
124352 | 255410 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
130074 | 255415 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
139116 | 255407 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
149074 | 255412 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
164769 | 255405 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
165740 | 255404 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 150 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
167550 | 255408 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
178102 | 255413 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
179705 | 255411 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
12720 | 115537 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
40425 | 115540 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x5 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
75364 | 115539 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
164265 | 115538 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
185440 | 115536 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
165889 | 65944 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 1051 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774496 | 6007126.88528 | 2114657.80083 | 37.7868498044193 | -122.419121190999 | (37.7868498044193, -122.419121190999) | 13 | 9 | 9 | 28858 | 36 | |
184734 | 115535 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007237.56945 | 2111260.60051 | 37.7775281488378 | -122.418497266559 | (37.7775281488378, -122.418497266559) | 7 | 9 | 9 | 28852 | 36 | ||
93518 | 115534 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007259.83389 | 2111260.26588 | 37.7775284833993 | -122.418420222514 | (37.7775284833993, -122.418420222514) | 7 | 9 | 9 | 28852 | 36 | ||
115681 | 115533 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007275.38703 | 2111262.82601 | 37.7775363884346 | -122.418366600452 | (37.7775363884346, -122.418366600452) | 7 | 9 | 9 | 28852 | 36 | ||
34272 | 115532 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007293.46404 | 2111265.83422 | 37.7775456658356 | -122.418304279225 | (37.7775456658356, -122.418304279225) | 7 | 9 | 9 | 28852 | 36 | ||
168962 | 115531 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007312.73746 | 2111269.98589 | 37.7775581502144 | -122.41823790028 | (37.7775581502144, -122.41823790028) | 7 | 9 | 9 | 28852 | 36 | ||
171393 | 115528 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007325.8351 | 2111377.63368 | 37.7778544624367 | -122.418200224953 | (37.7778544624367, -122.418200224953) | 7 | 9 | 9 | 28852 | 36 | |
135842 | 115529 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007327.31765 | 2111347.52577 | 37.777771876795 | -122.418192961161 | (37.777771876795, -122.418192961161) | 7 | 9 | 9 | 28852 | 36 | |
167439 | 115530 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007332.44961 | 2111311.79762 | 37.7776740647351 | -122.418172674243 | (37.7776740647351, -122.418172674243) | 7 | 9 | 9 | 28852 | 36 | |
78499 | 255416 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
126056 | 255417 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
136714 | 65940 | Planning Code 138.1 required 2 | Liquidambar styraciflua :: American Sweet Gum 37 | 620 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 8 | Permit Number 28961 | 6007431.46715 | 2113367.23378 | 37.7833233693217 | -122.417975883707 | (37.7833233693217, -122.417975883707) | 7 | 9 | 9 | 28858 | 36 | |
181676 | 196592 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 43 Lafayette St | 4 | : | Tree | Private 2 | 8 | Width 3ft | Permit Number 772992 | 6007533.59843 | 2109642.31042 | 37.7731013709756 | -122.417358489209 | (37.7731013709756, -122.417358489209) | 8 | 2 | 9 | 28853 | 19 | ||
112760 | 196591 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 43 Lafayette St | 3 | : | Tree | Private 2 | 13 | Width 3ft | Permit Number 772992 | 6007555.65106 | 2109624.06249 | 37.7730525072055 | -122.417280912782 | (37.7730525072055, -122.417280912782) | 8 | 2 | 9 | 28853 | 19 | ||
98537 | 196590 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 43 Lafayette St | 2 | : | Tree | Private 2 | 10 | Width 3ft | Permit Number 772992 | 6007565.69447 | 2109618.27361 | 37.7730371773558 | -122.417245760983 | (37.7730371773558, -122.417245760983) | 8 | 2 | 9 | 28853 | 19 | ||
129348 | 251179 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
138609 | 251178 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
177182 | 15246 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770901 | 6007883.54199 | 2110310.54573 | 37.7749558692557 | -122.416195322271 | (37.7749558692557, -122.416195322271) | 8 | 2 | 9 | 28853 | 34 | |
158086 | 15247 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007902.55668 | 2110326.57547 | 37.7750009522643 | -122.416130681693 | (37.7750009522643, -122.416130681693) | 8 | 2 | 9 | 28853 | 34 | |
23724 | 15248 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007914.86722 | 2110337.26914 | 37.7750310067149 | -122.41608885424 | (37.7750310067149, -122.41608885424) | 8 | 2 | 9 | 28853 | 34 | |
22638 | 113651 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
26508 | 113650 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
36458 | 113646 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
88035 | 113653 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
99698 | 113643 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
117291 | 113647 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
121557 | 113652 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
124821 | 113644 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
130377 | 113654 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
137539 | 113649 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
139476 | 113655 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 901X JESSIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 3x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
152719 | 113648 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
154892 | 113645 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
182348 | 173697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007975.5805432 | 2110395.7628537 | 37.775195030009 | -122.415882976003 | (37.775195030009, -122.415882976003) | 8 | 2 | 9 | 28853 | 34 | |
33336 | 192346 | Planning Code 138.1 required 2 | Fraxinus spp :: Ash Spp 121 | 118 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 770901 | 6007994.19176 | 2110350.54528 | 37.7750719195804 | -122.415815392882 | (37.7750719195804, -122.415815392882) | 8 | 2 | 9 | 28853 | 34 | |
106809 | 29017 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 120 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2014 12:00:00 AM | 6 | 3x3 | Permit Number 770901 | 6008044.5664857 | 2110308.5131992 | 37.7749593412658 | -122.415638158484 | (37.7749593412658, -122.415638158484) | 8 | 2 | 9 | 28853 | 34 | |
68035 | 117021 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008114.19003 | 2113031.70239 | 37.7824404814865 | -122.415590162171 | (37.7824404814865, -122.415590162171) | 7 | 10 | 9 | 28852 | 36 | |
61797 | 117020 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008118.25915 | 2113018.66588 | 37.7824049150971 | -122.415575161466 | (37.7824049150971, -122.415575161466) | 7 | 10 | 9 | 28852 | 36 | |
14869 | 117019 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008121.68381 | 2113004.40875 | 37.782365960952 | -122.415562303882 | (37.782365960952, -122.415562303882) | 7 | 10 | 9 | 28852 | 36 | |
77658 | 94315 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008122 | 2112982 | 37.7823044496932 | -122.415559622955 | (37.7823044496932, -122.415559622955) | 7 | 10 | 9 | 28852 | 36 | |
97662 | 117018 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.66458 | 2112987.05621 | 37.7823185388132 | -122.415547303188 | (37.7823185388132, -122.415547303188) | 7 | 10 | 9 | 28852 | 36 | |
81347 | 117017 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008130.7573 | 2112963.51283 | 37.7822541806174 | -122.415528017206 | (37.7822541806174, -122.415528017206) | 7 | 10 | 9 | 28852 | 36 | |
71488 | 190612 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Washburn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 775218 | 6008236.46776 | 2110619.04505 | 37.7758227734432 | -122.414996312823 | (37.7758227734432, -122.414996312823) | 8 | 2 | 9 | 28853 | 34 | |
176904 | 190611 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Washburn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 775218 | 6008250.0486 | 2110605.54207 | 37.7757864606069 | -122.41494837717 | (37.7757864606069, -122.41494837717) | 8 | 2 | 9 | 28853 | 34 | |
61672 | 15237 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) | 8 | 2 | 9 | 28853 | 34 | |
190069 | 15235 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) | 8 | 2 | 9 | 28853 | 34 | |
61214 | 15236 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008261.49106 | 2110663.48431 | 37.7759461992201 | -122.414912896556 | (37.7759461992201, -122.414912896556) | 8 | 2 | 9 | 28853 | 34 | |
159283 | 192594 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/1995 12:00:00 AM | 2 | Width 4ft | Permit Number 770747 | 6008274.3646 | 2110675.08431 | 37.7759787734355 | -122.414869184668 | (37.7759787734355, -122.414869184668) | 8 | 2 | 9 | 28853 | 34 | |
52682 | 192595 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1995 12:00:00 AM | 3 | Width 4ft | Permit Number 770747 | 6008285.14461 | 2110684.68439 | 37.7760057386966 | -122.414832573262 | (37.7760057386966, -122.414832573262) | 8 | 2 | 9 | 28853 | 34 | |
162521 | 192596 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1335 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1995 12:00:00 AM | 3 | Width 4ft | Permit Number 770747 | 6008295.90964 | 2110693.56586 | 37.7760307299718 | -122.414795962779 | (37.7760307299718, -122.414795962779) | 8 | 2 | 9 | 28853 | 34 | |
39373 | 251291 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.7777175065003 | -122.413322904728 | (37.7777175065003, -122.413322904728) | 8 | 2 | 9 | 28853 | 34 | |
115603 | 251289 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.7777175065003 | -122.413322904728 | (37.7777175065003, -122.413322904728) | 8 | 2 | 9 | 28853 | 34 | |
158927 | 251290 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.7777175065003 | -122.413322904728 | (37.7777175065003, -122.413322904728) | 8 | 2 | 9 | 28853 | 34 | |
169960 | 192564 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.7777175065003 | -122.413322904728 | (37.7777175065003, -122.413322904728) | 8 | 2 | 9 | 28853 | 34 | |
57131 | 192563 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008747.97709 | 2111280.89227 | 37.7776687794229 | -122.413273679445 | (37.7776687794229, -122.413273679445) | 8 | 2 | 9 | 28853 | 34 | |
176162 | 121550 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1125 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778243 | 6009252.51421 | 2111618.01515 | 37.7786227523886 | -122.411552131552 | (37.7786227523886, -122.411552131552) | 8 | 2 | 9 | 28853 | 34 | |
168133 | 121551 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778243 | 6009293.51408 | 2111653.12836 | 37.7787214646499 | -122.411412777974 | (37.7787214646499, -122.411412777974) | 8 | 2 | 9 | 28853 | 34 | |
5118 | 169123 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 210 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2019 12:00:00 AM | 3 | Width 4ft | 6009469.52117 | 2113800.26568 | 37.7846268637924 | -122.410955591431 | (37.7846268637924, -122.410955591431) | 14 | 10 | 9 | 28852 | 36 | ||
3797 | 260871 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
11471 | 260869 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
13730 | 260870 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
18437 | 260868 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
9750 | 169122 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 210 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2019 12:00:00 AM | 3 | Width 4ft | 6009478.56357 | 2113738.5186 | 37.7844578281201 | -122.410919945006 | (37.7844578281201, -122.410919945006) | 14 | 10 | 9 | 28852 | 36 | ||
57241 | 253248 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
79696 | 253247 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
187618 | 253249 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
34894 | 253483 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
35262 | 253489 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
36333 | 253491 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
50722 | 253485 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
61025 | 253495 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
84993 | 253492 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
85377 | 253490 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
93105 | 253487 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 |
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) );