trees
3,709 rows where qSpecies_id = 9 sorted by DBH
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43500 | 103583 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
| 43692 | 88726 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1005 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742 | 2109408 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | 15 | 5 | 11 | 29492 | 9 | ||
| 44185 | 47155 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 401X Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | Permit Number 45125 | 5993485.13149709 | 2093664.18210859 | 37.7284290986601 | -122.464792998786 | (37.7284290986601, -122.464792998786) | 9 | 8 | 4 | 59 | 40 | ||
| 44446 | 36904 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4375 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767280 | 6000774.94181487 | 2102264.44769346 | 37.75246099878 | -122.440208312423 | (37.75246099878, -122.440208312423) | 2 | 4 | 5 | 28862 | 22 | |
| 44707 | 75866 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 500X 30TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1989 12:00:00 AM | 3x3 | 5986580 | 2112184 | 37.7788789460419 | -122.490025663538 | (37.7788789460419, -122.490025663538) | 11 | 6 | 2 | 55 | 26 | |||
| 44891 | 75821 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 500X 30TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1989 12:00:00 AM | 3x3 | 5986580 | 2112184 | 37.7788789460419 | -122.490025663538 | (37.7788789460419, -122.490025663538) | 11 | 6 | 2 | 55 | 26 | |||
| 45180 | 36110 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1900 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43523 | 5992873.88147935 | 2102526.51410864 | 37.7527275651303 | -122.467550320151 | (37.7527275651303, -122.467550320151) | 1 | 8 | 4 | 29491 | 12 | ||
| 45341 | 173691 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
| 45764 | 37902 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1525 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51452 | 5995814.03079033 | 2094240.32165612 | 37.7301450363484 | -122.45678358123 | (37.7301450363484, -122.45678358123) | 9 | 7 | 4 | 28861 | 40 | ||
| 46511 | 88000 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952 | 2121180 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | 5 | 1 | 1 | 28858 | 32 | ||
| 46830 | 33858 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 23 Kronquist Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1997 12:00:00 AM | Permit Number 37856 | 6002262.86430125 | 2100188.3462204 | 37.7468451159163 | -122.434914374282 | (37.7468451159163, -122.434914374282) | 2 | 7 | 5 | 63 | 22 | |||
| 46844 | 44320 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2150 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2008 12:00:00 AM | 3x3 | Permit Number 50059 | 6001880.60996644 | 2113983.70033588 | 37.7847020596058 | -122.437223769823 | (37.7847020596058, -122.437223769823) | 13 | 6 | 11 | 29490 | 13 | ||
| 47062 | 68378 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 25 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32202 | 5998511.40529692 | 2105993.51041649 | 37.7625709476977 | -122.448304473804 | (37.7625709476977, -122.448304473804) | 15 | 5 | 11 | 29492 | 9 | ||
| 47170 | 45451 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 191 Corona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
| 47610 | 115296 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1715 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776029 | 5993685.8 | 2103804.5 | 37.7562834285867 | -122.464835383865 | (37.7562834285867, -122.464835383865) | 1 | 8 | 4 | 56 | 12 | |||
| 48696 | 37557 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4582 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1998 12:00:00 AM | Permit Number 39996 | 6000729.26896445 | 2104687.27430081 | 37.7591108913935 | -122.440540014618 | (37.7591108913935, -122.440540014618) | 2 | 4 | 5 | 28862 | 3 | ||
| 49168 | 47597 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 49563 | 66226 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1092 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1991 12:00:00 AM | Permit Number 29321 | 6007625.68875547 | 2109532.95268759 | 37.7728062813888 | -122.417032186184 | (37.7728062813888, -122.417032186184) | 8 | 2 | 9 | 28853 | 19 | ||
| 49878 | 60478 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1347 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1982 12:00:00 AM | Permit Number 20073 | 6002219.48599286 | 2113123.74035536 | 37.7823600854243 | -122.43598981706 | (37.7823600854243, -122.43598981706) | 15 | 5 | 11 | 29490 | 41 | ||
| 49951 | 58685 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1365 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/1988 12:00:00 AM | Permit Number 17913 | 6004542.14665913 | 2100947.18708781 | 37.7490578670673 | -122.427086868373 | (37.7490578670673, -122.427086868373) | 2 | 4 | 5 | 28862 | 22 | ||
| 49954 | 48839 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1239 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46837 | 5992309.70821316 | 2098410.34670203 | 37.7413930369511 | -122.469201754626 | (37.7413930369511, -122.469201754626) | 1 | 8 | 4 | 59 | 40 | ||
| 51150 | 47544 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 42 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 45411 | 6004848.5926145 | 2101664.35736028 | 37.7510443747722 | -122.42607822279 | (37.7510443747722, -122.42607822279) | 2 | 4 | 5 | 28862 | 22 | ||
| 51182 | 84957 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 8 Kronquist Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002223 | 2100219 | 37.7469270204759 | -122.43505441311 | (37.7469270204759, -122.43505441311) | 2 | 7 | 5 | 63 | 22 | |||||
| 51758 | 52262 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 146 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | 6x10 | Permit Number 48427 | 6005571.5262701 | 2100241.30714404 | 37.7471778384958 | -122.423477084213 | (37.7471778384958, -122.423477084213) | 2 | 7 | 5 | 28859 | 22 | |
| 52311 | 39618 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 172 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41018 | 5997530.61215046 | 2106784.14607791 | 37.7646857112231 | -122.451753702175 | (37.7646857112231, -122.451753702175) | 15 | 5 | 11 | 29492 | 9 | ||
| 52494 | 253139 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Brady St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | 8 | 2 | 9 | 28853 | 19 | ||||
| 52843 | 83372 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4570 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50810 | 6000783.84913806 | 2104682.12835594 | 37.7590998696933 | -122.440350881798 | (37.7590998696933, -122.440350881798) | 2 | 4 | 5 | 28862 | 3 | ||
| 52959 | 97989 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 876 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2011 12:00:00 AM | 3x3 | Permit Number 768167 | 6000897 | 2099683 | 37.7453799097395 | -122.439601171278 | (37.7453799097395, -122.439601171278) | 2 | 4 | 5 | 63 | 22 | ||
| 53471 | 46897 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1364 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44953 | 5992430.5821262 | 2106168.20504671 | 37.762701091794 | -122.469348364409 | (37.762701091794, -122.469348364409) | 1 | 8 | 11 | 56 | 12 | ||
| 53551 | 33870 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 199 Montcalm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1997 12:00:00 AM | Permit Number 37861 | 6010103.23973562 | 2099711.91394451 | 37.74597898005 | -122.407769380972 | (37.74597898005, -122.407769380972) | 2 | 7 | 7 | 28859 | 2 | |||
| 54203 | 68282 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 584 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1993 12:00:00 AM | Permit Number 32090 | 6002991.77839865 | 2095733.01235725 | 37.7346531579959 | -122.432075753497 | (37.7346531579959, -122.432075753497) | 2 | 7 | 5 | 63 | 7 | ||
| 54563 | 45585 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 139 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2011 12:00:00 AM | 3x3 | Permit Number 767525 | 5998075.71843503 | 2093918.7268896 | 37.7293916194009 | -122.448941513826 | (37.7293916194009, -122.448941513826) | 9 | 7 | 4 | 28861 | 40 | ||
| 54706 | 39795 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 56032 | 65858 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3449 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | Permit Number 28850 | 6000757.88455321 | 2120149.39668347 | 37.8015675622019 | -122.441550624863 | (37.8015675622019, -122.441550624863) | 13 | 9 | 1 | 57 | 17 | ||
| 56693 | 47594 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 56847 | 65355 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 66 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28190 | 6002485.22206397 | 2096558.7122321 | 37.7368916079784 | -122.433886087946 | (37.7368916079784, -122.433886087946) | 2 | 7 | 5 | 63 | 7 | ||
| 57072 | 112434 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 774101 | 5995479 | 2115773.8 | 37.7892512085361 | -122.459500756916 | (37.7892512085361, -122.459500756916) | 11 | 6 | 1 | 54 | 11 | |||
| 57304 | 255830 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Rhine St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 5994504.97936 | 2086701.61608 | 37.7093703016665 | -122.460762984428 | (37.7093703016665, -122.460762984428) | 9 | 8 | 6 | 28861 | 25 | ||||
| 57617 | 84016 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 826 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50436 | 6001873.67916989 | 2101682.75665543 | 37.7509263075182 | -122.436367073892 | (37.7509263075182, -122.436367073892) | 2 | 4 | 5 | 28862 | 22 | ||
| 57650 | 105054 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501X 27th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.64233 | 37.7790311285688 | -122.48680778308 | (37.7790311285688, -122.48680778308) | 11 | 6 | 2 | 55 | 26 | ||
| 57830 | 67676 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1970 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2007 12:00:00 AM | Permit Number 49654 | 6012165.49957843 | 2093485.91293956 | 37.7289989246829 | -122.400201126902 | (37.7289989246829, -122.400201126902) | 10 | 3 | 8 | 58 | 1 | ||
| 58062 | 86773 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4259 22nd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49745 | 6000836 | 2102862 | 37.7541052091019 | -122.44004000726 | (37.7541052091019, -122.44004000726) | 2 | 4 | 5 | 28862 | 22 | |||
| 58109 | 112429 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17 Arguello Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3x3 | 5995478.7 | 2115781.3 | 37.7892717842545 | -122.459502338276 | (37.7892717842545, -122.459502338276) | 11 | 6 | 1 | 54 | 11 | |||
| 58212 | 51454 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 501 Crescent Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2004 12:00:00 AM | Permit Number 47772 | 6007598.88566769 | 2095737.65957423 | 37.7349260410204 | -122.416147708857 | (37.7349260410204, -122.416147708857) | 2 | 7 | 7 | 28859 | 2 | |||
| 58281 | 101130 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1477 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3x3 | Permit Number 769344 | 6000788.3 | 2110635.6 | 37.7754468763902 | -122.44076254186 | (37.7754468763902, -122.44076254186) | 15 | 5 | 11 | 29492 | 10 | ||
| 58410 | 56637 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1925 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1986 12:00:00 AM | 6001550.67834342 | 2112841.6674483 | 37.7815475678078 | -122.438283377738 | (37.7815475678078, -122.438283377738) | 15 | 5 | 11 | 29490 | 41 | |||
| 59377 | 38522 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4354 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767257 | 6001582.06164415 | 2101191.52240977 | 37.7495609212637 | -122.437340342167 | (37.7495609212637, -122.437340342167) | 2 | 4 | 5 | 28862 | 22 | |
| 59693 | 113605 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
| 60263 | 41526 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1036 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42066 | 6018440.91849108 | 2095073.89345371 | 37.7337071281629 | -122.378616510061 | (37.7337071281629, -122.378616510061) | 10 | 3 | 8 | 58 | 1 | |||
| 60716 | 31049 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 15 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34804 | 6002647.46614225 | 2087728.93921016 | 37.712656237769 | -122.432694584455 | (37.712656237769, -122.432694584455) | 9 | 7 | 6 | 28861 | 5 | ||
| 61160 | 106800 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 443 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6011195 | 2112052 | 37.7799231406809 | -122.404862852803 | (37.7799231406809, -122.404862852803) | 14 | 2 | 9 | 28853 | 34 | |||||
| 61505 | 114803 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 273 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 772863 | 5990214.8 | 2113578.4 | 37.7829191632935 | -122.477553529871 | (37.7829191632935, -122.477553529871) | 11 | 6 | 2 | 55 | 26 | |||
| 61507 | 116527 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5732 GEARY BLVD | 1 | Sidewalk: Curb side : Yard | Tree | MTA 3 | DPW for City Agency | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 61854 | 50277 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 149 Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46980 | 6005201.31751977 | 2095053.36403777 | 37.7329120173043 | -122.424388296173 | (37.7329120173043, -122.424388296173) | 2 | 7 | 7 | 28861 | 2 | ||
| 61867 | 46362 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3621 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2002 12:00:00 AM | Permit Number 44600 | 6005453.12692671 | 2105447.54952341 | 37.7614662865278 | -122.424256718241 | (37.7614662865278, -122.424256718241) | 2 | 4 | 5 | 28859 | 19 | |||
| 61920 | 122530 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1798x Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003948 | 2097778 | 37.7403223952484 | -122.428915519189 | (37.7403223952484, -122.428915519189) | 2 | 7 | 5 | 63 | 7 | ||||
| 62337 | 92284 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 76 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52732 | 5992529 | 2098634 | 37.7420198013099 | -122.468459794719 | (37.7420198013099, -122.468459794719) | 1 | 8 | 4 | 29491 | 40 | ||
| 63772 | 253140 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Brady St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | 8 | 2 | 9 | 28853 | 19 | ||||
| 64462 | 47318 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 807A York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45246 | 6009931.15082206 | 2104513.94838888 | 37.7591546639811 | -122.40870315334 | (37.7591546639811, -122.40870315334) | 2 | 4 | 7 | 28859 | 19 | ||
| 64774 | 48615 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 201 Ulloa St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.455861320442 | (37.7434052350482, -122.455861320442) | 1 | 5 | 4 | 59 | 40 | ||
| 64785 | 39502 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 228 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/18/2006 12:00:00 AM | Permit Number 40958 | 6003674.69321501 | 2101013.31571102 | 37.7491903495803 | -122.430091245883 | (37.7491903495803, -122.430091245883) | 2 | 4 | 5 | 28862 | 22 | ||
| 65211 | 43399 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 69 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43142 | 6000382.29662695 | 2101283.84473675 | 37.7497461374598 | -122.441495780576 | (37.7497461374598, -122.441495780576) | 2 | 4 | 5 | 28862 | 22 | ||
| 65275 | 113613 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
| 65420 | 50089 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 Lenox Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46820 | 5993639.14545893 | 2099165.59898138 | 37.7435435002865 | -122.464659889376 | (37.7435435002865, -122.464659889376) | 1 | 8 | 4 | 59 | 40 | |||
| 66525 | 33579 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 169 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37687 | 6007131.89501253 | 2098033.82997093 | 37.7412045483591 | -122.417924980998 | (37.7412045483591, -122.417924980998) | 2 | 7 | 7 | 28859 | 2 | |||
| 66779 | 253662 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 715 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999814 | 2107879 | 37.7678224156838 | -122.443934762725 | (37.7678224156838, -122.443934762725) | 15 | 5 | 11 | 29492 | 9 | ||||
| 66873 | 50353 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.3812076 | 2111605.18300999 | 37.7788895958171 | -122.392829354684 | (37.7788895958171, -122.392829354684) | 6 | 2 | 9 | 28856 | 34 | |||
| 67648 | 49009 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2031REVISED Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2003 12:00:00 AM | Permit Number 47203 | 6004221.06826057 | 2115296.78098336 | 37.7884402156292 | -122.429220223223 | (37.7884402156292, -122.429220223223) | 13 | 9 | 11 | 29490 | 27 | |||
| 68002 | 47532 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 250 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45403 | 6004974.92780724 | 2098453.94495454 | 37.7422364593045 | -122.425412899819 | (37.7422364593045, -122.425412899819) | 2 | 7 | 5 | 63 | 22 | ||
| 68484 | 55704 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 29 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/1973 12:00:00 AM | 3x3 | Permit Number 11722 | 6003817.67189064 | 2108181.69074035 | 37.7688810970006 | -122.430108133411 | (37.7688810970006, -122.430108133411) | 7 | 9 | 5 | 28862 | 3 | ||
| 68725 | 43382 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 835 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43130 | 6001926.83234227 | 2101663.46629848 | 37.7508763608447 | -122.436181885123 | (37.7508763608447, -122.436181885123) | 2 | 4 | 5 | 28862 | 22 | ||
| 68744 | 46748 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | |||
| 68861 | 251590 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 340x Vicente St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5991910 | 2097743 | 37.7395375677929 | -122.470535201056 | (37.7395375677929, -122.470535201056) | 1 | 8 | 4 | 59 | 40 | ||||
| 69123 | 35684 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2010 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | Permit Number 38989 | 6004340.08099372 | 2115739.15382331 | 37.7896615965766 | -122.428840007681 | (37.7896615965766, -122.428840007681) | 13 | 9 | 1 | 28858 | 27 | |||
| 69932 | 56849 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1043 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14083 | 5998828.52357861 | 2106301.56148098 | 37.7634349035124 | -122.447229852767 | (37.7634349035124, -122.447229852767) | 15 | 5 | 11 | 29492 | 9 | |||
| 70415 | 46880 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2300 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2002 12:00:00 AM | Permit Number 44939 | 6006358.85800747 | 2118685.04678939 | 37.7978643358127 | -122.422064597009 | (37.7978643358127, -122.422064597009) | 13 | 9 | 10 | 28858 | 32 | ||
| 70467 | 48769 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 21 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | Permit Number 46027 | 6004996.28078575 | 2101620.42759661 | 37.7509320998658 | -122.425564375644 | (37.7509320998658, -122.425564375644) | 2 | 4 | 5 | 28862 | 22 | |||
| 70867 | 57825 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 703-705 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1977 12:00:00 AM | Permit Number 16766 | 6001849.12678995 | 2102031.55551925 | 37.7518826308781 | -122.436476940209 | (37.7518826308781, -122.436476940209) | 2 | 4 | 5 | 28862 | 22 | |||
| 71654 | 88179 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 435 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51188 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
| 71863 | 46747 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | ||
| 71895 | 113602 | Section 143 10 | Olea europaea :: Olive Tree 9 | 550 FLORIDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233 | 2105681 | 37.7623199946126 | -122.411200142124 | (37.7623199946126, -122.411200142124) | 8 | 4 | 7 | 28859 | 19 | ||
| 72013 | 43403 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 235 Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43146 | 6000671.31740654 | 2103070.12377068 | 37.7546672900273 | -122.440624445322 | (37.7546672900273, -122.440624445322) | 2 | 4 | 5 | 28862 | 22 | ||
| 72166 | 46340 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3742Oaks St. 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44589 | 6005571.08187894 | 2100828.92807079 | 37.7487912858438 | -122.42352039086 | (37.7487912858438, -122.42352039086) | 2 | 4 | 5 | 28859 | 19 | ||
| 72869 | 38708 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1900 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | Permit Number 40614 | 6000044.14141087 | 2111300.00488868 | 37.7772287555823 | -122.443384488436 | (37.7772287555823, -122.443384488436) | 15 | 5 | 11 | 29490 | 16 | ||
| 72969 | 89347 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 767 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2008 12:00:00 AM | 3x3 | Permit Number 51931 | 6001571 | 2099979 | 37.7462309937898 | -122.437291783871 | (37.7462309937898, -122.437291783871) | 2 | 7 | 5 | 63 | 22 | ||
| 73548 | 96294 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 417 Dewey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/25/2011 12:00:00 AM | 3x3 | Permit Number 57003 | 5995136 | 2100316.9 | 37.7467908665237 | -122.459567540316 | (37.7467908665237, -122.459567540316) | 1 | 8 | 4 | 59 | 40 | ||
| 73842 | 43182 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 350 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | Permit Number 42986 | 6008194.87778355 | 2092383.3879698 | 37.7257494266132 | -122.413849953332 | (37.7257494266132, -122.413849953332) | 9 | 3 | 7 | 309 | 28 | ||
| 74278 | 114955 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 50 Circular Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2015 12:00:00 AM | Permit Number 776076 | 6001248.1 | 2094471.5 | 37.7310903246371 | -122.438013895012 | (37.7310903246371, -122.438013895012) | 9 | 7 | 4 | 63 | 40 | |||
| 74473 | 48919 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2977 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51550 | 6009053.14086522 | 2102721.98826857 | 37.7541851311189 | -122.411613133185 | (37.7541851311189, -122.411613133185) | 2 | 4 | 7 | 28859 | 19 | ||
| 74878 | 83345 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4122 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50808 | 6002892.76964494 | 2104186.76558185 | 37.7578595731657 | -122.433021845922 | (37.7578595731657, -122.433021845922) | 2 | 4 | 5 | 28862 | 3 | ||
| 75048 | 251405 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 540 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:08:00 PM | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | 3 | 1 | 10 | 308 | 23 | |||
| 75802 | 254197 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 539 Stevenson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6009498.57489 | 2112438.36356 | 37.7808890340394 | -122.410758860237 | (37.7808890340394, -122.410758860237) | 14 | 2 | 9 | 28853 | 34 | ||||
| 75986 | 137839 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1800 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6005239.1389 | 2115489.1761 | 37.7890260654428 | -122.425711556168 | (37.7890260654428, -122.425711556168) | 13 | 9 | 1 | 28858 | 27 | ||||
| 76444 | 46669 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1410 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44798 | 5991496.386577 | 2105807.77483853 | 37.7616574165081 | -122.47255310345 | (37.7616574165081, -122.47255310345) | 1 | 8 | 4 | 56 | 12 | ||
| 77445 | 85384 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1970 Carroll Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2007 12:00:00 AM | Permit Number 49654 | 6012142.9 | 2093507.8 | 37.7290577618583 | -122.40028079247 | (37.7290577618583, -122.40028079247) | 10 | 3 | 8 | 58 | 1 | |||
| 77519 | 45449 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 191 Corona St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
| 78122 | 41269 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 44 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1999 12:00:00 AM | Permit Number 47888 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | ||
| 78232 | 92489 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2949 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52860 | 5986907 | 2098225 | 37.7405704530713 | -122.487868578446 | (37.7405704530713, -122.487868578446) | 1 | 8 | 3 | 29491 | 35 | |
| 78500 | 110933 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013092.21392497 | 2107061.02739926 | 37.7663249213263 | -122.397949287209 | (37.7663249213263, -122.397949287209) | 14 | 3 | 8 | 28856 | 20 | |||||
| 79746 | 51455 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 501 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2004 12:00:00 AM | Permit Number 47772 | 6007598.88566769 | 2095737.65957423 | 37.7349260410204 | -122.416147708857 | (37.7349260410204, -122.416147708857) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );