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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77 | 77 | 49739 | Permitted Site 1 | Tree(s) :: 17 | 145 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2017 12:00:00 AM | 3 | Permit Number 779552 | 6013462.1222 | 2106403.54987 | 37.764540227980206 | -122.396623740816 | (37.7645402279802, -122.396623740816) | |
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 1863 | 1863 | 33121 | Permitted Site 1 | Tree(s) :: 17 | 2360 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2017 12:00:00 AM | 3 | Permit Number 780047 | 6001597.15977 | 2119079.49 | 37.7986776600995 | -122.438569654391 | (37.7986776600995, -122.438569654391) | |
| 2039 | 2039 | 45572 | Permitted Site 1 | Tree(s) :: 17 | 1951 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2017 12:00:00 AM | 3 | Permit Number 779446 | 5999433.18152 | 2115607.6653299998 | 37.7890216140951 | -122.44580786133999 | (37.7890216140951, -122.44580786134) | |
| 2215 | 2215 | 62177 | Permitted Site 1 | Tree(s) :: 17 | 33 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1985 12:00:00 AM | 15 | 3x3 | Permit Number 780357 | 6000151.498869999 | 2091775.04378 | 37.723624054296295 | -122.44161159051599 | (37.7236240542963, -122.441611590516) |
| 3061 | 3061 | 61313 | Permitted Site 1 | Tree(s) :: 17 | 1355 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2017 12:00:00 AM | 3 | Permit Number 780590 | 6011741.38821 | 2102064.0767099997 | 37.752529078769896 | -122.402270200829 | (37.7525290787699, -122.402270200829) | |
| 3291 | 3291 | 41799 | Permitted Site 1 | Tree(s) :: 17 | 101 Henry Adams St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780552 | 6011423.81805 | 2107722.81991 | 37.7680489940823 | -122.403766558473 | (37.7680489940823, -122.403766558473) |
| 3912 | 3912 | 38150 | Permitted Site 1 | Tree(s) :: 17 | 200 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 12:00:00 AM | 3 | Permit Number 780230 | 6010281.37407 | 2093721.8548299999 | 37.7295415331127 | -122.40673134359899 | (37.7295415331127, -122.406731343599) | |
| 4771 | 4771 | 253556 | Permitted Site 1 | Tree(s) :: 17 | 27 Ceres St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 AM | 3 | Permit Number 780682 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
| 4832 | 4832 | 70442 | Undocumented 2 | Tree(s) :: 17 | 2470 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | |
| 5221 | 5221 | 72132 | Undocumented 2 | Tree(s) :: 17 | 950 Wisconsin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 12/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 780813 | 6012748.1522699995 | 2103075.8524599997 | 37.755363341648795 | -122.398859619973 | (37.7553633416488, -122.398859619973) |
| 6961 | 6961 | 68131 | Permitted Site 1 | Tree(s) :: 17 | 1512 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2014 12:00:00 AM | 3 | Permit Number 773861 | 6000696.77 | 2113847.7478 | 37.7842614019342 | -122.441309693767 | (37.7842614019342, -122.441309693767) | |
| 7309 | 7309 | 64383 | Permitted Site 1 | Tree(s) :: 17 | 1727 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773289 | 6010433.5649 | 2120449.6261 | 37.802938410361 | -122.40808941120001 | (37.802938410361, -122.4080894112) |
| 7434 | 7434 | 59955 | Permitted Site 1 | Tree(s) :: 17 | 580 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2015 12:00:00 AM | 3 | Permit Number 773594 | 6005099.7952 | 2110963.7011 | 37.776592355427205 | -122.425871407663 | (37.7765923554272, -122.425871407663) | |
| 7905 | 7905 | 30963 | Permitted Site 1 | Tree(s) :: 17 | 1900 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2016 12:00:00 AM | 3 | Permit Number 778453 | 6001995.095 | 2115110.3689 | 37.787802110792704 | -122.43690837559099 | (37.7878021107927, -122.436908375591) | |
| 9041 | 9041 | 42494 | Permitted Site 1 | Tree(s) :: 17 | 698X Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2016 12:00:00 AM | 3 | Permit Number 779155 | 5996831.0 | 2094462.0 | 37.7308120537964 | -122.453283804485 | (37.7308120537964, -122.453283804485) | |
| 9831 | 9831 | 36377 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | 2x2 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) |
| 9832 | 9832 | 36376 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | |
| 10027 | 10027 | 122385 | Undocumented 2 | Tree(s) :: 17 | 1642 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 778904 | 5990935.0 | 2104213.0 | 37.7572460781285 | -122.474378311379 | (37.7572460781285, -122.474378311379) | ||
| 10160 | 10160 | 37874 | Permitted Site 1 | Tree(s) :: 17 | 175 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2017 12:00:00 AM | 3 | Permit Number 779358 | 5996105.27424077 | 2094054.94489501 | 37.7296527551899 | -122.455763326175 | (37.7296527551899, -122.455763326175) | |
| 10181 | 10181 | 37872 | Permitted Site 1 | Tree(s) :: 17 | 175 Colon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2017 12:00:00 AM | 3 | Permit Number 779358 | 5996105.27424077 | 2094054.94489501 | 37.7296527551899 | -122.455763326175 | (37.7296527551899, -122.455763326175) | |
| 10182 | 10182 | 37873 | Permitted Site 1 | Tree(s) :: 17 | 175 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2017 12:00:00 AM | 3 | Permit Number 779358 | 5996105.27424077 | 2094054.94489501 | 37.7296527551899 | -122.455763326175 | (37.7296527551899, -122.455763326175) | |
| 10205 | 10205 | 34128 | Permitted Site 1 | Tree(s) :: 17 | 1401 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2017 12:00:00 AM | 3 | Permit Number 779521 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.45662648597799 | (37.7276243745144, -122.456626485978) | |
| 10270 | 10270 | 41911 | Permitted Site 1 | Tree(s) :: 17 | 595 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2017 12:00:00 AM | 3 | Permit Number 778901 | 5992201.12975 | 2111434.05815 | 37.7771464503181 | -122.47052549063999 | (37.7771464503181, -122.47052549064) | |
| 12605 | 12605 | 38122 | Permitted Site 1 | Tree(s) :: 17 | 1355 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/07/2015 12:00:00 AM | 3 | Permit Number 776164 | 5986460.6131 | 2106032.8209 | 37.7619825625653 | -122.48998611957701 | (37.7619825625653, -122.489986119577) | |
| 12715 | 12715 | 70439 | Undocumented 2 | Tree(s) :: 17 | 2426 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773392 | 5983041.4986 | 2098597.8907 | 37.7413680695353 | -122.501261346997 | (37.7413680695353, -122.501261346997) |
| 18078 | 18078 | 34424 | Permitted Site 1 | Tree(s) :: 17 | 245 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2015 12:00:00 AM | Permit Number 776476 | 6003617.84008567 | 2095979.02625995 | 37.735364130918796 | -122.429928789613 | (37.7353641309188, -122.429928789613) | ||
| 19506 | 19506 | 61468 | Permitted Site 1 | Tree(s) :: 17 | 348 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2016 12:00:00 AM | 3 | Permit Number 777176 | 6004159.4203704 | 2106880.97501526 | 37.765328995236004 | -122.428833307398 | (37.765328995236, -122.428833307398) | |
| 19671 | 19671 | 50858 | Permitted Site 1 | Tree(s) :: 17 | 201 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2007 12:00:00 AM | Permit No. 49272 | 6005487.62164601 | 2107821.09181059 | 37.767985417744896 | -122.424306235525 | (37.7679854177449, -122.424306235525) | ||
| 23636 | 23636 | 31756 | Permitted Site 1 | Tree(s) :: 17 | 2450 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35242 | 5989554.0796 | 2098675.0659 | 37.7419602704622 | -122.478749009163 | (37.7419602704622, -122.478749009163) | |
| 30526 | 30526 | 65800 | Permitted Site 1 | Tree(s) :: 17 | 2207 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/2016 12:00:00 AM | 3 | Permit Number 777549 | 5990993.94866564 | 2100373.41600695 | 37.7467070009861 | -122.473894331539 | (37.7467070009861, -122.473894331539) | |
| 30576 | 30576 | 70371 | Undocumented 2 | Tree(s) :: 17 | 1470 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2015 12:00:00 AM | 7 | Permit Number 776609 | 5983120.8169 | 2105139.9902 | 37.759335513294396 | -122.50147093465598 | (37.7593355132944, -122.501470934656) | |
| 30737 | 30737 | 73237 | Undocumented 2 | Tree(s) :: 17 | 2609 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 4 | 6000014.0127 | 2114014.6742 | 37.7846808214882 | -122.44368378171801 | (37.7846808214882, -122.443683781718) | ||
| 40648 | 40648 | 47075 | Permitted Site 1 | Tree(s) :: 17 | 106 Beaumont Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 1 | Permit Number 45062 | 5996790.5922 | 2112343.8817 | 37.7799088922744 | -122.454714927889 | (37.7799088922744, -122.454714927889) | |
| 41317 | 41317 | 61331 | Permitted Site 1 | Tree(s) :: 17 | 1920 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2012 12:00:00 AM | 4 | Permit Number 768883 | 5999952.62565133 | 2111287.45936794 | 37.7771890895601 | -122.44370016820801 | (37.7771890895601, -122.443700168208) | |
| 41373 | 41373 | 40043 | Permitted Site 1 | Tree(s) :: 17 | 1318 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 3 | Permit Number 41280 | 6016753.7891 | 2093547.2013 | 37.7294219844577 | -122.3843431768 | (37.7294219844577, -122.3843431768) | |
| 41783 | 41783 | 69037 | Permitted Site 1 | Tree(s) :: 17 | 1449 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 4 | 3x3 | Permit Number 33043 | 5984311.7811 | 2105306.0319 | 37.7598612914512 | -122.49736432153999 | (37.7598612914512, -122.49736432154) |
| 44253 | 44253 | 66971 | Permitted Site 1 | Tree(s) :: 17 | 163 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2014 12:00:00 AM | 7 | Permit Number 773168 | 5996818.3428 | 2111877.5365 | 37.778630022687395 | -122.454585227328 | (37.7786300226874, -122.454585227328) | |
| 49251 | 49251 | 79990 | Undocumented 2 | Tree(s) :: 17 | 3655 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2005 12:00:00 AM | 5 | 5981694.1032 | 2096684.9357 | 37.736036404783796 | -122.505778307285 | (37.7360364047838, -122.505778307285) | ||
| 50025 | 50025 | 31583 | Permitted Site 1 | Tree(s) :: 17 | 1894 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/2014 12:00:00 AM | 6 | Permit Number 772450 | 5988802.032000001 | 2102448.7219 | 37.7522780370894 | -122.481625643256 | (37.7522780370894, -122.481625643256) | |
| 51514 | 51514 | 65987 | Permitted Site 1 | Tree(s) :: 17 | 562 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1990 12:00:00 AM | Permit Number 29017 | 6011019.59487131 | 2116505.8764121 | 37.7921426252031 | -122.405783475493 | (37.7921426252031, -122.405783475493) | ||
| 61936 | 61936 | 66108 | Permitted Site 1 | Tree(s) :: 17 | 2362 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/2014 12:00:00 AM | 1 | 3x3 | Permit Number 772928 | 5983332.1796 | 2099071.547 | 37.742685666006395 | -122.50029129955401 | (37.7426856660064, -122.500291299554) |
| 62316 | 62316 | 70381 | Undocumented 2 | Tree(s) :: 17 | 1454 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5982184.823 | 2105192.1683 | 37.7594237635385 | -122.50471186838499 | (37.7594237635385, -122.504711868385) | ||
| 62873 | 62873 | 92335 | Permitted Site 1 | Tree(s) :: 17 | 1970 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/2015 12:00:00 AM | 2 | 3x3 | Permit Number 776964 | 5986336.5649 | 2101845.3156 | 37.7504775757385 | -122.49010712277399 | (37.7504775757385, -122.490107122774) |
| 63550 | 63550 | 49945 | Permitted Site 1 | Tree(s) :: 17 | 2342 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 3 | Permit Number 46703 | 5986114.5688 | 2099288.7531 | 37.7434449787261 | -122.490686709517 | (37.7434449787261, -122.490686709517) | |
| 64873 | 64873 | 61917 | Permitted Site 1 | Tree(s) :: 17 | 466 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2011 12:00:00 AM | Permit Number 56835 | 6005671.64086161 | 2107867.23893534 | 37.7681225159523 | -122.42367301409901 | (37.7681225159523, -122.423673014099) | ||
| 66019 | 66019 | 111476 | Permitted Site 1 | Tree(s) :: 17 | 2x TRAINOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | |||
| 74410 | 74410 | 64548 | Permitted Site 1 | Tree(s) :: 17 | 1419 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 10 | Permit Number 774050 | 6015523.2809 | 2094949.9929 | 37.7332056516757 | -122.388695084393 | (37.7332056516757, -122.388695084393) | |
| 74484 | 74484 | 43546 | Permitted Site 1 | Tree(s) :: 17 | 1819 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 5 | Permit Number 43210 | 6000386.6564 | 2111295.4007 | 37.7772356400413 | -122.442199292355 | (37.7772356400413, -122.442199292355) | |
| 74946 | 74946 | 32774 | Permitted Site 1 | Tree(s) :: 17 | 538 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2014 12:00:00 AM | 4 | Permit Number 770870 | 6001146.4846 | 2110608.6957 | 37.775393395823606 | -122.43952157023399 | (37.7753933958236, -122.439521570234) | |
| 75749 | 75749 | 48955 | Permitted Site 1 | Tree(s) :: 17 | 2710 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2002 12:00:00 AM | Permit Number 46142 | 6008905.89648049 | 2102666.1035566004 | 37.7540234236093 | -122.412118393253 | (37.7540234236093, -122.412118393253) | ||
| 77522 | 77522 | 43558 | Permitted Site 1 | Tree(s) :: 17 | 556 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776806 | 6002301.81672253 | 2099470.8115862 | 37.7448771459543 | -122.434728379076 | (37.7448771459543, -122.434728379076) | ||
| 77691 | 77691 | 63661 | Permitted Site 1 | Tree(s) :: 17 | 478 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779161 | 6003414.6876897 | 2100122.82585576 | 37.7467305432329 | -122.43092680414699 | (37.7467305432329, -122.430926804147) | |
| 78456 | 78456 | 31794 | Permitted Site 1 | Tree(s) :: 17 | 135 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/2015 12:00:00 AM | Permit Number 775857 | 6001317.37619782 | 2108550.8717799997 | 37.7697528504481 | -122.43878292419 | (37.7697528504481, -122.43878292419) | ||
| 79005 | 79005 | 31812 | Permitted Site 1 | Tree(s) :: 17 | 99 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.768975877879896 | -122.436695073767 | (37.7689758778799, -122.436695073767) | ||
| 80054 | 80054 | 63240 | Permitted Site 1 | Tree(s) :: 17 | 3630-3632 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/2013 12:00:00 AM | 12 | 3x3 | Permit Number 769849 | 6006088.29647773 | 2104364.06352525 | 37.75852713188279 | -122.42198295538799 | (37.7585271318828, -122.421982955388) |
| 80532 | 80532 | 53085 | Permitted Site 1 | Tree(s) :: 17 | 191@ WHITNEY Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2006 12:00:00 AM | Permit Number 49052 | 6004418.2123833 | 2097211.38982763 | 37.7387932164166 | -122.42724936043301 | (37.7387932164166, -122.427249360433) | ||
| 81538 | 81538 | 63218 | Permitted Site 1 | Tree(s) :: 17 | 454 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2015 12:00:00 AM | 3 | Permit Number 775238 | 5984722.44692053 | 2112804.45455059 | 37.7804738886083 | -122.496497376024 | (37.7804738886083, -122.496497376024) | |
| 81542 | 81542 | 102317 | Permitted Site 1 | Tree(s) :: 17 | 51 Arnold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6006607.7 | 2095553.8 | 37.7343654214358 | -122.419561552483 | (37.7343654214358, -122.419561552483) | |||
| 82011 | 82011 | 58866 | Permitted Site 1 | Tree(s) :: 17 | 27 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2006 12:00:00 AM | Permit Number 18126 | 5998507.54065237 | 2107215.37491712 | 37.7659256589143 | -122.44840583592699 | (37.7659256589143, -122.448405835927) | ||
| 82075 | 82075 | 36570 | Permitted Site 1 | Tree(s) :: 17 | 133 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2014 12:00:00 AM | Permit Number 773080 | 6006339.29055152 | 2097508.67729568 | 37.7397179573591 | -122.42062825899099 | (37.7397179573591, -122.420628258991) | ||
| 82256 | 82256 | 46839 | Permitted Site 1 | Tree(s) :: 17 | 298 Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/2016 12:00:00 AM | 3 | Permit Number 778889 | 6004393.42189905 | 2090714.06413365 | 37.72095160713771 | -122.42687247108401 | (37.7209516071377, -122.426872471084) | |
| 82444 | 82444 | 40532 | Permitted Site 1 | Tree(s) :: 17 | 169 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 776065 | 5993382.53676631 | 2094483.25805098 | 37.7306721640024 | -122.465207140084 | (37.7306721640024, -122.465207140084) | ||
| 83183 | 83183 | 46821 | Permitted Site 1 | Tree(s) :: 17 | 478 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2013 12:00:00 AM | 5 | 3x3 | Permit Number 770370 | 6003653.90242727 | 2090553.77488483 | 37.7204696462922 | -122.429417343863 | (37.7204696462922, -122.429417343863) |
| 83500 | 83500 | 69076 | Permitted Site 1 | Tree(s) :: 17 | 1425 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/2016 12:00:00 AM | 3 | Permit Number 777977 | 5990812.29366182 | 2105693.6463457 | 37.7613044295825 | -122.474910748597 | (37.7613044295825, -122.474910748597) | |
| 83572 | 83572 | 64692 | Permitted Site 1 | Tree(s) :: 17 | 3154 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/1988 12:00:00 AM | Permit Number 25635 | 6007753.91403584 | 2106213.64737052 | 37.7636994595275 | -122.416353490139 | (37.7636994595275, -122.416353490139) | ||
| 84078 | 84078 | 31810 | Permitted Site 1 | Tree(s) :: 17 | 99 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.768975877879896 | -122.436695073767 | (37.7689758778799, -122.436695073767) | ||
| 84207 | 84207 | 111479 | Permitted Site 1 | Tree(s) :: 17 | 2x TRAINOR ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | |||
| 84393 | 84393 | 94908 | Permitted Site 1 | Tree(s) :: 17 | 72 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2010 12:00:00 AM | 3x3 | Permit Number 53966 | 6007392.0 | 2098971.0 | 37.7437924437225 | -122.41709201753099 | (37.7437924437225, -122.417092017531) | |
| 84487 | 84487 | 32097 | Permitted Site 1 | Tree(s) :: 17 | 120 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2014 12:00:00 AM | 3 | Permit Number 773394 | 6002642.78557008 | 2105187.99006098 | 37.7605945117309 | -122.43395796110902 | (37.7605945117309, -122.433957961109) | |
| 84768 | 84768 | 63088 | Permitted Site 1 | Tree(s) :: 17 | 354 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1986 12:00:00 AM | Permit Number 770432 | 6007694.44064518 | 2097453.04033367 | 37.7396414722296 | -122.415938775 | (37.7396414722296, -122.415938775) | ||
| 85004 | 85004 | 34417 | Permitted Site 1 | Tree(s) :: 17 | 279 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 770972 | 6003795.94277526 | 2097823.50841376 | 37.7404387429926 | -122.42944451706002 | (37.7404387429926, -122.42944451706) | ||
| 85053 | 85053 | 46188 | Permitted Site 1 | Tree(s) :: 17 | 780 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2011 12:00:00 AM | 3x3 | Permit Number 768223 | 5997150.49053966 | 2107881.60530605 | 37.7676772760194 | -122.453147666398 | (37.7676772760194, -122.453147666398) | |
| 85436 | 85436 | 100225 | Permitted Site 1 | Tree(s) :: 17 | 101X Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004128.9 | 2102465.7 | 37.7532039716563 | -122.428624108827 | (37.7532039716563, -122.428624108827) | |
| 85905 | 85905 | 40858 | Permitted Site 1 | Tree(s) :: 17 | 1670 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2016 12:00:00 AM | 3 | Permit Number 778806 | 6009721.65724328 | 2100087.27684169 | 37.746988275084895 | -122.409115329349 | (37.7469882750849, -122.409115329349) | |
| 86182 | 86182 | 67379 | Permitted Site 1 | Tree(s) :: 17 | 811 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/2013 12:00:00 AM | Permit Number 769501 | 5993117.56906479 | 2111365.22758445 | 37.7770104083875 | -122.467350258179 | (37.7770104083875, -122.467350258179) | ||
| 86311 | 86311 | 101001 | Undocumented 2 | Tree(s) :: 17 | 500X Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/2012 12:00:00 AM | Permit Number 769389 | 6008398.5 | 2096033.1 | 37.7357821841588 | -122.413404038925 | (37.7357821841588, -122.413404038925) | ||
| 86499 | 86499 | 32277 | Permitted Site 1 | Tree(s) :: 17 | 944 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/2013 12:00:00 AM | 3x3 | Permit Number 769138 | 6003101.07553731 | 2102742.21815956 | 37.7539050033068 | -122.432198276476 | (37.7539050033068, -122.432198276476) | |
| 86697 | 86697 | 41288 | Permitted Site 1 | Tree(s) :: 17 | 552-554 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2000 12:00:00 AM | 3 | 3x3 | Permit Number 771150 | 6005120.37250824 | 2107836.80061549 | 37.7680078062065 | -122.42557762883301 | (37.7680078062065, -122.425577628833) |
| 86981 | 86981 | 31835 | Permitted Site 1 | Tree(s) :: 17 | 237 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35291 | 6009638.9380413 | 2109067.0653134 | 37.771640108885606 | -122.41003520238998 | (37.7716401088856, -122.41003520239) | ||
| 87478 | 87478 | 43229 | Permitted Site 1 | Tree(s) :: 17 | 1367 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773263 | 5989870.53533028 | 2106067.55897718 | 37.762276471885706 | -122.478195197482 | (37.7622764718857, -122.478195197482) |
| 87943 | 87943 | 65850 | Permitted Site 1 | Tree(s) :: 17 | 67 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 9 | 3x3 | Permit Number 770220 | 6001319.42927239 | 2121416.09155385 | 37.8050775459314 | -122.439698294296 | (37.8050775459314, -122.439698294296) |
| 88448 | 88448 | 68868 | Permitted Site 1 | Tree(s) :: 17 | 131 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2015 12:00:00 AM | Permit Number 776250 | 5999210.16726242 | 2093759.37669383 | 37.729018894566 | -122.44500818101601 | (37.729018894566, -122.445008181016) | ||
| 88542 | 88542 | 37933 | Permitted Site 1 | Tree(s) :: 17 | 555 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/2012 12:00:00 AM | Permit Number 769142 | 6015867.85661054 | 2105328.6464788 | 37.76172237071 | -122.38822785970301 | (37.76172237071, -122.388227859703) | ||
| 88892 | 88892 | 42921 | Permitted Site 1 | Tree(s) :: 17 | 2399 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/28/2014 12:00:00 AM | Permit Number 772558 | 6009716.72366272 | 2103393.40144797 | 37.7560658822202 | -122.40936566949499 | (37.7560658822202, -122.409365669495) | ||
| 90602 | 90602 | 52301 | Permitted Site 1 | Tree(s) :: 17 | 40 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/2013 12:00:00 AM | 9 | 3x3 | Permit Number 769780 | 6001665.92153751 | 2105591.90634568 | 37.7616480821365 | -122.437365407078 | (37.7616480821365, -122.437365407078) |
| 91217 | 91217 | 33109 | Permitted Site 1 | Tree(s) :: 17 | 3033 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37347 | 6000472.52041077 | 2118667.88075678 | 37.797483451112704 | -122.442431687357 | (37.7974834511127, -122.442431687357) | ||
| 91244 | 91244 | 62879 | Permitted Site 1 | Tree(s) :: 17 | 278 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1986 12:00:00 AM | Permit Number 771206 | 6008220.17562651 | 2097285.74539631 | 37.739211660574796 | -122.414109170863 | (37.7392116605748, -122.414109170863) | ||
| 91308 | 91308 | 64393 | Permitted Site 1 | Tree(s) :: 17 | 1404 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776674 | 6003891.86083892 | 2100091.12141479 | 37.7466705157706 | -122.429274526717 | (37.7466705157706, -122.429274526717) | ||
| 91435 | 91435 | 66644 | Permitted Site 1 | Tree(s) :: 17 | 2700 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | Permit Number 29855 | 6009925.41529066 | 2103991.79272413 | 37.7577206208361 | -122.40868615341101 | (37.7577206208361, -122.408686153411) | ||
| 91883 | 91883 | 69105 | Permitted Site 1 | Tree(s) :: 17 | 1746 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2014 12:00:00 AM | Permit Number 773015 | 5992515.58805804 | 2103677.38967785 | 37.7558668777692 | -122.468873094813 | (37.7558668777692, -122.468873094813) | ||
| 91910 | 91910 | 38831 | Permitted Site 1 | Tree(s) :: 17 | 4752 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2010 12:00:00 AM | Permit Number 53215 | 5992891.16777932 | 2114175.89899282 | 37.7847146745833 | -122.468337971559 | (37.7847146745833, -122.468337971559) | ||
| 92062 | 92062 | 100665 | Permitted Site 1 | Tree(s) :: 17 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | FUF 1 | 09/04/2012 12:00:00 AM | 3x3 | Permit Number 769258 | 6003201.8 | 2107946.7 | 37.768200969529204 | -122.432221606092 | (37.7682009695292, -122.432221606092) | |
| 92281 | 92281 | 36723 | Permitted Site 1 | Tree(s) :: 17 | 59 RAMONA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2014 12:00:00 AM | Permit Number 771005 | 6005243.7 | 2107472.6 | 37.7670147661944 | -122.42512513476002 | (37.7670147661944, -122.42512513476) | ||
| 92379 | 92379 | 34422 | Permitted Site 1 | Tree(s) :: 17 | 130 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 771757 | 6003402.32347703 | 2096169.98346751 | 37.735876248452 | -122.43068753255301 | (37.735876248452, -122.430687532553) | ||
| 93054 | 93054 | 65768 | Permitted Site 1 | Tree(s) :: 17 | 1918 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777006 | 6003756.36713634 | 2119034.39129688 | 37.798676420037495 | -122.431094890587 | (37.7986764200375, -122.431094890587) |
| 93324 | 93324 | 32776 | Tree(s) :: 17 | 552 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/20/2010 12:00:00 AM | Permit Number 54024 | 6001158.24288979 | 2110568.68225327 | 37.775284198166496 | -122.43947802668 | (37.7752841981665, -122.43947802668) | |||
| 93463 | 93463 | 98506 | Undocumented 2 | Tree(s) :: 17 | 135 Sussex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042.0 | 2096528.0 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | |
| 93597 | 93597 | 43203 | Permitted Site 1 | Tree(s) :: 17 | 145X Boylston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2013 12:00:00 AM | Permit Number 770459 | 6009104.22811123 | 2094637.94494348 | 37.731990987741106 | -122.410865546677 | (37.7319909877411, -122.410865546677) | ||
| 93607 | 93607 | 50857 | Permitted Site 1 | Tree(s) :: 17 | 201 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2007 12:00:00 AM | Permit No. 49272 | 6005487.62164601 | 2107821.09181059 | 37.767985417744896 | -122.424306235525 | (37.7679854177449, -122.424306235525) |
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");