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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 120993 | 120993 | 94368 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 899@ Fulton 27th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.77262150846121 | -122.48648355682501 | (37.7726215084612, -122.486483556825) | |||
| 81316 | 81316 | 94369 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 899@ Fulton 27th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.77262150846121 | -122.48648355682501 | (37.7726215084612, -122.486483556825) | |||
| 140594 | 140594 | 94706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/29/2010 12:00:00 AM | 6 | Permit Number 53868 | 5994701.2 | 2098925.3 | 37.7429448703691 | -122.460970181408 | (37.7429448703691, -122.460970181408) | ||
| 86950 | 86950 | 94707 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/29/2010 12:00:00 AM | 6 | Permit Number 53868 | 5994701.2 | 2098925.3 | 37.7429448703691 | -122.460970181408 | (37.7429448703691, -122.460970181408) | ||
| 88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
| 92324 | 92324 | 96987 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 114167 | 114167 | 99706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 119703 | 119703 | 99707 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 113083 | 113083 | 99708 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 101806 | 101806 | 99709 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 90054 | 90054 | 99710 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 139212 | 139212 | 99711 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 77900 | 77900 | 99712 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 82574 | 82574 | 107467 | Permitted Site 1 | Prunus sargentii 'Columnaris' :: Sargent Cherry Tree 'Columnaris' 473 | 1643 35th Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 773410 | 5985268.14341 | 2104019.02784 | 37.7563835411873 | -122.493961929435 | (37.7563835411873, -122.493961929435) | |||
| 118775 | 118775 | 107677 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 305 NEVADA ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 3x12 | 6008988.2 | 2096819.7 | 37.7379751095359 | -122.411420761527 | (37.7379751095359, -122.411420761527) | |||
| 90025 | 90025 | 110868 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 800 INDIANA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 100600 | 100600 | 110872 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 800 INDIANA ST | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 144517 | 144517 | 110873 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 800 INDIANA ST | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 81044 | 81044 | 110874 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 800 INDIANA ST | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 153533 | 153533 | 117710 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | |||
| 175612 | 175612 | 118209 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 574 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5985058.9891 | 2111965.86595 | 37.7781910764099 | -122.495271274867 | (37.7781910764099, -122.495271274867) | |||
| 114681 | 114681 | 119273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 3x3 | 5993437.0 | 2093200.0 | 37.727151793263296 | -122.464925693193 | (37.7271517932633, -122.464925693193) | |||
| 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) | |||
| 187822 | 187822 | 119519 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 774 31st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5986356.00779 | 2110632.6752299997 | 37.7746063664364 | -122.49068635897301 | (37.7746063664364, -122.490686358973) | |||
| 180478 | 180478 | 119520 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 774 31st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5986359.0703 | 2110632.1730299997 | 37.774605166430504 | -122.490675728333 | (37.7746051664305, -122.490675728333) | |||
| 169371 | 169371 | 122246 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Lake St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5990773.91586 | 2114787.49655 | 37.7862714344835 | -122.47570756157499 | (37.7862714344835, -122.475707561575) | |||
| 74340 | 74340 | 122249 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1600 Clement St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5990532.83595 | 2113421.55221 | 37.7825069529614 | -122.47644180764799 | (37.7825069529614, -122.476441807648) | |||
| 136416 | 136416 | 122250 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1600 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5990504.56786 | 2113419.1912 | 37.7824988308057 | -122.476539429393 | (37.7824988308057, -122.476539429393) | |||
| 177744 | 177744 | 122252 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1600 Clement St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5990423.373269999 | 2113418.9345299997 | 37.7824934165268 | -122.47682030563499 | (37.7824934165268, -122.476820305635) | |||
| 50433 | 50433 | 123122 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 624 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5992573.24713 | 2111201.55414 | 37.7765295670124 | -122.46922130393601 | (37.7765295670124, -122.469221303936) | |||
| 54381 | 54381 | 123144 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 572 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5992865.77571 | 2111587.1444200003 | 37.7776051929209 | -122.46823742950501 | (37.7776051929209, -122.468237429505) | |||
| 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) | |||
| 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) | |||
| 74862 | 74862 | 123152 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 506 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992856.05195 | 2111969.64084 | 37.7786548628959 | -122.46829890029899 | (37.7786548628959, -122.468298900299) | |||
| 188524 | 188524 | 123164 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 567 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5992805.53108 | 2111610.19032 | 37.7776649910865 | -122.46844751130399 | (37.7776649910865, -122.468447511304) | ||||
| 161259 | 161259 | 123188 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 583 09th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5993119.2006 | 2111506.41718 | 37.7773981711119 | -122.467354883251 | (37.7773981711119, -122.467354883251) | |||
| 178841 | 178841 | 123381 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 741 03rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5995015.450230001 | 2110521.81461 | 37.7748040007041 | -122.46072380906 | (37.7748040007041, -122.46072380906) | ||||
| 175997 | 175997 | 124045 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 723 12th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5992223.98611 | 2110507.73124 | 37.77460432927921 | -122.470378946663 | (37.7746043292792, -122.470378946663) | |||
| 171239 | 171239 | 124046 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 723 12th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992224.36446 | 2110496.07608 | 37.7745723492368 | -122.470376788909 | (37.7745723492368, -122.470376788909) | |||
| 125065 | 125065 | 124047 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 693 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5992526.1539900005 | 2110751.1645299997 | 37.775290197576105 | -122.469351420391 | (37.7752901975761, -122.469351420391) | ||||
| 75018 | 75018 | 124048 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 693 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5992526.55561 | 2110733.67497 | 37.775242199176795 | -122.469348757796 | (37.7752421991768, -122.469348757796) | ||||
| 181872 | 181872 | 124180 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Almaden Ct | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
| 175710 | 175710 | 124184 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Almaden Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5995890.93647 | 2112594.82496 | 37.780546271753295 | -122.457845381425 | (37.7805462717533, -122.457845381425) | |||
| 137921 | 137921 | 124228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Stanyan St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5996619.11206 | 2111349.85847 | 37.7771697285711 | -122.45523629563499 | (37.7771697285711, -122.455236295635) | |||
| 132194 | 132194 | 124229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Stanyan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5996620.976869999 | 2111333.86588 | 37.7771259241055 | -122.45522868869499 | (37.7771259241055, -122.455228688695) | |||
| 134887 | 134887 | 124232 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Paramount Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5996415.548690001 | 2110976.74716 | 37.7761335815126 | -122.455913502291 | (37.7761335815126, -122.455913502291) | |||
| 44349 | 44349 | 124423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5996107.9721800005 | 2115471.34233 | 37.78845688642 | -122.45730271274401 | (37.78845688642, -122.457302712744) | |||
| 154029 | 154029 | 124424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.788413082259105 | -122.45729418503599 | (37.7884130822591, -122.457294185036) | |||
| 75053 | 75053 | 124628 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 739 Euclid Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5996019.75868 | 2113776.29204 | 37.7837976659747 | -122.457485230667 | (37.7837976659747, -122.457485230667) | |||
| 166240 | 166240 | 124629 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 749 Euclid Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5995991.233580001 | 2113774.73723 | 37.7837917583619 | -122.457583803683 | (37.7837917583619, -122.457583803683) | |||
| 183601 | 183601 | 124630 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 749 Euclid Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5995936.92789 | 2113773.7221 | 37.7837858514667 | -122.457771606363 | (37.7837858514667, -122.457771606363) | |||
| 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) | |||
| 41280 | 41280 | 124684 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3899 Jackson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5995566.4285 | 2115772.64492 | 37.7892530636592 | -122.459198183151 | (37.7892530636592, -122.459198183151) | |||
| 57093 | 57093 | 125606 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Cherry St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5996136.29839 | 2115745.93668 | 37.7892124754164 | -122.45722458116998 | (37.7892124754164, -122.45722458117) | |||
| 56547 | 56547 | 129893 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 5996283.0892 | 2114624.04425 | 37.78614048933979 | -122.45663553961701 | (37.7861404893398, -122.456635539617) | |||
| 54456 | 54456 | 130524 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 Cherry St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5996140.15322 | 2115718.74961 | 37.789138048438794 | -122.45720927651199 | (37.7891380484388, -122.457209276512) | |||
| 170790 | 170790 | 130525 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 Cherry St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5996138.91299 | 2115724.5355700003 | 37.7891538638973 | -122.45721398625 | (37.7891538638973, -122.45721398625) | |||
| 172547 | 172547 | 131074 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 110 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5996123.3175099995 | 2115792.2897200002 | 37.7893390028406 | -122.45727284778 | (37.7893390028406, -122.45727284778) | |||
| 146341 | 146341 | 131075 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 110 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5996123.96932 | 2115807.18448 | 37.7893799372718 | -122.45727167056101 | (37.7893799372718, -122.457271670561) | |||
| 46419 | 46419 | 135703 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 69 Masonic Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5998890.10615 | 2113926.10029 | 37.7843734546089 | -122.447565730187 | (37.7843734546089, -122.447565730187) | |||
| 67798 | 67798 | 135704 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 69 Masonic Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5998891.86362 | 2113914.5712099997 | 37.784341899203504 | -122.44755881979601 | (37.7843418992035, -122.447558819796) | |||
| 149537 | 149537 | 135705 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 71 Collins St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998103.88222 | 2114203.23453 | 37.7850894291786 | -122.450305763004 | (37.7850894291786, -122.450305763004) | ||||
| 55698 | 55698 | 135724 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5999982.20185 | 2115576.5673700003 | 37.7889675594589 | -122.443906093806 | (37.7889675594589, -122.443906093806) | |||
| 167904 | 167904 | 135725 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5999979.44045 | 2115594.83954 | 37.789017572549604 | -122.443916961204 | (37.7890175725496, -122.443916961204) | |||
| 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) | |||
| 180479 | 180479 | 135740 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1900 Lyon St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5999505.99761 | 2115475.33585 | 37.7886624293634 | -122.44554640865101 | (37.7886624293634, -122.445546408651) | |||
| 153991 | 153991 | 135757 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2646 Broderick St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000168.56183 | 2117716.69184 | 37.794854408249 | -122.44341510174601 | (37.794854408249, -122.443415101746) | |||
| 76763 | 76763 | 135798 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Phoenix Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6008602.032930001 | 2117913.0115900002 | 37.795870778879 | -122.41424790421001 | (37.795870778879, -122.41424790421) | |||
| 70955 | 70955 | 135799 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Phoenix Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6008603.37941 | 2117901.29377 | 37.7958386802699 | -122.41424241565399 | (37.7958386802699, -122.414242415654) | |||
| 178508 | 178508 | 135800 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 16 Phoenix Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6008612.60281 | 2117902.3687 | 37.7958421498461 | -122.414210576953 | (37.7958421498461, -122.414210576953) | |||
| 44735 | 44735 | 135801 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 16 Phoenix Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6008610.92916 | 2117913.61927 | 37.795872947126206 | -122.414217164494 | (37.7958729471262, -122.414217164494) | |||
| 185177 | 185177 | 135806 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 22 Aladdin Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008809.714930001 | 2119549.2222700003 | 37.8003750720026 | -122.41364506887399 | (37.8003750720026, -122.413645068874) | |||
| 72395 | 72395 | 135807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1311 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6005955.98541 | 2119974.55098 | 37.8013822560451 | -122.42355037726101 | (37.8013822560451, -122.423550377261) | ||||
| 43904 | 43904 | 135809 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1154 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6006309.30935 | 2120436.0273599997 | 37.8026692893277 | -122.422360524716 | (37.8026692893277, -122.422360524716) | |||
| 42317 | 42317 | 135828 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008658.00325 | 2119030.21476 | 37.798941486106294 | -122.414133314422 | (37.7989414861063, -122.414133314422) | |||
| 51638 | 51638 | 135831 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008642.5114400005 | 2119028.50949 | 37.7989359337052 | -122.41418680068199 | (37.7989359337052, -122.414186800682) | |||
| 155763 | 155763 | 135834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008624.12392 | 2119028.66096 | 37.7989353167715 | -122.414250438519 | (37.7989353167715, -122.414250438519) | |||
| 57508 | 57508 | 135835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008609.072240001 | 2119027.30535 | 37.7989307491201 | -122.41430242651899 | (37.7989307491201, -122.414302426519) | |||
| 62925 | 62925 | 135836 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008591.776769999 | 2119025.88036 | 37.7989258649019 | -122.41436217388001 | (37.7989258649019, -122.41436217388) | |||
| 177395 | 177395 | 135852 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 13 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008609.879 | 2119160.01046 | 37.7992951697024 | -122.414309029333 | (37.7992951697024, -122.414309029333) | ||||
| 170186 | 170186 | 135881 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2431 Jones St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6007959.30516 | 2120736.41676 | 37.803587019598204 | -122.416671982741 | (37.8035870195982, -122.416671982741) | |||
| 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) | |||
| 180497 | 180497 | 135883 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2431 Jones St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6007965.36294 | 2120676.16554 | 37.8034219256369 | -122.416646748657 | (37.8034219256369, -122.416646748657) | |||
| 179436 | 179436 | 135891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2398 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.802460509893606 | -122.44659245147301 | (37.8024605098936, -122.446592451473) | |||
| 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) | ||||
| 118168 | 118168 | 135902 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6008341.98532 | 2119430.34352 | 37.8000223848775 | -122.415255184482 | (37.8000223848775, -122.415255184482) | ||||
| 74598 | 74598 | 135903 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6008339.85894 | 2119440.03353 | 37.8000488717233 | -122.41526322892 | (37.8000488717233, -122.41526322892) | ||||
| 154849 | 154849 | 135905 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2843 Larkin St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6006460.32075 | 2121020.9303099997 | 37.804283800830795 | -122.42187952052099 | (37.8042838008308, -122.421879520521) | |||
| 176542 | 176542 | 135906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6007265.472680001 | 2119876.0558700003 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | |||
| 185153 | 185153 | 135917 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2350 Green St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6001679.33795 | 2118057.34258 | 37.7958757853901 | -122.438212029083 | (37.7958757853901, -122.438212029083) | |||
| 172726 | 172726 | 135927 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3400 Baker St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5999297.26526 | 2120520.00382 | 37.8025018265619 | -122.446631690727 | (37.8025018265619, -122.446631690727) | ||||
| 59687 | 59687 | 135938 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Walnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998466.03707 | 2116398.7314400002 | 37.791138403269294 | -122.44921105427 | (37.7911384032693, -122.44921105427) | |||
| 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) | |||
| 187914 | 187914 | 135943 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2056 Jefferson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5999351.778519999 | 2121203.50658 | 37.8043816542415 | -122.446492250814 | (37.8043816542415, -122.446492250814) | |||
| 55051 | 55051 | 135961 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2600 Divisadero St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000735.77189 | 2117237.48779 | 37.793570969586895 | -122.44141807800399 | (37.7935709695869, -122.441418078004) | |||
| 149151 | 149151 | 135962 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2600 Divisadero St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000720.81325 | 2117333.0898599997 | 37.7938326156312 | -122.441476699387 | (37.7938326156312, -122.441476699387) | |||
| 183269 | 183269 | 135964 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 Broadway | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001301.4834199995 | 2117308.30173 | 37.7937976176176 | -122.439465753262 | (37.7937976176176, -122.439465753262) | |||
| 42134 | 42134 | 135965 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 Broadway | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001290.6793 | 2117307.18376 | 37.7937939330834 | -122.439503056242 | (37.7937939330834, -122.439503056242) | |||
| 181976 | 181976 | 136014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6007575.68988 | 2119392.2209400004 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) |
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");