Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
| 85541 | 85541 | 30142 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 410X Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
| 98718 | 98718 | 19415 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600X Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989744.831209299 | 2096044.8028161 | 37.7347493206824 | -122.477897219949 | (37.7347493206824, -122.477897219949) | ||
| 102034 | 102034 | 19417 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5988998.102828201 | 2096024.0271709 | 37.7346489082814 | -122.48047736602301 | (37.7346489082814, -122.480477366023) | ||
| 107953 | 107953 | 19416 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 700X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989518.2187007 | 2096039.5354251 | 37.7347217027544 | -122.4786803033 | (37.7347217027544, -122.4786803033) | ||
| 144749 | 144749 | 16346 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 900X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996119.1686597 | 2094698.5315602 | 37.7314206866198 | -122.45576179592301 | (37.7314206866198, -122.455761795923) | ||
| 135590 | 135590 | 142317 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 442 LYON ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6000199.2759 | 2110472.9787 | 37.774966797429705 | -122.442788429748 | (37.7749667974297, -122.442788429748) | |||
| 34558 | 34558 | 188318 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2000 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6012048.56124 | 2104706.10168 | 37.759800640718005 | -122.401393594734 | (37.759800640718, -122.401393594734) | |||
| 35293 | 35293 | 204639 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 185 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998393.85271 | 2093179.60638 | 37.7273803570158 | -122.44778850934401 | (37.7273803570158, -122.447788509344) | ||||
| 35496 | 35496 | 204653 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 131 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.61668 | 2090064.78105 | 37.718425920692795 | -122.47171971360599 | (37.7184259206928, -122.471719713606) | |||
| 52875 | 52875 | 186786 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984829.112000001 | 2106870.9818 | 37.7641885128796 | -122.495690587985 | (37.7641885128796, -122.495690587985) | |||
| 55593 | 55593 | 222537 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 540 28th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6002401.940909999 | 2099473.8736099997 | 37.744891237355795 | -122.43438238754999 | (37.7448912373558, -122.43438238755) | |||
| 59966 | 59966 | 188338 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1580 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6014174.61235 | 2095442.29815 | 37.7344825828894 | -122.39339227343001 | (37.7344825828894, -122.39339227343) | |||
| 91385 | 91385 | 102872 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | ||||
| 132011 | 132011 | 204664 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 494 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5998245.72554 | 2095284.33404 | 37.73315097474371 | -122.448452092092 | (37.7331509747437, -122.448452092092) | ||||
| 135094 | 135094 | 125879 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Emerson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5998729.9299099995 | 2113444.41319 | 37.7830417124478 | -122.448085187582 | (37.7830417124478, -122.448085187582) | |||
| 138626 | 138626 | 102585 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/07/2013 12:00:00 AM | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | |||
| 144474 | 144474 | 102871 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | ||||
| 146750 | 146750 | 188337 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1578 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6014186.2862599995 | 2095457.7275599998 | 37.7345255974821 | -122.393352991941 | (37.7345255974821, -122.393352991941) | |||
| 151548 | 151548 | 204635 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 458 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998373.34514 | 2094412.4750299999 | 37.73076435209 | -122.447948129107 | (37.73076435209, -122.447948129107) | ||||
| 165733 | 165733 | 204663 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 163 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6000334.21865 | 2095199.1131900002 | 37.7330361672695 | -122.44122551783998 | (37.7330361672695, -122.44122551784) | ||||
| 181394 | 181394 | 125880 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Emerson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5998726.98974 | 2113474.62388 | 37.783124495049 | -122.448097535281 | (37.783124495049, -122.448097535281) | |||
| 181876 | 181876 | 204665 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 368 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5999628.00963 | 2094984.6303599998 | 37.732406994366606 | -122.443651657603 | (37.7324069943666, -122.443651657603) | ||||
| 185696 | 185696 | 175790 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 79 Colby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6008193.10922 | 2093597.69816 | 37.7290835632519 | -122.413941929669 | (37.7290835632519, -122.413941929669) | |||
| 187337 | 187337 | 204659 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998394.00648 | 2097223.48858 | 37.738483907702204 | -122.448079021847 | (37.7384839077022, -122.448079021847) | |||
| 111008 | 111008 | 116626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 5732X GEARY BLVD | 7 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 30579 | 30579 | 175758 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Tocoloma Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012839.87945 | 2087571.5634599999 | 37.7127968922232 | -122.397455115464 | (37.7127968922232, -122.397455115464) | ||||
| 37729 | 37729 | 247042 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6002114.968169999 | 2099165.77298 | 37.7440289718731 | -122.43535264990601 | (37.7440289718731, -122.435352649906) | ||||
| 153413 | 153413 | 247043 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6002094.89222 | 2099164.93967 | 37.744025543647105 | -122.435422008318 | (37.7440255436471, -122.435422008318) | ||||
| 177203 | 177203 | 175759 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Tocoloma Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012872.74847 | 2087577.73375 | 37.7128156646891 | -122.397341941199 | (37.7128156646891, -122.397341941199) | ||||
| 13269 | 13269 | 187626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 298x Molimo Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5997428.0 | 2096652.0 | 37.7368594694916 | -122.451377782024 | (37.7368594694916, -122.451377782024) | ||||
| 40373 | 40373 | 37238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.755729192821704 | -122.48675431687 | (37.7557291928217, -122.48675431687) | ||
| 80878 | 80878 | 108581 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1X GARDENSIDE DR | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999463.0 | 2102872.0 | 37.7540544083949 | -122.44478887768 | (37.7540544083949, -122.44478887768) | |||||
| 95289 | 95289 | 37234 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 95392 | 95392 | 37236 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 104783 | 104783 | 96999 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 115986 | 115986 | 37239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 125835 | 125835 | 97004 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 128725 | 128725 | 109380 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 725X BURNETT AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999257.1 | 2101645.9 | 37.7506760851616 | -122.44541277185499 | (37.7506760851616, -122.445412771855) | |||||
| 143102 | 143102 | 37235 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 25248 | 25248 | 188298 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6007537.97287 | 2109701.89036 | 37.7732652094644 | -122.41734758044 | (37.7732652094644, -122.41734758044) | |||
| 25360 | 25360 | 188327 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012968.79067 | 2102886.92272 | 37.754856873149706 | -122.398083326981 | (37.7548568731497, -122.398083326981) | |||
| 27078 | 27078 | 188288 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010227.812000001 | 2110667.04277 | 37.7760662630739 | -122.40811110056299 | (37.7760662630739, -122.408111100563) | |||
| 28372 | 28372 | 204655 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 452 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.46529981143298 | (37.7188834957636, -122.465299811433) | |||
| 28539 | 28539 | 188302 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008239.71976 | 2109507.11568 | 37.7727698610843 | -122.414906347362 | (37.7727698610843, -122.414906347362) | |||
| 30747 | 30747 | 188322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.75696789675921 | -122.39901232755399 | (37.7569678967592, -122.399012327554) | |||
| 34214 | 34214 | 188320 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.93717 | 2103702.00953 | 37.7570807814757 | -122.399018435778 | (37.7570807814757, -122.399018435778) | |||
| 34236 | 34236 | 188300 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791001 | (37.7728541761188, -122.41480452791) | |||
| 35460 | 35460 | 188321 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.29279 | 2103681.1367599997 | 37.757023433506 | -122.399019199302 | (37.757023433506, -122.399019199302) | |||
| 38034 | 38034 | 188335 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6013335.43042 | 2105239.42727 | 37.761336752 | -122.396980309397 | (37.761336752, -122.396980309397) | |||
| 38900 | 38900 | 222499 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 301 Webster St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004137.32896 | 2109855.92191 | 37.7734962273111 | -122.429121852705 | (37.7734962273111, -122.429121852705) | |||
| 41982 | 41982 | 188330 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 214 Texas St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6013707.236830001 | 2106019.4851599997 | 37.763499309471506 | -122.395749036807 | (37.7634993094715, -122.395749036807) | |||
| 43337 | 43337 | 204651 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 27 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.45097974552401 | (37.7179774953307, -122.450979745524) | |||
| 44147 | 44147 | 188289 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009413.38466 | 2109546.86827 | 37.772944891630104 | -122.41084930056101 | (37.7729448916301, -122.410849300561) | |||
| 50641 | 50641 | 246815 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 182 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6010185.45324 | 2098877.40442 | 37.74369220094071 | -122.407426274006 | (37.7436922009407, -122.407426274006) | |||
| 50745 | 50745 | 188325 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.39898942183201 | (37.7567499739592, -122.398989421832) | |||
| 53234 | 53234 | 188328 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1850 23rd St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6012921.09525 | 2102885.8261700002 | 37.754851205638204 | -122.39824819520099 | (37.7548512056382, -122.398248195201) | |||
| 53807 | 53807 | 188319 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101001 | (37.7571363191045, -122.39902607101) | |||
| 54041 | 54041 | 188299 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007530.7890099995 | 2109693.3141 | 37.7732412569071 | -122.41737182255501 | (37.7732412569071, -122.417371822555) | |||
| 60381 | 60381 | 188345 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012515.97712 | 2096106.6824400001 | 37.73621455036071 | -122.399173381754 | (37.7362145503607, -122.399173381754) | |||
| 61563 | 61563 | 247044 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002079.830030001 | 2099170.11996 | 37.74403891207071 | -122.43547446040199 | (37.7440389120707, -122.435474460402) | |||
| 62206 | 62206 | 188301 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008261.50029 | 2109526.90873 | 37.772825431974894 | -122.41483240691002 | (37.7728254319749, -122.41483240691) | |||
| 64408 | 64408 | 188294 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6008162.78535 | 2108877.84718 | 37.771037714636705 | -122.415127922313 | (37.7710377146367, -122.415127922313) | |||
| 65817 | 65817 | 188323 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012718.59247 | 2103642.7954599997 | 37.7569183962771 | -122.399001638237 | (37.7569183962771, -122.399001638237) | |||
| 68007 | 68007 | 188285 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010183.94442 | 2110713.51419 | 37.776191406445705 | -122.40826612929199 | (37.7761914064457, -122.408266129292) | |||
| 68293 | 68293 | 188331 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 612 Texas St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6013806.03622 | 2104232.11636 | 37.7585970807056 | -122.39528210428101 | (37.7585970807056, -122.395282104281) | |||
| 68710 | 68710 | 188336 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6013315.97127 | 2105238.81397 | 37.7613339848017 | -122.39704756789101 | (37.7613339848017, -122.397047567891) | |||
| 73514 | 73514 | 188348 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 135 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6013321.68612 | 2095651.6396700002 | 37.7350099660289 | -122.396355810291 | (37.7350099660289, -122.396355810291) | |||
| 74635 | 74635 | 188296 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6008131.8967699995 | 2108889.4185900004 | 37.7710677511061 | -122.41523558646601 | (37.7710677511061, -122.415235586466) | |||
| 129616 | 129616 | 188290 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009398.69382 | 2109531.26602 | 37.7729012277415 | -122.410899015985 | (37.7729012277415, -122.410899015985) | |||
| 131404 | 131404 | 247045 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6002079.02681 | 2099155.53035 | 37.7439988068049 | -122.435476194275 | (37.7439988068049, -122.435476194275) | |||
| 132718 | 132718 | 188329 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1850 23rd St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6012894.83022 | 2102885.3269599997 | 37.7548483718617 | -122.398338992565 | (37.7548483718617, -122.398338992565) | |||
| 136161 | 136161 | 188344 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 7 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012532.5163 | 2096115.8290099998 | 37.7362405866356 | -122.39911684046301 | (37.7362405866356, -122.399116840463) | |||
| 136815 | 136815 | 188343 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012604.8118 | 2096159.0938799998 | 37.736363411533496 | -122.398869919026 | (37.7363634115335, -122.398869919026) | |||
| 149455 | 149455 | 188292 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6009353.5292 | 2109489.65006 | 37.772784427403 | -122.411052306329 | (37.772784427403, -122.411052306329) | |||
| 150539 | 150539 | 188297 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6008118.01492 | 2108896.99552 | 37.771087775398705 | -122.415284140848 | (37.7710877753987, -122.415284140848) | |||
| 152265 | 152265 | 188341 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2351 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013156.07372 | 2096444.5663599998 | 37.737177960788706 | -122.396983972339 | (37.7371779607887, -122.396983972339) | |||
| 154732 | 154732 | 204656 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5993464.3561 | 2089166.2811200002 | 37.716077755750206 | -122.464538359982 | (37.7160777557502, -122.464538359982) | |||
| 155718 | 155718 | 188291 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009385.19996 | 2109515.63966 | 37.772857564751206 | -122.410944589137 | (37.7728575647512, -122.410944589137) | |||
| 159939 | 159939 | 188347 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 83 Scotia Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011997.83069 | 2095044.25145 | 37.7332684477844 | -122.400890216316 | (37.7332684477844, -122.400890216316) | |||
| 161577 | 161577 | 188334 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6013355.939119999 | 2105240.17326 | 37.7613399419185 | -122.396909430223 | (37.7613399419185, -122.396909430223) | |||
| 164398 | 164398 | 188287 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010207.19158 | 2110684.55446 | 37.776113191502496 | -122.408183667747 | (37.7761131915025, -122.408183667747) | |||
| 164795 | 164795 | 188303 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008234.3659 | 2109502.33979 | 37.772756446777294 | -122.414924528938 | (37.7727564467773, -122.414924528938) | |||
| 165867 | 165867 | 188339 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011007.54195 | 2094765.98142 | 37.7324490889606 | -122.40429435530301 | (37.7324490889606, -122.404294355303) | |||
| 167180 | 167180 | 188340 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2080 Silver Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012583.4784699995 | 2096093.4959599997 | 37.7361821046275 | -122.39893907508801 | (37.7361821046275, -122.398939075088) | |||
| 174395 | 174395 | 188293 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 5ft | 6008175.899180001 | 2108871.2472900003 | 37.771020329842294 | -122.415082093787 | (37.7710203298423, -122.415082093787) | |||
| 175317 | 175317 | 188295 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 3 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6008148.21893 | 2108881.79172 | 37.771047726812604 | -122.41517858743799 | (37.7710477268126, -122.415178587438) | |||
| 175531 | 175531 | 188286 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6010191.871780001 | 2110704.80693 | 37.776167942238295 | -122.408238092013 | (37.7761679422383, -122.408238092013) | |||
| 175761 | 175761 | 204654 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 222 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992216.41936 | 2089361.24223 | 37.7165410523041 | -122.46886596240299 | (37.7165410523041, -122.468865962403) | |||
| 179966 | 179966 | 188324 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | |||
| 180781 | 180781 | 188349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1764 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014694.72418 | 2096821.3256 | 37.738297993561396 | -122.391690447682 | (37.7382979935614, -122.391690447682) | |||
| 181555 | 181555 | 204650 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 254 Howth St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5997292.004269999 | 2090577.4247599998 | 37.720172339354704 | -122.451409977591 | (37.7201723393547, -122.451409977591) | |||
| 182374 | 182374 | 188342 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2335 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 21 | Width 2ft | 6013082.28487 | 2096418.14951 | 37.7371013178729 | -122.397237243906 | (37.7371013178729, -122.397237243906) | |||
| 185934 | 185934 | 188326 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012985.7528099995 | 2102888.64274 | 37.7548625406828 | -122.39802478743799 | (37.7548625406828, -122.398024787438) | |||
| 186252 | 186252 | 188346 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1716 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6014499.65662 | 2094860.17735 | 37.7329022519179 | -122.39222777999399 | (37.7329022519179, -122.392227779994) | |||
| 135572 | 135572 | 221334 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90x Peralta Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6010340.53234 | 2100283.1811900004 | 37.747560836176 | -122.406989109071 | (37.747560836176, -122.406989109071) | |||
| 24183 | 24183 | 175768 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989578.68884 | 2089185.3656400002 | 37.7159053925979 | -122.47797031747801 | (37.7159053925979, -122.477970317478) | ||||
| 24841 | 24841 | 175769 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989661.94364 | 2089233.64885 | 37.716042798215206 | -122.477686080452 | (37.7160427982152, -122.477686080452) | ||||
| 28542 | 28542 | 204628 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5992344.57273 | 2095377.42888 | 37.733067423224 | -122.46886055298701 | (37.733067423224, -122.468860552987) | |||
| 34559 | 34559 | 175753 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 755 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6000826.82092 | 2089512.30625 | 37.7174495420436 | -122.439115030257 | (37.7174495420436, -122.439115030257) |
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");