Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29931 | 29931 | 129373 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2133 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000002.55629 | 2120892.7221 | 37.8035654727314 | -122.444217840184 | (37.8035654727314, -122.444217840184) | |||
| 55786 | 55786 | 129372 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2133 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999985.518069999 | 2120890.75849 | 37.80355910913379 | -122.444276660352 | (37.8035591091338, -122.444276660352) | |||
| 73263 | 73263 | 129389 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006655.24817 | 2120043.6921200003 | 37.801611544485205 | -122.421135524881 | (37.8016115444852, -122.421135524881) | |||
| 144304 | 144304 | 88645 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2500x Larkin St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51618 | 6006882.7 | 2119972.1 | 37.8014277902223 | -122.420343352043 | (37.8014277902223, -122.420343352043) | |||
| 56096 | 56096 | 65853 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3415 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51130 | 6000770.44597 | 2120073.90569 | 37.8013609996628 | -122.44150173651501 | (37.8013609996628, -122.441501736515) | |
| 40740 | 40740 | 129388 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006666.99925 | 2119949.9372900003 | 37.8013547799481 | -122.421088199869 | (37.8013547799481, -122.421088199869) | |||
| 26189 | 26189 | 83205 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3437 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52337 | 6002190.72031 | 2120034.66861 | 37.8013340766633 | -122.436584154541 | (37.8013340766633, -122.436584154541) | |
| 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) | ||
| 188753 | 188753 | 129387 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006679.63776 | 2119843.90732 | 37.801064360981606 | -122.42103693222602 | (37.8010643609816, -122.421036932226) | |||
| 85798 | 85798 | 42693 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |
| 73444 | 73444 | 34680 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1904 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52535 | 6003705.30059 | 2119372.14104 | 37.7996008996227 | -122.43129571912701 | (37.7996008996227, -122.431295719127) | |
| 153028 | 153028 | 129390 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 902 Vallejo St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009192.86484 | 2118752.75452 | 37.798209676283 | -122.41226288822399 | (37.798209676283, -122.412262888224) | |||
| 147945 | 147945 | 52071 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 939 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009677.58908 | 2117754.14875 | 37.7954949369081 | -122.41051503874701 | (37.7954949369081, -122.410515038747) | ||
| 50407 | 50407 | 52070 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 939 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009656.25559 | 2117750.5131099997 | 37.7954837583147 | -122.410588599703 | (37.7954837583147, -122.410588599703) | ||
| 49141 | 49141 | 83685 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009407.14931 | 2117677.56911 | 37.7952695029448 | -122.411445397284 | (37.7952695029448, -122.411445397284) | |
| 53126 | 53126 | 83686 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52242 | 6009408.292880001 | 2117660.17543 | 37.795221808298294 | -122.411440210903 | (37.7952218082983, -122.411440210903) | |
| 76000 | 76000 | 83687 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009414.651880001 | 2117634.8999400004 | 37.7951527646548 | -122.41141642115801 | (37.7951527646548, -122.411416421158) | |
| 120684 | 120684 | 88438 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1248 Mason St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52242 | 6009421.0 | 2117567.0 | 37.794966684082105 | -122.41138965638599 | (37.7949666840821, -122.411389656386) | |||
| 174850 | 174850 | 60223 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1230 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52240 | 6009426.5919699995 | 2117542.6242 | 37.7949000677337 | -122.41136858440399 | (37.7949000677337, -122.411368584404) | |
| 66808 | 66808 | 52362 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1438ASHINGTON Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 9 | Permit Number 48498 | 6007994.9364599995 | 2117377.7611599998 | 37.7943669936906 | -122.416310648633 | (37.7943669936906, -122.416310648633) | |
| 49520 | 49520 | 129379 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1765 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6005697.11148 | 2117184.40611 | 37.793706610722 | -122.424247645012 | (37.793706610722, -122.424247645012) | |||
| 77138 | 77138 | 129378 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002236.43678 | 2116865.63553 | 37.7926353355998 | -122.436199040575 | (37.7926353355998, -122.436199040575) | |||
| 187386 | 187386 | 129377 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6002239.2844 | 2116842.37021 | 37.7925716168296 | -122.43618752203699 | (37.7925716168296, -122.436187522037) | |||
| 31107 | 31107 | 129376 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6002240.59165 | 2116825.10443 | 37.7925242837291 | -122.43618176277398 | (37.7925242837291, -122.436181762774) | |||
| 55763 | 55763 | 52885 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2500@ JACKSON Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 7 | Permit Number 48890 | 6002243.8338 | 2116804.81477 | 37.792468757764794 | -122.436169092224 | (37.7924687577648, -122.436169092224) | ||
| 150847 | 150847 | 52442 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2310 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | Permit Number 48553 | 6003588.30454 | 2116614.49532 | 37.7920224826905 | -122.43150359293301 | (37.7920224826905, -122.431503592933) | |
| 38399 | 38399 | 129386 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 929 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009490.7484 | 2116033.66261 | 37.7907604245028 | -122.411039958651 | (37.7907604245028, -122.411039958651) | |||
| 40870 | 40870 | 129385 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 722 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009662.68842 | 2115877.38276 | 37.7903409582254 | -122.41043401253 | (37.7903409582254, -122.41043401253) | |||
| 50222 | 50222 | 113489 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 40 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x10 | 5995526.6518 | 2115672.85646 | 37.7889767847188 | -122.45932857543 | (37.7889767847188, -122.45932857543) | |||
| 135797 | 135797 | 51532 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3155 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 2 | Permit Number 47834 | 5999712.30266 | 2115373.4309400003 | 37.78839440084 | -122.44482529806001 | (37.78839440084, -122.44482529806) | ||
| 134834 | 134834 | 84816 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 736 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53031 | 6008319.9304599995 | 2115035.61847 | 37.7879543130824 | -122.415020270782 | (37.7879543130824, -122.415020270782) | |
| 158616 | 158616 | 129380 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 730 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008321.927730001 | 2115014.63424 | 37.7878968077251 | -122.415011874722 | (37.7878968077251, -122.415011874722) | |||
| 138235 | 138235 | 87031 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 50 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52524 | 5994278.21944 | 2115255.72364 | 37.787759595502294 | -122.463617666169 | (37.7877595955023, -122.463617666169) | |
| 47371 | 47371 | 250553 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.787713689594796 | -122.484739928202 | (37.7877136895948, -122.484739928202) | |||
| 164675 | 164675 | 250554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988163.80572 | 2115366.95271 | 37.7877107901693 | -122.484780278081 | (37.7877107901693, -122.484780278081) | |||
| 57488 | 57488 | 250555 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988156.37986 | 2115366.75845 | 37.7877098242971 | -122.484805955556 | (37.7877098242971, -122.484805955556) | |||
| 63881 | 63881 | 129374 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 454 Walnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998634.47077 | 2115144.9555599997 | 37.7877054985629 | -122.448537946784 | (37.7877054985629, -122.448537946784) | |||
| 147108 | 147108 | 79224 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3562 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2001 12:00:00 AM | 6 | 5997807.39537 | 2115154.90167 | 37.787685483256396 | -122.451400172276 | (37.7876854832564, -122.451400172276) | ||
| 161226 | 161226 | 129375 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 454 Walnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998637.857999999 | 2115126.2699599997 | 37.7876543864995 | -122.448524881439 | (37.7876543864995, -122.448524881439) | |||
| 41903 | 41903 | 73594 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2014 12:00:00 AM | 3 | Permit Number 772812 | 6008453.79298 | 2114896.74793 | 37.787580529660794 | -122.41454729843399 | (37.7875805296608, -122.414547298434) | |
| 24713 | 24713 | 71549 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772812 | 6008431.05429 | 2114892.38013 | 37.7875672592553 | -122.41462566084101 | (37.7875672592553, -122.414625660841) |
| 118027 | 118027 | 79726 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50955 | 6008416.19534554 | 2114892.53002417 | 37.7875668360064 | -122.414677080613 | (37.7875668360064, -122.414677080613) | ||
| 146911 | 146911 | 79199 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 409 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777130 | 5998120.56156 | 2115036.84682 | 37.7873792631851 | -122.450308169597 | (37.7873792631851, -122.450308169597) | |
| 166649 | 166649 | 50185 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 139 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49870 | 5987999.15348 | 2115065.15007 | 37.7868725355783 | -122.485327781661 | (37.7868725355783, -122.485327781661) | |
| 34436 | 34436 | 88394 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 139 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51373 | 5988000.05712 | 2115038.19323 | 37.78679857243979 | -122.485322676521 | (37.7867985724398, -122.485322676521) | ||
| 38736 | 38736 | 100491 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3978 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770312 | 5995766.62837 | 2114872.73446 | 37.786793659691895 | -122.45844035359801 | (37.7867936596919, -122.458440353598) | |
| 72194 | 72194 | 121883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 18th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5990230.48175 | 2114847.31405 | 37.786404156248004 | -122.477592056385 | (37.786404156248, -122.477592056385) | |||
| 35773 | 35773 | 121884 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 18th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5990230.5783400005 | 2114834.8193200002 | 37.78636985483121 | -122.477590808601 | (37.7863698548312, -122.477590808601) | |||
| 134106 | 134106 | 94712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 119 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53849 | 5993940.39408 | 2114713.66519 | 37.7862517797866 | -122.46474709013 | (37.7862517797866, -122.46474709013) |
| 26324 | 26324 | 50815 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 131 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2004 12:00:00 AM | 4 | Permit Number 47338 | 5993943.23893 | 2114634.67726 | 37.7860350644754 | -122.464731509757 | (37.7860350644754, -122.464731509757) | ||
| 60676 | 60676 | 129381 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 555 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008630.87446 | 2114175.52263 | 37.7856101663154 | -122.41388359157699 | (37.7856101663154, -122.413883591577) | |||
| 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) | ||
| 1367 | 1367 | 36152 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 4 | Permit Number 39237 | 5996489.9045 | 2114249.7041 | 37.7851245233187 | -122.455892946486 | (37.7851245233187, -122.455892946486) | |
| 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) | ||||
| 49688 | 49688 | 119982 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5987459.3505 | 2114288.69945 | 37.7847091625278 | -122.487138302864 | (37.7847091625278, -122.487138302864) | |||
| 152382 | 152382 | 250789 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 285 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5985873.63674 | 2113998.18517 | 37.7838189038641 | -122.492602865457 | (37.7838189038641, -122.492602865457) | |||
| 101502 | 101502 | 111713 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 145461 | 145461 | 111714 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 182506 | 182506 | 83202 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987450.31295 | 2113217.36399 | 37.7817670537285 | -122.487090859235 | (37.7817670537285, -122.487090859235) | |||
| 176219 | 176219 | 88398 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51376 | 5987449.923219999 | 2113199.01189 | 37.7817166413541 | -122.48709085924 | (37.7817166413541, -122.48709085924) | |
| 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) | ||
| 43034 | 43034 | 140758 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 42 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000316.7782 | 2112875.0348 | 37.781568928755895 | -122.442554464995 | (37.7815689287559, -122.442554464995) | |||
| 74310 | 74310 | 129384 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008749.2926 | 2112454.6236099997 | 37.7808916402666 | -122.41335215429399 | (37.7808916402666, -122.413352154294) | |||
| 183197 | 183197 | 129383 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008721.10925 | 2112450.3341200002 | 37.7808782799549 | -122.413449351208 | (37.7808782799549, -122.413449351208) | |||
| 172851 | 172851 | 129382 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008704.563080001 | 2112447.63135 | 37.7808699297471 | -122.41350640150401 | (37.7808699297471, -122.413506401504) | |||
| 162362 | 162362 | 96799 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 438 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 2 | Permit Number 769004 | 5983479.2923099995 | 2112857.21489 | 37.780545845051705 | -122.500801866987 | (37.7805458450517, -122.500801866987) | ||
| 132114 | 132114 | 96082 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 448 43rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767705 | 5982547.81502 | 2112777.5539599997 | 37.7802723877651 | -122.50401833246299 | (37.7802723877651, -122.504018332463) | |
| 43413 | 43413 | 251006 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 348 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5981660.38525 | 2112713.01394 | 37.780042954548705 | -122.50708351880199 | (37.7800429545487, -122.507083518802) | |||
| 166285 | 166285 | 251003 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 Point Lobos Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5981957.64195 | 2112675.6435700003 | 37.7799578490271 | -122.506052420011 | (37.7799578490271, -122.506052420011) | |||
| 26381 | 26381 | 251002 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5981992.43445 | 2112670.6708 | 37.7799462432625 | -122.50593169049299 | (37.7799462432625, -122.505931690493) | |||
| 38391 | 38391 | 251001 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 232 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5982033.34511 | 2112665.09757 | 37.7799333487875 | -122.505789751407 | (37.7799333487875, -122.505789751407) | |||
| 180010 | 180010 | 118666 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 465 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5982506.22463 | 2112651.7557200002 | 37.779924536981504 | -122.50415288931299 | (37.7799245369815, -122.504152889313) | |||
| 48322 | 48322 | 251000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 226 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5982074.747269999 | 2112660.45291 | 37.7799230326473 | -122.505646180935 | (37.7799230326473, -122.505646180935) | |||
| 164615 | 164615 | 250999 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 206 Point Lobos Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5982160.80138 | 2112648.7463599998 | 37.7798959540729 | -122.505347618625 | (37.7798959540729, -122.505347618625) | |||
| 119389 | 119389 | 24747 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 200X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/1999 12:00:00 AM | 3 | 3X3 | 5982215.35166 | 2112638.47493 | 37.779870961567894 | -122.505158146759 | (37.7798709615679, -122.505158146759) | ||
| 133488 | 133488 | 118589 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 150 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982275.325019999 | 2112634.79146 | 37.779864376411 | -122.50495040283998 | (37.779864376411, -122.50495040284) | |||
| 35959 | 35959 | 118588 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 150 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982305.68238 | 2112631.11012 | 37.779856054488604 | -122.50484511221701 | (37.7798560544886, -122.504845112217) | |||
| 118920 | 118920 | 113357 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 POINT LOBOS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 5982777.0 | 2112621.0 | 37.779856011140204 | -122.50321389449499 | (37.7798560111402, -122.503213894495) | ||||
| 166344 | 166344 | 118587 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 140 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982334.052630001 | 2112627.33977 | 37.7798473711823 | -122.504746689196 | (37.7798473711823, -122.504746689196) | |||
| 25668 | 25668 | 118581 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 104 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982478.43556 | 2112606.9372400003 | 37.7797998443253 | -122.504245701476 | (37.7797998443253, -122.504245701476) | |||
| 161979 | 161979 | 117687 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 8ft | 5982599.26265 | 2112595.13886 | 37.7797745547632 | -122.50382684040501 | (37.7797745547632, -122.503826840405) | |||
| 132152 | 132152 | 117686 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 34 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5982669.571880001 | 2112585.47797 | 37.7797521626965 | -122.503582898398 | (37.7797521626965, -122.503582898398) | |||
| 152469 | 152469 | 113356 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 5982735.90689 | 2112577.0088400003 | 37.7797328087219 | -122.503352793138 | (37.7797328087219, -122.503352793138) | |||
| 38258 | 38258 | 113355 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 5982766.03998 | 2112575.4615 | 37.779730331527404 | -122.503248436763 | (37.7797303315274, -122.503248436763) | |||
| 119386 | 119386 | 24739 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2004 12:00:00 AM | 3 | 3X3 | 5982782.27657 | 2112574.64249 | 37.7797290371816 | -122.503192207591 | (37.7797290371816, -122.503192207591) | ||
| 80627 | 80627 | 24740 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/07/2012 12:00:00 AM | 3 | 3X3 | 5982774.3423 | 2112574.7084 | 37.779728751764104 | -122.503219660118 | (37.7797287517641, -122.503219660118) | ||
| 27198 | 27198 | 140780 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 5 Encanto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000014.7367 | 2112198.3604 | 37.7796937331341 | -122.44355075738399 | (37.7796937331341, -122.443550757384) | |||
| 52877 | 52877 | 118595 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982415.15882 | 2112561.71552 | 37.7796719571588 | -122.504461248614 | (37.7796719571588, -122.504461248614) | |||
| 58669 | 58669 | 118593 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5982449.24993 | 2112557.22359 | 37.7796616287576 | -122.504342981812 | (37.7796616287576, -122.504342981812) | |||
| 153714 | 153714 | 118592 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5982471.06333 | 2112548.68274 | 37.779639461018796 | -122.504266888216 | (37.7796394610188, -122.504266888216) | |||
| 28135 | 28135 | 41812 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999993.4162 | 2112171.4558 | 37.7796186440476 | -122.44362258073 | (37.7796186440476, -122.44362258073) | |
| 48341 | 48341 | 41809 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 2 | Permit Number 42201 | 5999967.3577 | 2112168.7485 | 37.779609724261896 | -122.443712533479 | (37.7796097242619, -122.443712533479) | |
| 41560 | 41560 | 41808 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999945.6987 | 2112165.7027 | 37.7796001259133 | -122.44378724216601 | (37.7796001259133, -122.443787242166) | |
| 71350 | 71350 | 41807 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999913.2102 | 2112161.3032 | 37.7795861928813 | -122.443899317319 | (37.7795861928813, -122.443899317319) | |
| 4697 | 4697 | 60547 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 507 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2017 09:50:00 AM | 3 | Permit Number 20157 | 5984999.38205 | 2112385.8100400004 | 37.779340631831495 | -122.49550845523501 | (37.7793406318315, -122.495508455235) | |
| 48823 | 48823 | 39959 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 492 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 2 | Permit Number 43327 | 5993771.39961 | 2112170.75464 | 37.7792598926327 | -122.465146995833 | (37.7792598926327, -122.465146995833) | |
| 137957 | 137957 | 88614 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 521 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51567 | 5994972.3051 | 2111963.78431 | 37.7787607840169 | -122.460977590338 | (37.7787607840169, -122.460977590338) |
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");