trees
2,694 rows where qSpecies_id = 84 sorted by SiteOrder
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2238 | 88648 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 74 Carmelita St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51628 | 6002619 | 2108775 | 37.7704422164895 | -122.434296675208 | (37.7704422164895, -122.434296675208) | 15 | 5 | 5 | 29492 | 9 | |||
18166 | 88091 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1619 39th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51095 | 5984024.3 | 2104125.3 | 37.756602478656 | -122.498271356488 | (37.756602478656, -122.498271356488) | 1 | 8 | 3 | 56 | 35 | |||
22987 | 88225 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2084 Hayes St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51221 | 5997896.9 | 2109991 | 37.7735118836843 | -122.450718045928 | (37.7735118836843, -122.450718045928) | 15 | 5 | 11 | 29492 | 16 | |||
29518 | 88278 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Aptos Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062 | 2093861.6 | 37.7289467548913 | -122.466270114229 | (37.7289467548913, -122.466270114229) | 9 | 8 | 4 | 59 | 40 | |||
39053 | 96460 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
40777 | 96459 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
40860 | 88235 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 329 Lyon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51224 | 6000219 | 2110006 | 37.7736857166247 | -122.44268666247 | (37.7736857166247, -122.44268666247) | 15 | 5 | 11 | 29492 | 16 | |||
42192 | 88277 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Aptos Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062 | 2093861.6 | 37.7289467548913 | -122.466270114229 | (37.7289467548913, -122.466270114229) | 9 | 8 | 4 | 59 | 40 | |||
53403 | 88223 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2442 Fulton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51219 | 5996404 | 2110432 | 37.7746371856421 | -122.455914062335 | (37.7746371856421, -122.455914062335) | 11 | 5 | 2 | 54 | 16 | |||
56370 | 88522 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 10 Valdez Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417 | 2093827.6 | 37.7290464055545 | -122.454669245202 | (37.7290464055545, -122.454669245202) | 9 | 7 | 4 | 28861 | 40 | |||
65089 | 88093 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1726 39th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51097 | 5984135 | 2103400.2 | 37.7546180463975 | -122.497834981734 | (37.7546180463975, -122.497834981734) | 1 | 8 | 3 | 56 | 35 | |||
74566 | 96463 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
80400 | 88253 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1025 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131 | 2106547 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | 15 | 5 | 11 | 29492 | 9 | |||
84536 | 89293 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1353 26th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2008 12:00:00 AM | 3x3 | Permit Number 51899 | 5987992.1 | 2106076.8 | 37.7621926272889 | -122.484692595652 | (37.7621926272889, -122.484692595652) | 1 | 8 | 3 | 56 | 35 | |||
93879 | 88359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1443 12th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51337 | 5992382.4 | 2105622.1 | 37.7611988469011 | -122.469475253221 | (37.7611988469011, -122.469475253221) | 1 | 8 | 4 | 56 | 12 | |||
97873 | 96462 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
103519 | 87844 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 536 28th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50751 | 5987246 | 2112270.7 | 37.7791558680057 | -122.487728106826 | (37.7791558680057, -122.487728106826) | 11 | 6 | 2 | 55 | 26 | |||
107640 | 88260 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 123 Corbett Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51245 | 6000668.3 | 2105609.4 | 37.7616393503242 | -122.440817021394 | (37.7616393503242, -122.440817021394) | 15 | 5 | 5 | 28862 | 3 | |||
112478 | 88731 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 248 Scott St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51665 | 6002314 | 2109330 | 37.771948792814 | -122.435391376972 | (37.771948792814, -122.435391376972) | 15 | 5 | 11 | 29492 | 9 | |||
133113 | 96461 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
133116 | 88226 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2108 Hayes St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802 | 2109918 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | 15 | 5 | 11 | 29492 | 16 | |||
162155 | 88594 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 298 Divisadero St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51540 | 6001881 | 2109400.2 | 37.7721169442044 | -122.436894179858 | (37.7721169442044, -122.436894179858) | 15 | 5 | 11 | 29492 | 9 | |||
164374 | 88189 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 123 Dore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51194 | 6009069 | 2109644 | 37.7731922763614 | -122.412047438663 | (37.7731922763614, -122.412047438663) | 8 | 2 | 9 | 28853 | 34 | |||
166247 | 89001 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 212 Maynard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2008 12:00:00 AM | 3x3 | Permit Number 51753 | 6004786 | 2093771 | 37.7293674698939 | -122.425732914897 | (37.7293674698939, -122.425732914897) | 9 | 7 | 6 | 28861 | 5 | |||
170456 | 88131 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 525 Jersey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51155 | 6001754 | 2101449 | 37.7502776664916 | -122.436764203777 | (37.7502776664916, -122.436764203777) | 2 | 4 | 5 | 28862 | 22 | |||
176732 | 88505 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 140 Colon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51443 | 5996179.5 | 2093971.6 | 37.7294281696535 | -122.455500699897 | (37.7294281696535, -122.455500699897) | 9 | 7 | 4 | 28861 | 40 | |||
339 | 18096 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3008 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/1997 12:00:00 AM | 6 | 3X3 | 5999424.6928 | 2114682.6521 | 37.7864812852303 | -122.445770680231 | (37.7864812852303, -122.445770680231) | 15 | 6 | 1 | 29490 | 31 | ||
340 | 42995 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 436 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42871 | 6004515.16540478 | 2110012.02065503 | 37.7739462176361 | -122.42782598565 | (37.7739462176361, -122.42782598565) | 7 | 9 | 11 | 28852 | 10 | ||
523 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | 1 | 8 | 3 | 29491 | 35 | ||
655 | 73536 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2270 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987645.1852 | 2099831.4757 | 37.7450244421871 | -122.485434109471 | (37.7450244421871, -122.485434109471) | 1 | 8 | 3 | 29491 | 35 | |||
940 | 71166 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2123 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988191.5983 | 2100838.0598 | 37.747820074212 | -122.483618518196 | (37.747820074212, -122.483618518196) | 1 | 8 | 3 | 29491 | 35 | |||
1003 | 72752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988097.7754 | 2104798.077 | 37.758687755803 | -122.484233325891 | (37.758687755803, -122.484233325891) | 1 | 8 | 3 | 56 | 35 | |||
1474 | 86100 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2628 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988972.7801 | 2097431.8111 | 37.738512846905 | -122.480667939289 | (37.738512846905, -122.480667939289) | 1 | 8 | 3 | 29491 | 35 | ||
1475 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.491255586179 | (37.735588983385, -122.491255586179) | 1 | 8 | 3 | 64 | 35 | |||
1659 | 65957 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2451 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 6 | Permit Number 28979 | 5987645.5214 | 2098612.1125 | 37.7416764134378 | -122.485343487905 | (37.7416764134378, -122.485343487905) | 1 | 8 | 3 | 29491 | 35 | ||
1668 | 86560 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.485018839299 | (37.7522790893532, -122.485018839299) | 1 | 8 | 3 | 56 | 35 | ||
1745 | 72898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2476 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5990180.6745 | 2098530.744 | 37.7416003626627 | -122.476571927541 | (37.7416003626627, -122.476571927541) | 1 | 8 | 3 | 29491 | 35 | |||
1818 | 38898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 127 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 1 | Permit Number 40712 | 5996846.0934 | 2113584.1977 | 37.7833176557587 | -122.454612555673 | (37.7833176557587, -122.454612555673) | 11 | 6 | 1 | 54 | 31 | |
1869 | 71210 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2263 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988533.228 | 2099925.3582 | 37.7453339163785 | -122.482370330567 | (37.7453339163785, -122.482370330567) | 1 | 8 | 3 | 29491 | 35 | |||
2005 | 23894 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1581 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:37:00 AM | 3 | 3X3 | 6003529.5219 | 2114142.2135 | 37.7852308919409 | -122.431530405312 | (37.7852308919409, -122.431530405312) | 13 | 9 | 11 | 29490 | 13 | ||
2074 | 64926 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2340 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25954 | 5991486.3095246 | 2099579.02126823 | 37.7445543038697 | -122.472133919026 | (37.7445543038697, -122.472133919026) | 1 | 8 | 4 | 29491 | 40 | ||
2221 | 238015 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 77 Ashbury Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5999599.38464 | 2106733.87641 | 37.7646659486903 | -122.444594775755 | (37.7646659486903, -122.444594775755) | 15 | 5 | 5 | 29492 | 9 | |||
2384 | 61000 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 569 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | 3x3 | Permit Number 20813 | 6003055.65980298 | 2095965.62236934 | 37.7352954735478 | -122.43187149765 | (37.7352954735478, -122.43187149765) | 2 | 7 | 5 | 63 | 7 | |
2537 | 245955 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 450 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997557.5774 | 2107478.8878 | 37.7665948394439 | -122.45171055689 | (37.7665948394439, -122.45171055689) | 15 | 5 | 11 | 29492 | 9 | |||
2833 | 47893 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 745 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 6 | Permit Number 48331 | 6000477.4696 | 2111570.4889 | 37.7779961374161 | -122.441904890309 | (37.7779961374161, -122.441904890309) | 15 | 5 | 11 | 29490 | 16 | |
3071 | 31851 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
3161 | 68640 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1843 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32545 | 5990599.2738678 | 2102847.22998444 | 37.7534765784204 | -122.475439654249 | (37.7534765784204, -122.475439654249) | 1 | 8 | 4 | 56 | 12 | ||
3201 | 52387 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 136 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48512 | 6005694.4540201 | 2096630.70014958 | 37.7372708656751 | -122.422795452389 | (37.7372708656751, -122.422795452389) | 2 | 7 | 7 | 28859 | 2 | ||
3508 | 95024 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | 9 | 7 | 8 | 309 | 39 | |||
3526 | 65715 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 735 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1996 12:00:00 AM | Permit Number 28647 | 6009189.05467178 | 2115445.35577198 | 37.7891281538301 | -122.412042214215 | (37.7891281538301, -122.412042214215) | 5 | 1 | 10 | 28858 | 21 | ||
3665 | 261403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 746 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010031.95335 | 2118510.77151 | 37.797592298166 | -122.409342294069 | (37.797592298166, -122.409342294069) | 3 | 1 | 10 | 308 | 4 | |||||
3715 | 137933 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 23 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003135 | 2115313 | 37.788423206128 | -122.432979003927 | (37.788423206128, -122.432979003927) | 13 | 9 | 1 | 29490 | 27 | |||
3967 | 72444 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1733 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5999558.0145 | 2110143.3213 | 37.7740250637938 | -122.444982979337 | (37.7740250637938, -122.444982979337) | 15 | 5 | 11 | 29492 | 16 | |||
3995 | 59121 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 572 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2013 12:00:00 AM | Permit Number 770918 | 5992864.66737091 | 2111571.53492594 | 37.7775622694604 | -122.46824012776 | (37.7775622694604, -122.46824012776) | 11 | 6 | 2 | 54 | 11 | |||
4251 | 42457 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 571 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 9 | 3x3 | Permit Number 42600 | 5997658.92569742 | 2095237.95802388 | 37.7329900693173 | -122.450477464919 | (37.7329900693173, -122.450477464919) | 9 | 7 | 4 | 59 | 40 |
4346 | 32173 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
4426 | 42126 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42422 | 5999645.50083885 | 2093804.90397788 | 37.7291687386678 | -122.44350647351 | (37.7291687386678, -122.44350647351) | 9 | 7 | 4 | 63 | 40 | ||
4516 | 259272 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1705 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/2019 12:00:00 AM | 3 | 6009597.7323 | 2119503.87292 | 37.8002947722719 | -122.410914999374 | (37.8002947722719, -122.410914999374) | 3 | 1 | 10 | 308 | 4 | |||
4734 | 63548 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 942 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | 10 | Permit Number 24164 | 5999530.709 | 2111776.0946 | 37.7785066833069 | -122.445194846179 | (37.7785066833069, -122.445194846179) | 15 | 5 | 11 | 29490 | 16 | |
4762 | 84963 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 227 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51615 | 5999235.1 | 2094032 | 37.7297688774613 | -122.444941576876 | (37.7297688774613, -122.444941576876) | 9 | 7 | 4 | 28861 | 40 | ||
5081 | 69491 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 57 Danton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | 3 | Permit Number 33613 | 6002842.65111 | 2094614.47792 | 37.7315734613241 | -122.43251146945 | (37.7315734613241, -122.43251146945) | 9 | 7 | 5 | 28861 | 25 | |
5165 | 39388 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 414 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40926 | 6003200.97263054 | 2099519.74958744 | 37.7450625247242 | -122.431622760195 | (37.7450625247242, -122.431622760195) | 2 | 7 | 5 | 63 | 22 | ||
5446 | 36410 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 591 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39333 | 5995339.97501455 | 2093247.68753987 | 37.7273922712597 | -122.458350621736 | (37.7273922712597, -122.458350621736) | 9 | 7 | 4 | 28861 | 40 | ||
5592 | 43851 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2678 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 6 | Permit Number 43473 | 5985253.1482 | 2097007.4687 | 37.7371308274945 | -122.49349719028 | (37.7371308274945, -122.49349719028) | 1 | 8 | 3 | 29491 | 35 | |
5687 | 66315 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 94 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29430 | 6001458.61740114 | 2094962.10093841 | 37.7324493716412 | -122.43732121741 | (37.7324493716412, -122.43732121741) | 9 | 7 | 5 | 63 | 40 | ||
5710 | 261400 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 730 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010100.55131 | 2118520.19892 | 37.7976220266446 | -122.409105591228 | (37.7976220266446, -122.409105591228) | 3 | 1 | 10 | 308 | 4 | |||||
5766 | 69922 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1479 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987109.7204 | 2105224.4854 | 37.7598009776001 | -122.487681752733 | (37.7598009776001, -122.487681752733) | 1 | 8 | 3 | 56 | 35 | |||
5974 | 62490 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 52 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1986 12:00:00 AM | Permit Number 22661 | 6000842.2540014 | 2092843.5185791 | 37.7265971735996 | -122.439300325407 | (37.7265971735996, -122.439300325407) | 9 | 7 | 6 | 28861 | 25 | ||
6160 | 42787 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 413 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42754 | 6004586.33786017 | 2109969.42501453 | 37.7738332863504 | -122.427576752843 | (37.7738332863504, -122.427576752843) | 7 | 9 | 11 | 28852 | 10 | |
6548 | 178944 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 202 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004727.85531 | 2094036.32936 | 37.7300927194874 | -122.425952806385 | (37.7300927194874, -122.425952806385) | 9 | 7 | 6 | 28861 | 5 | |||
6602 | 89550 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 5539 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981409.78222 | 2111623.31383 | 37.7770361978186 | -122.507869561004 | (37.7770361978186, -122.507869561004) | 11 | 6 | 2 | 55 | 26 | ||
6847 | 260435 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 917 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992908 | 2106572 | 37.7638373839544 | -122.467726529112 | (37.7638373839544, -122.467726529112) | 1 | 8 | 11 | 56 | 12 | ||||
6906 | 48666 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1715REVISED Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2002 12:00:00 AM | 1 | Permit Number 45950 | 6004823.677 | 2115363.4456 | 37.7886573555281 | -122.427140041517 | (37.7886573555281, -122.427140041517) | 13 | 9 | 11 | 28858 | 27 | |
7068 | 66214 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2233 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1990 12:00:00 AM | 9 | Permit Number 29304 | 5989765.2961 | 2100174.6084 | 37.7460898851299 | -122.47812830871 | (37.7460898851299, -122.47812830871) | 1 | 8 | 3 | 29491 | 35 | ||
7234 | 43732 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43369 | 5994354.80201989 | 2089904.78759744 | 37.718156810292 | -122.461514088361 | (37.718156810292, -122.461514088361) | 9 | 8 | 6 | 28861 | 24 | ||
7392 | 261325 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 644 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010473 | 2118597 | 37.79785376133 | -122.407822230627 | (37.79785376133, -122.407822230627) | 3 | 1 | 10 | 308 | 4 | ||||
7447 | 40722 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1436 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41701 | 6009381.89128779 | 2097433.59188792 | 37.7396827973609 | -122.410102898748 | (37.7396827973609, -122.410102898748) | 10 | 7 | 7 | 28859 | 2 | ||
7515 | 70939 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1925 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989075.8648 | 2102218.2021 | 37.7516610101851 | -122.480661823031 | (37.7516610101851, -122.480661823031) | 1 | 8 | 3 | 29491 | 35 | |||
7546 | 86580 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2539 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987975.8922 | 2098002.1559 | 37.7400208741264 | -122.484156469463 | (37.7400208741264, -122.484156469463) | 1 | 8 | 3 | 29491 | 35 | ||
7567 | 78659 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 238 Ottawa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998369.99191 | 2089313.52564 | 37.7167636327026 | -122.447592817774 | (37.7167636327026, -122.447592817774) | 9 | 7 | 6 | 28861 | 25 | |||
7569 | 86577 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2519 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987971.7931 | 2098127.9672 | 37.740366080244 | -122.484179866453 | (37.740366080244, -122.484179866453) | 1 | 8 | 3 | 29491 | 35 | ||
7633 | 65608 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 235 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | Permit Number 28512 | 6004926.15006729 | 2093819.12850558 | 37.7295075388181 | -122.425251826139 | (37.7295075388181, -122.425251826139) | 9 | 7 | 6 | 28861 | 5 | ||
7700 | 261404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 754 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009997.65437 | 2118506.05781 | 37.7975774337622 | -122.409460645418 | (37.7975774337622, -122.409460645418) | 3 | 1 | 10 | 308 | 4 | |||||
7795 | 34636 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1466 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 4 | Permit Number 45216 | 5988080.2573 | 2105318.5059 | 37.7601156921394 | -122.484332079774 | (37.7601156921394, -122.484332079774) | 1 | 8 | 3 | 56 | 35 | |
7880 | 46205 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1852 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2002 12:00:00 AM | 6 | Permit Number 44521 | 5988484.6348 | 2102686.0448 | 37.7529112010076 | -122.482740630037 | (37.7529112010076, -122.482740630037) | 1 | 8 | 3 | 56 | 35 | |
8000 | 71225 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2262 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5987644.7584 | 2099883.1111 | 37.7451661944085 | -122.485439373685 | (37.7451661944085, -122.485439373685) | 1 | 8 | 3 | 29491 | 35 | |||
8197 | 65499 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1520 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1989 12:00:00 AM | 2 | Permit Number 28383 | 5988131.2403 | 2099681.6905 | 37.7446414773793 | -122.483742458373 | (37.7446414773793, -122.483742458373) | 1 | 8 | 3 | 29491 | 35 | |
8298 | 66169 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 141 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29241 | 6009332.38059352 | 2096679.3641893 | 37.7376090764499 | -122.410220849347 | (37.7376090764499, -122.410220849347) | 10 | 7 | 7 | 28859 | 2 | ||
8330 | 60243 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1241 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 1 | Permit Number 19795 | 5987983.8428 | 2106825.6856 | 37.7642483811973 | -122.484776093092 | (37.7642483811973, -122.484776093092) | 1 | 8 | 3 | 56 | 35 | |
8464 | 92304 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2001 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52751 | 5989091.9697 | 2101683.9526 | 37.7501950388707 | -122.480567026206 | (37.7501950388707, -122.480567026206) | 1 | 8 | 3 | 29491 | 35 |
8521 | 43574 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 165 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43235 | 6004098.34924441 | 2100984.69662112 | 37.7491357535113 | -122.428624197191 | (37.7491357535113, -122.428624197191) | 2 | 4 | 5 | 28862 | 22 | ||
8548 | 138687 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2828 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999933.5509 | 2114410.1103 | 37.7857619969761 | -122.443990574135 | (37.7857619969761, -122.443990574135) | 15 | 6 | 1 | 29490 | 31 | |||
8574 | 182275 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3150 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985063.5912 | 2105018.8618 | 37.7591168373077 | -122.49474304376 | (37.7591168373077, -122.49474304376) | 1 | 8 | 3 | 56 | 35 | |||
8785 | 178959 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1333 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007585.1415 | 2091886.23741 | 37.7243500958617 | -122.415922582174 | (37.7243500958617, -122.415922582174) | 9 | 3 | 7 | 309 | 28 | |||
8869 | 45450 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 191 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
8968 | 261399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 715 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010168.78657 | 2118489.20051 | 37.7975407349103 | -122.408867289597 | (37.7975407349103, -122.408867289597) | 3 | 1 | 10 | 308 | 4 | |||||
8992 | 261405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
9198 | 44212 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2009 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2001 12:00:00 AM | 2 | Permit Number 43659 | 6003842.4279 | 2115438.8041 | 37.7888087328674 | -122.430540396598 | (37.7888087328674, -122.430540396598) | 13 | 9 | 1 | 29490 | 27 | |
9291 | 34653 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2000 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38332 | 5988676.14476792 | 2105141.94720244 | 37.75966558895 | -122.482258277854 | (37.75966558895, -122.482258277854) | 1 | 8 | 3 | 56 | 35 | ||
9392 | 70671 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 73 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6010033.5172 | 2110899.92735 | 37.7766948289379 | -122.408799654802 | (37.7766948289379, -122.408799654802) | 8 | 2 | 9 | 28853 | 34 |
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) );