trees
27,746 rows where qCaretaker_id = 1 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
2082 | 195047 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 06th St | 2 | : | Tree | DPW 1 | 02/25/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.7776732094966 | -122.404737337955 | (37.7776732094966, -122.404737337955) | 14 | 2 | 9 | 28853 | 34 | |
9617 | 240412 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 1 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.05977 | 2103920.26324 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
22721 | 199372 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2 Newhall St | 2 | : | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 15 | Width 3ft | Permit Number 774049 | 6018530.30847 | 2097200.55685 | 37.7395514542225 | -122.378455061265 | (37.7395514542225, -122.378455061265) | 10 | 3 | 8 | 58 | 1 | |
23938 | 237023 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 4 | : | Tree | DPW 1 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | 7 | 9 | 11 | 28852 | 10 | ||
30838 | 188697 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 13 | : | Tree | DPW 1 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291 | (37.7397338556296, -122.38293388291) | 10 | 3 | 8 | 58 | 1 | |||
32529 | 237036 | DPW Maintained 1 | Shrub :: Shrub 66 | 150 Octavia St | 4 | : | Tree | DPW 1 | 04/13/2017 02:42:00 PM | 3 | Width 4ft | 6005705.05318 | 2109878.39065 | 37.7736465417793 | -122.423700457022 | (37.7736465417793, -122.423700457022) | 7 | 9 | 11 | 28852 | 10 | ||
33615 | 188702 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Evans Ave | 2 | : | Tree | DPW 1 | 17 | Width 4ft | 6015994.71985 | 2098219.31717 | 37.7422086702947 | -122.387293152263 | (37.7422086702947, -122.387293152263) | 10 | 3 | 8 | 58 | 1 | |||
33892 | 191798 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 2 Newhall St | 3 | : | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 6 | Width 3ft | Permit Number 774049 | 6018546.98738 | 2097184.73725 | 37.7395089360924 | -122.378396294176 | (37.7395089360924, -122.378396294176) | 10 | 3 | 8 | 58 | 1 | |
51504 | 196581 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 375 07th St | 3 | : | Tree | DPW 1 | 10 | Width 3ft | 6010649.28152 | 2110608.88242 | 37.7759301578972 | -122.40664901875 | (37.7759301578972, -122.40664901875) | 14 | 2 | 9 | 28853 | 34 | |||
58831 | 195045 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 312 06th St | 1 | : | Tree | DPW 1 | 10 | Width 3ft | 6010980.17572 | 2111476.79231 | 37.7783317443601 | -122.405565505645 | (37.7783317443601, -122.405565505645) | 14 | 2 | 9 | 28853 | 34 | |||
71087 | 189833 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 2 | : | Tree | DPW 1 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | 10 | 3 | 8 | 58 | 1 | ||
75260 | 195041 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 402 06th St | 1 | : | Tree | DPW 1 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.7771714039683 | -122.403804684362 | (37.7771714039683, -122.403804684362) | 14 | 2 | 9 | 28856 | 34 | |||
75385 | 193091 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1395 Fairfax Ave | 1 | : | Tree | DPW 1 | 01/27/2015 12:22:00 PM | 6 | Width 3ft | 6016598.40823 | 2097419.67591 | 37.7400464320877 | -122.385150061522 | (37.7400464320877, -122.385150061522) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
85490 | 246858 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1198 Oak St | 1 | : | Tree | DPW 1 | 5 | Width 4ft | 6001462.57137 | 2109763.81432 | 37.7730915476574 | -122.438367610872 | (37.7730915476574, -122.438367610872) | 15 | 5 | 11 | 29492 | 10 | |||
87985 | 237035 | DPW Maintained 1 | Shrub :: Shrub 66 | 150 Octavia St | 2 | : | Tree | DPW 1 | 04/12/2017 02:27:00 PM | 3 | Width 4ft | 6005709.86547 | 2109855.10938 | 37.7735828886787 | -122.423682154918 | (37.7735828886787, -122.423682154918) | 7 | 9 | 11 | 28852 | 10 | ||
92574 | 190440 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1350 Evans Ave | 7 | : | Tree | DPW 1 | 03/30/2004 12:00:00 AM | 4 | Width 3ft | 6016842.64833 | 2097703.08966 | 37.7408381367768 | -122.384325304974 | (37.7408381367768, -122.384325304974) | 10 | 3 | 8 | 58 | 1 | ||
92899 | 190438 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1350 Evans Ave | 4 | : | Tree | DPW 1 | 03/18/2017 11:59:00 AM | 3 | Width 3ft | 6016891.21359 | 2097667.15217 | 37.7407421449384 | -122.38415488076 | (37.7407421449384, -122.38415488076) | 10 | 3 | 8 | 58 | 1 | ||
96826 | 234845 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 452 Oak St | 2 | : | Tree | DPW 1 | 8 | Width 4ft | 6004779.43654 | 2110228.96496 | 37.7745568400539 | -122.426927281183 | (37.7745568400539, -122.426927281183) | 7 | 9 | 11 | 28852 | 10 | |||
100200 | 237022 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 3 | : | Tree | DPW 1 | 04/15/2017 01:40:00 PM | 3 | Width 6ft | 6005770.13323 | 2109412.50366 | 37.772371001847 | -122.423442207693 | (37.772371001847, -122.423442207693) | 7 | 9 | 11 | 28852 | 10 | ||
101381 | 188685 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300 Evans Ave | 14 | : | Tree | DPW 1 | 04/10/2017 01:01:00 PM | 3 | Width 3ft | 6017863.85792 | 2096944.20177 | 37.7388107959886 | -122.380741566863 | (37.7388107959886, -122.380741566863) | 10 | 3 | 8 | 58 | 1 | ||
102932 | 237024 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 5 | : | Tree | DPW 1 | 04/15/2017 01:48:00 PM | 3 | Width 6ft | 6005763.84021 | 2109451.72322 | 37.772478334131 | -122.423466764586 | (37.772478334131, -122.423466764586) | 7 | 9 | 11 | 28852 | 10 | ||
113799 | 228442 | DPW Maintained 1 | :: 45 | 413 Haight St | 1 | : | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004129.64861 | 2109389.34953 | 37.7722146987825 | -122.429115146464 | (37.7722146987825, -122.429115146464) | 7 | 9 | 11 | 29492 | 10 | ||
117072 | 190439 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1350 Evans Ave | 6 | : | Tree | DPW 1 | 03/18/2017 11:54:00 AM | 3 | Width 3ft | 6016857.78658 | 2097692.82931 | 37.7408108009722 | -122.384272247659 | (37.7408108009722, -122.384272247659) | 10 | 3 | 8 | 58 | 1 | ||
117844 | 188482 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1580 Burke Ave | 3 | : | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | 10 | 3 | 8 | 58 | 1 | ||
120431 | 188691 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 45 | : | Tree | DPW 1 | 03/18/2017 02:26:00 PM | 3 | Width 3ft | 6017107.93008 | 2097506.97635 | 37.7403143140663 | -122.38339440234 | (37.7403143140663, -122.38339440234) | 10 | 3 | 8 | 58 | 1 | ||
122004 | 249575 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1099 Ofarrell St | 1 | : | Tree | DPW 1 | 10 | Width 4ft | 6006092.59759 | 2113824.51195 | 37.7845034992802 | -122.422640354193 | (37.7845034992802, -122.422640354193) | 7 | 9 | 11 | 28858 | 41 | |||
129705 | 226530 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 498 Oak St | 1 | : | Tree | DPW 1 | 16 | Width 4ft | 6004664.90455 | 2110206.95803 | 37.7744899376984 | -122.427321901889 | (37.7744899376984, -122.427321901889) | 7 | 9 | 11 | 28852 | 10 | |||
129732 | 228443 | DPW Maintained 1 | :: 45 | 401 Haight St | 1 | : | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004157.65728 | 2109393.74469 | 37.7722283522845 | -122.429018575473 | (37.7722283522845, -122.429018575473) | 7 | 9 | 11 | 29492 | 10 | ||
130451 | 218199 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 819 Ulloa St | 1 | : | Tree | DPW 1 | 13 | Width 3ft | 5993346.67502 | 2098141.32486 | 37.740714236277 | -122.465596773898 | (37.740714236277, -122.465596773898) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
132582 | 240413 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 2 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.7569141478938 | -122.442632304847 | (37.7569141478938, -122.442632304847) | 2 | 4 | 5 | 28862 | 3 | ||
135923 | 246861 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1198 Oak St | 5 | : | Tree | DPW 1 | 05/09/1997 12:00:00 AM | 7 | Width 4ft | 6001300.07854 | 2109739.80574 | 37.773016382323 | -122.438927972152 | (37.773016382323, -122.438927972152) | 15 | 5 | 11 | 29492 | 10 | ||
136697 | 239151 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Octavia St | 2 | : | Tree | DPW 1 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | 7 | 9 | 11 | 28852 | 10 | ||
139069 | 191800 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 2 Newhall St | 5 | : | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 19 | Width 4ft | Permit Number 774049 | 6018580.4534 | 2097158.49779 | 37.7394387323227 | -122.378278760853 | (37.7394387323227, -122.378278760853) | 10 | 3 | 8 | 58 | 1 | |
147554 | 239154 | DPW Maintained 1 | Shrub :: Shrub 66 | 150 Octavia St | 6 | : | Tree | DPW 1 | 04/13/2017 02:47:00 PM | 3 | Width 4ft | 6005701.84613 | 2109911.12293 | 37.773736235682 | -122.42371387849 | (37.773736235682, -122.42371387849) | 7 | 9 | 11 | 28852 | 10 | ||
149263 | 188692 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 46 | : | Tree | DPW 1 | 03/18/2017 02:33:00 PM | 3 | Width 3ft | 6017090.76081 | 2097520.28707 | 37.7403499137184 | -122.383454693803 | (37.7403499137184, -122.383454693803) | 10 | 3 | 8 | 58 | 1 | ||
150651 | 250070 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 1 | : | Tree | DPW 1 | 2 | Width 3ft | 6005393.47416 | 2115303.01268 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | 13 | 9 | 1 | 28858 | 41 | |||
154474 | 237028 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 9 | : | Tree | DPW 1 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | 7 | 9 | 11 | 28852 | 10 | ||
159263 | 115188 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2300X Alemany Blvd | 5 | : | Tree | DPW 1 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | 9 | 7 | 6 | 28861 | 25 | ||||
160788 | 228440 | DPW Maintained 1 | :: 45 | 451 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 4 | Width 3ft | 6003980.50091 | 2109366.20592 | 37.7721427080557 | -122.429629410284 | (37.7721427080557, -122.429629410284) | 7 | 9 | 11 | 29492 | 10 | ||
161224 | 242868 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 388 Guerrero St | 1 | : | Tree | DPW 1 | 05/12/2014 12:00:00 AM | 1 | Width 3ft | 6005479.97294 | 2106783.54072 | 37.7651361178728 | -122.424258890153 | (37.7651361178728, -122.424258890153) | 8 | 4 | 5 | 28853 | 19 | ||
166693 | 193039 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1800 Evans Ave | 10 | : | Tree | DPW 1 | 05/12/2011 12:00:00 AM | 5 | Width 4ft | 6014331.82546 | 2099544.27863 | 37.7457545046729 | -122.393135659077 | (37.7457545046729, -122.393135659077) | 10 | 3 | 8 | 58 | 1 | ||
173923 | 249579 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1075 Ofarrell St | 2 | : | Tree | DPW 1 | 06/30/2015 10:17:00 AM | 13 | Width 4ft | 6006196.86356 | 2113838.78404 | 37.7845485688079 | -122.42228064334 | (37.7845485688079, -122.42228064334) | 7 | 9 | 11 | 28858 | 41 | ||
174324 | 246970 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299 Noe St | 2 | : | Tree | DPW 1 | 9 | Width 4ft | 6002947.4073 | 2106634.57369 | 37.7645837632448 | -122.433007767491 | (37.7645837632448, -122.433007767491) | 15 | 5 | 5 | 28862 | 3 | |||
177500 | 188690 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 44 | : | Tree | DPW 1 | 03/18/2017 02:23:00 PM | 3 | Width 3ft | 6017127.64655 | 2097493.15124 | 37.7402774427419 | -122.383325267851 | (37.7402774427419, -122.383325267851) | 10 | 3 | 8 | 58 | 1 | ||
186445 | 188686 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 20 | : | Tree | DPW 1 | 12 | Width 3ft | 6017760.57019 | 2097020.59109 | 37.7390148449557 | -122.381104000867 | (37.7390148449557, -122.381104000867) | 10 | 3 | 8 | 58 | 1 | |||
189134 | 249576 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1099 Ofarrell St | 2 | : | Tree | DPW 1 | 10/18/2012 12:00:00 AM | 2 | Width 4ft | 6006111.66082 | 2113826.64553 | 37.784510433048 | -122.422574553491 | (37.784510433048, -122.422574553491) | 7 | 9 | 11 | 28858 | 41 | ||
129825 | 113062 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 3 | : Yard | Tree | DPW 1 | 08/18/2016 09:59:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
161019 | 113063 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 4 | : Yard | Tree | DPW 1 | 08/18/2016 09:56:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
342 | 115652 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 18 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
24981 | 115647 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 13 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
27745 | 115653 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 19 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
36364 | 115642 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 8 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
61637 | 115638 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 4 | Back Yard : Cutout | Tree | DPW 1 | 7 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
67651 | 115641 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 7 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
69931 | 115646 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 12 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
82655 | 115645 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 11 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
92653 | 115639 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 5 | Back Yard : Cutout | Tree | DPW 1 | 6 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
93215 | 251582 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 691x Ulloa St | 1 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 5994175 | 2098101 | 37.7406512558576 | -122.462729837498 | (37.7406512558576, -122.462729837498) | 1 | 8 | 4 | 59 | 40 | ||||
94640 | 115635 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 1 | Back Yard : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
102518 | 115648 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 14 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
109260 | 115649 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 15 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
113451 | 115644 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 10 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
137355 | 115636 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 2 | Back Yard : Cutout | Tree | DPW 1 | 16 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
144021 | 115650 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 16 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
163840 | 115640 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 6 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
168631 | 115643 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 9 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
173132 | 115637 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 3 | Back Yard : Cutout | Tree | DPW 1 | 14 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
175002 | 115655 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 21 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
177053 | 115654 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 20 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
181668 | 115651 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 17 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
10032 | 254212 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 81X Elsie St | 10 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
15426 | 262040 | DPW Maintained 1 | Tree(s) :: 17 | 740 Jamestown Ave | Back Yard : Yard | Tree | DPW 1 | Private | 6015231.58289 | 2088478.1596 | 37.7154191081975 | -122.38925181324 | (37.7154191081975, -122.38925181324) | 10 | 3 | 8 | 58 | 1 | |||||
16107 | 262406 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2827 Cesar Chavez St | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010428 | 2100696 | 37.7486992403688 | -122.406715738075 | (37.7486992403688, -122.406715738075) | 2 | 4 | 7 | 28859 | 2 | ||||
16438 | 87300 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 2 | Back Yard : Yard | Tree | DPW 1 | 6 | Permit Number 50312 | 6011877.98748 | 2100898.05147 | 37.749335051069 | -122.401715863223 | (37.749335051069, -122.401715863223) | 10 | 3 | 8 | 58 | 1 | |||
18372 | 121500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 251X Pennsylvania Ave | 1 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
22171 | 251481 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 32 Peralta Ave | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010779 | 2100499 | 37.7481779538542 | -122.405488104269 | (37.7481779538542, -122.405488104269) | 2 | 7 | 7 | 28859 | 2 | ||||
29072 | 253545 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1000 Cayuga Ave | 13 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:58:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
30830 | 253551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 19 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
41458 | 87301 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 3 | Back Yard : Yard | Tree | DPW 1 | 5 | Permit Number 50312 | 6011915.6161 | 2100899.61614 | 37.7493414470685 | -122.401585851825 | (37.7493414470685, -122.401585851825) | 10 | 3 | 8 | 58 | 1 | |||
41989 | 69895 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51x PRENTISS ST | 2 | Back Yard : Yard | Tree | DPW 1 | 03/29/2003 12:00:00 AM | 12 | 6008906.8 | 2098323.8 | 37.7421004736884 | -122.411808454692 | (37.7421004736884, -122.411808454692) | 10 | 7 | 7 | 28859 | 2 | |||
55894 | 253546 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 14 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
56235 | 253550 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 18 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
58983 | 253548 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 16 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
60264 | 253535 | DPW Maintained 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 1000 Cayuga Ave | 3 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 02:31:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
61431 | 253549 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 17 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
71991 | 253538 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1000 Cayuga Ave | 6 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 02:43:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
75814 | 103457 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Bosworth St | 3 | Back Yard : Yard | Tree | DPW 1 | 26 | Located on DPW property next to 84 Lippard Ave | 6001796.5 | 2095573.7 | 37.7341478843848 | -122.436196831648 | (37.7341478843848, -122.436196831648) | 2 | 7 | 5 | 63 | 7 | |||
78837 | 107619 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51X Prentiss St | 3 | Back Yard : Yard | Tree | DPW 1 | 12 | 6008906.75623 | 2098323.8391 | 37.7421005785929 | -122.411808608798 | (37.7421005785929, -122.411808608798) | 10 | 7 | 7 | 28859 | 2 | ||||
80700 | 253542 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 10 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:42:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
81250 | 253536 | DPW Maintained 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 1000 Cayuga Ave | 4 | Back Yard : Yard | Tree | DPW 1 | 10/05/2017 04:10:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
85620 | 253539 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1000 Cayuga Ave | 7 | Back Yard : Yard | Tree | DPW 1 | 10/05/2017 04:07:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
86647 | 253533 | DPW Maintained 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 1000 Cayuga Ave | 1 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 01:57:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
87305 | 253547 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 15 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
95991 | 253541 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 9 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 03:59:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
106265 | 253543 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 11 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:35:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
118918 | 253544 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 12 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:38:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 |
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) );