Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188393 | 188393 | 238414 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000656.2221099995 | 2105622.5799 | 37.761674851230296 | -122.44085973930099 | (37.7616748512303, -122.440859739301) | |||
| 188338 | 188338 | 237241 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 467 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998529.49857 | 2106472.57998 | 37.7638873867061 | -122.448276395158 | (37.7638873867061, -122.448276395158) | |||
| 188145 | 188145 | 213572 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6 Merced Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995340.05175 | 2100264.05702 | 37.7466575040536 | -122.45885812859801 | (37.7466575040536, -122.458858128598) | |||
| 188053 | 188053 | 66364 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 472 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1991 12:00:00 AM | 4 | Permit Number 29965 | 5991908.34552 | 2112195.95462 | 37.7792214762424 | -122.471593848027 | (37.7792214762424, -122.471593848027) | ||
| 187959 | 187959 | 88452 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 4 | 5x12 | 6005470.42698 | 2121378.16696 | 37.8052088057127 | -122.425330567252 | (37.8052088057127, -122.425330567252) | ||
| 187197 | 187197 | 120727 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 474 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989397.82148 | 2112121.21454 | 37.7788706974235 | -122.48027321576001 | (37.7788706974235, -122.48027321576) | |||
| 186721 | 186721 | 213319 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 262 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991459.9673 | 2090912.89222 | 37.7207577701313 | -122.471593616958 | (37.7207577701313, -122.471593616958) | |||
| 186655 | 186655 | 238405 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003809.565119999 | 2108171.76515 | 37.7688533845966 | -122.430135465991 | (37.7688533845966, -122.430135465991) | |||
| 186414 | 186414 | 45549 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990323.96119 | 2095935.96592 | 37.7344840775814 | -122.47588704426201 | (37.7344840775814, -122.475887044262) | ||
| 186409 | 186409 | 45569 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 310 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44312 | 5997642.12042 | 2115315.11009 | 37.7881159077753 | -122.451983551718 | (37.7881159077753, -122.451983551718) | |
| 185845 | 185845 | 238428 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Mars St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5999550.38613 | 2105480.9679099997 | 37.76122297789 | -122.444674186789 | (37.76122297789, -122.444674186789) | |||
| 185823 | 185823 | 237189 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004351.715890001 | 2103282.1102 | 37.7554582498219 | -122.427911736635 | (37.7554582498219, -122.427911736635) | |||
| 185419 | 185419 | 96033 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767672 | 6008167.44383 | 2115805.7111 | 37.790060229456294 | -122.41560239383301 | (37.7900602294563, -122.415602393833) |
| 185356 | 185356 | 135996 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009314.46183 | 2117374.97438 | 37.794433452692104 | -122.41174472045601 | (37.7944334526921, -122.411744720456) | |||
| 185274 | 185274 | 135977 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2065 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6003684.735780001 | 2117929.31477 | 37.795638105372895 | -122.431263834562 | (37.7956381053729, -122.431263834562) | |||
| 183942 | 183942 | 238248 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003967.82352 | 2105120.30526 | 37.7604837720267 | -122.42937043070299 | (37.7604837720267, -122.429370430703) | |||
| 183269 | 183269 | 135964 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 Broadway | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001301.4834199995 | 2117308.30173 | 37.7937976176176 | -122.439465753262 | (37.7937976176176, -122.439465753262) | |||
| 182840 | 182840 | 179092 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004478.253830001 | 2092876.7352900002 | 37.7268946223776 | -122.42673316430201 | (37.7268946223776, -122.426733164302) | |||
| 182764 | 182764 | 213402 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2111 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991606.081259999 | 2101026.68041 | 37.7485361329461 | -122.471825260742 | (37.7485361329461, -122.471825260742) | |||
| 182646 | 182646 | 238112 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 375 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006785.71084 | 2101613.6712599997 | 37.751014495425295 | -122.419375862811 | (37.7510144954253, -122.419375862811) | |||
| 182464 | 182464 | 214574 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1441 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991211.29509 | 2106533.5678 | 37.7636337446377 | -122.473592054438 | (37.7636337446377, -122.473592054438) | |||
| 182153 | 182153 | 214597 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1380 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993363.01616 | 2106105.83321 | 37.7625836746058 | -122.46611890136299 | (37.7625836746058, -122.466118901363) | |||
| 181827 | 181827 | 213350 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 610 Head St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993524.58129 | 2089927.1808799999 | 37.7181704754556 | -122.464385407781 | (37.7181704754556, -122.464385407781) | |||
| 181691 | 181691 | 213563 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996504.15927 | 2094478.31136 | 37.7308381018815 | -122.454414916535 | (37.7308381018815, -122.454414916535) | |||
| 181027 | 181027 | 196510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Matthew Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017931.224780001 | 2094293.63767 | 37.7315365882339 | -122.380324481997 | (37.7315365882339, -122.380324481997) | |||
| 180962 | 180962 | 214752 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995609.0834800005 | 2093408.98072 | 37.727850604413796 | -122.457431983704 | (37.7278506044138, -122.457431983704) | |||
| 180872 | 180872 | 179136 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Burrows St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010838.78874 | 2093367.25092 | 37.7285990373024 | -122.404779339894 | (37.7285990373024, -122.404779339894) | |||
| 180746 | 180746 | 238098 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 970 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009393.96902 | 2103533.4588 | 37.7564323594785 | -122.41049175708599 | (37.7564323594785, -122.410491757086) | |||
| 179657 | 179657 | 238526 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 30th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003170.6602 | 2098315.46605 | 37.7417541232615 | -122.431641611885 | (37.7417541232615, -122.431641611885) | |||
| 178412 | 178412 | 238166 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3851 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002757.34107 | 2103546.83542 | 37.756094795346705 | -122.433444484595 | (37.7560947953467, -122.433444484595) | |||
| 178321 | 178321 | 213623 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995805.80133 | 2096226.42669 | 37.7355979265959 | -122.456955630803 | (37.7355979265959, -122.456955630803) | |||
| 178233 | 178233 | 238257 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002630.88394 | 2105571.65187 | 37.761647278923995 | -122.43402654919 | (37.761647278924, -122.43402654919) | |||
| 176728 | 176728 | 238413 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000620.6168 | 2105576.07492 | 37.761545132131296 | -122.440979546976 | (37.7615451321313, -122.440979546976) | |||
| 176727 | 176727 | 213479 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 250 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992112.189780001 | 2095156.89303 | 37.7324484585195 | -122.46964790583701 | (37.7324484585195, -122.469647905837) | |||
| 176683 | 176683 | 179153 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 412 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 8ft | 6001969.08964 | 2086773.8202799999 | 37.7099951946836 | -122.434970999229 | (37.7099951946836, -122.434970999229) | |||
| 176665 | 176665 | 237281 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 536 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007994.0626300005 | 2096346.0131 | 37.7366186589168 | -122.414824480273 | (37.7366186589168, -122.414824480273) | |||
| 176624 | 176624 | 213429 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2344 Cecilia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991482.19388 | 2099461.6129099997 | 37.7442316925378 | -122.472139593583 | (37.7442316925378, -122.472139593583) | |||
| 176556 | 176556 | 179061 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Colonial Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000459.355169999 | 2093573.28788 | 37.728579155081206 | -122.440676311782 | (37.7285791550812, -122.440676311782) | |||
| 176274 | 176274 | 238476 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 381 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003886.03434 | 2109005.47799 | 37.7711468878542 | -122.429930442157 | (37.7711468878542, -122.429930442157) | |||
| 176153 | 176153 | 237433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1206 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6001927.83941 | 2100530.44886 | 37.747765421138794 | -122.43609733352699 | (37.7477654211388, -122.436097333527) | |||
| 176075 | 176075 | 214540 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 609 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993836.216659999 | 2106624.1684 | 37.7640341767683 | -122.46451992297199 | (37.7640341767683, -122.464519922972) | |||
| 175471 | 175471 | 238304 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4540 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001222.48655 | 2104091.20816 | 37.7575023116873 | -122.438791523428 | (37.7575023116873, -122.438791523428) | |||
| 175400 | 175400 | 238348 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 278 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003838.52771 | 2104528.23485 | 37.7588507668706 | -122.429775374741 | (37.7588507668706, -122.429775374741) | |||
| 175301 | 175301 | 67942 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 586 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 4 | Permit Number 31656 | 5989115.53927 | 2111342.9098799997 | 37.776717282669296 | -122.48119272322701 | (37.7767172826693, -122.481192723227) | |
| 174844 | 174844 | 213535 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996040.92015 | 2094127.28499 | 37.7298476902047 | -122.45599103146499 | (37.7298476902047, -122.455991031465) | |||
| 174698 | 174698 | 49745 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46544 | 6008556.3350599995 | 2087877.23988 | 37.7133967814171 | -122.41228206988899 | (37.7133967814171, -122.412282069889) | |
| 173982 | 173982 | 213346 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992956.82489 | 2088699.8094099998 | 37.7147676656708 | -122.466258733373 | (37.7147676656708, -122.466258733373) | |||
| 173911 | 173911 | 84352 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 06th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51575 | 5994138.19056 | 2110541.38294 | 37.7748072179408 | -122.463759829065 | (37.7748072179408, -122.463759829065) | |
| 173628 | 173628 | 237346 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 207 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008796.404569999 | 2097657.6817099997 | 37.740265265032605 | -122.412143102127 | (37.7402652650326, -122.412143102127) | |||
| 173623 | 173623 | 238312 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 74 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999934.524730001 | 2104479.26331 | 37.7584944572775 | -122.443273669837 | (37.7584944572775, -122.443273669837) | |||
| 173620 | 173620 | 237200 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003436.897000001 | 2099196.2236599997 | 37.7441875672949 | -122.430783892462 | (37.7441875672949, -122.430783892462) | |||
| 173218 | 173218 | 237348 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1305 Eugenia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008557.2056599995 | 2097676.42362 | 37.740303301858 | -122.412971483856 | (37.740303301858, -122.412971483856) | |||
| 172983 | 172983 | 50299 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 4 | Permit Number 47010 | 5989048.57412 | 2095810.2761099997 | 37.7340649359436 | -122.480287231884 | (37.7340649359436, -122.480287231884) | |
| 171050 | 171050 | 214532 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 805 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993224.68666 | 2106601.39795 | 37.763936383573295 | -122.46663335226499 | (37.7639363835733, -122.466633352265) | |||
| 170892 | 170892 | 214541 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 604 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993864.92677 | 2106687.84743 | 37.764210677716996 | -122.46442524773899 | (37.764210677717, -122.464425247739) | |||
| 170814 | 170814 | 179132 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009928.59229 | 2093027.9547 | 37.727616484787205 | -122.40790203874501 | (37.7276164847872, -122.407902038745) | |||
| 170540 | 170540 | 213688 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998099.236269999 | 2095311.8097599999 | 37.7332180398727 | -122.44896052110501 | (37.7332180398727, -122.448960521105) | |||
| 170485 | 170485 | 120737 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 734 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989462.460519999 | 2110322.27124 | 37.773935053699 | -122.4799179267 | (37.773935053699, -122.4799179267) | |||
| 170449 | 170449 | 179031 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Tucker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010327.66378 | 2088774.95095 | 37.7159609509146 | -122.406222917279 | (37.7159609509146, -122.406222917279) | |||
| 170179 | 170179 | 214795 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 292 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995452.2912099995 | 2097504.4195 | 37.7390866747017 | -122.458270312832 | (37.7390866747017, -122.458270312832) | |||
| 170090 | 170090 | 214602 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1352 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993354.826830001 | 2106288.96143 | 37.7630860242229 | -122.46616053368 | (37.7630860242229, -122.46616053368) | |||
| 169477 | 169477 | 136000 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009476.57256 | 2116845.84647 | 37.792989689179294 | -122.411146401493 | (37.7929896891793, -122.411146401493) | |||
| 169398 | 169398 | 237446 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 879 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001309.32831 | 2101280.0918900003 | 37.7497886034602 | -122.438289805157 | (37.7497886034602, -122.438289805157) | |||
| 169376 | 169376 | 213558 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 60 Valdez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5996393.4117 | 2094019.32459 | 37.72957148234121 | -122.45476463767599 | (37.7295714823412, -122.454764637676) | |||
| 168896 | 168896 | 237308 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 203 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009026.69702 | 2097414.14807 | 37.7396094937884 | -122.41132964014601 | (37.7396094937884, -122.411329640146) | |||
| 167820 | 167820 | 45548 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990306.88184 | 2095939.17218 | 37.734491890873606 | -122.475946326684 | (37.7344918908736, -122.475946326684) | ||
| 167713 | 167713 | 238512 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Arlington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004381.48819 | 2096377.8106200001 | 37.7365023199311 | -122.42731697179899 | (37.7365023199311, -122.427316971799) | |||
| 167659 | 167659 | 135989 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Myrtle St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007041.41912 | 2114167.7009900003 | 37.785499296995795 | -122.419382103224 | (37.7854992969958, -122.419382103224) | |||
| 167607 | 167607 | 238245 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3995 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003097.16034 | 2104736.91782 | 37.759381750889794 | -122.43235426975201 | (37.7593817508898, -122.432354269752) | |||
| 166833 | 166833 | 238516 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001807.33737 | 2096679.7017700002 | 37.7371853253266 | -122.43623848751999 | (37.7371853253266, -122.43623848752) | |||
| 166620 | 166620 | 213624 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 54 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995380.54139 | 2096143.4290099998 | 37.735345605619294 | -122.458419901559 | (37.7353456056193, -122.458419901559) | |||
| 166435 | 166435 | 179135 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010828.32671 | 2093363.20014 | 37.7285873299367 | -122.404815222846 | (37.7285873299367, -122.404815222846) | |||
| 166314 | 166314 | 238047 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 400 Lily St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004564.74999 | 2110005.30362 | 37.7739305791617 | -122.42765398556601 | (37.7739305791617, -122.427653985566) | |||
| 166176 | 166176 | 68393 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 248 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 4 | Permit Number 32221 | 6001588.48331 | 2093972.4225299999 | 37.729739323692705 | -122.436801419974 | (37.7297393236927, -122.436801419974) | |
| 165990 | 165990 | 238260 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002684.23387 | 2105269.06904 | 37.7608194871373 | -122.433820405688 | (37.7608194871373, -122.433820405688) | |||
| 165776 | 165776 | 179116 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Yale St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006991.89793 | 2093240.59071 | 37.7280354870245 | -122.418069316059 | (37.7280354870245, -122.418069316059) | |||
| 165692 | 165692 | 214531 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 825 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993201.56141 | 2106599.90569 | 37.763930951669394 | -122.46671322643999 | (37.7639309516694, -122.46671322644) | |||
| 165523 | 165523 | 238424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 166 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999753.17114 | 2106004.66697 | 37.7626724952591 | -122.444010471812 | (37.7626724952591, -122.444010471812) | |||
| 165469 | 165469 | 45480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3014 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44262 | 5990294.42195 | 2095159.6612900002 | 37.732350829908704 | -122.47593249418699 | (37.7323508299087, -122.475932494187) | |
| 165384 | 165384 | 79359 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 567 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2004 12:00:00 AM | 4 | 5985009.753819999 | 2112015.61326 | 37.778324785429895 | -122.495445265062 | (37.7783247854299, -122.495445265062) | ||
| 165307 | 165307 | 213589 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1971 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993451.57313 | 2102072.4961200003 | 37.7515142846609 | -122.46551959497299 | (37.7515142846609, -122.465519594973) | |||
| 164977 | 164977 | 135995 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009287.1824 | 2117369.66466 | 37.7944173431466 | -122.41183873557199 | (37.7944173431466, -122.411838735572) | |||
| 164850 | 164850 | 31788 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35258 | 6001692.80487 | 2107894.1622099997 | 37.7679710399513 | -122.437437296395 | (37.7679710399513, -122.437437296395) | |
| 164530 | 164530 | 135993 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009221.31733 | 2117360.97425 | 37.794389786122 | -122.412066023053 | (37.794389786122, -122.412066023053) | |||
| 164276 | 164276 | 238148 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 802 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001868.63348 | 2101724.21233 | 37.7510398482207 | -122.436387489002 | (37.7510398482207, -122.436387489002) | |||
| 163927 | 163927 | 213650 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 166 Marietta Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998669.243480001 | 2097904.09309 | 37.7403684145664 | -122.44717635790899 | (37.7403684145664, -122.447176357909) | |||
| 163902 | 163902 | 135915 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004293.78648 | 2119207.639 | 37.7991825520948 | -122.429247608494 | (37.7991825520948, -122.429247608494) | |||
| 163386 | 163386 | 214771 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Forest Hill Path | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994272.06767 | 2100993.3623099998 | 37.748598545893394 | -122.46260397398999 | (37.7485985458934, -122.46260397399) | |||
| 163145 | 163145 | 239496 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 541 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008200.5938800005 | 2096299.6237700002 | 37.7365028864977 | -122.414107129744 | (37.7365028864977, -122.414107129744) | |||
| 162648 | 162648 | 82704 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 67 Jennings Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2005 12:00:00 AM | 4 | 6012930.127090001 | 2089200.7150299998 | 37.7172752435332 | -122.39725735994301 | (37.7172752435332, -122.397257359943) | ||
| 162176 | 162176 | 45547 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990293.1703699995 | 2095939.4617299999 | 37.734491890875795 | -122.47599375241501 | (37.7344918908758, -122.475993752415) | ||
| 161711 | 161711 | 238328 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 230 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002043.417090001 | 2104477.9419400003 | 37.758610859222706 | -122.435980092511 | (37.7586108592227, -122.435980092511) | |||
| 161202 | 161202 | 214674 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2650 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991779.85078 | 2097391.18651 | 37.73856405080021 | -122.470959574244 | (37.7385640508002, -122.470959574244) | |||
| 161023 | 161023 | 214591 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1333 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993612.54689 | 2106403.41455 | 37.7634151482214 | -122.46527748849199 | (37.7634151482214, -122.465277488492) | |||
| 160997 | 160997 | 214553 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1104 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992323.456069999 | 2106634.49291 | 37.7639752037022 | -122.46975282075701 | (37.7639752037022, -122.469752820757) | |||
| 159600 | 159600 | 213583 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Garcia Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994657.50527 | 2099501.27559 | 37.744523840899205 | -122.46116300556801 | (37.7445238408992, -122.461163005568) | |||
| 159006 | 159006 | 124472 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2474 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995885.81707 | 2110375.20896 | 37.7744514982012 | -122.457702438809 | (37.7744514982012, -122.457702438809) | |||
| 158498 | 158498 | 213636 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996783.68078 | 2094092.94585 | 37.729796007073396 | -122.453420758283 | (37.7297960070734, -122.453420758283) | |||
| 158154 | 158154 | 79061 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1006 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6012156.574130001 | 2103666.55961 | 37.756952313327396 | -122.40094698961599 | (37.7569523133274, -122.400946989616) | ||
| 157491 | 157491 | 213339 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 375 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992194.5826900005 | 2090348.43318 | 37.7192503768696 | -122.46901324258499 | (37.7192503768696, -122.469013242585) |
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");