Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128 | 128 | 212622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991392.0 | 2089980.0 | 37.718192344870296 | -122.471760605115 | (37.7181923448703, -122.471760605115) | |||
| 2593 | 2593 | 155952 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/20/2017 12:00:00 AM | 3 | 5993448.18795 | 2093194.64055 | 37.7271377226027 | -122.464886627823 | (37.7271377226027, -122.464886627823) | |||
| 3523 | 3523 | 253474 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 4757 | 4757 | 179682 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 501X San Juan Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6000425.2781 | 2092808.87665 | 37.726478317196204 | -122.44073930839 | (37.7264783171962, -122.44073930839) | |||
| 18402 | 18402 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | |||
| 22299 | 22299 | 179788 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6004749.24947 | 2094369.67329 | 37.731009216793296 | -122.425902563064 | (37.7310092167933, -122.425902563064) | ||||
| 23463 | 23463 | 185056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 82 Crestlake Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5988580.6885 | 2096305.5585 | 37.735397653561 | -122.481941107831 | (37.735397653561, -122.481941107831) | |||
| 23596 | 23596 | 179735 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6004922.43107 | 2094357.6156 | 37.7309858946841 | -122.42530298683701 | (37.7309858946841, -122.425302986837) | |||
| 23779 | 23779 | 213682 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000730.9848 | 2095013.8875 | 37.7325501736469 | -122.43984052053801 | (37.7325501736469, -122.439840520538) | |||
| 24054 | 24054 | 179073 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 Otsego Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6000546.4255099995 | 2092093.61368 | 37.724521267414296 | -122.440269236362 | (37.7245212674143, -122.440269236362) | |||
| 24246 | 24246 | 123150 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 530 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5992860.06337 | 2111844.7190400003 | 37.778312093174 | -122.468275933095 | (37.778312093174, -122.468275933095) | |||
| 24307 | 24307 | 215245 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 318 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5992229.521269999 | 2090002.05617 | 37.7183013286233 | -122.468867281705 | (37.7183013286233, -122.468867281705) | |||
| 24350 | 24350 | 214468 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 623 Gennessee St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5997445.526980001 | 2095470.2100900002 | 37.7336155617911 | -122.451231980178 | (37.7336155617911, -122.451231980178) | |||
| 24369 | 24369 | 237998 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 338 Hoffman Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000611.91644 | 2101788.98208 | 37.7511462020375 | -122.440737977395 | (37.7511462020375, -122.440737977395) | |||
| 24513 | 24513 | 213290 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.721017116620004 | -122.46235759304399 | (37.72101711662, -122.462357593044) | |||
| 24615 | 24615 | 212913 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1805 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992793.90733 | 2103137.66659 | 37.7544010140192 | -122.467871330222 | (37.7544010140192, -122.467871330222) | |||
| 24851 | 24851 | 237592 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 39 Seward St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6000911.96408 | 2104271.56125 | 37.7579798462996 | -122.439878363121 | (37.7579798462996, -122.439878363121) | |||
| 24895 | 24895 | 179744 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6004895.55112 | 2094358.6043 | 37.730987090783 | -122.425395985741 | (37.730987090783, -122.425395985741) | |||
| 24973 | 24973 | 179783 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6004773.760559999 | 2094370.4753299998 | 37.7310128042003 | -122.42581788109501 | (37.7310128042003, -122.425817881095) | ||||
| 24980 | 24980 | 213333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991918.76578 | 2089524.2789200002 | 37.7169715101175 | -122.469906655166 | (37.7169715101175, -122.469906655166) | |||
| 25056 | 25056 | 136041 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3399 Jackson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5998034.28644 | 2116116.0882900003 | 37.7903376361102 | -122.450684503481 | (37.7903376361102, -122.450684503481) | |||
| 25245 | 25245 | 179675 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1183 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6003399.47661 | 2094250.7820700002 | 37.7306063951513 | -122.430560473899 | (37.7306063951513, -122.430560473899) | |||
| 25772 | 25772 | 179691 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 425 Pioche St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6005621.06817 | 2093204.8072799998 | 37.72785998252721 | -122.422805780863 | (37.7278599825272, -122.422805780863) | |||
| 25908 | 25908 | 214251 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 470 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998963.14193 | 2095000.98839 | 37.7324139668331 | -122.445951428216 | (37.7324139668331, -122.445951428216) | |||
| 26039 | 26039 | 236674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4301 26th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6001900.9288 | 2100573.2486400004 | 37.747881410301 | -122.436193451291 | (37.747881410301, -122.436193451291) | |||
| 26282 | 26282 | 196130 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 582 Rhode Island St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6011755.76075 | 2105663.76681 | 37.7624138349597 | -122.402473594197 | (37.7624138349597, -122.402473594197) | ||||
| 27129 | 27129 | 136601 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1900 Jefferson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6000030.07826 | 2121297.6398099996 | 37.80467883793111 | -122.444151713048 | (37.8046788379311, -122.444151713048) | |||
| 27296 | 27296 | 213681 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6000730.35653 | 2095033.04499 | 37.7326027399078 | -122.439844065674 | (37.7326027399078, -122.439844065674) | |||
| 27498 | 27498 | 179751 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6004881.94818 | 2094356.48865 | 37.7309805131181 | -122.42544286291901 | (37.7309805131181, -122.425442862919) | |||
| 28334 | 28334 | 186775 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984844.3759 | 2106784.0328 | 37.7639506692175 | -122.495631381575 | (37.7639506692175, -122.495631381575) | |||
| 28471 | 28471 | 135727 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3170 Sacramento St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5999594.80396 | 2115410.0134799997 | 37.7884881407547 | -122.44523445452299 | (37.7884881407547, -122.445234454523) | |||
| 28486 | 28486 | 212659 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 335 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5993217.881709999 | 2089418.2439299999 | 37.7167553733424 | -122.465408578168 | (37.7167553733424, -122.465408578168) | ||||
| 28522 | 28522 | 179728 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6004946.07219 | 2094358.6538200001 | 37.730990081010106 | -122.4252213293 | (37.7309900810101, -122.4252213293) | |||
| 28657 | 28657 | 119518 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 774 31st Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5986356.81834 | 2110650.14553 | 37.774654382283295 | -122.490684840834 | (37.7746543822833, -122.490684840834) | |||
| 29016 | 29016 | 179696 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1317 Felton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6007086.79477 | 2092691.09915 | 37.72653204271771 | -122.417702322507 | (37.7265320427177, -122.417702322507) | |||
| 29059 | 29059 | 214419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 479 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5992969.97647 | 2090349.4269700001 | 37.7192978763685 | -122.466333093823 | (37.7192978763685, -122.466333093823) | |||
| 29456 | 29456 | 179778 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 6004787.32766 | 2094370.8495200002 | 37.731014598327796 | -122.42577100392799 | (37.7310145983278, -122.425771003928) | |||
| 29577 | 29577 | 213706 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 1444 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5990875.43177 | 2105581.50007 | 37.7610001645442 | -122.474684197434 | (37.7610001645442, -122.474684197434) | |||
| 29740 | 29740 | 178803 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 428 Amherst St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6007743.472490001 | 2091796.14538 | 37.7241116226352 | -122.415368877669 | (37.7241116226352, -122.415368877669) | |||
| 29834 | 29834 | 215244 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 290 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5991718.94325 | 2090452.86708 | 37.7195096334551 | -122.470664935645 | (37.7195096334551, -122.470664935645) | |||
| 30249 | 30249 | 212644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 385 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992447.09906 | 2090440.19057 | 37.7195169071729 | -122.46814706775 | (37.7195169071729, -122.46814706775) | |||
| 30258 | 30258 | 179786 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004760.18002 | 2094369.44832 | 37.7310092167964 | -122.425864758274 | (37.7310092167964, -122.425864758274) | ||||
| 30400 | 30400 | 179785 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6004765.43097 | 2094369.55773 | 37.7310098139557 | -122.42584661262501 | (37.7310098139557, -122.425846612625) | ||||
| 30458 | 30458 | 179736 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6004921.59693 | 2094359.59302 | 37.730991277113795 | -122.425306011263 | (37.7309912771138, -122.425306011263) | |||
| 30499 | 30499 | 136628 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 35 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6007442.68945 | 2119347.6765099997 | 37.7997448199195 | -122.418361234195 | (37.7997448199195, -122.418361234195) | |||
| 30565 | 30565 | 238390 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 80 Collingwood St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001989.17062 | 2105400.26005 | 37.7611402393495 | -122.436233705824 | (37.7611402393495, -122.436233705824) | |||
| 30690 | 30690 | 135882 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2431 Jones St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6007964.86831 | 2120685.23293 | 37.803446794585795 | -122.41664910307199 | (37.8034467945858, -122.416649103072) | |||
| 30957 | 30957 | 212587 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 147 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998729.2739699995 | 2093442.0374900002 | 37.7281200970646 | -122.446647836227 | (37.7281200970646, -122.446647836227) | |||
| 31098 | 31098 | 212655 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 494 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5993275.23376 | 2090421.34929 | 37.7195129663325 | -122.46528316408998 | (37.7195129663325, -122.46528316409) | |||
| 31260 | 31260 | 179729 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6004942.13253 | 2094358.51707 | 37.730989482957895 | -122.42523493965099 | (37.7309894829579, -122.425234939651) | |||
| 31891 | 31891 | 214268 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 654 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5997738.617219999 | 2095021.34514 | 37.7323998627676 | -122.45018634383601 | (37.7323998627676, -122.450186343836) | |||
| 32155 | 32155 | 202169 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Kalmanovitz St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 1ft | 6013155.46174 | 2093221.3423900001 | 37.7283276183124 | -122.396760188629 | (37.7283276183124, -122.396760188629) | |||
| 32300 | 32300 | 196138 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 801 Arkansas St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6013054.7193 | 2103811.53724 | 37.757400449098604 | -122.39785101412 | (37.7574004490986, -122.39785101412) | ||||
| 32334 | 32334 | 213694 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 219 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998610.14505 | 2093760.09504 | 37.728986602838205 | -122.447082546947 | (37.7289866028382, -122.447082546947) | ||||
| 32614 | 32614 | 213347 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 529 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5993232.83209 | 2090695.6130099997 | 37.7202635827786 | -122.465449643 | (37.7202635827786, -122.465449643) | |||
| 32816 | 32816 | 202152 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1951 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6013046.17664 | 2093441.4035900002 | 37.7289257780866 | -122.397153419018 | (37.7289257780866, -122.397153419018) | |||
| 33059 | 33059 | 135939 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Walnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998471.02227 | 2116380.3328400003 | 37.7910881707365 | -122.44919247964701 | (37.7910881707365, -122.449192479647) | |||
| 33076 | 33076 | 214242 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 235 Stillings Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5999236.96696 | 2095747.8899 | 37.734480414624706 | -122.445058430207 | (37.7344804146247, -122.445058430207) | |||
| 33171 | 33171 | 179639 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 286 Foote Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5998303.30516 | 2088729.74058 | 37.7151568814675 | -122.447781316552 | (37.7151568814675, -122.447781316552) | |||
| 33220 | 33220 | 212458 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 768 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5994909.71426 | 2093167.9276299998 | 37.7271485351522 | -122.45983224818501 | (37.7271485351522, -122.459832248185) | |||
| 33226 | 33226 | 212679 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Beachmont Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5990820.47866 | 2095690.2389599998 | 37.7338381494169 | -122.474152512843 | (37.7338381494169, -122.474152512843) | |||
| 33407 | 33407 | 179702 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1142 Silliman St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6007383.5399400005 | 2093322.51563 | 37.7282824705509 | -122.41672119542801 | (37.7282824705509, -122.416721195428) | |||
| 33570 | 33570 | 179741 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6004901.636469999 | 2094356.73695 | 37.7309823072691 | -122.42537481481101 | (37.7309823072691, -122.425374814811) | |||
| 33659 | 33659 | 179635 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 9 Moneta Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997908.32309 | 2088048.3986 | 37.7132634892865 | -122.44909748427601 | (37.7132634892865, -122.449097484276) | ||||
| 33665 | 33665 | 179793 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 629 Hamilton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6009759.65206 | 2091562.25484 | 37.7235825209091 | -122.408382730001 | (37.7235825209091, -122.408382730001) | |||
| 33866 | 33866 | 179632 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1277 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5999581.03215 | 2090102.7419900002 | 37.718999778104795 | -122.443463521241 | (37.7189997781048, -122.443463521241) | |||
| 34028 | 34028 | 213114 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Omar Way | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998118.31509 | 2097542.20212 | 37.7393432548731 | -122.449055178356 | (37.7393432548731, -122.449055178356) | |||
| 34055 | 34055 | 179782 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6004777.69099 | 2094370.17663 | 37.7310122061496 | -122.425804271672 | (37.7310122061496, -122.425804271672) | ||||
| 34250 | 34250 | 241035 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 683 Duncan St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6002140.9869099995 | 2099704.66458 | 37.745510119292 | -122.435301222178 | (37.745510119292, -122.435301222178) | |||
| 34396 | 34396 | 179657 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 570 Edinburgh St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6002562.8789099995 | 2090358.04011 | 37.7198703712871 | -122.433174679891 | (37.7198703712871, -122.433174679891) | |||
| 34688 | 34688 | 239029 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 26 Harry St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003326.300869999 | 2097748.91757 | 37.740207332512796 | -122.431063031234 | (37.7402073325128, -122.431063031234) | |||
| 34878 | 34878 | 212667 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 412 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5993789.73455 | 2089863.57128 | 37.7180110994161 | -122.463464279867 | (37.7180110994161, -122.463464279867) | |||
| 35134 | 35134 | 214474 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 231 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998536.47989 | 2093762.7157299998 | 37.7289895894874 | -122.447337400427 | (37.7289895894874, -122.447337400427) | ||||
| 35170 | 35170 | 179653 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 570 Edinburgh St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6002670.92192 | 2090527.15665 | 37.7203408561316 | -122.43281328822201 | (37.7203408561316, -122.432813288222) | |||
| 35245 | 35245 | 179766 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6004833.3420400005 | 2094364.4580400002 | 37.7309996489081 | -122.425611469595 | (37.7309996489081, -122.425611469595) | |||
| 35627 | 35627 | 214221 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 144 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6000463.1265199995 | 2095257.0070900002 | 37.7332024726215 | -122.44078400199699 | (37.7332024726215, -122.440784001997) | ||||
| 36090 | 36090 | 124683 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3899 Jackson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5995553.12452 | 2115771.60073 | 37.789249431740295 | -122.459244137371 | (37.7892494317403, -122.459244137371) | |||
| 36320 | 36320 | 212934 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1964 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 5990996.330519999 | 2102040.26003 | 37.751283858566104 | -122.47400768869801 | (37.7512838585661, -122.474007688698) | |||
| 36378 | 36378 | 178800 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Princeton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6008027.45015 | 2091896.60863 | 37.7244034301488 | -122.41439431206699 | (37.7244034301488, -122.414394312067) | |||
| 36502 | 36502 | 214815 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 655 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5997076.755580001 | 2094378.60032 | 37.73059714113489 | -122.452428176541 | (37.7305971411349, -122.452428176541) | |||
| 36555 | 36555 | 212583 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 769 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997015.86824 | 2094973.70242 | 37.7322276605726 | -122.452681605484 | (37.7322276605726, -122.452681605484) | |||
| 36563 | 36563 | 202259 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1 Kalmanovitz St | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6013218.01399 | 2093376.8881599999 | 37.7287581966316 | -122.396554840154 | (37.7287581966316, -122.396554840154) | ||||
| 36648 | 36648 | 136020 | Undocumented 2 | Prunus spp :: Cherry 84 | 1477 Green St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6006004.56438 | 2118595.56069 | 37.7975986409201 | -122.423284189634 | (37.7975986409201, -122.423284189634) | |||
| 36691 | 36691 | 237667 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4749 18th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5999715.49796 | 2104975.36146 | 37.7598441283126 | -122.44406680625 | (37.7598441283126, -122.44406680625) | |||
| 37063 | 37063 | 213321 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5991673.594880001 | 2090710.5616 | 37.7202145769251 | -122.470840448236 | (37.7202145769251, -122.470840448236) | |||
| 37561 | 37561 | 135901 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008342.534990001 | 2119419.33537 | 37.7999921901354 | -122.415252502723 | (37.7999921901354, -122.415252502723) | ||||
| 37655 | 37655 | 213628 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 518 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5997988.71827 | 2097660.25448 | 37.739659985321495 | -122.449511768669 | (37.7396599853215, -122.449511768669) | |||
| 38115 | 38115 | 123151 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 506 10th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5992855.02904 | 2111985.99608 | 37.7786997108705 | -122.46830362906 | (37.7786997108705, -122.46830362906) | |||
| 38234 | 38234 | 179776 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 6004793.39482 | 2094368.1113 | 37.7310074226383 | -122.42574983389 | (37.7310074226383, -122.42574983389) | |||
| 38858 | 38858 | 238309 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 84 Seward St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000741.11024 | 2104546.1812 | 37.758724158512 | -122.44048894251301 | (37.758724158512, -122.440488942513) | |||
| 38990 | 38990 | 178757 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 475 Country Club Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5984730.24902 | 2094611.5938900001 | 37.7305217923373 | -122.49512844142099 | (37.7305217923373, -122.495128441421) | |||
| 39187 | 39187 | 178946 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 25 Madison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6005433.25 | 2093389.63985 | 37.7283568930528 | -122.42346820799 | (37.7283568930528, -122.42346820799) | |||
| 39424 | 39424 | 215233 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 381 Flood Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998173.02333 | 2094066.3332099998 | 37.7298024758896 | -122.44861574981199 | (37.7298024758896, -122.448615749812) | |||
| 39666 | 39666 | 213322 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991674.008280001 | 2090730.18875 | 37.720268492169296 | -122.470840448222 | (37.7202684921693, -122.470840448222) | |||
| 39951 | 39951 | 179747 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6004888.75202 | 2094357.6554900003 | 37.730984101417704 | -122.42541942389299 | (37.7309841014177, -122.425419423893) | |||
| 40048 | 40048 | 214790 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valdez Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5995727.44967 | 2095481.9792400002 | 37.7335493555041 | -122.45717268576401 | (37.7335493555041, -122.457172685764) | |||
| 40064 | 40064 | 136617 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1075 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6006167.26583 | 2120699.80075 | 37.803385530067104 | -122.422870825248 | (37.8033855300671, -122.422870825248) | |||
| 40188 | 40188 | 213362 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Elmhurst Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991224.3842 | 2094533.07073 | 37.730684246775205 | -122.472671762002 | (37.7306842467752, -122.472671762002) | |||
| 40432 | 40432 | 214284 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 317 Staples Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998054.67 | 2093771.8404599999 | 37.728987100156395 | -122.44900370298099 | (37.7289871001564, -122.449003702981) | |||
| 40633 | 40633 | 179692 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 425 Pioche St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6005640.05215 | 2093208.69537 | 37.7278717294828 | -122.42274042892299 | (37.7278717294828, -122.422740428923) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");