trees

8,298 rows where qLegalStatus_id = 4 sorted by SiteOrder descending

✎ View and edit SQL

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)
653 262559 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
1256 97187 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
2023 264805 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
2361 256460 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 9 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
3197 261564 Undocumented 4 Pinus radiata :: Monterey Pine 15 1801 25th St 9 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
6188 111792 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
8269 99967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2270 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
11056 111333 Undocumented 4 Quercus suber :: Cork Oak 78 698x ILLINOIS ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015875 2105932 37.7633794456224 -122.388245263499 (37.7633794456224, -122.388245263499) 14 3 8 28856 29
12634 264775 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 90x Guy Pl 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
16042 256809 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1098x Geary St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
19076 99594 Undocumented 4 Ficus nitida :: Laurel Fig 53 1855X Evans Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
19191 122767 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 86X Park Hill Ave 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001171 2107689 37.7673780360046 -122.439227450619 (37.7673780360046, -122.439227450619) 15 5 5 29492 3
23579 255888 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 50 Columbia Square St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
26537 102408 Undocumented 4 Tree(s) :: 17 95X Harriet St 9 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010704.6 2111649.2 37.7787897224959 -122.406530981243 (37.7787897224959, -122.406530981243) 14 2 9 28853 34
26910 111776 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
29374 109992 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 501X Shotwell St 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
32800 117172 Undocumented 4 Tree(s) :: 17 299x ALMA ST 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
34327 105563 Undocumented 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 450 10th St 9 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6009467.7 2108781.2 37.7708455901598 -122.410607336919 (37.7708455901598, -122.410607336919) 8 2 9 28853 34
34378 109203 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 2401x CASTRO ST 9 Median : Yard Tree DPW 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
36751 121063 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
37186 112411 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
37608 97493 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 500X Miramar Ave 9 Median : Cutout Tree Private 2     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
37764 76002 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 49 Townsend St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1996 12:00:00 AM 9 3x3   6015772.4 2112409.7 37.7811600997206 -122.389052431052 (37.7811600997206, -122.389052431052) 6 2 9 28856 20
39248 100138 Undocumented 4 Tree(s) :: 17 155 05th St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769024 6011029.6 2112857.4 37.7821253339557 -122.405491786923 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
39604 116148 Undocumented 4 Tree(s) :: 17 3800X 20th St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6004661.9257 2104258.88373 37.7581577845713 -122.426908497787 (37.7581577845713, -122.426908497787) 2 4 5 28862 3
39923 94251 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 9 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
40148 237562 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 268 Dorland St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003657.48862 2105720.4016 37.7621139182326 -122.430486555019 (37.7621139182326, -122.430486555019) 8 4 5 28862 3
45959 113293 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1626 PIERCE ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002154 2114089 37.7850067228559 -122.436285471088 (37.7850067228559, -122.436285471088) 13 6 11 29490 13
47231 99464 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 550X Miramar Ave 9 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
48698 108284 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 1 HENRY ADAMS ST 9 Sidewalk: Property side : Cutout Tree Private 2     16 3x3   6011517.4 2108140.5 37.7692010762684 -122.403472255644 (37.7692010762684, -122.403472255644) 8 2 8 28853 20
50533 113121 Undocumented 4 Eriobotrya japonica :: Edible Loquat 119 1x TOMASO CT 9 Sidewalk: Property side : Yard Tree Private 2           6009323 2086334 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552) 9 7 8 309 39
52863 113177 Undocumented 4 Pyrus spp :: Pear Tree 281 1721X Armstrong Ave 9 Sidewalk: Curb side : Cutout Tree Private 2           6013664.61678 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
55377 117237 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 635 GROVE ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
55613 114746 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 9 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
57879 101766 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
57981 110511 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1600x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6006820 2107391 37.7668796319268 -122.419667156869 (37.7668796319268, -122.419667156869) 8 4 7 28853 19
57984 116822 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 9 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
59516 120135 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
60054 139409 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 1500 GEARY BLVD 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004207.1311 2114038.5263 37.7849845753314 -122.429178689925 (37.7849845753314, -122.429178689925) 13 9 11 29490 13
60871 110703 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 9 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
61080 114116 Undocumented 4 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 9 Sidewalk: Property side : Yard Tree Private 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
61217 98752 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
61782 108657 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
61934 108130 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1901 FOLSOM ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008051 2107091 37.7661251677687 -122.415388074018 (37.7661251677687, -122.415388074018) 8 4 7 28853 19
63931 102343 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
65073 116329 Undocumented 4 :: 45 1400X Potrero Ave 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6010648.28497 2101378.43149 37.7505853701643 -122.406002059271 (37.7505853701643, -122.406002059271) 10 4 8 28859 19
74136 101581 Undocumented 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1200X Bryant St 9 Sidewalk: Property side : Cutout Tree Private 2     8 3x3   6009691.5 2108599.6 37.7703595033467 -122.409820383511 (37.7703595033467, -122.409820383511) 8 2 9 28853 34
74249 116261 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 9 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
75871 125324 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 640 Davis St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6013147.44886 2118845.30288 37.798684901431 -122.398585258406 (37.798684901431, -122.398585258406) 3 1 10 28860 6
79499 256582 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
80560 114268 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 9 Front Yard : Yard Tree Private 2     30     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
81287 111404 Undocumented 4 Pinus radiata :: Monterey Pine 15 50x SANTA RITA AVE 9 Median : Yard Tree Private 2     48     5993713 2100532 37.7472995494238 -122.464503713167 (37.7472995494238, -122.464503713167) 1 8 4 29491 40
83031 256421 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 9 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
83759 115862 Undocumented 4 Celtis sinensis :: Chinese Hackberry 153 451x KANSAS ST 9 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6011530 2106284 37.7641042503363 -122.403298055195 (37.7641042503363, -122.403298055195) 8 3 8 28856 29
85263 116800 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2120 BROADWAY 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003325 2117599 37.7947107530845 -122.432484978634 (37.7947107530845, -122.432484978634) 13 9 1 29490 27
85328 114933 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 9 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
85516 116628 Undocumented 4 Olea europaea :: Olive Tree 9 5732X GEARY BLVD 9 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
87592 100507 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 9 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
87854 103360 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 9 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
93435 122493 Undocumented 4 Quercus agrifolia :: Coast Live Oak 172 69x Bonview St 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007716 2099172 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063) 2 7 7 28859 2
93715 100117 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 9 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
93965 116189 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1751 CARROLL AVE 9 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6013485 2092424 37.7261566141218 -122.395565112125 (37.7261566141218, -122.395565112125) 10 3 8 58 1
96059 74239 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 499 Townsend St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1996 12:00:00 AM   3x3   6012750.5 2109712.9 37.7735873297862 -122.399317399206 (37.7735873297862, -122.399317399206) 14 2 9 28856 20
96258 256848 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
100811 111598 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
101825 97903 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 375X Precita Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
102477 116246 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
102497 108353 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 9 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
105781 112723 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 455 BAY ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
105950 116993 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 300x BRODERICK ST 9 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6001353 2109892 37.7734372805127 -122.438755818588 (37.7734372805127, -122.438755818588) 15 5 11 29492 10
106479 118298 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 275 OLYMPIA WAY 9 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996383 2101914 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371) 1 5 4 63 38
107063 113250 Undocumented 4 Gleditsia triacanthos :: Honey Locust 182 1301X 04TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       5x5   5994883 2106671 37.7642230519674 -122.46090282761 (37.7642230519674, -122.46090282761) 15 5 11 56 12
107789 137954 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1615 SUTTER ST 9 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004801.2336 2114685.8103 37.7867954695312 -122.427169405594 (37.7867954695312, -122.427169405594) 13 9 11 28858 13
107815 101556 Undocumented 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 435X 11th St 9 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009095.5 2108566.4 37.770234925082 -122.411879608901 (37.770234925082, -122.411879608901) 8 2 9 28853 34
108209 99567 Undocumented 4 Tree(s) :: 17 650X Brunswick St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
108397 102154 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
108758 110875 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 800 INDIANA ST 9 Sidewalk: Property side : Yard Tree Private 2           6014913.4 2104437.2 37.7592217202179 -122.391466645187 (37.7592217202179, -122.391466645187) 10 3 8 28856 29
109200 116282 Undocumented 4 :: 45 700X Greenwich St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
109207 256819 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1101 Van Ness Ave 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006375 2114401 37.786102322085 -122.421704297146 (37.786102322085, -122.421704297146) 13 9 11 28858 41
110191 111226 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
113686 117470 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 511x HAMPSHIRE ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010223 2105808 37.7627241794067 -122.407785042208 (37.7627241794067, -122.407785042208) 8 4 8 28859 19
115122 108413 Undocumented 4 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 99x HYDE ST 9 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x3 Permit Number 773269 6008108 2112443 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338) 7 10 9 28852 36
117083 256838 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1201x Franklin St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
117410 114174 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1x SHRADER ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997234 2110523 37.7749346499606 -122.453049512511 (37.7749346499606, -122.453049512511) 15 5 2 29492 16
117469 120988 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 838 Pacific Ave 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010100.08183161 2118181.67167684 37.7966924872417 -122.409083316519 (37.7966924872417, -122.409083316519) 3 1 10 308 4
117575 116563 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1620 INNES AVE 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015376 2097346 37.7397764361483 -122.389371539928 (37.7397764361483, -122.389371539928) 10 3 8 58 1
118778 116293 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
119361 120152 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
121243 113675 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 500X THE EMBARCADERO 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
122465 111414 Undocumented 4 Pinus radiata :: Monterey Pine 15 150x SAN MARCOS AVE 9 Median : Yard Tree Private 2     42     5993566 2100407 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317) 1 8 4 29491 40
122580 117041 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2220x SUTTER ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
123387 103432 Undocumented 4 Podocarpus henkelii :: Long-Leafed Yellow-Wood 187 50X Bluxome St 9 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
125028 112655 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 3100X 26TH ST 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008747 2100981 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695) 2 4 7 28859 19
126641 102334 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 3201X 18th St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008125.3 2105602.6 37.7620425418858 -122.415025724241 (37.7620425418858, -122.415025724241) 2 4 7 28859 19
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
130000 102029 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
134593 99126 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 9 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
136511 110551 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 9 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
138975 256237 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 133 Shipley St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012189 2112453 37.7810797043555 -122.401452333097 (37.7810797043555, -122.401452333097) 6 2 9 28856 34
143233 108339 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 1099 CAPITOL AVE 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995030 2091211 37.7217821988442 -122.459274772662 (37.7217821988442, -122.459274772662) 9 8 6 28861 24

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