trees
27,746 rows where qCaretaker_id = 1 sorted by Zip Codes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 172 | 176155 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 25 | 10x10 | 5988860 | 2088745 | 37.7146545182747 | -122.480422197946 | (37.7146545182747, -122.480422197946) | 1 | 8 | 4 | 64 | 14 | |||
| 384 | 415 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3862 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2X6 | 5990878.96388 | 2090116.60552 | 37.7185377326944 | -122.473543893183 | (37.7185377326944, -122.473543893183) | 9 | 8 | 4 | 64 | 40 | |||
| 408 | 109629 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200X GELLERT DR | 30 | Median : Cutout | Tree | DPW 1 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||||
| 430 | 121151 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Payson St | 1 | Side Yard : Yard | Tree | DPW 1 | 25 | 3x3 | 5992041 | 2087761 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | 9 | 8 | 4 | 64 | 24 | |||
| 485 | 251655 | DPW Maintained 1 | Shrub :: Shrub 66 | 300x Chester Ave | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5991691 | 2087193 | 37.7105572148468 | -122.470524229297 | (37.7105572148468, -122.470524229297) | 9 | 8 | 4 | 64 | 24 | ||||
| 825 | 175382 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 2 | Width 3ft | 5991305.51807 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | 9 | 8 | 6 | 64 | 24 | |||
| 932 | 111099 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 480X LAKESHORE DR | 20 | Median : Cutout | Tree | DPW 1 | 30x200 | 5984942 | 2095282 | 37.7323749444343 | -122.494445798495 | (37.7323749444343, -122.494445798495) | 1 | 8 | 4 | 64 | 35 | ||||
| 1378 | 95407 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2X Cranleigh Dr | 9 | Median : Yard | Tree | DPW 1 | 80 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | ||||
| 1612 | 11759 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
| 1722 | 19403 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 400X Sloat Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5990261.3597061 | 2096050.1007314 | 37.7347938328013 | -122.47611180944 | (37.7347938328013, -122.47611180944) | 1 | 8 | 3 | 64 | 35 | |||
| 1864 | 102860 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 10X CRANLEIGH DR | 1 | Median : Yard | Tree | DPW 1 | 03/06/2013 12:00:00 AM | 6 | 5991339 | 2095700 | 37.7338949747581 | -122.472360557436 | (37.7338949747581, -122.472360557436) | 1 | 8 | 4 | 64 | 40 | |||
| 2097 | 12450 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
| 2160 | 29663 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2200X Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5991214.62649 | 2094785.74836 | 37.7313774711782 | -122.472723912001 | (37.7313774711782, -122.472723912001) | 1 | 8 | 4 | 64 | 40 | |||
| 2282 | 19424 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | 1 | 8 | 3 | 64 | 35 | |||
| 2496 | 331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3402X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 50 | 2X3 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 3113 | 2257 | DPW Maintained 1 | Cupressus arizonica :: Arizona Cypress 251 | 700X Brotherhood Way | 3 | Median : Cutout | Tree | DPW 1 | 45 | 14M | 5991180.7931196 | 2088069.9959997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | 1 | 8 | 4 | 64 | 14 | |||
| 3548 | 296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3451X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
| 3666 | 113065 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 6 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:51:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 3741 | 228 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2974 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/1992 12:00:00 AM | 70 | 3X4 | 5990613.87863 | 2095369.93557 | 37.7329467072262 | -122.474843412516 | (37.7329467072262, -122.474843412516) | 1 | 8 | 4 | 64 | 40 | ||
| 3841 | 28382 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3075 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2003 12:00:00 AM | 3 | 2 | 5990535.85203 | 2094820.37137 | 37.7314332212786 | -122.475073063976 | (37.7314332212786, -122.475073063976) | 1 | 8 | 4 | 64 | 35 | ||
| 3873 | 19441 | DPW Maintained 1 | Eucalyptus lehmanni :: Bushy Yate 260 | 1300X Sloat Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 20 | 5986928.6035 | 2095895.7656 | 37.7341762495639 | -122.487622811763 | (37.7341762495639, -122.487622811763) | 1 | 8 | 4 | 64 | 35 | |||
| 3881 | 11625 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 300X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | 9 | 8 | 4 | 64 | 40 | |||
| 4153 | 19360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992081.20032 | 2089838.16122 | 37.7178427427344 | -122.469368036824 | (37.7178427427344, -122.469368036824) | 9 | 8 | 6 | 64 | 24 | |||
| 4977 | 11672 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 710X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991310.6193982 | 2092985.752428 | 37.7264406890913 | -122.472260886614 | (37.7264406890913, -122.472260886614) | 9 | 8 | 4 | 64 | 40 | ||
| 5522 | 185128 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200x Sloat Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5987683.0779 | 2095922.3154 | 37.7342931239465 | -122.48501633511 | (37.7342931239465, -122.48501633511) | 1 | 8 | 4 | 64 | 35 | |||
| 6030 | 19323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 5993467.32802 | 2089853.93143 | 37.7179660496774 | -122.4645779904 | (37.7179660496774, -122.4645779904) | 9 | 8 | 6 | 64 | 24 | |||
| 6438 | 29970 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991349.07674 | 2093718.94394 | 37.7284560756763 | -122.472181363504 | (37.7284560756763, -122.472181363504) | 9 | 8 | 4 | 64 | 40 | ||
| 6439 | 185119 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200x Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 5987585.1902 | 2095924.1623 | 37.7342924927912 | -122.485354895586 | (37.7342924927912, -122.485354895586) | 1 | 8 | 4 | 64 | 35 | |||
| 6706 | 255369 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Brotherhood Way | 4 | Median : Cutout | Tree | DPW 1 | 14x10 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 6823 | 11708 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991296.5308 | 2092759.13423 | 37.7258176365683 | -122.472293077282 | (37.7258176365683, -122.472293077282) | 9 | 8 | 4 | 64 | 40 | ||
| 7147 | 260402 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Arch St | 1 | Median : Yard | Tree | DPW 1 | 3X5 | 5992587 | 2087523 | 37.7115150847083 | -122.467451465905 | (37.7115150847083, -122.467451465905) | 9 | 8 | 4 | 64 | 24 | ||||
| 7457 | 2165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.7142100327703 | -122.463817234952 | (37.7142100327703, -122.463817234952) | 9 | 8 | 6 | 64 | 24 | ||
| 7938 | 369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 8504 | 109669 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 200X GELLERT DR | 33 | Median : Cutout | Tree | DPW 1 | 02/26/2015 01:37:00 PM | 3 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||
| 8932 | 254133 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Lake Merced Blvd | 7 | Median : Yard | Tree | DPW 1 | 10x10 | 5983894 | 2095251 | 37.7322284370415 | -122.498066633405 | (37.7322284370415, -122.498066633405) | 1 | 8 | 4 | 64 | 35 | ||||
| 9033 | 254440 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501X Brotherhood Way | 20 | Median : Yard | Tree | DPW 1 | 10x10 | 5992686 | 2087818 | 37.7123307991194 | -122.467130733446 | (37.7123307991194, -122.467130733446) | 9 | 8 | 4 | 64 | 24 | ||||
| 9230 | 27347 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 300X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 2X2 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | 9 | 8 | 4 | 64 | 40 | ||
| 9536 | 1292 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3990 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5992119.08452 | 2087279.95314 | 37.710820711192 | -122.469051013205 | (37.710820711192, -122.469051013205) | 9 | 8 | 4 | 64 | 24 | |||
| 9662 | 113066 | - 12 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 7 | : | Tree | DPW 1 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 10023 | 256755 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 212 Country Club Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 5984146.79424 | 2095075.85796 | 37.7317623621263 | -122.497179756321 | (37.7317623621263, -122.497179756321) | 1 | 8 | 4 | 64 | 35 | |||
| 10113 | 11713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 10140 | 106278 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 2 | Median : Cutout | Tree | DPW 1 | 60 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | ||||
| 10560 | 178279 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 6 | Front Yard : Yard | Tree | DPW 1 | 4 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | |||
| 10769 | 19433 | DPW Maintained 1 | Eucalyptus lehmanni :: Bushy Yate 260 | 1300X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5987408.7322245 | 2095946.646093 | 37.7343439457369 | -122.485966609595 | (37.7343439457369, -122.485966609595) | 1 | 8 | 3 | 64 | 35 | |||
| 10818 | 251223 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80X Junipero Serra Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | Width 3ft | 5991438.54417 | 2088636.90192 | 37.714507218415 | -122.471501908609 | (37.714507218415, -122.471501908609) | 9 | 8 | 6 | 64 | 24 | |||
| 11238 | 1253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3802X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X5 | 5992813.09767 | 2087592.82096 | 37.7117198470729 | -122.466675091581 | (37.7117198470729, -122.466675091581) | 9 | 8 | 4 | 64 | 24 | ||
| 11286 | 1295 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 4000X Alemany Blvd | 3 | Median : Cutout | Tree | DPW 1 | 25 | 10 | 5991914.74417 | 2087134.82891 | 37.710410426081 | -122.469746695459 | (37.710410426081, -122.469746695459) | 9 | 8 | 4 | 64 | 24 | |||
| 11607 | 11613 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 12437 | 1235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3645 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5993271.90922 | 2087553.28553 | 37.7116377596374 | -122.465086457186 | (37.7116377596374, -122.465086457186) | 9 | 8 | 4 | 64 | 24 | |||
| 12739 | 30076 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 11 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
| 12775 | 260566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Denslowe Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5990592.24818 | 2090826.09743 | 37.7204692135739 | -122.474586693137 | (37.7204692135739, -122.474586693137) | 9 | 8 | 4 | 64 | 40 | |||||
| 12848 | 11711 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 13141 | 386 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3721X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | |||
| 13504 | 207123 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 6 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:51:00 AM | 21 | Width 0ft | 5991338.6165 | 2095665.48618 | 37.7338001863266 | -122.472359368113 | (37.7338001863266, -122.472359368113) | 1 | 8 | 4 | 64 | 40 | ||
| 13755 | 11746 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 03/03/2006 12:00:00 AM | 3 | 6X6 | 5991277.67104 | 2092671.80389 | 37.7255767576586 | -122.472351910013 | (37.7255767576586, -122.472351910013) | 9 | 8 | 4 | 64 | 40 | ||
| 13853 | 19419 | DPW Maintained 1 | Eucalyptus lehmanni :: Bushy Yate 260 | 800X Sloat Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5988998.1028282 | 2096024.0271709 | 37.7346489082814 | -122.480477366023 | (37.7346489082814, -122.480477366023) | 1 | 8 | 3 | 64 | 35 | |||
| 13953 | 116804 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 131 LAKESHORE DR | 1 | Median : Yard | Landscaping | DPW 1 | 10x100 | 5984782 | 2094243 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | 1 | 8 | 4 | 64 | 35 | ||||
| 14614 | 251224 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80X Junipero Serra Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | Width 3ft | 5991438.54417 | 2088636.90192 | 37.714507218415 | -122.471501908609 | (37.714507218415, -122.471501908609) | 9 | 8 | 6 | 64 | 24 | |||
| 14665 | 256768 | DPW Maintained 1 | Tree(s) :: 17 | 900 Brotherhood Way | 7 | Front Yard : Yard | Tree | DPW 1 | 09/25/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782397 | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | |
| 14685 | 19326 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 221 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2000 12:00:00 AM | 3 | 3X3 | 5993385.67 | 2089823.67731 | 37.7178782713364 | -122.464858048275 | (37.7178782713364, -122.464858048275) | 9 | 8 | 6 | 64 | 24 | ||
| 15052 | 1279 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
| 16414 | 30097 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400X Brotherhood Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 5993855.385701 | 2087505.212074 | 37.7115393894105 | -122.463066335527 | (37.7115393894105, -122.463066335527) | 9 | 8 | 6 | 64 | 24 | |||
| 17479 | 30098 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400X Brotherhood Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 5993855.385701 | 2087505.212074 | 37.7115393894105 | -122.463066335527 | (37.7115393894105, -122.463066335527) | 9 | 8 | 6 | 64 | 24 | |||
| 17744 | 11685 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 700X Junipero Serra Blvd | 17 | Median : Cutout | Tree | DPW 1 | 08/21/2019 12:00:00 AM | 3 | 6X6 | 5991290.62257 | 2092826.93511 | 37.7260034589701 | -122.472318441739 | (37.7260034589701, -122.472318441739) | 9 | 8 | 4 | 64 | 40 | ||
| 17777 | 219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2949 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 5X8 | 5990525.93487 | 2095591.0616 | 37.7335487664486 | -122.475163590944 | (37.7335487664486, -122.475163590944) | 1 | 8 | 4 | 64 | 35 | |||
| 17832 | 11665 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 700X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | 3 | 2x2 | 5991320.9947906 | 2093088.5989831 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | 9 | 8 | 4 | 64 | 40 | ||
| 17987 | 19440 | DPW Maintained 1 | Eucalyptus lehmanni :: Bushy Yate 260 | 1300X Sloat Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 20 | 5987401.6755259 | 2095951.2124587 | 37.7343560725457 | -122.485991341651 | (37.7343560725457, -122.485991341651) | 1 | 8 | 3 | 64 | 35 | |||
| 18585 | 27533 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 19587 | 260401 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3900 Alemany Blvd | 2 | Median : Yard | Tree | DPW 1 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | 9 | 8 | 4 | 64 | 24 | ||||
| 19838 | 207 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2919 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/1994 12:00:00 AM | 20 | 2X3 | 5990501.92231 | 2095794.16798 | 37.7341050531518 | -122.47526143143 | (37.7341050531518, -122.47526143143) | 1 | 8 | 4 | 64 | 35 | ||
| 19876 | 291 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3355 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/1994 12:00:00 AM | 20 | 2x10 | 5990518.29998 | 2093633.85413 | 37.7281743270786 | -122.475047162015 | (37.7281743270786, -122.475047162015) | 1 | 8 | 4 | 64 | 14 | ||
| 20049 | 11756 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
| 20778 | 30069 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 410X Brotherhood Way | 3 | Median : Cutout | Tree | DPW 1 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | |||
| 20995 | 87598 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | 4 | 3x3 | 5991401.185357 | 2095410.335482 | 37.7331032279342 | -122.472124459161 | (37.7331032279342, -122.472124459161) | 1 | 8 | 4 | 64 | 40 | ||
| 21244 | 186970 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1650x Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 5986025.4295 | 2095869.2083 | 37.7340506115946 | -122.490743373283 | (37.7340506115946, -122.490743373283) | 1 | 8 | 4 | 64 | 35 | |||
| 21376 | 418 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3870 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 2X4 | 5990907.498 | 2090050.47073 | 37.7183577952661 | -122.473440442237 | (37.7183577952661, -122.473440442237) | 9 | 8 | 4 | 64 | 40 | ||
| 21378 | 259 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3100 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X3 | 5990639.72639 | 2094599.99663 | 37.7308341475716 | -122.474697876125 | (37.7308341475716, -122.474697876125) | 9 | 8 | 4 | 64 | 40 | |||
| 21450 | 208080 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1000x Junipero Serra Blvd | 1 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991162.63824 | 2089810.37082 | 37.7177133113937 | -122.472541042839 | (37.7177133113937, -122.472541042839) | 9 | 8 | 4 | 64 | 24 | |||
| 21476 | 30129 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400X Brotherhood Way | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 5993855.385701 | 2087505.212074 | 37.7115393894105 | -122.463066335527 | (37.7115393894105, -122.463066335527) | 9 | 8 | 6 | 64 | 24 | |||
| 21545 | 392 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 2 | 5990516.36157 | 2090620.36486 | 37.7198999256056 | -122.474833997279 | (37.7198999256056, -122.474833997279) | 9 | 8 | 4 | 64 | 40 | |||
| 21587 | 30086 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 22 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
| 21615 | 254127 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Lake Merced Blvd | 1 | Median : Yard | Tree | DPW 1 | 10x10 | 5983894 | 2095251 | 37.7322284370415 | -122.498066633405 | (37.7322284370415, -122.498066633405) | 1 | 8 | 4 | 64 | 35 | ||||
| 21665 | 385 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 21715 | 1234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3633 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993305.81701 | 2087547.31495 | 37.7116233210332 | -122.464968830366 | (37.7116233210332, -122.464968830366) | 9 | 8 | 4 | 64 | 24 | |||
| 21752 | 29977 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 610X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991336.00972369 | 2093444.32433125 | 37.7277012826104 | -122.47220652658 | (37.7277012826104, -122.47220652658) | 9 | 8 | 4 | 64 | 40 | ||
| 21774 | 2295 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 10 | Median : Cutout | Tree | DPW 1 | 45 | 14M | 5990276.2096462 | 2088591.5343604 | 37.7143153385926 | -122.475516051132 | (37.7143153385926, -122.475516051132) | 1 | 8 | 4 | 64 | 14 | |||
| 21996 | 87612 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 800X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991263.805475 | 2092171.02552 | 37.7242009421806 | -122.472363351561 | (37.7242009421806, -122.472363351561) | 9 | 8 | 4 | 64 | 40 | ||
| 22317 | 30044 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 23309 | 266 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1999 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
| 23523 | 341 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2013 12:00:00 AM | 10 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 23627 | 208082 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1000x Junipero Serra Blvd | 45 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5991232.00982 | 2090962.12018 | 37.7208797469797 | -122.47238517505 | (37.7208797469797, -122.47238517505) | 9 | 8 | 4 | 64 | 24 | |||
| 23728 | 225 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2962 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/17/1991 12:00:00 AM | 40 | 3X4 | 5990608.66265 | 2095460.33335 | 37.7331946143326 | -122.474868041333 | (37.7331946143326, -122.474868041333) | 1 | 8 | 4 | 64 | 40 | ||
| 23735 | 102961 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 23835 | 29607 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 900X Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.48666 | 2091034.59302 | 37.7210755258009 | -122.472582381082 | (37.7210755258009, -122.472582381082) | 9 | 8 | 4 | 64 | 40 | ||
| 24110 | 19402 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 400X Sloat Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5990261.3597061 | 2096050.1007314 | 37.7347938328013 | -122.47611180944 | (37.7347938328013, -122.47611180944) | 1 | 8 | 3 | 64 | 35 | |||
| 24133 | 11748 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 31 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991276.77165 | 2092652.88165 | 37.7255247498407 | -122.472353640304 | (37.7255247498407, -122.472353640304) | 9 | 8 | 4 | 64 | 40 | ||
| 24157 | 19445 | DPW Maintained 1 | Eucalyptus lehmanni :: Bushy Yate 260 | 1400X Sloat Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5986974.9102614 | 2095954.0242956 | 37.7343389133904 | -122.48746699486 | (37.7343389133904, -122.48746699486) | 1 | 8 | 3 | 64 | 35 | |||
| 24222 | 12455 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
| 24482 | 11743 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2x2 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
| 25221 | 19488 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2100X Sloat Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 20M | 5984311.7495235 | 2095837.0474516 | 37.7338620509701 | -122.496665634298 | (37.7338620509701, -122.496665634298) | 1 | 8 | 3 | 64 | 35 |
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) );