trees
4,014 rows where qSpecies_id = 40 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34248 | 196460 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 364 Missouri St | 2 | : | Tree | Private 2 | 16 | Width 3ft | 6013463.46293 | 2105385.87525 | 37.7617459921168 | -122.396547761567 | (37.7617459921168, -122.396547761567) | 10 | 3 | 8 | 28856 | 29 | |||
38729 | 196443 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2309 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011925.40712 | 2101842.83313 | 37.7519318623815 | -122.401618279553 | (37.7519318623815, -122.401618279553) | 10 | 3 | 8 | 28856 | 29 | |||
40196 | 196441 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 768 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012093.04476 | 2104807.3138 | 37.7600810286241 | -122.401246859559 | (37.7600810286241, -122.401246859559) | 10 | 3 | 8 | 28856 | 29 | ||||
47299 | 104364 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
49289 | 196487 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014260.97705 | 2112675.46167 | 37.7818059234575 | -122.394299855773 | (37.7818059234575, -122.394299855773) | 6 | 2 | 9 | 28856 | 6 | |||
50590 | 39571 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 835 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 8 | Permit Number 40989 | 6011610.45833 | 2104449.83114 | 37.7590725253066 | -122.402890761795 | (37.7590725253066, -122.402890761795) | 10 | 3 | 8 | 28856 | 29 | |
50913 | 50957 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 860 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2004 12:00:00 AM | 3 | Permit Number 47450 | 6011554.87685 | 2104354.20942 | 37.7588068655572 | -122.403076264082 | (37.7588068655572, -122.403076264082) | 10 | 3 | 8 | 28856 | 29 | |
52392 | 27729 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015622.7491 | 2101166.85438 | 37.7502813887778 | -122.3887850466 | (37.7502813887778, -122.3887850466) | 10 | 3 | 8 | 28856 | 1 | ||
54061 | 196452 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6013266.78575 | 2101037.18746 | 37.7497944913407 | -122.396923089148 | (37.7497944913407, -122.396923089148) | 10 | 3 | 8 | 28856 | 1 | |||
54353 | 92795 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 999 Wisconsin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 52022 | 6012811.72806 | 2102960.97452 | 37.7550514540675 | -122.398631693097 | (37.7550514540675, -122.398631693097) | 10 | 3 | 8 | 28856 | 29 | ||
60473 | 37967 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 456 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013486.47926 | 2104950.0016 | 37.7605504594599 | -122.396437603638 | (37.7605504594599, -122.396437603638) | 10 | 3 | 8 | 28856 | 29 | |
64136 | 121586 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 855 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012479.74347 | 2103984.11738 | 37.7578422788274 | -122.399851639655 | (37.7578422788274, -122.399851639655) | 10 | 3 | 8 | 28856 | 29 | |||
65480 | 196425 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 282 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011155.75972 | 2111427.64984 | 37.7782066270623 | -122.404954631245 | (37.7782066270623, -122.404954631245) | 14 | 2 | 9 | 28856 | 34 | |||
68166 | 196440 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1400 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014910.39402 | 2101173.59345 | 37.7502603851252 | -122.391248908417 | (37.7502603851252, -122.391248908417) | 10 | 3 | 8 | 28856 | 1 | |||
68283 | 196492 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014449.0241 | 2112477.93082 | 37.7812739996458 | -122.393635466299 | (37.7812739996458, -122.393635466299) | 6 | 2 | 9 | 28856 | 6 | |||
72009 | 43296 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 589 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775309 | 6013581.06232 | 2104334.57728 | 37.7588659015663 | -122.396067351846 | (37.7588659015663, -122.396067351846) | 10 | 3 | 8 | 28856 | 29 | ||
73927 | 50360 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 807 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 3 | Permit Number 47032 | 6011601.76017 | 2104587.37273 | 37.7594496982747 | -122.402930518137 | (37.7594496982747, -122.402930518137) | 10 | 3 | 8 | 28856 | 29 | ||
75212 | 196491 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014437.84547 | 2112488.65371 | 37.7813028211009 | -122.393674889898 | (37.7813028211009, -122.393674889898) | 6 | 2 | 9 | 28856 | 6 | |||
77137 | 57611 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 356 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/1976 12:00:00 AM | 13 | Permit Number 16500 | 6013179.72476 | 2105412.69394 | 37.7618038355947 | -122.397530985864 | (37.7618038355947, -122.397530985864) | 10 | 3 | 8 | 28856 | 29 | ||
81146 | 50013 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 999 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 2 | Permit Number 52022 | 6012813.23846 | 2102916.22313 | 37.7549286606329 | -122.398623329429 | (37.7549286606329, -122.398623329429) | 10 | 3 | 8 | 28856 | 29 | ||
82225 | 196447 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Madera St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012994.61219 | 2103283.12733 | 37.7559462030644 | -122.398021821446 | (37.7559462030644, -122.398021821446) | 10 | 3 | 8 | 28856 | 29 | |||
82301 | 62079 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 595 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1985 12:00:00 AM | 14 | Permit Number 22161 | 6013301.58361 | 2104304.12984 | 37.7587667459021 | -122.397031791103 | (37.7587667459021, -122.397031791103) | 10 | 3 | 8 | 28856 | 29 | |
83351 | 96396 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 800 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 3x3 | Permit Number 767136 | 6015449.8 | 2105317.4 | 37.7616683177051 | -122.389672976331 | (37.7616683177051, -122.389672976331) | 10 | 3 | 8 | 28856 | 29 | ||
84132 | 196449 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Madera St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6012958.79837 | 2103280.94306 | 37.7559382107998 | -122.398145525023 | (37.7559382107998, -122.398145525023) | 10 | 3 | 8 | 28856 | 29 | |||
85090 | 196485 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014233.73328 | 2112701.00373 | 37.7818745417214 | -122.394395896169 | (37.7818745417214, -122.394395896169) | 6 | 2 | 9 | 28856 | 6 | |||
87718 | 196457 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 13 | : | Tree | Private 2 | 3 | Width 3ft | 6012824.47283 | 2101012.76758 | 37.7497028090569 | -122.398450923095 | (37.7497028090569, -122.398450923095) | 10 | 3 | 8 | 28856 | 1 | |||
93608 | 196438 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1300 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015044.32759 | 2101169.27402 | 37.7502559568629 | -122.390785451805 | (37.7502559568629, -122.390785451805) | 10 | 3 | 8 | 28856 | 1 | |||
95145 | 196444 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200x Kansas St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 6011674.76736 | 2102721.10758 | 37.7543294225845 | -122.402546786399 | (37.7543294225845, -122.402546786399) | 10 | 3 | 8 | 28856 | 29 | |||
96306 | 92531 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1298X Kansas St | 1 | Median : Cutout | Tree | DPW 1 | 4 | 6011695.14318 | 2102366.06354 | 37.7533556870153 | -122.402451357562 | (37.7533556870153, -122.402451357562) | 10 | 3 | 8 | 28856 | 29 | ||||
98261 | 36732 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39511 | 6014611.90402 | 2112877.28923 | 37.7823795964711 | -122.393099929045 | (37.7823795964711, -122.393099929045) | 6 | 2 | 9 | 28856 | 6 | |
108318 | 196451 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013299.05466 | 2101039.80695 | 37.7498034800424 | -122.396811684714 | (37.7498034800424, -122.396811684714) | 10 | 3 | 8 | 28856 | 1 | |||
108668 | 32947 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 301 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37265 | 6012942.48941846 | 2105645.52533205 | 37.7624299268392 | -122.39836783116 | (37.7624299268392, -122.39836783116) | 14 | 3 | 8 | 28856 | 29 | ||
114422 | 39603 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 636 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 10 | Permit Number 41005 | 6012670.17637 | 2104503.85017 | 37.7592799656157 | -122.399229521944 | (37.7592799656157, -122.399229521944) | 10 | 3 | 8 | 28856 | 29 | |
116975 | 196498 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 649 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6012784.03099 | 2111475.7584 | 37.7784296058662 | -122.399325187321 | (37.7784296058662, -122.399325187321) | 6 | 2 | 9 | 28856 | 34 | |||
126194 | 65922 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 6 | Permit Number 28938 | 6014500.58115 | 2112811.20719 | 37.7821919655182 | -122.393480434 | (37.7821919655182, -122.393480434) | 6 | 2 | 9 | 28856 | 6 | |
126486 | 196483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 65 Colin P Kelly Jr St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015356.8087 | 2112701.67439 | 37.7819387497011 | -122.390510590187 | (37.7819387497011, -122.390510590187) | 6 | 2 | 9 | 28856 | 6 | |||
129562 | 196489 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014409.66856 | 2112518.16121 | 37.7813822762217 | -122.393774434946 | (37.7813822762217, -122.393774434946) | 6 | 2 | 9 | 28856 | 6 | |||
129774 | 39575 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 885 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 13 | Permit Number 40992 | 6011619.84178 | 2104260.65443 | 37.7585536119741 | -122.40284500429 | (37.7585536119741, -122.40284500429) | 10 | 3 | 8 | 28856 | 29 | |
130909 | 104361 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
136588 | 27728 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015202.17288 | 2101166.08495 | 37.750255956855 | -122.390239385253 | (37.750255956855, -122.390239385253) | 10 | 3 | 8 | 28856 | 1 | ||
143063 | 196490 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014419.45189 | 2112508.88507 | 37.7813573497108 | -122.393739939655 | (37.7813573497108, -122.393739939655) | 6 | 2 | 9 | 28856 | 6 | |||
145893 | 196455 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 11 | : | Tree | Private 2 | 6 | Width 3ft | 6012871.43703 | 2101015.96129 | 37.7497141944763 | -122.39828874204 | (37.7497141944763, -122.39828874204) | 10 | 3 | 8 | 28856 | 1 | |||
146975 | 121620 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1300x Kansas St | 1 | Median : Cutout | Tree | DPW 1 | 1 | 3x3 | 6011700.39266 | 2102280.30315 | 37.7531205008135 | -122.402427173876 | (37.7531205008135, -122.402427173876) | 10 | 3 | 8 | 28856 | 29 | |||
147470 | 196484 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014481.0981 | 2112803.55306 | 37.7821698664821 | -122.393547301273 | (37.7821698664821, -122.393547301273) | 6 | 2 | 9 | 28856 | 6 | |||
148935 | 37966 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 456 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013485.30445 | 2104964.69116 | 37.7605907284002 | -122.396442696467 | (37.7605907284002, -122.396442696467) | 10 | 3 | 8 | 28856 | 29 | |
149692 | 196448 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Madera St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6012976.23669 | 2103282.94556 | 37.7559446805133 | -122.398085357651 | (37.7559446805133, -122.398085357651) | 10 | 3 | 8 | 28856 | 29 | |||
150555 | 62580 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 775 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50012 | 6011310.42938 | 2104760.04993 | 37.7599075593065 | -122.403950240515 | (37.7599075593065, -122.403950240515) | 10 | 3 | 8 | 28856 | 29 | |
152097 | 114542 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2035 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011944.84803 | 2103714.66509 | 37.7570725877403 | -122.401682603564 | (37.7570725877403, -122.401682603564) | 10 | 3 | 8 | 28856 | 29 | ||
155160 | 50012 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 999 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3 | Permit Number 52022 | 6012815.30679 | 2102898.98068 | 37.7548814318474 | -122.398614966606 | (37.7548814318474, -122.398614966606) | 10 | 3 | 8 | 28856 | 29 | ||
156328 | 59606 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1077 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1981 12:00:00 AM | 1 | 3x3 | Permit Number 19007 | 6015566.4484 | 2104073.99726 | 37.7582606677124 | -122.389182708811 | (37.7582606677124, -122.389182708811) | 10 | 3 | 8 | 28856 | 29 | |
156519 | 196450 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013387.24706 | 2101044.34817 | 37.7498208576628 | -122.3965070277 | (37.7498208576628, -122.3965070277) | 10 | 3 | 8 | 28856 | 1 | |||
157822 | 196456 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012848.61003 | 2101014.24206 | 37.7497082022719 | -122.398367558612 | (37.7497082022719, -122.398367558612) | 10 | 3 | 8 | 28856 | 1 | |||
163813 | 196445 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 722 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011248.37561 | 2104820.69662 | 37.76007061448 | -122.404169123812 | (37.76007061448, -122.404169123812) | 10 | 3 | 8 | 28856 | 29 | |||
164139 | 196453 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6012987.92898 | 2101021.89129 | 37.7497369652948 | -122.397886321506 | (37.7497369652948, -122.397886321506) | 10 | 3 | 8 | 28856 | 1 | |||
172790 | 196486 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6014249.44841 | 2112687.41636 | 37.7818381074737 | -122.394340577066 | (37.7818381074737, -122.394340577066) | 6 | 2 | 9 | 28856 | 6 | |||
173357 | 104362 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
176896 | 67488 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1117 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | Permit Number 773109 | 6012239.52235 | 2103185.1315 | 37.7556350439301 | -122.400626303061 | (37.7556350439301, -122.400626303061) | 10 | 3 | 8 | 28856 | 29 | |
177743 | 111661 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1398x Kansas St | 1 | Median : Cutout | Tree | DPW 1 | 06/25/2015 01:32:00 PM | 3 | 3x3 | 6011721.86925 | 2101900.79241 | 37.7520796461774 | -122.402326221379 | (37.7520796461774, -122.402326221379) | 10 | 3 | 8 | 28856 | 29 | ||
180426 | 104366 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
182517 | 196437 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2125 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6011358.58417 | 2105543.63854 | 37.7620618088278 | -122.403838835192 | (37.7620618088278, -122.403838835192) | 10 | 3 | 8 | 28856 | 29 | |||
184202 | 40853 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 126 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | 11 | Permit Number 45449 | 6014213.93466 | 2112556.76874 | 37.781477404701 | -122.394454288235 | (37.781477404701, -122.394454288235) | 6 | 2 | 9 | 28856 | 6 | |
185279 | 196454 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 10 | : | Tree | Private 2 | 1 | Width 3ft | 6012891.82767 | 2101016.42082 | 37.7497165920542 | -122.398218262172 | (37.7497165920542, -122.398218262172) | 10 | 3 | 8 | 28856 | 1 | |||
188115 | 104360 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
191876 | 196439 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1300 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015016.02089 | 2101171.05558 | 37.7502592780626 | -122.390883463504 | (37.7502592780626, -122.390883463504) | 10 | 3 | 8 | 28856 | 1 | |||
192611 | 114543 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2035 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011964.29912 | 2103715.17017 | 37.7570750599871 | -122.401615369369 | (37.7570750599871, -122.401615369369) | 10 | 3 | 8 | 28856 | 29 | ||
192795 | 54425 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 664 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1972 12:00:00 AM | 10 | Permit Number 10199 | 6012377.17429 | 2104832.12129 | 37.7601649920327 | -122.400265927655 | (37.7601649920327, -122.400265927655) | 10 | 3 | 8 | 28856 | 29 | ||
194486 | 86928 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 838 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774404 | 6011535 | 2104444 | 37.7590523005339 | -122.403151323818 | (37.7590523005339, -122.403151323818) | 10 | 3 | 8 | 28856 | 29 | |
1598 | 135994 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009269.53041 | 2117367.69461 | 37.7944109435695 | -122.411899674537 | (37.7944109435695, -122.411899674537) | 3 | 1 | 10 | 28857 | 21 | |||
8166 | 135996 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009314.46183 | 2117374.97438 | 37.7944334526921 | -122.411744720456 | (37.7944334526921, -122.411744720456) | 3 | 1 | 10 | 28857 | 21 | |||
10833 | 135992 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009196.7187 | 2117357.70571 | 37.7943794313202 | -122.412150906452 | (37.7943794313202, -122.412150906452) | 3 | 1 | 10 | 28857 | 21 | |||
13277 | 135995 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009287.1824 | 2117369.66466 | 37.7944173431466 | -122.411838735572 | (37.7944173431466, -122.411838735572) | 3 | 1 | 10 | 28857 | 21 | |||
16183 | 135997 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009336.40364 | 2117377.1493 | 37.7944406553528 | -122.411668952587 | (37.7944406553528, -122.411668952587) | 3 | 1 | 10 | 28857 | 21 | |||
19515 | 135993 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009221.31733 | 2117360.97425 | 37.794389786122 | -122.412066023053 | (37.794389786122, -122.412066023053) | 3 | 1 | 10 | 28857 | 21 | |||
26102 | 136002 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009478.99985 | 2116817.49063 | 37.7929119670677 | -122.411135999022 | (37.7929119670677, -122.411135999022) | 3 | 1 | 10 | 28857 | 21 | |||
29561 | 88415 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009399.28346 | 2116763.19844 | 37.7927584231235 | -122.411407985496 | (37.7927584231235, -122.411407985496) | 3 | 1 | 10 | 28857 | 21 | |
30472 | 100032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | ||
32309 | 88409 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | 3 | 1 | 10 | 28857 | 21 | |
33557 | 135998 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009470.07385 | 2116888.98279 | 37.7931077665596 | -122.411171935935 | (37.7931077665596, -122.411171935935) | 3 | 1 | 10 | 28857 | 21 | |||
35235 | 88414 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009411.74152 | 2116765.8223 | 37.7927663263429 | -122.41136506535 | (37.7927663263429, -122.41136506535) | 3 | 1 | 10 | 28857 | 21 | |
37392 | 96373 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1315 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008912.46348 | 2117456.9297 | 37.7946359224745 | -122.413141486295 | (37.7946359224745, -122.413141486295) | 5 | 1 | 10 | 28857 | 21 | |
42087 | 88407 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | 3 | 1 | 10 | 28857 | 21 | |
50563 | 88416 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
58470 | 136000 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009476.57256 | 2116845.84647 | 37.7929896891793 | -122.411146401493 | (37.7929896891793, -122.411146401493) | 3 | 1 | 10 | 28857 | 21 | |||
67796 | 33273 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1121 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37442 | 6009382.25638 | 2117052.96271 | 37.7935530901583 | -122.411487381259 | (37.7935530901583, -122.411487381259) | 3 | 1 | 10 | 28857 | 21 | |
71695 | 100034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
73001 | 98796 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950@Washington Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768771 | 6010177.18626 | 2117200.01626 | 37.7940014192822 | -122.408747227007 | (37.7940014192822, -122.408747227007) | 3 | 1 | 10 | 28857 | 4 | |
78840 | 136001 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009476.76834 | 2116835.36375 | 37.7929609171614 | -122.411144983273 | (37.7929609171614, -122.411144983273) | 3 | 1 | 10 | 28857 | 21 | |||
87213 | 100031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | 3 | 1 | 10 | 28857 | 21 | |
91852 | 88421 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
100186 | 135999 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009475.36486 | 2116853.62807 | 37.7930109878303 | -122.411151130141 | (37.7930109878303, -122.411151130141) | 3 | 1 | 10 | 28857 | 21 | |||
103353 | 88413 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51386 | 6009439.10659 | 2116768.27237 | 37.7927745884158 | -122.411270553799 | (37.7927745884158, -122.411270553799) | 3 | 1 | 10 | 28857 | 21 | |
104181 | 98790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950x CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
105885 | 88412 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009452.7788 | 2116769.6537 | 37.7927791479928 | -122.411223344786 | (37.7927791479928, -122.411223344786) | 3 | 1 | 10 | 28857 | 21 | |
130066 | 136003 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009481.94772 | 2116801.23595 | 37.7928675009884 | -122.411124650506 | (37.7928675009884, -122.411124650506) | 3 | 1 | 10 | 28857 | 21 | |||
137212 | 88418 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
143356 | 100035 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
151278 | 100037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
153077 | 88417 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
153256 | 100033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
156455 | 88419 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 |
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) );