trees
6,714 rows where qSpecies_id = 7 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 129277 | 103959 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 460X Lily St | 1 | unknown : Pot | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
| 162044 | 247938 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 29 Joy St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | 2 | 7 | 7 | 28859 | 2 | |||
| 72 | 135801 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Phoenix Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008610.92916 | 2117913.61927 | 37.7958729471262 | -122.414217164494 | (37.7958729471262, -122.414217164494) | 5 | 1 | 10 | 308 | 21 | |||
| 1844 | 212645 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 385 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992447.95571 | 2090426.49221 | 37.7194793442858 | -122.468143110712 | (37.7194793442858, -122.468143110712) | 9 | 8 | 6 | 64 | 24 | |||
| 1853 | 214288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 38 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/23/2000 12:00:00 AM | 13 | Width 3ft | Permit Number 42619 | 5999806.95305 | 2093809.09712 | 37.7291894584065 | -122.442948622496 | (37.7291894584065, -122.442948622496) | 9 | 7 | 4 | 63 | 40 | |
| 3010 | 124046 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 723 12th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5992224.36446 | 2110496.07608 | 37.7745723492368 | -122.470376788909 | (37.7745723492368, -122.470376788909) | 11 | 6 | 2 | 54 | 11 | |||
| 4349 | 212581 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 698 Hearst Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5996847.55389 | 2094438.38996 | 37.7307481750846 | -122.453224871536 | (37.7307481750846, -122.453224871536) | 9 | 7 | 4 | 59 | 40 | |||
| 5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 9 | 8 | 4 | 64 | 40 | ||||
| 6598 | 261578 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 496 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 11152 | 212892 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1485 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5991130.51563 | 2105331.7867 | 37.7603292954688 | -122.473783764707 | (37.7603292954688, -122.473783764707) | 1 | 8 | 4 | 56 | 12 | |||
| 13078 | 135703 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Masonic Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998890.10615 | 2113926.10029 | 37.7843734546089 | -122.447565730187 | (37.7843734546089, -122.447565730187) | 15 | 6 | 1 | 54 | 31 | |||
| 13333 | 196273 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 89 Kiska Rd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6018678.54669 | 2093695.28939 | 37.7299348462003 | -122.377699306103 | (37.7299348462003, -122.377699306103) | 10 | 3 | 8 | 58 | 1 | |||
| 14010 | 261579 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 496 Urbano Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 14034 | 260614 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Farnsworth Ln | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | Width 6ft | 5996584.89502 | 2106441.40106 | 37.763690412698 | -122.454999901235 | (37.763690412698, -122.454999901235) | 15 | 5 | 11 | 29492 | 12 | ||||
| 16137 | 123150 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 530 10th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992860.06337 | 2111844.71904 | 37.778312093174 | -122.468275933095 | (37.778312093174, -122.468275933095) | 11 | 6 | 2 | 54 | 11 | |||
| 19021 | 196130 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 582 Rhode Island St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011755.76075 | 2105663.76681 | 37.7624138349597 | -122.402473594197 | (37.7624138349597, -122.402473594197) | 8 | 3 | 8 | 28856 | 29 | ||||
| 20002 | 124228 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 219 Stanyan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5996619.11206 | 2111349.85847 | 37.7771697285711 | -122.455236295635 | (37.7771697285711, -122.455236295635) | 11 | 6 | 2 | 54 | 16 | |||
| 20851 | 212631 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 162 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5992215.36031 | 2088948.17723 | 37.7154068147365 | -122.468839581692 | (37.7154068147365, -122.468839581692) | 9 | 8 | 6 | 64 | 24 | |||
| 21417 | 124045 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 723 12th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5992223.98611 | 2110507.73124 | 37.7746043292792 | -122.470378946663 | (37.7746043292792, -122.470378946663) | 11 | 6 | 2 | 54 | 11 | |||
| 22027 | 214252 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 534 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5998526.76738 | 2095010.30635 | 37.7324146242322 | -122.447460741526 | (37.7324146242322, -122.447460741526) | 9 | 7 | 4 | 59 | 40 | ||||
| 26210 | 178799 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 426 Princeton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6008025.38045 | 2091906.17516 | 37.7244295815351 | -122.414402143346 | (37.7244295815351, -122.414402143346) | 9 | 3 | 7 | 309 | 28 | |||
| 28812 | 214205 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 790 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999120.217 | 2095751.41949 | 37.7344834417592 | -122.445462325626 | (37.7344834417592, -122.445462325626) | 9 | 7 | 4 | 59 | 40 | |||
| 29345 | 214272 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 700 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5997358.8736 | 2095022.69988 | 37.7323818439441 | -122.451499297349 | (37.7323818439441, -122.451499297349) | 9 | 7 | 4 | 59 | 40 | |||
| 29530 | 201971 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6013754.58016 | 2092201.85922 | 37.7255616517262 | -122.394617632995 | (37.7255616517262, -122.394617632995) | 10 | 3 | 8 | 58 | 1 | ||||
| 29896 | 196297 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1501 22nd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6013586.24242 | 2103799.53475 | 37.7573970793204 | -122.396011941921 | (37.7573970793204, -122.396011941921) | 10 | 3 | 8 | 28856 | 29 | ||||
| 32364 | 123164 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 567 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5992805.53108 | 2111610.19032 | 37.7776649910865 | -122.468447511304 | (37.7776649910865, -122.468447511304) | 11 | 6 | 2 | 54 | 11 | ||||
| 32769 | 212683 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5990865.46988 | 2095638.11605 | 37.7336976393282 | -122.473993164651 | (37.7336976393282, -122.473993164651) | 1 | 8 | 4 | 64 | 40 | |||
| 34460 | 249631 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2498 Golden Gate Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997554.63334 | 2111312.07091 | 37.7771196039259 | -122.451997320318 | (37.7771196039259, -122.451997320318) | 15 | 6 | 2 | 54 | 16 | |||
| 35475 | 212652 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 313 Vernon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5992443.32484 | 2089879.75405 | 37.717977866774 | -122.468119367735 | (37.717977866774, -122.468119367735) | 9 | 8 | 6 | 64 | 24 | |||
| 35634 | 212893 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1485 16th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5991128.89373 | 2105319.02448 | 37.760294159865 | -122.473788442997 | (37.760294159865, -122.473788442997) | 1 | 8 | 4 | 56 | 12 | |||
| 37551 | 253474 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x2 | 5991633 | 2092401 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | 9 | 8 | 4 | 59 | 40 | ||||
| 38512 | 212458 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 768 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5994909.71426 | 2093167.92763 | 37.7271485351522 | -122.459832248185 | (37.7271485351522, -122.459832248185) | 9 | 7 | 4 | 28861 | 40 | |||
| 38922 | 212628 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 385 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5991678.72226 | 2091078.63283 | 37.7212255066273 | -122.47084952239 | (37.7212255066273, -122.47084952239) | 9 | 8 | 6 | 64 | 24 | |||
| 39120 | 236674 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4301 26th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6001900.9288 | 2100573.24864 | 37.747881410301 | -122.436193451291 | (37.747881410301, -122.436193451291) | 2 | 4 | 5 | 63 | 22 | |||
| 41179 | 212620 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 119 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5991404.09674 | 2089992.64963 | 37.7182277775561 | -122.471719713595 | (37.7182277775561, -122.471719713595) | 9 | 8 | 6 | 64 | 24 | |||
| 41804 | 236972 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Eugenia Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6006377.9227 | 2098202.61198 | 37.7416255237887 | -122.420543931068 | (37.7416255237887, -122.420543931068) | 2 | 7 | 7 | 28859 | 2 | |||
| 42577 | 212685 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 57 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5990825.48012 | 2095506.36854 | 37.7333335775765 | -122.474121809996 | (37.7333335775765, -122.474121809996) | 1 | 8 | 4 | 64 | 40 | |||
| 43050 | 212619 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 123 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991404.11082 | 2090016.7036 | 37.718293824676 | -122.471721416918 | (37.718293824676, -122.471721416918) | 9 | 8 | 6 | 64 | 24 | |||
| 43152 | 214251 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 470 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998963.14193 | 2095000.98839 | 37.7324139668331 | -122.445951428216 | (37.7324139668331, -122.445951428216) | 9 | 7 | 4 | 59 | 40 | |||
| 44612 | 185131 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2665 34th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985814.4377 | 2097199.1641 | 37.7376899897949 | -122.491570691472 | (37.7376899897949, -122.491570691472) | 1 | 8 | 3 | 29491 | 35 | |||
| 46967 | 212633 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 338 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992228.53387 | 2090118.36082 | 37.7186206158303 | -122.468879153643 | (37.7186206158303, -122.468879153643) | 9 | 8 | 6 | 64 | 24 | |||
| 47128 | 237592 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 39 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6000911.96408 | 2104271.56125 | 37.7579798462996 | -122.439878363121 | (37.7579798462996, -122.439878363121) | 2 | 4 | 5 | 28862 | 38 | |||
| 47976 | 135834 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6008624.12392 | 2119028.66096 | 37.7989353167715 | -122.414250438519 | (37.7989353167715, -122.414250438519) | 5 | 1 | 10 | 308 | 32 | |||
| 49060 | 94369 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 899@ Fulton 27th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.7726215084612 | -122.486483556825 | (37.7726215084612, -122.486483556825) | 11 | 6 | 2 | 55 | 26 | |||
| 49513 | 135705 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 71 Collins St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5998103.88222 | 2114203.23453 | 37.7850894291786 | -122.450305763004 | (37.7850894291786, -122.450305763004) | 15 | 6 | 1 | 54 | 31 | ||||
| 52032 | 135836 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6008591.77677 | 2119025.88036 | 37.7989258649019 | -122.41436217388 | (37.7989258649019, -122.41436217388) | 5 | 1 | 10 | 308 | 32 | |||
| 52046 | 212583 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 769 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5997015.86824 | 2094973.70242 | 37.7322276605726 | -122.452681605484 | (37.7322276605726, -122.452681605484) | 9 | 7 | 4 | 59 | 40 | |||
| 52674 | 214239 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 235 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5999201.62865 | 2095749.05127 | 37.7344815864478 | -122.445180689449 | (37.7344815864478, -122.445180689449) | 9 | 7 | 4 | 59 | 40 | |||
| 52932 | 178802 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 428 Amherst St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6007745.17316 | 2091797.30343 | 37.7241148979791 | -122.415363080637 | (37.7241148979791, -122.415363080637) | 9 | 3 | 7 | 309 | 28 | |||
| 54686 | 196138 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 801 Arkansas St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6013054.7193 | 2103811.53724 | 37.7574004490986 | -122.39785101412 | (37.7574004490986, -122.39785101412) | 10 | 3 | 8 | 28856 | 29 | ||||
| 55360 | 178781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 243 Ottawa Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5998332.41388 | 2089291.42657 | 37.7167008060656 | -122.447721115953 | (37.7167008060656, -122.447721115953) | 9 | 7 | 6 | 28861 | 25 | |||
| 56863 | 123188 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 583 09th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993119.2006 | 2111506.41718 | 37.7773981711119 | -122.467354883251 | (37.7773981711119, -122.467354883251) | 11 | 6 | 2 | 54 | 11 | |||
| 57239 | 135704 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Masonic Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998891.86362 | 2113914.57121 | 37.7843418992035 | -122.447558819796 | (37.7843418992035, -122.447558819796) | 15 | 6 | 1 | 54 | 31 | |||
| 58252 | 212678 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 29 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5990819.11641 | 2095735.96999 | 37.7339636363128 | -122.47416055818 | (37.7339636363128, -122.47416055818) | 1 | 8 | 4 | 64 | 40 | |||
| 60978 | 178699 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 17 Sala Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 5999039.32435 | 2088222.29438 | 37.7138055898272 | -122.44520086393 | (37.7138055898272, -122.44520086393) | 9 | 7 | 6 | 28861 | 25 | |||
| 66021 | 237650 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 613 Sanchez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003691.30859 | 2104707.131 | 37.7593336353469 | -122.430297289981 | (37.7593336353469, -122.430297289981) | 2 | 4 | 5 | 28862 | 3 | |||
| 66672 | 237621 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 310 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6002065.57752 | 2104041.16224 | 37.7574128264583 | -122.435872199967 | (37.7574128264583, -122.435872199967) | 2 | 4 | 5 | 28862 | 3 | |||
| 67311 | 201975 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013711.44714 | 2092234.27571 | 37.7256482627537 | -122.394769010484 | (37.7256482627537, -122.394769010484) | 10 | 3 | 8 | 58 | 1 | ||||
| 68389 | 237652 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4045 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6003417.6007 | 2104164.25364 | 37.7578275164429 | -122.431205154696 | (37.7578275164429, -122.431205154696) | 2 | 4 | 5 | 28862 | 3 | |||
| 69130 | 212679 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5990820.47866 | 2095690.23896 | 37.7338381494169 | -122.474152512843 | (37.7338381494169, -122.474152512843) | 1 | 8 | 4 | 64 | 40 | |||
| 74533 | 135835 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6008609.07224 | 2119027.30535 | 37.7989307491201 | -122.414302426519 | (37.7989307491201, -122.414302426519) | 5 | 1 | 10 | 308 | 32 | |||
| 75185 | 212677 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 916 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5991577.34612 | 2089232.98657 | 37.7161519507271 | -122.471065557542 | (37.7161519507271, -122.471065557542) | 9 | 8 | 6 | 64 | 24 | |||
| 75917 | 124630 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 749 Euclid Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5995936.92789 | 2113773.7221 | 37.7837858514667 | -122.457771606363 | (37.7837858514667, -122.457771606363) | 11 | 6 | 1 | 54 | 31 | |||
| 76131 | 213104 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 71 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998559.80526 | 2095918.15558 | 37.7349092509549 | -122.447411843581 | (37.7349092509549, -122.447411843581) | 9 | 7 | 4 | 59 | 40 | |||
| 76446 | 178757 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 475 Country Club Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5984730.24902 | 2094611.59389 | 37.7305217923373 | -122.495128441421 | (37.7305217923373, -122.495128441421) | 1 | 8 | 4 | 64 | 35 | |||
| 78759 | 212880 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1856 17th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5990966.0543 | 2102781.91653 | 37.7533184991505 | -122.474166496407 | (37.7533184991505, -122.474166496407) | 1 | 8 | 4 | 56 | 12 | |||
| 79330 | 202168 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Kalmanovitz St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6013157.76295 | 2093232.82928 | 37.7283592870497 | -122.396753038148 | (37.7283592870497, -122.396753038148) | 10 | 3 | 8 | 58 | 1 | |||
| 80104 | 123152 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 506 10th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5992856.05195 | 2111969.64084 | 37.7786548628959 | -122.468298900299 | (37.7786548628959, -122.468298900299) | 11 | 6 | 2 | 54 | 11 | |||
| 80924 | 135806 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 22 Aladdin Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008809.71493 | 2119549.22227 | 37.8003750720026 | -122.413645068874 | (37.8003750720026, -122.413645068874) | 3 | 1 | 10 | 308 | 32 | |||
| 81304 | 212618 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 158 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991450.23786 | 2090240.56685 | 37.7189111669923 | -122.471578280835 | (37.7189111669923, -122.471578280835) | 9 | 8 | 6 | 64 | 24 | |||
| 81877 | 212913 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1805 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5992793.90733 | 2103137.66659 | 37.7544010140192 | -122.467871330222 | (37.7544010140192, -122.467871330222) | 1 | 8 | 4 | 56 | 12 | |||
| 82113 | 212934 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1964 17th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 9ft | 5990996.33052 | 2102040.26003 | 37.7512838585661 | -122.474007688698 | (37.7512838585661, -122.474007688698) | 1 | 8 | 4 | 29491 | 12 | |||
| 82596 | 212680 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 30 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5990862.6136 | 2095693.98036 | 37.7338508631143 | -122.474007114039 | (37.7338508631143, -122.474007114039) | 1 | 8 | 4 | 64 | 40 | |||
| 83024 | 123122 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 624 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5992573.24713 | 2111201.55414 | 37.7765295670124 | -122.469221303936 | (37.7765295670124, -122.469221303936) | 11 | 6 | 2 | 54 | 11 | |||
| 85852 | 124229 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 219 Stanyan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5996620.97687 | 2111333.86588 | 37.7771259241055 | -122.455228688695 | (37.7771259241055, -122.455228688695) | 11 | 6 | 2 | 54 | 16 | |||
| 86407 | 201978 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6013680.98178 | 2092258.06513 | 37.7257118897673 | -122.394875992933 | (37.7257118897673, -122.394875992933) | 10 | 3 | 8 | 58 | 1 | ||||
| 86479 | 196128 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2098 20th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6011883.81228 | 2104698.03976 | 37.7597693110244 | -122.401962817046 | (37.7597693110244, -122.401962817046) | 10 | 3 | 8 | 28856 | 29 | |||
| 89075 | 135831 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008642.51144 | 2119028.50949 | 37.7989359337052 | -122.414186800682 | (37.7989359337052, -122.414186800682) | 5 | 1 | 10 | 308 | 32 | |||
| 93730 | 178803 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 428 Amherst St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6007743.47249 | 2091796.14538 | 37.7241116226352 | -122.415368877669 | (37.7241116226352, -122.415368877669) | 9 | 3 | 7 | 309 | 28 | |||
| 94642 | 212623 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 222 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5991708.59487 | 2090008.32571 | 37.7182884332397 | -122.470668344073 | (37.7182884332397, -122.470668344073) | 9 | 8 | 6 | 64 | 24 | |||
| 94778 | 135852 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 13 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008609.879 | 2119160.01046 | 37.7992951697024 | -122.414309029333 | (37.7992951697024, -122.414309029333) | 5 | 1 | 10 | 308 | 32 | ||||
| 95572 | 123381 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 741 03rd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5995015.45023 | 2110521.81461 | 37.7748040007041 | -122.46072380906 | (37.7748040007041, -122.46072380906) | 11 | 6 | 2 | 54 | 11 | ||||
| 95795 | 123151 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 506 10th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5992855.02904 | 2111985.99608 | 37.7786997108705 | -122.46830362906 | (37.7786997108705, -122.46830362906) | 11 | 6 | 2 | 54 | 11 | |||
| 97321 | 212658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 339 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5993218.69942 | 2089441.88827 | 37.7168203421713 | -122.465407468378 | (37.7168203421713, -122.465407468378) | 9 | 8 | 6 | 64 | 24 | ||||
| 102148 | 202169 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Kalmanovitz St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 6013155.46174 | 2093221.34239 | 37.7283276183124 | -122.396760188629 | (37.7283276183124, -122.396760188629) | 10 | 3 | 8 | 58 | 1 | |||
| 102284 | 135828 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008658.00325 | 2119030.21476 | 37.7989414861063 | -122.414133314422 | (37.7989414861063, -122.414133314422) | 5 | 1 | 10 | 308 | 32 | |||
| 102816 | 178818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Ina Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6004783.72135 | 2091297.0719 | 37.722574479812 | -122.425564792981 | (37.722574479812, -122.425564792981) | 9 | 7 | 6 | 28861 | 5 | ||||
| 103442 | 236719 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 541 Grand View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6000042.149 | 2101703.3311 | 37.7508785611156 | -122.442702138095 | (37.7508785611156, -122.442702138095) | 2 | 4 | 5 | 28862 | 22 | |||
| 103749 | 212626 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 315 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5991670.94588 | 2090561.38472 | 37.719804820616 | -122.470838744014 | (37.719804820616, -122.470838744014) | 9 | 8 | 6 | 64 | 24 | |||
| 103976 | 213117 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 107 Bella Vista Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998491.69909 | 2097031.09609 | 37.737961228022 | -122.447727403094 | (37.737961228022, -122.447727403094) | 9 | 7 | 4 | 59 | 40 | |||
| 105098 | 212668 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 162 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992987.49956 | 2088299.56272 | 37.7136704541029 | -122.466123641711 | (37.7136704541029, -122.466123641711) | 9 | 8 | 6 | 64 | 24 | |||
| 105251 | 212585 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 154 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5999046.49545 | 2093810.20287 | 37.7291491085375 | -122.445577658299 | (37.7291491085375, -122.445577658299) | 9 | 7 | 4 | 28861 | 40 | ||||
| 106095 | 214242 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 235 Stillings Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5999236.96696 | 2095747.8899 | 37.7344804146247 | -122.445058430207 | (37.7344804146247, -122.445058430207) | 9 | 7 | 4 | 59 | 40 | |||
| 108923 | 214243 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 235 Stillings Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5999250.24874 | 2095747.61382 | 37.7344804146331 | -122.445012491029 | (37.7344804146331, -122.445012491029) | 9 | 7 | 4 | 59 | 40 | |||
| 110251 | 249629 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2498 Golden Gate Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997572.14406 | 2111315.29965 | 37.7771294721856 | -122.451936978525 | (37.7771294721856, -122.451936978525) | 15 | 6 | 2 | 54 | 16 | |||
| 110661 | 212877 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1681 17th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5990867.871 | 2103995.80014 | 37.7566458153716 | -122.474594615958 | (37.7566458153716, -122.474594615958) | 1 | 8 | 4 | 56 | 12 | |||
| 110938 | 212667 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 412 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993789.73455 | 2089863.57128 | 37.7180110994161 | -122.463464279867 | (37.7180110994161, -122.463464279867) | 9 | 8 | 6 | 64 | 24 | |||
| 111743 | 212664 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 752 Head St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993542.32801 | 2090823.31232 | 37.7206320593021 | -122.464389093183 | (37.7206320593021, -122.464389093183) | 9 | 8 | 6 | 64 | 24 | |||
| 113582 | 196137 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 801 Arkansas St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6013055.93777 | 2103788.34053 | 37.7573368238503 | -122.397845173025 | (37.7573368238503, -122.397845173025) | 10 | 3 | 8 | 28856 | 29 | ||||
| 114815 | 135757 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2646 Broderick St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000168.56183 | 2117716.69184 | 37.794854408249 | -122.443415101746 | (37.794854408249, -122.443415101746) | 13 | 9 | 1 | 57 | 27 |
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) );