trees
2,694 rows where qSpecies_id = 84 sorted by SiteOrder descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29442 | 42763 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 9 | 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 | |||
41956 | 178886 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6003733.07859 | 2090591.8271 | 37.7205786116989 | -122.429146369125 | (37.7205786116989, -122.429146369125) | 9 | 7 | 6 | 28861 | 5 | |||
45064 | 28647 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 9 | Median : Cutout | Tree | DPW 1 | 8 | 6 | 6003547.8453 | 2114380.4001 | 37.7858859308492 | -122.431484021877 | (37.7858859308492, -122.431484021877) | 13 | 9 | 11 | 29490 | 13 | |||
47389 | 87404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 9 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003683.0746 | 2113412.9921 | 37.7832373349481 | -122.430947098227 | (37.7832373349481, -122.430947098227) | 15 | 9 | 11 | 29490 | 41 | ||
57353 | 238027 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251 Alma St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997671.60097 | 2106142.0382 | 37.7629307194099 | -122.451219750302 | (37.7629307194099, -122.451219750302) | 15 | 5 | 11 | 29492 | 9 | |||
60054 | 139409 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1500 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004207.1311 | 2114038.5263 | 37.7849845753314 | -122.429178689925 | (37.7849845753314, -122.429178689925) | 13 | 9 | 11 | 29490 | 13 | |||
76819 | 214405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200x Terrace Dr | 9 | Median : Yard | Tree | DPW 1 | 2 | 5993807.85396 | 2096495.95192 | 37.7362230417557 | -122.463882802747 | (37.7362230417557, -122.463882802747) | 1 | 8 | 4 | 59 | 40 | ||||
78797 | 21707 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1710X Webster St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | 6 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | 13 | 9 | 11 | 29490 | 27 | ||
128068 | 139183 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1900 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002330.6115 | 2113779.5111 | 37.784166978068 | -122.435652302842 | (37.784166978068, -122.435652302842) | 13 | 5 | 11 | 29490 | 13 | |||
132970 | 178914 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993788.47929 | 2086756.58168 | 37.7094799730978 | -122.463243292153 | (37.7094799730978, -122.463243292153) | 9 | 8 | 6 | 28861 | 25 | ||||
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 | ||||
158641 | 138102 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1760 Webster St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003533.9856 | 2114838.2776 | 37.7871423613143 | -122.431564673103 | (37.7871423613143, -122.431564673103) | 13 | 9 | 11 | 29490 | 27 | |||
179265 | 39078 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2280X Alameda St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
185871 | 50542 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
14237 | 240835 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1383 Vermont St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
18369 | 261412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
38409 | 110550 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
51459 | 238126 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3388 17th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2017 02:38:00 PM | 3 | Width 3ft | Permit Number 43579 | 6006363.87344 | 2106134.73006 | 37.7634045065344 | -122.421155613935 | (37.7634045065344, -122.421155613935) | 8 | 4 | 7 | 28859 | 19 | |
52577 | 178885 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003721.71366 | 2090575.27261 | 37.7205325133491 | -122.429184474304 | (37.7205325133491, -122.429184474304) | 9 | 7 | 6 | 28861 | 5 | |||
59666 | 87403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 8 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 10 | 3x3 | 6003687.1999 | 2113392.3659 | 37.7831809343135 | -122.430931353807 | (37.7831809343135, -122.430931353807) | 15 | 9 | 11 | 29490 | 41 | ||
67619 | 37253 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4200 20th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
71347 | 137953 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1615 SUTTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004788.4681 | 2114683.7679 | 37.786789139709 | -122.427213425712 | (37.786789139709, -122.427213425712) | 13 | 9 | 11 | 28858 | 13 | |||
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 | |||
89096 | 183942 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1805 Quintara St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987837.1544 | 2100978.5872 | 37.7481852874885 | -122.484854460213 | (37.7481852874885, -122.484854460213) | 1 | 8 | 3 | 29491 | 35 | |||
102725 | 36038 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1660X BRYANT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1998 12:00:00 AM | 2 | Permit Number 39178 | 6009346 | 2106886 | 37.7656349852358 | -122.410894426294 | (37.7656349852358, -122.410894426294) | 8 | 4 | 7 | 28853 | 19 | ||
107391 | 238026 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251 Alma St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997640.69708 | 2106136.91348 | 37.7629148787356 | -122.451326266018 | (37.7629148787356, -122.451326266018) | 15 | 5 | 11 | 29492 | 9 | |||
110027 | 42375 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 601 Foerster St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42549 | 5998097.42751354 | 2095265.42548706 | 37.7330905762451 | -122.448963434318 | (37.7330905762451, -122.448963434318) | 9 | 7 | 4 | 59 | 40 | ||
114211 | 50543 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
116661 | 106987 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1737-1795 Post St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2012 12:00:00 AM | 2 | 6003830.0102 | 2114195.5789 | 37.7853944465243 | -122.430494617565 | (37.7853944465243, -122.430494617565) | 13 | 9 | 11 | 29490 | 13 | |||
120473 | 88233 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2108 Hayes St | 8 | 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 | ||
133350 | 138101 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1750 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003541.5257 | 2114778.8993 | 37.7869797508763 | -122.431534345354 | (37.7869797508763, -122.431534345354) | 13 | 9 | 11 | 29490 | 27 | |||
143467 | 38758 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Shipley St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012273.298 | 2112461.93462 | 37.7811089398776 | -122.401161330453 | (37.7811089398776, -122.401161330453) | 6 | 2 | 9 | 28856 | 34 | ||
147741 | 117171 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
8270 | 261411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
11452 | 110549 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
11590 | 37254 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4200 20th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
20375 | 27754 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1299 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | 10 | 3 | 8 | 58 | 1 | ||
30564 | 106986 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1737-1795 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2012 12:00:00 AM | 2 | 6003814.6942 | 2114193.6153 | 37.7853881873399 | -122.430547466156 | (37.7853881873399, -122.430547466156) | 13 | 9 | 11 | 29490 | 13 | |||
38617 | 119866 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
52254 | 117170 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
58603 | 178891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 579 Madrid St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.7204375997904 | -122.43356984467 | (37.7204375997904, -122.43356984467) | 9 | 7 | 6 | 28861 | 5 | |||
67178 | 142764 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010752.149 | 2120007.2027 | 37.8017414569096 | -122.406955738459 | (37.8017414569096, -122.406955738459) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
76871 | 178913 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5993781.9303 | 2086773.16178 | 37.7095251208514 | -122.463267128695 | (37.7095251208514, -122.463267128695) | 9 | 8 | 6 | 28861 | 25 | ||||
85027 | 238001 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 591 27th St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6002762.01889 | 2100032.14119 | 37.7464445418877 | -122.433177187196 | (37.7464445418877, -122.433177187196) | 2 | 7 | 5 | 63 | 22 | ||||
93192 | 139147 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1500 GEARY BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004351.7938 | 2114062.4276 | 37.7850583905278 | -122.428679907469 | (37.7850583905278, -122.428679907469) | 13 | 9 | 11 | 29490 | 13 | |||
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 | ||||
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 | |||
106176 | 48786 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1405 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
106223 | 36248 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 134 Surrey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.7359046033608 | -122.434856848009 | (37.7359046033608, -122.434856848009) | 2 | 7 | 5 | 63 | 7 | |||
109253 | 88232 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2108 Hayes St | 7 | 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 | ||
113787 | 50544 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
116884 | 178884 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003708.27118 | 2090552.30373 | 37.7204686848705 | -122.429229303716 | (37.7204686848705, -122.429229303716) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
129592 | 4033 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2150 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.9559004 | 2100994.1740901 | 37.7496402484926 | -122.399163766262 | (37.7496402484926, -122.399163766262) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||||
132643 | 138799 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1827 Broderick St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000493.7553 | 2114952.745 | 37.7872838717102 | -122.44209139561 | (37.7872838717102, -122.44209139561) | 13 | 6 | 1 | 29490 | 27 | |||
133203 | 38750 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Shipley St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012258.40846 | 2112446.8085 | 37.7810665763953 | -122.40121177791 | (37.7810665763953, -122.40121177791) | 6 | 2 | 9 | 28856 | 34 | ||
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 | ||||
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 | ||||
149749 | 36259 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 25 Elmhurst Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | 9 | 8 | 4 | 64 | 40 | ||
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 | |||
158726 | 36037 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1660X BRYANT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39178 | 6009346 | 2106886 | 37.7656349852358 | -122.410894426294 | (37.7656349852358, -122.410894426294) | 8 | 4 | 7 | 28853 | 19 | ||
166674 | 120891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.7125761244342 | -122.407663136759 | (37.7125761244342, -122.407663136759) | 9 | 7 | 8 | 309 | 39 | |||
4233 | 27745 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1399 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6014867.8526066 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | 10 | 3 | 8 | 28856 | 1 | ||
4627 | 36424 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Montecito Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | 9 | 7 | 4 | 28861 | 40 | |||
6947 | 23903 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | 13 | 9 | 11 | 29490 | 13 | |||
14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
25901 | 37268 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 910 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | 2 | 4 | 5 | 28862 | 22 | ||
28839 | 119865 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
40452 | 12440 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1595X Laguna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
44352 | 178912 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5993780.74611 | 2086770.03775 | 37.7095164747811 | -122.463270994886 | (37.7095164747811, -122.463270994886) | 9 | 8 | 6 | 28861 | 25 | ||||
53173 | 36247 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 134 Surrey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.7359046033608 | -122.434856848009 | (37.7359046033608, -122.434856848009) | 2 | 7 | 5 | 63 | 7 | |||
61236 | 120890 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118268 | -122.40771591214 | (37.71259118268, -122.40771591214) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||||
85774 | 106985 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1737-1795 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2010 12:00:00 AM | 4 | 6003795.2547 | 2114190.67 | 37.7853789990287 | -122.430614510729 | (37.7853789990287, -122.430614510729) | 13 | 9 | 11 | 29490 | 13 | |||
86289 | 178935 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 249 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000079.03218 | 2091613.78256 | 37.7231771388895 | -122.44185052598 | (37.7231771388895, -122.44185052598) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||||
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 | ||||
106762 | 183940 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1809 Quintara St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987813.0153 | 2100978.3126 | 37.7481831275412 | -122.484937911261 | (37.7481831275412, -122.484937911261) | 1 | 8 | 3 | 29491 | 35 | |||
109206 | 238025 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251 Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997578.60338 | 2106127.58066 | 37.7628856975313 | -122.451540352327 | (37.7628856975313, -122.451540352327) | 15 | 5 | 11 | 29492 | 9 | |||
110623 | 256194 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009543.77791 | 2118449.16091 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | 3 | 1 | 10 | 308 | 4 | |||||
111704 | 34473 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1725 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1997 12:00:00 AM | 3 | Permit Number 38203 | 6008692.20922 | 2118946.49843 | 37.7987135430497 | -122.414009024508 | (37.7987135430497, -122.414009024508) | 5 | 1 | 10 | 308 | 21 | ||
112566 | 23490 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2500X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6005777.87956 | 2119177.13076 | 37.7991826887835 | -122.424109961515 | (37.7991826887835, -122.424109961515) | 13 | 9 | 1 | 28858 | 32 | |||
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 | |||
113671 | 43832 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2690 35th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | Permit Number 43458 | 5985573.35768067 | 2097037.8388719 | 37.7372329419636 | -122.492392332362 | (37.7372329419636, -122.492392332362) | 1 | 8 | 3 | 29491 | 35 | ||
116087 | 38752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Shipley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012228.62933 | 2112416.55663 | 37.7809818503781 | -122.40131267285 | (37.7809818503781, -122.40131267285) | 6 | 2 | 9 | 28856 | 34 | ||
116703 | 49406 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 288@ OCEAN Onondaga Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2003 12:00:00 AM | Permit Number 46355 | 5999928.15335168 | 2091616.69162038 | 37.7231765280064 | -122.442372291811 | (37.7231765280064, -122.442372291811) | 9 | 7 | 6 | 28861 | 25 | |||
117878 | 196382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012355.92865 | 2112312.32296 | 37.7807027502657 | -122.400864953468 | (37.7807027502657, -122.400864953468) | 6 | 2 | 9 | 28856 | 34 | |||
120294 | 138798 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1827 Broderick St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000492.2704 | 2114959.4269 | 37.7873021338531 | -122.442097012851 | (37.7873021338531, -122.442097012851) | 13 | 6 | 1 | 29490 | 27 | |||
127416 | 45546 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 345 Sloat Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | Permit Number 44299 | 5990416.87578702 | 2095931.52068495 | 37.7344772588746 | -122.475565486654 | (37.7344772588746, -122.475565486654) | 1 | 8 | 4 | 64 | 35 | ||
128924 | 178883 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003694.22054 | 2090531.28472 | 37.7204101758585 | -122.42927637423 | (37.7204101758585, -122.42927637423) | 9 | 7 | 6 | 28861 | 5 | |||
133933 | 139146 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1500 GEARY BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004372.8447 | 2114064.6435 | 37.7850656661829 | -122.428607235997 | (37.7850656661829, -122.428607235997) | 13 | 9 | 11 | 29490 | 13 | |||
137443 | 48787 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1405 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
139819 | 117169 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
143218 | 88231 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2108 Hayes St | 6 | 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 |
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) );