trees
4,014 rows where qSpecies_id = 40 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1549 | 239487 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 500 Andover St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007556.24914 | 2097139.11134 | 37.7387717222454 | -122.416394353017 | (37.7387717222454, -122.416394353017) | 2 | 7 | 7 | 28859 | 2 | |||
| 10602 | 104255 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 37382 | 239402 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 338 Hoffman Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6000616.75777 | 2101741.19606 | 37.7510152688496 | -122.440717808276 | (37.7510152688496, -122.440717808276) | 2 | 4 | 5 | 28862 | 22 | |||
| 57981 | 110511 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
| 82657 | 4137 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3550 Cesar Chavez St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2000 12:00:00 AM | 3 | 3x3 | 6006233.57538 | 2100604.08317 | 37.7482112843407 | -122.421213523093 | (37.7482112843407, -122.421213523093) | 2 | 4 | 5 | 28859 | 19 | ||
| 116909 | 238353 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 737 Sanchez St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003694.73227 | 2104140.3391 | 37.757777553703 | -122.430245012403 | (37.757777553703, -122.430245012403) | 2 | 4 | 5 | 28862 | 3 | |||
| 124105 | 238042 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 38 Dolores St | 9 | : | Tree | Private 2 | 2 | Width 4ft | 6004734.59668 | 2107939.64619 | 37.7682683900123 | -122.426919311396 | (37.7682683900123, -122.426919311396) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 140300 | 136005 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1237x Robert C Levy Tunl | 9 | Median : Yard | Tree | DPW 1 | 3 | 6007661.46268 | 2118150.4985 | 37.7964699809712 | -122.417519302367 | (37.7964699809712, -122.417519302367) | 5 | 1 | 10 | 28858 | 32 | ||||
| 153317 | 137540 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1510 Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002670.5536 | 2113409.7602 | 37.7831710382055 | -122.434449780345 | (37.7831710382055, -122.434449780345) | 13 | 9 | 11 | 29490 | 41 | |||
| 158690 | 135917 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2350 Green St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6001679.33795 | 2118057.34258 | 37.7958757853901 | -122.438212029083 | (37.7958757853901, -122.438212029083) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | ||||
| 189928 | 8486 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1900X Geary Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6002632.5922648 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | 13 | 9 | 11 | 29490 | 13 | ||
| 191235 | 88420 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 9 | 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 | ||
| 7115 | 4034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2150 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/1995 12:00:00 AM | 3 | 3X3 | 6012617.9559004 | 2100994.1740901 | 37.7496402484926 | -122.399163766262 | (37.7496402484926, -122.399163766262) | 10 | 3 | 8 | 58 | 1 | ||
| 24698 | 8097 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 762 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004143.8911021 | 2111521.3201229 | 37.7780693729621 | -122.4292179278 | (37.7780693729621, -122.4292179278) | 7 | 9 | 11 | 28852 | 41 | ||
| 30894 | 237389 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3100 25th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008835.28321 | 2101547.20536 | 37.7509472180458 | -122.412283514173 | (37.7509472180458, -122.412283514173) | 2 | 4 | 7 | 28859 | 19 | |||
| 41999 | 27517 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1212 Guerrero St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005756.59865 | 2101732.46517 | 37.7512826606677 | -122.422943082157 | (37.7512826606677, -122.422943082157) | 2 | 4 | 5 | 28859 | 19 | ||
| 54306 | 237027 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 8 | : | Tree | Private 2 | 5 | Width 6ft | 6005758.33223 | 2109504.65873 | 37.7726233714135 | -122.423489581302 | (37.7726233714135, -122.423489581302) | 7 | 9 | 11 | 28852 | 10 | |||
| 62471 | 238433 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 272 Corbett Ave | 8 | Side Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 5999629.67276 | 2105348.17571 | 37.7608628875441 | -122.444390425487 | (37.7608628875441, -122.444390425487) | 15 | 5 | 5 | 28862 | 3 | |||
| 63494 | 196467 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Cesar Chavez St | 8 | : | Tree | Private 2 | 4 | Width 3ft | 6015482.81101 | 2101057.86709 | 37.7499743755266 | -122.389261356351 | (37.7499743755266, -122.389261356351) | 10 | 3 | 8 | 58 | 1 | |||
| 83109 | 238487 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Lily St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006307.15117 | 2110249.94796 | 37.7747007180984 | -122.42164409961 | (37.7747007180984, -122.42164409961) | 7 | 9 | 11 | 28852 | 10 | |||
| 89850 | 237067 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3425 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006787.74358 | 2100522.77101 | 37.7480192458088 | -122.419291455163 | (37.7480192458088, -122.419291455163) | 2 | 4 | 7 | 28859 | 2 | |||
| 104145 | 110510 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
| 118140 | 237046 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1650 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009426.03353 | 2107014.04663 | 37.7659910592617 | -122.410626650002 | (37.7659910592617, -122.410626650002) | 8 | 4 | 7 | 28853 | 19 | |||
| 120104 | 4090 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3215 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1995 12:00:00 AM | 6 | 3X3 | 6008246.07333 | 2100530.81306 | 37.7481233522135 | -122.414249161492 | (37.7481233522135, -122.414249161492) | 2 | 4 | 7 | 28859 | 2 | ||
| 127879 | 238352 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 737 Sanchez St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003693.5654 | 2104120.4185 | 37.7577227903793 | -122.430247626748 | (37.7577227903793, -122.430247626748) | 2 | 4 | 5 | 28862 | 3 | |||
| 130424 | 237424 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4301 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001903.00903 | 2100295.23121 | 37.7471181583961 | -122.436166365499 | (37.7471181583961, -122.436166365499) | 2 | 4 | 5 | 63 | 22 | |||
| 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 | ||
| 185536 | 104254 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 190498 | 239401 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 338 Hoffman Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6000615.63827 | 2101746.41589 | 37.7510295374914 | -122.440722053988 | (37.7510295374914, -122.440722053988) | 2 | 4 | 5 | 28862 | 22 | |||
| 131633 | 115503 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2901 25th St | 72 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.7511727251881 | -122.408119020981 | (37.7511727251881, -122.408119020981) | 2 | 4 | 7 | 28859 | 19 | |
| 21117 | 214508 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1961 11th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5992833.56281 | 2102184.357 | 37.7517857621057 | -122.467664866564 | (37.7517857621057, -122.467664866564) | 1 | 8 | 4 | 29491 | 12 | |||
| 21230 | 213396 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 850 Quintara St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990723.50511 | 2101134.13324 | 37.7487800641658 | -122.474885006136 | (37.7487800641658, -122.474885006136) | 1 | 8 | 4 | 29491 | 12 | |||
| 30595 | 237093 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006628.38963 | 2107330.3055 | 37.7667021837902 | -122.420325599041 | (37.7667021837902, -122.420325599041) | 8 | 4 | 7 | 28853 | 19 | |||
| 31057 | 237423 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4301 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001886.4331 | 2100294.85625 | 37.7471161870731 | -122.43622365679 | (37.7471161870731, -122.43622365679) | 2 | 4 | 5 | 63 | 22 | |||
| 36307 | 237111 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2x Coso Ave | 7 | Median : Yard | Tree | DPW 1 | 2 | 6007125.29232 | 2099860.06971 | 37.7462186223039 | -122.418077248072 | (37.7462186223039, -122.418077248072) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||||
| 54764 | 237017 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 7 | : | Tree | Private 2 | 8 | Width 2ft | 6004569.305 | 2109982.95925 | 37.7738694846242 | -122.427636636743 | (37.7738694846242, -122.427636636743) | 7 | 9 | 11 | 28852 | 10 | |||
| 55857 | 237026 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 7 | : | Tree | Private 2 | 3 | Width 6ft | 6005759.75569 | 2109493.68206 | 37.7725933124646 | -122.423483876889 | (37.7725933124646, -122.423483876889) | 7 | 9 | 11 | 28852 | 10 | |||
| 56781 | 135965 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2574 Broadway | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6001290.6793 | 2117307.18376 | 37.7937939330834 | -122.439503056242 | (37.7937939330834, -122.439503056242) | 13 | 9 | 1 | 57 | 27 | |||
| 74065 | 27516 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1212 Guerrero St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005758.28533 | 2101749.68479 | 37.7513300369518 | -122.422938473144 | (37.7513300369518, -122.422938473144) | 2 | 4 | 5 | 28859 | 19 | ||
| 78950 | 237033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 7 | : | Tree | DPW 1 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | 7 | 9 | 11 | 28852 | 10 | |||
| 85004 | 239479 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 251 Alma St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997609.51363 | 2106133.00912 | 37.7629023727565 | -122.45143383661 | (37.7629023727565, -122.45143383661) | 15 | 5 | 11 | 29492 | 9 | |||
| 114466 | 237045 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1650 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009424.6793 | 2107033.19319 | 37.7660435553884 | -122.41063268625 | (37.7660435553884, -122.41063268625) | 8 | 4 | 7 | 28853 | 19 | |||
| 122179 | 110509 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
| 124323 | 196466 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Cesar Chavez St | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6015450.2681 | 2101056.0343 | 37.7499675388841 | -122.389373764399 | (37.7499675388841, -122.389373764399) | 10 | 3 | 8 | 58 | 1 | |||
| 126258 | 135921 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2495 Filbert St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001125.35407 | 2118620.11363 | 37.797389483787 | -122.440169289291 | (37.797389483787, -122.440169289291) | 13 | 9 | 1 | 57 | 17 | |||
| 127559 | 213360 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 Elmhurst Dr | 7 | : | Tree | Private 2 | 3 | Width 3ft | 5991212.62572 | 2094437.93395 | 37.7304223444182 | -122.472705478494 | (37.7304223444182, -122.472705478494) | 9 | 8 | 4 | 64 | 40 | |||
| 128959 | 213671 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 120 Edgehill Way | 7 | Front Yard : Yard | Tree | Private 2 | 6 | Width 3ft | 5994885.50886 | 2098943.91671 | 37.7430065910919 | -122.460334245238 | (37.7430065910919, -122.460334245238) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | ||
| 139259 | 238041 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 38 Dolores St | 7 | : | Tree | Private 2 | 2 | Width 4ft | 6004732.58551 | 2107964.89474 | 37.7683376027325 | -122.426928066278 | (37.7683376027325, -122.426928066278) | 8 | 4 | 5 | 28862 | 3 | |||
| 145221 | 103081 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 445 Octavia St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005464 | 2110963 | 37.7766110057417 | -122.424611466414 | (37.7766110057417, -122.424611466414) | 7 | 9 | 11 | 28852 | 10 | |||
| 147096 | 196495 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 728 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012138.91764 | 2110082.47387 | 37.7745679907399 | -122.401458945783 | (37.7745679907399, -122.401458945783) | 14 | 2 | 9 | 28853 | 34 | |||
| 159148 | 237388 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3100 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008822.57979 | 2101547.71816 | 37.7509479132318 | -122.412327480227 | (37.7509479132318, -122.412327480227) | 2 | 4 | 7 | 28859 | 19 | |||
| 160931 | 238351 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 737 Sanchez St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003693.25503 | 2104105.37257 | 37.7576814602529 | -122.43024762673 | (37.7576814602529, -122.43024762673) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 173245 | 4124 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3435 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6006760.09222 | 2100373.98133 | 37.7476091457032 | -122.419376518884 | (37.7476091457032, -122.419376518884) | 2 | 7 | 7 | 28859 | 2 | ||
| 181673 | 103052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
| 183446 | 22527 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 6600 03rd St | 7 | Median : Cutout | Tree | DPW 1 | 3 | 3X3 | 6012847.5284056 | 2089784.7633559 | 37.7188743244909 | -122.397583806576 | (37.7188743244909, -122.397583806576) | 10 | 3 | 8 | 58 | 1 | |||
| 184890 | 135939 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Walnut St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998471.02227 | 2116380.33284 | 37.7910881707365 | -122.449192479647 | (37.7910881707365, -122.449192479647) | 13 | 6 | 1 | 54 | 31 | |||
| 187895 | 239399 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 338 Hoffman Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6000615.20196 | 2101754.98366 | 37.751053037676 | -122.44072417729 | (37.751053037676, -122.44072417729) | 2 | 4 | 5 | 28862 | 22 | |||
| 188046 | 104253 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 5639 | 85379 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3390 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6007302.06128 | 2100623.11206 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 16544 | 84392 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2101 Jerrold Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012504.25768 | 2099077.65785 | 37.7443715685998 | -122.399422411225 | (37.7443715685998, -122.399422411225) | 10 | 3 | 8 | 58 | 1 | |||
| 17324 | 91930 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1201X IRVING ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5992070 | 2106573 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | 1 | 8 | 11 | 56 | 12 | ||
| 24376 | 237016 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 6 | : | Tree | Private 2 | 10 | Width 2ft | 6004555.22046 | 2109981.30616 | 37.773864148951 | -122.42768523968 | (37.773864148951, -122.42768523968) | 7 | 9 | 11 | 28852 | 10 | |||
| 31840 | 103051 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
| 32057 | 108634 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | 11 | 6 | 1 | 55 | 33 | |||
| 34471 | 237092 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006640.82063 | 2107331.42339 | 37.766705953729 | -122.420282681595 | (37.766705953729, -122.420282681595) | 8 | 4 | 7 | 28853 | 19 | |||
| 34890 | 196480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1499 Rankin St | 6 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6012679.65409 | 2096682.3113 | 37.737804227083 | -122.39864786201 | (37.737804227083, -122.39864786201) | 10 | 3 | 8 | 58 | 1 | |||
| 38071 | 179104 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 135 Craut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004049.57525 | 2094157.94474 | 37.7303882915845 | -122.42830637085 | (37.7303882915845, -122.42830637085) | 9 | 7 | 6 | 28861 | 5 | |||
| 38945 | 237205 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 300 Valley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003767.75515 | 2099262.24072 | 37.7443875747186 | -122.429644564749 | (37.7443875747186, -122.429644564749) | 2 | 7 | 5 | 63 | 22 | |||
| 42333 | 237115 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Hwy 101 Southbound | 6 | Back Yard : Yard | Tree | Private 2 | 6 | 6005846.05822 | 2108984.84199 | 37.7712010306339 | -122.423149171694 | (37.7712010306339, -122.423149171694) | 8 | 2 | 5 | 28853 | 19 | ||||
| 43195 | 178991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 342 Oneida Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5999304.0712 | 2091408.36096 | 37.7225689094196 | -122.444514648859 | (37.7225689094196, -122.444514648859) | 9 | 7 | 6 | 28861 | 25 | |||
| 53883 | 237387 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3100 25th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008814.66838 | 2101545.8698 | 37.7509423940946 | -122.412354708115 | (37.7509423940946, -122.412354708115) | 2 | 4 | 7 | 28859 | 19 | |||
| 58099 | 135920 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2495 Filbert St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001110.69798 | 2118617.54309 | 37.7973815913536 | -122.440219818601 | (37.7973815913536, -122.440219818601) | 13 | 9 | 1 | 57 | 17 | |||
| 58842 | 213670 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 120 Edgehill Way | 6 | Front Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 5994884.54629 | 2098945.43271 | 37.7430106982792 | -122.460337683337 | (37.7430106982792, -122.460337683337) | 1 | 8 | 4 | 59 | 40 | |||
| 61226 | 237210 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 483 Valley St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6002788.03138 | 2099167.4963 | 37.7440719046074 | -122.43302547424 | (37.7440719046074, -122.43302547424) | 2 | 7 | 5 | 63 | 22 | ||||
| 64169 | 250645 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Lake St | 6 | : | Tree | Private 2 | 1 | Width 3ft | 5987300.52243 | 2114656.77456 | 37.7857105288548 | -122.487714838772 | (37.7857105288548, -122.487714838772) | 11 | 6 | 1 | 55 | 33 | |||
| 64401 | 213573 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Dewey Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5995208.70184 | 2100413.07322 | 37.7470591142869 | -122.459323109585 | (37.7470591142869, -122.459323109585) | 1 | 8 | 4 | 59 | 40 | |||
| 66512 | 28620 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 279 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6000051.9098 | 2091608.73805 | 37.723161742302 | -122.441943920583 | (37.723161742302, -122.441943920583) | 9 | 7 | 6 | 28861 | 25 | |||
| 70990 | 238051 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 6 | : | Tree | Private 2 | 14 | Width 3ft | 6004519.00384 | 2109998.49241 | 37.7739092895156 | -122.427811743735 | (37.7739092895156, -122.427811743735) | 7 | 9 | 11 | 28852 | 10 | |||
| 72636 | 214514 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1201 Irving St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991913.63923 | 2106558.50977 | 37.7637428782486 | -122.471164705988 | (37.7637428782486, -122.471164705988) | 1 | 8 | 11 | 56 | 12 | |||
| 75204 | 213361 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 Elmhurst Dr | 6 | : | Tree | Private 2 | 2 | Width 3ft | 5991216.12738 | 2094471.85178 | 37.7305156769604 | -122.472695844937 | (37.7305156769604, -122.472695844937) | 9 | 8 | 4 | 64 | 40 | |||
| 75617 | 237152 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 601 Hampshire St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6010131.84271 | 2105445.94414 | 37.7617249524607 | -122.408074789522 | (37.7617249524607, -122.408074789522) | 10 | 4 | 8 | 28859 | 19 | |||
| 82028 | 237426 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4301 26th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6001882.89987 | 2100571.76133 | 37.7478763021598 | -122.436255687975 | (37.7478763021598, -122.436255687975) | 2 | 4 | 5 | 63 | 22 | |||
| 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 | ||
| 85683 | 214507 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1961 11th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992840.59438 | 2102195.17889 | 37.7518158822179 | -122.467641337597 | (37.7518158822179, -122.467641337597) | 1 | 8 | 4 | 29491 | 12 | |||
| 87770 | 238372 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 588 Liberty St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002491.08532 | 2103866.93295 | 37.7569585968715 | -122.434388170198 | (37.7569585968715, -122.434388170198) | 2 | 4 | 5 | 28862 | 3 | |||
| 93016 | 178988 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 438 Delano Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999531.66128 | 2091360.09609 | 37.7224493688267 | -122.443724457718 | (37.7224493688267, -122.443724457718) | 9 | 7 | 6 | 28861 | 25 | |||
| 94157 | 87232 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2575X Judah St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/2007 12:00:00 AM | 3x3 | Permit Number 50266 | 5986663 | 2105714 | 37.7611189843543 | -122.4892627097 | (37.7611189843543, -122.4892627097) | 1 | 8 | 3 | 56 | 35 | ||
| 101721 | 237025 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 6 | : | Tree | Private 2 | 3 | Width 6ft | 6005760.04076 | 2109480.81274 | 37.7725579925006 | -122.423481975714 | (37.7725579925006, -122.423481975714) | 7 | 9 | 11 | 28852 | 10 | |||
| 103046 | 4032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2150 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6012617.9559004 | 2100994.1740901 | 37.7496402484926 | -122.399163766262 | (37.7496402484926, -122.399163766262) | 10 | 3 | 8 | 58 | 1 | ||
| 104579 | 4134 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3550 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2000 12:00:00 AM | 3 | 3x3 | 6006304.68418 | 2100605.72758 | 37.7482198080922 | -122.420967747359 | (37.7482198080922, -122.420967747359) | 2 | 4 | 5 | 28859 | 19 | ||
| 111611 | 214810 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 111 Edgehill Way | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994724.24125 | 2098971.31175 | 37.7430725329757 | -122.460893845698 | (37.7430725329757, -122.460893845698) | 1 | 8 | 4 | 59 | 40 | |||
| 115591 | 104252 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 121388 | 196464 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1301 Cesar Chavez St | 6 | : | Tree | Private 2 | 9 | Width 3ft | 6015016.3527 | 2101061.74011 | 37.7499591392145 | -122.390874677125 | (37.7499591392145, -122.390874677125) | 10 | 3 | 8 | 58 | 1 | |||
| 121461 | 237228 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Grattan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997909.87398 | 2106480.5106 | 37.7638737188236 | -122.450420051547 | (37.7638737188236, -122.450420051547) | 15 | 5 | 11 | 29492 | 9 |
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) );