trees
8,298 rows where qLegalStatus_id = 4 sorted by Police 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28626 | 100399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 4x4 | 6011664 | 2118384 | 37.7973355180624 | -122.403686018548 | (37.7973355180624, -122.403686018548) | 3 | 1 | 10 | 308 | 23 | ||
28662 | 99265 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | |||||
28847 | 116869 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2000x JONES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008236 | 2119365 | 37.7998370108632 | -122.415617306198 | (37.7998370108632, -122.415617306198) | 5 | 1 | 10 | 308 | 32 | ||||
28867 | 108644 | Undocumented 4 | Tree(s) :: 17 | 315X PACIFIC AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012408.6 | 2118423 | 37.7974841688946 | -122.401112237555 | (37.7974841688946, -122.401112237555) | 3 | 1 | 10 | 28860 | 4 | ||||
29140 | 108656 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
29875 | 120994 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
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 | ||||
30371 | 120985 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
30430 | 102606 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010368 | 2120990 | 37.8044184722981 | -122.408354438035 | (37.8044184722981, -122.408354438035) | 3 | 1 | 10 | 308 | 23 | ||||
30487 | 99178 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 330 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008617 | 2122137 | 37.807469636787 | -122.41449515712 | (37.807469636787, -122.41449515712) | 3 | 1 | 10 | 308 | 23 | ||||
30525 | 109918 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 114 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6010269.5 | 2121152.3 | 37.8048585915517 | -122.408706764133 | (37.8048585915517, -122.408706764133) | 3 | 1 | 10 | 308 | 23 | ||||
31564 | 113207 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
32295 | 121480 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 90x Maiden Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011222 | 2115110 | 37.7883211983641 | -122.404984820247 | (37.7883211983641, -122.404984820247) | 5 | 1 | 10 | 28857 | 6 | ||||
33291 | 116409 | Undocumented 4 | Elaeocarpus decipiens :: Japanese Blueberry Tree 321 | 600x GRANT AVE | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6011037 | 2116673 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | 3 | 1 | 10 | 28857 | 4 | |||||
33900 | 103111 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 300 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010691 | 2115198.3 | 37.7885339521538 | -122.40682822806 | (37.7885339521538, -122.40682822806) | 5 | 1 | 10 | 28857 | 6 | ||||
34104 | 113688 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
34442 | 113460 | Undocumented 4 | Ficus Spp. :: 101 | 18X LEROY PL | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008359 | 2116564 | 37.7921530708525 | -122.414993316892 | (37.7921530708525, -122.414993316892) | 5 | 1 | 10 | 28858 | 21 | ||||
34734 | 116368 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 100x SACRAMENTO ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013491 | 2117477 | 37.7949470000015 | -122.397300449207 | (37.7949470000015, -122.397300449207) | 3 | 1 | 10 | 28860 | 6 | ||||
34994 | 112672 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500x FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010481 | 2120003 | 37.8017147408613 | -122.407893747059 | (37.8017147408613, -122.407893747059) | 3 | 1 | 10 | 308 | 23 | ||||
35001 | 116817 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 4 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
35016 | 120999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
35781 | 256056 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 418 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010297 | 2120665 | 37.8035221265997 | -122.408577200527 | (37.8035221265997, -122.408577200527) | 3 | 1 | 10 | 308 | 23 | ||||
36324 | 102902 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 290 PACIFIC AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012556 | 2118523 | 37.797766966668 | -122.400609219963 | (37.797766966668, -122.400609219963) | 3 | 1 | 10 | 28860 | 6 | ||||
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 | |||||
37459 | 108582 | Undocumented 4 | Ficus laurel :: 247 | 1100x BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008279 | 2118302 | 37.7969206942597 | -122.415393214122 | (37.7969206942597, -122.415393214122) | 5 | 1 | 10 | 28858 | 21 | ||||
38688 | 113686 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
39590 | 112840 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 390X FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009568 | 2121208 | 37.8049722148904 | -122.411138326504 | (37.8049722148904, -122.411138326504) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||||
40034 | 116284 | Undocumented 4 | :: 45 | 700X Greenwich St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
41004 | 99266 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | ||||
41338 | 109613 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
41455 | 109491 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1315 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007628 | 2115744 | 37.789860448493 | -122.417464454457 | (37.789860448493, -122.417464454457) | 13 | 1 | 10 | 28858 | 21 | ||||
42180 | 114695 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
42509 | 94981 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 1088 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6007813 | 2118904 | 37.7985474336912 | -122.417048365627 | (37.7985474336912, -122.417048365627) | 5 | 1 | 10 | 308 | 32 | |||
42643 | 258040 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||||
42959 | 117474 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
43388 | 102901 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 712 BATTERY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012523 | 2118543 | 37.7978200413762 | -122.400724815577 | (37.7978200413762, -122.400724815577) | 3 | 1 | 10 | 28860 | 6 | ||||
43430 | 112751 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
43856 | 111715 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2390x MASON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
44956 | 103510 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
45331 | 107372 | Undocumented 4 | Acer palmatum :: Japanese Maple 216 | 305x GREENWICH ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 6011370 | 2120243 | 37.8024234525216 | -122.404834287898 | (37.8024234525216, -122.404834287898) | 3 | 1 | 10 | 308 | 23 | ||||
45892 | 116291 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009504.70132 | 2120333.42493 | 37.8025672995432 | -122.41129555893 | (37.8025672995432, -122.41129555893) | 3 | 1 | 10 | 308 | 23 | |||||
45998 | 112547 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 462 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011324 | 2118723 | 37.798247331278 | -122.404886391926 | (37.798247331278, -122.404886391926) | 3 | 1 | 10 | 308 | 23 | ||||
46826 | 110117 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 160x PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010076 | 2121146 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | 3 | 1 | 10 | 308 | 23 | ||||
46917 | 122714 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
47604 | 104262 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
47816 | 107839 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1000x LEAVENWORTH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | ||||
47968 | 107586 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 698 MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x5 | 6009682 | 2115721 | 37.7899126515148 | -122.410356148991 | (37.7899126515148, -122.410356148991) | 5 | 1 | 10 | 28857 | 21 | |||
47978 | 116279 | Undocumented 4 | :: 45 | 700X Greenwich St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
48219 | 122825 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 201x Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
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 | |||||
48264 | 110607 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1181 GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6007369 | 2118756 | 37.7981160762917 | -122.418574247636 | (37.7981160762917, -122.418574247636) | 5 | 1 | 10 | 28858 | 32 | ||||
48387 | 116276 | Undocumented 4 | :: 45 | 700X Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
48575 | 116363 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 100x SACRAMENTO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2016 12:00:00 AM | 3 | 3x3 | 6013491 | 2117477 | 37.7949470000015 | -122.397300449207 | (37.7949470000015, -122.397300449207) | 3 | 1 | 10 | 28860 | 6 | ||
48637 | 114696 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
48972 | 120646 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 780x Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008827 | 2115225 | 37.7885027900531 | -122.413279293156 | (37.7885027900531, -122.413279293156) | 5 | 1 | 10 | 28858 | 21 | ||||
49039 | 128383 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 109 Trenton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6010080.15671 | 2117907.34216 | 37.7959381290836 | -122.409132894969 | (37.7959381290836, -122.409132894969) | 3 | 1 | 10 | 308 | 4 | |||
49622 | 113208 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
50112 | 109625 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 312x FILBERT ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 14 | 6011362.9 | 2120079.8 | 37.801974948341 | -122.40484736081 | (37.801974948341, -122.40484736081) | 3 | 1 | 10 | 308 | 23 | ||||
50482 | 103357 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
50715 | 108646 | Undocumented 4 | Tree(s) :: 17 | 315X PACIFIC AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012408.6 | 2118423 | 37.7974841688946 | -122.401112237555 | (37.7974841688946, -122.401112237555) | 3 | 1 | 10 | 28860 | 4 | ||||
51202 | 100114 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
51701 | 98673 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
51920 | 103361 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
52074 | 117185 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011833 | 2120374 | 37.8028090150843 | -122.40324129087 | (37.8028090150843, -122.40324129087) | 3 | 1 | 10 | 308 | 23 | ||||
52365 | 115463 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 695x JONES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008737 | 2114865 | 37.787509264052 | -122.413565208574 | (37.787509264052, -122.413565208574) | 5 | 1 | 10 | 28858 | 36 | ||||
52593 | 98672 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
52599 | 108181 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 835 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010686.57825 | 2116924.79472 | 37.7932742451254 | -122.406965263124 | (37.7932742451254, -122.406965263124) | 3 | 1 | 10 | 28857 | 4 | ||||
52839 | 115077 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
52989 | 121687 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1653 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010440 | 2120221 | 37.8023110197422 | -122.408051009419 | (37.8023110197422, -122.408051009419) | 3 | 1 | 10 | 308 | 23 | ||||
53543 | 115711 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 550 NORTH POINT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008089 | 2121871 | 37.806709591959 | -122.416303574578 | (37.806709591959, -122.416303574578) | 5 | 1 | 10 | 308 | 23 | ||||
53972 | 116826 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 13 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
54265 | 110794 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 900 CALIFORNIA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009776 | 2116634 | 37.7924247975925 | -122.410095399183 | (37.7924247975925, -122.410095399183) | 5 | 1 | 10 | 28857 | 21 | ||||
54711 | 112674 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500x FILBERT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010481 | 2120003 | 37.8017147408613 | -122.407893747059 | (37.8017147408613, -122.407893747059) | 3 | 1 | 10 | 308 | 23 | ||||
55711 | 112719 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 455 BAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | ||||
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 | |||
56128 | 116290 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009504.70132 | 2120333.42493 | 37.8025672995432 | -122.41129555893 | (37.8025672995432, -122.41129555893) | 3 | 1 | 10 | 308 | 23 | |||||
56447 | 117399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
57245 | 99116 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1200x KEARNY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011163 | 2119066 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | 3 | 1 | 10 | 308 | 23 | ||||
57433 | 101617 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 896X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007773.9 | 2115454.2 | 37.7890729368167 | -122.416939111253 | (37.7890729368167, -122.416939111253) | 13 | 1 | 10 | 28858 | 21 | ||||
57700 | 113210 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
57984 | 116822 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 9 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
58098 | 112642 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 299X STOCKTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x12 | 6010693 | 2115178 | 37.7884783251045 | -122.406819877074 | (37.7884783251045, -122.406819877074) | 5 | 1 | 10 | 28852 | 6 | |||
58111 | 258045 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007719 | 2121534 | 37.805763462997 | -122.417560134413 | (37.805763462997, -122.417560134413) | 5 | 1 | 10 | 308 | 23 | ||
58440 | 112748 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 135X TRENTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
58595 | 114506 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 10 LOMBARD ST | 1 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
58800 | 108938 | Undocumented 4 | Ligustrum japonicum :: Japanese Privet 232 | 431 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010275.9 | 2120590.4 | 37.8033161117204 | -122.408644952554 | (37.8033161117204, -122.408644952554) | 3 | 1 | 10 | 308 | 23 | |||
59611 | 106127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1609 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6009609.6 | 2119208.8 | 37.7994852403002 | -122.410853080764 | (37.7994852403002, -122.410853080764) | 3 | 1 | 10 | 308 | 4 | ||||
59664 | 115245 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | 3x3 | 6009439.8 | 2118094.4 | 37.7964158497349 | -122.411361881702 | (37.7964158497349, -122.411361881702) | 3 | 1 | 10 | 308 | 4 | |||
59848 | 112528 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
59862 | 120620 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010405 | 2122056 | 37.8073475155142 | -122.408301628949 | (37.8073475155142, -122.408301628949) | 3 | 1 | 10 | 308 | 23 | ||||
60576 | 116868 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2000x JONES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008236 | 2119365 | 37.7998370108632 | -122.415617306198 | (37.7998370108632, -122.415617306198) | 5 | 1 | 10 | 308 | 32 | ||||
60634 | 113685 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
61014 | 112834 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 390X FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009568 | 2121208 | 37.8049722148904 | -122.411138326504 | (37.8049722148904, -122.411138326504) | 3 | 1 | 10 | 308 | 23 | |||
61136 | 101619 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 896X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2013 12:00:00 AM | 7 | 3x3 | Permit Number 771029 | 6007773.9 | 2115454.2 | 37.7890729368167 | -122.416939111253 | (37.7890729368167, -122.416939111253) | 13 | 1 | 10 | 28858 | 21 | |
61438 | 107905 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2650 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008717 | 2122501 | 37.8084747060674 | -122.414174852603 | (37.8084747060674, -122.414174852603) | 3 | 1 | 10 | 308 | 23 | ||||
61593 | 122835 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
61683 | 113459 | Undocumented 4 | Ficus Spp. :: 101 | 18X LEROY PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008359 | 2116564 | 37.7921530708525 | -122.414993316892 | (37.7921530708525, -122.414993316892) | 5 | 1 | 10 | 28858 | 21 | ||||
61684 | 100109 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 |
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) );