Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
qCaretaker ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131343 | 131343 | 39995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 869 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2004 12:00:00 AM | 6 | 3x3 | Permit Number 47551 | 6019405.77873 | 2094282.05396 | 37.7315860320638 | -122.375225801726 | (37.7315860320638, -122.375225801726) |
| 47543 | 47543 | 201520 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6019241.773440001 | 2094383.32833 | 37.7318550858427 | -122.37579982552 | (37.7318550858427, -122.37579982552) | |||
| 163764 | 163764 | 201519 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6019223.74724 | 2094361.07733 | 37.7317929966527 | -122.375860604396 | (37.7317929966527, -122.375860604396) | |||
| 27606 | 27606 | 201518 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6019207.673780001 | 2094338.78719 | 37.7317309074526 | -122.37591462936199 | (37.7317309074526, -122.375914629362) | |||
| 81165 | 81165 | 97014 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 85013 | 85013 | 97015 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 94845 | 94845 | 97016 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 176927 | 176927 | 40009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 963 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | Permit Number 41262 | 6018899.57505 | 2094657.4041900001 | 37.732588803110204 | -122.377001897143 | (37.7325888031102, -122.377001897143) | |
| 152139 | 152139 | 196275 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018699.22943 | 2093690.01585 | 37.729921505667 | -122.37762743678101 | (37.729921505667, -122.377627436781) | |||
| 153801 | 153801 | 196274 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018690.35337 | 2093691.67274 | 37.7299255661145 | -122.377658237655 | (37.7299255661145, -122.377658237655) | |||
| 132578 | 132578 | 196273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6018678.54669 | 2093695.28939 | 37.729934846200294 | -122.377699306103 | (37.7299348462003, -122.377699306103) | |||
| 170977 | 170977 | 196272 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018667.18531 | 2093699.9533900002 | 37.7299470266284 | -122.377738907749 | (37.7299470266284, -122.377738907749) | |||
| 88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
| 180204 | 180204 | 201503 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 1001 Innes Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6018539.45605 | 2094929.8909099998 | 37.7333171568604 | -122.378265839401 | (37.7333171568604, -122.378265839401) | ||||
| 153474 | 153474 | 196471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | |||
| 49913 | 49913 | 199985 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018147.7753 | 2092169.4169 | 37.725715836336896 | -122.379428312297 | (37.7257158363369, -122.379428312297) | |||
| 181845 | 181845 | 201407 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 201 Harbor Rd | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6018140.985830001 | 2094924.5554099998 | 37.733280536449705 | -122.379643105252 | (37.7332805364497, -122.379643105252) | |||
| 14939 | 14939 | 6391 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 16 Espanola St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 3X3 | 6018056.47068 | 2094273.68663 | 37.7314887164161 | -122.379890092347 | (37.7314887164161, -122.379890092347) | ||
| 102400 | 102400 | 6398 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4X Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/1998 12:00:00 AM | 12 | 3X3 | 6018041.9202743 | 2094226.9871977002 | 37.7313596862419 | -122.379937152762 | (37.7313596862419, -122.379937152762) | ||
| 88204 | 88204 | 14623 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837711999 | 37.7313920698281 | -122.38002451510201 | (37.7313920698281, -122.380024515102) | ||
| 145234 | 145234 | 14624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018000.3078284 | 2094247.4364445 | 37.7314135402286 | -122.38008243669701 | (37.7314135402286, -122.380082436697) | ||
| 174583 | 174583 | 196509 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6017994.96949 | 2094236.9761 | 37.731384523654704 | -122.380100165912 | (37.7313845236547, -122.380100165912) | |||
| 78561 | 78561 | 14625 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 15 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 12 | 3X4 | 6017974.7726653 | 2094204.2737729999 | 37.7312936151853 | -122.380167719121 | (37.7312936151853, -122.380167719121) | ||
| 181027 | 181027 | 196510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Matthew Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017931.224780001 | 2094293.63767 | 37.7315365882339 | -122.380324481997 | (37.7315365882339, -122.380324481997) | |||
| 175278 | 175278 | 199890 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1200x Quesada Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6017354.2822 | 2093058.6837 | 37.7281137963921 | -122.382233221943 | (37.7281137963921, -122.382233221943) | |||
| 119612 | 119612 | 96804 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200X Revere Ave | 1 | Median : 22 | Tree 1 | DPW 2 | 6017205.4 | 2092876.1 | 37.7276042330013 | -122.38273521775801 | (37.7276042330013, -122.382735217758) | |||||
| 83650 | 83650 | 4016 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/27/2000 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.38278818869301 | (37.7506230149756, -122.382788188693) | ||
| 71980 | 71980 | 196271 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Cashmere St | 1 | : 4 | Tree 1 | Private 1 | 31 | 6017110.310380001 | 2095865.5402400002 | 37.7358073912904 | -122.383271945238 | (37.7358073912904, -122.383271945238) | ||||
| 171275 | 171275 | 199981 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200x Shafter Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.38332614590799 | (37.7268412531355, -122.383326145908) | |||
| 14815 | 14815 | 29657 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 299X Cashmere St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3x3 | 6016930.3488300005 | 2095863.99444 | 37.735793199983796 | -122.38389404137699 | (37.7357931999838, -122.383894041377) | ||
| 43128 | 43128 | 196270 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6016861.7614 | 2096200.30133 | 37.7367128395304 | -122.384154590289 | (37.7367128395304, -122.384154590289) | ||||
| 29345 | 29345 | 196269 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016851.53049 | 2096187.80946 | 37.7366779736991 | -122.38418909364599 | (37.7366779736991, -122.384189093646) | ||||
| 64185 | 64185 | 196507 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 65 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016757.4280199995 | 2094967.1096700002 | 37.7333209726796 | -122.384429453683 | (37.7333209726796, -122.384429453683) | |||
| 34005 | 34005 | 196506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016688.4000699995 | 2094936.9316 | 37.7332342924349 | -122.384666003252 | (37.7332342924349, -122.384666003252) | |||
| 28003 | 28003 | 60357 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | |
| 159334 | 159334 | 196508 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 97 Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016637.34398 | 2094986.73553 | 37.7333682203685 | -122.38484598815901 | (37.7333682203685, -122.384845988159) | |||
| 23318 | 23318 | 1917 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 12 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6016599.627230001 | 2095217.01267 | 37.7339984292864 | -122.384992424754 | (37.7339984292864, -122.384992424754) | |||
| 46118 | 46118 | 38580 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1375 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40540 | 6016458.6044 | 2093690.7438 | 37.729799797257 | -122.385373666801 | (37.729799797257, -122.385373666801) | |
| 9424 | 9424 | 16412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
| 9468 | 9468 | 16413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
| 97122 | 97122 | 16435 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1299X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 6016431.7799349995 | 2094795.0104810002 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | ||
| 50238 | 50238 | 116394 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1351 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6016395.7433 | 2093382.8838 | 37.7289509966751 | -122.38556953980199 | (37.7289509966751, -122.385569539802) | |||
| 183509 | 183509 | 88051 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1351 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51061 | 6016378.6669 | 2093395.5533 | 37.728984839756606 | -122.38562945735701 | (37.7289848397566, -122.385629457357) | |
| 112336 | 112336 | 24168 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 95X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 101983 | 101983 | 16450 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1395 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
| 107698 | 107698 | 16451 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1395 Newcomb Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/2009 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
| 149566 | 149566 | 87175 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1414 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50143 | 6016206.1979 | 2094998.2533 | 37.7333759901055 | -122.386337396865 | (37.7333759901055, -122.386337396865) | |
| 152377 | 152377 | 196548 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1828 Illinois St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6016259.97415 | 2100569.45799 | 37.748676359729 | -122.38653980997499 | (37.748676359729, -122.386539809975) | |||
| 147685 | 147685 | 196064 | Undocumented 2 | Prunus spp :: Cherry 84 | 1800 Illinois St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6016257.27394 | 2100629.7145700003 | 37.7488416623195 | -122.386553348372 | (37.7488416623195, -122.386553348372) | |||
| 16482 | 16482 | 11411 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1482 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1992 12:00:00 AM | 6 | 3X4 | 6016167.7351400005 | 2096777.3502099998 | 37.738258902726 | -122.38659438804599 | (37.738258902726, -122.386594388046) | ||
| 16028 | 16028 | 11414 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1486 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6016137.01095 | 2096800.6040700001 | 37.738321052161005 | -122.386702239228 | (37.738321052161, -122.386702239228) | |||
| 15803 | 15803 | 11415 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1486 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016124.41895 | 2096811.6938599998 | 37.7383508053301 | -122.386746549719 | (37.7383508053301, -122.386746549719) | |||
| 58886 | 58886 | 196424 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1427x Innes Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6016113.33147 | 2096777.48422 | 37.7382562587307 | -122.386782500139 | (37.7382562587307, -122.386782500139) | ||||
| 52400 | 52400 | 199862 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1455 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016004.4926 | 2094023.6514 | 37.73068876117671 | -122.38696680587499 | (37.7306887611767, -122.386966805875) | |||
| 76090 | 76090 | 84687 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1514 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50141 | 6016000.88112 | 2096896.45557 | 37.738576703346205 | -122.387179597554 | (37.7385767033462, -122.387179597554) | |
| 131227 | 131227 | 199694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1350 Underwood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6015915.704 | 2092772.4292 | 37.727248236967704 | -122.38718652280701 | (37.7272482369677, -122.387186522807) | |||
| 13866 | 13866 | 10995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016004.21156 | 2097242.6965900003 | 37.7395275952262 | -122.387192226744 | (37.7395275952262, -122.387192226744) | |||
| 34311 | 34311 | 67662 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31263 | 6016003.68231462 | 2097240.31166612 | 37.739521017402 | -122.38719389035101 | (37.739521017402, -122.387193890351) | ||
| 143629 | 143629 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 84 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 173265 | 173265 | 196276 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1514 Innes Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6015988.30327 | 2096906.1918 | 37.738602740517294 | -122.38722376507499 | (37.7386027405173, -122.387223765075) | |||
| 151462 | 151462 | 38551 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1843 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | Permit Number 40519 | 6015881.5256 | 2093201.6545 | 37.728424911733896 | -122.387334607185 | (37.7284249117339, -122.387334607185) | |
| 176269 | 176269 | 38550 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1843 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 4 | Permit Number 40519 | 6015868.3053 | 2093186.7815 | 37.728383341251394 | -122.38737927372298 | (37.7283833412514, -122.387379273723) | |
| 16894 | 16894 | 26124 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1439 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015892.5497 | 2094809.562 | 37.732840515342104 | -122.387408617446 | (37.7328405153421, -122.387408617446) | |||
| 27051 | 27051 | 196337 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015979.32592 | 2099953.2392599997 | 37.7469688106565 | -122.38746731498199 | (37.7469688106565, -122.387467314982) | ||||
| 186723 | 186723 | 196338 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015971.97004 | 2099951.82403 | 37.7469645173129 | -122.387492652478 | (37.7469645173129, -122.387492652478) | ||||
| 179258 | 179258 | 196339 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6015967.11689 | 2099936.1121799997 | 37.7469211070262 | -122.387508338452 | (37.7469211070262, -122.387508338452) | |||
| 36595 | 36595 | 196340 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6015958.58897 | 2099937.15281 | 37.7469234920398 | -122.387537900079 | (37.7469234920398, -122.387537900079) | |||
| 149041 | 149041 | 46629 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1490 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 7 | Permit Number 44750 | 6015847.6531 | 2095265.1212 | 37.734088902667104 | -122.38759560956001 | (37.7340889026671, -122.38759560956) | |
| 182120 | 182120 | 200751 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1419 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015822.8195 | 2094514.1504 | 37.7320255121303 | -122.387629091574 | (37.7320255121303, -122.387629091574) | |||
| 50115 | 50115 | 46630 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1494 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 4 | Permit Number 44751 | 6015833.2108 | 2095276.4238 | 37.7341191373642 | -122.387646329853 | (37.7341191373642, -122.387646329853) | |
| 181173 | 181173 | 60368 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1423 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 6 | Permit Number 19946 | 6015801.9343 | 2094530.6388 | 37.7320696291014 | -122.387702446866 | (37.7320696291014, -122.387702446866) | |
| 54947 | 54947 | 38600 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1473 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40551 | 6015747.1184 | 2093869.8344 | 37.7302521558979 | -122.38784586741801 | (37.7302521558979, -122.387845867418) | |
| 59112 | 59112 | 40021 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1530 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41266 | 6015759.6141 | 2095683.1757 | 37.73523191912879 | -122.387929152323 | (37.7352319191288, -122.387929152323) | |
| 70989 | 70989 | 196341 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015838.55119 | 2099899.27486 | 37.7468128376585 | -122.387950340845 | (37.7468128376585, -122.387950340845) | ||||
| 161815 | 161815 | 196342 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015828.19689 | 2099862.61894 | 37.7467116144672 | -122.38798358786501 | (37.7467116144672, -122.387983587865) | ||||
| 63659 | 63659 | 38558 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1534 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40523 | 6015743.77247492 | 2095689.90327715 | 37.735249514063895 | -122.38798439240601 | (37.7352495140639, -122.387984392406) | ||
| 159636 | 159636 | 40022 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | |
| 77246 | 77246 | 60388 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1454 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 1 | Permit Number 19968 | 6015694.2103 | 2094682.8814 | 37.7324816889757 | -122.388085495957 | (37.7324816889757, -122.388085495957) | |
| 74643 | 74643 | 88044 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1527 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51056 | 6015719.2528800005 | 2096684.2880400002 | 37.737978534576605 | -122.388138539286 | (37.7379785345766, -122.388138539286) | |
| 50322 | 50322 | 88043 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1527 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51056 | 6015705.98557 | 2096695.57507 | 37.7380087913713 | -122.38818519881 | (37.7380087913713, -122.38818519881) | |
| 184636 | 184636 | 199678 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1400x Underwood Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6015628.2568 | 2092949.4044 | 37.72771825330071 | -122.388192580507 | (37.7277182533007, -122.388192580507) | |||
| 152517 | 152517 | 196065 | Undocumented 2 | Prunus spp :: Cherry 84 | 602 Arthur Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015745.278940001 | 2099859.59173 | 37.7466987082831 | -122.388270101098 | (37.7466987082831, -122.388270101098) | ||||
| 133460 | 133460 | 196469 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Cesar Chavez St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015764.4296 | 2101073.59632 | 37.750033173207 | -122.388288593857 | (37.750033173207, -122.388288593857) | |||
| 47512 | 47512 | 196066 | Undocumented 2 | Prunus spp :: Cherry 84 | 602 Arthur Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015729.65904 | 2099863.28866 | 37.7467079937826 | -122.38832437158999 | (37.7467079937826, -122.38832437159) | ||||
| 52252 | 52252 | 88047 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1547 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51057 | 6015649.6033 | 2096737.02814 | 37.7381194889247 | -122.388383034362 | (37.7381194889247, -122.388383034362) | |
| 55696 | 55696 | 196277 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1547 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015638.97442 | 2096745.3057 | 37.738141628436296 | -122.38842036162501 | (37.7381416284363, -122.388420361625) | |||
| 104746 | 104746 | 52158 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1418 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | Permit Number 48350 | 6015559.23625291 | 2093031.45294248 | 37.727939717782895 | -122.388436912151 | (37.7279397177829, -122.388436912151) | ||
| 68337 | 68337 | 196343 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6015689.423719999 | 2099879.91957 | 37.7467514292439 | -122.388464663129 | (37.7467514292439, -122.388464663129) | ||||
| 31178 | 31178 | 88045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1547 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51057 | 6015625.12405 | 2096754.45465 | 37.7381659820759 | -122.388468888121 | (37.7381659820759, -122.388468888121) | |
| 127102 | 127102 | 27759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.817910201 | 2101113.2850563 | 37.750139234821 | -122.38847329943701 | (37.750139234821, -122.388473299437) | ||
| 131586 | 131586 | 196344 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015666.28786 | 2099877.42762 | 37.7467433047611 | -122.38854449143801 | (37.7467433047611, -122.388544491438) | ||||
| 51189 | 51189 | 196345 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015663.1317300005 | 2099868.27306 | 37.7467179933348 | -122.388554766215 | (37.7467179933348, -122.388554766215) | ||||
| 60619 | 60619 | 197886 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6015689.86816 | 2101943.47037 | 37.7524175331559 | -122.388607147206 | (37.7524175331559, -122.388607147206) | |||
| 186864 | 186864 | 197885 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6015684.0853699995 | 2101943.48621 | 37.7524172561691 | -122.388627146329 | (37.7524172561691, -122.388627146329) | |||
| 3644 | 3644 | 196082 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015721.57305 | 2103923.0720900004 | 37.7578548576382 | -122.388635680008 | (37.7578548576382, -122.388635680008) | |||
| 58653 | 58653 | 197884 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6015678.84769 | 2101942.9496400002 | 37.7524154925876 | -122.388645221797 | (37.7524154925876, -122.388645221797) | |||
| 181397 | 181397 | 197883 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6015671.68668 | 2101942.82757 | 37.752414760540105 | -122.388669977447 | (37.7524147605401, -122.388669977447) | |||
| 173545 | 173545 | 197882 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6015650.38756 | 2101941.3683 | 37.752409573246396 | -122.388743532098 | (37.7524095732464, -122.388743532098) | |||
| 151967 | 151967 | 196468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015629.24905 | 2101065.86664 | 37.7500044578413 | -122.38875552004801 | (37.7500044578413, -122.388755520048) | |||
| 41368 | 41368 | 197881 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6015646.32257 | 2101941.32655 | 37.75240923331361 | -122.38875758671101 | (37.7524092333136, -122.388757586711) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");