trees

1,011 rows where qLegalStatus_id = 2 sorted by TreeID

✎ View and edit SQL

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)
27737 115492 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
65049 115493 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 4 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
46086 115494 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1199X OCEAN AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
23597 115495 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1199X OCEAN AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
131633 115503 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 72 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 2 4 7 28859 19
163013 115504 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 3 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
171393 115528 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 101 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007325.8351 2111377.63368 37.7778544624367 -122.418200224953 (37.7778544624367, -122.418200224953) 7 9 9 28852 36
135842 115529 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 101 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007327.31765 2111347.52577 37.777771876795 -122.418192961161 (37.777771876795, -122.418192961161) 7 9 9 28852 36
167439 115530 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 101 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007332.44961 2111311.79762 37.7776740647351 -122.418172674243 (37.7776740647351, -122.418172674243) 7 9 9 28852 36
168962 115531 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 1 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007312.73746 2111269.98589 37.7775581502144 -122.41823790028 (37.7775581502144, -122.41823790028) 7 9 9 28852 36
34272 115532 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 2 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007293.46404 2111265.83422 37.7775456658356 -122.418304279225 (37.7775456658356, -122.418304279225) 7 9 9 28852 36
115681 115533 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 3 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007275.38703 2111262.82601 37.7775363884346 -122.418366600452 (37.7775363884346, -122.418366600452) 7 9 9 28852 36
93518 115534 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 4 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007259.83389 2111260.26588 37.7775284833993 -122.418420222514 (37.7775284833993, -122.418420222514) 7 9 9 28852 36
184734 115535 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 5 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007237.56945 2111260.60051 37.7775281488378 -122.418497266559 (37.7775281488378, -122.418497266559) 7 9 9 28852 36
185440 115536 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
12720 115537 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
164265 115538 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
75364 115539 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
40425 115540 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x5 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
148701 115559 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2539 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6001373.79142 2117611.09107 37.7946331129763 -122.439237274207 (37.7946331129763, -122.439237274207) 13 9 1 57 27
184166 115674 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1433 48th Ave   Sidewalk: Curb side : Cutout Tree Private 2   10/18/2016 12:00:00 AM 3 3x3 Permit Number 774098 5981190.2 2105303.4 37.7596706142775 -122.508159957785 (37.7596706142775, -122.508159957785) 1 8 3 56 35
142797 115805 Planning Code 138.1 required 2 Pyrus kawakamii :: Evergreen Pear 83 872 Kansas St   Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3 3x3   6011546.4 2104246.9 37.7585117443173 -122.403098033012 (37.7585117443173, -122.403098033012) 10 3 8 28856 29
29841 115885 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 1 Sidewalk: Property side : Yard Tree Private 2   03/01/2016 12:00:00 AM 3 10x10 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
45389 115886 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
28863 115887 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 2 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
84799 115962 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 209 Grattan St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2016 12:00:00 AM 3 3x3   5997642.1 2106419.3 37.7636903209387 -122.451341781368 (37.7636903209387, -122.451341781368) 15 5 11 29492 9
163344 115976 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757) 10 3 7 309 28
188951 115977 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011639.0005 2091249.90123 37.7228299259539 -122.40186416949 (37.7228299259539, -122.40186416949) 10 3 7 309 28
158751 115978 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721 (37.7228154963084, -122.40191601721) 10 3 7 309 28
156122 115979 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011610.19593 2091240.25279 37.7228018257296 -122.401963063449 (37.7228018257296, -122.401963063449) 10 3 7 309 28
13984 115980 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011593.71434 2091235.60939 37.7227881560287 -122.402019710862 (37.7227881560287, -122.402019710862) 10 3 7 309 28
84579 116262 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 35 La Grande Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2016 12:00:00 AM 3 3x4   6005278.18089 2092026.49943 37.7246052551119 -122.42390739822 (37.7246052551119, -122.42390739822) 9 7 6 309 5
158236 116267 Planning Code 138.1 required 2 Acer japonicum :: Japanese Maple 124 717 PARIS ST 1 Front Yard : Yard Tree Private 2       3x3   6001138 2089523 37.7174966063475 -122.438040195581 (37.7174966063475, -122.438040195581) 9 7 6 28861 5
110069 116528 Planning Code 138.1 required 2 :: 45 125 CROWN TER 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   5998841 2104182 37.7576158290564 -122.447034160915 (37.7576158290564, -122.447034160915) 2 5 5 28862 3
177060 116640 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 2 Sidewalk: Property side : Cutout Tree Private 2     1 4x4   6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
171427 116774 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008811.21548 2117995.14613 37.7961080479024 -122.413529902601 (37.7961080479024, -122.413529902601) 5 1 10 308 21
190292 116775 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008794.04431 2117993.28546 37.7961019747828 -122.413589186808 (37.7961019747828, -122.413589186808) 5 1 10 308 21
129695 116776 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008776.88904 2117992.21481 37.7960980717264 -122.413648471894 (37.7960980717264, -122.413648471894) 5 1 10 308 21
136966 116777 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008763.52683 2117990.43413 37.7960924320727 -122.413694581941 (37.7960924320727, -122.413694581941) 5 1 10 308 21
27582 116803 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 931 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2016 12:00:00 AM 3 3x3   6007342.71844 2093540.39539 37.7288784251848 -122.416877747635 (37.7288784251848, -122.416877747635) 9 3 7 309 28
183437 116849 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 83 Panorama Dr 1 Front Yard : Yard Tree Private 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
164459 116850 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 83 Panorama Dr 2 Front Yard : Yard Tree Private 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
137347 116851 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 83 Panorama Dr 3 Front Yard : Yard Tree Private 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
65206 116853 Planning Code 138.1 required 2 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3 3X3 Permit Number 773331 6005973.81147 2115593.81965 37.7893548777914 -122.423177122971 (37.7893548777914, -122.423177122971) 13 9 1 28858 41
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
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
23615 117008 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1315 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2016 12:00:00 AM 3 3x3   6006952.61647 2093135.11232 37.7277436552341 -122.418197638517 (37.7277436552341, -122.418197638517) 9 3 7 309 5
81347 117017 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008130.7573 2112963.51283 37.7822541806174 -122.415528017206 (37.7822541806174, -122.415528017206) 7 10 9 28852 36
97662 117018 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008125.66458 2112987.05621 37.7823185388132 -122.415547303188 (37.7823185388132, -122.415547303188) 7 10 9 28852 36
14869 117019 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.415562303882 (37.782365960952, -122.415562303882) 7 10 9 28852 36
61797 117020 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008118.25915 2113018.66588 37.7824049150971 -122.415575161466 (37.7824049150971, -122.415575161466) 7 10 9 28852 36
68035 117021 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008114.19003 2113031.70239 37.7824404814865 -122.415590162171 (37.7824404814865, -122.415590162171) 7 10 9 28852 36
84905 117112 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1650 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005683.22125 2117915.42136 37.7957130098979 -122.424347724294 (37.7957130098979, -122.424347724294) 13 9 1 28858 27
64492 117113 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1650 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005663.57094 2117913.49378 37.7957066076266 -122.424415580821 (37.7957066076266, -122.424415580821) 13 9 1 28858 27
119986 117114 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1650 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005648.88243 2117910.88116 37.7956986045686 -122.424466219844 (37.7956986045686, -122.424466219844) 13 9 1 28858 27
74321 117115 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1650 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005638.31982 2117909.64088 37.7956946025865 -122.42450268015 (37.7956946025865, -122.42450268015) 13 9 1 28858 27
119169 117250 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 2474 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2016 12:00:00 AM 3 3x3 Permit Number 773044 6001780.62325 2117368.05955 37.7939889537763 -122.437812170719 (37.7939889537763, -122.437812170719) 13 9 1 57 27
160441 117453 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011539.59396 2111788.0027 37.779217520823 -122.403652162024 (37.779217520823, -122.403652162024) 14 2 9 28856 34
52945 117454 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 236 Shipley St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2016 12:00:00 AM 3 3x3 Permit Number 776408 6011519 2111785 37.7792081256956 -122.403723194086 (37.7792081256956, -122.403723194086) 14 2 9 28856 34
84600 117455 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 Shipley St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011503.45491 2111758.78759 37.7791352841027 -122.403775126323 (37.7791352841027, -122.403775126323) 14 2 9 28856 34
123746 117456 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 SHIPLEY ST 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011519 2111785 37.7792081256956 -122.403723194086 (37.7792081256956, -122.403723194086) 14 2 9 28856 34
160718 117479 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 1 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
166329 117480 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
187328 117481 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 3 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
184372 117482 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 4 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
26702 117483 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 5 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
25596 117510 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 23x BRIGHT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2016 12:00:00 AM 3 3x3   5993679 2087403 37.7112485771375 -122.463668552658 (37.7112485771375, -122.463668552658) 9 8 4 64 24
179827 118360 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
149634 118361 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
70059 118374 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 4x6   6014693.17098 2114681.80971 37.787338911495 -122.392945071183 (37.787338911495, -122.392945071183) 6 2 9 28855 6
5835 118375 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x6   6014712.48727 2114662.02755 37.7872856671566 -122.392876855803 (37.7872856671566, -122.392876855803) 6 2 9 28855 6
132870 118376 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
42633 118377 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
64723 118378 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
32270 118379 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
75283 118380 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
22723 119256 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 195 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2016 12:00:00 AM 3 3x3   6010242 2098801 37.7434855758555 -122.407225363197 (37.7434855758555, -122.407225363197) 2 7 7 28859 2
78754 119257 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 191 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2016 12:00:00 AM 3 3x3   6010220 2098811 37.743511802413 -122.407302138847 (37.743511802413, -122.407302138847) 2 7 7 28859 2
34845 119285 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 400 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2016 12:00:00 AM 3 4x4   6005873 2111410 37.7778614491402 -122.423228396467 (37.7778614491402, -122.423228396467) 7 9 11 28852 10
97781 119286 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 400 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2016 12:00:00 AM 3 4x4   6005873 2111410 37.7778614491402 -122.423228396467 (37.7778614491402, -122.423228396467) 7 9 11 28852 10
29612 119287 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 400 Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2016 12:00:00 AM 3 4x4   6005873 2111410 37.7778614491402 -122.423228396467 (37.7778614491402, -122.423228396467) 7 9 11 28852 10
117515 119808 Planning Code 138.1 required 2 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3 3x3 Permit Number 773331 6006048 2115627 37.7894501691998 -122.422922798032 (37.7894501691998, -122.422922798032) 13 9 1 28858 41
142552 120109 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 555 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2016 12:00:00 AM 3 3x3   5997970 2087042 37.7105036758619 -122.448811863159 (37.7105036758619, -122.448811863159) 9 7 6 28861 25
118314 120115 Planning Code 138.1 required 2 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2225 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6000127.23839 2120216.52423 37.8017159270068 -122.443737765003 (37.8017159270068, -122.443737765003) 13 9 1 57 17
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
90566 120518 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 520 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010156 2108818 37.7709851997146 -122.408229076629 (37.7709851997146, -122.408229076629) 8 2 9 28853 34
47024 120519 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 520 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010156 2108818 37.7709851997146 -122.408229076629 (37.7709851997146, -122.408229076629) 8 2 9 28853 34
125559 120527 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1672 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2016 12:00:00 AM 3 3x3   5981030 2103685 37.7552175094175 -122.508593851446 (37.7552175094175, -122.508593851446) 1 8 3 56 35
102650 120680 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 522 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2016 12:00:00 AM 3 3x3   6003717 2090174 37.7194304401491 -122.42917217064 (37.7194304401491, -122.42917217064) 9 7 6 28861 5
105730 120914 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1356 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/2016 12:00:00 AM 3 3x3   5989939 2106143 37.7624875866057 -122.477963922005 (37.7624875866057, -122.477963922005) 1 8 3 56 35
58719 121093 Planning Code 138.1 required 2 Tree(s) :: 17 150 Ridgewood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778915 5996816.77701 2094570.70089 37.7311097051787 -122.453340820219 (37.7311097051787, -122.453340820219) 9 7 4 59 40
146805 121136 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1875 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 12/04/2017 12:00:00 AM 3 3x3   6006784.10346 2107469.87255 37.7670941752111 -122.419796914586 (37.7670941752111, -122.419796914586) 8 4 7 28853 19
8598 121137 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
1751 121138 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
15566 121139 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
58189 121145 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 962 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2016 12:00:00 AM 3 3x3   5995080 2090346 37.7194099895512 -122.459039336024 (37.7194099895512, -122.459039336024) 9 8 6 28861 24
62537 121276 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
5543 121277 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
128498 121278 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
152002 121279 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26

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