trees
39,840 rows where qLegalStatus_id = 7 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
165 | 104843 | Permitted Site 7 | :: 45 | 1320 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989622 | 2106334.7 | 37.7629955389606 | -122.479074319647 | (37.7629955389606, -122.479074319647) | 1 | 8 | 3 | 56 | 35 | ||||||
980 | 96180 | Permitted Site 7 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767812 | ||||||||||||||
1558 | 256904 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1571 37th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782743 | 5984651.59496 | 2104500.79365 | 37.7576702424259 | -122.496129679735 | (37.7576702424259, -122.496129679735) | 1 | 8 | 3 | 56 | 35 | |
2238 | 88648 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 74 Carmelita St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51628 | 6002619 | 2108775 | 37.7704422164895 | -122.434296675208 | (37.7704422164895, -122.434296675208) | 15 | 5 | 5 | 29492 | 9 | |||
2777 | 256912 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
3226 | 107892 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 162 Brewster St | Front Yard : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.407278527778 | (37.7440766668365, -122.407278527778) | 2 | 7 | 7 | 28859 | 2 | ||
3667 | 97254 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 601 Tompkins Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768271 | 6008616.2 | 2096553.7 | 37.7372238594213 | -122.412688154144 | (37.7372238594213, -122.412688154144) | 10 | 7 | 7 | 28859 | 2 | |||
3941 | 92078 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1151 Sutter St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2009 12:00:00 AM | 3x3 | Permit Number 52192 | 6007083 | 2115004 | 37.7877979108835 | -122.419297592258 | (37.7877979108835, -122.419297592258) | 13 | 9 | 10 | 28858 | 21 | |||
3994 | 256688 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1477 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782620 | |||||||||||
4377 | 88323 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417 | 2092629 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | 9 | 7 | 6 | 28861 | 5 | |||
4537 | 96174 | Permitted Site 7 | Malus sylvestris :: Apple 277 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767807 | ||||||||||||||
5227 | 96177 | Permitted Site 7 | Diospyros kaki :: Persimmon 288 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767810 | ||||||||||||||
5290 | 89193 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | |||||
5320 | 88554 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 579 16th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51499 | 5990911.3 | 2111462.4 | 37.7771496035915 | -122.474989443149 | (37.7771496035915, -122.474989443149) | 11 | 6 | 2 | 54 | 26 | |||
5477 | 88381 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 423 16th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51359 | 5990873.7 | 2112494.8 | 37.7799821106609 | -122.475194900005 | (37.7799821106609, -122.475194900005) | 11 | 6 | 2 | 54 | 26 | |||
5724 | 87766 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 3896 22nd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50469 | 6002488 | 2102987 | 37.7545423364482 | -122.434335932006 | (37.7545423364482, -122.434335932006) | 2 | 4 | 5 | 28862 | 22 | |||
5768 | 87061 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | unknown : Yard | Tree | Private 2 | 3x3 | Permit Number 50003 | |||||||||||||||
6343 | 96176 | Permitted Site 7 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767809 | ||||||||||||||
6402 | 94573 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3978 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53752 | 6003116 | 2105363 | 37.761101890414 | -122.432333828196 | (37.761101890414, -122.432333828196) | 15 | 4 | 5 | 28862 | 3 | ||
6593 | 261297 | Permitted Site 7 | :: 45 | 3180 18th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/01/2013 12:00:00 AM | 3 | 6008239.4944 | 2105648.95562 | 37.762176240156 | -122.414634049312 | (37.762176240156, -122.414634049312) | 8 | 4 | 7 | 28859 | 19 | ||||
6730 | 96175 | Permitted Site 7 | Malus sylvestris :: Apple 277 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767808 | ||||||||||||||
6813 | 256911 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
6833 | 109426 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 132 Locust St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 5997544.3 | 2115966.4 | 37.7898985728773 | -122.452369007612 | (37.7898985728773, -122.452369007612) | 11 | 6 | 1 | 54 | 31 | ||||
8281 | 87805 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50570 | 6001886.8 | 2119949.6 | 37.8010832252731 | -122.437629755692 | (37.8010832252731, -122.437629755692) | 13 | 9 | 1 | 57 | 17 | |||
8305 | 86762 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
8362 | 96178 | Permitted Site 7 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767810 | ||||||||||||||
8520 | 108716 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 201 Randall St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773302 | 6004213.21698 | 2097517.41416 | 37.7396218942487 | -122.427979939698 | (37.7396218942487, -122.427979939698) | 2 | 7 | 5 | 63 | 7 | |
8544 | 256668 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1835 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782601 | |||||||||||
8593 | 91087 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207 | 2088764 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | 9 | 8 | 6 | 64 | 24 | |||
8599 | 262043 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 245 11th St | : Cutout | Tree | Private 2 | FUF | 04/14/2020 12:00:00 AM | 3 | Permit Number 785251 | 6008265.74007 | 2109435.35593 | 37.7725742877847 | -122.414811260337 | (37.7725742877847, -122.414811260337) | 8 | 2 | 9 | 28853 | 34 | ||
8700 | 106117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2014 12:00:00 AM | 3x3 | Permit Number 772749 | 6002458.5 | 2091056.7 | 37.7217828139374 | -122.433585385445 | (37.7217828139374, -122.433585385445) | 9 | 7 | 6 | 28861 | 5 | |||
8975 | 256665 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 5x5 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
9283 | 94134 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 18 Nebraska St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53498 | 6009291 | 2097948 | 37.7410901551317 | -122.410453476975 | (37.7410901551317, -122.410453476975) | 10 | 7 | 7 | 28859 | 2 | |||
9573 | 108831 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 774658 | 6003763.1265 | 2093992.42876 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | 9 | 7 | 6 | 28861 | 5 | |||
10067 | 88529 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51479 | ||||||||||||||
10084 | 91045 | Permitted Site 7 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1100X Chestnut St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2006 12:00:00 AM | 3x3 | Permit Number 48418 | 6006545 | 2120445 | 37.8027072182013 | -122.42154555229 | (37.8027072182013, -122.42154555229) | 5 | 9 | 1 | 28858 | 32 | |||
10118 | 108815 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 474 Munich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774652 | 6003779.44726 | 2089723.38143 | 37.7181966752665 | -122.428924204145 | (37.7181966752665, -122.428924204145) | 9 | 7 | 6 | 28861 | 5 | |
10409 | 256902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
10600 | 254532 | Permitted Site 7 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 154 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781436 | |||||||||||
11108 | 86883 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 550 Jersey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49808 | 6001589 | 2101474 | 37.750336931821 | -122.43733657342 | (37.750336931821, -122.43733657342) | 2 | 4 | 5 | 28862 | 22 | ||||
11448 | 96234 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/15/2011 12:00:00 AM | Permit Number 767856 | |||||||||||||||
11572 | 96179 | Permitted Site 7 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | Permit Number 767811 | |||||||||||||||
11682 | 89044 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51783 | 6002618 | 2096049 | 37.7354995892493 | -122.433390603486 | (37.7354995892493, -122.433390603486) | 2 | 7 | 5 | 63 | 7 | ||||
11701 | 87286 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1272 42nd Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 03/18/2007 12:00:00 AM | Permit Number 50303 | 5983096.8 | 2106514.6 | 37.7631083916796 | -122.501655692289 | (37.7631083916796, -122.501655692289) | 1 | 8 | 3 | 56 | 35 | ||||
12231 | 96231 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
12237 | 88560 | Permitted Site 7 | Prunus spp :: Cherry 68 | 2901 Pierce St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501 | 2118350 | 37.7966692015857 | -122.438850093229 | (37.7966692015857, -122.438850093229) | 13 | 9 | 1 | 57 | 17 | |||
12300 | 93053 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | 36 | Permit Number 53387 | ||||||||||||||
12345 | 107864 | Permitted Site 7 | Tree(s) :: 17 | 362 BRANNAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014441.4 | 2112297.4 | 37.7807778793576 | -122.393649202889 | (37.7807778793576, -122.393649202889) | 6 | 2 | 9 | 28856 | 6 | |||||
12387 | 88728 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
12615 | 87685 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 118 Virginia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 4x4 | Permit Number 776560 | 6006594.8 | 2098480.6 | 37.7424010366351 | -122.419813761733 | (37.7424010366351, -122.419813761733) | 2 | 7 | 7 | 28859 | 2 | |||
13104 | 88055 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 52 Robblee Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 3x3 | Permit Number 51065 | 6012498 | 2095923.9 | 37.7357116661186 | -122.399222709682 | (37.7357116661186, -122.399222709682) | 10 | 3 | 8 | 58 | 1 | |||
13212 | 87784 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 48 Santa Ysabel Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50524 | 6000929.5 | 2093152.6 | 37.7274508049284 | -122.439020861215 | (37.7274508049284, -122.439020861215) | 9 | 7 | 6 | 28861 | 25 | |||
13863 | 108832 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 60 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774659 | 6003833.887 | 2093995.50335 | 37.7299300570357 | -122.429040457944 | (37.7299300570357, -122.429040457944) | 9 | 7 | 6 | 28861 | 5 | |
14247 | 256666 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1406 California St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782597 | |||||||||||
14367 | 86754 | Permitted Site 7 | Tree(s) :: 17 | 1376 06th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | Permit Number 49715 | 5994310.3 | 2106169.4 | 37.7628128189867 | -122.462847225894 | (37.7628128189867, -122.462847225894) | 1 | 5 | 11 | 56 | 12 | ||||
14870 | 87142 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 54 Homestead St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50130 | 6000955 | 2101398 | 37.7500921913505 | -122.439523535984 | (37.7500921913505, -122.439523535984) | 2 | 4 | 5 | 28862 | 22 | |||
15100 | 86751 | Permitted Site 7 | Tree(s) :: 17 | 81 Parker Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | 11 | 6 | 1 | 54 | 31 | ||||
15191 | 96232 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
15343 | 92823 | Permitted Site 7 | Tree(s) :: 17 | 50 Kirkham St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2009 12:00:00 AM | 3x3 | Permit Number 53037 | 5994776.3 | 2105346.5 | 37.7605801777143 | -122.461175855238 | (37.7605801777143, -122.461175855238) | 15 | 5 | 11 | 56 | 12 | |||
15444 | 89331 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201 | 2105201 | 37.7604913603716 | -122.4424038966 | (37.7604913603716, -122.4424038966) | 15 | 4 | 5 | 28862 | 3 | |||
15845 | 258506 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1826 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784310 | 5981340.96511 | 2102634.36273 | 37.7523510806953 | -122.507440512367 | (37.7523510806953, -122.507440512367) | 1 | 8 | 3 | 56 | 35 | |
15890 | 256718 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 927 Brazil Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782649 | |||||||||||
16191 | 254533 | Permitted Site 7 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 154 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781436 | |||||||||||
16203 | 87742 | Permitted Site 7 | Morus alba :: White Mulberry 246 | 1725 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50405 | 6009154 | 2119215 | 37.7994767072274 | -122.412430063534 | (37.7994767072274, -122.412430063534) | 3 | 1 | 10 | 308 | 32 | |||
16351 | 92032 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4232 21st St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2009 12:00:00 AM | 3x3 | Permit Number 52175 | 6001386.1 | 2103403.9 | 37.75562443672 | -122.43817644846 | (37.75562443672, -122.43817644846) | 2 | 4 | 5 | 28862 | 3 | |||
16550 | 88330 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 544 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51318 | 6001416.8 | 2090660.3 | 37.7206352284922 | -122.437157897339 | (37.7206352284922, -122.437157897339) | 9 | 7 | 6 | 28861 | 5 | |||
16631 | 104298 | Permitted Site 7 | Tree(s) :: 17 | 4021 20TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 6003557 | 2104154 | 37.7578072610358 | -122.430722322319 | (37.7578072610358, -122.430722322319) | 2 | 4 | 5 | 28862 | 3 | |||||
16680 | 256664 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 5x5 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
17354 | 88467 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 119 Augusta St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176 | 2095454 | 37.7343476550611 | -122.403760347511 | (37.7343476550611, -122.403760347511) | 10 | 3 | 8 | 58 | 1 | |||
17594 | 254853 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799 Avalon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781645 | |||||||||||
17742 | 94465 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 4128 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5x6 | Permit Number 779215 | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||
17928 | 87790 | Permitted Site 7 | Brahea aramata :: Mexican Blue Palm 377 | 635 Buena Vista West Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2008 12:00:00 AM | Permit Number 50531 | 5999771 | 2107673 | 37.7672543384354 | -122.444068690497 | (37.7672543384354, -122.444068690497) | 15 | 5 | 5 | 29492 | 9 | ||||
18166 | 88091 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1619 39th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51095 | 5984024.3 | 2104125.3 | 37.756602478656 | -122.498271356488 | (37.756602478656, -122.498271356488) | 1 | 8 | 3 | 56 | 35 | |||
18199 | 254500 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1715 Octavia St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769839 | 6004851.87126 | 2115244.61878 | 37.7883326812086 | -122.427034026756 | (37.7883326812086, -122.427034026756) | 13 | 9 | 11 | 28858 | 27 | |
18284 | 258470 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2414 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781119 | 5981787.508 | 2098641.53969 | 37.741414197633 | -122.505600368739 | (37.741414197633, -122.505600368739) | 1 | 8 | 3 | 29491 | 35 | |
18289 | 88190 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1118 Harrison St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631 | 2110372 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | 8 | 2 | 9 | 28853 | 34 | |||
18434 | 105315 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | |||||
18452 | 108642 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Judson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | 9 | 7 | 4 | 28861 | 40 | |
19174 | 261294 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 801 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6012760.41981 | 2103766.81895 | 37.7572612683759 | -122.398865686828 | (37.7572612683759, -122.398865686828) | 10 | 3 | 8 | 28856 | 29 | |||||
19267 | 88109 | Permitted Site 7 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1305 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51113 | 5981150.4 | 2106141.9 | 37.7619705488895 | -122.508359845943 | (37.7619705488895, -122.508359845943) | 1 | 8 | 3 | 56 | 35 | |||
19465 | 96173 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767806 | ||||||||||||||
20053 | 88130 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 822 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51154 | 6001234 | 2099702 | 37.7454512540188 | -122.438437243524 | (37.7454512540188, -122.438437243524) | 2 | 4 | 5 | 63 | 22 | |||
20087 | 255687 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1435 Oakdale Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782067 | 6015917.10189 | 2094795.04742 | 37.7328020209929 | -122.387322721383 | (37.7328020209929, -122.387322721383) | 10 | 3 | 8 | 58 | 1 | |
20705 | 108706 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1683 Chattanooga St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774629 | 6004719.93732 | 2102694.114 | 37.7538645742471 | -122.42659644528 | (37.7538645742471, -122.42659644528) | 2 | 4 | 5 | 28862 | 22 | |
21071 | 258216 | Permitted Site 7 | Banksia integrifolia :: Coast Banksia 21 | 1525 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783183 | 5982470.91812 | 2104727.52358 | 37.758164806501 | -122.503688017142 | (37.758164806501, -122.503688017142) | 1 | 8 | 3 | 56 | 35 | |
21342 | 88261 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 229 Douglass St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51248 | 6001199 | 2104918 | 37.7597711445886 | -122.438931999231 | (37.7597711445886, -122.438931999231) | 2 | 4 | 5 | 28862 | 3 | |||
21444 | 87268 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 727 Moraga St | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/05/2008 12:00:00 AM | Permit Number 50290 | 5992077 | 2103851 | 37.7563182174397 | -122.470402504062 | (37.7563182174397, -122.470402504062) | 1 | 8 | 4 | 56 | 12 | ||||
21713 | 88316 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 447 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51307 | 6003165.8 | 2091093 | 37.7219225920035 | -122.431143024225 | (37.7219225920035, -122.431143024225) | 9 | 7 | 6 | 28861 | 5 | |||
21984 | 105306 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2014 12:00:00 AM | 3x3 | Permit Number 771671 | 6001537.2 | 2100535.2 | 37.7477562656077 | -122.437448482105 | (37.7477562656077, -122.437448482105) | 2 | 4 | 5 | 63 | 22 | |||
22133 | 86802 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2007 12:00:00 AM | 3x3 | Permit Number 49634 | 6008359 | 2106197 | 37.7636877570953 | -122.414259500664 | (37.7636877570953, -122.414259500664) | 8 | 4 | 7 | 28859 | 19 | |||
22140 | 108608 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 46 Mirabel Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774593 | 6007564.86266 | 2099909.67409 | 37.7463795558054 | -122.416560777242 | (37.7463795558054, -122.416560777242) | 2 | 7 | 7 | 28859 | 2 | |
22225 | 88126 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2202 Sutter St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51132 | 6002003.4 | 2114360.3 | 37.7857430855157 | -122.436825926477 | (37.7857430855157, -122.436825926477) | 13 | 6 | 1 | 29490 | 27 | |||
22366 | 108443 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 559 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773772 | 5994363.45802 | 2111716.68858 | 37.7780472719646 | -122.463065881676 | (37.7780472719646, -122.463065881676) | 11 | 6 | 2 | 54 | 11 | |||
22683 | 86700 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | ||||||
22718 | 88236 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1593 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51225 | 6001491 | 2111451 | 37.7777257527509 | -122.438390172535 | (37.7777257527509, -122.438390172535) | 15 | 5 | 11 | 29492 | 41 | |||
22984 | 92756 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
22987 | 88225 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2084 Hayes St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51221 | 5997896.9 | 2109991 | 37.7735118836843 | -122.450718045928 | (37.7735118836843, -122.450718045928) | 15 | 5 | 11 | 29492 | 16 | |||
23031 | 88096 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.499127022602 | (37.7534794912156, -122.499127022602) | 1 | 8 | 3 | 56 | 35 | |||
23278 | 88325 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 346 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51314 | 6002623 | 2091442 | 37.7228500939634 | -122.433044266804 | (37.7228500939634, -122.433044266804) | 9 | 7 | 6 | 28861 | 5 | |||
23388 | 256663 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 |
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) );