trees
193 rows where qSpecies_id = 256 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194036 | 135868 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2881 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999820.06951 | 2117394.7311 | 37.7939505095535 | -122.444597778561 | (37.7939505095535, -122.444597778561) | 13 | 9 | 1 | 57 | 27 | |||
| 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 | |||
| 193384 | 237880 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006230.93863 | 2097643.52174 | 37.7400821028175 | -122.421012466149 | (37.7400821028175, -122.421012466149) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | |||
| 192023 | 135862 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 8 Kimball Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008000.71273 | 2116486.83875 | 37.7919210652522 | -122.416227532369 | (37.7919210652522, -122.416227532369) | 5 | 1 | 10 | 28858 | 21 | |||
| 191326 | 214353 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 50 Garcia Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995149.72336 | 2099349.67966 | 37.7441359102383 | -122.459450049774 | (37.7441359102383, -122.459450049774) | 1 | 8 | 4 | 59 | 40 | |||
| 190908 | 214344 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 498 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992505.71978 | 2091140.82125 | 37.7214440535804 | -122.467995374584 | (37.7214440535804, -122.467995374584) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 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 | |||
| 187537 | 237925 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 37 Seward St | 7 | Front Yard : Yard | Tree | Private 2 | 14 | Width 3ft | 6000968.93807 | 2104244.5163 | 37.7579088304528 | -122.439679384512 | (37.7579088304528, -122.439679384512) | 2 | 4 | 5 | 28862 | 38 | |||
| 187535 | 135865 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2518 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001998.80283 | 2116724.02313 | 37.7922330004913 | -122.437011118472 | (37.7922330004913, -122.437011118472) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | ||
| 186104 | 214333 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 312 Hearst Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999316.02125 | 2094400.93218 | 37.7307864969836 | -122.444688331319 | (37.7307864969836, -122.444688331319) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 177804 | 237877 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6006273.45555 | 2097651.54951 | 37.7401065418729 | -122.420866029569 | (37.7401065418729, -122.420866029569) | 2 | 7 | 7 | 28859 | 2 | ||||
| 177598 | 18547 | Landmark tree 11 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1700X Quesada Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014668.27449 | 2095058.71423 | 37.733456755021 | -122.391658696189 | (37.733456755021, -122.391658696189) | 10 | 3 | 8 | 58 | 1 | |||
| 177113 | 237933 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Lower Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000440.92976 | 2106173.77589 | 37.7631760355812 | -122.441643904037 | (37.7631760355812, -122.441643904037) | 15 | 5 | 5 | 28862 | 3 | |||
| 176476 | 214349 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 290 San Fernando Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992100.51565 | 2094983.26623 | 37.7319710480083 | -122.469675630143 | (37.7319710480083, -122.469675630143) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 174153 | 196333 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 801 Arkansas St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6013061.90076 | 2103711.91526 | 37.7571273088036 | -122.397819189808 | (37.7571273088036, -122.397819189808) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 172736 | 178855 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1101 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011864.77985 | 2089786.97938 | 37.7188256378672 | -122.400980956107 | (37.7188256378672, -122.400980956107) | 10 | 7 | 8 | 309 | 39 | |||
| 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 | |||
| 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 | ||||
| 169227 | 237935 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 272 Corbett Ave | 4 | Side Yard : Yard | Tree | Private 2 | 6 | Width 3ft | 5999636.03267 | 2105332.26436 | 37.7608195617885 | -122.444367285948 | (37.7608195617885, -122.444367285948) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 167799 | 214320 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1518 05th Ave | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | 5994627.9467 | 2105254.67875 | 37.7603195216609 | -122.461682280428 | (37.7603195216609, -122.461682280428) | 15 | 5 | 4 | 56 | 12 | ||||
| 167408 | 214325 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 121 Miraloma Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5994585.09435 | 2096884.89716 | 37.7373357495539 | -122.461223767378 | (37.7373357495539, -122.461223767378) | 9 | 7 | 4 | 59 | 40 | |||
| 167208 | 135869 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001710.05375 | 2117173.2312 | 37.7934499927743 | -122.438042385449 | (37.7934499927743, -122.438042385449) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | ||||
| 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 | |||
| 165907 | 181900 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2374 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5987672.3244 | 2099143.5701 | 37.7431372169369 | -122.485289801059 | (37.7431372169369, -122.485289801059) | 1 | 8 | 3 | 29491 | 35 | |||
| 160687 | 237907 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3911 21st St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6002340.71018 | 2103530.84091 | 37.7560272319733 | -122.434884188553 | (37.7560272319733, -122.434884188553) | 2 | 4 | 5 | 28862 | 22 | ||||
| 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 | ||
| 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 | |||
| 159830 | 135871 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001702.83254 | 2117214.86813 | 37.7935639062924 | -122.43807035526 | (37.7935639062924, -122.43807035526) | 13 | 6 | 1 | 29490 | 27 | |||
| 158815 | 214327 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100 Vista Verde Ct | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999204.10164 | 2096073.93624 | 37.7353737849692 | -122.445195489605 | (37.7353737849692, -122.445195489605) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | |||
| 157516 | 183563 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2593 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5987056.9644 | 2097643.917 | 37.7389836993781 | -122.487307395263 | (37.7389836993781, -122.487307395263) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 157371 | 237934 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Lower Ter | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000443.26422 | 2106174.87839 | 37.76317919578 | -122.441635909067 | (37.76317919578, -122.441635909067) | 15 | 5 | 5 | 28862 | 3 | |||
| 156361 | 214312 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1616 09th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 5993417.09067 | 2104452.78428 | 37.7580479528666 | -122.465811766705 | (37.7580479528666, -122.465811766705) | 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 | |||
| 154527 | 27415 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2300 Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 9 | 6005889.8891 | 2118381.22689 | 37.7970036620469 | -122.423665750374 | (37.7970036620469, -122.423665750374) | 13 | 9 | 1 | 28858 | 32 | |||
| 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 | |||
| 153709 | 196329 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011758.91837 | 2105646.20338 | 37.7623657859795 | -122.402461438042 | (37.7623657859795, -122.402461438042) | 8 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 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 | |||
| 149035 | 135870 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6001706.98139 | 2117190.01379 | 37.7934958986807 | -122.438054218747 | (37.7934958986807, -122.438054218747) | 13 | 6 | 1 | 29490 | 27 | |||
| 148401 | 196332 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 801 Arkansas St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013061.70024 | 2103702.02862 | 37.7571001510787 | -122.39781918981 | (37.7571001510787, -122.39781918981) | 10 | 3 | 8 | 28856 | 29 | ||||
| 147707 | 214356 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 811 Congo St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6000533.92821 | 2095885.0481 | 37.7349309587854 | -122.44058425268 | (37.7349309587854, -122.44058425268) | 9 | 7 | 4 | 63 | 40 | ||||
| 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 | ||
| 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 | |||
| 144998 | 237910 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 414 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6002101.86364 | 2103432.68582 | 37.7557441577743 | -122.435703175979 | (37.7557441577743, -122.435703175979) | 2 | 4 | 5 | 28862 | 22 | ||||
| 143109 | 196325 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011758.16915 | 2105659.78061 | 37.7624030241958 | -122.402464984075 | (37.7624030241958, -122.402464984075) | 8 | 3 | 8 | 28856 | 29 | ||||
| 142548 | 196328 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011759.42256 | 2105649.40128 | 37.7623745948457 | -122.402459919101 | (37.7623745948457, -122.402459919101) | 8 | 3 | 8 | 28856 | 29 | ||||
| 141635 | 237881 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6006228.09651 | 2097633.90585 | 37.7400555395259 | -122.42102161048 | (37.7400555395259, -122.42102161048) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||||
| 131455 | 237916 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1295 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5997518.24966 | 2104934.77487 | 37.7596070976188 | -122.451663046815 | (37.7596070976188, -122.451663046815) | 15 | 5 | 11 | 29492 | 12 | |||
| 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 | |||
| 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 | |||
| 130359 | 117740 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 475 39th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5983746.49746 | 2112674.00016 | 37.7800584750229 | -122.499863945897 | (37.7800584750229, -122.499863945897) | 11 | 6 | 2 | 55 | 26 | |||
| 129701 | 200001 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1450 Griffith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6017674.9346 | 2092354.0887 | 37.7261968206849 | -122.381075736801 | (37.7261968206849, -122.381075736801) | 10 | 3 | 8 | 58 | 1 | |||
| 129479 | 214340 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 10 Granada Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995647.31789 | 2089997.48145 | 37.7184856365862 | -122.457053144299 | (37.7184856365862, -122.457053144299) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 128567 | 214322 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 350x Kensington Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | Width 6ft | 5994251.85903 | 2099042.92229 | 37.7432419652355 | -122.462532396964 | (37.7432419652355, -122.462532396964) | 1 | 8 | 4 | 59 | 40 | |||
| 127469 | 196326 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6011758.07727 | 2105655.26159 | 37.7623906108466 | -122.40246498408 | (37.7623906108466, -122.40246498408) | 8 | 3 | 8 | 28856 | 29 | ||||
| 127191 | 237892 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 61 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007463.8743 | 2099061.81517 | 37.7440458449445 | -122.416849925291 | (37.7440458449445, -122.416849925291) | 2 | 7 | 7 | 28859 | 2 | |||
| 126920 | 214314 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1630 09th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 6ft | 5993419.49404 | 2104375.41426 | 37.7578356535119 | -122.465797833501 | (37.7578356535119, -122.465797833501) | 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 | ||
| 125030 | 178857 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 701 Delta St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6009291.72599 | 2087274.33794 | 37.711782574777 | -122.409697761866 | (37.711782574777, -122.409697761866) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | |||
| 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 | |||
| 121176 | 135861 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 5 Dicha Aly | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 5998316.32407 | 2113776.61007 | 37.7839301859787 | -122.44954003255 | (37.7839301859787, -122.44954003255) | 15 | 6 | 1 | 54 | 31 | |||
| 118841 | 196331 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 801 Arkansas St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013062.01072 | 2103694.01523 | 37.7570781653471 | -122.397817553962 | (37.7570781653471, -122.397817553962) | 10 | 3 | 8 | 28856 | 29 | ||||
| 118298 | 237930 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 4119 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002901.50765 | 2104134.40267 | 37.7577162927848 | -122.432987885294 | (37.7577162927848, -122.432987885294) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 116148 | 98003 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1904 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x12 | 6003782.57859 | 2119037.12075 | 37.7986853996597 | -122.431004385541 | (37.7986853996597, -122.431004385541) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | ||||
| 115454 | 135863 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 8 Kimball Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007998.64807 | 2116497.60836 | 37.7919505198577 | -122.416235439221 | (37.7919505198577, -122.416235439221) | 5 | 1 | 10 | 28858 | 21 | |||
| 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 | |||
| 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 | |||
| 113135 | 237873 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1200 San Jose Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004198.3369 | 2096122.91618 | 37.7357920776323 | -122.427932046027 | (37.7357920776323, -122.427932046027) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 110895 | 135872 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001695.18556 | 2117280.97246 | 37.7937449767048 | -122.438101551856 | (37.7937449767048, -122.438101551856) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | ||||
| 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 | |||
| 105432 | 237938 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 272 Corbett Ave | 7 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 5999643.14509 | 2105335.62313 | 37.7608291899369 | -122.44434292871 | (37.7608291899369, -122.44434292871) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 104386 | 237875 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 200 Kingston St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | 6006243.16762 | 2098035.54696 | 37.7411592055212 | -122.420998010444 | (37.7411592055212, -122.420998010444) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 |
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) );