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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74692 | 74692 | 196073 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 5 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014983.580569999 | 2102134.9117099997 | 37.752904023218605 | -122.391063005979 | (37.7529040232186, -122.391063005979) | ||||
| 30029 | 30029 | 196074 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 7 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014974.36324 | 2102149.68411 | 37.7529440736099 | -122.391095913948 | (37.7529440736099, -122.391095913948) | ||||
| 133863 | 133863 | 196076 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 18 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014971.87416 | 2102223.03647 | 37.753145345506795 | -122.39110964840401 | (37.7531453455068, -122.391109648404) | ||||
| 130498 | 130498 | 196075 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 17 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014963.469190001 | 2102214.24517 | 37.753120740043705 | -122.391138100256 | (37.7531207400437, -122.391138100256) | ||||
| 51894 | 51894 | 67680 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1523 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 7 | Permit Number 31284 | 6014960.4779 | 2093407.781 | 37.7289398410715 | -122.390533137865 | (37.7289398410715, -122.390533137865) | |
| 151585 | 151585 | 196077 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 19 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014960.28506 | 2102234.79181 | 37.7531769800583 | -122.391150547759 | (37.7531769800583, -122.391150547759) | ||||
| 55873 | 55873 | 82677 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1627 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2005 12:00:00 AM | 4 | 6014950.6191 | 2094457.8846 | 37.7318226671335 | -122.390640571691 | (37.7318226671335, -122.390640571691) | ||
| 92961 | 92961 | 67679 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1539 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31283 | 6014892.62692915 | 2093462.84742446 | 37.72908727807339 | -122.39077155227301 | (37.7290872780734, -122.390771552273) | ||
| 13588 | 13588 | 26008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1625 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014811.10476 | 2095618.3620200001 | 37.7350013613099 | -122.391203993568 | (37.7350013613099, -122.391203993568) | |||
| 13630 | 13630 | 49513 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1648@3rd ST Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2003 12:00:00 AM | Permit Number 46418 | 6014785.81315318 | 2094304.60337815 | 37.731392643231295 | -122.391199634158 | (37.7313926432313, -122.391199634158) | |||
| 159455 | 159455 | 82979 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1175 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52488 | 6014632.4876 | 2090162.3488 | 37.72001033006671 | -122.391440240364 | (37.7200103300667, -122.391440240364) | |
| 52581 | 52581 | 30766 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1595 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34647 | 6014606.5276 | 2093671.0453 | 37.729643069645704 | -122.391775180038 | (37.7296430696457, -122.391775180038) | |
| 25423 | 25423 | 30768 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.727837721051294 | -122.391915390574 | (37.7278377210513, -122.391915390574) | |
| 171367 | 171367 | 40011 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 Latona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50722 | 6014429.18041 | 2094668.8927099998 | 37.732373109730894 | -122.39245806129101 | (37.7323731097309, -122.392458061291) | |
| 60474 | 60474 | 40018 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 Latona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50722 | 6014428.09341 | 2094657.0886799998 | 37.7323406379015 | -122.392460993976 | (37.7323406379015, -122.392460993976) | |
| 132015 | 132015 | 196092 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 24 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014425.82588 | 2105887.0502299997 | 37.7631756200823 | -122.393254379501 | (37.7631756200823, -122.393254379501) | ||||
| 53520 | 53520 | 196107 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 559 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6014419.73249 | 2104517.48217 | 37.759414745219296 | -122.39317961614799 | (37.7594147452193, -122.393179616148) | |||
| 40900 | 40900 | 196108 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 553 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6014419.65969 | 2104542.9303 | 37.759484616234104 | -122.393181648629 | (37.7594846162341, -122.393181648629) | |||
| 29380 | 29380 | 196093 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 25 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014406.1146599995 | 2105887.9731 | 37.763177058994 | -122.39332261913601 | (37.763177058994, -122.393322619136) | ||||
| 152443 | 152443 | 196094 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014400.8809 | 2105882.83985 | 37.7631626734333 | -122.393340361863 | (37.7631626734333, -122.393340361863) | ||||
| 44868 | 44868 | 40014 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25X Bay View St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50722 | 6014394.45523 | 2094706.7316599998 | 37.7324750793504 | -122.39258076118799 | (37.7324750793504, -122.392580761188) | |
| 54057 | 54057 | 39694 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1770 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | 8 | Permit Number 41079 | 6014361.02925 | 2095331.7699799999 | 37.7341894506734 | -122.392740033843 | (37.7341894506734, -122.392740033843) | |
| 172593 | 172593 | 40015 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25 Bay View St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 6 | Permit Number 41263 | 6014358.7954400005 | 2094713.5609799998 | 37.7324918508025 | -122.39270452408998 | (37.7324918508025, -122.39270452409) | ||
| 48632 | 48632 | 40016 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25X Bay View St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50722 | 6014347.1001 | 2094717.0020700002 | 37.7325006497719 | -122.392745198625 | (37.7325006497719, -122.392745198625) | |
| 120441 | 120441 | 114494 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 322 Ritch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014223.46606 | 2111741.7307700003 | 37.7792400254408 | -122.394364230131 | (37.7792400254408, -122.394364230131) | |||
| 60811 | 60811 | 114493 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 322 Ritch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014211.871830001 | 2111751.31287 | 37.779265691209105 | -122.394405010779 | (37.7792656912091, -122.394405010779) | |||
| 70857 | 70857 | 114492 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 322 Ritch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | 1 | 3x3 | Permit Number 777002 | 6014200.75816 | 2111763.05938 | 37.7792973266569 | -122.394444280578 | (37.7792973266569, -122.394444280578) | |
| 48192 | 48192 | 196300 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014184.739519999 | 2113142.03031 | 37.783082776381605 | -122.3945962858 | (37.7830827763816, -122.3945962858) | |||
| 26319 | 26319 | 67661 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 33 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 5 | Permit Number 31262 | 6014174.7724 | 2093920.80707 | 37.7303048875537 | -122.39328528558201 | (37.7303048875537, -122.393285285582) | |
| 61527 | 61527 | 67653 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 27 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 7 | Permit Number 31252 | 6014173.95689 | 2094523.3573 | 37.7319593226536 | -122.393330254407 | (37.7319593226536, -122.393330254407) | |
| 140067 | 140067 | 67672 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1777 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31275 | 6014169.61511167 | 2095049.17888581 | 37.7334028801998 | -122.393382048969 | (37.7334028801998, -122.393382048969) | ||
| 71671 | 71671 | 196299 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6014168.1975 | 2113125.45849 | 37.783036354289706 | -122.394652354018 | (37.7830363542897, -122.394652354018) | |||
| 185836 | 185836 | 67660 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 37 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 6 | Permit Number 31261 | 6014167.43331 | 2093890.7896900002 | 37.7302220581813 | -122.39330855826701 | (37.7302220581813, -122.393308558267) | |
| 182414 | 182414 | 67652 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 41 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 8 | Permit Number 31251 | 6014164.92937 | 2094480.71091 | 37.7318417227986 | -122.39335848140699 | (37.7318417227986, -122.393358481407) | |
| 54699 | 54699 | 196189 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 49 Lucy St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6014162.436290001 | 2093869.58355 | 37.7301635528011 | -122.393324350359 | (37.7301635528011, -122.393324350359) | |||
| 167300 | 167300 | 67658 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 49 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 7 | Permit Number 31259 | 6014158.601840001 | 2093846.4381799998 | 37.7300997872766 | -122.39333598758999 | (37.7300997872766, -122.39333598759) | |
| 185482 | 185482 | 49363 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875@ EVANS Marin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2003 12:00:00 AM | 3 | Permit Number 46338 | 6014150.899019999 | 2100527.8780900002 | 37.748445208788 | -122.39383011827 | (37.748445208788, -122.39383011827) | ||
| 47150 | 47150 | 81654 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 6 | 6014140.03196 | 2096118.2922200002 | 37.7363368024053 | -122.393559125566 | (37.7363368024053, -122.393559125566) | ||
| 16805 | 16805 | 25996 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6014137.90687 | 2096120.20835 | 37.7363419456235 | -122.39356660700899 | (37.7363419456235, -122.393566607009) | ||
| 118911 | 118911 | 50301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3212 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | Permit Number 47011 | 6014135.02682875 | 2089827.85867998 | 37.7190642634607 | -122.39313641269699 | (37.7190642634607, -122.393136412697) | ||
| 132293 | 132293 | 87176 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1784 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50145 | 6014123.922259999 | 2095138.61734 | 37.733645921116796 | -122.393546280538 | (37.7336459211168, -122.393546280538) | |
| 38516 | 38516 | 67659 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 44 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 9 | Permit Number 31260 | 6014110.85725 | 2093863.20548 | 37.7301431741556 | -122.393502220965 | (37.7301431741556, -122.393502220965) | |
| 133145 | 133145 | 32966 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 556 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 6 | Permit Number 37281 | 6014072.59224 | 2104507.52941 | 37.759368126158 | -122.394379509632 | (37.759368126158, -122.394379509632) | |
| 147570 | 147570 | 32963 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 534 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 7 | Permit Number 37278 | 6014065.513669999 | 2104636.52078 | 37.7597219149616 | -122.39441302283899 | (37.7597219149616, -122.394413022839) | |
| 155033 | 155033 | 196110 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 233 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6014050.9505900005 | 2105936.57906 | 37.7632907818606 | -122.394554425942 | (37.7632907818606, -122.394554425942) | |||
| 57340 | 57340 | 196156 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 418 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014038.63136 | 2105124.6384 | 37.7610606853181 | -122.39454017618999 | (37.7610606853181, -122.39454017619) | |||
| 163092 | 163092 | 196155 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 418 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6014037.44823 | 2105136.58178 | 37.761093413462504 | -122.39454510449801 | (37.7610934134625, -122.394545104498) | |||
| 73795 | 73795 | 196157 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 422 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014037.08737 | 2105100.22653 | 37.760993569807205 | -122.394543806767 | (37.7609935698072, -122.394543806767) | |||
| 73597 | 73597 | 30774 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 548 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 4 | 4.5x12 | Permit Number 34652 | 6014028.90307 | 2112230.33243 | 37.7805707972354 | -122.39507154151501 | (37.7805707972354, -122.395071541515) |
| 39643 | 39643 | 46463 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 31 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2002 12:00:00 AM | 8 | Permit Number 44667 | 6013974.3230800005 | 2095449.0350900001 | 37.7344899510581 | -122.39408521636801 | (37.7344899510581, -122.394085216368) | ||
| 67748 | 67748 | 196209 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 655 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013962.20415 | 2111085.21756 | 37.7774228624975 | -122.395222049367 | (37.7774228624975, -122.395222049367) | |||
| 52066 | 52066 | 196210 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 655 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013945.1419 | 2111103.2242 | 37.777471355756 | -122.39528233543301 | (37.777471355756, -122.395282335433) | |||
| 143960 | 143960 | 119638 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 655 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013935.0 | 2111132.0 | 37.7775498035437 | -122.395319436196 | (37.7775498035437, -122.395319436196) | ||||
| 162602 | 162602 | 196190 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 39 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013905.10394 | 2093942.74194 | 37.7303501306396 | -122.39421910833 | (37.7303501306396, -122.39421910833) | |||
| 34244 | 34244 | 196191 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1700 Armstrong Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6013892.03543 | 2092881.8479400002 | 37.727436404540796 | -122.39419004313 | (37.7274364045408, -122.39419004313) | ||||
| 37343 | 37343 | 196211 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 655 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013867.923169999 | 2111181.57439 | 37.7776821928143 | -122.39555495321301 | (37.7776821928143, -122.395554953213) | |||
| 110551 | 110551 | 117619 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5700 03RD ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6013866.0 | 2092333.0 | 37.7259279317454 | -122.394241638465 | (37.7259279317454, -122.394241638465) | |||||
| 173376 | 173376 | 56520 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 609 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 9 | Permit Number 31878 | 6013865.39943 | 2104246.99962 | 37.7586412482196 | -122.39507784038601 | (37.7586412482196, -122.395077840386) | |
| 53741 | 53741 | 68128 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 607 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 10 | Permit Number 31879 | 6013862.47141 | 2104272.49707 | 37.75871109585611 | -122.395089752816 | (37.7587110958561, -122.395089752816) | |
| 15502 | 15502 | 119264 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1243 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013843.6616400005 | 2105220.96082 | 37.7613143247043 | -122.39522124448798 | (37.7613143247043, -122.395221244488) | |||
| 134646 | 134646 | 65556 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1243 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1991 12:00:00 AM | 7 | 3x3 | Permit Number 28455 | 6013830.40453 | 2105221.22934 | 37.7613143247209 | -122.395267114398 | (37.7613143247209, -122.395267114398) | |
| 52347 | 52347 | 201970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 21 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013765.00423 | 2092206.62002 | 37.725575303453496 | -122.39458193081998 | (37.7255753034535, -122.39458193082) | |||
| 62690 | 62690 | 201971 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6013754.580159999 | 2092201.85922 | 37.7255616517262 | -122.394617632995 | (37.7255616517262, -122.394617632995) | ||||
| 185885 | 185885 | 201972 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 19 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013746.1142 | 2092220.9433400002 | 37.725613582194796 | -122.39464823513501 | (37.7256135821948, -122.394648235135) | |||
| 153153 | 153153 | 201973 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013730.31809 | 2092219.82075 | 37.725609621562796 | -122.39470276281999 | (37.7256096215628, -122.39470276282) | ||||
| 187589 | 187589 | 201974 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 17 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013727.10603 | 2092236.0738 | 37.725654070573704 | -122.39471500442 | (37.7256540705737, -122.39471500442) | |||
| 75379 | 75379 | 196198 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013719.80665 | 2111866.7259400003 | 37.779555223429604 | -122.39611537115 | (37.7795552234296, -122.39611537115) | |||
| 64124 | 64124 | 196197 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 36 Zoe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6013719.47537 | 2111992.2902 | 37.7798999758408 | -122.396125319442 | (37.7798999758408, -122.396125319442) | |||
| 71405 | 71405 | 201975 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013711.44714 | 2092234.27571 | 37.7256482627537 | -122.39476901048401 | (37.7256482627537, -122.394769010484) | ||||
| 130792 | 130792 | 201976 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 15 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013710.28394 | 2092247.91618 | 37.725685652057706 | -122.394773986446 | (37.7256856520577, -122.394773986446) | |||
| 65866 | 65866 | 196196 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 36 Zoe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6013700.87036 | 2112012.93246 | 37.7799556195859 | -122.396191130011 | (37.7799556195859, -122.396191130011) | |||
| 162857 | 162857 | 58258 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 204 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1978 12:00:00 AM | 10 | Permit Number 17263 | 6013700.6852400005 | 2106106.09172 | 37.7637367475831 | -122.395777765655 | (37.7637367475831, -122.395777765655) | ||
| 166958 | 166958 | 196199 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013692.0119 | 2111837.7722 | 37.7794741765351 | -122.396209495994 | (37.7794741765351, -122.396209495994) | |||
| 165875 | 165875 | 201977 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 14 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013690.4115699995 | 2092261.6964099999 | 37.7257223848541 | -122.394843648839 | (37.7257223848541, -122.394843648839) | |||
| 161423 | 161423 | 196154 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1317 19th St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6013683.78692 | 2105210.99248 | 37.7612780613652 | -122.395773489354 | (37.7612780613652, -122.395773489354) | |||
| 158933 | 158933 | 196200 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013682.55541 | 2111829.59348 | 37.7794511934496 | -122.396241636866 | (37.7794511934496, -122.396241636866) | |||
| 168510 | 168510 | 201941 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 7 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013681.12245 | 2092335.8479 | 37.7259254733716 | -122.394880951809 | (37.7259254733716, -122.394880951809) | |||
| 51057 | 51057 | 201978 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6013680.98178 | 2092258.06513 | 37.7257118897673 | -122.39487599293301 | (37.7257118897673, -122.394875992933) | ||||
| 58820 | 58820 | 196195 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 36 Zoe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6013679.408480001 | 2112034.51402 | 37.7800136834307 | -122.396266889798 | (37.7800136834307, -122.396266889798) | |||
| 173598 | 173598 | 196263 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1059 Jamestown Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6013674.30393 | 2089830.73604 | 37.7190465590346 | -122.394729166931 | (37.7190465590346, -122.394729166931) | ||||
| 56024 | 56024 | 201979 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013673.656359999 | 2092275.41387 | 37.7257591185834 | -122.39490253103901 | (37.7257591185834, -122.394902531039) | |||
| 168103 | 168103 | 196201 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013661.85599 | 2111812.39055 | 37.7794028063227 | -122.396312039369 | (37.7794028063227, -122.396312039369) | |||
| 185938 | 185938 | 201942 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013661.36989 | 2092347.25444 | 37.7259556950922 | -122.394950034125 | (37.7259556950922, -122.394950034125) | |||
| 15827 | 15827 | 100893 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013651.46361 | 2112030.89517 | 37.7800021918959 | -122.396363310639 | (37.7800021918959, -122.396363310639) | |||
| 182692 | 182692 | 196202 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6013641.30182 | 2111791.44038 | 37.779344138168895 | -122.396381676574 | (37.7793441381689, -122.396381676574) | |||
| 73494 | 73494 | 201943 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 9 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013641.01292 | 2092357.4486099998 | 37.7259825542392 | -122.39502112103999 | (37.7259825542392, -122.39502112104) | |||
| 150209 | 150209 | 201982 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 9 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013638.14457 | 2092296.9483299998 | 37.7258162731896 | -122.395026801165 | (37.7258162731896, -122.395026801165) | |||
| 112013 | 112013 | 113584 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1828 NEWHALL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013636.0 | 2094731.0 | 37.732499564411995 | -122.395204639391 | (37.732499564412, -122.395204639391) | ||||
| 46370 | 46370 | 196203 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013624.81706 | 2111774.8130099997 | 37.7792975658558 | -122.396437538871 | (37.7792975658558, -122.396437538871) | |||
| 147663 | 147663 | 201944 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 10 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013619.17874 | 2092369.08927 | 37.726013302964894 | -122.395097415939 | (37.7260133029649, -122.395097415939) | |||
| 63590 | 63590 | 201983 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013616.63963 | 2092305.2202599999 | 37.7258377903696 | -122.39510172187201 | (37.7258377903696, -122.395101721872) | |||
| 85298 | 85298 | 30861 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 30 Reddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34700 | 6013611.1313561 | 2094054.73303175 | 37.7306412906978 | -122.395243261567 | (37.7306412906978, -122.395243261567) | |||
| 114586 | 114586 | 30860 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 30 Reddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34700 | 6013611.1313561 | 2094054.73303175 | 37.7306412906978 | -122.395243261567 | (37.7306412906978, -122.395243261567) | |||
| 49852 | 49852 | 196204 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013601.37493 | 2111753.2604400003 | 37.7792370828557 | -122.396517124359 | (37.7792370828557, -122.396517124359) | |||
| 69858 | 69858 | 201984 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013594.77768 | 2092310.7003900001 | 37.7258516219291 | -122.39517768132099 | (37.7258516219291, -122.395177681321) | |||
| 130580 | 130580 | 201945 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 12 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013588.62557 | 2092382.18651 | 37.72604756622879 | -122.395203954116 | (37.7260475662288, -122.395203954116) | |||
| 154458 | 154458 | 196297 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1501 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6013586.24242 | 2103799.53475 | 37.7573970793204 | -122.396011941921 | (37.7573970793204, -122.396011941921) | ||||
| 173931 | 173931 | 201905 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1797 Yosemite Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013584.00079 | 2093382.5672099998 | 37.728794151521 | -122.395289988656 | (37.728794151521, -122.395289988656) | |||
| 30216 | 30216 | 196205 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6013581.78975 | 2111736.47585 | 37.77918990623971 | -122.396583701171 | (37.7791899062397, -122.396583701171) | |||
| 130448 | 130448 | 201904 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1797 Yosemite Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013567.70299 | 2093393.69523 | 37.7288238003734 | -122.395347110876 | (37.7288238003734, -122.395347110876) |
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");