trees
2,694 rows where qSpecies_id = 84 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78849 | 244320 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 331 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005500.9462 | 2110499.2518 | 37.775339752374 | -122.424450664906 | (37.775339752374, -122.424450664906) | 7 | 9 | 11 | 28852 | 10 | |||
78970 | 119804 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
79472 | 111917 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 150X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.423745644927 | (37.7736761836422, -122.423745644927) | 7 | 9 | 11 | 28852 | 10 | ||||
79941 | 244925 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 223 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005441.8933 | 2110105.3671 | 37.77425490559 | -122.424626917474 | (37.77425490559, -122.424626917474) | 7 | 9 | 11 | 28852 | 10 | |||
80213 | 142262 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 595 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004599.612 | 2110681.6144 | 37.7757895352037 | -122.427581585207 | (37.7757895352037, -122.427581585207) | 7 | 9 | 11 | 28852 | 10 | |||
80467 | 139396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 496 Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005003.1486 | 2111107.1822 | 37.7769808572422 | -122.426215953949 | (37.7769808572422, -122.426215953949) | 7 | 9 | 11 | 28852 | 10 | |||
82594 | 42764 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
83183 | 119809 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
84863 | 109157 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2016 12:00:00 AM | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | |||
86497 | 119598 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 401x Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005458 | 2110677 | 37.7758253804544 | -122.424611872791 | (37.7758253804544, -122.424611872791) | 7 | 9 | 11 | 28852 | 10 | ||||
88357 | 8090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004349.2473 | 2111557.1689 | 37.7781794280627 | -122.428510082803 | (37.7781794280627, -122.428510082803) | 7 | 9 | 11 | 28852 | 41 | ||
90473 | 138872 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 OCTAVIA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005567.8228 | 2110765.4538 | 37.7760744547885 | -122.424238259715 | (37.7760744547885, -122.424238259715) | 7 | 9 | 11 | 28852 | 10 | |||
91155 | 109160 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
91399 | 139389 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 432 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005549.1907 | 2110899.3178 | 37.7764409607239 | -122.424312236277 | (37.7764409607239, -122.424312236277) | 7 | 9 | 11 | 28852 | 10 | |||
92692 | 119851 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 331 Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
93329 | 109161 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
94698 | 107754 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
95194 | 139388 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 432 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005550.9106 | 2110887.2787 | 37.7764080013995 | -122.424305430186 | (37.7764080013995, -122.424305430186) | 7 | 9 | 11 | 28852 | 10 | |||
95577 | 119850 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 331 Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
95754 | 138977 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Octavia St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005455.7439 | 2110835.1089 | 37.7762593816337 | -122.424630926935 | (37.7762593816337, -122.424630926935) | 7 | 9 | 11 | 28852 | 10 | |||
95996 | 88729 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 260 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51664 | 6005332 | 2109792.9 | 37.7733907397046 | -122.424984822508 | (37.7733907397046, -122.424984822508) | 7 | 9 | 11 | 28852 | 10 | ||
96477 | 119870 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
96776 | 110544 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
97547 | 244990 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 215 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005497.2001 | 2110113.2681 | 37.7742797231705 | -122.424436163123 | (37.7742797231705, -122.424436163123) | 7 | 9 | 11 | 28852 | 10 | |||
99977 | 119872 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
100482 | 115686 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
101572 | 115455 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
101843 | 142243 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 530 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004841.3136 | 2110737.0993 | 37.7759555514889 | -122.426749430003 | (37.7759555514889, -122.426749430003) | 7 | 9 | 11 | 28852 | 10 | |||
103386 | 42762 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
104251 | 43005 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 205X Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
106124 | 119863 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
106625 | 33657 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 595 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37745 | 6004567.28962624 | 2110660.7642941 | 37.7757304576278 | -122.427691910628 | (37.7757304576278, -122.427691910628) | 7 | 9 | 11 | 28852 | 10 | |||
106905 | 42996 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 438 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42872 | 6004509.83171755 | 2110011.27832833 | 37.7739438776611 | -122.427844382866 | (37.7739438776611, -122.427844382866) | 7 | 9 | 11 | 28852 | 10 | ||
107307 | 138955 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 721 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004476.9169 | 2110918.2976 | 37.7764324685086 | -122.428022888756 | (37.7764324685086, -122.428022888756) | 7 | 9 | 11 | 28852 | 10 | |||
108069 | 244238 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 255 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005544.2422 | 2110192.8239 | 37.7745008205043 | -122.424279095113 | (37.7745008205043, -122.424279095113) | 7 | 9 | 11 | 28852 | 10 | |||
108779 | 139394 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 486 Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005015.0309 | 2111107.9249 | 37.7769835681253 | -122.426174902271 | (37.7769835681253, -122.426174902271) | 7 | 9 | 11 | 28852 | 10 | |||
110506 | 244240 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005550.0678 | 2110158.7025 | 37.7744074603478 | -122.424256515939 | (37.7744074603478, -122.424256515939) | 7 | 9 | 11 | 28852 | 10 | |||
110647 | 244987 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2018 12:00:00 AM | 3 | Width 0ft | 6005231.3024 | 2109750.7356 | 37.7732692779132 | -122.425330148953 | (37.7732692779132, -122.425330148953) | 7 | 9 | 11 | 28852 | 10 | ||
111647 | 119864 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
112713 | 138976 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 459 Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005452.3041 | 2110848.868 | 37.7762969665081 | -122.424643805155 | (37.7762969665081, -122.424643805155) | 7 | 9 | 11 | 28852 | 10 | |||
113458 | 119856 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
114577 | 119876 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 450X Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
114764 | 119597 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005470 | 2110737 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | 7 | 9 | 11 | 28852 | 10 | ||||
116692 | 119843 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
117033 | 33616 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 426 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 37725 | 6004541.83388077 | 2110015.73229407 | 37.7739579174854 | -122.427733999418 | (37.7739579174854, -122.427733999418) | 7 | 9 | 11 | 28852 | 10 | ||
119721 | 138932 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 724 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004510.895 | 2110993.3253 | 37.7766403984333 | -122.427910696353 | (37.7766403984333, -122.427910696353) | 7 | 9 | 11 | 28852 | 10 | |||
119743 | 103650 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 307X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |
124309 | 244989 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 217 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005482.6137 | 2110109.6215 | 37.7742688867804 | -122.424486360759 | (37.7742688867804, -122.424486360759) | 7 | 9 | 11 | 28852 | 10 | |||
125930 | 110546 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
129368 | 244253 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005660.0799 | 2110124.2725 | 37.7743191351223 | -122.423873514167 | (37.7743191351223, -122.423873514167) | 7 | 9 | 11 | 28852 | 10 | |||
130165 | 119873 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
132038 | 33656 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 595 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37745 | 6004567.28962624 | 2110660.7642941 | 37.7757304576278 | -122.427691910628 | (37.7757304576278, -122.427691910628) | 7 | 9 | 11 | 28852 | 10 | |||
133200 | 114733 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 435 LILY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2x2 | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | ||||
135861 | 109155 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2016 12:00:00 AM | 6 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||
136511 | 110551 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
136692 | 88730 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 260 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51664 | 6005332 | 2109792.9 | 37.7733907397046 | -122.424984822508 | (37.7733907397046, -122.424984822508) | 7 | 9 | 11 | 28852 | 10 | ||
137979 | 138981 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005467.783 | 2110751.9814 | 37.7760318136474 | -122.42458336579 | (37.7760318136474, -122.42458336579) | 7 | 9 | 11 | 28852 | 10 | |||
138897 | 110545 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
142831 | 115456 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
143992 | 12253 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 528 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2003 12:00:00 AM | 6 | 3x3 | 6005030.2517 | 2110722.9994 | 37.7759275170107 | -122.426094839447 | (37.7759275170107, -122.426094839447) | 7 | 9 | 11 | 28852 | 10 | ||
145615 | 138849 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 650x WEBSTER ST | 1 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6004012.6112 | 2111066.8822 | 37.7768141659098 | -122.429639652936 | (37.7768141659098, -122.429639652936) | 7 | 9 | 11 | 28852 | 10 | |||
147093 | 142241 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 500 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004960.5581 | 2110752.4077 | 37.7760043257642 | -122.426338022136 | (37.7760043257642, -122.426338022136) | 7 | 9 | 11 | 28852 | 10 | |||
147302 | 35168 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 74 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51674 | 6004316.89156048 | 2108922.37247915 | 37.7709430910195 | -122.428434166598 | (37.7709430910195, -122.428434166598) | 7 | 9 | 11 | 28852 | 10 | ||
148419 | 119852 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 331 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
149513 | 115687 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
150011 | 138974 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 469 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005448.291 | 2110883.8389 | 37.7763927614438 | -122.424660175882 | (37.7763927614438, -122.424660175882) | 7 | 9 | 11 | 28852 | 10 | |||
150078 | 32139 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 618 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.427699936535 | (37.7756480927458, -122.427699936535) | 7 | 9 | 11 | 28852 | 10 | |||
151220 | 119720 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 150X Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.423745644927 | (37.7736761836422, -122.423745644927) | 7 | 9 | 11 | 28852 | 10 | ||||
151732 | 138871 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005570.116 | 2110750.5481 | 37.7760336568414 | -122.42422926657 | (37.7760336568414, -122.42422926657) | 7 | 9 | 11 | 28852 | 10 | |||
152074 | 42759 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
154328 | 119874 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 450X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
154465 | 114736 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 435 LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2x2 | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | ||||
155795 | 119875 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 450X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
156655 | 142258 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 545 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004771.8857 | 2110705.1842 | 37.7758639948557 | -122.426987325719 | (37.7758639948557, -122.426987325719) | 7 | 9 | 11 | 28852 | 10 | |||
160891 | 116695 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 535 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6004831 | 2110695 | 37.7758393739821 | -122.426782108664 | (37.7758393739821, -122.426782108664) | 7 | 9 | 11 | 28852 | 10 | ||||
161498 | 103649 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 307X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005304.8 | 2110365.7 | 37.7749619731115 | -122.425119675916 | (37.7749619731115, -122.425119675916) | 7 | 9 | 11 | 28852 | 10 | |
165220 | 138982 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 429 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005468.9296 | 2110741.6621 | 37.7760035441121 | -122.424578665176 | (37.7760035441121, -122.424578665176) | 7 | 9 | 11 | 28852 | 10 | |||
165374 | 109158 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | |||
165948 | 46333 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 201 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2002 12:00:00 AM | Permit Number 44582 | 6005568.06039934 | 2110039.04677053 | 37.7740799306106 | -122.424185764506 | (37.7740799306106, -122.424185764506) | 7 | 9 | 11 | 28852 | 10 | ||
167501 | 139393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 476 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005043.2512 | 2111112.0094 | 37.7769963781719 | -122.426077570324 | (37.7769963781719, -122.426077570324) | 7 | 9 | 11 | 28852 | 10 | |||
168475 | 8092 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004291.3267 | 2111546.8391 | 37.778147787093 | -122.428709714706 | (37.778147787093, -122.428709714706) | 7 | 9 | 11 | 28852 | 41 | ||
169262 | 31303 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 535 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005167.7319 | 2111457.2123 | 37.7779512556108 | -122.425671528209 | (37.7779512556108, -122.425671528209) | 7 | 9 | 11 | 28852 | 10 | |
169317 | 110548 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
169343 | 109156 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2015 01:49:00 PM | 3 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||
171091 | 110543 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
176367 | 244298 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005605.7628 | 2110511.5277 | 37.7753793775331 | -122.424088952775 | (37.7753793775331, -122.424088952775) | 7 | 9 | 11 | 28852 | 10 | |||
177813 | 106891 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400x LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | |||||
178326 | 65946 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 556 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 2 | Permit Number 28967 | 6007598.7781 | 2113267.2525 | 37.7830582599109 | -122.417389964837 | (37.7830582599109, -122.417389964837) | 7 | 9 | 9 | 28852 | 36 | |
180626 | 105143 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 432 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | DPW for City Agency | 3 | 4x4 | 6005556.0703 | 2110851.1612 | 37.7763091228737 | -122.424285011933 | (37.7763091228737, -122.424285011933) | 7 | 9 | 11 | 28852 | 10 | ||
180697 | 119811 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
181373 | 115685 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
181761 | 32140 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 618 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.427699936535 | (37.7756480927458, -122.427699936535) | 7 | 9 | 11 | 28852 | 10 | |||
184002 | 139387 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 432 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005553.2038 | 2110871.2264 | 37.7763640551752 | -122.424296355394 | (37.7763640551752, -122.424296355394) | 7 | 9 | 11 | 28852 | 10 | |||
185160 | 8091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004317.1512 | 2111553.1108 | 37.7781664691559 | -122.428620825565 | (37.7781664691559, -122.428620825565) | 7 | 9 | 11 | 28852 | 41 | ||
187384 | 42788 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 426 -28 - 30 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42755 | 6004546 | 2110000 | 37.7739149561089 | -122.427718466962 | (37.7739149561089, -122.427718466962) | 7 | 9 | 11 | 28852 | 10 | ||
188339 | 42760 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
190086 | 119844 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
190616 | 32149 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 131 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35500 | 6006458.85096741 | 2110609.91009121 | 37.7756976404314 | -122.421144903557 | (37.7756976404314, -122.421144903557) | 7 | 9 | 11 | 28852 | 10 | ||
190677 | 244969 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 215 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005489.603 | 2109760.4598 | 37.7733105679298 | -122.424437343055 | (37.7733105679298, -122.424437343055) | 7 | 9 | 11 | 28852 | 10 | |||
191780 | 31304 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 535 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005195.9419 | 2111461.818 | 37.7779654957454 | -122.425574267643 | (37.7779654957454, -122.425574267643) | 7 | 9 | 11 | 28852 | 10 |
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) );