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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6813 | 256911 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
| 1115 | 238053 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 426 Lily St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6004459.53739 | 2109991.59452 | 37.7738869854343 | -122.428016956418 | (37.7738869854343, -122.428016956418) | 7 | 9 | 11 | 28852 | 10 | |||
| 3867 | 33659 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 545 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 8 | Permit Number 37747 | 6004792.43502 | 2110705.04365 | 37.7758647708832 | -122.426916230306 | (37.7758647708832, -122.426916230306) | 7 | 9 | 11 | 28852 | 10 | |
| 6608 | 47030 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.7722281991235 | -122.424230399247 | (37.7722281991235, -122.424230399247) | 7 | 9 | 11 | 28852 | 10 | ||
| 8391 | 238054 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 432 Lily St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004439.8336 | 2109989.04683 | 37.7738788753301 | -122.428084933487 | (37.7738788753301, -122.428084933487) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 18621 | 238048 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6004553.97154 | 2110004.04883 | 37.7739265241283 | -122.427691180609 | (37.7739265241283, -122.427691180609) | 7 | 9 | 11 | 28852 | 10 | |||
| 22117 | 238046 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6004578.89431 | 2110007.96592 | 37.7739386892479 | -122.427605247709 | (37.7739386892479, -122.427605247709) | 7 | 9 | 11 | 28852 | 10 | |||
| 22969 | 103049 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 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 | ||
| 28308 | 237185 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 78 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004315.99922 | 2108931.71426 | 37.7709686907843 | -122.428437919182 | (37.7709686907843, -122.428437919182) | 7 | 9 | 11 | 28852 | 10 | |||
| 29810 | 51964 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 624 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/2005 12:00:00 AM | Permit Number 48186 | 6004986.46742486 | 2111098.21623731 | 37.7769552960255 | -122.426273020817 | (37.7769552960255, -122.426273020817) | 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 | |||
| 33834 | 238052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 426 Lily St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6004475.89025 | 2109993.473 | 37.7738930684378 | -122.42796052306 | (37.7738930684378, -122.42796052306) | 7 | 9 | 11 | 28852 | 10 | |||
| 35727 | 238050 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6004531.27247 | 2110000.08562 | 37.7739143581026 | -122.427769418044 | (37.7739143581026, -122.427769418044) | 7 | 9 | 11 | 28852 | 10 | |||
| 39361 | 82980 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 535-537 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52398 | 6004842.87299878 | 2110699.22399126 | 37.7758516433121 | -122.426741337783 | (37.7758516433121, -122.426741337783) | 7 | 9 | 11 | 28852 | 10 | ||
| 39680 | 237014 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 4 | : | Tree | Private 2 | 5 | Width 2ft | 6004527.81122 | 2109977.01256 | 37.7738508093129 | -122.427779746755 | (37.7738508093129, -122.427779746755) | 7 | 9 | 11 | 28852 | 10 | |||
| 48274 | 103042 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 450X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | 7 | 9 | 11 | 28852 | 10 | |||
| 49146 | 104249 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St Frontage East | 3 | 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 | |||
| 49196 | 238049 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6004542.42912 | 2110001.70207 | 37.7739194275845 | -122.427730940528 | (37.7739194275845, -122.427730940528) | 7 | 9 | 11 | 28852 | 10 | |||
| 49777 | 47033 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.7722281991235 | -122.424230399247 | (37.7722281991235, -122.424230399247) | 7 | 9 | 11 | 28852 | 10 | ||
| 50233 | 237038 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Octavia St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6005608.42983 | 2109742.33589 | 37.773267513529 | -122.424025015163 | (37.773267513529, -122.424025015163) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 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 | |||
| 54770 | 237029 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 10 | : | Tree | Private 2 | 3 | Width 6ft | 6005753.2097 | 2109536.23847 | 37.7727097926437 | -122.423509546241 | (37.7727097926437, -122.423509546241) | 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 | |||
| 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 | |||
| 73822 | 237021 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 509 Hickory St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6004431.83065 | 2110307.63972 | 37.7747532007429 | -122.428135326097 | (37.7747532007429, -122.428135326097) | 7 | 9 | 11 | 28852 | 10 | |||
| 73934 | 104256 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 10 | 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 | |||
| 74420 | 238491 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 151 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006355.34413 | 2110387.19122 | 37.7750802724623 | -122.421487139129 | (37.7750802724623, -122.421487139129) | 7 | 9 | 11 | 28852 | 10 | |||
| 77514 | 238490 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 151 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006307.18834 | 2110382.81943 | 37.7750655532558 | -122.421653410291 | (37.7750655532558, -122.421653410291) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 79153 | 47019 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 380 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2002 12:00:00 AM | Permit Number 45014 | 6004716.89647578 | 2110040.09694572 | 37.7740347181094 | -122.427130164093 | (37.7740347181094, -122.427130164093) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 83349 | 33813 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 261 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | 6 | Permit Number 37827 | 6006152.11101 | 2110895.22751 | 37.7764637562375 | -122.422226270344 | (37.7764637562375, -122.422226270344) | 7 | 9 | 11 | 28852 | 10 | ||
| 83624 | 33812 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 261 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/1996 12:00:00 AM | 5 | Permit Number 37827 | 6006136.86682 | 2110893.01835 | 37.776456830551 | -122.422278847415 | (37.776456830551, -122.422278847415) | 7 | 9 | 11 | 28852 | 10 | |
| 84440 | 30682 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 425 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Permit Number 782764 | 6004593.18284 | 2110062.14173 | 37.7740882510028 | -122.427559681752 | (37.7740882510028, -122.427559681752) | 7 | 9 | 11 | 28852 | 10 | |
| 86715 | 47032 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.7722281991235 | -122.424230399247 | (37.7722281991235, -122.424230399247) | 7 | 9 | 11 | 28852 | 10 | ||
| 86720 | 238056 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 439 Lily St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6004411.75821 | 2109960.94242 | 37.7738001190119 | -122.428180047573 | (37.7738001190119, -122.428180047573) | 7 | 9 | 11 | 28852 | 10 | |||
| 87406 | 33649 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 541 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37740 | 6004806.91261 | 2110706.66354 | 37.7758700373021 | -122.426866263978 | (37.7758700373021, -122.426866263978) | 7 | 9 | 11 | 28852 | 10 | ||
| 87661 | 238488 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Lily St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006273.57752 | 2110244.12778 | 37.7746828440634 | -122.42175982435 | (37.7746828440634, -122.42175982435) | 7 | 9 | 11 | 28852 | 10 | |||
| 89833 | 51966 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 624 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/2005 12:00:00 AM | Permit Number 48186 | 6004986.46742486 | 2111098.21623731 | 37.7769552960255 | -122.426273020817 | (37.7769552960255, -122.426273020817) | 7 | 9 | 11 | 28852 | 10 | ||
| 89932 | 104250 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8x Octavia St Frontage East | 4 | 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 | |||
| 99348 | 237011 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 1 | : | Tree | Private 2 | 11 | Width 2ft | 6004491.59652 | 2109971.54016 | 37.7738337347625 | -122.427904629301 | (37.7738337347625, -122.427904629301) | 7 | 9 | 11 | 28852 | 10 | |||
| 99924 | 47001 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 127 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45001 | 6004764.4 | 2108902.6 | 37.7709141138756 | -122.426884813577 | (37.7709141138756, -122.426884813577) | 7 | 9 | 11 | 28852 | 10 | ||
| 101441 | 238485 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Lily St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006368.40748 | 2110255.5826 | 37.77471964342 | -122.421432601534 | (37.77471964342, -122.421432601534) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 102903 | 237013 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 3 | : | Tree | Private 2 | 8 | Width 2ft | 6004515.0923 | 2109975.33135 | 37.7738454736228 | -122.427823623763 | (37.7738454736228, -122.427823623763) | 7 | 9 | 11 | 28852 | 10 | |||
| 105662 | 238492 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 151 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006395.8599 | 2110394.0176 | 37.7751013004086 | -122.421347470809 | (37.7751013004086, -122.421347470809) | 7 | 9 | 11 | 28852 | 10 | |||
| 108764 | 103040 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 450X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | 7 | 9 | 11 | 28852 | 10 | |||
| 108824 | 30684 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 425 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Permit Number 782764 | 6004595.56145 | 2110044.99198 | 37.7740412965118 | -122.427550231668 | (37.7740412965118, -122.427550231668) | 7 | 9 | 11 | 28852 | 10 | |
| 109985 | 238489 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Lily St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006240.43536 | 2110240.59642 | 37.7746712787972 | -122.421874219038 | (37.7746712787972, -122.421874219038) | 7 | 9 | 11 | 28852 | 10 | |||
| 111215 | 47002 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 133 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/25/2005 12:00:00 AM | Permit Number 45001 | 6004750.78049806 | 2108920.69040717 | 37.7709630156683 | -122.426933212426 | (37.7709630156683, -122.426933212426) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 116801 | 94562 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 251X OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005545 | 2110135 | 37.774342092867 | -122.424272360307 | (37.774342092867, -122.424272360307) | 7 | 9 | 11 | 28852 | 10 | |||
| 119462 | 237040 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Octavia St | 3 | : | Tree | Private 2 | 5 | Width 4ft | 6005610.09761 | 2109720.52403 | 37.7732077175873 | -122.424017694677 | (37.7732077175873, -122.424017694677) | 7 | 9 | 11 | 28852 | 10 | |||
| 122924 | 30598 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 66 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 12 | Permit Number 34565 | 6004323.10435 | 2108874.18954 | 37.7708111439393 | -122.428409241587 | (37.7708111439393, -122.428409241587) | 7 | 9 | 11 | 28852 | 10 | |
| 123336 | 238057 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 413 Lily St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6004461.64769 | 2109967.10473 | 37.7738198618406 | -122.428007911041 | (37.7738198618406, -122.428007911041) | 7 | 9 | 11 | 28852 | 10 | |||
| 123557 | 246593 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6005556.53311 | 2109286.77456 | 37.7720137218797 | -122.424172128036 | (37.7720137218797, -122.424172128036) | 7 | 9 | 11 | 28852 | 10 | |||
| 131106 | 237030 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 4 | : | Tree | DPW 1 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.7732508616652 | -122.423617927146 | (37.7732508616652, -122.423617927146) | 7 | 9 | 11 | 28852 | 10 | |||
| 131435 | 237032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 6 | : | Tree | Private 2 | 5 | Width 4ft | 6005721.49565 | 2109758.3052 | 37.7733177442556 | -122.423635040324 | (37.7733177442556, -122.423635040324) | 7 | 9 | 11 | 28852 | 10 | |||
| 132330 | 238055 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 438 Lily St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6004413.04242 | 2109984.42979 | 37.7738646822544 | -122.428177279482 | (37.7738646822544, -122.428177279482) | 7 | 9 | 11 | 28852 | 10 | |||
| 132418 | 47031 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.7722281991235 | -122.424230399247 | (37.7722281991235, -122.424230399247) | 7 | 9 | 11 | 28852 | 10 | ||
| 134398 | 246594 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6005538.63737 | 2109282.04946 | 37.7719997374372 | -122.424233694733 | (37.7719997374372, -122.424233694733) | 7 | 9 | 11 | 28852 | 10 | |||
| 136415 | 237037 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 129 Octavia St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6005605.52362 | 2109755.39176 | 37.7733031977155 | -122.424035996776 | (37.7733031977155, -122.424035996776) | 7 | 9 | 11 | 28852 | 10 | |||
| 136737 | 237034 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 150 Octavia St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6005711.67822 | 2109842.25548 | 37.7735476972984 | -122.423674970241 | (37.7735476972984, -122.423674970241) | 7 | 9 | 11 | 28852 | 10 | |||
| 137716 | 240126 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006399.28254 | 2110261.0751 | 37.7747364652596 | -122.421326188373 | (37.7747364652596, -122.421326188373) | 7 | 9 | 11 | 28852 | 10 | |||
| 140690 | 238486 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Lily St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006336.80273 | 2110252.01922 | 37.7747080772398 | -122.421541675834 | (37.7747080772398, -122.421541675834) | 7 | 9 | 11 | 28852 | 10 | |||
| 141008 | 103080 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 445 Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005464 | 2110963 | 37.7766110057417 | -122.424611466414 | (37.7766110057417, -122.424611466414) | 7 | 9 | 11 | 28852 | 10 | |||
| 141395 | 47018 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 231 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45013 | 6005433.67080173 | 2110087.35394876 | 37.7742049814645 | -122.424654078961 | (37.7742049814645, -122.424654078961) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 148691 | 238047 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6004564.74999 | 2110005.30362 | 37.7739305791617 | -122.427653985566 | (37.7739305791617, -122.427653985566) | 7 | 9 | 11 | 28852 | 10 | |||
| 149691 | 246595 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 52 Waller St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005513.49124 | 2109280.44319 | 37.7719939071131 | -122.424320562945 | (37.7719939071131, -122.424320562945) | 7 | 9 | 11 | 28852 | 10 | |||
| 151970 | 51967 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 624 Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/2005 12:00:00 AM | Permit Number 48186 | 6004986.46742486 | 2111098.21623731 | 37.7769552960255 | -122.426273020817 | (37.7769552960255, -122.426273020817) | 7 | 9 | 11 | 28852 | 10 | ||
| 153484 | 42781 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52594 | 6005188.63098476 | 2109645.76261136 | 37.7729786366348 | -122.425470283277 | (37.7729786366348, -122.425470283277) | 7 | 9 | 11 | 28852 | 10 | ||
| 159452 | 237012 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6004502.75117 | 2109973.05936 | 37.7738385371506 | -122.427866151824 | (37.7738385371506, -122.427866151824) | 7 | 9 | 11 | 28852 | 10 | |||
| 159989 | 47017 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 225 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45012 | 6005461.20832632 | 2110091.18652684 | 37.7742170599864 | -122.424559094315 | (37.7742170599864, -122.424559094315) | 7 | 9 | 11 | 28852 | 10 | ||
| 160692 | 30599 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 82 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 8 | 5x7 | Permit Number 34566 | 6004311.30995 | 2108965.65965 | 37.771061631219 | -122.428456559416 | (37.771061631219, -122.428456559416) | 7 | 9 | 11 | 28852 | 10 |
| 165233 | 104251 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 5 | 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 | |||
| 166480 | 103078 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 445 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005464 | 2110963 | 37.7766110057417 | -122.424611466414 | (37.7766110057417, -122.424611466414) | 7 | 9 | 11 | 28852 | 10 | |||
| 168426 | 237015 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 5 | : | Tree | Private 2 | 4 | Width 2ft | 6004541.71287 | 2109979.25241 | 37.7738577457794 | -122.427731818294 | (37.7738577457794, -122.427731818294) | 7 | 9 | 11 | 28852 | 10 | |||
| 170909 | 237039 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Octavia St | 2 | : | Tree | Private 2 | 7 | Width 4ft | 6005609.24206 | 2109730.37641 | 37.7732347215415 | -122.424021354908 | (37.7732347215415, -122.424021354908) | 7 | 9 | 11 | 28852 | 10 | |||
| 174481 | 47000 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 127 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45000 | 6004753.51907903 | 2108901.08928055 | 37.7709093505683 | -122.426922343371 | (37.7709093505683, -122.426922343371) | 7 | 9 | 11 | 28852 | 10 | ||
| 178694 | 237031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 5 | : | Tree | Private 2 | 5 | Width 4ft | 6005723.44032 | 2109745.94906 | 37.773283927046 | -122.423627434762 | (37.773283927046, -122.423627434762) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 183687 | 246596 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 52 Waller St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6005499.23386 | 2109278.37719 | 37.7719874292938 | -122.424369733388 | (37.7719874292938, -122.424369733388) | 7 | 9 | 11 | 28852 | 10 | |||
| 185269 | 103079 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 445 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005464 | 2110963 | 37.7766110057417 | -122.424611466414 | (37.7766110057417, -122.424611466414) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 187006 | 51965 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 624 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/2005 12:00:00 AM | Permit Number 48186 | 6004986.46742486 | 2111098.21623731 | 37.7769552960255 | -122.426273020817 | (37.7769552960255, -122.426273020817) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 189198 | 47005 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 124 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45003 | 6004800.11223501 | 2108943.4032863 | 37.77102816901 | -122.426764190216 | (37.77102816901, -122.426764190216) | 7 | 9 | 5 | 28852 | 10 | |||
| 194058 | 30683 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 425 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Permit Number 782764 | 6004598.67244 | 2110025.49511 | 37.773987938825 | -122.42753808092 | (37.773987938825, -122.42753808092) | 7 | 9 | 11 | 28852 | 10 | |
| 1029 | 65280 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 435 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28085 | 6011091.92612 | 2112217.73363 | 37.7803724445696 | -122.405231107147 | (37.7803724445696, -122.405231107147) | 14 | 2 | 9 | 28853 | 34 | |
| 3725 | 73662 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 828 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011416.18719 | 2109390.39573 | 37.7726273509159 | -122.403910314231 | (37.7726273509159, -122.403910314231) | 14 | 2 | 9 | 28853 | 34 | |||
| 6764 | 95833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 520 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767565 | 6010212.70231 | 2112022.42286 | 37.7797869733249 | -122.408258986859 | (37.7797869733249, -122.408258986859) | 14 | 2 | 9 | 28853 | 34 |
| 8641 | 41286 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 494 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52403 | 6005499.65147882 | 2107857.73967205 | 37.7680867232876 | -122.424267232407 | (37.7680867232876, -122.424267232407) | 8 | 4 | 5 | 28853 | 19 | ||
| 9518 | 65278 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 415 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28081 | 6011215.3927 | 2112332.46737 | 37.7806943784819 | -122.40481205634 | (37.7806943784819, -122.40481205634) | 14 | 2 | 9 | 28853 | 34 | |
| 10348 | 91136 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 480 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2009 12:00:00 AM | 3x3 | Permit Number 52024 | 6005604 | 2107874.4 | 37.7681383601012 | -122.423907486341 | (37.7681383601012, -122.423907486341) | 8 | 4 | 5 | 28853 | 19 | ||
| 20340 | 238038 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Elgin Park | 3 | : | Tree | Private 2 | 5 | Width 2ft | 6005844.52457 | 2108573.0044 | 37.7700701367551 | -122.423125198471 | (37.7700701367551, -122.423125198471) | 8 | 2 | 5 | 28853 | 19 |
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) );