Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, DBH, PlotSize
qSiteInfo ✖
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1364 | 1364 | 251507 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
1365 | 1365 | 251509 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
1372 | 1372 | 251508 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
1375 | 1375 | 251506 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
1835 | 1835 | 251742 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002771.0 | 2086560.0 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | ||||
1836 | 1836 | 251749 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 601 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002875.0 | 2087693.0 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | |||||
1848 | 1848 | 251743 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 Cordova St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001773.0 | 2087479.0 | 37.7119203272299 | -122.43569914014999 | (37.7119203272299, -122.43569914015) | |||||
2122 | 2122 | 252898 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997879.0 | 2089997.0 | 37.7186122227881 | -122.44933914222901 | (37.7186122227881, -122.449339142229) | ||||
2676 | 2676 | 253162 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 323 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004481.0 | 2091226.0 | 37.7223622223708 | -122.42660617515699 | (37.7223622223708, -122.426606175157) | ||||
13879 | 13879 | 50774 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
20472 | 20472 | 89331 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4658 18th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201.0 | 2105201.0 | 37.760491360371596 | -122.4424038966 | (37.7604913603716, -122.4424038966) | |||
42969 | 42969 | 95722 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
49235 | 49235 | 39895 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50795 | 6001095.73329197 | 2104700.06064199 | 37.7591668603211 | -122.439273525739 | (37.7591668603211, -122.439273525739) | ||
49602 | 49602 | 92857 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | Permit Number 53074 | 6001966.0 | 2100891.0 | 37.748757577125204 | -122.435991171851 | (37.7487575771252, -122.435991171851) | |||
54143 | 54143 | 88190 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1118 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631.0 | 2110372.0 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | |||
70838 | 70838 | 69919 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 95 Mercedes Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.728618246103295 | -122.470591251084 | (37.7286182461033, -122.470591251084) | ||
72527 | 72527 | 50111 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 250 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46832 | 5992489.27392501 | 2099148.73533454 | 37.7434308389356 | -122.468634598074 | (37.7434308389356, -122.468634598074) | ||
75293 | 75293 | 95998 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1682 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054683998 | (37.7362914700729, -122.39132054684) | |
77789 | 77789 | 88712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51654 | 6004166.0 | 2109783.0 | 37.773297624540895 | -122.429017475211 | (37.7732976245409, -122.429017475211) | ||
77937 | 77937 | 106193 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3040 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5983698.2 | 2098878.7 | 37.742177638003994 | -122.499011481047 | (37.742177638004, -122.499011481047) | ||||
79719 | 79719 | 112585 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
79989 | 79989 | 95720 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
80742 | 80742 | 114691 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 391 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975.0 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | |||
81387 | 81387 | 83396 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50820 | 6002600.50899636 | 2105341.51117361 | 37.761013644342604 | -122.43411515125 | (37.7610136443426, -122.43411515125) | ||
81515 | 81515 | 94694 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 12 Dehon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771.0 | 2106542.0 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | |
82028 | 82028 | 82433 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50249 | 6010057.43217179 | 2099484.04645755 | 37.745350741274 | -122.40791171221599 | (37.745350741274, -122.407911712216) | ||
83196 | 83196 | 71841 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 95 Mercedes Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.728618246103295 | -122.470591251084 | (37.7286182461033, -122.470591251084) | ||
83380 | 83380 | 101252 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1290X 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992716.9 | 2106688.9 | 37.764147324412605 | -122.46839598557699 | (37.7641473244126, -122.468395985577) | ||||
84032 | 84032 | 92858 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966.0 | 2100891.0 | 37.748757577125204 | -122.435991171851 | (37.7487575771252, -122.435991171851) | ||
84200 | 84200 | 98848 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | ||
84274 | 84274 | 87855 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2537 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2008 12:00:00 AM | 3x3 | Permit Number 50783 | 6006632.0 | 2119882.0 | 37.8011662683494 | -122.421204486113 | (37.8011662683494, -122.421204486113) | ||
85189 | 85189 | 39614 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 577 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42206 | 5996839.91957309 | 2107330.11638831 | 37.7661452244472 | -122.454182049235 | (37.7661452244472, -122.454182049235) | ||
85422 | 85422 | 88095 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.49912702260201 | (37.7534794912156, -122.499127022602) | |||
85631 | 85631 | 95404 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767278 | 6003403.3 | 2099172.9 | 37.7441216223731 | -122.430898399301 | (37.7441216223731, -122.430898399301) | |
86290 | 86290 | 40470 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43 Lakeview Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
87710 | 87710 | 88139 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 523 Teresita Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51168 | 5998937.5 | 2097522.9 | 37.7393370734625 | -122.446221422912 | (37.7393370734625, -122.446221422912) | |||
88126 | 88126 | 92664 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 791 San Bruno Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.759644317200106 | -122.404916188138 | (37.7596443172001, -122.404916188138) | |||
88455 | 88455 | 81333 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1607 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53535 | 5993364.90659405 | 2104537.49939321 | 37.7582775482109 | -122.46599839571999 | (37.7582775482109, -122.46599839572) | ||
89138 | 89138 | 88206 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51211 | 5996832.5 | 2111680.5 | 37.7780898241501 | -122.45452201468201 | (37.7780898241501, -122.454522014682) | |||
92779 | 92779 | 88094 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1474 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51098 | 5983765.2 | 2105129.7 | 37.759345083267796 | -122.499241618892 | (37.7593450832678, -122.499241618892) | |||
92798 | 92798 | 115268 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2275 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775658 | 5987276.1 | 2099806.2 | 37.744933531932794 | -122.486708467871 | (37.7449335319328, -122.486708467871) | |||
92854 | 92854 | 38913 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 70 Borica St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.722940558785794 | -122.46798762393101 | (37.7229405587858, -122.467987623931) | ||
93530 | 93530 | 88397 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51376 | 5987436.1 | 2113196.8 | 37.781709762111795 | -122.487138517946 | (37.7817097621118, -122.487138517946) | ||
93834 | 93834 | 116736 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1799x 25TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988397.0 | 2103119.0 | 37.754094880795606 | -122.48307541499399 | (37.7540948807956, -122.483075414994) | ||||
94109 | 94109 | 102385 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 33 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.768410224110205 | -122.438031497558 | (37.7684102241102, -122.438031497558) | ||
94167 | 94167 | 88256 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 436 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51241 | 5998536.0 | 2106665.0 | 37.76441609532 | -122.44826776566099 | (37.76441609532, -122.448267765661) | ||
94415 | 94415 | 103118 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 443 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2013 12:00:00 AM | Permit Number 769638 | 5992399.1 | 2090786.9 | 37.72046611452 | -122.46833819147801 | (37.72046611452, -122.468338191478) | |||
94537 | 94537 | 83344 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4443-4445 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50816 | 6001265.82005399 | 2105215.83153824 | 37.760592718857495 | -122.43872224382 | (37.7605927188575, -122.43872224382) | ||
95133 | 95133 | 105013 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 330 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | ||||
96116 | 96116 | 94672 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53808 | 5997731.1 | 2095032.6 | 37.732430335747 | -122.45021314346901 | (37.732430335747, -122.450213143469) | |
96133 | 96133 | 105012 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 330 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | ||||
96167 | 96167 | 94695 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 12 Dehon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771.0 | 2106542.0 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | |
97094 | 97094 | 37052 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 156 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49822 | 6005524.96145532 | 2099948.44891125 | 37.746371088402704 | -122.423617283508 | (37.7463710884027, -122.423617283508) | ||
97343 | 97343 | 95721 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
97731 | 97731 | 92226 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.41527458403401 | (37.7590797904057, -122.415274584034) | ||
98150 | 98150 | 43741 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
98766 | 98766 | 104736 | Significant Tree 6 | Lagunaria patersonii :: Primrose Tree 48 | 1499X 44th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770763 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.50371897878901 | (37.7595862228156, -122.503718978789) | ||||
99545 | 99545 | 88108 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1935 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51112 | 5981615.2 | 2101901.1 | 37.7503538981052 | -122.50643780728001 | (37.7503538981052, -122.50643780728) | |||
99795 | 99795 | 43061 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3050 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 53563 | 5983775.74745702 | 2098849.58098564 | 37.7421022336559 | -122.498741199638 | (37.7421022336559, -122.498741199638) | |||
101190 | 101190 | 51233 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1130 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.763705958456704 | -122.45231616044599 | (37.7637059584567, -122.452316160446) | |||
101532 | 101532 | 46892 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1383 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44948 | 5992692.47897134 | 2106059.86172468 | 37.7624187406256 | -122.46843468168501 | (37.7624187406256, -122.468434681685) | ||
102266 | 102266 | 88244 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4330 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51231 | 6000585.0 | 2105809.0 | 37.7621826583789 | -122.441119442302 | (37.7621826583789, -122.441119442302) | |||
102285 | 102285 | 102092 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391.0 | 37.744996275991504 | -122.414008688761 | (37.7449962759915, -122.414008688761) | |
102671 | 102671 | 94671 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 654 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | |
103046 | 103046 | 43742 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
103063 | 103063 | 51232 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1130 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.763705958456704 | -122.45231616044599 | (37.7637059584567, -122.452316160446) | |||
103150 | 103150 | 51230 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1130 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.763705958456704 | -122.45231616044599 | (37.7637059584567, -122.452316160446) | |||
104034 | 104034 | 82079 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1648 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50227 | 6009276.07844564 | 2099765.78028808 | 37.7460805446245 | -122.410633408071 | (37.7460805446245, -122.410633408071) | ||
104847 | 104847 | 74157 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 195 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | Permit Number 768269 | 6008310.54477322 | 2097714.64471242 | 37.740394399357 | -122.413827044611 | (37.740394399357, -122.413827044611) | ||
105096 | 105096 | 106607 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1392 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.761726116308104 | -122.48005880990699 | (37.7617261163081, -122.480058809907) | ||
105236 | 105236 | 116735 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1799x 25TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988397.0 | 2103119.0 | 37.754094880795606 | -122.48307541499399 | (37.7540948807956, -122.483075414994) | ||||
105336 | 105336 | 102384 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.768410224110205 | -122.438031497558 | (37.7684102241102, -122.438031497558) | ||
105500 | 105500 | 92859 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966.0 | 2100891.0 | 37.748757577125204 | -122.435991171851 | (37.7487575771252, -122.435991171851) | ||
106448 | 106448 | 88732 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1732 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51666 | 6003104.1 | 2114241.2 | 37.7854785624412 | -122.433009307654 | (37.7854785624412, -122.433009307654) | ||
106923 | 106923 | 88527 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1501 06th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51477 | 5994255.6 | 2105256.2 | 37.7603022580943 | -122.462970154312 | (37.7603022580943, -122.462970154312) | |||
107208 | 107208 | 67239 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 3x9 | Permit Number 30703 | 6003792.49486353 | 2108815.33294247 | 37.770619498227 | -122.430240430849 | (37.770619498227, -122.430240430849) | |
107437 | 107437 | 95999 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1682 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054683998 | (37.7362914700729, -122.39132054684) | |
107833 | 107833 | 87640 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3x3 | 6012975.96285 | 2096322.27153 | 37.7368321371284 | -122.397598127165 | (37.7368321371284, -122.397598127165) | |||
108159 | 108159 | 41826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2517 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2000 12:00:00 AM | Permit Number 42212 | 5998421.57666404 | 2111723.27260806 | 37.7782982768263 | -122.449027932684 | (37.7782982768263, -122.449027932684) | |||
108178 | 108178 | 112584 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
108202 | 108202 | 92665 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 791 San Bruno Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.759644317200106 | -122.404916188138 | (37.7596443172001, -122.404916188138) | |||
109287 | 109287 | 50035 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 73 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46766 | 6007848.45417861 | 2093691.5625558 | 37.7293219318135 | -122.41514007459801 | (37.7293219318135, -122.415140074598) | ||
110202 | 110202 | 84332 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51851 | 5986981.94009984 | 2110441.32651783 | 37.7741175201244 | -122.488507097746 | (37.7741175201244, -122.488507097746) | ||
110281 | 110281 | 116789 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 530 CRESCENT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007719.0 | 2095661.0 | 37.7347223035732 | -122.415727003996 | (37.7347223035732, -122.415727003996) | ||||
110297 | 110297 | 88724 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1009 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742.0 | 2109408.0 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | ||
111070 | 111070 | 49802 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | Permit Number 46598 | 6014071.0 | 2106574.0 | 37.765042114519 | -122.39452971790399 | (37.765042114519, -122.394529717904) | ||
111186 | 111186 | 105014 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 330 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | ||||
111314 | 111314 | 106608 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1392 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.761726116308104 | -122.48005880990699 | (37.7617261163081, -122.480058809907) | ||
111831 | 111831 | 94654 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53793 | 6003689.0 | 2095884.0 | 37.73510724004171 | -122.429675988088 | (37.7351072400417, -122.429675988088) | |
112359 | 112359 | 82755 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50226 | 6009275.52393785 | 2099776.98643755 | 37.746111283151 | -122.410636116717 | (37.746111283151, -122.410636116717) | ||
112382 | 112382 | 43739 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
112446 | 112446 | 83301 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2194 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | ||
112698 | 112698 | 88255 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 115 Belvedere St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51240 | 5998220.0 | 2108137.0 | 37.7684397634087 | -122.44946678758998 | (37.7684397634087, -122.44946678759) | |||
113001 | 113001 | 115239 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775147 | 5981970.6 | 2109880.3 | 37.7722834181785 | -122.505800301349 | (37.7722834181785, -122.505800301349) | |||
113043 | 113043 | 115237 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775536 | 5982900.6 | 2109891.1 | 37.772367765473795 | -122.502584200594 | (37.7723677654738, -122.502584200594) | |||
113705 | 113705 | 112586 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
114348 | 114348 | 43740 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
114352 | 114352 | 110718 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 201x OGDEN AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007843.0 | 2096159.0 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | ||||
114553 | 114553 | 84680 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49721 | 5996259.49937321 | 2091420.61840977 | 37.722428372357 | -122.45503987717 | (37.722428372357, -122.45503987717) | ||
114566 | 114566 | 114692 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 391 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | Private 3 | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975.0 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) |
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");