56 rows where qLegalStatus_id = 2 and qSiteInfo = "Sidewalk: Property side : Cutout"

View and edit SQL

These facets timed out: Supervisor Districts, qSiteInfo

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)
1560 258220 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 477 Eucalyptus Dr 2 Sidewalk: Property side : Cutout Tree Private 2   07/03/2019 12:00:00 AM 3 3x3 Permit Number 774069 5989683 2094686 37.7310148065902 -122.478011682019 (37.7310148065902, -122.478011682019) 1 8 4 64 14
5670 253203 Planning Code 138.1 required 2 Acer buergeranum :: Trident Maple 110 349 Mangels Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF   3 3x3   5999103 2095207 37.732987611392 -122.445482716078 (37.732987611392, -122.445482716078) 9 7 4 59 40
11745 260192 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1699 Market St 5 Sidewalk: Property side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 4X4   6006124.91889 2109483.72494 37.7725865765291 -122.422220029928 (37.7725865765291, -122.422220029928) 8 2 9 28853 19
14929 256105 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1935 34th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 Port 09/06/2018 12:00:00 AM 3 3x3 Permit Number 778629 5985666.45669 2102048.38182 37.7509959848908 -122.492439326416 (37.7509959848908, -122.492439326416) 1 8 3 29491 35
17276 72565 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 1 Sidewalk: Property side : Cutout Tree Private 2     3 4x4 Permit Number 770847 6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
17886 261591 Planning Code 138.1 required 2 :: 45 1747 Cayuga Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/28/2020 12:00:00 AM 3   Permit Number 784552 5998049.81023 2088594.07996 37.7147698965646 -122.44864773571 (37.7147698965646, -122.44864773571) 9 7 6 28861 25
18060 258219 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 477 Eucalyptus Dr 1 Sidewalk: Property side : Cutout Tree Private 2   07/03/2019 12:00:00 AM 3 3x3 Permit Number 774069 5989683 2094686 37.7310148065902 -122.478011682019 (37.7310148065902, -122.478011682019) 1 8 4 64 14
18138 260191 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1699 Market St 4 Sidewalk: Property side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 4X4   6006124.91889 2109483.72494 37.7725865765291 -122.422220029928 (37.7725865765291, -122.422220029928) 8 2 9 28853 19
24135 254150 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2123 30th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 3x6 Permit Number 778310 5986951.71761 2100810.65655 37.7476725845461 -122.487903895201 (37.7476725845461, -122.487903895201) 1 8 3 29491 35
25630 255709 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2458 40th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   06/28/2018 12:00:00 AM 3 3x3 Permit Number 775348 5983968.47211 2098431.39968 37.740965323086 -122.498043953777 (37.740965323086, -122.498043953777) 1 8 3 29491 35
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
35800 121504 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 4 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014396.4001 2115093.29031 37.7884522533286 -122.394000660325 (37.7884522533286, -122.394000660325) 6 2 9 28855 6
36667 112972 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4099x ULLOA ST 1 Sidewalk: Property side : Cutout Tree Private 2   10/20/2015 12:00:00 AM 1 3x3 Permit Number 773327 5983385 2098079 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652) 1 8 3 29491 35
36960 113338 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 3 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
37189 121502 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 2 Sidewalk: Property side : Cutout Tree Private 2     4 10x4   6014428.99687 2115060.94265 37.7883652457059 -122.393885614549 (37.7883652457059, -122.393885614549) 6 2 9 28855 6
38353 256715 Planning Code 138.1 required 2 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 1540 17th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/15/2019 12:00:00 AM 3 4x8 Permit Number 779534 5990911 2104908 37.7591529734205 -122.474512031039 (37.7591529734205, -122.474512031039) 1 8 4 56 12
39006 253854 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 650 Joost Ave 1 Sidewalk: Property side : Cutout Tree Private 2   11/20/2017 12:00:00 AM 3 10x9 Permit Number 776163 5997782.66631 2095011.71334 37.7323759368037 -122.450033362597 (37.7323759368037, -122.450033362597) 9 7 4 59 40
40751 121505 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 5 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014377.50413 2115113.61118 37.7885069995398 -122.394067461056 (37.7885069995398, -122.394067461056) 6 2 9 28855 6
42827 253341 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1935 46th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.68101 2101921.14451 37.7504283278742 -122.505299944249 (37.7504283278742, -122.505299944249) 1 8 3 29491 35
45850 112974 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4099x ULLOA ST 3 Sidewalk: Property side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385 2098079 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652) 1 8 3 29491 35
51709 173899 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
62167 121518 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 13 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
64240 112973 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4099x ULLOA ST 2 Sidewalk: Property side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385 2098079 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652) 1 8 3 29491 35
66507 121501 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 1 Sidewalk: Property side : Cutout Tree Private 2     4 10x4   6014441.60375 2115047.86993 37.7883300516388 -122.393841081021 (37.7883300516388, -122.393841081021) 6 2 9 28855 6
68264 173898 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
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
80043 255924 Planning Code 138.1 required 2 Maytenus boaria :: Mayten 58 454 Ralston St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5992261 2090872 37.7206918008503 -122.468821743954 (37.7206918008503, -122.468821743954) 9 8 6 64 24
80342 121514 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 9 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
84340 115405 Planning Code 138.1 required 2 Podocarpus macrophyllus :: Yew Pine 137 2050 43RD AVE 1 Sidewalk: Property side : Cutout Tree Private 2   01/29/2016 12:00:00 AM 3 3x3   5982969 2101168 37.7484206232379 -122.50170211889 (37.7484206232379, -122.50170211889) 1 8 3 29491 35
94254 121506 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 1 Sidewalk: Property side : Cutout Tree Private 2     11 3x3   6012227.3168 2112699.1751 37.7817577819585 -122.401337080379 (37.7817577819585, -122.401337080379) 6 2 9 28856 34
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
101009 121510 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
102091 121512 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
106240 122625 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 189 Country Club Dr 1 Sidewalk: Property side : Cutout Tree Private 2   11/15/2016 12:00:00 AM 3 4x5 Permit Number 774974 5984222 2094938 37.7313882480876 -122.496909587532 (37.7313882480876, -122.496909587532) 1 8 4 64 35
106371 121516 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 11 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
107033 104876 Planning Code 138.1 required 2 Prunus laurocerasus :: English laurel 371 2478 43rd Ave   Sidewalk: Property side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.7404797966413 -122.501143676277 (37.7404797966413, -122.501143676277) 1 8 3 29491 35
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
120636 121503 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 3 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014412.49464 2115075.87435 37.7884053276005 -122.393943755694 (37.7884053276005, -122.393943755694) 6 2 9 28855 6
124554 112975 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4099x ULLOA ST 4 Sidewalk: Property side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385 2098079 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652) 1 8 3 29491 35
125850 113335 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 1 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
129348 251179 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
138609 251178 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
144548 254740 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1814 42nd Ave 1 Sidewalk: Property side : Cutout Tree Private 2   03/27/2018 12:00:00 AM 3 3x3 Permit Number 779958 5983225 2102757 37.752798609062 -122.500934388909 (37.752798609062, -122.500934388909) 1 8 3 56 35
160249 113337 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
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
160922 121508 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 3 Sidewalk: Property side : Cutout Tree Private 2     6 3x3   6012258.9126 2112729.3972 37.7818425275943 -122.401229897449 (37.7818425275943, -122.401229897449) 6 2 9 28856 34
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
167627 256505 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 4023 Pacheco St 1 Sidewalk: Property side : Cutout Tree Private 2   10/15/2018 12:00:00 AM 3 4x4 Permit Number 780999 5982525.89889 2101484.48033 37.7492635534225 -122.50325775688 (37.7492635534225, -122.50325775688) 1 8 3 29491 35
171095 122627 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 34 Country Club Dr 1 Sidewalk: Property side : Cutout Tree Private 2   11/15/2016 12:00:00 AM 3 3x4 Permit Number 775279 5984731 2094410 37.7299683129055 -122.495110985344 (37.7299683129055, -122.495110985344) 1 8 4 64 35
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
178269 122626 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 330 Country Club Dr 1 Sidewalk: Property side : Cutout Tree Private 2   11/15/2016 12:00:00 AM 3 3x5 Permit Number 774975 5984613 2095517 37.7330009316807 -122.495600537949 (37.7330009316807, -122.495600537949) 1 8 4 64 35
180231 254400 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2346 46th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   02/12/2018 12:00:00 AM 3 3X3   5982081.05878 2099125.72352 37.7427609043033 -122.504621254744 (37.7427609043033, -122.504621254744) 1 8 3 29491 35
183412 121520 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 15 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
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
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
194418 265072 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2027 41st Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5983517.97374 2101348.17171 37.7489475550359 -122.499817124771 (37.7489475550359, -122.499817124771) 1 8 3 29491 35

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