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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18482 | 18482 | 50084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 163 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46816 | 5992385.51984068 | 2098065.73695017 | 37.7404512063716 | -122.468914554715 | (37.7404512063716, -122.468914554715) | ||
| 18542 | 18542 | 31283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2574 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778680 | 5991125.83447 | 2097900.24985 | 37.7399239615173 | -122.47325794369199 | (37.7399239615173, -122.473257943692) | |
| 18614 | 18614 | 63155 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23691 | 5992764.22387578 | 2105486.82086268 | 37.7608494648287 | -122.468144857754 | (37.7608494648287, -122.468144857754) | ||
| 18838 | 18838 | 43257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.728118638728105 | -122.407120168437 | (37.7281186387281, -122.407120168437) | ||
| 18841 | 18841 | 64930 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2306 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1989 12:00:00 AM | Permit Number 25958 | 5991495.59202308 | 2099725.9184431 | 37.7449581828883 | -122.47211252761002 | (37.7449581828883, -122.47211252761) | ||
| 18883 | 18883 | 65715 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 735 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | Permit Number 28647 | 6009189.05467178 | 2115445.35577198 | 37.789128153830106 | -122.41204221421499 | (37.7891281538301, -122.412042214215) | ||
| 19061 | 19061 | 50930 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2287 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47426 | 5991460.4982554 | 2099833.27531374 | 37.745250926286396 | -122.47224169859699 | (37.7452509262864, -122.472241698597) | ||
| 19155 | 19155 | 52324 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4119NOE ST. 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48477 | 6002926.75349176 | 2104136.57118168 | 37.7577236789461 | -122.432900729778 | (37.7577236789461, -122.432900729778) | ||
| 19226 | 19226 | 30599 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | 5x7 | Permit Number 34566 | 6004311.30995 | 2108965.65965 | 37.771061631219 | -122.428456559416 | (37.771061631219, -122.428456559416) |
| 19412 | 19412 | 68594 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1776 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32496 | 5991255.24615708 | 2103348.30667764 | 37.754890406441895 | -122.47320772508499 | (37.7548904064419, -122.473207725085) | ||
| 19752 | 19752 | 38951 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | ||
| 19771 | 19771 | 31446 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 239 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 7 | Permit Number 35021 | 6002088.5838 | 2104465.22029 | 37.758578494425294 | -122.435822975577 | (37.7585784944253, -122.435822975577) | |
| 19789 | 19789 | 66507 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 64 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | Permit Number 29671 | 6009973.94739461 | 2110908.31483893 | 37.7767145222423 | -122.409006317188 | (37.7767145222423, -122.409006317188) | ||
| 19803 | 19803 | 40552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 380 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41594 | 5992231.83033974 | 2094391.07598337 | 37.7303526300924 | -122.46917856626301 | (37.7303526300924, -122.469178566263) | ||
| 19839 | 19839 | 46807 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 San Felipe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.46294824520201 | (37.7322740285646, -122.462948245202) | ||
| 20288 | 20288 | 34981 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 336 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41309 | 6003431.10233151 | 2104509.78972726 | 37.758777041212895 | -122.43118312363 | (37.7587770412129, -122.43118312363) | ||
| 20378 | 20378 | 31923 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
| 20385 | 20385 | 39056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | ||
| 20479 | 20479 | 73501 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.74920537061129 | -122.436016109621 | (37.7492053706113, -122.436016109621) | |
| 20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
| 20490 | 20490 | 68099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31844 | 6006420.25408514 | 2099944.49896622 | 37.7464107382986 | -122.42052117977501 | (37.7464107382986, -122.420521179775) | ||
| 20492 | 20492 | 65549 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 336 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28448 | 5995107.08134396 | 2097533.05659271 | 37.739145462122394 | -122.45946595668998 | (37.7391454621224, -122.45946595669) | ||
| 20623 | 20623 | 39050 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009499.38 | 2105599.429 | 37.762110954787005 | -122.410273070025 | (37.762110954787, -122.410273070025) | ||
| 20662 | 20662 | 84576 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3966 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003390.40048346 | 2101879.79659646 | 37.7515533971776 | -122.43113617160401 | (37.7515533971776, -122.431136171604) |
| 20981 | 20981 | 40426 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 572 Wildwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41522 | 5994442.84312797 | 2093351.87569512 | 37.7276267513816 | -122.46145953493901 | (37.7276267513816, -122.461459534939) | ||
| 21241 | 21241 | 41670 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.44465870166599 | (37.7577735947767, -122.444658701666) | ||
| 21832 | 21832 | 52298 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 48421st ST Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48459 | 6001164.37327683 | 2103435.80726183 | 37.7556994334338 | -122.43894553395599 | (37.7556994334338, -122.438945533956) | ||
| 22957 | 22957 | 108702 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2382 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772586 | 6001605.971969999 | 2118381.98302 | 37.79676299019629 | -122.438489159966 | (37.7967629901963, -122.438489159966) |
| 23415 | 23415 | 65130 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 38 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1989 12:00:00 AM | 8 | Permit Number 27100 | 5989605.43837 | 2114945.94466 | 37.7866386771259 | -122.479761743811 | (37.7866386771259, -122.479761743811) | |
| 23458 | 23458 | 40046 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1732 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767656 | 6014557.3351 | 2095185.1065900002 | 37.7337976439298 | -122.392051083889 | (37.7337976439298, -122.392051083889) |
| 23540 | 23540 | 50495 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 678 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 3 | Permit Number 47131 | 6001459.37999 | 2089596.3595900002 | 37.7177163070325 | -122.436934583487 | (37.7177163070325, -122.436934583487) | |
| 23606 | 23606 | 31666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4066 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 6 | Permit Number 35467 | 6002585.751619999 | 2104753.963 | 37.7593995412727 | -122.434124187708 | (37.7593995412727, -122.434124187708) | |
| 23672 | 23672 | 45504 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3071 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44274 | 5989334.51674 | 2094909.25358 | 37.731607570812294 | -122.47923275968 | (37.7316075708123, -122.47923275968) | |
| 23692 | 23692 | 71227 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.48543517398599 | (37.7450642803204, -122.485435173986) | ||
| 23854 | 23854 | 30732 | Permitted Site 1 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 218 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 8 | Permit Number 34627 | 6005441.5895 | 2109781.1239 | 37.773364595093604 | -122.424604898731 | (37.7733645950936, -122.424604898731) | |
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 23899 | 23899 | 72385 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 686 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 8 | 5995057.69186 | 2110887.03516 | 37.775809229939206 | -122.460604158861 | (37.7758092299392, -122.460604158861) | ||
| 24290 | 24290 | 31978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 241 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 10 | Permit Number 35377 | 5995211.0055599995 | 2113933.52562 | 37.784182899243 | -122.460294590416 | (37.784182899243, -122.460294590416) | |
| 24421 | 24421 | 47030 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.772228199123504 | -122.424230399247 | (37.7722281991235, -122.424230399247) | ||
| 24425 | 24425 | 68640 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1843 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32545 | 5990599.2738678 | 2102847.22998444 | 37.753476578420404 | -122.475439654249 | (37.7534765784204, -122.475439654249) | ||
| 24502 | 24502 | 66601 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1111 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 9 | Permit Number 29794 | 6008473.92013 | 2115892.33746 | 37.7903153068679 | -122.414548140207 | (37.7903153068679, -122.414548140207) | |
| 24585 | 24585 | 49743 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 114 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 8 | Permit Number 46542 | 6010621.23603 | 2087831.01483 | 37.7133855110935 | -122.405141759495 | (37.7133855110935, -122.405141759495) | |
| 24668 | 24668 | 62307 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 75 Loraine Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 12 | Permit Number 22445. Tree 1 on Anza | 5996139.53723 | 2112297.17389 | 37.7797432798479 | -122.456963823301 | (37.7797432798479, -122.456963823301) | |
| 24704 | 24704 | 50215 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 894@ CABRILLO 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 6 | Permit Number 46923 | 5986993.182990001 | 2109884.80336 | 37.7725901199359 | -122.488427298171 | (37.7725901199359, -122.488427298171) | |
| 24726 | 24726 | 72266 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325116999 | (37.7230023412585, -122.43384325117) | ||
| 24747 | 24747 | 32784 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 722 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37151 | 5999634.6045 | 2111035.6277 | 37.7764794805822 | -122.444782194549 | (37.7764794805822, -122.444782194549) | |
| 24778 | 24778 | 45056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2327 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43941 | 5988236.6427 | 2099455.0874 | 37.7440254200914 | -122.483361393915 | (37.7440254200914, -122.483361393915) | |
| 24803 | 24803 | 43758 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 187 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43394 | 5990518.06964 | 2114139.81459 | 37.78447824498161 | -122.47654538071698 | (37.7844782449816, -122.476545380717) | |
| 24819 | 24819 | 65946 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 556 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 2 | Permit Number 28967 | 6007598.7781 | 2113267.2525 | 37.783058259910895 | -122.417389964837 | (37.7830582599109, -122.417389964837) | |
| 24823 | 24823 | 47425 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45336 | 5984176.15569 | 2110679.3098400002 | 37.7746068364777 | -122.49823022658701 | (37.7746068364777, -122.498230226587) | |
| 24978 | 24978 | 70667 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 8 | 6009828.97228 | 2111081.0117200003 | 37.777180585152394 | -122.40952002252399 | (37.7771805851524, -122.409520022524) | ||
| 25010 | 25010 | 78257 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 538 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003439.3186800005 | 2090205.80452 | 37.7195020449593 | -122.430134279779 | (37.7195020449593, -122.430134279779) | ||
| 25042 | 25042 | 70403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 215 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 18 | 6006511.50188 | 2092924.3025099998 | 37.7271399781258 | -122.419707630826 | (37.7271399781258, -122.419707630826) | ||
| 25098 | 25098 | 95928 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 758 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767625 | 5987895.384330001 | 2110807.039 | 37.775174921567796 | -122.485374215588 | (37.7751749215678, -122.485374215588) |
| 25348 | 25348 | 50499 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 608 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 5 | Permit Number 47136 | 6002721.49496 | 2090080.38174 | 37.719116979545795 | -122.432606577246 | (37.7191169795458, -122.432606577246) | |
| 25373 | 25373 | 60884 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 811 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2013 12:00:00 AM | 4 | Permit Number 769979 | 6009011.35018 | 2119721.10568 | 37.8008583416072 | -122.412959487805 | (37.8008583416072, -122.412959487805) | |
| 25402 | 25402 | 52514 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 25423 | 25423 | 30768 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.727837721051294 | -122.391915390574 | (37.7278377210513, -122.391915390574) | |
| 25526 | 25526 | 31523 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1320 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 9 | Permit Number 35078 | 6011116.30671 | 2102174.6826400002 | 37.752797866337794 | -122.404439635397 | (37.7527978663378, -122.404439635397) | |
| 25642 | 25642 | 43023 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 519 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42885 | 6004020.081809999 | 2110698.29349 | 37.7758025350991 | -122.429587516272 | (37.7758025350991, -122.429587516272) | |
| 25688 | 25688 | 95116 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 67 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54043 | 6002297.43224 | 2093241.3314 | 37.727772179934 | -122.43429826136999 | (37.727772179934, -122.43429826137) |
| 25882 | 25882 | 31929 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 450 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 5 | Permit Number 35345 | 5991716.333380001 | 2100485.7522400003 | 37.747057262589 | -122.471404605562 | (37.747057262589, -122.471404605562) | |
| 25960 | 25960 | 31277 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991087.0554599995 | 2097794.191 | 37.739630505545705 | -122.47338429037902 | (37.7396305055457, -122.473384290379) | |
| 26028 | 26028 | 78318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 605 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | 3x6 | 6008900.368419999 | 2091273.5690900001 | 37.722741693447105 | -122.411332749116 | (37.7227416934471, -122.411332749116) | |
| 26032 | 26032 | 48415 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2475 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 8 | Permit Number 45793 | 6001140.73556 | 2118622.32163 | 37.797396422056295 | -122.440116223893 | (37.7973964220563, -122.440116223893) | |
| 26055 | 26055 | 70169 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 3 | 5982394.507019999 | 2111657.31782 | 37.777187531817496 | -122.504465669217 | (37.7771875318175, -122.504465669217) | ||
| 26064 | 26064 | 43329 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43087 | 6003232.20541 | 2091824.6572900002 | 37.7239353231315 | -122.43096566975402 | (37.7239353231315, -122.430965669754) | |
| 26128 | 26128 | 31225 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2491 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34912 | 5987341.6863 | 2098360.1236 | 37.740966813188 | -122.486375538404 | (37.740966813188, -122.486375538404) | |
| 26265 | 26265 | 96024 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 668 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767665 | 6007552.0 | 2113596.0 | 37.783958288790004 | -122.41757510581999 | (37.78395828879, -122.41757510582) |
| 26319 | 26319 | 67661 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 33 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 5 | Permit Number 31262 | 6014174.7724 | 2093920.80707 | 37.7303048875537 | -122.39328528558201 | (37.7303048875537, -122.393285285582) | |
| 26520 | 26520 | 45041 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1874 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2001 12:00:00 AM | 2 | Permit Number 43928 | 5988487.5162 | 2102559.2618 | 37.752563256460206 | -122.48272137554702 | (37.7525632564602, -122.482721375547) | |
| 26534 | 26534 | 42234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 479 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 1 | Permit Number 42487 | 6010475.72371 | 2112231.45093 | 37.780375639875295 | -122.407363816092 | (37.7803756398753, -122.407363816092) | |
| 26685 | 26685 | 72437 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3770 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 8 | 5996832.97473 | 2115019.84204 | 37.7872588007918 | -122.45476169870001 | (37.7872588007918, -122.4547616987) | ||
| 27021 | 27021 | 95729 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 247 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767475 | 6004014.48263 | 2088996.54653 | 37.7162142458739 | -122.428060019581 | (37.7162142458739, -122.428060019581) |
| 27208 | 27208 | 78214 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 743 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | 6011081.23974 | 2091316.8573 | 37.722982629931295 | -122.403796950193 | (37.7229826299313, -122.403796950193) | ||
| 27234 | 27234 | 73651 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2484 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 6 | 5989869.6737 | 2098462.6897 | 37.7413954601505 | -122.477642278142 | (37.7413954601505, -122.477642278142) | ||
| 27276 | 27276 | 84392 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2101 Jerrold Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6012504.257680001 | 2099077.65785 | 37.744371568599796 | -122.39942241122499 | (37.7443715685998, -122.399422411225) | ||
| 27317 | 27317 | 45508 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2929 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44276 | 5988794.6572900005 | 2095738.11606 | 37.7338520448427 | -122.48115980898899 | (37.7338520448427, -122.481159808989) | |
| 27626 | 27626 | 67962 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 859 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 3 | Permit Number 31683 | 5986944.37754 | 2110090.6261299998 | 37.773152403641205 | -122.488611249777 | (37.7731524036412, -122.488611249777) | |
| 27701 | 27701 | 45499 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2963 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 2 | Permit Number 44272 | 5989310.955130001 | 2095557.4598599998 | 37.7333860107429 | -122.47936161996999 | (37.7333860107429, -122.47936161997) | |
| 27720 | 27720 | 72005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1963 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5987221.7723 | 2101915.2958 | 37.7507213765199 | -122.487051188188 | (37.7507213765199, -122.487051188188) | ||
| 27869 | 27869 | 31273 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991084.11448 | 2097836.49496 | 37.7397464910963 | -122.473397543673 | (37.7397464910963, -122.473397543673) | |
| 27935 | 27935 | 31275 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991083.96236 | 2097817.15833 | 37.739693388847606 | -122.47339665963001 | (37.7396933888476, -122.47339665963) | |
| 28003 | 28003 | 60357 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | |
| 28025 | 28025 | 67400 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 547 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 6 | Permit Number 30897 | 5990610.3412 | 2111645.1131599997 | 37.777633837418996 | -122.47604389172199 | (37.777633837419, -122.476043891722) | |
| 28035 | 28035 | 73552 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1558 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 7 | 6000334.7955 | 2110645.2290000003 | 37.775447477965706 | -122.4423320082 | (37.7754474779657, -122.4423320082) | ||
| 28083 | 28083 | 31759 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2654 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35245 | 5989289.1529 | 2097265.3499 | 37.7380741702289 | -122.479561911147 | (37.7380741702289, -122.479561911147) | |
| 28098 | 28098 | 30828 | Permitted Site 1 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 198 Lippard Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 5 | Permit Number 34680 | 6001758.93127 | 2095020.15662 | 37.73262584710739 | -122.436287116556 | (37.7326258471074, -122.436287116556) | |
| 28229 | 28229 | 43752 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 258 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43388 | 5991219.98047 | 2113680.3591 | 37.7832573927775 | -122.47408349916799 | (37.7832573927775, -122.474083499168) | |
| 28323 | 28323 | 43865 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 2 | Permit Number 43482 | 5985465.207 | 2096960.4516 | 37.7370141335806 | -122.49276055533998 | (37.7370141335806, -122.49276055534) | |
| 28327 | 28327 | 95833 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767565 | 6010212.70231 | 2112022.42286 | 37.7797869733249 | -122.408258986859 | (37.7797869733249, -122.408258986859) |
| 28507 | 28507 | 73526 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 807 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 8 | 6009578.52705 | 2116144.74687 | 37.791070356964205 | -122.41074409605899 | (37.7910703569642, -122.410744096059) | ||
| 28586 | 28586 | 69849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 22 Bernice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 6 | 6008480.655259999 | 2108494.13228 | 37.7700019816405 | -122.414001247166 | (37.7700019816405, -122.414001247166) | ||
| 28667 | 28667 | 31457 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35026 | 6001233.81138 | 2102648.72464 | 37.7535422450846 | -122.43864900065701 | (37.7535422450846, -122.438649000657) | |
| 28739 | 28739 | 64507 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 848 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 6 | Permit Number 25388 | 6000492.1653 | 2111922.2928 | 37.778962938676706 | -122.441879309268 | (37.7789629386767, -122.441879309268) | |
| 28805 | 28805 | 64858 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 2 | Permit Number 25874 | 5995885.498430001 | 2112555.8177099996 | 37.7804388557843 | -122.45786137054199 | (37.7804388557843, -122.457861370542) | |
| 28848 | 28848 | 78416 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2959 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 5 | 5990231.308540001 | 2095554.29925 | 37.7334307457305 | -122.47617950378 | (37.7334307457305, -122.47617950378) | ||
| 28886 | 28886 | 40657 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 7 | Permit Number 47919 | 6004684.27364 | 2093706.73058 | 37.729185251382 | -122.4260800191 | (37.729185251382, -122.4260800191) | |
| 28994 | 28994 | 38689 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1387 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 7 | Permit Number 40602 | 6001181.9349 | 2110716.5649 | 37.775691594994505 | -122.439406673557 | (37.7756915949945, -122.439406673557) | |
| 29045 | 29045 | 78786 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1356 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/2002 12:00:00 AM | 7 | 6001332.0848 | 2110785.1298 | 37.7758884007732 | -122.438892183533 | (37.7758884007732, -122.438892183533) |
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");