trees
8,298 rows where qLegalStatus_id = 4 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84059 | 92924 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2725X 14th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | tree 4 on 14th st | 5992210 | 2097192 | 37.7380420035645 | -122.46945784276 | (37.7380420035645, -122.46945784276) | 1 | 8 | 4 | 59 | 40 | ||
43218 | 92923 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2725X 14th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | tree 3 on 14th st | 5992210 | 2097192 | 37.7380420035645 | -122.46945784276 | (37.7380420035645, -122.46945784276) | 1 | 8 | 4 | 59 | 40 | ||
58117 | 92926 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 398 West Portal Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | tree 2 on 15th st | 5991862 | 2096794 | 37.7369290786614 | -122.470632059845 | (37.7369290786614, -122.470632059845) | 1 | 8 | 4 | 59 | 40 | |||
168425 | 92922 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2725X 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | tree 2 on 14th st. | 5992210 | 2097192 | 37.7380420035645 | -122.46945784276 | (37.7380420035645, -122.46945784276) | 1 | 8 | 4 | 59 | 40 | ||
39520 | 92928 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 301 West Portal Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | tree 2 on 14th st | 5992361 | 2097058 | 37.7376827987343 | -122.468926016741 | (37.7376827987343, -122.468926016741) | 1 | 8 | 4 | 59 | 40 | |||
21923 | 92943 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2800X 15TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | tree 1 on 15th st | 5991935 | 2096694 | 37.7366587249535 | -122.470372388311 | (37.7366587249535, -122.470372388311) | 1 | 8 | 4 | 59 | 40 | |||
50584 | 92925 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 398 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | tree 1 on 15th st | 5991862 | 2096794 | 37.7369290786614 | -122.470632059845 | (37.7369290786614, -122.470632059845) | 1 | 8 | 4 | 59 | 40 | |||
50435 | 92921 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2725X 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | tree 1 on 14th st. | 5992210 | 2097192 | 37.7380420035645 | -122.46945784276 | (37.7380420035645, -122.46945784276) | 1 | 8 | 4 | 59 | 40 | ||
164411 | 92927 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 301 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | tree 1 on 14th st | 5992361 | 2097058 | 37.7376827987343 | -122.468926016741 | (37.7376827987343, -122.468926016741) | 1 | 8 | 4 | 59 | 40 | |||
147160 | 99960 | Undocumented 4 | Ulmus americana :: American Elm 74 | 279 Filbert St | 1 | Unaccepted Street : Yard | Tree | Private 2 | shared responsibility with 1400 Montgomery | 6011546.2 | 2120046.5 | 37.8018937585678 | -122.40421070766 | (37.8018937585678, -122.40421070766) | 3 | 1 | 10 | 308 | 23 | ||||
171514 | 115762 | Undocumented 4 | :: 45 | 84X Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | on Athens Street frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | |||
192835 | 115870 | Undocumented 4 | :: 45 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
189112 | 115869 | Undocumented 4 | :: 45 | 84X Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
133702 | 104938 | Undocumented 4 | Privet :: 212 | 101 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | missing? | 5990474.7 | 2090014.4 | 37.7182336817112 | -122.474933796522 | (37.7182336817112, -122.474933796522) | 1 | 8 | 4 | 64 | 14 | ||||
145777 | 104922 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 3 | Median : Yard | Tree | Private 2 | missing? | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | ||||
57332 | 104890 | Undocumented 4 | :: 45 | 150 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | empty | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | ||||
140446 | 104738 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 200X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree on the 23rd St side of property | 6005413 | 2102541 | 37.753483315938 | -122.424188782445 | (37.753483315938, -122.424188782445) | 2 | 4 | 5 | 28859 | 19 | ||||
127997 | 92908 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 802 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Tree no. 2 on Jackson St. | 6011726 | 2118056 | 37.7964383722538 | -122.403448393826 | (37.7964383722538, -122.403448393826) | 3 | 1 | 10 | 28860 | 4 | ||
81460 | 99821 | Undocumented 4 | Salix spp :: Willow 203 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 11 | Tree closest to sidewalk and retaining wall | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
59195 | 93735 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 201@ Page Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on Page St. | 5999812.1 | 2109210.9 | 37.7714793693282 | -122.44403704657 | (37.7714793693282, -122.44403704657) | 15 | 5 | 11 | 29492 | 9 | ||||
123948 | 75029 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
132603 | 74892 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
191057 | 100769 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 3701 21st St | Front Yard : Yard | Tree | Private 2 | 55 | Street tree w/in RoW | 6003717 | 2103606 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | 2 | 4 | 5 | 28862 | 22 | ||||
83914 | 99756 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 517 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Probably planted at same time/permitted with tree no. 1 | 6001837 | 2100870 | 37.7486925868246 | -122.436435749617 | (37.7486925868246, -122.436435749617) | 2 | 4 | 5 | 28862 | 22 | |||
8683 | 99744 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 431 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Probably planted at same time as tree no. 1 w/same permit. CB | 6002387 | 2100900 | 37.7488061968535 | -122.43453600134 | (37.7488061968535, -122.43453600134) | 2 | 4 | 5 | 28862 | 22 | |||
70430 | 142788 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | 7 | 9 | 9 | 28858 | 36 | ||
78904 | 98227 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 207 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Planted without permit; 2' away from sewer line. | 6007132 | 2097003 | 37.7383741239705 | -122.417851565085 | (37.7383741239705, -122.417851565085) | 2 | 7 | 7 | 28859 | 2 | |||
178575 | 96914 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 4396X 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | 3x3 | Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. | 6000641.3 | 2102303.1 | 37.7525595190983 | -122.440673239158 | (37.7525595190983, -122.440673239158) | 2 | 4 | 5 | 28862 | 22 | |
3790 | 262255 | Undocumented 4 | Tree(s) :: 17 | 4210 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
63852 | 254397 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 317X Dorado Ter | 1 | Side Yard : Yard | Tree | Private 2 | 01/09/2019 12:00:00 AM | 3 | 3x6 | Permit Number 782774 | 5994307 | 2093018 | 37.7267021901994 | -122.461904942649 | (37.7267021901994, -122.461904942649) | 9 | 8 | 4 | 28861 | 40 | |
107023 | 254398 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 317X Dorado Ter | 2 | Side Yard : Yard | Tree | Private 2 | 01/09/2019 12:00:00 AM | 3 | 3x6 | Permit Number 782774 | 5994307 | 2093018 | 37.7267021901994 | -122.461904942649 | (37.7267021901994, -122.461904942649) | 9 | 8 | 4 | 28861 | 40 | |
185777 | 254399 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 317X Dorado Ter | 3 | Side Yard : Yard | Tree | Private 2 | 01/09/2019 12:00:00 AM | 3 | 3x6 | Permit Number 782774 | 5994307 | 2093018 | 37.7267021901994 | -122.461904942649 | (37.7267021901994, -122.461904942649) | 9 | 8 | 4 | 28861 | 40 | |
2230 | 256764 | Undocumented 4 | Tree(s) :: 17 | 25 Serrano Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/25/2019 12:00:00 AM | 3 | 6x6 | Permit Number 782398 | 5990027 | 2090605 | 37.7198293671123 | -122.476524410241 | (37.7198293671123, -122.476524410241) | 1 | 8 | 4 | 64 | 14 | |
142370 | 231440 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101x Portola Dr | 3 | Median : Cutout | Tree | Private 2 | 27 | Width 5ft | Permit Number 782331 | 5999772.05051 | 2101277.39678 | 37.7496936476461 | -122.44360556645 | (37.7496936476461, -122.44360556645) | 2 | 4 | 5 | 28862 | 38 | ||
40027 | 255997 | Undocumented 4 | Tree(s) :: 17 | 119 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782200 | 5989797 | 2090440 | 37.7193629757475 | -122.477307378715 | (37.7193629757475, -122.477307378715) | 1 | 8 | 4 | 64 | 14 | |
149695 | 255521 | Undocumented 4 | Pinus thunbergii :: Japanese Black Pine 207 | 2061 10th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 781979 | 5993167.34823 | 2101456.73677 | 37.7498071704373 | -122.466457721745 | (37.7498071704373, -122.466457721745) | 1 | 8 | 4 | 29491 | 12 | |||
23240 | 255713 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 618x Mendell St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 | |||
120683 | 255712 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 618x Mendell St | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 | |||
129496 | 255714 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 618x Mendell St | 9 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016376 | 2097269 | 37.7396204009215 | -122.385908564927 | (37.7396204009215, -122.385908564927) | 10 | 3 | 8 | 58 | 1 | |||
173722 | 250672 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781557 | 5986349.68151 | 2114864.86182 | 37.7862263710027 | -122.491019750162 | (37.7862263710027, -122.491019750162) | 11 | 6 | 1 | 55 | 33 | |
141714 | 254548 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 52 Tamalpais Ter | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 781454 | 5998542 | 2111499 | 37.7776893687507 | -122.448595189071 | (37.7776893687507, -122.448595189071) | 15 | 6 | 2 | 54 | 16 | |||
111371 | 255520 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 77 Belgrave Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | ||||
16477 | 224849 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 779889 | 6003244.13534 | 2095137.54828 | 37.7330324530887 | -122.431160782146 | (37.7330324530887, -122.431160782146) | 9 | 7 | 5 | 28861 | 25 | ||
93121 | 122374 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779511 | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
64237 | 114607 | Undocumented 4 | Tree(s) :: 17 | 2399X 15TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | Permit Number 779471 | 5991654 | 2099150 | 37.7433860243849 | -122.471522828523 | (37.7433860243849, -122.471522828523) | 1 | 8 | 4 | 29491 | 40 | |||
177645 | 121761 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779456 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |
28786 | 121671 | Undocumented 4 | Tree(s) :: 17 | 2 Edgehill Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779402 | 5994953 | 2099187 | 37.7436779193362 | -122.460118487781 | (37.7436779193362, -122.460118487781) | 1 | 8 | 4 | 59 | 40 | |
88003 | 121672 | Undocumented 4 | Tree(s) :: 17 | 2 Edgehill Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779402 | 5994953 | 2099187 | 37.7436779193362 | -122.460118487781 | (37.7436779193362, -122.460118487781) | 1 | 8 | 4 | 59 | 40 | |
97896 | 121674 | Undocumented 4 | Tree(s) :: 17 | 2 Edgehill Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779402 | 5994953 | 2099187 | 37.7436779193362 | -122.460118487781 | (37.7436779193362, -122.460118487781) | 1 | 8 | 4 | 59 | 40 | |
159320 | 121673 | Undocumented 4 | Tree(s) :: 17 | 2 Edgehill Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779402 | 5994953 | 2099187 | 37.7436779193362 | -122.460118487781 | (37.7436779193362, -122.460118487781) | 1 | 8 | 4 | 59 | 40 | |
75337 | 122556 | Undocumented 4 | Tree(s) :: 17 | 1801x Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779391 | 6002089 | 2098776 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | 2 | 7 | 5 | 63 | 7 | |
64613 | 111400 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 5 | Median : Yard | Tree | Private 2 | 54 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
92974 | 111398 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 3 | Median : Yard | Tree | Private 2 | 4 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
114181 | 111397 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 2 | Median : Yard | Tree | Private 2 | 36 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
119676 | 111396 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 1 | Median : Yard | Tree | Private 2 | 53 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
145621 | 111399 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 4 | Median : Yard | Tree | Private 2 | 48 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
163373 | 109096 | Undocumented 4 | Tree(s) :: 17 | 194 FARALLONES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779352 | 5995118.3 | 2088431.1 | 37.71415432875 | -122.458768388595 | (37.71415432875, -122.458768388595) | 9 | 8 | 6 | 28861 | 24 | |
105272 | 115099 | Undocumented 4 | Tree(s) :: 17 | 1061X PACHECO ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/16/2017 12:00:00 AM | 3 | 3x10 | Permit Number 779333 | 5991641 | 2102174 | 37.7516883950984 | -122.471788116316 | (37.7516883950984, -122.471788116316) | 1 | 8 | 4 | 29491 | 12 | |
81282 | 122386 | Undocumented 4 | Tree(s) :: 17 | 198 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779324 | 5994732 | 2099337 | 37.7440770679838 | -122.460893516037 | (37.7440770679838, -122.460893516037) | 1 | 8 | 4 | 59 | 40 | |
116762 | 122388 | Undocumented 4 | Tree(s) :: 17 | 150X Garcia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779324 | 5994732 | 2099337 | 37.7440770679838 | -122.460893516037 | (37.7440770679838, -122.460893516037) | 1 | 8 | 4 | 59 | 40 | |
117633 | 122387 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779324 | 5994732 | 2099337 | 37.7440770679838 | -122.460893516037 | (37.7440770679838, -122.460893516037) | 1 | 8 | 4 | 59 | 40 | |||
103278 | 121623 | Undocumented 4 | Tree(s) :: 17 | 298X Staples Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779293 | 5998141 | 2093851 | 37.7292093905587 | -122.448710954214 | (37.7292093905587, -122.448710954214) | 9 | 7 | 4 | 28861 | 40 | |
9687 | 121554 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 330 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 779292 | 6001441 | 2103840 | 37.7568249841019 | -122.438017823933 | (37.7568249841019, -122.438017823933) | 2 | 4 | 5 | 28862 | 3 | ||
180932 | 121557 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 421 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779269 | 6003622 | 2102696 | 37.7538076209017 | -122.430393500907 | (37.7538076209017, -122.430393500907) | 2 | 4 | 5 | 28862 | 22 | |
193813 | 121556 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 421 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 779269 | 6003622 | 2102696 | 37.7538076209017 | -122.430393500907 | (37.7538076209017, -122.430393500907) | 2 | 4 | 5 | 28862 | 22 | ||
5267 | 121644 | Undocumented 4 | Tree(s) :: 17 | 362 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2016 12:00:00 AM | 3 | 2x4 | Permit Number 779268 | 5997955 | 2098188 | 37.741107118117 | -122.449666371295 | (37.741107118117, -122.449666371295) | 9 | 7 | 4 | 59 | 40 | |
190196 | 101232 | Undocumented 4 | Tree(s) :: 17 | 3575 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779254 | 5997770 | 2115107 | 37.7875518165957 | -122.451526095937 | (37.7875518165957, -122.451526095937) | 11 | 6 | 1 | 54 | 31 | |
59845 | 121650 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 90 Fernwood Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2017 12:00:00 AM | 3 | 2x2 | Permit Number 779248 | 5994730 | 2095273 | 37.7329182144954 | -122.46060599284 | (37.7329182144954, -122.46060599284) | 9 | 8 | 4 | 59 | 40 | |
53811 | 121152 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 4300 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779217 | 6001168 | 2102360 | 37.7527457326892 | -122.438855901364 | (37.7527457326892, -122.438855901364) | 2 | 4 | 5 | 28862 | 22 | |
87130 | 122739 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 4300 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779217 | 6001168 | 2102360 | 37.7527457326892 | -122.438855901364 | (37.7527457326892, -122.438855901364) | 2 | 4 | 5 | 28862 | 22 | |
146860 | 122740 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 4300 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779217 | 6001168 | 2102360 | 37.7527457326892 | -122.438855901364 | (37.7527457326892, -122.438855901364) | 2 | 4 | 5 | 28862 | 22 | |
52148 | 121580 | Undocumented 4 | Tree(s) :: 17 | 3595 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 5x6 | Permit Number 779170 | 6004440 | 2103609 | 37.7563608063483 | -122.427629711642 | (37.7563608063483, -122.427629711642) | 2 | 4 | 5 | 28862 | 22 | |
37063 | 212059 | Undocumented 4 | Tree(s) :: 17 | 125 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/08/2019 12:00:00 AM | 3 | Width 6ft | Permit Number 779144 | 5994018.1401 | 2096987.89262 | 37.7375859049576 | -122.463191447135 | (37.7375859049576, -122.463191447135) | 9 | 8 | 4 | 59 | 40 | |
143633 | 121421 | Undocumented 4 | Tree(s) :: 17 | 301 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2016 12:00:00 AM | 3 | Permit Number 779128 | 6001229.40575975 | 2096509.00524046 | 37.7366837791531 | -122.438224431893 | (37.7366837791531, -122.438224431893) | 2 | 7 | 5 | 63 | 7 | |
115656 | 121604 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 132 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002211 | 2096230 | 37.7359734746513 | -122.434810693949 | (37.7359734746513, -122.434810693949) | 2 | 7 | 5 | 63 | 7 | |
19641 | 121627 | Undocumented 4 | Tree(s) :: 17 | 1706 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779124 | 6009277 | 2099394 | 37.7450597695073 | -122.410603971932 | (37.7450597695073, -122.410603971932) | 2 | 7 | 7 | 28859 | 2 | |
4766 | 121797 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 310 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779075 | 6004274 | 2096577 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | 2 | 7 | 5 | 63 | 7 | |
22887 | 121796 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 305 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 779075 | 6004274 | 2096577 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | 2 | 7 | 5 | 63 | 7 | ||
115327 | 121799 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 310 Miguel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779075 | 6004274 | 2096577 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | 2 | 7 | 5 | 63 | 7 | |
168718 | 121567 | Undocumented 4 | Tree(s) :: 17 | 499X Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779059 | 5998083 | 2114873 | 37.7869272334312 | -122.450426308155 | (37.7869272334312, -122.450426308155) | 11 | 6 | 1 | 54 | 31 | |
25361 | 113722 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 57 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 779057 | 5994581 | 2092950 | 37.7265312490745 | -122.460952813642 | (37.7265312490745, -122.460952813642) | 9 | 8 | 4 | 28861 | 40 | ||
44100 | 115215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | |
140034 | 95413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523 | 2095666 | 37.7344425689427 | -122.433691689524 | (37.7344425689427, -122.433691689524) | 2 | 7 | 5 | 63 | 7 | |
136720 | 121400 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 3998X 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003912 | 2101337 | 37.7500925484643 | -122.429293713772 | (37.7500925484643, -122.429293713772) | 2 | 4 | 5 | 28862 | 22 | |
163662 | 121401 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 3998X 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003912 | 2101337 | 37.7500925484643 | -122.429293713772 | (37.7500925484643, -122.429293713772) | 2 | 4 | 5 | 28862 | 22 | |
49635 | 121237 | Undocumented 4 | Tree(s) :: 17 | 3512 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779014 | 6004884 | 2103735 | 37.7567318772846 | -122.42610317358 | (37.7567318772846, -122.42610317358) | 2 | 4 | 5 | 28862 | 3 | |
142546 | 121226 | Undocumented 4 | Tree(s) :: 17 | 485 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778977 | 5995193 | 2098174 | 37.7409102741074 | -122.4592152915 | (37.7409102741074, -122.4592152915) | 1 | 8 | 4 | 59 | 40 | |
25456 | 102816 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
43634 | 102815 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
84396 | 102817 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
118132 | 114815 | Undocumented 4 | Tree(s) :: 17 | 160 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/08/2016 12:00:00 AM | 3 | 4x15 | Permit Number 778944 | 5995496 | 2095622 | 37.7339205232551 | -122.457982998117 | (37.7339205232551, -122.457982998117) | 9 | 7 | 4 | 59 | 40 | |
121133 | 121467 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778925 | 6002578 | 2096112 | 37.735670303373 | -122.4335333993 | (37.735670303373, -122.4335333993) | 2 | 7 | 5 | 63 | 7 | ||
88661 | 122385 | Undocumented 4 | Tree(s) :: 17 | 1642 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 778904 | 5990935 | 2104213 | 37.7572460781285 | -122.474378311379 | (37.7572460781285, -122.474378311379) | 1 | 8 | 4 | 56 | 12 | ||
121 | 120916 | Undocumented 4 | Tree(s) :: 17 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778800 | 5990886 | 2105639 | 37.7611586563939 | -122.474651843595 | (37.7611586563939, -122.474651843595) | 1 | 8 | 4 | 56 | 12 | |
14571 | 205488 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 19 | Width 3ft | Permit Number 778800 | 5990862.44739 | 2105654.74875 | 37.761200533507 | -122.474734450646 | (37.761200533507, -122.474734450646) | 1 | 8 | 4 | 56 | 12 | |
167071 | 120917 | Undocumented 4 | Tree(s) :: 17 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778800 | 5990886 | 2105639 | 37.7611586563939 | -122.474651843595 | (37.7611586563939, -122.474651843595) | 1 | 8 | 4 | 56 | 12 | |
115503 | 100654 | Undocumented 4 | Tree(s) :: 17 | 590X Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | Permit Number 778778 | 5992503 | 2104630 | 37.7584817696578 | -122.468985951036 | (37.7584817696578, -122.468985951036) | 1 | 8 | 4 | 56 | 12 | ||
31233 | 231847 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 4050 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2016 12:00:00 AM | 3 | Width 2ft | Permit Number 778753 | 6001932.15846 | 2105889.72854 | 37.7624809612573 | -122.436465919794 | (37.7624809612573, -122.436465919794) | 15 | 5 | 5 | 28862 | 3 | |
109631 | 117583 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 4050 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778753 | 6001943 | 2105900 | 37.7625097802299 | -122.436429158123 | (37.7625097802299, -122.436429158123) | 15 | 5 | 5 | 28862 | 3 | |
82709 | 116214 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 3801 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996623 | 2114922 | 37.7869781063352 | -122.455481088021 | (37.7869781063352, -122.455481088021) | 11 | 6 | 1 | 54 | 31 |
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) );