trees
194,517 rows sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5138 | 247774 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 222 30th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005147.38191 | 2098466.01095 | 37.7422793318144 | -122.424817464458 | (37.7422793318144, -122.424817464458) | 2 | 7 | 5 | 63 | 22 | |||
5180 | 223976 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Gough St | 1 | : | Tree | Private 2 | 24 | 6006664.52423 | 2109235.55024 | 37.771935569897 | -122.420335857614 | (37.771935569897, -122.420335857614) | 8 | 2 | 9 | 28853 | 19 | ||||
5208 | 193661 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1744 Oakdale Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014300.46707 | 2096063.18282 | 37.7361943965519 | -122.393000575541 | (37.7361943965519, -122.393000575541) | 10 | 3 | 8 | 58 | 1 | |||
5264 | 200287 | DPW Maintained 1 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 | 450 Texas St | 5 | : | Tree | Private 2 | 1 | Width 5ft | 6013763.35516 | 2104980.70366 | 37.7606501645924 | -122.395482160282 | (37.7606501645924, -122.395482160282) | 10 | 3 | 8 | 28856 | 29 | |||
5281 | 189460 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Keith St | 6 | : | Tree | Private 2 | 23 | Width 3ft | 6017666.55512 | 2096787.33958 | 37.7383691928822 | -122.38141284964 | (37.7383691928822, -122.38141284964) | 10 | 3 | 8 | 58 | 1 | |||
5289 | 198707 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1601 Bay Shore Blvd | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6012032.42562 | 2091390.57869 | 37.7232381462018 | -122.400514050588 | (37.7232381462018, -122.400514050588) | 10 | 3 | 8 | 58 | 1 | |||
5340 | 247013 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Valley St | 3 | : | Tree | Private 2 | 14 | Width 3ft | 6002616.04169 | 2099183.02337 | 37.7441047811073 | -122.433621285011 | (37.7441047811073, -122.433621285011) | 2 | 7 | 5 | 63 | 22 | |||
5501 | 250103 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1634 Pine St | 2 | : | Tree | Private 2 | 2 | Width 4ft | 6006023.8446 | 2115600.71368 | 37.7893766304877 | -122.423004504073 | (37.7893766304877, -122.423004504073) | 13 | 9 | 1 | 28858 | 41 | |||
5547 | 194077 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 551 Barneveld Ave | 4 | : | Tree | Private 2 | 5 | Width 2ft | 6011049.20846 | 2097370.84853 | 37.7396038298609 | -122.404333582832 | (37.7396038298609, -122.404333582832) | 10 | 3 | 8 | 58 | 1 | |||
5620 | 250454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Seacliff Ave | 1 | : | Tree | Private 2 | 9 | Width 4ft | 5987161.73503 | 2115752.97281 | 37.7887122778945 | -122.488275583153 | (37.7887122778945, -122.488275583153) | 11 | 6 | 1 | 55 | 33 | |||
5623 | 226838 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 14 Liberty St | 2 | : | Tree | Private 2 | 7 | Width 1ft | 6006187.25946 | 2104078.53237 | 37.7577487106567 | -122.42162041686 | (37.7577487106567, -122.42162041686) | 2 | 4 | 5 | 28859 | 19 | |||
5629 | 192801 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1919 22nd St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6012353.86378 | 2103736.47851 | 37.7571552983898 | -122.400269594186 | (37.7571552983898, -122.400269594186) | 10 | 3 | 8 | 28856 | 29 | |||
5672 | 250483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 475 Seacliff Ave | 6 | : | Tree | Private 2 | 7 | Width 2ft | 5986409.29286 | 2115158.05614 | 37.7870348804072 | -122.490835095073 | (37.7870348804072, -122.490835095073) | 11 | 6 | 1 | 55 | 33 | |||
5700 | 247227 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 754 Duboce Ave | 3 | : | Tree | Private 2 | 13 | Width 4ft | 6002088.83354 | 2108298.92928 | 37.7691049375705 | -122.436096447702 | (37.7691049375705, -122.436096447702) | 15 | 5 | 5 | 29492 | 9 | |||
5704 | 247050 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 523 Valley St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6002490.03893 | 2099140.16558 | 37.7439799534136 | -122.434053911082 | (37.7439799534136, -122.434053911082) | 2 | 7 | 5 | 63 | 22 | |||
5750 | 177827 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 10 Brotherhood Way | 5 | : | Tree | Private 2 | 22 | Width 0ft | 5993584.63921 | 2087685.05468 | 37.7120175945993 | -122.46401514608 | (37.7120175945993, -122.46401514608) | 9 | 8 | 4 | 64 | 24 | |||
5781 | 207615 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | 9 | 8 | 6 | 64 | 24 | |||
5821 | 232036 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Scott St | 6 | : | Tree | Private 2 | 7 | Width 3ft | 6002425.62423 | 2108559.69988 | 37.7698400775965 | -122.434950161914 | (37.7698400775965, -122.434950161914) | 15 | 5 | 5 | 29492 | 9 | |||
5848 | 189784 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Texas St | 1 | : | Tree | Private 2 | 20 | Width 4ft | 6013708.09947 | 2105987.51004 | 37.7634115608072 | -122.39574381262 | (37.7634115608072, -122.39574381262) | 14 | 3 | 8 | 28856 | 29 | |||
5882 | 188040 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 50 Sierra St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6013665.83046 | 2104151.79248 | 37.7583687302392 | -122.395761374607 | (37.7583687302392, -122.395761374607) | 10 | 3 | 8 | 28856 | 29 | |||
5899 | 228878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 317 Buchanan St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6004644.50049 | 2109700.89583 | 37.7730992602639 | -122.427356425982 | (37.7730992602639, -122.427356425982) | 7 | 9 | 11 | 28852 | 10 | |||
6047 | 204081 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 681 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993497.95379 | 2090430.17226 | 37.7195500336733 | -122.464513948782 | (37.7195500336733, -122.464513948782) | 9 | 8 | 6 | 64 | 24 | |||
6219 | 198125 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6013825.74476 | 2093610.04486 | 37.72943220072 | -122.394470179266 | (37.72943220072, -122.394470179266) | 10 | 3 | 8 | 58 | 1 | |||
6249 | 211394 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 37 | : | Tree | Private 2 | 7 | Width 0ft | 5991385.47593 | 2094405.95622 | 37.7303445458499 | -122.472105586627 | (37.7303445458499, -122.472105586627) | 9 | 8 | 4 | 64 | 40 | |||
6418 | 194172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 664 Wisconsin St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6012676.7573 | 2104370.99604 | 37.7589155441312 | -122.399197435936 | (37.7589155441312, -122.399197435936) | 10 | 3 | 8 | 28856 | 29 | |||
6531 | 192922 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 6 | : | Tree | Private 2 | 2 | Width 3ft | 6009195.26787 | 2109094.7407 | 37.7716912222994 | -122.411571845561 | (37.7716912222994, -122.411571845561) | 8 | 2 | 9 | 28853 | 34 | |||
6550 | 194776 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Flora St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013845.42665 | 2094215.08633 | 37.731094615529 | -122.394444484728 | (37.731094615529, -122.394444484728) | 10 | 3 | 8 | 58 | 1 | |||
6733 | 208696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993735.7088 | 2088773.52296 | 37.7150149747485 | -122.463571955684 | (37.7150149747485, -122.463571955684) | 9 | 8 | 6 | 64 | 24 | |||
6794 | 213749 | DPW Maintained 1 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 | 300 Junipero Serra Blvd | 35 | : | Tree | Private 2 | 3 | Width 0ft | 5991393.22767 | 2094416.18381 | 37.730373076833 | -122.472079533242 | (37.730373076833, -122.472079533242) | 9 | 8 | 4 | 64 | 40 | |||
6844 | 235670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Elgin Park | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005833.06667 | 2108709.07327 | 37.7704431026896 | -122.423174504696 | (37.7704431026896, -122.423174504696) | 8 | 2 | 5 | 28853 | 19 | |||
6975 | 213248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2950 San Jose Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5996050.31606 | 2087518.48106 | 37.7117020161965 | -122.455481080804 | (37.7117020161965, -122.455481080804) | 9 | 8 | 6 | 28861 | 24 | |||
6997 | 210163 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 855 Niagara Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997165.58678 | 2090928.28629 | 37.7211284832657 | -122.451872256998 | (37.7211284832657, -122.451872256998) | 9 | 8 | 6 | 28861 | 24 | |||
7077 | 208685 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 61 Margaret Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997050.0175 | 2089737.60379 | 37.7178525273547 | -122.452185875792 | (37.7178525273547, -122.452185875792) | 9 | 8 | 6 | 28861 | 24 | |||
7271 | 246478 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 324 Duncan St | 1 | : | Tree | Private 2 | 15 | Width 5ft | 6004249.43735 | 2099875.64697 | 37.7460991095817 | -122.42802271119 | (37.7460991095817, -122.42802271119) | 2 | 7 | 5 | 63 | 22 | |||
7314 | 249340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 839 Post St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6008138.31912 | 2114803.99526 | 37.7873081250076 | -122.415632209079 | (37.7873081250076, -122.415632209079) | 13 | 1 | 9 | 28858 | 36 | |||
7439 | 193102 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1298 Fairfax Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6017232.41157 | 2097031.5064 | 37.7390156480633 | -122.382930908836 | (37.7390156480633, -122.382930908836) | 10 | 3 | 8 | 58 | 1 | |||
7557 | 206861 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 89 | : | Tree | Private 2 | 15 | Width 0ft | 5991235.10134 | 2092148.32282 | 37.7241369448505 | -122.47246092223 | (37.7241369448505, -122.47246092223) | 9 | 8 | 4 | 64 | 40 | |||
7843 | 202011 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Wheat St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012102.79015 | 2091227.84985 | 37.7227952498849 | -122.400259388686 | (37.7227952498849, -122.400259388686) | 10 | 3 | 8 | 58 | 1 | |||
7850 | 204156 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900 Junipero Serra Blvd | 106 | : | Tree | Private 2 | 3 | Width 0ft | 5991140.12525 | 2090380.53407 | 37.7192775364035 | -122.472660407165 | (37.7192775364035, -122.472660407165) | 9 | 8 | 4 | 64 | 40 | |||
7914 | 193840 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 8 | : | Tree | Private 2 | 6 | Width 3ft | 6011575.20658 | 2099640.54229 | 37.7458653020467 | -122.402674470349 | (37.7458653020467, -122.402674470349) | 10 | 3 | 8 | 58 | 1 | |||
7929 | 212670 | DPW Maintained 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 215 Garfield St | 1 | : | Tree | Private 2 | 04/09/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785243 | 5993431.79105 | 2090458.25949 | 37.7196233401385 | -122.464744686025 | (37.7196233401385, -122.464744686025) | 9 | 8 | 6 | 64 | 24 | |
8109 | 136528 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3271 Baker St | 1 | : | Tree | Private 2 | 17 | Width 4ft | 5999283.78896 | 2120122.72812 | 37.8014102447475 | -122.446649724806 | (37.8014102447475, -122.446649724806) | 13 | 9 | 1 | 57 | 17 | |||
8115 | 204074 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 216 Arch St | 3 | : | Tree | Private 2 | 3 | Width 3ft | Permit Number 767875 | 5992726.806 | 2088618.30959 | 37.7145306124731 | -122.467047845297 | (37.7145306124731, -122.467047845297) | 9 | 8 | 6 | 64 | 24 | ||
8125 | 189865 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 501 Newhall St | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6015985.7864 | 2097784.98338 | 37.7410155838051 | -122.387293751216 | (37.7410155838051, -122.387293751216) | 10 | 3 | 8 | 58 | 1 | |||
8185 | 247646 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 2 | : | Tree | Private 2 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.7690898244695 | -122.437731184045 | (37.7690898244695, -122.437731184045) | 15 | 5 | 5 | 29492 | 9 | |||
8287 | 196310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 928 Clara St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6011726.41935 | 2111671.91567 | 37.7789092071182 | -122.402997684908 | (37.7789092071182, -122.402997684908) | 14 | 2 | 9 | 28856 | 34 | |||
8312 | 187793 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 570 Bryant St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013291.53911 | 2112061.35383 | 37.7800657892442 | -122.397610596567 | (37.7800657892442, -122.397610596567) | 6 | 2 | 9 | 28856 | 34 | |||
8353 | 246952 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6003390.88605 | 2107111.412 | 37.7659181907902 | -122.43150793845 | (37.7659181907902, -122.43150793845) | 15 | 5 | 5 | 28862 | 3 | |||
8394 | 206864 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 108 | : | Tree | Private 2 | 16 | Width 0ft | 5991230.74264 | 2091941.55129 | 37.7235689492395 | -122.472460922234 | (37.7235689492395, -122.472460922234) | 9 | 8 | 4 | 64 | 40 | |||
8438 | 189632 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6007298.00895 | 2110457.3775 | 37.7753260931545 | -122.4182312237 | (37.7753260931545, -122.4182312237) | 8 | 2 | 9 | 28853 | 34 | |||
8531 | 239148 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 8 Octavia St | 12 | : | Tree | Private 2 | 3 | Width 6ft | 6005748.59719 | 2109565.89201 | 37.7727909537754 | -122.423527610038 | (37.7727909537754, -122.423527610038) | 7 | 9 | 11 | 28852 | 10 | |||
8626 | 188622 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 20 | : | Tree | Private 2 | 16 | Width 3ft | 6016025.72974 | 2098951.35828 | 37.7442204222503 | -122.387236979699 | (37.7442204222503, -122.387236979699) | 10 | 3 | 8 | 58 | 1 | |||
8677 | 249743 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2500 Broderick St | 27 | : | Tree | Private 2 | 8 | Width 1ft | 6000230.51867 | 2117262.97292 | 37.7936121486327 | -122.443168120916 | (37.7936121486327, -122.443168120916) | 13 | 9 | 1 | 57 | 27 | |||
8692 | 247232 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 760 Duboce Ave | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6002013.60886 | 2108293.7767 | 37.7690865158689 | -122.436356276247 | (37.7690865158689, -122.436356276247) | 15 | 5 | 5 | 29492 | 9 | |||
8741 | 196051 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 10 McLea Ct | 4 | : | Tree | Private 2 | 11 | Width 3ft | 6010059.73194 | 2109243.59053 | 37.7721483818683 | -122.408592099356 | (37.7721483818683, -122.408592099356) | 14 | 2 | 9 | 28853 | 34 | |||
8756 | 221784 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 201 Buchanan St | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6004701.97389 | 2109293.67351 | 37.7719843770185 | -122.427128606994 | (37.7719843770185, -122.427128606994) | 7 | 9 | 11 | 28852 | 10 | |||
8768 | 246988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Clipper St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6004704.08454 | 2101068.96131 | 37.7494013868777 | -122.426535555381 | (37.7494013868777, -122.426535555381) | 2 | 4 | 5 | 28862 | 22 | |||
8797 | 213239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Majestic Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997415.57746 | 2089795.63137 | 37.7180327919586 | -122.450926484985 | (37.7180327919586, -122.450926484985) | 9 | 8 | 6 | 28861 | 24 | |||
8808 | 198709 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 1575 Bay Shore Blvd | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6011880.53852 | 2091897.11167 | 37.7246205103096 | -122.401074672678 | (37.7246205103096, -122.401074672678) | 10 | 3 | 8 | 58 | 1 | |||
8875 | 193652 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2141 Oakdale Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6012072.86393 | 2097652.92355 | 37.7404354977101 | -122.400814014067 | (37.7404354977101, -122.400814014067) | 10 | 3 | 8 | 58 | 1 | |||
9176 | 176544 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 7 | : | Tree | Private 2 | 1 | Width 3ft | 5992259.97775 | 2086836.1982 | 37.7096104062721 | -122.468531792305 | (37.7096104062721, -122.468531792305) | 9 | 8 | 4 | 64 | 24 | |||
9279 | 196461 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 615 Mississippi St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542099 | (37.7587393543665, -122.39411542099) | 10 | 3 | 8 | 28856 | 29 | |||
9352 | 200404 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 325 09th St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6009328.24749 | 2109756.9252 | 37.7735168847176 | -122.411158642161 | (37.7735168847176, -122.411158642161) | 8 | 2 | 9 | 28853 | 34 | |||
9365 | 247654 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 10 | : | Tree | Private 2 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | 15 | 5 | 5 | 29492 | 9 | |||
9444 | 205868 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Lakeview Ave | 1 | : | Tree | Private 2 | 11/04/1969 12:00:00 AM | 13 | Width 3ft | Permit Number 6398 | 5996845.79725 | 2089640.92362 | 37.7175753652817 | -122.452884796511 | (37.7175753652817, -122.452884796511) | 9 | 8 | 6 | 28861 | 24 | |
9467 | 191059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 2 | : | Tree | Private 2 | 6 | Width 5ft | 6011805.95608 | 2111927.87879 | 37.7796164636776 | -122.402740539939 | (37.7796164636776, -122.402740539939) | 14 | 2 | 9 | 28856 | 34 | |||
9489 | 219078 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 23 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993714.36027 | 2087390.34861 | 37.7112158768855 | -122.463545422096 | (37.7112158768855, -122.463545422096) | 9 | 8 | 4 | 64 | 24 | |||
9586 | 191511 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 392 04th St | 2 | : | Tree | Private 2 | 09/27/2001 12:00:00 AM | 5 | Width 3ft | Permit Number 44376 | 6012652.22642 | 2112454.21838 | 37.7811088850041 | -122.399849876973 | (37.7811088850041, -122.399849876973) | 6 | 2 | 9 | 28856 | 34 | |
9603 | 215597 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 44 | : | Tree | Private 2 | 15 | Width 0ft | 5991275.01695 | 2092498.39745 | 37.7251004730822 | -122.472348449425 | (37.7251004730822, -122.472348449425) | 9 | 8 | 4 | 64 | 40 | |||
9617 | 240412 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 1 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.05977 | 2103920.26324 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | 2 | 4 | 5 | 28862 | 3 | ||
9662 | 113066 | - 12 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 7 | : | Tree | DPW 1 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
9797 | 219544 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 28 | : | Tree | Private 2 | 19 | Width 0ft | 5991391.01152 | 2094448.55765 | 37.7304618390337 | -122.472089553508 | (37.7304618390337, -122.472089553508) | 9 | 8 | 4 | 64 | 40 | |||
9805 | 246529 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6005210.23202 | 2109136.89842 | 37.77158263905 | -122.425359343752 | (37.77158263905, -122.425359343752) | 7 | 9 | 5 | 28852 | 10 | |||
9813 | 201661 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 149 Dore St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6009207.44548 | 2109499.94346 | 37.7728044975557 | -122.411558355748 | (37.7728044975557, -122.411558355748) | 8 | 2 | 9 | 28853 | 34 | |||
9829 | 207861 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Ralston St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5992207.07547 | 2088343.8619 | 37.7137470322778 | -122.468824268047 | (37.7137470322778, -122.468824268047) | 9 | 8 | 6 | 64 | 24 | |||
9866 | 178155 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 10 | : | Tree | Private 2 | 6 | Width 0ft | 5993366.44396 | 2087810.43567 | 37.7123492834548 | -122.464778384525 | (37.7123492834548, -122.464778384525) | 9 | 8 | 4 | 64 | 24 | |||
10038 | 195214 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Davidson Ave | 3 | : | Tree | Private 2 | 9 | Width 4ft | 6014827.69575 | 2099442.30699 | 37.7455020460878 | -122.391413870179 | (37.7455020460878, -122.391413870179) | 10 | 3 | 8 | 58 | 1 | |||
10163 | 204073 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 216 Arch St | 2 | : | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 767875 | 5992727.7538 | 2088602.30188 | 37.7144867138609 | -122.467043406235 | (37.7144867138609, -122.467043406235) | 9 | 8 | 6 | 64 | 24 | |
10175 | 103130 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 418 28th Ave | 1 | : | Tree | Private 2 | 1 | 5987189.39247 | 2113118.19249 | 37.7814795396885 | -122.487986220863 | (37.7814795396885, -122.487986220863) | 11 | 6 | 2 | 55 | 26 | ||||
10186 | 250045 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6006086.73506 | 2114727.88869 | 37.7869836181338 | -122.422724857187 | (37.7869836181338, -122.422724857187) | 13 | 9 | 1 | 28858 | 41 | |||
10208 | 250096 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 Pine St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005700.60971 | 2115508.13842 | 37.789104197049 | -122.42411627476 | (37.789104197049, -122.42411627476) | 13 | 9 | 1 | 28858 | 41 | |||
10211 | 249538 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 7 | : | Tree | Private 2 | 4 | Width 3ft | 6006360.10871 | 2114050.01147 | 37.7851377542393 | -122.421730877876 | (37.7851377542393, -122.421730877876) | 13 | 9 | 11 | 28858 | 41 | |||
10356 | 196587 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 219 Dore St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6009517.96758 | 2109174.60645 | 37.7719286109601 | -122.410461243119 | (37.7719286109601, -122.410461243119) | 8 | 2 | 9 | 28853 | 34 | |||
10433 | 189238 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2126 24th St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012108.67622 | 2102369.63804 | 37.75338857883 | -122.401021516451 | (37.75338857883, -122.401021516451) | 10 | 3 | 8 | 28856 | 29 | |||
10434 | 189892 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 6 | : | Tree | Private 2 | 13 | Width 4ft | 6016806.72009 | 2098324.89991 | 37.7425435148768 | -122.384492832481 | (37.7425435148768, -122.384492832481) | 10 | 3 | 8 | 58 | 1 | |||
10548 | 211015 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 78 | : | Tree | Private 2 | 3 | Width 0ft | 5991307.93934 | 2093199.2311 | 37.7270266932138 | -122.472285706431 | (37.7270266932138, -122.472285706431) | 9 | 8 | 4 | 64 | 40 | |||
10610 | 218537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 169 Eucalyptus Dr | 2 | : | Tree | Private 2 | 3 | Width 2ft | 5991155.07657 | 2094656.4445 | 37.7310189879395 | -122.472920359789 | (37.7310189879395, -122.472920359789) | 9 | 8 | 4 | 64 | 40 | |||
10641 | 232039 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Scott St | 12 | : | Tree | Private 2 | 9 | Width 3ft | 6002403.60195 | 2108716.39098 | 37.7702690623006 | -122.435037544552 | (37.7702690623006, -122.435037544552) | 15 | 5 | 5 | 29492 | 9 | |||
10727 | 190148 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1711 Oakdale Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014397.54059 | 2095926.93864 | 37.7358256897857 | -122.392655422032 | (37.7358256897857, -122.392655422032) | 10 | 3 | 8 | 58 | 1 | |||
10827 | 193103 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1360 Fairfax Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6016766.03407 | 2097379.43395 | 37.7399452071057 | -122.384567672275 | (37.7399452071057, -122.384567672275) | 10 | 3 | 8 | 58 | 1 | |||
10828 | 196319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 83 Lafayette St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007736.57644 | 2109492.64153 | 37.7727018336483 | -122.416645755806 | (37.7727018336483, -122.416645755806) | 8 | 2 | 9 | 28853 | 19 | |||
10873 | 189885 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 201 Newhall St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6016834.26905 | 2098267.19561 | 37.7423865939792 | -122.384393557236 | (37.7423865939792, -122.384393557236) | 10 | 3 | 8 | 58 | 1 | |||
10908 | 214113 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 232 Garfield St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993322.79937 | 2090505.62474 | 37.7197471093131 | -122.46512486634 | (37.7197471093131, -122.46512486634) | 9 | 8 | 6 | 64 | 24 | |||
10946 | 200359 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 4 | : | Tree | Private 2 | 9 | Width 5ft | 6014213.14362 | 2096595.32013 | 37.7376506849368 | -122.393339717964 | (37.7376506849368, -122.393339717964) | 10 | 3 | 8 | 58 | 1 | |||
11000 | 241648 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Scott St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6002449.19089 | 2108391.942 | 37.7693807938253 | -122.434856646815 | (37.7693807938253, -122.434856646815) | 15 | 5 | 5 | 29492 | 9 | |||
11011 | 249339 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 839 Post St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6008120.77004 | 2114802.70738 | 37.7873036023197 | -122.415692834155 | (37.7873036023197, -122.415692834155) | 13 | 1 | 9 | 28858 | 36 | |||
11059 | 211396 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 51 | : | Tree | Private 2 | 7 | Width 0ft | 5991320.25705 | 2093401.75426 | 37.7275834841643 | -122.47225788142 | (37.7275834841643, -122.47225788142) | 9 | 8 | 4 | 64 | 40 | |||
11061 | 189851 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 15 | : | Tree | Private 2 | 12 | Width 3ft | 6017359.84801 | 2098072.09609 | 37.7418799384027 | -122.382562673322 | (37.7418799384027, -122.382562673322) | 10 | 3 | 8 | 58 | 1 | |||
11064 | 196994 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 7 | : | Tree | Private 2 | 7 | Width 4ft | 6013884.28274 | 2100137.93009 | 37.7473596740254 | -122.394724774624 | (37.7473596740254, -122.394724774624) | 10 | 3 | 8 | 58 | 1 | |||
11122 | 205941 | DPW Maintained 1 | Cedrus atlantica :: Atlas Cedar 233 | 400 Junipero Serra Blvd | 26 | : | Tree | Private 2 | 14 | Width 0ft | 5991352.1529 | 2093883.98785 | 37.7289094230078 | -122.472182754742 | (37.7289094230078, -122.472182754742) | 9 | 8 | 4 | 64 | 40 |
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) );