trees
2,694 rows where qSpecies_id = 84 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23229 | 101446 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
181217 | 101447 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
85708 | 101473 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1X Melrose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000100 | 2095441 | 37.7336869872758 | -122.442052627426 | (37.7336869872758, -122.442052627426) | 9 | 7 | 4 | 63 | 40 | |||||
192833 | 101729 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 90 Rotteck St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003352.20109 | 2094564.64642 | 37.731465517513 | -122.430746301695 | (37.731465517513, -122.430746301695) | 9 | 7 | 5 | 28861 | 25 | |||
91365 | 10211 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1311 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1991 12:00:00 AM | 12 | 2X2 | 6005852.92273 | 2101311.29856 | 37.7501316687427 | -122.422580057332 | (37.7501316687427, -122.422580057332) | 2 | 4 | 5 | 28859 | 19 | ||
126063 | 102207 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 89X Elgin Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.423097025843 | (37.7700345996314, -122.423097025843) | 8 | 2 | 5 | 28853 | 19 | |
59035 | 102208 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 89X Elgin Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.423097025843 | (37.7700345996314, -122.423097025843) | 8 | 2 | 5 | 28853 | 19 | |
23647 | 102209 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 89X Elgin Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.423097025843 | (37.7700345996314, -122.423097025843) | 8 | 2 | 5 | 28853 | 19 | |
64985 | 102572 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 778 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x9 | 5997324.2834 | 2112596.006 | 37.7806317567919 | -122.452886865809 | (37.7806317567919, -122.452886865809) | 15 | 6 | 2 | 54 | 16 | |||
144373 | 102809 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 490 33rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 33567 | 5985658.04889 | 2112631.72376 | 37.7800543868588 | -122.493248005621 | (37.7800543868588, -122.493248005621) | 11 | 6 | 2 | 55 | 26 | ||
186593 | 102810 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 490 33rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770137 | 5985656.77163 | 2112663.00689 | 37.7801402066402 | -122.493254729507 | (37.7801402066402, -122.493254729507) | 11 | 6 | 2 | 55 | 26 | |
162412 | 103482 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 560 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6003141.00472 | 2090240.25972 | 37.7195797508971 | -122.431167899382 | (37.7195797508971, -122.431167899382) | 9 | 7 | 6 | 28861 | 5 | |||
161498 | 103649 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 307X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005304.8 | 2110365.7 | 37.7749619731115 | -122.425119675916 | (37.7749619731115, -122.425119675916) | 7 | 9 | 11 | 28852 | 10 | |
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 | |
44178 | 103651 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 307X Octavia St | 3 | 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 | |
192258 | 104036 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 149 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 770678 | 6005538 | 2099025 | 37.7438362440335 | -122.423506557165 | (37.7438362440335, -122.423506557165) | 2 | 7 | 5 | 28859 | 22 | ||
88513 | 104081 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2610 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987336.5 | 2114673.6 | 37.7857588250819 | -122.487591604742 | (37.7857588250819, -122.487591604742) | 11 | 6 | 1 | 55 | 33 | |||||
147994 | 104125 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1330 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 9x6 | Permit Number 770527 | 6001480.2051 | 2110460.0547 | 37.7750042523156 | -122.438356503743 | (37.7750042523156, -122.438356503743) | 15 | 5 | 11 | 29492 | 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 | ||
159093 | 104337 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2667 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 5991723.9 | 2097287 | 37.7382747449775 | -122.471145435016 | (37.7382747449775, -122.471145435016) | 1 | 8 | 4 | 29491 | 40 | ||||
60519 | 104961 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 125 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2013 12:00:00 AM | 10 | Permit Number 770811 | 5996496.5 | 2113597.6 | 37.7833343975689 | -122.455822972198 | (37.7833343975689, -122.455822972198) | 11 | 6 | 1 | 54 | 31 | ||
180626 | 105143 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 432 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | DPW for City Agency | 3 | 4x4 | 6005556.0703 | 2110851.1612 | 37.7763091228737 | -122.424285011933 | (37.7763091228737, -122.424285011933) | 7 | 9 | 11 | 28852 | 10 | ||
164734 | 106722 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2905 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5999550.4676 | 2114295.9601 | 37.7854267102234 | -122.445307719005 | (37.7854267102234, -122.445307719005) | 15 | 6 | 1 | 29490 | 31 | |||
119264 | 106857 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2800 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001545 | 2118180 | 37.7962049292866 | -122.438685656109 | (37.7962049292866, -122.438685656109) | 13 | 9 | 1 | 57 | 17 | ||
177813 | 106891 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400x LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | |||||
38528 | 106984 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1737-1795 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2012 12:00:00 AM | 3 | 6003775.6189 | 2114189.0991 | 37.7853735733153 | -122.430682332536 | (37.7853735733153, -122.430682332536) | 13 | 9 | 11 | 29490 | 13 | |||
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 | |||
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 | |||
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 | |||
109379 | 106988 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1737-1795 Post St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2012 12:00:00 AM | 2 | 6003903.841 | 2114208.5386 | 37.7854342126943 | -122.430240110104 | (37.7854342126943, -122.430240110104) | 13 | 9 | 11 | 29490 | 13 | |||
135370 | 106989 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1737-1795 Post St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2012 12:00:00 AM | 2 | 6003919.5496 | 2114210.5022 | 37.7854404939773 | -122.430185903176 | (37.7854404939773, -122.430185903176) | 13 | 9 | 11 | 29490 | 13 | |||
101115 | 107518 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 59 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x4 | 6003087.6 | 2108634.4 | 37.7700827498113 | -122.432665742309 | (37.7700827498113, -122.432665742309) | 15 | 5 | 5 | 29492 | 9 | |||
29717 | 107752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x3 | Permit Number 772924 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||
20713 | 107753 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | ||||
94698 | 107754 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
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 | |||||
193327 | 107756 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 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 | |||||
54636 | 108099 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2390X Green St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | ||
75647 | 108192 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 603 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007188.43841 | 2091737.3666 | 37.7239190175192 | -122.417283387741 | (37.7239190175192, -122.417283387741) | 9 | 3 | 7 | 309 | 28 | |||
114875 | 108545 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 150 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003013.00279 | 2094373.5586 | 37.7309216102277 | -122.431905334488 | (37.7309216102277, -122.431905334488) | 9 | 7 | 5 | 28861 | 25 |
157524 | 108886 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 4102x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002290.3 | 2104760.1 | 37.7593996192873 | -122.435146441702 | (37.7593996192873, -122.435146441702) | 2 | 4 | 5 | 28862 | 3 | ||||
63249 | 108887 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 4102x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002290.3 | 2104760.1 | 37.7593996192873 | -122.435146441702 | (37.7593996192873, -122.435146441702) | 2 | 4 | 5 | 28862 | 3 | ||||
190721 | 108896 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) | 9 | 7 | 6 | 28861 | 5 |
101029 | 108939 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774694 | 6004341.9 | 2118349.2 | 37.7968282226561 | -122.429019881342 | (37.7968282226561, -122.429019881342) | 13 | 9 | 1 | 57 | 17 |
135861 | 109155 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2016 12:00:00 AM | 6 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||
169343 | 109156 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2015 01:49:00 PM | 3 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
165374 | 109158 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | |||
27494 | 109159 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 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 | ||||
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 | ||||
59804 | 109182 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 634 HURON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5998040 | 2087925.4 | 37.7129332935716 | -122.448633512376 | (37.7129332935716, -122.448633512376) | 9 | 7 | 6 | 28861 | 25 | |||
81155 | 109406 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 185 BELGRAVE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997621.5 | 2104846.8 | 37.7593714532782 | -122.451299612431 | (37.7593714532782, -122.451299612431) | 15 | 5 | 11 | 28862 | 12 | ||||
113401 | 109407 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 185 BELGRAVE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 3 | 3x3 | 5997621.5 | 2104846.8 | 37.7593714532782 | -122.451299612431 | (37.7593714532782, -122.451299612431) | 15 | 5 | 11 | 28862 | 12 | ||
35556 | 109408 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 185 BELGRAVE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 3 | 3x3 | 5997621.5 | 2104846.8 | 37.7593714532782 | -122.451299612431 | (37.7593714532782, -122.451299612431) | 15 | 5 | 11 | 28862 | 12 | ||
82547 | 109710 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 274 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774419 | 6005156.44986 | 2094314.59165 | 37.730880978857 | -122.424490884661 | (37.730880978857, -122.424490884661) | 9 | 7 | 6 | 28861 | 5 |
171091 | 110543 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | ||||
138897 | 110545 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
125930 | 110546 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | ||||
169317 | 110548 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
21018 | 110553 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
28979 | 110554 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
156509 | 111452 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1399x EUGENIA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6008618 | 2097694 | 37.7403549752059 | -122.412762522808 | (37.7403549752059, -122.412762522808) | 10 | 7 | 7 | 28859 | 2 | |||
129555 | 111662 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1343 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011203 | 2102078 | 37.7525372414217 | -122.404133028772 | (37.7525372414217, -122.404133028772) | 10 | 4 | 8 | 28859 | 19 | ||||
152044 | 111845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1550 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | 2 | 7 | 7 | 28859 | 2 | ||
83697 | 11186 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100 Idora Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | 1 | 8 | 4 | 59 | 40 | |||
62448 | 11188 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995291.08877 | 2099424.10153 | 37.7443483813689 | -122.458966630003 | (37.7443483813689, -122.458966630003) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
189426 | 11200 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 186 Idora Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5995344.6608195 | 2099448.7962231 | 37.7444192662253 | -122.458783177848 | (37.7444192662253, -122.458783177848) | 1 | 8 | 4 | 59 | 40 | |||
138486 | 112235 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 210 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778169 | 6004073.8 | 2107506.8 | 37.7670425133064 | -122.429174075483 | (37.7670425133064, -122.429174075483) | 8 | 4 | 5 | 28862 | 3 | |
126717 | 112392 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4331 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6001612.33019827 | 2105235.34197744 | 37.7606659965109 | -122.437525222221 | (37.7606659965109, -122.437525222221) | 2 | 4 | 5 | 28862 | 3 | |||
96954 | 112423 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 48 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000897 | 2109209 | 37.7715359812847 | -122.440284193858 | (37.7715359812847, -122.440284193858) | 15 | 5 | 11 | 29492 | 9 | ||||
33519 | 113285 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1626 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6002125.1158 | 2114161.3803 | 37.7852038195405 | -122.43639058316 | (37.7852038195405, -122.43639058316) | 13 | 6 | 11 | 29490 | 13 | |||
142214 | 113286 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1626 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002122.0899 | 2114184.377 | 37.7852667906839 | -122.436402698291 | (37.7852667906839, -122.436402698291) | 13 | 6 | 11 | 29490 | 13 | |||
79075 | 113403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2052 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006463.2485 | 2117908.2188 | 37.7957372487994 | -122.421648172625 | (37.7957372487994, -122.421648172625) | 13 | 9 | 10 | 28858 | 32 | |||
29396 | 113411 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1642 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5991208.59288317 | 2104157.90962907 | 37.757110661532 | -122.473428111823 | (37.757110661532, -122.473428111823) | 1 | 8 | 4 | 56 | 12 | ||||
156989 | 113745 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009609.4912 | 2118458.30583 | 37.797424561837 | -122.410800425125 | (37.797424561837, -122.410800425125) | 3 | 1 | 10 | 308 | 4 | ||||
172565 | 113746 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009590.33174 | 2118455.97825 | 37.7974170965836 | -122.410866557642 | (37.7974170965836, -122.410866557642) | 3 | 1 | 10 | 308 | 4 | ||||
28356 | 113747 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 6009570.41641 | 2118454.83114 | 37.7974128301892 | -122.410935389082 | (37.7974128301892, -122.410935389082) | 3 | 1 | 10 | 308 | 4 | |||
23950 | 113748 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009543.77791 | 2118449.16091 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | 3 | 1 | 10 | 308 | 4 | ||||
173585 | 114422 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 30X OGDEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x9 | 6009444 | 2095952 | 37.7356181472918 | -122.40978359874 | (37.7356181472918, -122.40978359874) | 10 | 7 | 7 | 28859 | 2 | |||
32686 | 114513 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 418 BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 6x7 | 5998550 | 2106753 | 37.7646585215155 | -122.448225680862 | (37.7646585215155, -122.448225680862) | 15 | 5 | 11 | 29492 | 9 | |||
36930 | 114660 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1603 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6004469.8992 | 2114403.3025 | 37.786001031208 | -122.428295602978 | (37.786001031208, -122.428295602978) | 13 | 9 | 11 | 29490 | 13 | |||
161361 | 114661 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1603 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2016 12:00:00 AM | 3 | 3x3 | 6004477.5231 | 2114370.1159 | 37.7859103404926 | -122.428266860283 | (37.7859103404926, -122.428266860283) | 13 | 9 | 11 | 29490 | 13 | ||
118423 | 114730 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2536 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780830 | 6002593.47602 | 2116148.5251 | 37.7906866135575 | -122.434912365239 | (37.7906866135575, -122.434912365239) | 13 | 9 | 1 | 29490 | 27 | |
133200 | 114733 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 435 LILY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2x2 | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | ||||
154465 | 114736 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 435 LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2x2 | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | ||||
22364 | 114870 | Planning Code 138.1 required 2 | Prunus serrulata :: Ornamental Cherry 84 | 2326 Cecelia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3 | 3x4 | 5991484.88147917 | 2099641.61135178 | 37.744726077495 | -122.472143418263 | (37.744726077495, -122.472143418263) | 1 | 8 | 4 | 29491 | 40 | ||
189834 | 115103 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 98X HEMLOCK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006944 | 2114961 | 37.7876720140792 | -122.419775454842 | (37.7876720140792, -122.419775454842) | 13 | 9 | 10 | 28858 | 21 | |||
55855 | 115104 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 98X HEMLOCK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006944 | 2114961 | 37.7876720140792 | -122.419775454842 | (37.7876720140792, -122.419775454842) | 13 | 9 | 10 | 28858 | 21 | ||||
42198 | 115105 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 98X HEMLOCK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006944 | 2114961 | 37.7876720140792 | -122.419775454842 | (37.7876720140792, -122.419775454842) | 13 | 9 | 10 | 28858 | 21 | ||||
61332 | 115106 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 98X HEMLOCK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006944 | 2114961 | 37.7876720140792 | -122.419775454842 | (37.7876720140792, -122.419775454842) | 13 | 9 | 10 | 28858 | 21 | ||||
36097 | 115453 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 300 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 |
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) );