trees

171 rows where Police Districts = 4 and qLegalStatus_id = 2 sorted by qCaretaker_id

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

  • 7 85
  • 5 51
  • 8 5

Police Districts ✖

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)
7127 260547 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 4x4 Permit Number 776221 6006333.00148 2102621.91378 37.753757389911 -122.421012959005 (37.753757389911, -122.421012959005) 2 4 5 28859 19
7195 4140 Planning Code 138.1 required 2 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3620 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2020 12:00:00 AM 3 3x6 Permit Number 780969 6006062.29639 2100597.35658 37.7481831571401 -122.421805323766 (37.7481831571401, -122.421805323766) 2 4 5 28859 19
7258 262001 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 7 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
7502 236582 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009292.77734 2105398.52034 37.7615477221736 -122.410973441191 (37.7615477221736, -122.410973441191) 2 4 7 28859 19
7744 225194 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3 Permit Number 778605 6007219.63733 2103836.19178 37.7571414587344 -122.418032839538 (37.7571414587344, -122.418032839538) 2 4 7 28859 19
8008 260640 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 3936 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2019 12:00:00 AM 3 4x4 Permit Number 776281 6004258 2100777 37.7485745007292 -122.428057323873 (37.7485745007292, -122.428057323873) 2 4 5 28862 22
8319 260505 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 760 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2019 12:00:00 AM 3 3x3 Permit Number 784870 6007464 2105234 37.7609932681872 -122.417286789238 (37.7609932681872, -122.417286789238) 2 4 7 28859 19
8601 222646 Planning Code 138.1 required 2 Ceanothus Sps :: California lilac 192 4209 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/06/2018 12:00:00 AM 3 Width 3ft   6001770.77195 2101738.59247 37.7510737715579 -122.436726932715 (37.7510737715579, -122.436726932715) 2 4 5 28862 22
8699 262221 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2020 12:00:00 AM 3 3x3 Permit Number 781435 6004728 2102256 37.7526620712812 -122.426537368454 (37.7526620712812, -122.426537368454) 2 4 5 28862 22
8777 18349 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2006 12:00:00 AM 3 3X3   6010308 2106081 37.7634785336334 -122.407510304274 (37.7634785336334, -122.407510304274) 8 4 8 28859 19
8936 261999 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
9271 225190 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
9770 262000 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
10030 261998 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
10742 166681 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 563 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2019 12:00:00 AM 3 3x3   6002718.47853 2102666.28528 37.7536748096657 -122.433515959096 (37.7536748096657, -122.433515959096) 2 4 5 28862 22
10960 166315 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
11040 260952 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
11143 258742 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 367 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2019 12:00:00 AM 3 3x3 Permit Number 774042 6003945 2103884 37.7570878795298 -122.429361203627 (37.7570878795298, -122.429361203627) 2 4 5 28862 3
11200 4249 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 4043 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1995 12:00:00 AM 12 4x4   6003613.964 2100376.48243 37.7474383143284 -122.430255820476 (37.7474383143284, -122.430255820476) 2 4 5 63 22
11330 166753 Planning Code 138.1 required 2 Schinus molle :: California Pepper 91 350 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2019 12:00:00 AM 3 4x4 Permit Number 781737 6002856.72425 2101550.76622 37.7506197011549 -122.43295818429 (37.7506197011549, -122.43295818429) 2 4 5 28862 22
11511 225198 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007149.23047 2103831.77129 37.7571253581517 -122.418276020715 (37.7571253581517, -122.418276020715) 2 4 7 28859 19
11548 225197 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007163.79352 2103832.50742 37.7571281991351 -122.418225708166 (37.7571281991351, -122.418225708166) 2 4 7 28859 19
11620 260954 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
11734 243526 Planning Code 138.1 required 2 Cassia leptophylla :: Gold Medallion Tree 152 3443 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6007325.13159 2104386.27009 37.7586577840397 -122.417706987288 (37.7586577840397, -122.417706987288) 2 4 7 28859 19
11885 157920 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4147 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2019 12:00:00 AM 3 3x3 Permit Number 777832 6002961.17206 2100636.31842 37.7481147664022 -122.432531686182 (37.7481147664022, -122.432531686182) 2 4 5 63 22
11910 262222 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2020 12:00:00 AM 3 3x3 Permit Number 781435 6004728 2102256 37.7526620712812 -122.426537368454 (37.7526620712812, -122.426537368454) 2 4 5 28862 22
12003 166317 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008865.69274 2103234.56357 37.755582030708 -122.412297603862 (37.755582030708, -122.412297603862) 2 4 7 28859 19
12221 261589 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 299x 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
12391 221098 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2815 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009314.5684 2105431.86525 37.7616405016156 -122.410900429722 (37.7616405016156, -122.410900429722) 2 4 7 28859 19
12438 260430 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
12677 259879 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 10 Romain St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2019 12:00:00 AM 3 3x3 Permit Number 776294 6001192.18773 2103413.52714 37.7556398401092 -122.438847746407 (37.7556398401092, -122.438847746407) 2 4 5 28862 3
13037 152668 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 811 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 3x3 Permit Number 777381 6008574.99769 2103713.14234 37.7568797829862 -122.413336764205 (37.7568797829862, -122.413336764205) 2 4 7 28859 19
13165 152981 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 4x4 Permit Number 776221 6006333.00148 2102621.91378 37.753757389911 -122.421012959005 (37.753757389911, -122.421012959005) 2 4 5 28859 19
13240 157603 Planning Code 138.1 required 2 Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 16 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2020 12:00:00 AM 3 5x5 Permit Number 784681 6000322.25182 2101567.57465 37.7505217703771 -122.441723777343 (37.7505217703771, -122.441723777343) 2 4 5 28862 22
13412 260953 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
13567 243284 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1450 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007678.08789 2107386.86578 37.766916579475 -122.416698868869 (37.766916579475, -122.416698868869) 8 4 7 28853 19
13706 225187 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
15138 231239 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2000 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009523.66683 2105264.06886 37.7611914935157 -122.410165393114 (37.7611914935157, -122.410165393114) 2 4 7 28859 19
15201 243525 Planning Code 138.1 required 2 Cassia leptophylla :: Gold Medallion Tree 152 3445 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4x5   6007302.00064 2104384.8851 37.7586526795002 -122.417786886671 (37.7586526795002, -122.417786886671) 2 4 7 28859 19
15413 262220 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2020 12:00:00 AM 3 3x3 Permit Number 781435 6004728 2102256 37.7526620712812 -122.426537368454 (37.7526620712812, -122.426537368454) 2 4 5 28862 22
15819 151746 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3030 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779245 6008502.96204 2106251.6003 37.763845762487 -122.413765441348 (37.763845762487, -122.413765441348) 8 4 7 28859 19
16166 166316 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008870.16891 2103155.64589 37.7553655917605 -122.412276546247 (37.7553655917605, -122.412276546247) 2 4 7 28859 19
16474 253340 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1045 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 3x3 Permit Number 780536 6004464 2102825 37.7542094840672 -122.427490860103 (37.7542094840672, -122.427490860103) 2 4 5 28862 22
17210 225188 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
17339 166211 Planning Code 138.1 required 2 Cercis canadensis :: Eastern Redbud 346 3140 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6008730.35876 2101584.0935 37.7510426163255 -122.412648961786 (37.7510426163255, -122.412648961786) 2 4 7 28859 19
18063 259659 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 4061 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 3x3 Permit Number 784440 6003514 2100377 37.7474340728524 -122.430601526112 (37.7474340728524, -122.430601526112) 2 4 5 63 22
18610 259660 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
18826 262002 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 8 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
19030 221366 Planning Code 138.1 required 2 Quercus suber :: Cork Oak 78 55 Homestead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2019 12:00:00 AM 3 3x3 Permit Number 778991 6000992.93047 2101385.53728 37.7500601303816 -122.439391477336 (37.7500601303816, -122.439391477336) 2 4 5 28862 22
19151 242322 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 99X San Jose Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2019 12:00:00 AM 3 4x4 Permit Number 776221 6006212.50813 2102671.12138 37.7538857096745 -122.421433147433 (37.7538857096745, -122.421433147433) 2 4 5 28859 19
19431 242096 Planning Code 138.1 required 2 Quercus suber :: Cork Oak 78 3721 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2019 12:00:00 AM 3 4x4 Permit Number 769571 6003563.92038 2103590.2718 37.756259789464 -122.430658162741 (37.756259789464, -122.430658162741) 2 4 5 28862 22
30240 243370 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006249.22799 2103449.78821 37.7560258191488 -122.421361454386 (37.7560258191488, -122.421361454386) 2 4 5 28859 19
31022 79408 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 322 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 4x4 Permit Number 776851 6004758.73696772 2101857.84943819 37.7515705801104 -122.426402728229 (37.7515705801104, -122.426402728229) 2 4 5 28862 22
34077 256492 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 280 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2018 12:00:00 AM 3 3x3 Permit Number 780675 6001741.51076 2104267.16046 37.7580149486389 -122.437009129166 (37.7580149486389, -122.437009129166) 2 4 5 28862 3
34711 44001 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
36004 187698 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2880 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008980.17665 2103937.78959 37.7575193538388 -122.41195137385 (37.7575193538388, -122.41195137385) 2 4 7 28859 19
36893 152811 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009988.15821 2101607.87857 37.7511784382559 -122.40830102207 (37.7511784382559, -122.40830102207) 2 4 7 28859 19
37180 44003 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
38312 167082 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 280 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2018 12:00:00 AM 3 3x3 Permit Number 780675 6001741.51076 2104267.16046 37.7580149486389 -122.437009129166 (37.7580149486389, -122.437009129166) 2 4 5 28862 3
41331 14313 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2018 12:00:00 AM 3 4x4 Permit Number 782146 6003603.86 2107219.9092 37.7662281664546 -122.430779049243 (37.7662281664546, -122.430779049243) 7 4 5 28862 3
46028 152812 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6010002.42353 2101608.75594 37.7511816461268 -122.408251752714 (37.7511816461268, -122.408251752714) 2 4 7 28859 19
47537 18353 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2013 12:00:00 AM 3 3x3   6010310.70956 2106111.3358 37.7635619805233 -122.407503071611 (37.7635619805233, -122.407503071611) 8 4 8 28859 19
52242 243372 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1050 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006308.99467 2103436.4955 37.7559926899263 -122.42115381712 (37.7559926899263, -122.42115381712) 2 4 5 28859 19
53742 82615 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 2 4 7 28859 19
54415 224728 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 1110 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2018 12:00:00 AM 3 3x3 Permit Number 771820 6009984.63313 2102660.33541 37.754068053508 -122.408387439738 (37.754068053508, -122.408387439738) 2 4 7 28859 19
56279 116967 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 480 Potrero Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010335.4704597 2106068.8961361 37.7634468367565 -122.407414438937 (37.7634468367565, -122.407414438937) 8 4 8 28859 19
58500 251298 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 4 Sidewalk: Curb side : Cutout Tree Private 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
63824 120132 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006324.60427 2103454.53368 37.7560430985606 -122.421101114609 (37.7560430985606, -122.421101114609) 2 4 5 28859 19
67108 152327 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 49 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4   6006657.39777 2105617.1383 37.7619998635108 -122.420103671551 (37.7619998635108, -122.420103671551) 8 4 7 28859 19
68317 228832 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 517 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2018 12:00:00 AM 3 4x4   6006836.21643 2100716.23735 37.7485531903885 -122.419137558645 (37.7485531903885, -122.419137558645) 2 4 7 28859 19
70866 224462 Planning Code 138.1 required 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2810 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010311.37562 2101086.64633 37.7497653433983 -122.407146558773 (37.7497653433983, -122.407146558773) 2 4 7 28859 19
72617 251297 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 5 Sidewalk: Curb side : Cutout Tree Private 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
72715 44010 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 405x Florida St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
74821 36044 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3030 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779245 6008531.98185334 2106261.58493121 37.7638748076146 -122.413665776536 (37.7638748076146, -122.413665776536) 8 4 7 28859 19
76348 258086 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 381 Lexington St 1 Sidewalk: Property side : Cutout Tree Private 2       2x1   6006575 2103913 37.7573160533564 -122.420267699006 (37.7573160533564, -122.420267699006) 2 4 7 28859 19
78698 173775 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1057 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2018 12:00:00 AM 3 4x4 Permit Number 779347 6009462.91602 2103024.17334 37.7550378411013 -122.410217357343 (37.7550378411013, -122.410217357343) 2 4 7 28859 19
80448 187677 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
81103 156905 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 3201x 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417 2106083 37.7633217807187 -122.417509514421 (37.7633217807187, -122.417509514421) 8 4 7 28859 19
82212 156914 Planning Code 138.1 required 2 Tree(s) :: 17 2995 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2018 12:00:00 AM 3 3x3 Permit Number 782654 6009047.12311 2101072.92433 37.7496568330138 -122.411517443787 (37.7496568330138, -122.411517443787) 2 4 7 28859 19
82843 243896 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 4225 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2018 12:00:00 AM 3 3x3   6001659.32992 2102313.2065 37.7526451902403 -122.437153446982 (37.7526451902403, -122.437153446982) 2 4 5 28862 22
83711 258012 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 238 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2019 12:00:00 AM 3 3x3 Permit Number 781835 6001423.51445 2104434.57022 37.7584565353532 -122.438120885556 (37.7584565353532, -122.438120885556) 2 4 5 28862 3
84485 240578 Planning Code 138.1 required 2 Tree(s) :: 17 3636 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/17/2019 12:00:00 AM 3 4x4 Permit Number 782238 6004112.69332 2103663.95963 37.7564931932291 -122.428765570083 (37.7564931932291, -122.428765570083) 2 4 5 28862 3
84809 167131 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 4540 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/20/2018 12:00:00 AM 3 3x3 Permit Number 780648 6000902.50099 2104660.33643 37.7590467894041 -122.439938965707 (37.7590467894041, -122.439938965707) 2 4 5 28862 3
88053 187676 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
88632 60705 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 963 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1983 12:00:00 AM 1 3x3 Permit Number 20354 6009178.18020232 2103559.73737881 37.7564924147418 -122.4112398899 (37.7564924147418, -122.4112398899) 2 4 7 28859 19
91584 157471 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 844 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2018 12:00:00 AM 3 3x3   6001109 2099712 37.7454716006778 -122.438870189158 (37.7454716006778, -122.438870189158) 2 4 5 63 22
96451 225775 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 577 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft Permit Number 782239 6002401.77617 2104846.28665 37.75964259654 -122.43476706624 (37.75964259654, -122.43476706624) 2 4 5 28862 3
100236 166794 Planning Code 138.1 required 2 Crataegus phaenopyrum :: Washington Hawthorn 102 477 Elizabeth St 1 Sidewalk: Property side : Cutout Tree Private 2   05/30/2019 12:00:00 AM 3 3x3 Permit Number 774858 6003342.48296 2102120.18359 37.7522107277484 -122.431319034046 (37.7522107277484, -122.431319034046) 2 4 5 28862 22
104300 196537 Planning Code 138.1 required 2 Prunus x yedoensis :: Yoshino Cherry 77 526 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 Width 3ft Permit Number 782869 6010635.96485 2105787.36101 37.7626906193079 -122.406355282166 (37.7626906193079, -122.406355282166) 8 4 8 28859 19
105170 252909 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 3201x 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417 2106083 37.7633217807187 -122.417509514421 (37.7633217807187, -122.417509514421) 8 4 7 28859 19
105542 251314 Planning Code 138.1 required 2 :: 45 1108 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001901 2100825 37.7485726639367 -122.4362112186 (37.7485726639367, -122.4362112186) 2 4 5 28862 22
107596 151878 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1450 15th St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007623.77597 2107385.08821 37.7669086438472 -122.416886599646 (37.7669086438472, -122.416886599646) 8 4 7 28853 19
114599 240686 Planning Code 138.1 required 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2810 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010325.27315 2101087.17666 37.7497675773096 -122.407098537685 (37.7497675773096, -122.407098537685) 2 4 7 28859 19
119022 60277 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2690 Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM   3x3 Permit Number 51145 6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
119230 254617 Planning Code 138.1 required 2 :: 45 685 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 3x3 Permit Number 773164 6009303.1948 2105068.09113 37.7606410229668 -122.410914072761 (37.7606410229668, -122.410914072761) 2 4 7 28859 19
119839 152118 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 44 Woodward St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2018 12:00:00 AM 3 3x3 Permit Number 780873 6006474.76942 2108215.62621 37.7691244070031 -122.420919809024 (37.7691244070031, -122.420919809024) 8 4 7 28853 19
120060 221127 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1218 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2016 12:00:00 AM 1 Width 3ft Permit Number 778419 6008662.3869 2101444.26707 37.750654869142 -122.412874131348 (37.750654869142, -122.412874131348) 2 4 7 28859 19
120199 116966 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6010311.67872 2106089.82191 37.7635029625087 -122.407498202703 (37.7635029625087, -122.407498202703) 8 4 8 28859 19
124014 108228 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 390x TREAT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779245 6008492 2106262 37.763873702058 -122.413804091523 (37.763873702058, -122.413804091523) 8 4 7 28859 19
124846 258137 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 460 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/09/2019 12:00:00 AM 3 3x3 Permit Number 782442 6002949.79782 2105560.87431 37.7616357801338 -122.432922786357 (37.7616357801338, -122.432922786357) 15 4 5 28862 3

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);