Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | ||||
| 34992 | 34992 | 222570 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4308 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001844.3062 | 2101201.08908 | 37.7496020939667 | -122.43643417821698 | (37.7496020939667, -122.436434178217) | |||
| 35176 | 35176 | 43892 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 6 | Permit Number 43498 | 6009086.19652 | 2110571.7349400003 | 37.7757405834934 | -122.412053529658 | (37.7757405834934, -122.412053529658) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 36392 | 36392 | 44281 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1588 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014169.386469999 | 2095432.395 | 37.734455100518 | -122.393409648353 | (37.734455100518, -122.393409648353) | ||
| 36933 | 36933 | 244274 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 470 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004329.9355 | 2109813.5769 | 37.7733908594087 | -122.42845257964501 | (37.7733908594087, -122.428452579645) | |||
| 36944 | 36944 | 88065 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012481.79699 | 2096085.11316 | 37.7361534207291 | -122.399290043599 | (37.7361534207291, -122.399290043599) | |
| 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) | ||||
| 37998 | 37998 | 221341 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 217 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005002.96321 | 2100161.85612 | 37.7469275767478 | -122.42543747867201 | (37.7469275767478, -122.425437478672) | |||
| 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) | |||
| 38265 | 38265 | 222573 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3917 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003673.95782 | 2101843.15091 | 37.7514688410299 | -122.43015298120301 | (37.7514688410299, -122.430152981203) | |||
| 38282 | 38282 | 188358 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1334 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017132.819619999 | 2095655.66164 | 37.7352323503922 | -122.383179517428 | (37.7352323503922, -122.383179517428) | |||
| 38724 | 38724 | 204643 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995381.41136 | 2092014.7979700002 | 37.7240094335681 | -122.458118187113 | (37.7240094335681, -122.458118187113) | |||
| 38894 | 38894 | 50846 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | 5 | Permit Number 47372 | 6003324.61709 | 2090530.54695 | 37.720387218868495 | -122.430553920527 | (37.7203872188685, -122.430553920527) | ||
| 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) | |||
| 39326 | 39326 | 221354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008383.52326 | 2103860.65415 | 37.7572740646699 | -122.41400939143601 | (37.7572740646699, -122.414009391436) | |||
| 39548 | 39548 | 72980 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1730 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1999 12:00:00 AM | 7 | 5987835.4413 | 2103488.2738 | 37.7550761133303 | -122.48504448823499 | (37.7550761133303, -122.485044488235) | ||
| 39974 | 39974 | 188355 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1339 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017230.94644 | 2095282.0098400002 | 37.7342117988404 | -122.38281425956998 | (37.7342117988404, -122.38281425957) | |||
| 40087 | 40087 | 125883 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008823.04151 | 2115295.3212900003 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | |||
| 40165 | 40165 | 32579 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.763848120851705 | -122.49227291177401 | (37.7638481208517, -122.492272911774) | |
| 40334 | 40334 | 222553 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007213.79342 | 2097921.72013 | 37.740901328538996 | -122.417633860722 | (37.740901328539, -122.417633860722) | |||
| 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) | ||
| 41275 | 41275 | 188305 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 635 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015454.10981 | 2106058.18427 | 37.7637025904139 | -122.389709812266 | (37.7637025904139, -122.389709812266) | |||
| 41434 | 41434 | 175767 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | ||||
| 41763 | 41763 | 222502 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005857.93432 | 2106390.78551 | 37.764079039426704 | -122.42292369548599 | (37.7640790394267, -122.422923695486) | |||
| 41865 | 41865 | 204668 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5997569.23018 | 2095279.46651 | 37.7330989075946 | -122.45079055604499 | (37.7330989075946, -122.450790556045) | |||
| 41975 | 41975 | 65113 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 363 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 10 | Permit Number 27082 | 5989323.435380001 | 2112903.08855 | 37.781013182321104 | -122.480587794991 | (37.7810131823211, -122.480587794991) | |
| 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) | |||
| 42503 | 42503 | 204633 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998410.37704 | 2094369.2089900002 | 37.7306476704498 | -122.447816990888 | (37.7306476704498, -122.447816990888) | |||
| 42881 | 42881 | 78349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5986607.90066 | 2110854.65361 | 37.7752305672016 | -122.489831352395 | (37.7752305672016, -122.489831352395) | ||
| 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) | |||
| 44057 | 44057 | 175774 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5990113.97654 | 2089437.91841 | 37.7166298945381 | -122.47613856845 | (37.7166298945381, -122.47613856845) | ||||
| 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) | |||
| 44455 | 44455 | 222555 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006651.1877 | 2098952.76416 | 37.743700669854796 | -122.419652282953 | (37.7437006698548, -122.419652282953) | |||
| 44691 | 44691 | 175766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135001 | (37.7167583770722, -122.47966897135) | ||||
| 44902 | 44902 | 43889 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 4 | Permit Number 43498 | 6009135.81805 | 2110617.1891 | 37.775868173909004 | -122.411885088422 | (37.775868173909, -122.411885088422) | ||
| 45243 | 45243 | 221339 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002975.42772 | 2099463.08044 | 37.744894137656395 | -122.43239860720699 | (37.7448941376564, -122.432398607207) | |||
| 45314 | 45314 | 221329 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 92 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010301.696169999 | 2100286.438 | 37.7475676053645 | -122.407123632349 | (37.7475676053645, -122.407123632349) | |||
| 45351 | 45351 | 188353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017129.66281 | 2095538.6901900002 | 37.7349109956364 | -122.38318229272899 | (37.7349109956364, -122.383182292729) | |||
| 45511 | 45511 | 221338 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 117 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005011.955130001 | 2099285.1526 | 37.7445208578632 | -122.425344007646 | (37.7445208578632, -122.425344007646) | |||
| 45600 | 45600 | 57691 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16595 | 6001759.0 | 2096663.0 | 37.7371367196384 | -122.436404416578 | (37.7371367196384, -122.436404416578) | |
| 45649 | 45649 | 221353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3181 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007743.59292 | 2102655.4048200003 | 37.7539287629281 | -122.41613717119199 | (37.7539287629281, -122.416137171192) | |||
| 45681 | 45681 | 49816 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.758343624767605 | -122.400103532548 | (37.7583436247676, -122.400103532548) |
| 45847 | 45847 | 43213 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 361 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 3 | Permit Number 43004 | 6008709.78977 | 2094511.79844 | 37.7316224914874 | -122.41222029725 | (37.7316224914874, -122.41222029725) | |
| 46013 | 46013 | 221321 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005240.58146 | 2105045.63355 | 37.7603507164348 | -122.424963229285 | (37.7603507164348, -122.424963229285) | |||
| 46438 | 46438 | 38557 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1511 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 12 | Permit Number 40522 | 6015824.3664 | 2095556.8722 | 37.7348887022439 | -122.38769646850001 | (37.7348887022439, -122.3876964685) | |
| 46539 | 46539 | 221335 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1641 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010542.34793 | 2100138.1982400003 | 37.7471740359465 | -122.406281026071 | (37.7471740359465, -122.406281026071) | |||
| 46843 | 46843 | 54597 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 630 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 19 | Permit Number 10420 | 6014092.76415 | 2104176.14538 | 37.7584593387525 | -122.394286543097 | (37.7584593387525, -122.394286543097) | ||
| 46851 | 46851 | 125887 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006289.37196 | 2113344.7288599997 | 37.7831972322057 | -122.42192548758301 | (37.7831972322057, -122.421925487583) | |||
| 47450 | 47450 | 125886 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 260 Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006255.845480001 | 2113363.12878 | 37.7832458630397 | -122.42204278345699 | (37.7832458630397, -122.422042783457) | |||
| 47579 | 47579 | 204671 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999561.20485 | 2094716.8073599997 | 37.7316678047194 | -122.443863381386 | (37.7316678047194, -122.443863381386) | |||
| 47784 | 47784 | 221322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005240.85494 | 2105024.4327599998 | 37.760292519512205 | -122.42496077502899 | (37.7602925195122, -122.424960775029) | |||
| 47820 | 47820 | 70445 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 5 | 5982997.1409 | 2098317.8833 | 37.740596640895795 | -122.501394010052 | (37.7405966408958, -122.501394010052) | ||
| 47824 | 47824 | 204629 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 5997855.18506 | 2096638.3314 | 37.7368463906537 | -122.449899836933 | (37.7368463906537, -122.449899836933) | |||
| 49781 | 49781 | 222588 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4380 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000121.81513 | 2105788.1369 | 37.762098979601 | -122.44271991951 | (37.762098979601, -122.44271991951) | |||
| 50086 | 50086 | 113271 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1321 Revere Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260.0 | 37.7286210040554 | -122.38509718743299 | (37.7286210040554, -122.385097187433) | ||||
| 50129 | 50129 | 175762 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011080.3120099995 | 2091995.56752 | 37.7248461762995 | -122.403847893187 | (37.7248461762995, -122.403847893187) | |||
| 50304 | 50304 | 221348 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 225 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007116.4311 | 2096880.25923 | 37.7380362287807 | -122.41789669659401 | (37.7380362287807, -122.417896696594) | |||
| 50384 | 50384 | 43896 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 716 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51474 | 6009227.05246 | 2110468.55015 | 37.7754651643179 | -122.411558979885 | (37.7754651643179, -122.411558979885) | |
| 50558 | 50558 | 70268 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 656 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 11 | 6002561.31186 | 2089826.6998700001 | 37.71841134000321 | -122.43314215230801 | (37.7184113400032, -122.433142152308) | ||
| 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) | |||
| 50710 | 50710 | 72270 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 619 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 5 | 6002965.14713 | 2089877.08907 | 37.7185725974338 | -122.431749858784 | (37.7185725974338, -122.431749858784) | ||
| 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) | |||
| 50847 | 50847 | 222571 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001358.40825 | 2101420.45569 | 37.7501768003212 | -122.43813013861099 | (37.7501768003212, -122.438130138611) | |||
| 51006 | 51006 | 221351 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006363.61838 | 2105832.54053 | 37.7625747506491 | -122.421135037456 | (37.7625747506491, -122.421135037456) | |||
| 51195 | 51195 | 244276 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 480 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004294.0037 | 2109808.1625 | 37.7733739594079 | -122.428576486808 | (37.7733739594079, -122.428576486808) | |||
| 51501 | 51501 | 44809 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1371 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 3 | Permit Number 43903 | 5986466.0604 | 2105911.3769 | 37.7616494289947 | -122.48995834721501 | (37.7616494289947, -122.489958347215) | |
| 51832 | 51832 | 222565 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Precita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007123.52166 | 2100080.2988 | 37.7468232221335 | -122.418098981082 | (37.7468232221335, -122.418098981082) | |||
| 52367 | 52367 | 175777 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 281 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004127.09808 | 2091752.9850700002 | 37.7237891931904 | -122.42786706372601 | (37.7237891931904, -122.427867063726) | |||
| 52591 | 52591 | 222563 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007620.90266 | 2100266.50742 | 37.747362491591296 | -122.41639226749201 | (37.7473624915913, -122.416392267492) | |||
| 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) | |||
| 52936 | 52936 | 222568 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 34 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004529.9479 | 2095570.0555900002 | 37.734292801673796 | -122.426746177496 | (37.7342928016738, -122.426746177496) | |||
| 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) | |||
| 53435 | 53435 | 222583 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 193 Diamond St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001753.50389 | 2104887.2031 | 37.7597181171131 | -122.43701204208 | (37.7597181171131, -122.43701204208) | |||
| 53675 | 53675 | 222572 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 524 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002965.6945400005 | 2102138.50273 | 37.7522396670301 | -122.432623334298 | (37.7522396670301, -122.432623334298) | |||
| 53683 | 53683 | 125881 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2101 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001760.22052 | 2119747.88013 | 37.8005221579273 | -122.438053316704 | (37.8005221579273, -122.438053316704) | |||
| 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) | |||
| 53944 | 53944 | 221365 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001927.1952 | 2100682.80135 | 37.748183708409 | -122.43611046183099 | (37.748183708409, -122.436110461831) | |||
| 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) | |||
| 54422 | 54422 | 204645 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994132.807630001 | 2090689.3393400002 | 37.7202982210683 | -122.462338293601 | (37.7202982210683, -122.462338293601) | |||
| 54695 | 54695 | 52371 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.78967044259821 | -122.41321087889901 | (37.7896704425982, -122.413210878899) |
| 54861 | 54861 | 204642 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5995680.91746 | 2091957.8181099999 | 37.7238701852543 | -122.457078728228 | (37.7238701852543, -122.457078728228) | |||
| 54979 | 54979 | 221358 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000996.09085 | 2097469.1732900003 | 37.73930690338871 | -122.439099895546 | (37.7393069033887, -122.439099895546) | |||
| 55473 | 55473 | 222549 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007198.14969 | 2097813.68298 | 37.740603802237295 | -122.417680295405 | (37.7406038022373, -122.417680295405) | |||
| 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) | |||
| 55954 | 55954 | 49814 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46606 | 6012411.85736 | 2104145.59448 | 37.758281874620295 | -122.400097759826 | (37.7582818746203, -122.400097759826) | |
| 56301 | 56301 | 204608 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1563 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5990535.7174 | 2104763.29262 | 37.7587338945762 | -122.47579935676399 | (37.7587338945762, -122.475799356764) | |||
| 56696 | 56696 | 188309 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012912.6135599995 | 2106204.46931 | 37.763962999012996 | -122.398510384468 | (37.763962999013, -122.398510384468) | |||
| 57253 | 57253 | 244273 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 466 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004356.0229 | 2109819.4835 | 37.7734085536944 | -122.428362760697 | (37.7734085536944, -122.428362760697) | |||
| 57424 | 57424 | 125888 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.784407514645096 | -122.415878065725 | (37.7844075146451, -122.415878065725) | |||
| 58130 | 58130 | 244275 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004317.6301 | 2109811.608 | 37.77338475694221 | -122.42849500540001 | (37.7733847569422, -122.4284950054) | |||
| 58207 | 58207 | 204627 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992327.28359 | 2095380.5803 | 37.7330750773552 | -122.46892055484301 | (37.7330750773552, -122.468920554843) | |||
| 58559 | 58559 | 221337 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 26 Hidalgo Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6004997.11684 | 2107512.5522 | 37.7671105326404 | -122.425980872425 | (37.7671105326404, -122.425980872425) | |||
| 58940 | 58940 | 107105 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 532 NOE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6002950.4 | 2105092.9 | 37.760350869576705 | -122.43288727007901 | (37.7603508695767, -122.432887270079) | |||
| 59363 | 59363 | 222560 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1409 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008015.99739 | 2099911.75152 | 37.7464106212529 | -122.415000947938 | (37.7464106212529, -122.415000947938) |
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");