trees
2,694 rows where qSpecies_id = 84 sorted by Neighborhoods (old)
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
884 | 261406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
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 | |||||||||||||
4023 | 31850 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
4740 | 119761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
4940 | 39332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
5244 | 261407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
6169 | 39333 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
8270 | 261411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
8992 | 261405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10081 | 119760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
11366 | 53918 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
12262 | 261408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
15267 | 119759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
17187 | 261409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18369 | 261412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
19387 | 31852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
3849 | 27720 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2015 06:49:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.7501876266135 | -122.390460137824 | (37.7501876266135, -122.390460137824) | 10 | 3 | 8 | 28856 | 1 | ||
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 | ||
11092 | 74333 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | 10 | 3 | 8 | 58 | 1 | |||
11462 | 38558 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1534 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40523 | 6015743.77247492 | 2095689.90327715 | 37.7352495140639 | -122.387984392406 | (37.7352495140639, -122.387984392406) | 10 | 3 | 8 | 58 | 1 | ||
15474 | 67662 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31263 | 6016003.68231462 | 2097240.31166612 | 37.739521017402 | -122.387193890351 | (37.739521017402, -122.387193890351) | 10 | 3 | 8 | 58 | 1 | ||
18344 | 40022 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | 10 | 3 | 8 | 58 | 1 | |
18417 | 4023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2015 02:44:00 PM | 3 | 3X3 | 6013444.0079121 | 2101040.051797 | 37.7498122193832 | -122.396310443681 | (37.7498122193832, -122.396310443681) | 10 | 3 | 8 | 28856 | 1 | ||
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 | ||
25815 | 27759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.8179102 | 2101113.2850563 | 37.750139234821 | -122.388473299437 | (37.750139234821, -122.388473299437) | 10 | 3 | 8 | 58 | 1 | ||
26757 | 4027 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2150 Cesar Chavez St | 1 | 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 | ||
36197 | 67647 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1980 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31246 | 6013237.51927358 | 2096157.49523352 | 37.7363942565122 | -122.396682257399 | (37.7363942565122, -122.396682257399) | 10 | 3 | 8 | 58 | 1 | ||
42727 | 67682 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 56 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31286 | 6012201.16288031 | 2095460.48706817 | 37.7344226836872 | -122.400216460292 | (37.7344226836872, -122.400216460292) | 10 | 3 | 8 | 58 | 1 | ||
45706 | 27750 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1299 Cesar Chavez St | 3 | 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 | ||
48725 | 27758 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1299 Cesar Chavez St | 11 | 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 | ||
59660 | 89359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 308 Tocoloma Ave | 3 | Front Yard : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.398393755853 | (37.7112369933076, -122.398393755853) | 10 | 3 | 8 | 309 | 1 | ||
62719 | 178898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012665.55046 | 2087301.61111 | 37.7120459484316 | -122.398038730507 | (37.7120459484316, -122.398038730507) | 10 | 3 | 8 | 309 | 1 | |||
65628 | 40021 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1530 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 5 | Permit Number 41266 | 6015759.6141 | 2095683.1757 | 37.7352319191288 | -122.387929152323 | (37.7352319191288, -122.387929152323) | 10 | 3 | 8 | 58 | 1 | |
66460 | 15049 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1125 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1999 12:00:00 AM | 25 | 8X15 | 6015485.0268 | 2096001.9904 | 37.7360921037992 | -122.388900760186 | (37.7360921037992, -122.388900760186) | 10 | 3 | 8 | 58 | 1 | ||
69218 | 196424 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1427x Innes Ave | 31 | Median : Yard | Tree | DPW 1 | 3 | 6016113.33147 | 2096777.48422 | 37.7382562587307 | -122.386782500139 | (37.7382562587307, -122.386782500139) | 10 | 3 | 8 | 58 | 1 | ||||
90077 | 29251 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300X Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.7501876266135 | -122.390460137824 | (37.7501876266135, -122.390460137824) | 10 | 3 | 8 | 28856 | 1 | ||
90801 | 199985 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1032 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018147.7753 | 2092169.4169 | 37.7257158363369 | -122.379428312297 | (37.7257158363369, -122.379428312297) | 10 | 3 | 8 | 58 | 1 | |||
96168 | 30770 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1662 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 2 | Permit Number 51077 | 6014463.7744 | 2093152.8983 | 37.7282124168861 | -122.392232472861 | (37.7282124168861, -122.392232472861) | 10 | 3 | 8 | 58 | 1 | ||
100052 | 46629 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1490 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 7 | Permit Number 44750 | 6015847.6531 | 2095265.1212 | 37.7340889026671 | -122.38759560956 | (37.7340889026671, -122.38759560956) | 10 | 3 | 8 | 58 | 1 | |
109178 | 30767 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1595 Underwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34647 | 6014606.20359025 | 2093675.42749231 | 37.729655084275 | -122.39177660647 | (37.729655084275, -122.39177660647) | 10 | 3 | 8 | 58 | 1 | ||
117015 | 27743 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1399 Cesar Chavez St | 4 | 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 | ||
119540 | 178897 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012667.83856 | 2087309.2144 | 37.7120669530014 | -122.398031355176 | (37.7120669530014, -122.398031355176) | 10 | 3 | 8 | 309 | 1 | |||
121404 | 54661 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 345 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 2 | Permit Number 10485 | 6012308.35839 | 2086909.49761 | 37.7109493816857 | -122.399245788885 | (37.7109493816857, -122.399245788885) | 10 | 3 | 8 | 309 | 1 | ||
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 | ||
132528 | 51809 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1465 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 2 | 3x3 | Permit Number 48055 | 6015110.437 | 2092946.715 | 37.7276821641004 | -122.389982519172 | (37.7276821641004, -122.389982519172) | 10 | 3 | 8 | 58 | 1 | |
134499 | 51808 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1465 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | Permit Number 48055 | 6015124.97012751 | 2092940.21442791 | 37.7276651208235 | -122.389931823623 | (37.7276651208235, -122.389931823623) | 10 | 3 | 8 | 58 | 1 | |||
137148 | 178896 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 424 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6012763.5947 | 2086999.98496 | 37.7112232027683 | -122.397678716599 | (37.7112232027683, -122.397678716599) | 10 | 3 | 8 | 309 | 1 | |||
141905 | 24168 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 95X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | ||
153037 | 4025 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1900 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/25/2015 03:01:00 PM | 3 | 3X3 | 6013444.0079121 | 2101040.051797 | 37.7498122193832 | -122.396310443681 | (37.7498122193832, -122.396310443681) | 10 | 3 | 8 | 28856 | 1 | ||
154597 | 27753 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1299 Cesar Chavez St | 6 | 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 | ||
156579 | 4026 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1900 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6013444.0079121 | 2101040.051797 | 37.7498122193832 | -122.396310443681 | (37.7498122193832, -122.396310443681) | 10 | 3 | 8 | 28856 | 1 | ||
158880 | 96804 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1200X Revere Ave | 1 | Median : | Tree | DPW 1 | 6017205.4 | 2092876.1 | 37.7276042330013 | -122.382735217758 | (37.7276042330013, -122.382735217758) | 10 | 3 | 8 | 58 | 1 | |||||
161111 | 4019 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1760 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 3 | 2X3 | 6013957.30178 | 2101067.5315943 | 37.7499162221241 | -122.394537361718 | (37.7499162221241, -122.394537361718) | 10 | 3 | 8 | 58 | 1 | ||
164897 | 199981 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1200x Shafter Ave | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.383326145908 | (37.7268412531355, -122.383326145908) | 10 | 3 | 8 | 58 | 1 | |||
166282 | 178899 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012660.08669 | 2087284.72268 | 37.7119992718279 | -122.398056430958 | (37.7119992718279, -122.398056430958) | 10 | 3 | 8 | 309 | 1 | |||
173129 | 60295 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1469 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1982 12:00:00 AM | 7 | 3x3 | Permit Number 19860 | 6015087.9595 | 2092963.5731 | 37.7277272064476 | -122.390061402044 | (37.7277272064476, -122.390061402044) | 10 | 3 | 8 | 58 | 1 | |
176433 | 199678 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1400x Underwood Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6015628.2568 | 2092949.4044 | 37.7277182533007 | -122.388192580507 | (37.7277182533007, -122.388192580507) | 10 | 3 | 8 | 58 | 1 | |||
188202 | 4029 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2150 Cesar Chavez St | 3 | 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 | ||
282 | 119806 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | ||
4437 | 244983 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 299 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005200.9141 | 2109719.1317 | 37.7731807843789 | -122.425433016756 | (37.7731807843789, -122.425433016756) | 7 | 9 | 11 | 28852 | 10 | |
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 | |
9471 | 119842 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
9852 | 31300 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 519 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 10 | Permit Number 34943 | 6005263.3007 | 2111469.3023 | 37.7779898515936 | -122.425341782234 | (37.7779898515936, -122.425341782234) | 7 | 9 | 11 | 28852 | 10 | |
11107 | 78786 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1356 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001332.0848 | 2110785.1298 | 37.7758884007732 | -122.438892183533 | (37.7758884007732, -122.438892183533) | 15 | 5 | 11 | 29492 | 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 | ||||
13210 | 244980 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 289 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005226.4402 | 2109722.7783 | 37.7731922392405 | -122.425344978098 | (37.7731922392405, -122.425344978098) | 7 | 9 | 11 | 28852 | 10 | |||
19155 | 80023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 632-632 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001104.7117 | 2110909.6213 | 37.7762172841329 | -122.439687650862 | (37.7762172841329, -122.439687650862) | 15 | 5 | 11 | 29492 | 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 | ||||
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 | ||||
23723 | 30734 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 281 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34629 | 6005251.19976575 | 2109714.98569866 | 37.7731722414546 | -122.425258776803 | (37.7731722414546, -122.425258776803) | 7 | 9 | 11 | 28852 | 10 | ||
23975 | 142257 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 541 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004803.1693 | 2110709.0411 | 37.7758763538472 | -122.426879382419 | (37.7758763538472, -122.426879382419) | 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 | ||||
27984 | 138926 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005464.9166 | 2110768.0336 | 37.7760757272062 | -122.424594423557 | (37.7760757272062, -122.424594423557) | 7 | 9 | 11 | 28852 | 10 | |||
28153 | 244988 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2018 12:00:00 AM | 3 | Width 0ft | 6005214.8927 | 2109749.52 | 37.7732650130646 | -122.425386825853 | (37.7732650130646, -122.425386825853) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||||
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 | ||||
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 | |||
29485 | 33704 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 196 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1996 12:00:00 AM | Permit Number 37772 | 6003356.08500561 | 2108810.32684763 | 37.7705810245056 | -122.431749619478 | (37.7705810245056, -122.431749619478) | 15 | 9 | 11 | 29492 | 10 | ||
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 | |||
31012 | 42789 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 426 -28 -30 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42755 | 6004546 | 2110000 | 37.7739149561089 | -122.427718466962 | (37.7739149561089, -122.427718466962) | 7 | 9 | 11 | 28852 | 10 | ||
31843 | 119859 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
33066 | 42783 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 202 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42751 | 6005176.07009417 | 2109735.98338901 | 37.7732256513259 | -122.425520155041 | (37.7732256513259, -122.425520155041) | 7 | 9 | 11 | 28852 | 10 | ||
33346 | 245221 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 341 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005088.7556 | 2110037.9678 | 37.7740498933785 | -122.425843687227 | (37.7740498933785, -122.425843687227) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||||
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 | ||||
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 | ||||
39220 | 33696 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 36 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37767 | 6004073.12371459 | 2108909.64468264 | 37.7708943463194 | -122.429276458446 | (37.7708943463194, -122.429276458446) | 7 | 9 | 11 | 29492 | 10 | |||
39487 | 244972 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 209 Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005534.5777 | 2109768.9686 | 37.7733364706745 | -122.424282374507 | (37.7733364706745, -122.424282374507) | 7 | 9 | 11 | 28852 | 10 | |||
40216 | 244239 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 253 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005546.7389 | 2110177.0116 | 37.7744575447356 | -122.424269333697 | (37.7744575447356, -122.424269333697) | 7 | 9 | 11 | 28852 | 10 | |||
42803 | 115684 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
43629 | 119810 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
44073 | 142255 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 521 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004876.8784 | 2110720.6117 | 37.7759122912727 | -122.426625227687 | (37.7759122912727, -122.426625227687) | 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 |
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) );