trees
2,694 rows where qSpecies_id = 84 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46174 | 244365 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 301 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005511.8056 | 2110439.7613 | 37.7751770191286 | -122.424408867351 | (37.7751770191286, -122.424408867351) | 7 | 9 | 11 | 28852 | 10 | |||
48105 | 142263 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 585 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004612.4683 | 2110683.7571 | 37.7757961457109 | -122.427537264685 | (37.7757961457109, -122.427537264685) | 7 | 9 | 11 | 28852 | 10 | |||
48774 | 119805 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
49694 | 119841 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 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 | ||||
51800 | 91186 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 291 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 2 | 6x9 | Permit Number 52039 | 6005173 | 2109884 | 37.7736318955877 | -122.425541311156 | (37.7736318955877, -122.425541311156) | 7 | 9 | 11 | 28852 | 10 | |
52301 | 107755 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
52758 | 47013 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 445 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | Permit Number 47268 | 6004844.28922352 | 2110353.57072253 | 37.7749026438811 | -122.426711818296 | (37.7749026438811, -122.426711818296) | 7 | 9 | 11 | 28852 | 10 | ||
54224 | 119853 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 401 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 | ||||
54629 | 66372 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 426 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 29496 | 6003710.25290475 | 2109797.53880085 | 37.7733117365244 | -122.430595003889 | (37.7733117365244, -122.430595003889) | 7 | 9 | 11 | 29492 | 10 | ||
54663 | 110552 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
54888 | 33703 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 196 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1996 12:00:00 AM | Permit Number 37772 | 6003356.08500561 | 2108810.32684763 | 37.7705810245056 | -122.431749619478 | (37.7705810245056, -122.431749619478) | 15 | 9 | 11 | 29492 | 10 | ||
55324 | 138925 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005461.4768 | 2110789.2454 | 37.7761337753876 | -122.424607831994 | (37.7761337753876, -122.424607831994) | 7 | 9 | 11 | 28852 | 10 | |||
55977 | 119812 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
56426 | 244956 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 298 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6005155.9394 | 2109820.0209 | 37.77345526051 | -122.42559577205 | (37.77345526051, -122.42559577205) | 7 | 9 | 11 | 28852 | 10 | |||
58002 | 119858 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 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 | ||||
58451 | 110547 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
58652 | 31299 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 519 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 8 | Permit Number 34943 | 6005251.2106 | 2111468.7266 | 37.777987587802 | -122.425383565241 | (37.777987587802, -122.425383565241) | 7 | 9 | 11 | 28852 | 10 | |
60080 | 67238 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 130 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 30702 | 6003839.32811404 | 2108856.20223017 | 37.7707343678804 | -122.430081350049 | (37.7707343678804, -122.430081350049) | 7 | 9 | 11 | 29492 | 10 | ||
60687 | 42765 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 5 | 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 | |||
61525 | 46331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 201 Lily St | 2 | 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 | ||
61618 | 244350 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2017 07:22:00 AM | 3 | Width 0ft | 6005619.219 | 2110418.7508 | 37.7751253943864 | -122.424035805431 | (37.7751253943864, -122.424035805431) | 7 | 9 | 11 | 28852 | 10 | ||
64335 | 138975 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 461 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005450.5842 | 2110864.9202 | 37.7763409448097 | -122.42465089693 | (37.7763409448097, -122.42465089693) | 7 | 9 | 11 | 28852 | 10 | |||
65404 | 46332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 201 Lily St | 1 | 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 | ||
68060 | 31301 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 529 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 8 | Permit Number 34944 | 6005236.8177 | 2111465.8481 | 37.7779788709631 | -122.425433150534 | (37.7779788709631, -122.425433150534) | 7 | 9 | 11 | 28852 | 10 | |
68068 | 44186 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 792 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45643 | 6004083.1428 | 2110821.1912 | 37.7761435523821 | -122.429378138275 | (37.7761435523821, -122.429378138275) | 7 | 9 | 11 | 28852 | 10 |
69433 | 107757 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
70233 | 139392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 466 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005058.4753 | 2111113.4947 | 37.7770013168736 | -122.426025011181 | (37.7770013168736, -122.426025011181) | 7 | 9 | 11 | 28852 | 10 | |||
70239 | 142454 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 537 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004825.882 | 2110712.4694 | 37.7758870513166 | -122.426801057519 | (37.7758870513166, -122.426801057519) | 7 | 9 | 11 | 28852 | 10 | |||
70643 | 244389 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 250 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005653.9696 | 2110171.6272 | 37.7744488147211 | -122.42389801886 | (37.7744488147211, -122.42389801886) | 7 | 9 | 11 | 28852 | 10 | |||
70667 | 115688 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 150X Octavia St Frontage East | 2 | 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 | ||||
71027 | 43003 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 205X Rose St | 8 | 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 | |||
71162 | 256523 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6005231.3024 | 2109750.7356 | 37.7732692779132 | -122.425330148953 | (37.7732692779132, -122.425330148953) | 7 | 9 | 11 | 28852 | 10 | ||||
71737 | 138874 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 OCTAVIA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005562.0898 | 2110802.7178 | 37.7761764489655 | -122.424260742604 | (37.7761764489655, -122.424260742604) | 7 | 9 | 11 | 28852 | 10 | |||
71882 | 244992 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 249 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005441.5895 | 2109754.3822 | 37.7732911688522 | -122.424602996105 | (37.7732911688522, -122.424602996105) | 7 | 9 | 11 | 28852 | 10 | |||
72864 | 244352 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005613.5532 | 2110456.5225 | 37.7752287864343 | -122.424058091407 | (37.7752287864343, -122.424058091407) | 7 | 9 | 11 | 28852 | 10 | |||
72883 | 30735 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 281 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 6 | Permit Number 34629 | 6005260 | 2109713 | 37.7731672863676 | -122.42522819429 | (37.7731672863676, -122.42522819429) | 7 | 9 | 11 | 28852 | 10 | |
73713 | 244366 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 301 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005514.1663 | 2110403.406 | 37.7750773296011 | -122.424398114747 | (37.7750773296011, -122.424398114747) | 7 | 9 | 11 | 28852 | 10 | |||
74205 | 104126 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1330 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 8x6 | Permit Number 770527 | 6001460.4923 | 2110454.7269 | 37.774988502255 | -122.438424312648 | (37.774988502255, -122.438424312648) | 15 | 5 | 11 | 29492 | 10 | ||
74267 | 31302 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 529 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 9 | Permit Number 34944 | 6005223.0006 | 2111465.2723 | 37.7779765092875 | -122.425480907835 | (37.7779765092875, -122.425480907835) | 7 | 9 | 11 | 28852 | 10 | |
74848 | 139395 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 486 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005025.4278 | 2111110.8954 | 37.7769923120329 | -122.426139147688 | (37.7769923120329, -122.426139147688) | 7 | 9 | 11 | 28852 | 10 | |||
74948 | 42761 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 8 | 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 | |||
75128 | 244991 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 213 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005531.8427 | 2110116.9147 | 37.7742916920696 | -122.424316587333 | (37.7742916920696, -122.424316587333) | 7 | 9 | 11 | 28852 | 10 | |||
75976 | 119596 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005470 | 2110737 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | 7 | 9 | 11 | 28852 | 10 | ||||
76471 | 244994 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 231 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 4 | Width 0ft | Permit Number 45013 | 6005396.3109 | 2110099.8972 | 37.7742373121563 | -122.4247842062 | (37.7742373121563, -122.4247842062) | 7 | 9 | 11 | 28852 | 10 | |
77446 | 119877 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 450X 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 | ||||
77588 | 42997 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 438 Lily St | 2 | 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 | ||
78073 | 33620 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 426 Lily St | 1 | 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 | ||
78677 | 120638 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 538 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6000640.47849283 | 2110797.5063283 | 37.7758830107493 | -122.441285509617 | (37.7758830107493, -122.441285509617) | 15 | 5 | 11 | 29492 | 10 | |||
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 | ||||
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 | ||||
93372 | 140211 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 519 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004017.0107 | 2110696.0316 | 37.7757961506144 | -122.429597978666 | (37.7757961506144, -122.429597978666) | 7 | 9 | 11 | 29492 | 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 | ||||
97416 | 88736 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 201 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51670 | 6004164.8 | 2109541.2 | 37.7726336328898 | -122.429004383201 | (37.7726336328898, -122.429004383201) | 7 | 9 | 11 | 29492 | 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 | |||
101945 | 244515 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 426 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003699.3803 | 2109847.5959 | 37.7734485650794 | -122.430636186348 | (37.7734485650794, -122.430636186348) | 7 | 9 | 11 | 29492 | 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 | |||
107413 | 247372 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 475 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002162.1125 | 2110097.0889 | 37.7740464011597 | -122.43597166463 | (37.7740464011597, -122.43597166463) | 15 | 5 | 11 | 29492 | 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 | ||
117106 | 244518 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 531 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003993.7068 | 2109716.5376 | 37.7731053809378 | -122.429608719922 | (37.7731053809378, -122.429608719922) | 7 | 9 | 11 | 29492 | 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 |
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) );