trees
39,840 rows where qLegalStatus_id = 7 sorted by DBH descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17759 | 8164 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | 15 | 5 | 11 | 29492 | 41 | |||
27711 | 3410 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6528 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5987293.52978 | 2113992.83204 | 37.7838871248275 | -122.487690236342 | (37.7838871248275, -122.487690236342) | 11 | 6 | 1 | 55 | 33 | |||
47489 | 17723 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |||
60921 | 239 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3010X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 90 | 2 | 5990623.3177 | 2095139.449 | 37.7323143965058 | -122.474793962374 | (37.7323143965058, -122.474793962374) | 1 | 8 | 4 | 64 | 40 | |||
79809 | 4593 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.404374021953 | (37.7966440043551, -122.404374021953) | 3 | 1 | 10 | 308 | 4 | |||
88572 | 3393 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6241 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5988252.22536 | 2113941.19107 | 37.7838012036794 | -122.484369756511 | (37.7838012036794, -122.484369756511) | 11 | 6 | 2 | 55 | 26 | |||
118065 | 5464 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 6 | 6004918.8923427 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | 2 | 4 | 5 | 28862 | 3 | |||
144538 | 17727 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |||
162752 | 5435 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 6 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
181464 | 11367 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1351X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679 | -122.38258247713 | (37.730452470679, -122.38258247713) | 10 | 3 | 8 | 58 | 1 | |||
866 | 28332 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3247 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 9 | 3x3 | 6006498.83651 | 2099346.51324 | 37.74477323292 | -122.420207017141 | (37.74477323292, -122.420207017141) | 2 | 7 | 7 | 28859 | 2 | ||
1331 | 25415 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
2592 | 6305 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1797X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | 9 | 3X3 | 6002532.11938 | 2112833.28187 | 37.7815803152054 | -122.434887466275 | (37.7815803152054, -122.434887466275) | 15 | 5 | 11 | 29490 | 41 | ||
3896 | 227738 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1240 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1991 12:00:00 AM | 9 | Width 4ft | Permit Number 30100 | 5997494.2501 | 2105433.95534 | 37.7609763468939 | -122.451782059502 | (37.7609763468939, -122.451782059502) | 15 | 5 | 11 | 29492 | 12 | |
4251 | 42457 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 571 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 9 | 3x3 | Permit Number 42600 | 5997658.92569742 | 2095237.95802388 | 37.7329900693173 | -122.450477464919 | (37.7329900693173, -122.450477464919) | 9 | 7 | 4 | 59 | 40 |
6368 | 142137 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3059 GEARY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997680.98 | 2113001.7737 | 37.7817663225775 | -122.451682166477 | (37.7817663225775, -122.451682166477) | 15 | 6 | 2 | 54 | 16 | |||
6645 | 226161 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32799 | 5997997.11826 | 2106529.02842 | 37.76401192934 | -122.450121798605 | (37.76401192934, -122.450121798605) | 15 | 5 | 11 | 29492 | 9 | |
11336 | 213698 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 9 | Width 2ft | Permit Number 42422 | 5999705.61228 | 2093800.4183 | 37.7291598500291 | -122.443298341854 | (37.7291598500291, -122.443298341854) | 9 | 7 | 4 | 63 | 40 | |
11779 | 44518 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 100X TOWNSEND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2001 12:00:00 AM | 9 | 3x3 | Permit Number 43820 | 6015218.7 | 2112179.2 | 37.7804964903429 | -122.390951859139 | (37.7804964903429, -122.390951859139) | 6 | 2 | 9 | 28856 | 6 | |
14831 | 195631 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 416 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 9 | Width 4ft | 6015940.74399 | 2112714.61706 | 37.782006663809 | -122.388491328916 | (37.782006663809, -122.388491328916) | 6 | 2 | 9 | 28856 | 6 | ||
15615 | 94975 | Permitted Site 7 | Tree(s) :: 17 | 2040@Jackson Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2010 12:00:00 AM | 9 | 3x3 | Permit Number 54005 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |
16268 | 3823 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2001 12:00:00 AM | 9 | 3X3 | 6017067.4579304 | 2095837.0108628 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | 10 | 3 | 8 | 58 | 1 | ||
17971 | 221104 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 2815 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 779645 | 6009432.49535 | 2105438.1168 | 37.761664278799 | -122.410493008061 | (37.761664278799, -122.410493008061) | 2 | 4 | 7 | 28859 | 19 | ||
20441 | 9592 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1321 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6003210.81431 | 2112031.15046 | 37.7794163737998 | -122.432482197381 | (37.7794163737998, -122.432482197381) | 15 | 9 | 11 | 29490 | 41 | |||
20892 | 98486 | Permitted Site 7 | Casurina stricta :: Beefwood: Drooping She-Oak 173 | 531X Franconia St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | 10 | 7 | 7 | 28859 | 2 | |||
22772 | 95335 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 855 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2011 12:00:00 AM | 9 | 4x4 | Permit Number 767214 | 6012385 | 2119009 | 37.7990918675768 | -122.401235100386 | (37.7990918675768, -122.401235100386) | 3 | 1 | 10 | 28860 | 6 | |
23984 | 12171 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1421X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
25483 | 56043 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4129 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 9 | 3x3 | Permit Number 12130 | 6002248.77832892 | 2105270.36244465 | 37.7607983186187 | -122.435326543463 | (37.7607983186187, -122.435326543463) | 2 | 4 | 5 | 28862 | 3 | |
25486 | 24126 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 140X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1997 12:00:00 AM | 9 | 3X3 | 6016343.6401634 | 2095980.6654178 | 37.7360811036021 | -122.385930671948 | (37.7360811036021, -122.385930671948) | 10 | 3 | 8 | 58 | 1 | ||
26047 | 2600 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1755 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6005137.68077 | 2115060.19605 | 37.7878424598464 | -122.426032037994 | (37.7878424598464, -122.426032037994) | 13 | 9 | 11 | 28858 | 27 | |||
28859 | 91843 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 9 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
30958 | 104965 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3660 21ST ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 3x4 | Permit Number 770773 | 6003991.2 | 2103675.5 | 37.7565180033839 | -122.429186559891 | (37.7565180033839, -122.429186559891) | 2 | 4 | 5 | 28862 | 3 | ||
31790 | 93029 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 45 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5x6 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
33856 | 40850 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 317 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/1999 12:00:00 AM | 9 | Permit Number 41775 | 6004382 | 2098874 | 37.7433563163767 | -122.427492980249 | (37.7433563163767, -122.427492980249) | 2 | 7 | 5 | 63 | 22 | ||
35988 | 17646 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
36604 | 35871 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 50 Dorman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39081 | 6011337.7 | 2097400.6 | 37.7397016379903 | -122.403338190355 | (37.7397016379903, -122.403338190355) | 10 | 3 | 8 | 58 | 1 | |
37239 | 26550 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2771 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1997 12:00:00 AM | 9 | 3x3 | 6009840.2362842 | 2101212.306322 | 37.7500840001704 | -122.408784649554 | (37.7500840001704, -122.408784649554) | 2 | 4 | 7 | 28859 | 19 | ||
38534 | 91845 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 9 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
41370 | 108354 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 140 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 9x5 | 6004696.1 | 2095922.4 | 37.735269652849 | -122.426196812164 | (37.735269652849, -122.426196812164) | 2 | 7 | 5 | 28861 | 2 | |||
44790 | 3854 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 201X Cashmere St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2000 12:00:00 AM | 9 | 3X3 | 6016272.1162427 | 2096165.2075517 | 37.7365838606598 | -122.386190822782 | (37.7365838606598, -122.386190822782) | 10 | 3 | 8 | 58 | 1 | ||
47226 | 94411 | Permitted Site 7 | Tree(s) :: 17 | 905 California St | 1 | Front Yard : Yard | Tree | Private 2 | 07/27/2010 12:00:00 AM | 9 | Permit Number 53651 | 6010018 | 2116471 | 37.7919908000075 | -122.409246561226 | (37.7919908000075, -122.409246561226) | 5 | 1 | 10 | 28857 | 21 | ||
48063 | 35872 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 50 Dorman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39081 | 6011337.7 | 2097400.6 | 37.7397016379903 | -122.403338190355 | (37.7397016379903, -122.403338190355) | 10 | 3 | 8 | 58 | 1 | |
52020 | 93035 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3081 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 53145 | 6007764.8 | 2103179.8 | 37.7553698250409 | -122.416100967215 | (37.7553698250409, -122.416100967215) | 2 | 4 | 7 | 28859 | 19 | ||
52406 | 34551 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 3662 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | 9 | 3x2 | Permit Number 778622 | 6008447.76168785 | 2097836.53869706 | 37.7407367985354 | -122.413361219105 | (37.7407367985354, -122.413361219105) | 2 | 7 | 7 | 28859 | 2 |
53284 | 68192 | Permitted Site 7 | Tree(s) :: 17 | 2476 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 9 | 4x4 | Permit Number 31969 | 6002343.73518998 | 2116771.69418911 | 37.7923834925263 | -122.435821060136 | (37.7923834925263, -122.435821060136) | 13 | 9 | 1 | 29490 | 27 | |
57446 | 94626 | Permitted Site 7 | Alnus rhombifolia :: White Alder 327 | 1740 Bancroft Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/13/2010 12:00:00 AM | 9 | permit 53777 | 6014054 | 2092727 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | 10 | 3 | 8 | 58 | 1 | ||
58333 | 94618 | Permitted Site 7 | Alnus rhombifolia :: White Alder 327 | 1780 Bancroft Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/13/2010 12:00:00 AM | 9 | Permit Number 53777 | 6014054 | 2092727 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | 10 | 3 | 8 | 58 | 1 | ||
60737 | 52317 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4000 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48473 | 6003124.28187009 | 2102445.67821433 | 37.7530920905977 | -122.432096848701 | (37.7530920905977, -122.432096848701) | 2 | 4 | 5 | 28862 | 22 |
61546 | 52316 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4000 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48473 | 6003124.28187009 | 2102445.67821433 | 37.7530920905977 | -122.432096848701 | (37.7530920905977, -122.432096848701) | 2 | 4 | 5 | 28862 | 22 |
62141 | 24103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 105X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | |||
65164 | 52301 | Permitted Site 7 | Tree(s) :: 17 | 40 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/2013 12:00:00 AM | 9 | 3x3 | Permit Number 769780 | 6001665.92153751 | 2105591.90634568 | 37.7616480821365 | -122.437365407078 | (37.7616480821365, -122.437365407078) | 15 | 4 | 5 | 28862 | 3 |
66008 | 33700 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 117 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 9 | 3x3 | Permit Number 37769 | 6003661.70880782 | 2108800.16267952 | 37.7705704357115 | -122.430691738532 | (37.7705704357115, -122.430691738532) | 15 | 9 | 11 | 29492 | 10 | |
66492 | 92997 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | |||
67174 | 55716 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 21 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1973 12:00:00 AM | 9 | Permit Number 11739 | 6003173.21093574 | 2108192.12720252 | 37.7688732316917 | -122.432338023395 | (37.7688732316917, -122.432338023395) | 15 | 5 | 5 | 28862 | 3 | ||
69020 | 32189 | Permitted Site 7 | Tilia americana :: Basswood Linden 340 | 202 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1995 12:00:00 AM | 9 | 5x4.5 | Permit Number 35519; tree 1 on 23rd St | 6005403.8885181 | 2102517.95327516 | 37.7534195205124 | -122.424218652968 | (37.7534195205124, -122.424218652968) | 2 | 4 | 5 | 28859 | 19 | |
70947 | 65850 | Permitted Site 7 | Tree(s) :: 17 | 67 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 9 | 3x3 | Permit Number 770220 | 6001319.42927239 | 2121416.09155385 | 37.8050775459314 | -122.439698294296 | (37.8050775459314, -122.439698294296) | 13 | 9 | 1 | 57 | 17 |
72681 | 2587 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1525X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6005364.20078 | 2114992.96648 | 37.7876706638403 | -122.425243534375 | (37.7876706638403, -122.425243534375) | 13 | 9 | 11 | 28858 | 27 | |||
72955 | 58877 | Permitted Site 7 | Tree(s) :: 17 | 1154 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1980 12:00:00 AM | 9 | 3X3 | Permit Number 18141 | 5997384.83884567 | 2106256.4478798 | 37.7632284362662 | -122.452219811916 | (37.7632284362662, -122.452219811916) | 15 | 5 | 11 | 29492 | 9 | |
72985 | 21790 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6008342.51156 | 2121554.8602 | 37.8058558040212 | -122.415403850799 | (37.8058558040212, -122.415403850799) | 5 | 1 | 10 | 308 | 23 | |||
74834 | 35873 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 50 Dorman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39081 | 6011337.7 | 2097400.6 | 37.7397016379903 | -122.403338190355 | (37.7397016379903, -122.403338190355) | 10 | 3 | 8 | 58 | 1 | |
75159 | 86806 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 700X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
77311 | 103001 | Permitted Site 7 | Tree(s) :: 17 | 2476 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | 6002511 | 2116788 | 37.7924377640017 | -122.435243487202 | (37.7924377640017, -122.435243487202) | 13 | 9 | 1 | 29490 | 27 | |||
79754 | 86812 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 700X Phelps St | 7 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/26/2012 02:00:00 PM | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | ||
80353 | 39179 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1050 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | 9 | Permit Number 40838 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | 2 | 4 | 7 | 28859 | 19 | ||
81401 | 39297 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 399X Treat Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) | 8 | 4 | 7 | 28859 | 19 |
87151 | 85215 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 333 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005846.90542 | 2110665.07775 | 37.7758146007875 | -122.423265700534 | (37.7758146007875, -122.423265700534) | 7 | 9 | 11 | 28852 | 10 | |||
88800 | 95347 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 855 Battery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2011 12:00:00 AM | 9 | 4x4 | Permit Number 767214 | 6012385 | 2119009 | 37.7990918675768 | -122.401235100386 | (37.7990918675768, -122.401235100386) | 3 | 1 | 10 | 28860 | 6 | |
88809 | 210161 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 28 Williar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2001 12:00:00 AM | 9 | Width 3ft | Permit Number 43988 | 5997155.78029 | 2090782.22687 | 37.7207268766131 | -122.451895623196 | (37.7207268766131, -122.451895623196) | 9 | 8 | 6 | 28861 | 24 | |
90967 | 33602 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 200X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | 9 | Permit Number 37716 | 6006727.64769195 | 2098397.31693347 | 37.7421798430719 | -122.419348506645 | (37.7421798430719, -122.419348506645) | 2 | 7 | 7 | 28859 | 2 | ||
91549 | 12624 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 830 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 5992912.47098 | 2114850.62826 | 37.7865685263306 | -122.468313373633 | (37.7865685263306, -122.468313373633) | 11 | 6 | 1 | 54 | 11 | |||
94033 | 12170 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1421X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
99658 | 140590 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1277 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003057.8563 | 2111669.9722 | 37.7784159935792 | -122.43298553198 | (37.7784159935792, -122.43298553198) | 15 | 9 | 11 | 29492 | 41 | |||
100682 | 93045 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 487 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 53148 | 5998548 | 2106357 | 37.7635710908608 | -122.448204081475 | (37.7635710908608, -122.448204081475) | 15 | 5 | 11 | 29492 | 9 | ||
101295 | 29407 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2801X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6014804.18454 | 2090650.03815 | 37.7213589569903 | -122.390880803843 | (37.7213589569903, -122.390880803843) | 10 | 3 | 8 | 58 | 1 | |||
103946 | 103373 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 301 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 10432 | 5994853 | 2107015 | 37.7651658603244 | -122.461031523433 | (37.7651658603244, -122.461031523433) | 15 | 5 | 11 | 56 | 12 | ||
107212 | 49183 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1699X Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | 9 | 3x3 | Permit Number 46290 | 6015935.13709269 | 2101624.6873782 | 37.7515558114733 | -122.387736718976 | (37.7515558114733, -122.387736718976) | 10 | 3 | 8 | 28856 | 1 | |
109862 | 40839 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1100X HOWARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 9 | Permit Number 47707 | 6009782.3 | 2111346.9 | 37.7779080366251 | -122.409700249447 | (37.7779080366251, -122.409700249447) | 8 | 2 | 9 | 28853 | 34 | |
110259 | 5246 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1101X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1990 12:00:00 AM | 9 | 3X3 | 6001386.14183 | 2112156.35865 | 37.7796565242703 | -122.438803470391 | (37.7796565242703, -122.438803470391) | 15 | 5 | 11 | 29490 | 41 | ||
113239 | 93119 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000421 | 2110261 | 37.774397395284 | -122.442006222093 | (37.774397395284, -122.442006222093) | 15 | 5 | 11 | 29492 | 16 | |||
115678 | 24138 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 120X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1997 12:00:00 AM | 9 | 3x3 | 6016341.4043773 | 2096017.7564546 | 37.7361828243942 | -122.385940986699 | (37.7361828243942, -122.385940986699) | 10 | 3 | 8 | 58 | 1 | ||
117088 | 42651 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1924 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 9 | Permit Number 42691 | 6004339.89147 | 2118073.88126 | 37.7960721541703 | -122.429007191848 | (37.7960721541703, -122.429007191848) | 13 | 9 | 1 | 57 | 17 | |
118862 | 3853 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 201X Cashmere St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1992 12:00:00 AM | 9 | 3X3 | 6016272.1162427 | 2096165.2075517 | 37.7365838606598 | -122.386190822782 | (37.7365838606598, -122.386190822782) | 10 | 3 | 8 | 58 | 1 | ||
121866 | 93030 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 45 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
123587 | 9877 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1511 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | 6005349.97627 | 2114990.72408 | 37.7876637031607 | -122.425292588834 | (37.7876637031607, -122.425292588834) | 13 | 9 | 11 | 28858 | 27 | |||
125838 | 43565 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 527 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 9 | 3x3 | Permit Number 43226 | 6003161.6606046 | 2098886.62601348 | 37.743321886148 | -122.431713499297 | (37.743321886148, -122.431713499297) | 2 | 7 | 5 | 63 | 22 |
129763 | 35874 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 50 Dorman Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39081 | 6011337.7 | 2097400.6 | 37.7397016379903 | -122.403338190355 | (37.7397016379903, -122.403338190355) | 10 | 3 | 8 | 58 | 1 | |
133340 | 94625 | Permitted Site 7 | Alnus rhombifolia :: White Alder 327 | 1740 Bancroft Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/13/2010 12:00:00 AM | 9 | Permit Number 53777 | 6014054 | 2092727 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | 10 | 3 | 8 | 58 | 1 | ||
136501 | 2322 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2290 BRYANT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1996 12:00:00 AM | 9 | 3X3 | 6009654 | 2104017 | 37.7577746290621 | -122.409626602343 | (37.7577746290621, -122.409626602343) | 2 | 4 | 7 | 28859 | 19 | ||
137078 | 66676 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Elgin Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1991 12:00:00 AM | 9 | 3x3 | Permit Number 29900 | 6005854.87784236 | 2108623.50205375 | 37.7702093754743 | -122.423092976437 | (37.7702093754743, -122.423092976437) | 8 | 2 | 5 | 28853 | 19 |
140271 | 24087 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 141X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2000 12:00:00 AM | 9 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.385758322913 | (37.7360921261264, -122.385758322913) | 10 | 3 | 8 | 58 | 1 | ||
144388 | 3856 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 201X Cashmere St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2001 12:00:00 AM | 9 | 3X3 | 6016272.1162427 | 2096165.2075517 | 37.7365838606598 | -122.386190822782 | (37.7365838606598, -122.386190822782) | 10 | 3 | 8 | 58 | 1 | ||
145757 | 3813 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1995 12:00:00 AM | 9 | 3X3 | 6017067.4579304 | 2095837.0108628 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | 10 | 3 | 8 | 58 | 1 | ||
145760 | 26041 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 32 Broad St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/1997 12:00:00 AM | 9 | 3X3 | 5996239.04821 | 2088090.40121 | 37.7132832040965 | -122.454870071763 | (37.7132832040965, -122.454870071763) | 9 | 8 | 6 | 28861 | 24 | ||
146440 | 3818 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2001 12:00:00 AM | 9 | 3X3 | 6017067.4579304 | 2095837.0108628 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | 10 | 3 | 8 | 58 | 1 | ||
149999 | 9201 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6207 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 5987756.08528 | 2112469.4322 | 37.7797312691594 | -122.485978126746 | (37.7797312691594, -122.485978126746) | 11 | 6 | 2 | 55 | 26 | |||
156466 | 175424 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 231 Craut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2011 12:00:00 AM | 9 | Width 3ft | Permit Number 767516 | 6004062.42571 | 2093793.74481 | 37.7293890071806 | -122.428235998911 | (37.7293890071806, -122.428235998911) | 9 | 7 | 6 | 28861 | 5 | |
157142 | 51015 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 168 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48063 | 6005440.48678199 | 2099065.68713562 | 37.7439424571986 | -122.423846627927 | (37.7439424571986, -122.423846627927) | 2 | 7 | 5 | 28859 | 22 | |
160858 | 8783 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3540 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 5996078.91565 | 2112921.97286 | 37.781455330757 | -122.457218749012 | (37.781455330757, -122.457218749012) | 11 | 6 | 1 | 54 | 31 | |||
161598 | 63432 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 127 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1987 12:00:00 AM | 9 | Permit Number 24018 | 6005906.17265772 | 2095879.01582361 | 37.7352188514571 | -122.422010059455 | (37.7352188514571, -122.422010059455) | 2 | 7 | 7 | 28859 | 2 | ||
162107 | 124114 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5993989.05364 | 2112856.58401 | 37.7811555438317 | -122.464443855733 | (37.7811555438317, -122.464443855733) | 11 | 6 | 2 | 54 | 11 |
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) );