trees
2,694 rows where qSpecies_id = 84 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17648 | 261398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 711 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010187.59569 | 2118491.78545 | 37.7975488860672 | -122.408802387211 | (37.7975488860672, -122.408802387211) | 3 | 1 | 10 | 308 | 4 | |||||
| 17765 | 47693 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 469 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45492 | 6003825.81919033 | 2095934.94010265 | 37.7352548563783 | -122.429206586085 | (37.7352548563783, -122.429206586085) | 2 | 7 | 5 | 63 | 7 | ||
| 18166 | 88091 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1619 39th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51095 | 5984024.3 | 2104125.3 | 37.756602478656 | -122.498271356488 | (37.756602478656, -122.498271356488) | 1 | 8 | 3 | 56 | 35 | |||
| 18214 | 46802 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 90 Ravenwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44890 | 5994259.7635246 | 2095973.46470501 | 37.7348144532504 | -122.462282494227 | (37.7348144532504, -122.462282494227) | 9 | 8 | 4 | 59 | 40 | ||
| 18360 | 32820 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4231 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37179 | 6001652.66778496 | 2102313.08223681 | 37.7526444703409 | -122.437176476876 | (37.7526444703409, -122.437176476876) | 2 | 4 | 5 | 28862 | 22 | ||
| 18369 | 261412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 18397 | 41870 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 25 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42249 | 6003816.33085796 | 2108205.89422295 | 37.76894747793 | -122.430114498812 | (37.76894747793, -122.430114498812) | 7 | 9 | 5 | 28862 | 3 | ||
| 19203 | 65549 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 336 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28448 | 5995107.08134396 | 2097533.05659271 | 37.7391454621224 | -122.45946595669 | (37.7391454621224, -122.45946595669) | 9 | 7 | 4 | 59 | 40 | ||
| 19264 | 259569 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
| 19387 | 31852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
| 19506 | 42439 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 550 Judson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.453230305718 | (37.7285785035344, -122.453230305718) | 9 | 7 | 4 | 28861 | 40 | ||
| 19672 | 39059 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2112 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40773 | 6009544.26649418 | 2104935.53582208 | 37.7602905710121 | -122.410070953081 | (37.7602905710121, -122.410070953081) | 2 | 4 | 7 | 28859 | 19 | ||
| 19730 | 45264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 679 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44110 | 6007437.04043274 | 2095812.31493778 | 37.7351219268063 | -122.416712553249 | (37.7351219268063, -122.416712553249) | 2 | 7 | 7 | 28859 | 2 | ||
| 20130 | 68264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 381 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32070 | 6009731.82582651 | 2092664.31257859 | 37.72660698205 | -122.408556624594 | (37.72660698205, -122.408556624594) | 10 | 3 | 7 | 309 | 28 | ||
| 20153 | 36371 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 149 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39320 | 5995639.30235658 | 2093700.91704077 | 37.7286539269724 | -122.45734862822 | (37.7286539269724, -122.45734862822) | 9 | 7 | 4 | 28861 | 40 | ||
| 20169 | 36359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 131 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39315 | 5995616.87742593 | 2093562.88394601 | 37.728273633306 | -122.457416169824 | (37.728273633306, -122.457416169824) | 9 | 7 | 4 | 28861 | 40 | ||
| 20299 | 43280 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 731 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43050 | 6009363.88058907 | 2092426.70066476 | 37.7259339362736 | -122.409811838204 | (37.7259339362736, -122.409811838204) | 9 | 3 | 7 | 309 | 28 | ||
| 20713 | 107753 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | ||||
| 21001 | 37006 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1065 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39620 | 6009210.89939839 | 2102965.35956072 | 37.7548622220933 | -122.411084752447 | (37.7548622220933, -122.411084752447) | 2 | 4 | 7 | 28859 | 19 | ||
| 21018 | 110553 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
| 21032 | 121651 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 306 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993098 | 2103247 | 37.7547187703987 | -122.466827655897 | (37.7547187703987, -122.466827655897) | 1 | 8 | 4 | 56 | 12 | ||||
| 21133 | 66926 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 125 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30248 | 6007619.27051621 | 2098065.9648769 | 37.7413202009481 | -122.416242081144 | (37.7413202009481, -122.416242081144) | 2 | 7 | 7 | 28859 | 2 | ||
| 21420 | 47310 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1107 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45241 | 6010288.16181634 | 2102764.77938432 | 37.7543718262723 | -122.407345121668 | (37.7543718262723, -122.407345121668) | 10 | 4 | 7 | 28859 | 19 | ||
| 21463 | 43354 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4226 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43105 | 6002331.77416149 | 2104155.95516802 | 37.757743138206 | -122.434959796908 | (37.757743138206, -122.434959796908) | 2 | 4 | 5 | 28862 | 3 | ||
| 21733 | 37264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 910 Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | 2 | 4 | 5 | 28862 | 22 | ||
| 21824 | 67193 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 115 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30643 | 5997981.64121917 | 2106794.49458323 | 37.764739946577 | -122.450194465027 | (37.764739946577, -122.450194465027) | 15 | 5 | 11 | 29492 | 9 | ||
| 22144 | 39140 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1084 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40818 | 6007412.89120014 | 2100999.62033196 | 37.749363754725 | -122.417163498301 | (37.749363754725, -122.417163498301) | 2 | 4 | 7 | 28859 | 19 | ||
| 22570 | 50789 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 6900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | 11 | 6 | 2 | 55 | 26 | ||
| 22689 | 65805 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2255 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28773 | 5991004.89132243 | 2100060.8750428 | 37.7458494782853 | -122.473833696019 | (37.7458494782853, -122.473833696019) | 1 | 8 | 4 | 29491 | 40 | ||
| 22903 | 40229 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
| 22941 | 63176 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1438 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23713 | 5992757.94867175 | 2105669.22551201 | 37.7613499376947 | -122.468179830058 | (37.7613499376947, -122.468179830058) | 1 | 8 | 4 | 56 | 12 | ||
| 22982 | 34096 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.6434081 | 2093328.34737639 | 37.7276180343437 | -122.458098329779 | (37.7276180343437, -122.458098329779) | 9 | 7 | 4 | 28861 | 40 | |||
| 22987 | 88225 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2084 Hayes St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51221 | 5997896.9 | 2109991 | 37.7735118836843 | -122.450718045928 | (37.7735118836843, -122.450718045928) | 15 | 5 | 11 | 29492 | 16 | |||
| 23229 | 101446 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
| 23384 | 31717 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 Twin Peaks Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35217 | 5999015.35080387 | 2105425.59790745 | 37.7610403997541 | -122.446520655595 | (37.7610403997541, -122.446520655595) | 15 | 5 | 11 | 29492 | 12 | ||
| 23564 | 64920 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2320 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1989 12:00:00 AM | Permit Number 25948 | 5991486.61980938 | 2099663.95831255 | 37.7447875370964 | -122.472139036095 | (37.7447875370964, -122.472139036095) | 1 | 8 | 4 | 29491 | 40 | ||
| 23717 | 34392 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 224 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38139 | 6004139.10762167 | 2096768.34817433 | 37.7375609365762 | -122.428182808375 | (37.7375609365762, -122.428182808375) | 2 | 7 | 5 | 63 | 7 | |
| 23723 | 30734 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 281 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34629 | 6005251.19976575 | 2109714.98569866 | 37.7731722414546 | -122.425258776803 | (37.7731722414546, -122.425258776803) | 7 | 9 | 11 | 28852 | 10 | ||
| 23943 | 91342 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 829 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100 | 2112601 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | 6 | 2 | 9 | 28856 | 34 | ||
| 24056 | 62182 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 15 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1985 12:00:00 AM | Permit Number 22299 | 6000249.38294622 | 2091710.97820224 | 37.7234537213114 | -122.44126862873 | (37.7234537213114, -122.44126862873) | 9 | 7 | 6 | 28861 | 25 | ||
| 24390 | 66242 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 283 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29340 | 5997754.61642905 | 2090213.33999682 | 37.7191991265322 | -122.449784665644 | (37.7191991265322, -122.449784665644) | 9 | 8 | 6 | 28861 | 24 | ||
| 24462 | 38952 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | 9 | 8 | 4 | 59 | 40 | ||
| 24534 | 39765 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 668 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41131 | 6003653.48498832 | 2104383.93868728 | 37.7584440838148 | -122.430405042836 | (37.7584440838148, -122.430405042836) | 2 | 4 | 5 | 28862 | 3 | ||
| 24548 | 32852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 764 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41115 | 6001471.9166257 | 2102062.60736984 | 37.7519464500754 | -122.437783607007 | (37.7519464500754, -122.437783607007) | 2 | 4 | 5 | 28862 | 22 | ||
| 24598 | 50059 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 246 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46789 | 6002684.4080652 | 2104459.13376981 | 37.7585956098381 | -122.433761913311 | (37.7585956098381, -122.433761913311) | 2 | 4 | 5 | 28862 | 3 | ||
| 24657 | 41587 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 48 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/2000 12:00:00 AM | Permit Number 42095 | 6000324.11613416 | 2101399.22119137 | 37.7500596186155 | -122.441705249653 | (37.7500596186155, -122.441705249653) | 2 | 4 | 5 | 28862 | 22 | ||
| 24908 | 50538 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 199 Tiffany Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006096 | 2099195 | 37.7443345051857 | -122.421589192303 | (37.7443345051857, -122.421589192303) | 2 | 7 | 7 | 28859 | 2 | |||
| 25255 | 64036 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 444 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24793 | 6008741.54974036 | 2096719.77289509 | 37.7376868940515 | -122.412266495463 | (37.7376868940515, -122.412266495463) | 10 | 7 | 7 | 28859 | 2 | ||
| 25731 | 39751 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 168 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41119 | 6003201.65884895 | 2105082.75168604 | 37.7603372525468 | -122.432017558659 | (37.7603372525468, -122.432017558659) | 2 | 4 | 5 | 28862 | 3 | ||
| 25901 | 37268 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 910 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | 2 | 4 | 5 | 28862 | 22 | ||
| 25943 | 32174 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 119 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.494335637657 | (37.7296472241819, -122.494335637657) | 1 | 8 | 4 | 64 | 35 | ||
| 26082 | 50547 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
| 26346 | 35087 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1594 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38628 | 5992484.06042474 | 2104613.58351728 | 37.7584355999938 | -122.469050257237 | (37.7584355999938, -122.469050257237) | 1 | 8 | 4 | 56 | 12 | ||
| 26877 | 39166 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 301x Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40829 | 6003629 | 2104450 | 37.7586240854401 | -122.430494436391 | (37.7586240854401, -122.430494436391) | 2 | 4 | 5 | 28862 | 3 | ||
| 26887 | 43353 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4184 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | 2 | 4 | 5 | 28862 | 3 | ||
| 27494 | 109159 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
| 27625 | 42210 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 937 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42479 | 6011834.2594701 | 2111457.32291808 | 37.7783260063796 | -122.402609526252 | (37.7783260063796, -122.402609526252) | 14 | 2 | 9 | 28856 | 34 | ||
| 27655 | 64929 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2356 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25957 | 5991487.94157663 | 2099507.48973939 | 37.744357991135 | -122.472123062807 | (37.744357991135, -122.472123062807) | 1 | 8 | 4 | 29491 | 40 | ||
| 27709 | 35069 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1616 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38623 | 5992799.70916091 | 2104452.91029535 | 37.7580126662258 | -122.467946926218 | (37.7580126662258, -122.467946926218) | 1 | 8 | 4 | 56 | 12 | ||
| 27925 | 253362 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1737 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | 13 | 9 | 11 | 29490 | 13 | ||||
| 28066 | 60426 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 419 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31497 | 6003853.1521524 | 2098925.15717718 | 37.7434668562001 | -122.42932524739 | (37.7434668562001, -122.42932524739) | 2 | 7 | 5 | 63 | 22 | ||
| 28149 | 66486 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1249 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/11/1995 12:00:00 AM | Permit Number 29644 | 6001993.92137577 | 2100462.92046027 | 37.7475837581962 | -122.435863994873 | (37.7475837581962, -122.435863994873) | 2 | 4 | 5 | 63 | 22 | ||
| 28329 | 65179 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 358 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27162 | 6001459.94084351 | 2103675.64155416 | 37.7563747726958 | -122.437940547391 | (37.7563747726958, -122.437940547391) | 2 | 4 | 5 | 28862 | 3 | ||
| 28830 | 50549 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
| 28839 | 119865 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
| 28939 | 69108 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1608 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33123 | 5992177.27339597 | 2104495.32958128 | 37.7580931749511 | -122.470102642882 | (37.7580931749511, -122.470102642882) | 1 | 8 | 4 | 56 | 12 | ||
| 28979 | 110554 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
| 29250 | 84785 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49308 | 5999615.8 | 2105217.4 | 37.7605030183148 | -122.444429006349 | (37.7605030183148, -122.444429006349) | 15 | 5 | 5 | 28862 | 3 | |||
| 29311 | 64131 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 619 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 24902 | 6002577.32467051 | 2098854.14366792 | 37.743199557291 | -122.433731658795 | (37.743199557291, -122.433731658795) | 2 | 7 | 5 | 63 | 7 | ||
| 29344 | 39161 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 301x Cumberland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40829 | 6003629 | 2104450 | 37.7586240854401 | -122.430494436391 | (37.7586240854401, -122.430494436391) | 2 | 4 | 5 | 28862 | 3 | ||
| 29396 | 113411 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1642 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5991208.59288317 | 2104157.90962907 | 37.757110661532 | -122.473428111823 | (37.757110661532, -122.473428111823) | 1 | 8 | 4 | 56 | 12 | ||||
| 29442 | 42763 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
| 29485 | 33704 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 196 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1996 12:00:00 AM | Permit Number 37772 | 6003356.08500561 | 2108810.32684763 | 37.7705810245056 | -122.431749619478 | (37.7705810245056, -122.431749619478) | 15 | 9 | 11 | 29492 | 10 | ||
| 29496 | 36373 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 150 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39321 | 5995693.36220348 | 2093704.91985042 | 37.7286680225798 | -122.457162030727 | (37.7286680225798, -122.457162030727) | 9 | 7 | 4 | 28861 | 40 | ||
| 29518 | 88278 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Aptos Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062 | 2093861.6 | 37.7289467548913 | -122.466270114229 | (37.7289467548913, -122.466270114229) | 9 | 8 | 4 | 59 | 40 | |||
| 29717 | 107752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x3 | Permit Number 772924 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||
| 29957 | 68643 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1877 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32548 | 5990606.81052039 | 2102625.79643083 | 37.7528690170523 | -122.475397425135 | (37.7528690170523, -122.475397425135) | 1 | 8 | 4 | 56 | 12 | ||
| 30287 | 33042 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 407 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37319 | 6005521.73281863 | 2101332.19930241 | 37.750170367356 | -122.423726818664 | (37.750170367356, -122.423726818664) | 2 | 4 | 5 | 28859 | 19 | ||
| 30288 | 42394 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 531 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42554 | 5997433.46765796 | 2095082.84468997 | 37.7325512585551 | -122.451245745641 | (37.7325512585551, -122.451245745641) | 9 | 7 | 4 | 59 | 40 | ||
| 30534 | 35157 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 52 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44857 | 6002886.83329691 | 2108721.01150397 | 37.7703091758364 | -122.433366381141 | (37.7703091758364, -122.433366381141) | 15 | 5 | 5 | 29492 | 9 | ||
| 30699 | 55711 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 272 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1986 12:00:00 AM | Permit Number 23249 | 6008222.83311062 | 2097315.58995443 | 37.7392937564467 | -122.414102093282 | (37.7392937564467, -122.414102093282) | 2 | 7 | 7 | 28859 | 2 | ||
| 30723 | 120885 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6009830 | 2087548 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | 9 | 7 | 8 | 309 | 39 | ||||
| 30734 | 66175 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 21 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29248 | 6009393.43110869 | 2097334.70341331 | 37.7394119178851 | -122.410056019409 | (37.7394119178851, -122.410056019409) | 10 | 7 | 7 | 28859 | 2 | ||
| 30961 | 84824 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 845 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | Permit No. 49256 | 5996978.8 | 2090483.4 | 37.7198962296133 | -122.452485832408 | (37.7198962296133, -122.452485832408) | 9 | 8 | 6 | 28861 | 24 | |||
| 31012 | 42789 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 426 -28 -30 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42755 | 6004546 | 2110000 | 37.7739149561089 | -122.427718466962 | (37.7739149561089, -122.427718466962) | 7 | 9 | 11 | 28852 | 10 | ||
| 31218 | 39136 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 826 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40815 | 6007330.44078591 | 2102489.82130207 | 37.7534508693901 | -122.417554217278 | (37.7534508693901, -122.417554217278) | 2 | 4 | 7 | 28859 | 19 | ||
| 31260 | 52535 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3148GREENWICH Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2006 12:00:00 AM | Permit Number 48634 | 6001945.28510554 | 2118977.8518821 | 37.7984183853373 | -122.437357750068 | (37.7984183853373, -122.437357750068) | 13 | 9 | 1 | 57 | 17 | |||
| 31277 | 68324 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 750 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1995 12:00:00 AM | Permit Number 32139 | 6006836.2771862 | 2113285.80603773 | 37.7830662729123 | -122.420029228797 | (37.7830662729123, -122.420029228797) | 7 | 9 | 9 | 28858 | 36 | ||
| 31402 | 36014 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 97 Winfield St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1998 12:00:00 AM | Permit Number 39160 | 6007176.5102611 | 2098875.10334415 | 37.7435170081928 | -122.41783033575 | (37.7435170081928, -122.41783033575) | 2 | 7 | 7 | 28859 | 2 | |||
| 31403 | 82857 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 720 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50437 | 6001737.56005251 | 2102077.41658614 | 37.7520022141239 | -122.43686603571 | (37.7520022141239, -122.43686603571) | 2 | 4 | 5 | 28862 | 22 | ||
| 31843 | 119859 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
| 31959 | 43357 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3886 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43108 | 6002562.4926472 | 2103000.84973537 | 37.7545845925119 | -122.434079307055 | (37.7545845925119, -122.434079307055) | 2 | 4 | 5 | 28862 | 22 | ||
| 31979 | 31718 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 Twin Peaks Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35217 | 5999015.35080387 | 2105425.59790745 | 37.7610403997541 | -122.446520655595 | (37.7610403997541, -122.446520655595) | 15 | 5 | 11 | 29492 | 12 | ||
| 32036 | 36316 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 155 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39293 | 5996114.57806126 | 2093980.3628315 | 37.7294485047064 | -122.455725773063 | (37.7294485047064, -122.455725773063) | 9 | 7 | 4 | 28861 | 40 | ||
| 32041 | 45666 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 248 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | Permit Number 44362 | 6004322.96019847 | 2098710.22232116 | 37.7429032809545 | -122.427685458336 | (37.7429032809545, -122.427685458336) | 2 | 7 | 5 | 63 | 22 | ||
| 32133 | 38962 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4040 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/1998 12:00:00 AM | Permit Number 40756 | 6003617.62945341 | 2100718.82894394 | 37.7483785256483 | -122.430267566107 | (37.7483785256483, -122.430267566107) | 2 | 4 | 5 | 28862 | 22 | |||
| 32500 | 36525 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 614 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39399 | 6007955.56976026 | 2096040.57952045 | 37.7357778421218 | -122.414935955833 | (37.7357778421218, -122.414935955833) | 2 | 7 | 7 | 28859 | 2 | ||
| 32686 | 114513 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 418 BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 6x7 | 5998550 | 2106753 | 37.7646585215155 | -122.448225680862 | (37.7646585215155, -122.448225680862) | 15 | 5 | 11 | 29492 | 9 | |||
| 33066 | 42783 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 202 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42751 | 6005176.07009417 | 2109735.98338901 | 37.7732256513259 | -122.425520155041 | (37.7732256513259, -122.425520155041) | 7 | 9 | 11 | 28852 | 10 | ||
| 33286 | 43735 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 14 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43372 | 5996531.68905486 | 2089965.7239711 | 37.7184491858628 | -122.453993963558 | (37.7184491858628, -122.453993963558) | 9 | 8 | 6 | 28861 | 24 |
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) );