194,517 rows sorted by qSiteInfo

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);