trees
193 rows where qSpecies_id = 256 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3700 | 60597 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 839 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 3 | Permit Number 20219 | 5999535.7853 | 2111409.5838 | 37.7775006284393 | -122.445150928593 | (37.7775006284393, -122.445150928593) | 15 | 5 | 11 | 54 | 16 | |
| 4015 | 237917 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1295 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5997516.67396 | 2104938.08371 | 37.7596160926213 | -122.45166873503 | (37.7596160926213, -122.45166873503) | 15 | 5 | 11 | 29492 | 12 | |||
| 4669 | 259575 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 300 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 4x4 | 5994278 | 2098760 | 37.7424666368704 | -122.462421492412 | (37.7424666368704, -122.462421492412) | 1 | 8 | 4 | 59 | 40 | ||||
| 6807 | 60384 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1400 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19964 | 6015915.704 | 2094515.2497 | 37.7320336750995 | -122.387308043521 | (37.7320336750995, -122.387308043521) | 10 | 3 | 8 | 58 | 1 | |
| 10278 | 214311 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1616 09th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 5993417.73262 | 2104465.9003 | 37.7580840030825 | -122.465810499549 | (37.7580840030825, -122.465810499549) | 1 | 8 | 4 | 56 | 12 | |||
| 17385 | 29888 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1126 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6005721.57126 | 2102405.52669 | 37.7531287556897 | -122.423112046809 | (37.7531287556897, -122.423112046809) | 2 | 4 | 5 | 28859 | 19 | |||
| 20257 | 178853 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 34 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012436.48238 | 2087819.01103 | 37.7134538649768 | -122.398866750723 | (37.7134538649768, -122.398866750723) | 10 | 3 | 8 | 309 | 1 | |||
| 26626 | 14854 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1357 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 6 | 3x3 | 6002671.377 | 2111611.0853 | 37.7782323757584 | -122.434318296212 | (37.7782323757584, -122.434318296212) | 15 | 5 | 11 | 29492 | 41 | ||
| 30702 | 178854 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 401 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008573.82268 | 2088029.4794 | 37.7138157809362 | -122.412232379621 | (37.7138157809362, -122.412232379621) | 9 | 7 | 8 | 309 | 39 | |||
| 32573 | 237874 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 160 Coso Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6007471.90669 | 2099585.18417 | 37.7454833509872 | -122.416859223383 | (37.7454833509872, -122.416859223383) | 2 | 7 | 7 | 28859 | 2 | ||||
| 41063 | 237904 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 215 Grand View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000729.50411 | 2103183.58085 | 37.7549821289444 | -122.440431357129 | (37.7549821289444, -122.440431357129) | 2 | 4 | 5 | 28862 | 22 | |||
| 43672 | 237890 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Bradford St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 6009586.52326 | 2097993.57219 | 37.7412318491774 | -122.409434875633 | (37.7412318491774, -122.409434875633) | 10 | 7 | 7 | 28859 | 2 | |||
| 45379 | 237887 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 169 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999396.06078 | 2107229.01514 | 37.7660138714542 | -122.44533362007 | (37.7660138714542, -122.44533362007) | 15 | 5 | 5 | 29492 | 9 | |||
| 49088 | 237889 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 722 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007362.196 | 2095569.17155 | 37.7344500984995 | -122.416954096469 | (37.7344500984995, -122.416954096469) | 2 | 7 | 7 | 28859 | 2 | |||
| 50526 | 200068 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2025 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014532.2716 | 2093611.1753 | 37.7294745562967 | -122.392027707824 | (37.7294745562967, -122.392027707824) | 10 | 3 | 8 | 58 | 1 | |||
| 51898 | 105709 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 739 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5992855.21688 | 2110425.97288 | 37.7744163192706 | -122.468189464852 | (37.7744163192706, -122.468189464852) | 11 | 6 | 2 | 54 | 11 | |||
| 52368 | 214315 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1643 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993376.02878 | 2104293.90166 | 37.7576093337224 | -122.465942230469 | (37.7576093337224, -122.465942230469) | 1 | 8 | 4 | 56 | 12 | |||
| 54433 | 237944 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 26 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 15 | Width 2ft | 6002164.0262 | 2096336.81786 | 37.736264104808 | -122.434980737977 | (37.736264104808, -122.434980737977) | 2 | 7 | 5 | 63 | 7 | |||
| 54806 | 135866 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 200 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999037.7073 | 2115878.6146 | 37.7897429809958 | -122.447195652882 | (37.7897429809958, -122.447195652882) | 13 | 6 | 1 | 29490 | 31 | |||
| 55518 | 196321 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1018 Pennsylvania Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 6014465.23121 | 2102394.5848 | 37.7535882525988 | -122.392873735151 | (37.7535882525988, -122.392873735151) | 10 | 3 | 8 | 28856 | 29 | |||
| 62395 | 178850 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 178 Dublin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004207.2935 | 2089409.65664 | 37.7173594632439 | -122.427422984776 | (37.7173594632439, -122.427422984776) | 9 | 7 | 6 | 28861 | 5 | |||
| 64901 | 214336 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 165 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998449.68813 | 2093175.59235 | 37.727372526598 | -122.447595198264 | (37.727372526598, -122.447595198264) | 9 | 7 | 4 | 28861 | 40 | ||||
| 65928 | 237918 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 179 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998918.30257 | 2107113.8819 | 37.7656704608532 | -122.4469777966 | (37.7656704608532, -122.4469777966) | 15 | 5 | 11 | 29492 | 9 | |||
| 67753 | 181899 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2374 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5987671.986 | 2099129.3564 | 37.7430981701656 | -122.485289928402 | (37.7430981701656, -122.485289928402) | 1 | 8 | 3 | 29491 | 35 | |||
| 68350 | 237883 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 74 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005237.83328 | 2105067.23866 | 37.7604098837378 | -122.424974271161 | (37.7604098837378, -122.424974271161) | 2 | 4 | 5 | 28859 | 19 | |||
| 68421 | 178851 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 642 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002153.25457 | 2090190.26057 | 37.719386440714 | -122.434578616011 | (37.719386440714, -122.434578616011) | 9 | 7 | 6 | 28861 | 5 | |||
| 71671 | 178852 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 642 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 6003293.17352 | 2089466.63658 | 37.71746417401 | -122.430586734103 | (37.71746417401, -122.430586734103) | 9 | 7 | 6 | 28861 | 5 | |||
| 75539 | 237900 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008886.65088 | 2103959.41051 | 37.7575734723481 | -122.412276352893 | (37.7575734723481, -122.412276352893) | 2 | 4 | 7 | 28859 | 19 | |||
| 76693 | 142495 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 471 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010670.1646 | 2119603.9064 | 37.800629516216 | -122.407210998267 | (37.800629516216, -122.407210998267) | 3 | 1 | 10 | 308 | 23 | |||
| 77860 | 196324 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2014 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6011723.18554 | 2105150.83196 | 37.761003611654 | -122.40255018945 | (37.761003611654, -122.40255018945) | 10 | 3 | 8 | 28856 | 29 | |||
| 79936 | 116119 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1649x Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2x2 | 6014063.16728 | 2095217.05774 | 37.7338579263887 | -122.393761818374 | (37.7338579263887, -122.393761818374) | 10 | 3 | 8 | 58 | 1 | |||
| 80997 | 214348 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993734.17627 | 2099649.69883 | 37.7448781944898 | -122.464366439256 | (37.7448781944898, -122.464366439256) | 1 | 8 | 4 | 29491 | 40 | |||
| 82140 | 237898 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1087 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009471.98593 | 2102823.41576 | 37.754487114207 | -122.410171817891 | (37.754487114207, -122.410171817891) | 2 | 4 | 7 | 28859 | 19 | |||
| 86444 | 182193 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2830 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985470.896 | 2104355.1387 | 37.7573182698464 | -122.493285511535 | (37.7573182698464, -122.493285511535) | 1 | 8 | 3 | 56 | 35 | |||
| 90482 | 237885 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 730 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997985.44903 | 2107861.40989 | 37.7676696429749 | -122.450258206855 | (37.7676696429749, -122.450258206855) | 15 | 5 | 11 | 29492 | 9 | |||
| 90527 | 237920 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1237 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003246.87227 | 2101064.36652 | 37.7493062835598 | -122.43157430031 | (37.7493062835598, -122.43157430031) | 2 | 4 | 5 | 28862 | 22 | |||
| 91375 | 87840 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 150 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50723 | 6008834.94947 | 2112868.30248 | 37.7820323124688 | -122.413085083511 | (37.7820323124688, -122.413085083511) | 7 | 10 | 9 | 28852 | 36 | |
| 91722 | 135867 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2881 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999809.28552 | 2117392.98346 | 37.7939450956373 | -122.444634966434 | (37.7939450956373, -122.444634966434) | 13 | 9 | 1 | 57 | 27 | |||
| 92929 | 182339 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3081 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985312.4034 | 2104975.8588 | 37.759013323653 | -122.493879375972 | (37.759013323653, -122.493879375972) | 1 | 8 | 3 | 56 | 35 | |||
| 94586 | 237901 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 185 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999340.20511 | 2104037.69867 | 37.7572481219159 | -122.445297337804 | (37.7572481219159, -122.445297337804) | 2 | 5 | 5 | 28862 | 3 | |||
| 96174 | 237905 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3937 21st St | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6002227.46362 | 2103520.47073 | 37.7559923274905 | -122.435275090576 | (37.7559923274905, -122.435275090576) | 2 | 4 | 5 | 28862 | 22 | ||||
| 98475 | 214346 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1477 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994262.65159 | 2105461.95539 | 37.7608676152654 | -122.462960694582 | (37.7608676152654, -122.462960694582) | 1 | 5 | 11 | 56 | 12 | |||
| 98934 | 23463 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2300 Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | 9 | 6005896.8378 | 2118341.60488 | 37.7968952622641 | -122.423638887645 | (37.7968952622641, -122.423638887645) | 13 | 9 | 1 | 28858 | 32 | |||
| 100569 | 214323 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 211 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 5994213.9284 | 2098746.30202 | 37.742425335868 | -122.462642037812 | (37.742425335868, -122.462642037812) | 1 | 8 | 4 | 59 | 40 | |||
| 102207 | 214334 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 470 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5998312.15542 | 2094413.43188 | 37.7307634815435 | -122.448159739578 | (37.7307634815435, -122.448159739578) | 9 | 7 | 4 | 59 | 40 | |||
| 102517 | 214318 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 16 Belmont Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5996661.12102 | 2106238.02694 | 37.7631363718759 | -122.454721566453 | (37.7631363718759, -122.454721566453) | 15 | 5 | 11 | 29492 | 12 | ||||
| 103259 | 237897 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1351 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009296.40092 | 2101303.05308 | 37.7503026946211 | -122.410671678154 | (37.7503026946211, -122.410671678154) | 2 | 4 | 7 | 28859 | 19 | |||
| 103932 | 196323 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1922 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | 6012591.21229 | 2102864.69613 | 37.7547748064319 | -122.399387546319 | (37.7547748064319, -122.399387546319) | 10 | 3 | 8 | 28856 | 29 | ||||
| 104781 | 18905 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2602 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002286.89222 | 2115779.97328 | 37.789657253131 | -122.435946744753 | (37.789657253131, -122.435946744753) | 13 | 6 | 1 | 29490 | 27 | |||
| 107179 | 237926 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 23 Seward St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6001036.33691 | 2104228.71408 | 37.7578692773617 | -122.439445158788 | (37.7578692773617, -122.439445158788) | 2 | 4 | 5 | 28862 | 38 | |||
| 108292 | 135873 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1002 Vallejo St | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 6008628.64799 | 2118672.57502 | 37.7979578472257 | -122.414209576908 | (37.7979578472257, -122.414209576908) | 5 | 1 | 10 | 308 | 21 | ||||
| 112904 | 237921 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1235 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003247.45246 | 2101075.30094 | 37.7493363397968 | -122.431573074532 | (37.7493363397968, -122.431573074532) | 2 | 4 | 5 | 28862 | 22 | |||
| 113311 | 237891 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 61 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007462.84884 | 2099058.94868 | 37.7440379165229 | -122.416853268066 | (37.7440379165229, -122.416853268066) | 2 | 7 | 7 | 28859 | 2 | |||
| 113903 | 183562 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2591 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5987056.0774 | 2097655.4477 | 37.7390153079093 | -122.487311308785 | (37.7390153079093, -122.487311308785) | 1 | 8 | 3 | 29491 | 35 | |||
| 115839 | 214335 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 570 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5997650.4841 | 2094424.8417 | 37.730756962361 | -122.450448052843 | (37.730756962361, -122.450448052843) | 9 | 7 | 4 | 59 | 40 | ||||
| 116631 | 237922 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 167 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002705.54642 | 2104925.31615 | 37.7598768339596 | -122.433722125974 | (37.7598768339596, -122.433722125974) | 2 | 4 | 5 | 28862 | 3 | |||
| 123915 | 237895 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6010025.93602 | 2099871.47095 | 37.7464127607541 | -122.408047938455 | (37.7464127607541, -122.408047938455) | 2 | 7 | 7 | 28859 | 2 | |||
| 124031 | 214313 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1630 09th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 6ft | 5993420.04408 | 2104384.15571 | 37.7578596869935 | -122.465796566365 | (37.7578596869935, -122.465796566365) | 1 | 8 | 4 | 56 | 12 | |||
| 126456 | 58192 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 707 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1978 12:00:00 AM | 10 | Permit Number 17180 | 5992850.41876 | 2110607.08647 | 37.7749133313412 | -122.468219240401 | (37.7749133313412, -122.468219240401) | 11 | 6 | 2 | 54 | 11 | ||
| 130829 | 214354 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 8 Edgehill Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994911.61844 | 2099129.89576 | 37.7435187450863 | -122.460257437746 | (37.7435187450863, -122.460257437746) | 1 | 8 | 4 | 59 | 40 | |||
| 131053 | 237923 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 552 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6002969.94721 | 2104996.10401 | 37.7600861997348 | -122.432812750413 | (37.7600861997348, -122.432812750413) | 2 | 4 | 5 | 28862 | 3 | |||
| 136175 | 237886 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 286 Upper Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999373.81016 | 2106048.64713 | 37.7627716059584 | -122.445325703321 | (37.7627716059584, -122.445325703321) | 15 | 5 | 5 | 29492 | 9 | |||
| 136617 | 26103 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1557 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/1988 12:00:00 AM | 12 | 3x3 | 6015264.4135 | 2095277.0122 | 37.7340892301542 | -122.38961289841 | (37.7340892301542, -122.38961289841) | 10 | 3 | 8 | 58 | 1 | ||
| 141525 | 237882 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 814 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008528.1634 | 2103776.1584 | 37.7570501811472 | -122.413503191821 | (37.7570501811472, -122.413503191821) | 2 | 4 | 7 | 28859 | 19 | |||
| 141606 | 214343 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 105 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991402.99723 | 2089917.07257 | 37.7180201978552 | -122.47171800939 | (37.7180201978552, -122.47171800939) | 9 | 8 | 6 | 64 | 24 | |||
| 145267 | 237932 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Lower Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6000437.08664 | 2106174.23917 | 37.7631770886698 | -122.441657229316 | (37.7631770886698, -122.441657229316) | 15 | 5 | 5 | 28862 | 3 | |||
| 145318 | 51089 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2004 12:00:00 AM | 6 | Permit Number 47546 | 6001713.34736 | 2117152.10978 | 37.7933921861489 | -122.438029475688 | (37.7933921861489, -122.438029475688) | 13 | 6 | 1 | 29490 | 27 | ||
| 152943 | 237894 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010034.07785 | 2099858.60697 | 37.7463778949392 | -122.408018877775 | (37.7463778949392, -122.408018877775) | 2 | 7 | 7 | 28859 | 2 | |||
| 154055 | 214310 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1870 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5990380.69599 | 2102646.45339 | 37.7529126261287 | -122.476180871663 | (37.7529126261287, -122.476180871663) | 1 | 8 | 4 | 56 | 12 | |||
| 155222 | 214321 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 166 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991310.02713 | 2104174.00205 | 37.7571607203998 | -122.473078490286 | (37.7571607203998, -122.473078490286) | 1 | 8 | 4 | 56 | 12 | |||
| 157438 | 237939 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 273 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000450.96835 | 2106715.6224 | 37.764664383877 | -122.441648071496 | (37.764664383877, -122.441648071496) | 15 | 5 | 5 | 28862 | 3 | |||
| 157689 | 142479 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 472 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010643.4105 | 2119643.0095 | 37.8007353864259 | -122.407306336996 | (37.8007353864259, -122.407306336996) | 3 | 1 | 10 | 308 | 23 | |||
| 160402 | 214324 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 121 Miraloma Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5994586.44209 | 2096871.4866 | 37.7372990050334 | -122.461218135833 | (37.7372990050334, -122.461218135833) | 9 | 7 | 4 | 59 | 40 | |||
| 160624 | 68433 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2518 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 3 | Permit Number 32286 | 6002013.47223 | 2116725.04565 | 37.7922366418513 | -122.436960435397 | (37.7922366418513, -122.436960435397) | 13 | 6 | 1 | 29490 | 27 | ||
| 166266 | 214341 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 144 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995498.01894 | 2089341.34439 | 37.7166754640834 | -122.457521759431 | (37.7166754640834, -122.457521759431) | 9 | 8 | 6 | 28861 | 24 | |||
| 168860 | 237942 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 320 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003704.07001 | 2108683.26654 | 37.7702518672718 | -122.430536868479 | (37.7702518672718, -122.430536868479) | 15 | 9 | 11 | 29492 | 10 | |||
| 171201 | 237876 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006280.46143 | 2097653.37775 | 37.740111956701 | -122.420841935814 | (37.740111956701, -122.420841935814) | 2 | 7 | 7 | 28859 | 2 | ||||
| 172002 | 98002 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1904 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x12 | 6003787.47736 | 2119037.49851 | 37.7986867144679 | -122.430987461215 | (37.7986867144679, -122.430987461215) | 13 | 9 | 1 | 57 | 17 | |||
| 174026 | 237902 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 4120 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003116.41859 | 2100685.05072 | 37.7482573763929 | -122.43199832888 | (37.7482573763929, -122.43199832888) | 2 | 4 | 5 | 28862 | 22 | |||
| 175069 | 237929 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 741 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002446.47935 | 2103887.09921 | 37.7570114365341 | -122.434543876122 | (37.7570114365341, -122.434543876122) | 2 | 4 | 5 | 28862 | 3 | |||
| 175507 | 237940 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 67 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003085.03748 | 2108738.20516 | 37.7703676280017 | -122.432682022255 | (37.7703676280017, -122.432682022255) | 15 | 5 | 5 | 29492 | 9 | |||
| 184666 | 237884 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1229 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 5997429.19812 | 2105587.88131 | 37.7613952627958 | -122.452018150436 | (37.7613952627958, -122.452018150436) | 15 | 5 | 11 | 29492 | 12 | |||
| 186784 | 58839 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2385 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1979 12:00:00 AM | 8 | Permit Number 18096 | 6002233.54572 | 2117374.3754 | 37.7940320393926 | -122.436245468077 | (37.7940320393926, -122.436245468077) | 13 | 9 | 1 | 29490 | 27 | ||
| 188214 | 237893 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 48 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007622.58869 | 2099939.38246 | 37.7464643746486 | -122.416363270665 | (37.7464643746486, -122.416363270665) | 2 | 7 | 7 | 28859 | 2 | |||
| 188969 | 214342 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 331 Lakeview Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5996752.352 | 2089647.99235 | 37.7175894189894 | -122.453208302426 | (37.7175894189894, -122.453208302426) | 9 | 8 | 6 | 28861 | 24 | |||
| 193172 | 183467 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2534 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5988330.845 | 2098043.4689 | 37.7401549687764 | -122.482932230746 | (37.7401549687764, -122.482932230746) | 1 | 8 | 3 | 29491 | 35 | |||
| 193510 | 237943 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 22 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 6 | Width 3ft | 6002178.91966 | 2096366.03049 | 37.7363451615923 | -122.434931333735 | (37.7363451615923, -122.434931333735) | 2 | 7 | 5 | 63 | 7 | |||
| 137527 | 214328 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100 Vista Verde Ct | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 10ft | 5999189.95231 | 2096066.10598 | 37.7353514772763 | -122.44524384613 | (37.7353514772763, -122.44524384613) | 9 | 7 | 4 | 63 | 40 | |||
| 166314 | 214317 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 20 Belmont Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5996726.67758 | 2106195.56131 | 37.763023532129 | -122.454491761784 | (37.763023532129, -122.454491761784) | 15 | 5 | 11 | 29492 | 12 | ||||
| 63930 | 214329 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 11 | Median : Yard | Tree | DPW 1 | 11 | Width 9ft | 5995487.46893 | 2099377.84768 | 37.7442326665051 | -122.458284246023 | (37.7442326665051, -122.458284246023) | 1 | 8 | 4 | 59 | 40 | |||
| 132201 | 196330 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011759.95887 | 2105639.7656 | 37.7623481673595 | -122.402457386618 | (37.7623481673595, -122.402457386618) | 8 | 3 | 8 | 28856 | 29 | ||||
| 137500 | 214351 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100 Vista Verde Ct | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999187.72445 | 2096110.16457 | 37.7354723245737 | -122.445254715344 | (37.7354723245737, -122.445254715344) | 9 | 7 | 4 | 63 | 40 | |||
| 23810 | 214330 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 12 | Median : Yard | Tree | DPW 1 | 10 | Width 9ft | 5995527.4625 | 2099368.48178 | 37.7442092481691 | -122.458145280077 | (37.7442092481691, -122.458145280077) | 1 | 8 | 4 | 59 | 40 | |||
| 152210 | 214350 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100 Vista Verde Ct | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999173.54374 | 2096088.24984 | 37.735411342443 | -122.445302168061 | (37.735411342443, -122.445302168061) | 9 | 7 | 4 | 63 | 40 | |||
| 168191 | 214331 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 13 | Median : Yard | Tree | DPW 1 | 2 | Width 9ft | 5995540.56521 | 2099364.92702 | 37.7442002405496 | -122.458099716827 | (37.7442002405496, -122.458099716827) | 1 | 8 | 4 | 59 | 40 | |||
| 168300 | 202088 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1 Gould St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6012849.75876 | 2091137.38485 | 37.722588475066 | -122.397670917693 | (37.722588475066, -122.397670917693) | 10 | 3 | 8 | 58 | 1 | ||||
| 128972 | 214332 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 18 | Median : Yard | Tree | DPW 1 | 9 | Width 9ft | 5995718.21124 | 2099321.84536 | 37.7440921546362 | -122.457482343055 | (37.7440921546362, -122.457482343055) | 1 | 8 | 4 | 59 | 40 | |||
| 65407 | 237928 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 310 Liberty St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6004144.43295 | 2103938.76991 | 37.7572495536268 | -122.428675392374 | (37.7572495536268, -122.428675392374) | 2 | 4 | 5 | 28862 | 3 | |||
| 7816 | 237931 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 18 Temple St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999994.62286 | 2105880.85812 | 37.7623463174434 | -122.443166486857 | (37.7623463174434, -122.443166486857) | 15 | 5 | 5 | 28862 | 3 | |||
| 15259 | 178849 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 13 Liebig St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5995911.23484 | 2086261.34028 | 37.7082422172863 | -122.455870959398 | (37.7082422172863, -122.455870959398) | 7 | 6 | 28861 | 25 |
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) );