trees
2,694 rows where qSpecies_id = 84 sorted by Longitude
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 | |||||||||||||
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 | |||
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 | |||||
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 | |||
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 | ||
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 | ||||
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 | ||
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 | |
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 | |
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 | ||
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 | |
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
96137 | 121759 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1019 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015338 | 2103772 | 37.7574187808175 | -122.389951694408 | (37.7574187808175, -122.389951694408) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |
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 | |
38556 | 196406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
154286 | 196407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 301 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6014364.2295 | 2105674.47806 | 37.7625885210619 | -122.393452545091 | (37.7625885210619, -122.393452545091) | 10 | 3 | 8 | 28856 | 29 | |||
22903 | 40229 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
165564 | 40228 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
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 | ||
33075 | 67707 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 31 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 11 | Permit Number 31318 | 6014113.95879 | 2113076.60421 | 37.7828991959845 | -122.39483657655 | (37.7828991959845, -122.39483657655) | 6 | 2 | 9 | 28856 | 6 | |
80402 | 64483 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 55X Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1994 12:00:00 AM | Permit Number 25357 | 6014099.57937836 | 2112818.90611884 | 37.7821908163878 | -122.394868269842 | (37.7821908163878, -122.394868269842) | 6 | 2 | 9 | 28856 | 6 | ||
181908 | 196393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6013990.37233 | 2112956.91555 | 37.7825636859099 | -122.395255750564 | (37.7825636859099, -122.395255750564) | 6 | 2 | 9 | 28856 | 6 | |||
41313 | 196392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6013963.53714 | 2112927.48749 | 37.7824813907387 | -122.395346527235 | (37.7824813907387, -122.395346527235) | 6 | 2 | 9 | 28856 | 6 | |||
150236 | 196391 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6013949.37152 | 2112913.94153 | 37.7824434087757 | -122.395394585209 | (37.7824434087757, -122.395394585209) | 6 | 2 | 9 | 28856 | 6 | |||
145706 | 196390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6013936.7797 | 2112901.90047 | 37.7824096464379 | -122.395437303898 | (37.7824096464379, -122.395437303898) | 6 | 2 | 9 | 28856 | 6 | |||
54703 | 196389 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | 6 | 2 | 9 | 28856 | 6 | |||
165258 | 32267 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 267 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | Permit Number 36853 | 6013772.46926434 | 2105862.13808331 | 37.7630708975316 | -122.395512392676 | (37.7630708975316, -122.395512392676) | 14 | 3 | 8 | 28856 | 29 | |||
119235 | 196388 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6013913.95715 | 2112880.07634 | 37.7823484529672 | -122.395514731015 | (37.7823484529672, -122.395514731015) | 6 | 2 | 9 | 28856 | 6 | |||
54779 | 196387 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6013895.88765 | 2112864.30367 | 37.7823041397518 | -122.395576138553 | (37.7823041397518, -122.395576138553) | 6 | 2 | 9 | 28856 | 6 | |||
41243 | 196386 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6013883.34247 | 2112854.56717 | 37.7822767077361 | -122.395618857241 | (37.7822767077361, -122.395618857241) | 6 | 2 | 9 | 28856 | 6 | |||
120605 | 196385 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013873.09616 | 2112844.01572 | 37.7822471659153 | -122.395653565657 | (37.7822471659153, -122.395653565657) | 6 | 2 | 9 | 28856 | 6 | |||
7694 | 44088 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013788.61209882 | 2112522.22157888 | 37.7813588929752 | -122.395923288248 | (37.7813588929752, -122.395923288248) | 6 | 2 | 9 | 28856 | 34 | |
110818 | 44089 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013788.61209882 | 2112522.22157888 | 37.7813588929752 | -122.395923288248 | (37.7813588929752, -122.395923288248) | 6 | 2 | 9 | 28856 | 34 | |
55239 | 67709 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1992 12:00:00 AM | 10 | Permit Number 31320 | 6013781.91426 | 2112762.09602 | 37.7820171606904 | -122.395963274202 | (37.7820171606904, -122.395963274202) | 6 | 2 | 9 | 28856 | 6 | ||
84781 | 196394 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 497 03rd St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6013753.77821 | 2112514.40047 | 37.7813354799985 | -122.396043249122 | (37.7813354799985, -122.396043249122) | 6 | 2 | 9 | 28856 | 34 | |||
160597 | 44090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013747.9947 | 2112490.58767 | 37.7812697737139 | -122.396061588087 | (37.7812697737139, -122.396061588087) | 6 | 2 | 9 | 28856 | 34 | |
43932 | 196384 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 99 Stillman St | 3 | : | Tree | Private 2 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.7819454154917 | -122.396070069587 | (37.7819454154917, -122.396070069587) | 6 | 2 | 9 | 28856 | 6 | |||
60228 | 44086 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013734.19002 | 2112474.65205 | 37.7812252500735 | -122.396108228707 | (37.7812252500735, -122.396108228707) | 6 | 2 | 9 | 28856 | 34 | |
187102 | 67710 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.69743 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) | 6 | 2 | 9 | 28856 | 6 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
94321 | 40325 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 655 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/1999 12:00:00 AM | 4 | Permit Number 41463 | 6013209.4791 | 2113639.3788 | 37.7843941128313 | -122.398005213512 | (37.7843941128313, -122.398005213512) | 6 | 2 | 9 | 28856 | 6 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
32366 | 196377 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 137 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012419.03852 | 2112368.2176 | 37.7808597440141 | -122.400650552379 | (37.7808597440141, -122.400650552379) | 6 | 2 | 9 | 28856 | 34 | |||
20865 | 196378 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012410.67338 | 2112360.21924 | 37.7808373158188 | -122.400678929615 | (37.7808373158188, -122.400678929615) | 6 | 2 | 9 | 28856 | 34 | |||
91786 | 196379 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012397.66121 | 2112347.77768 | 37.7808024284316 | -122.400723071038 | (37.7808024284316, -122.400723071038) | 6 | 2 | 9 | 28856 | 34 | |||
100936 | 196380 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012381.80562 | 2112329.94836 | 37.7807525888897 | -122.400776670626 | (37.7807525888897, -122.400776670626) | 6 | 2 | 9 | 28856 | 34 | |||
137367 | 196381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012369.74132 | 2112319.30273 | 37.7807226855437 | -122.400817659004 | (37.7807226855437, -122.400817659004) | 6 | 2 | 9 | 28856 | 34 | |||
174923 | 43293 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 975 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43062 | 6012196.286885 | 2103939.61174077 | 37.7577042695859 | -122.400828830136 | (37.7577042695859, -122.400828830136) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
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 | ||
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 | ||
147402 | 178903 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6011814.45609 | 2090752.08936 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | 10 | 7 | 8 | 309 | 28 |
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) );