trees
4,014 rows where qSpecies_id = 40 sorted by qSiteInfo descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2321 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | 10 | 3 | 8 | 28856 | 29 | |||
| 10385 | 239400 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 338 Hoffman Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6000612.89044 | 2101776.73481 | 37.7511126294541 | -122.440733730797 | (37.7511126294541, -122.440733730797) | 2 | 4 | 5 | 28862 | 22 | |||
| 13363 | 238529 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 32 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6003245.12676 | 2097701.12571 | 37.7400715069955 | -122.431340287739 | (37.7400715069955, -122.431340287739) | 2 | 7 | 5 | 63 | 7 | ||||
| 16830 | 213628 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 518 Rockdale Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5997988.71827 | 2097660.25448 | 37.7396599853215 | -122.449511768669 | (37.7396599853215, -122.449511768669) | 9 | 7 | 4 | 59 | 40 | |||
| 27491 | 179073 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 201 Otsego Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 6000546.42551 | 2092093.61368 | 37.7245212674143 | -122.440269236362 | (37.7245212674143, -122.440269236362) | 9 | 7 | 6 | 28861 | 25 | |||
| 29986 | 238434 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 68 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001857.68079 | 2106239.01592 | 37.763435786759 | -122.436748514639 | (37.763435786759, -122.436748514639) | 15 | 5 | 5 | 28862 | 3 | |||
| 30704 | 213625 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 Sequoia Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5998243.47992 | 2097619.18832 | 37.7395617982244 | -122.448627959023 | (37.7395617982244, -122.448627959023) | 9 | 7 | 4 | 59 | 40 | |||
| 31261 | 213337 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 280 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992227.25788 | 2089749.39386 | 37.7176074486088 | -122.468856729068 | (37.7176074486088, -122.468856729068) | 9 | 8 | 6 | 64 | 24 | |||
| 31913 | 237437 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1633 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6002067.17233 | 2099257.65655 | 37.7442785481133 | -122.435524488761 | (37.7442785481133, -122.435524488761) | 2 | 7 | 5 | 63 | 22 | |||
| 32351 | 196476 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2074 Revere Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6012584.77785 | 2096296.25792 | 37.7367389189762 | -122.398948809344 | (37.7367389189762, -122.398948809344) | 10 | 3 | 8 | 58 | 1 | |||
| 34019 | 99712 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 34456 | 213358 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5990836.79794 | 2095256.57076 | 37.7326483517269 | -122.474064462004 | (37.7326483517269, -122.474064462004) | 1 | 8 | 4 | 64 | 40 | |||
| 36264 | 213336 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 280 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992226.96216 | 2089735.33948 | 37.7175688416125 | -122.468856729061 | (37.7175688416125, -122.468856729061) | 9 | 8 | 6 | 64 | 24 | |||
| 37382 | 239402 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 338 Hoffman Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6000616.75777 | 2101741.19606 | 37.7510152688496 | -122.440717808276 | (37.7510152688496, -122.440717808276) | 2 | 4 | 5 | 28862 | 22 | |||
| 37497 | 214816 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 655 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5997091.21284 | 2094378.0504 | 37.7305964594612 | -122.452378156221 | (37.7305964594612, -122.452378156221) | 9 | 7 | 4 | 28861 | 40 | |||
| 40196 | 196441 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 768 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012093.04476 | 2104807.3138 | 37.7600810286241 | -122.401246859559 | (37.7600810286241, -122.401246859559) | 10 | 3 | 8 | 28856 | 29 | ||||
| 41489 | 213629 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Arroyo Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998678.27789 | 2097325.31412 | 37.7387797423796 | -122.447103478636 | (37.7387797423796, -122.447103478636) | 9 | 7 | 4 | 59 | 40 | |||
| 43264 | 238379 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4045 20th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003509.36574 | 2104168.85122 | 37.7578453401174 | -122.430888121192 | (37.7578453401174, -122.430888121192) | 2 | 4 | 5 | 28862 | 3 | |||
| 46479 | 213682 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 305 Baden St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6000730.9848 | 2095013.8875 | 37.7325501736469 | -122.439840520538 | (37.7325501736469, -122.439840520538) | 9 | 7 | 5 | 63 | 40 | |||
| 47636 | 213622 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 759 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998023.15096 | 2095930.2118 | 37.7349116728363 | -122.44926810546 | (37.7349116728363, -122.44926810546) | 9 | 7 | 4 | 59 | 40 | |||
| 48564 | 124048 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 693 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5992526.55561 | 2110733.67497 | 37.7752421991768 | -122.469348757796 | (37.7752421991768, -122.469348757796) | 11 | 6 | 2 | 54 | 11 | ||||
| 56670 | 213333 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 147 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991918.76578 | 2089524.27892 | 37.7169715101175 | -122.469906655166 | (37.7169715101175, -122.469906655166) | 9 | 8 | 6 | 64 | 24 | |||
| 56781 | 135965 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2574 Broadway | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6001290.6793 | 2117307.18376 | 37.7937939330834 | -122.439503056242 | (37.7937939330834, -122.439503056242) | 13 | 9 | 1 | 57 | 27 | |||
| 57761 | 124180 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Almaden Ct | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 9ft | 5995876 | 2112606 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | 11 | 6 | 2 | 54 | 16 | |||
| 59147 | 179041 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2908 20th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5990269.38069 | 2095895.56899 | 37.7343699931708 | -122.476072795627 | (37.7343699931708, -122.476072795627) | 1 | 8 | 4 | 64 | 35 | |||
| 61293 | 124047 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 693 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5992526.15399 | 2110751.16453 | 37.7752901975761 | -122.469351420391 | (37.7752901975761, -122.469351420391) | 11 | 6 | 2 | 54 | 11 | ||||
| 61800 | 213321 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 325 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5991673.59488 | 2090710.5616 | 37.7202145769251 | -122.470840448236 | (37.7202145769251, -122.470840448236) | 9 | 8 | 6 | 64 | 24 | |||
| 62065 | 94707 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 40 Edgehill Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/29/2010 12:00:00 AM | 6 | Permit Number 53868 | 5994701.2 | 2098925.3 | 37.7429448703691 | -122.460970181408 | (37.7429448703691, -122.460970181408) | 1 | 8 | 4 | 59 | 40 | ||
| 65608 | 238309 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 84 Seward St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6000741.11024 | 2104546.1812 | 37.758724158512 | -122.440488942513 | (37.758724158512, -122.440488942513) | 2 | 4 | 5 | 28862 | 38 | |||
| 65809 | 99710 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 67957 | 213281 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 321 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5994152.36191 | 2092054.50461 | 37.7240477617885 | -122.462369665551 | (37.7240477617885, -122.462369665551) | 9 | 8 | 4 | 59 | 40 | ||||
| 70509 | 214483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1868 17th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5990967.17432 | 2102702.632 | 37.7531008695265 | -122.474156838569 | (37.7531008695265, -122.474156838569) | 1 | 8 | 4 | 56 | 12 | |||
| 70635 | 238378 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4045 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003444.53767 | 2104166.53773 | 37.7578353144667 | -122.431112158497 | (37.7578353144667, -122.431112158497) | 2 | 4 | 5 | 28862 | 3 | |||
| 70689 | 94959 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.378088153142 | (37.7364745658864, -122.378088153142) | 10 | 3 | 8 | 58 | 1 | ||||
| 73476 | 124184 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 18 Almaden Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 5995890.93647 | 2112594.82496 | 37.7805462717533 | -122.457845381425 | (37.7805462717533, -122.457845381425) | 11 | 6 | 2 | 54 | 16 | |||
| 75405 | 213683 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 305 Baden St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6000730.40073 | 2094998.07335 | 37.732506718412 | -122.43984140637 | (37.732506718412, -122.43984140637) | 9 | 7 | 5 | 63 | 40 | |||
| 80154 | 135938 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Walnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998466.03707 | 2116398.73144 | 37.7911384032693 | -122.44921105427 | (37.7911384032693, -122.44921105427) | 13 | 6 | 1 | 54 | 31 | |||
| 81472 | 238389 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 80 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001987.06172 | 2105419.43251 | 37.7611927624445 | -122.436242371703 | (37.7611927624445, -122.436242371703) | 15 | 4 | 5 | 28862 | 3 | |||
| 82028 | 237426 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4301 26th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6001882.89987 | 2100571.76133 | 37.7478763021598 | -122.436255687975 | (37.7478763021598, -122.436255687975) | 2 | 4 | 5 | 63 | 22 | |||
| 82186 | 124232 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Paramount Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5996415.54869 | 2110976.74716 | 37.7761335815126 | -122.455913502291 | (37.7761335815126, -122.455913502291) | 11 | 6 | 2 | 54 | 16 | |||
| 82671 | 196501 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 351 Tehama St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6011701.40176 | 2112798.07009 | 37.7819999683719 | -122.403163468629 | (37.7819999683719, -122.403163468629) | 6 | 2 | 9 | 28853 | 34 | |||
| 82939 | 238308 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 84 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000740.70306 | 2104526.54658 | 37.7586702234594 | -122.440488942504 | (37.7586702234594, -122.440488942504) | 2 | 4 | 5 | 28862 | 38 | |||
| 87774 | 239461 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5725 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000723.2907 | 2097082.59304 | 37.7382299184717 | -122.44001540269 | (37.7382299184717, -122.44001540269) | 2 | 7 | 5 | 63 | 7 | |||
| 90536 | 196502 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 351 Tehama St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6011719.28839 | 2112815.50725 | 37.7820488456301 | -122.403102815636 | (37.7820488456301, -122.403102815636) | 6 | 2 | 9 | 28853 | 34 | |||
| 94147 | 238390 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 80 Collingwood St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001989.17062 | 2105400.26005 | 37.7611402393495 | -122.436233705824 | (37.7611402393495, -122.436233705824) | 15 | 4 | 5 | 28862 | 3 | |||
| 95156 | 238087 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 175 Montcalm St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6010138.47184 | 2099734.59131 | 37.7460432194236 | -122.407649151187 | (37.7460432194236, -122.407649151187) | 2 | 7 | 7 | 28859 | 2 | |||
| 96820 | 135927 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3400 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5999297.26526 | 2120520.00382 | 37.8025018265619 | -122.446631690727 | (37.8025018265619, -122.446631690727) | 13 | 9 | 1 | 57 | 17 | ||||
| 97613 | 213327 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 331 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5991934.3542 | 2090733.05166 | 37.7202914059971 | -122.469940735003 | (37.7202914059971, -122.469940735003) | 9 | 8 | 6 | 64 | 24 | |||
| 100129 | 238045 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 38 Dolores St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 6004739.1194 | 2107851.95841 | 37.7680278762037 | -122.426897421898 | (37.7680278762037, -122.426897421898) | 8 | 4 | 5 | 28862 | 3 | |||
| 103112 | 238530 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 45 Harry St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6003244.09378 | 2097672.28705 | 37.7399922641312 | -122.431341801277 | (37.7399922641312, -122.431341801277) | 2 | 7 | 5 | 63 | 7 | |||
| 105143 | 135961 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2600 Divisadero St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000735.77189 | 2117237.48779 | 37.7935709695869 | -122.441418078004 | (37.7935709695869, -122.441418078004) | 13 | 9 | 1 | 57 | 27 | |||
| 109470 | 213623 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 125 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995805.80133 | 2096226.42669 | 37.7355979265959 | -122.456955630803 | (37.7355979265959, -122.456955630803) | 9 | 7 | 4 | 59 | 40 | |||
| 110354 | 99709 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 110791 | 213341 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 455 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992454.16583 | 2090885.02641 | 37.7207387260928 | -122.468154982671 | (37.7207387260928, -122.468154982671) | 9 | 8 | 6 | 64 | 24 | |||
| 111822 | 213323 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 395 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991938.55148 | 2091189.98285 | 37.7215462696313 | -122.469959478668 | (37.7215462696313, -122.469959478668) | 9 | 8 | 6 | 64 | 24 | |||
| 112314 | 238394 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 30 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6001974.4587 | 2105696.43162 | 37.7619526185486 | -122.436305784682 | (37.7619526185486, -122.436305784682) | 15 | 4 | 5 | 28862 | 3 | |||
| 113427 | 213319 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 262 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991459.9673 | 2090912.89222 | 37.7207577701313 | -122.471593616958 | (37.7207577701313, -122.471593616958) | 9 | 8 | 6 | 64 | 24 | |||
| 115210 | 213362 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Elmhurst Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991224.3842 | 2094533.07073 | 37.7306842467752 | -122.472671762002 | (37.7306842467752, -122.472671762002) | 9 | 8 | 4 | 64 | 40 | |||
| 115597 | 196503 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 351 Tehama St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6011737.82052 | 2112830.87734 | 37.7820920832107 | -122.403039783975 | (37.7820920832107, -122.403039783975) | 6 | 2 | 9 | 28853 | 34 | |||
| 116153 | 238327 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 311 Collingwood St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6002110.45234 | 2104015.29957 | 37.7573443628555 | -122.435715154927 | (37.7573443628555, -122.435715154927) | 2 | 4 | 5 | 28862 | 3 | |||
| 116299 | 213681 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 305 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6000730.35653 | 2095033.04499 | 37.7326027399078 | -122.439844065674 | (37.7326027399078, -122.439844065674) | 9 | 7 | 5 | 63 | 40 | |||
| 117443 | 214826 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 115 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5999324.23026 | 2093457.23325 | 37.7281957885028 | -122.444592150628 | (37.7281957885028, -122.444592150628) | 9 | 7 | 4 | 28861 | 40 | |||
| 120749 | 213338 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 280 Ralston St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992226.7586 | 2089761.94489 | 37.7176418818408 | -122.468859367667 | (37.7176418818408, -122.468859367667) | 9 | 8 | 6 | 64 | 24 | |||
| 120823 | 238388 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 80 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6001986.47657 | 2105431.50433 | 37.7612258754818 | -122.436245259426 | (37.7612258754818, -122.436245259426) | 15 | 4 | 5 | 28862 | 3 | |||
| 121822 | 213320 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 238 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5991458.7746 | 2090762.70401 | 37.7203453212587 | -122.471586801009 | (37.7203453212587, -122.471586801009) | 9 | 8 | 6 | 64 | 24 | |||
| 126609 | 213359 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 Beachmont Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5990836.58141 | 2095246.30718 | 37.7326201579899 | -122.474064462004 | (37.7326201579899, -122.474064462004) | 1 | 8 | 4 | 64 | 40 | |||
| 126699 | 213650 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 166 Marietta Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998669.24348 | 2097904.09309 | 37.7403684145664 | -122.447176357909 | (37.7403684145664, -122.447176357909) | 9 | 7 | 4 | 59 | 40 | |||
| 128234 | 213626 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 Sequoia Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998241.71999 | 2097608.84354 | 37.7395332933126 | -122.44863329921 | (37.7395332933126, -122.44863329921) | 9 | 7 | 4 | 59 | 40 | |||
| 132358 | 238528 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 28 Harry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6003301.96281 | 2097731.40275 | 37.7401578616993 | -122.431145932563 | (37.7401578616993, -122.431145932563) | 2 | 7 | 5 | 63 | 7 | |||
| 134486 | 196470 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Newcomb Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6013295.58948 | 2097174.20298 | 37.7391891560441 | -122.396552730329 | (37.7391891560441, -122.396552730329) | 10 | 3 | 8 | 58 | 1 | |||
| 135045 | 135943 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2056 Jefferson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5999351.77852 | 2121203.50658 | 37.8043816542415 | -122.446492250814 | (37.8043816542415, -122.446492250814) | 13 | 9 | 1 | 57 | 17 | |||
| 135361 | 213617 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 317 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5996181.3126 | 2095353.67754 | 37.7332231255301 | -122.455594290163 | (37.7332231255301, -122.455594290163) | 9 | 7 | 4 | 59 | 40 | |||
| 136075 | 238305 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 83 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000704.12797 | 2104538.43627 | 37.7587007869337 | -122.440616288315 | (37.7587007869337, -122.440616288315) | 2 | 4 | 5 | 28862 | 38 | |||
| 136490 | 213347 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 529 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5993232.83209 | 2090695.61301 | 37.7202635827786 | -122.465449643 | (37.7202635827786, -122.465449643) | 9 | 8 | 6 | 64 | 24 | |||
| 137806 | 214484 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1868 17th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5990968.36883 | 2102715.12154 | 37.7531352317224 | -122.474153618996 | (37.7531352317224, -122.474153618996) | 1 | 8 | 4 | 56 | 12 | |||
| 139829 | 213618 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 47 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5997823.37766 | 2095859.28539 | 37.7347054969618 | -122.449953678441 | (37.7347054969618, -122.449953678441) | 9 | 7 | 4 | 59 | 40 | |||
| 140958 | 213621 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 758 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998164.29493 | 2096098.97248 | 37.7353831217245 | -122.44879227507 | (37.7353831217245, -122.44879227507) | 9 | 7 | 4 | 59 | 40 | |||
| 142295 | 196471 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | 10 | 3 | 8 | 58 | 1 | |||
| 145661 | 99708 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 148124 | 213332 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 151 Byxbee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991918.25557 | 2089546.87165 | 37.717033514761 | -122.46991006272 | (37.717033514761, -122.46991006272) | 9 | 8 | 6 | 64 | 24 | |||
| 149319 | 179072 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90 Arago St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5999599.07977 | 2092991.34212 | 37.7269322392262 | -122.443608534205 | (37.7269322392262, -122.443608534205) | 9 | 7 | 6 | 28861 | 25 | |||
| 150596 | 99706 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100@Moncada Paloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 152250 | 214815 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 655 Hearst Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5997076.75558 | 2094378.60032 | 37.7305971411349 | -122.452428176541 | (37.7305971411349, -122.452428176541) | 9 | 7 | 4 | 28861 | 40 | |||
| 153775 | 179150 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 332 Edinburgh St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003465.83302 | 2091792.2726 | 37.7238596371003 | -122.430155747501 | (37.7238596371003, -122.430155747501) | 9 | 7 | 6 | 28861 | 5 | |||
| 156207 | 135964 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2574 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6001301.48342 | 2117308.30173 | 37.7937976176176 | -122.439465753262 | (37.7937976176176, -122.439465753262) | 13 | 9 | 1 | 57 | 27 | |||
| 158690 | 135917 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2350 Green St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6001679.33795 | 2118057.34258 | 37.7958757853901 | -122.438212029083 | (37.7958757853901, -122.438212029083) | 13 | 9 | 1 | 57 | 17 | |||
| 161801 | 213694 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 219 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998610.14505 | 2093760.09504 | 37.7289866028382 | -122.447082546947 | (37.7289866028382, -122.447082546947) | 9 | 7 | 4 | 28861 | 40 | ||||
| 164454 | 123144 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 572 10th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5992865.77571 | 2111587.14442 | 37.7776051929209 | -122.468237429505 | (37.7776051929209, -122.468237429505) | 11 | 6 | 2 | 54 | 11 | |||
| 164649 | 99707 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100@Moncada Paloma Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 167556 | 214790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 385 Valdez Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5995727.44967 | 2095481.97924 | 37.7335493555041 | -122.457172685764 | (37.7335493555041, -122.457172685764) | 9 | 7 | 4 | 59 | 40 | |||
| 167908 | 213290 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.72101711662 | -122.462357593044 | (37.72101711662, -122.462357593044) | 9 | 8 | 6 | 28861 | 24 | |||
| 171289 | 136015 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Havens St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6007560.5835 | 2119380.86157 | 37.7998425735334 | -122.417955630044 | (37.7998425735334, -122.417955630044) | 5 | 1 | 1 | 28858 | 32 | |||
| 171924 | 118209 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 574 35th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5985058.9891 | 2111965.86595 | 37.7781910764099 | -122.495271274867 | (37.7781910764099, -122.495271274867) | 11 | 6 | 2 | 55 | 26 | |||
| 172521 | 117710 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 477 41st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | 11 | 6 | 2 | 55 | 26 | |||
| 173058 | 202147 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1979 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6012955.25231 | 2093506.82348 | 37.7291003454988 | -122.397472339298 | (37.7291003454988, -122.397472339298) | 10 | 3 | 8 | 58 | 1 | |||
| 174868 | 213322 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 329 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991674.00828 | 2090730.18875 | 37.7202684921693 | -122.470840448222 | (37.7202684921693, -122.470840448222) | 9 | 8 | 6 | 64 | 24 | |||
| 176507 | 136014 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6007575.68988 | 2119392.22094 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) | 5 | 1 | 1 | 28858 | 32 | |||
| 178365 | 94706 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 40 Edgehill Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/29/2010 12:00:00 AM | 6 | Permit Number 53868 | 5994701.2 | 2098925.3 | 37.7429448703691 | -122.460970181408 | (37.7429448703691, -122.460970181408) | 1 | 8 | 4 | 59 | 40 | ||
| 179639 | 214789 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 385 Valdez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5995719.97757 | 2095492.23955 | 37.7335770986874 | -122.457199260764 | (37.7335770986874, -122.457199260764) | 9 | 7 | 4 | 59 | 40 | |||
| 182177 | 99711 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 |
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) );