trees
8,298 rows where qLegalStatus_id = 4 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25934 | 135966 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001187.63413 | 2117406.94715 | 37.7940619922234 | -122.439866757361 | (37.7940619922234, -122.439866757361) | 13 | 9 | 1 | 57 | 27 | |||
26219 | 95209 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2203@Clay Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000868 | 2115894 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | 13 | 6 | 1 | 29490 | 27 | ||||
26290 | 100794 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2499X Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002707 | 2116776 | 37.7924159434372 | -122.434564464045 | (37.7924159434372, -122.434564464045) | 13 | 9 | 1 | 29490 | 27 | |||
26359 | 111940 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 90 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 5987707 | 2115818 | 37.7889226212876 | -122.486393845778 | (37.7889226212876, -122.486393845778) | 11 | 6 | 1 | 55 | 33 | ||||
26574 | 100103 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 461 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
27011 | 111934 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 60 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5987882 | 2115824 | 37.7889492944095 | -122.485788817699 | (37.7889492944095, -122.485788817699) | 11 | 6 | 1 | 55 | 33 | ||||
27453 | 111935 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 66 SEACLIFF AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5987847 | 2115823 | 37.788944509176 | -122.485909838035 | (37.788944509176, -122.485909838035) | 11 | 6 | 1 | 55 | 33 | |||||
28155 | 106768 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 226 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x9 | 6001629.46862 | 2120633.92047 | 37.8029475537601 | -122.438569291156 | (37.8029475537601, -122.438569291156) | 13 | 9 | 1 | 57 | 17 | ||||
29014 | 115937 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X LAKE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5993877 | 2114929 | 37.786839375345 | -122.464982060228 | (37.786839375345, -122.464982060228) | 11 | 6 | 1 | 54 | 11 | ||||
29507 | 115701 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2840 LAKE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 5986626 | 2114487 | 37.785205010982 | -122.490035970437 | (37.785205010982, -122.490035970437) | 11 | 6 | 1 | 55 | 33 | ||||
30009 | 99508 | Undocumented 4 | Aesculus x carnea :: Red Horse Chestnut 267 | 2828 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000030 | 2117468 | 37.7941636633745 | -122.443876667305 | (37.7941636633745, -122.443876667305) | 13 | 9 | 1 | 57 | 27 | ||||
30032 | 121066 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 3199x Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005931 | 2121567 | 37.8057533025265 | -122.423750130533 | (37.8057533025265, -122.423750130533) | 5 | 1 | 1 | 28858 | 32 | ||||
30326 | 99286 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2839 Pacific Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000564.2 | 2116779 | 37.7923023065947 | -122.44197880494 | (37.7923023065947, -122.44197880494) | 13 | 6 | 1 | 29490 | 27 | |||||
30378 | 110304 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3735 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002991 | 2121133 | 37.8043952513031 | -122.433893386438 | (37.8043952513031, -122.433893386438) | 13 | 9 | 1 | 57 | 17 | ||||
30771 | 101430 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
30889 | 254841 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 71 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5993910 | 2115089 | 37.7872805943627 | -122.464879512834 | (37.7872805943627, -122.464879512834) | 11 | 6 | 1 | 54 | 11 | |
30901 | 103929 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 191 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5994248.3 | 2114379.9 | 37.7853530981444 | -122.463657591004 | (37.7853530981444, -122.463657591004) | 11 | 6 | 1 | 54 | 11 | ||||
31119 | 255523 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
31664 | 115699 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2840 LAKE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 5986626 | 2114487 | 37.785205010982 | -122.490035970437 | (37.785205010982, -122.490035970437) | 11 | 6 | 1 | 55 | 33 | ||||
32115 | 112617 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2399X DIVISADERO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000719 | 2116473 | 37.7914709305552 | -122.441421227792 | (37.7914709305552, -122.441421227792) | 13 | 6 | 1 | 29490 | 27 | ||||
32201 | 117042 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
32472 | 116801 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2120 BROADWAY | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003325 | 2117599 | 37.7947107530845 | -122.432484978634 | (37.7947107530845, -122.432484978634) | 13 | 9 | 1 | 29490 | 27 | ||||
32479 | 125072 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2559 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002527.91845 | 2116093.19627 | 37.7905309723786 | -122.435135231625 | (37.7905309723786, -122.435135231625) | 13 | 9 | 1 | 29490 | 27 | |||
32544 | 105274 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986553.3 | 2114252.8 | 37.784557719608 | -122.490270252434 | (37.784557719608, -122.490270252434) | 11 | 6 | 1 | 55 | 33 | |||||
32710 | 115086 | Undocumented 4 | Thuja plicata :: Western Red Cedar 307 | 2784X JACKSON ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000894 | 2116629 | 37.7919092338162 | -122.440826927692 | (37.7919092338162, -122.440826927692) | 13 | 6 | 1 | 29490 | 27 | |||
33165 | 115318 | Undocumented 4 | Ficus macrophylla :: Morton Bay Fig 322 | 3370 WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5998663 | 2115944 | 37.7899010948859 | -122.448496808995 | (37.7899010948859, -122.448496808995) | 13 | 6 | 1 | 54 | 31 | ||||
34089 | 102756 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 2807 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002069 | 2117756 | 37.7950705311236 | -122.436842144361 | (37.7950705311236, -122.436842144361) | 13 | 9 | 1 | 57 | 27 | |||
34132 | 111168 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6003190.19669 | 2119810.74673 | 37.8007759915841 | -122.43310951859 | (37.8007759915841, -122.43310951859) | 13 | 9 | 1 | 57 | 17 | |||
34398 | 101661 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
34652 | 108151 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
35338 | 113934 | Undocumented 4 | Tree(s) :: 17 | 800 EL CAMINO DEL MAR | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 3x3 | Permit Number 776988 | 5985966 | 2115003 | 37.7865832348262 | -122.492357345241 | (37.7865832348262, -122.492357345241) | 11 | 6 | 1 | 55 | 33 | ||
35465 | 109382 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 17 17TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5990474.2 | 2114948.8 | 37.78669694813 | -122.476756279285 | (37.78669694813, -122.476756279285) | 11 | 6 | 1 | 55 | 33 | |||
36178 | 108990 | Undocumented 4 | :: 45 | 2073-2099X Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | 13 | 9 | 1 | 57 | 17 | |||||
36751 | 121063 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
37319 | 105121 | Undocumented 4 | :: 45 | 721 BEACH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.420969011396 | (37.8064757462399, -122.420969011396) | 5 | 1 | 1 | 28858 | 32 | |||||
37383 | 121052 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
37428 | 105715 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 40X 18TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6x9 | 5990254.2 | 2114862 | 37.7864458560817 | -122.477511071909 | (37.7864458560817, -122.477511071909) | 11 | 6 | 1 | 55 | 33 | |||
38143 | 97575 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501x Presidio Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | 15 | 6 | 1 | 54 | 31 | |||||
38158 | 101288 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3355X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | 13 | 9 | 1 | 57 | 17 | ||||
38651 | 113775 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1712 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000121 | 2114885 | 37.7870766118482 | -122.443376178084 | (37.7870766118482, -122.443376178084) | 13 | 6 | 1 | 29490 | 27 | |||
39370 | 107630 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001495 | 2119755 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | 13 | 9 | 1 | 57 | 17 | |||
39406 | 129582 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003450.16372 | 2117252.10795 | 37.7937653733223 | -122.432027112554 | (37.7937653733223, -122.432027112554) | 13 | 9 | 1 | 29490 | 27 | |||
39521 | 107816 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 28TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x20 | 5987167.1 | 2114462.1 | 37.7851682253333 | -122.488162125765 | (37.7851682253333, -122.488162125765) | 11 | 6 | 1 | 55 | 33 | |||
39656 | 115936 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X LAKE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5993877 | 2114929 | 37.786839375345 | -122.464982060228 | (37.786839375345, -122.464982060228) | 11 | 6 | 1 | 54 | 11 | ||||
39975 | 121061 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
40072 | 95210 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2203@Clay Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6000868 | 2115894 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | 13 | 6 | 1 | 29490 | 27 | |||
40559 | 104272 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3675 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997210.1 | 2115656.5 | 37.7890285184352 | -122.453502918425 | (37.7890285184352, -122.453502918425) | 11 | 6 | 1 | 54 | 31 | ||||
41223 | 111952 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 73 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5987709 | 2115789 | 37.7888431121968 | -122.486384796167 | (37.7888431121968, -122.486384796167) | 11 | 6 | 1 | 55 | 33 | ||||
41363 | 102755 | Undocumented 4 | Shrub :: Shrub 66 | 61 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5996159.1 | 2114114.4 | 37.7847340229516 | -122.457027629275 | (37.7847340229516, -122.457027629275) | 11 | 6 | 1 | 54 | 31 | |||
41557 | 115704 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2820 LAKE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 5986689 | 2114483 | 37.7851977068092 | -122.489817718558 | (37.7851977068092, -122.489817718558) | 11 | 6 | 1 | 55 | 33 | ||||
41620 | 111945 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987570 | 2115773 | 37.7887910778243 | -122.486864535179 | (37.7887910778243, -122.486864535179) | 11 | 6 | 1 | 55 | 33 | |||||
43292 | 113935 | Undocumented 4 | Tree(s) :: 17 | 800 EL CAMINO DEL MAR | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 3x3 | Permit Number 776988 | 5985966 | 2115003 | 37.7865832348262 | -122.492357345241 | (37.7865832348262, -122.492357345241) | 11 | 6 | 1 | 55 | 33 | ||
43566 | 113936 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 800 EL CAMINO DEL MAR | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 776988 | 5985966 | 2115003 | 37.7865832348262 | -122.492357345241 | (37.7865832348262, -122.492357345241) | 11 | 6 | 1 | 55 | 33 | |||
43975 | 122579 | Undocumented 4 | Prunus spp :: Cherry 68 | 2500X Lyon St | 1 | Median : Cutout | Tree | Private 2 | 30 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
44007 | 111937 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 78 SEACLIFF AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 5987777 | 2115821 | 37.7889349383365 | -122.486151878662 | (37.7889349383365, -122.486151878662) | 11 | 6 | 1 | 55 | 33 | ||||
44631 | 122582 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 2500X Lyon St | 2 | Median : Cutout | Tree | Private 2 | 6 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
44767 | 111955 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 49 Seacliff Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5987872.34655427 | 2115783.06288074 | 37.7888363303163 | -122.485819211038 | (37.7888363303163, -122.485819211038) | 11 | 6 | 1 | 55 | 33 | |||
45400 | 117067 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 299X PRESIDIO AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998965 | 2115900 | 37.7897975450498 | -122.447448751983 | (37.7897975450498, -122.447448751983) | 13 | 6 | 1 | 54 | 31 | ||||
45633 | 115929 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3990 SACRAMENTO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995601 | 2114876 | 37.7867931062819 | -122.459013621631 | (37.7867931062819, -122.459013621631) | 11 | 6 | 1 | 54 | 31 | ||||
45816 | 121324 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
46946 | 112740 | Undocumented 4 | Tree(s) :: 17 | 2514 CLAY ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/09/2015 12:00:00 AM | 3x3 | Permit Number 776637 | 6002696 | 2116178 | 37.7907733646004 | -122.43455974658 | (37.7907733646004, -122.43455974658) | 13 | 9 | 1 | 29490 | 27 | ||
47028 | 110967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003043 | 2116458 | 37.7915618650441 | -122.433379161821 | (37.7915618650441, -122.433379161821) | 13 | 9 | 1 | 29490 | 27 | ||||
48110 | 108103 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
48222 | 100107 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
48350 | 111430 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500X PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999200 | 2114887 | 37.7870295394193 | -122.446562765799 | (37.7870295394193, -122.446562765799) | 15 | 6 | 1 | 29490 | 31 | ||||
48413 | 113168 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3902 CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996089 | 2115262 | 37.7878809990319 | -122.457353202257 | (37.7878809990319, -122.457353202257) | 11 | 6 | 1 | 54 | 31 | ||||
48655 | 113933 | Undocumented 4 | Tree(s) :: 17 | 800 EL CAMINO DEL MAR | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 3x3 | Permit Number 776988 | 5985966 | 2115003 | 37.7865832348262 | -122.492357345241 | (37.7865832348262, -122.492357345241) | 11 | 6 | 1 | 55 | 33 | ||
48758 | 112741 | Undocumented 4 | Cupressus sempervirens :: Italian Cypress 204 | 2514 CLAY ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6002696 | 2116178 | 37.7907733646004 | -122.43455974658 | (37.7907733646004, -122.43455974658) | 13 | 9 | 1 | 29490 | 27 | ||||
48825 | 116196 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 3751 CLAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996888 | 2115293 | 37.7880119756846 | -122.454591065245 | (37.7880119756846, -122.454591065245) | 11 | 6 | 1 | 54 | 31 | ||||
48998 | 98105 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 850 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001068 | 2114562 | 37.7862436951175 | -122.440076605796 | (37.7862436951175, -122.440076605796) | 13 | 6 | 1 | 29490 | 27 | |||
49204 | 101667 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
49686 | 99089 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801@Broderick Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
50213 | 111938 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 78 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987777 | 2115821 | 37.7889349383365 | -122.486151878662 | (37.7889349383365, -122.486151878662) | 11 | 6 | 1 | 55 | 33 | |||||
50422 | 121422 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2466 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999524 | 2119846 | 37.8006641419807 | -122.445798577396 | (37.8006641419807, -122.445798577396) | 13 | 9 | 1 | 57 | 17 | ||||
50742 | 117072 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 3105X CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
50841 | 103385 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 PRESIDIO AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999013 | 2116197 | 37.7906157715272 | -122.447304062173 | (37.7906157715272, -122.447304062173) | 13 | 6 | 1 | 29490 | 31 | ||||
51051 | 111449 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 291 32ND AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5985855 | 2113985 | 37.7837816114828 | -122.492666369295 | (37.7837816114828, -122.492666369295) | 11 | 6 | 1 | 55 | 33 | ||||
52051 | 100288 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
52243 | 250405 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 16 Seacliff Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5988113.64161 | 2115836.93474 | 37.788998304588 | -122.484988328172 | (37.788998304588, -122.484988328172) | 11 | 6 | 1 | 55 | 33 | |||
52306 | 103014 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1950X Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6000619.3 | 2112146.9 | 37.7795868963645 | -122.441455622144 | (37.7795868963645, -122.441455622144) | 15 | 5 | 1 | 29490 | 16 | |||
52804 | 122693 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2500X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | ||||
53341 | 255638 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 Masonic Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | |||||
54729 | 121020 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1653 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005036 | 2119492 | 37.8000053242339 | -122.426699554936 | (37.8000053242339, -122.426699554936) | 13 | 9 | 1 | 57 | 17 | ||||
55120 | 116042 | Undocumented 4 | Tree(s) :: 17 | 2617 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003977 | 2117866 | 37.7954808176447 | -122.43024802945 | (37.7954808176447, -122.43024802945) | 13 | 9 | 1 | 29490 | 27 | ||||
55655 | 250016 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Geary Blvd | 2 | : | Tree | Private 2 | 12 | Width 5ft | 6005727.9579 | 2114178.12622 | 37.7854538578564 | -122.423927038497 | (37.7854538578564, -122.423927038497) | 13 | 9 | 1 | 28858 | 41 | |||
55823 | 120504 | Undocumented 4 | Salix spp :: Willow 203 | 2050 Turk Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 6000175 | 2112136 | 37.7795316461312 | -122.442991859062 | (37.7795316461312, -122.442991859062) | 15 | 5 | 1 | 29490 | 16 | |||||
55994 | 102686 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2140 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6001431 | 2115640 | 37.7892242640561 | -122.438898003801 | (37.7892242640561, -122.438898003801) | 13 | 6 | 1 | 29490 | 27 | |||
56112 | 112489 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2690x Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2015 12:00:00 AM | 3x3 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | 5 | 1 | 1 | 308 | 32 | |||
56384 | 107052 | Undocumented 4 | Tree(s) :: 17 | 450 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.448562297399 | (37.7875132600186, -122.448562297399) | 13 | 6 | 1 | 54 | 31 | |||||
56533 | 99086 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2801@Broderick Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
57242 | 114460 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1462 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005986 | 2118991 | 37.7986833693446 | -122.423376553534 | (37.7986833693446, -122.423376553534) | 13 | 9 | 1 | 28858 | 32 | ||||
57863 | 111985 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 SEACLIFF AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5988113 | 2115801 | 37.7888996007164 | -122.484987910575 | (37.7888996007164, -122.484987910575) | 11 | 6 | 1 | 55 | 33 | ||||
58089 | 121568 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 499X Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998083 | 2114873 | 37.7869272334312 | -122.450426308155 | (37.7869272334312, -122.450426308155) | 11 | 6 | 1 | 54 | 31 | ||||
58698 | 254582 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 3239 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | 3x3 | 6001867 | 2119344 | 37.799419281227 | -122.437654876352 | (37.799419281227, -122.437654876352) | 13 | 9 | 1 | 57 | 17 | ||
59499 | 114431 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2787 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000638 | 2114779 | 37.7868150321065 | -122.441579867848 | (37.7868150321065, -122.441579867848) | 13 | 6 | 1 | 29490 | 27 | ||||
59647 | 93614 | Undocumented 4 | Tree(s) :: 17 | 3865 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 53255 | 5996391.2 | 2114920.9 | 37.7869617823748 | -122.456282979232 | (37.7869617823748, -122.456282979232) | 11 | 6 | 1 | 54 | 31 | ||
59777 | 113939 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 BUCHANAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003181 | 2119826 | 37.8008173514055 | -122.433142433403 | (37.8008173514055, -122.433142433403) | 13 | 9 | 1 | 57 | 17 | |||||
59827 | 117033 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
59847 | 116495 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2501x CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6002786 | 2116136 | 37.7906631519982 | -122.434245347461 | (37.7906631519982, -122.434245347461) | 13 | 9 | 1 | 29490 | 27 | ||||
59873 | 117586 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800X BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000654 | 2114867 | 37.787057568893 | -122.441530828991 | (37.787057568893, -122.441530828991) | 13 | 6 | 1 | 29490 | 27 |
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) );