trees
268 rows where qSpecies_id = 77 sorted by qAddress 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54637 | 238586 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 991 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6011096.08107 | 2103736.70014 | 37.7570856908704 | -122.404619530365 | (37.7570856908704, -122.404619530365) | 10 | 4 | 8 | 28859 | 19 | |||
| 151721 | 41603 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 98X Hoff St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |
| 51211 | 122964 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 98 09th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 5993049.94359 | 2114912.63546 | 37.7867467201865 | -122.467842267803 | (37.7867467201865, -122.467842267803) | 11 | 6 | 1 | 54 | 11 | |||
| 103313 | 122967 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 98 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993050.69162 | 2114890.11462 | 37.7866849273422 | -122.467838041215 | (37.7866849273422, -122.467838041215) | 11 | 6 | 1 | 54 | 11 | |||
| 84016 | 196547 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Wisconsin St | 1 | : | Tree | Private 2 | 10 | Width 6ft | 6012751.32394 | 2103003.67516 | 37.7551653352247 | -122.398843585967 | (37.7551653352247, -122.398843585967) | 10 | 3 | 8 | 28856 | 29 | |||
| 36420 | 124156 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995846.07339 | 2112226.83412 | 37.7795332890719 | -122.457973944713 | (37.7795332890719, -122.457973944713) | 11 | 6 | 2 | 54 | 16 | |||
| 79691 | 124155 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995858.43793 | 2112228.39454 | 37.7795382839593 | -122.457931283713 | (37.7795382839593, -122.457931283713) | 11 | 6 | 2 | 54 | 16 | |||
| 51956 | 196545 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 938 Rhode Island St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6011854.06587 | 2104027.62304 | 37.7579268348784 | -122.402018565106 | (37.7579268348784, -122.402018565106) | 10 | 3 | 8 | 28856 | 29 | |||
| 183984 | 239022 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 927 Church St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6004402.67666 | 2103488.0295 | 37.7560265386112 | -122.42775016985 | (37.7560265386112, -122.42775016985) | 2 | 4 | 5 | 28862 | 22 | |||
| 129753 | 238587 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 88 Hoff St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006547.66375 | 2106304.16095 | 37.763880083309 | -122.420531969171 | (37.763880083309, -122.420531969171) | 8 | 4 | 7 | 28859 | 19 | |||
| 52717 | 5516 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 839 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/2009 12:00:00 AM | 3 | 6X6 | 6005075.66356 | 2103479.99989 | 37.7560425375576 | -122.425422183901 | (37.7560425375576, -122.425422183901) | 2 | 4 | 5 | 28859 | 19 | ||
| 39652 | 124172 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 81 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995886.79128 | 2112251.90704 | 37.7796044719959 | -122.457834899878 | (37.7796044719959, -122.457834899878) | 11 | 6 | 2 | 54 | 16 | |||
| 17624 | 120418 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 779 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5988805.2712 | 2110017.74707 | 37.7730607113316 | -122.482168912555 | (37.7730607113316, -122.482168912555) | 11 | 6 | 2 | 55 | 26 | |||
| 83042 | 123363 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994763.50549 | 2110414.96281 | 37.7744961151162 | -122.461587583233 | (37.7744961151162, -122.461587583233) | 11 | 6 | 2 | 54 | 11 | |||
| 182789 | 123365 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5994764.07466 | 2110395.82025 | 37.7744435874791 | -122.461584226231 | (37.7744435874791, -122.461584226231) | 11 | 6 | 2 | 54 | 11 | |||
| 183292 | 123364 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994764.09915 | 2110406.2546 | 37.7744722388497 | -122.461584898177 | (37.7744722388497, -122.461584898177) | 11 | 6 | 2 | 54 | 11 | |||
| 29395 | 83672 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 76 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52299 | 6012122.94965 | 2095206.11599 | 37.7337198723641 | -122.400469008954 | (37.7337198723641, -122.400469008954) | 10 | 3 | 8 | 58 | 1 | |
| 152029 | 123081 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 756 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992285.07246 | 2110293.11916 | 37.7740185941965 | -122.470152007973 | (37.7740185941965, -122.470152007973) | 11 | 6 | 2 | 54 | 11 | |||
| 65368 | 50856 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 743 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | 4 | Permit Number 47371 | 5985677.37672 | 2110827.17931 | 37.7751007543065 | -122.493048175392 | (37.7751007543065, -122.493048175392) | 11 | 6 | 2 | 55 | 26 | ||
| 77284 | 44274 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 730 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2001 12:00:00 AM | 4 | Permit Number 43700 | 6011255.06578 | 2104741.61874 | 37.7598538580824 | -122.404140420144 | (37.7598538580824, -122.404140420144) | 10 | 3 | 8 | 28856 | 29 | ||
| 70516 | 123029 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 730 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991968.39214 | 2110452.13533 | 37.7744368966539 | -122.471259036935 | (37.7744368966539, -122.471259036935) | 11 | 6 | 2 | 54 | 11 | |||
| 25428 | 238585 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 73 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005403.58671 | 2103307.08135 | 37.7555862656019 | -122.424275817175 | (37.7555862656019, -122.424275817175) | 2 | 4 | 5 | 28859 | 19 | |||
| 30515 | 238584 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 73 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005403.70836 | 2103296.31784 | 37.7555567183818 | -122.42427463098 | (37.7555567183818, -122.42427463098) | 2 | 4 | 5 | 28859 | 19 | |||
| 154619 | 114678 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 726 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774712 | 6011027.75702 | 2091361.80007 | 37.7231030455441 | -122.40398499124 | (37.7231030455441, -122.40398499124) | 10 | 3 | 7 | 309 | 28 | ||
| 2376 | 57631 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 724 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1976 12:00:00 AM | 8 | Permit Number 16529 | 6004511.94268 | 2110995.61836 | 37.7766467538829 | -122.427907235555 | (37.7766467538829, -122.427907235555) | 7 | 9 | 11 | 28852 | 10 | |
| 105268 | 213731 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 72 Merced Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994987.04868 | 2099905.16215 | 37.7456517715262 | -122.460052772716 | (37.7456517715262, -122.460052772716) | 1 | 8 | 4 | 59 | 40 | |||
| 106942 | 62466 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 708 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/2012 12:00:00 AM | 2 | Permit Number 769096 | 6011238.859 | 2104985.8972 | 37.7605236866263 | -122.40421366454 | (37.7605236866263, -122.40421366454) | 10 | 3 | 8 | 28856 | 29 | |
| 173613 | 238599 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007470.12204 | 2105516.97902 | 37.7617706074473 | -122.417285669309 | (37.7617706074473, -122.417285669309) | 2 | 4 | 7 | 28859 | 19 | |||
| 192755 | 52450 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 672 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48563 | 5992577.48944 | 2110887.44098 | 37.7756673423473 | -122.469183761515 | (37.7756673423473, -122.469183761515) | 11 | 6 | 2 | 54 | 11 |
| 4262 | 213721 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 2 | Median : Yard | Tree | DPW 1 | 1 | 5993647.57824 | 2097426.08398 | 37.7387677148629 | -122.464504452814 | (37.7387677148629, -122.464504452814) | 1 | 8 | 4 | 59 | 40 | ||||
| 63461 | 213724 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 8 | Median : Yard | Tree | DPW 1 | 8 | 5993565.41473 | 2097500.59466 | 37.7389675657933 | -122.46479394281 | (37.7389675657933, -122.46479394281) | 1 | 8 | 4 | 59 | 40 | ||||
| 128274 | 213723 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 6 | Median : Yard | Tree | DPW 1 | 3 | 5993589.39355 | 2097453.93432 | 37.7388408306314 | -122.46470764836 | (37.7388408306314, -122.46470764836) | 1 | 8 | 4 | 59 | 40 | ||||
| 142227 | 213722 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 5 | Median : Yard | Tree | DPW 1 | 4 | 5993592.57964 | 2097450.02121 | 37.7388302698944 | -122.464696348358 | (37.7388302698944, -122.464696348358) | 1 | 8 | 4 | 59 | 40 | ||||
| 99174 | 213728 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x San Lorenzo Way | 13 | Median : Yard | Tree | DPW 1 | 2 | 5993678.60033 | 2097499.69771 | 37.7389716280322 | -122.464402537152 | (37.7389716280322, -122.464402537152) | 1 | 8 | 4 | 59 | 40 | ||||
| 123293 | 213726 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x San Lorenzo Way | 11 | Median : Yard | Tree | DPW 1 | 7 | 5993681.50314 | 2097480.63072 | 37.7389194421692 | -122.464391116668 | (37.7389194421692, -122.464391116668) | 1 | 8 | 4 | 59 | 40 | ||||
| 174604 | 213727 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x San Lorenzo Way | 12 | Median : Yard | Tree | DPW 1 | 4 | 5993674.25829 | 2097434.39998 | 37.7387920864908 | -122.464412810098 | (37.7387920864908, -122.464412810098) | 1 | 8 | 4 | 59 | 40 | ||||
| 188572 | 213725 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x San Lorenzo Way | 10 | Median : Yard | Tree | DPW 1 | 4 | 5993679.6596 | 2097491.88512 | 37.7389502376721 | -122.464398307632 | (37.7389502376721, -122.464398307632) | 1 | 8 | 4 | 59 | 40 | ||||
| 80871 | 46546 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 637 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2002 12:00:00 AM | Permit Number 44689 | 6009489.66445837 | 2111279.62627541 | 37.7777069157879 | -122.410707830593 | (37.7777069157879, -122.410707830593) | 8 | 2 | 9 | 28853 | 34 | |||
| 186374 | 46545 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 637 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/01/2002 12:00:00 AM | Permit Number 44689 | 6009489.66445837 | 2111279.62627541 | 37.7777069157879 | -122.410707830593 | (37.7777069157879, -122.410707830593) | 8 | 2 | 9 | 28853 | 34 | ||
| 127095 | 32222 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 623 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 15 | Permit Number 35543 | 6009718.6984 | 2100387.54672 | 37.7478125842885 | -122.40914674543 | (37.7478125842885, -122.40914674543) | 2 | 7 | 7 | 28859 | 2 | |
| 59809 | 45688 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 614 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2001 12:00:00 AM | 6 | Permit Number 44373 | 5988813.86357 | 2111116.63856 | 37.7760784619734 | -122.482219714975 | (37.7760784619734, -122.482219714975) | 11 | 6 | 2 | 55 | 26 | ||
| 97447 | 84400 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 611-613 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51577 | 5993447.66428 | 2111301.75717 | 37.7768551863663 | -122.466203752377 | (37.7768551863663, -122.466203752377) | 11 | 6 | 2 | 54 | 11 | |
| 96537 | 239010 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 60 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010651.97236 | 2100432.84922 | 37.747989214748 | -122.405922704693 | (37.747989214748, -122.405922704693) | 2 | 7 | 7 | 28859 | 2 | |||
| 138650 | 239009 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 60 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010637.01006 | 2100427.5195 | 37.7479737436878 | -122.405974068569 | (37.7479737436878, -122.405974068569) | 2 | 7 | 7 | 28859 | 2 | |||
| 42382 | 84481 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 59 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50146 | 6012081.07031 | 2095312.02235 | 37.7340083335059 | -122.40062123629 | (37.7340083335059, -122.40062123629) | 10 | 3 | 8 | 58 | 1 | |
| 22465 | 136051 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 584 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004614.40707 | 2110680.65398 | 37.7757877349621 | -122.427530336862 | (37.7757877349621, -122.427530336862) | 7 | 9 | 11 | 28852 | 10 | |||
| 135006 | 136050 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 584 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004583.8437 | 2110676.25728 | 37.7757739339551 | -122.427635749998 | (37.7757739339551, -122.427635749998) | 7 | 9 | 11 | 28852 | 10 | |||
| 132173 | 85064 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 57 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2007 12:00:00 AM | Permit Number 49430 | 6005948 | 2102270 | 37.7527694058254 | -122.422319381816 | (37.7527694058254, -122.422319381816) | 2 | 4 | 5 | 28859 | 19 | |||
| 35128 | 5454 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 561 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2009 12:00:00 AM | 3 | 8 | 6004988.38949 | 2105109.00015 | 37.7605104576133 | -122.425839954961 | (37.7605104576133, -122.425839954961) | 2 | 4 | 5 | 28859 | 19 | ||
| 142625 | 196552 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 56 Ledyard St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011678.30483 | 2094998.2948 | 37.7331244321513 | -122.401991681687 | (37.7331244321513, -122.401991681687) | 10 | 3 | 8 | 58 | 1 | |||
| 102967 | 39863 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 55 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 14 | Permit Number 41168 | 5997961.8347 | 2116210.86321 | 37.7905937153799 | -122.450942017156 | (37.7905937153799, -122.450942017156) | 11 | 6 | 1 | 54 | 31 | |
| 119804 | 136040 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 55 Laurel St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 5997963.88145 | 2116192.9912 | 37.7905447607719 | -122.450933646298 | (37.7905447607719, -122.450933646298) | 11 | 6 | 1 | 54 | 31 | |||
| 187043 | 239011 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 54 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010666.51854 | 2100440.55381 | 37.7480111833878 | -122.405872946996 | (37.7480111833878, -122.405872946996) | 2 | 7 | 7 | 28859 | 2 | |||
| 169416 | 51703 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 54 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | 3 | Permit Number 47979 | 6001520.69358 | 2121621.59135 | 37.805653247063 | -122.439016533799 | (37.805653247063, -122.439016533799) | 13 | 9 | 1 | 57 | 17 | ||
| 170138 | 239019 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 539 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004833.64681 | 2110391.58665 | 37.7750064246485 | -122.426751340518 | (37.7750064246485, -122.426751340518) | 7 | 9 | 11 | 28852 | 10 | |||
| 164743 | 119967 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 536 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5987220.23089 | 2112258.31491 | 37.7791203589842 | -122.487816341376 | (37.7791203589842, -122.487816341376) | 11 | 6 | 2 | 55 | 26 | |||
| 53920 | 33647 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 532 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | 6 | Permit Number 47617 | 6004852.49961 | 2110739.683 | 37.7759632781281 | -122.426710918693 | (37.7759632781281, -122.426710918693) | 7 | 9 | 11 | 28852 | 10 | |
| 122436 | 239021 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 530 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004598.87911 | 2110377.72269 | 37.7749550814495 | -122.427562465139 | (37.7749550814495, -122.427562465139) | 7 | 9 | 11 | 28852 | 10 | |||
| 104300 | 196537 | Planning Code 138.1 required 2 | Prunus x yedoensis :: Yoshino Cherry 77 | 526 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782869 | 6010635.96485 | 2105787.36101 | 37.7626906193079 | -122.406355282166 | (37.7626906193079, -122.406355282166) | 8 | 4 | 8 | 28859 | 19 | |
| 19717 | 47020 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 521 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 4 | Permit Number 45015 | 6004890.00739 | 2110720.29512 | 37.7759121642541 | -122.426579788542 | (37.7759121642541, -122.426579788542) | 7 | 9 | 11 | 28852 | 10 | |
| 190946 | 238580 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 519 Hickory St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6004286.86456 | 2110289.10974 | 37.7746941188733 | -122.428635472355 | (37.7746941188733, -122.428635472355) | 7 | 9 | 11 | 28852 | 10 | |||
| 43016 | 51309 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 518 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | 7 | Permit Number 47675 | 5989718.85945 | 2111803.87155 | 37.7780180115133 | -122.479139410746 | (37.7780180115133, -122.479139410746) | 11 | 6 | 2 | 55 | 26 | ||
| 116368 | 118026 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Shore View Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5984344.44515 | 2112788.18454 | 37.780407063583 | -122.49780384034 | (37.780407063583, -122.49780384034) | 11 | 6 | 2 | 55 | 26 | |||
| 120911 | 118028 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Shore View Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5984316.15967 | 2112798.24876 | 37.780433038793 | -122.49790243493 | (37.780433038793, -122.49790243493) | 11 | 6 | 2 | 55 | 26 | |||
| 29597 | 238598 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006428.46561 | 2107477.24993 | 37.7670943907258 | -122.421027537902 | (37.7670943907258, -122.421027537902) | 8 | 4 | 7 | 28853 | 19 | |||
| 46845 | 238593 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006434.12493 | 2107338.12771 | 37.7667127130356 | -122.420998084205 | (37.7667127130356, -122.420998084205) | 8 | 4 | 7 | 28853 | 19 | |||
| 121757 | 238594 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006432.46991 | 2107376.01737 | 37.7668166557888 | -122.421006499155 | (37.7668166557888, -122.421006499155) | 8 | 4 | 7 | 28853 | 19 | |||
| 162237 | 238597 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006428.61387 | 2107454.83624 | 37.7670328563946 | -122.421025433495 | (37.7670328563946, -122.421025433495) | 8 | 4 | 7 | 28853 | 19 | |||
| 188738 | 238595 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006430.43554 | 2107395.44142 | 37.7668698749586 | -122.421014915008 | (37.7668698749586, -122.421014915008) | 8 | 4 | 7 | 28853 | 19 | |||
| 189062 | 238596 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006429.49363 | 2107423.62513 | 37.7669472076635 | -122.421020174242 | (37.7669472076635, -122.421020174242) | 8 | 4 | 7 | 28853 | 19 | |||
| 94425 | 115309 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 500x Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6004961.03279 | 2110755.75124 | 37.776013533141 | -122.426336618167 | (37.776013533141, -122.426336618167) | 7 | 9 | 11 | 28852 | 10 | |||
| 174301 | 51361 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 50 Pomona St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014122.20154 | 2094470.50183 | 37.7318113167403 | -122.393505487305 | (37.7318113167403, -122.393505487305) | 10 | 3 | 8 | 58 | 1 |
| 25738 | 97483 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 50 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 3 | Permit Number 768208 | 5989920.47182 | 2114841.78 | 37.7863709666179 | -122.478664195663 | (37.7863709666179, -122.478664195663) | 11 | 6 | 1 | 55 | 33 | ||
| 122239 | 97484 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 50 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 3 | Permit Number 768208 | 5989917.9579 | 2114856.79796 | 37.7864120557494 | -122.4786739918 | (37.7864120557494, -122.4786739918) | 11 | 6 | 1 | 55 | 33 | ||
| 30391 | 239020 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 482 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004672.88732 | 2110370.92399 | 37.7749405996584 | -122.427305970394 | (37.7749405996584, -122.427305970394) | 7 | 9 | 11 | 28852 | 10 | |||
| 114927 | 196551 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 48 Ledyard St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011647.63932 | 2095039.33012 | 37.7332353949856 | -122.402100585073 | (37.7332353949856, -122.402100585073) | 10 | 3 | 8 | 58 | 1 | |||
| 184976 | 213732 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 475 Dewey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994831.427 | 2100060.8711 | 37.746070357361 | -122.460602166776 | (37.746070357361, -122.460602166776) | 1 | 8 | 4 | 59 | 40 | |||
| 22259 | 31877 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 457 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984054.95538 | 2112747.63581 | 37.7802787535999 | -122.498802308795 | (37.7802787535999, -122.498802308795) | 11 | 6 | 2 | 55 | 26 | ||
| 120741 | 31876 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 457 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984053.55944 | 2112762.76101 | 37.7803202011246 | -122.498808255642 | (37.7803202011246, -122.498808255642) | 11 | 6 | 2 | 55 | 26 | ||
| 183821 | 63200 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 450 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2015 12:00:00 AM | 3 | Permit Number 775741 | 5984716.80521 | 2112828.61382 | 37.7805398924486 | -122.496518676344 | (37.7805398924486, -122.496518676344) | 11 | 6 | 2 | 55 | 26 | |
| 76508 | 196550 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 44 Ledyard St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6011631.22474 | 2095058.90735 | 37.7332882337562 | -122.402158710982 | (37.7332882337562, -122.402158710982) | 10 | 3 | 8 | 58 | 1 | |||
| 24045 | 141370 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 430 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001204.6932 | 2110218.0701 | 37.7743241488087 | -122.439292208301 | (37.7743241488087, -122.439292208301) | 15 | 5 | 11 | 29492 | 10 | |||
| 143442 | 141371 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 430 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001203.2035 | 2110227.5052 | 37.7743499704497 | -122.439298037861 | (37.7743499704497, -122.439298037861) | 15 | 5 | 11 | 29492 | 10 | |||
| 152134 | 196553 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 43 Latona St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6014415.54504 | 2094422.50935 | 37.7316958338904 | -122.392487974535 | (37.7316958338904, -122.392487974535) | 10 | 3 | 8 | 58 | 1 | |||
| 94982 | 239017 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 420 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004649.23928 | 2110026.77374 | 37.7739943096302 | -122.427363252712 | (37.7739943096302, -122.427363252712) | 7 | 9 | 11 | 28852 | 10 | |||
| 183526 | 239018 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 420 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004647.99887 | 2110037.75326 | 37.7740243865621 | -122.427368325805 | (37.7740243865621, -122.427368325805) | 7 | 9 | 11 | 28852 | 10 | |||
| 146029 | 98235 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 42 19th Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 01/09/2012 12:00:00 AM | 3 | Permit Number 768620 | 5989920.54745 | 2114876.26257 | 37.7864656504451 | -122.47866645673 | (37.7864656504451, -122.47866645673) | 11 | 6 | 1 | 55 | 33 | ||
| 107927 | 239012 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 417 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009194 | 2100253 | 37.7474137401608 | -122.410951632147 | (37.7474137401608, -122.410951632147) | 2 | 7 | 7 | 28859 | 2 | |||
| 146323 | 238579 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 415 Buchanan St | 1 | : | Tree | Private 2 | 7 | Width 6ft | 6004609.7624 | 2109940.50049 | 37.7737551915801 | -122.427493662508 | (37.7737551915801, -122.427493662508) | 7 | 9 | 11 | 28852 | 10 | |||
| 174611 | 239023 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 4093 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003318.18687 | 2100656.24769 | 37.7481897266866 | -122.431298564594 | (37.7481897266866, -122.431298564594) | 2 | 4 | 5 | 63 | 22 | |||
| 31602 | 196549 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 40 Ledyard St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6011616.35938 | 2095078.64568 | 37.7333416013201 | -122.402211492182 | (37.7333416013201, -122.402211492182) | 10 | 3 | 8 | 58 | 1 | |||
| 147344 | 239016 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 399 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004681.24572 | 2110023.15394 | 37.773986180653 | -122.427252279074 | (37.773986180653, -122.427252279074) | 7 | 9 | 11 | 28852 | 10 | |||
| 136463 | 213720 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 398 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992203.97011 | 2094317.89279 | 37.7301500773614 | -122.469269557468 | (37.7301500773614, -122.469269557468) | 9 | 8 | 4 | 59 | 40 | |||
| 165707 | 4211 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3935 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004300.14403 | 2100415.02402 | 37.7475829828864 | -122.427885801087 | (37.7475829828864, -122.427885801087) | 2 | 4 | 5 | 63 | 22 | |||
| 60025 | 124684 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3899 Jackson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5995566.4285 | 2115772.64492 | 37.7892530636592 | -122.459198183151 | (37.7892530636592, -122.459198183151) | 11 | 6 | 1 | 54 | 31 | |||
| 63795 | 124683 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3899 Jackson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5995553.12452 | 2115771.60073 | 37.7892494317403 | -122.459244137371 | (37.7892494317403, -122.459244137371) | 11 | 6 | 1 | 54 | 31 | |||
| 113704 | 239024 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 389 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004038.85397 | 2100110.5602 | 37.7467322107326 | -122.428767625048 | (37.7467322107326, -122.428767625048) | 2 | 7 | 5 | 63 | 22 | |||
| 70362 | 4175 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3812X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6005112.58146 | 2100504.28147 | 37.7478739908906 | -122.425082788743 | (37.7478739908906, -122.425082788743) | 2 | 4 | 5 | 63 | 22 | ||
| 116083 | 239015 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 380 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004736.9455 | 2110029.27372 | 37.7740061339081 | -122.427060040012 | (37.7740061339081, -122.427060040012) | 7 | 9 | 11 | 28852 | 10 | |||
| 174055 | 4162 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3754 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2011 12:00:00 AM | 3 | 3X3 | 6005539.04385 | 2100528.63943 | 37.7479649537167 | -122.423609831438 | (37.7479649537167, -122.423609831438) | 2 | 4 | 5 | 28859 | 19 |
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) );