66 rows where Supervisor Districts = 3 and qLegalStatus_id = 2 sorted by PermitNotes

View and edit SQL

Supervisor 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)
2139 251538 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981086 2103156 37.753768326371 -122.508360924805 (37.753768326371, -122.508360924805) 1 8 3 56 35
3289 262310 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1356 20th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/26/2016 12:00:00 AM       5989914.31197 2106134.19071 37.7624619657204 -122.478048663847 (37.7624619657204, -122.478048663847) 1 8 3 56 35
15585 258769 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 1633 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2019 12:00:00 AM 3 3x3   5988962.35654 2103065.4403 37.7539807026125 -122.481116375927 (37.7539807026125, -122.481116375927) 1 8 3 56 35
37901 251534 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1818 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2017 12:00:00 AM 3 3x3   5983226 2102732 37.7527300247516 -122.500929082058 (37.7527300247516, -122.500929082058) 1 8 3 56 35
55332 115079 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981053.87958296 2103176.2415425 37.7538220108937 -122.508473505042 (37.7538220108937, -122.508473505042) 1 8 3 56 35
56397 251539 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981086 2103156 37.753768326371 -122.508360924805 (37.753768326371, -122.508360924805) 1 8 3 56 35
64249 252820 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 2339 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2017 12:00:00 AM 3 3x3   5983590.30233 2099230.68636 37.743137766616 -122.499410557243 (37.743137766616, -122.499410557243) 1 8 3 29491 35
64628 113721 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1526 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2015 12:00:00 AM   3x3   5989360 2104938.6 37.7591470062831 -122.479878309336 (37.7591470062831, -122.479878309336) 1 8 3 56 35
65989 255377 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 35
77927 187639 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1671 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2017 12:00:00 AM 3 3x6   5985585 2103854 37.7559489545124 -122.492853989295 (37.7559489545124, -122.492853989295) 1 8 3 56 35
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
101680 255378 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 35
104008 79418 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2001 12:00:00 AM   3x3   5981053.87958296 2103176.2415425 37.7538220108937 -122.508473505042 (37.7538220108937, -122.508473505042) 1 8 3 56 35
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
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
165057 255376 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 35
172845 255375 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 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
184867 112863 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2451 19TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2015 12:00:00 AM 3 3x3   5990427 2098705 37.7420931085193 -122.475732948104 (37.7420931085193, -122.475732948104) 1 8 3 29491 35
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
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
49225 53968 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1354 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773113 5988678.33594659 2106104.92629407 37.7623097958053 -122.482321255458 (37.7623097958053, -122.482321255458) 1 8 3 56 35
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
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
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
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
95009 173748 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1259 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 773489 5989520 2106786 37.7642287625639 -122.479460118399 (37.7642287625639, -122.479460118399) 1 8 3 56 35
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
53166 112854 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2622 JUDAH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 774112 5986417 2105735 37.7611622818619 -122.49011505097 (37.7611622818619, -122.49011505097) 1 8 3 56 35
114870 253576 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2622 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 774112 5986417 2105735 37.7611622818619 -122.49011505097 (37.7611622818619, -122.49011505097) 1 8 3 56 35
151100 81972 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1822 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/2015 12:00:00 AM 3 3x6 Permit Number 774361 5989407.90008391 2102936.76390687 37.7536532824256 -122.479566183797 (37.7536532824256, -122.479566183797) 1 8 3 56 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
105599 256614 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1483 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2018 12:00:00 AM 3 3x3 Permit Number 776026 5987111.69916 2105187.42749 37.7596993421459 -122.487672186767 (37.7596993421459, -122.487672186767) 1 8 3 56 35
145605 183545 Planning Code 138.1 required 2 Agonis flexuosa :: Peppermint Willow 65 2580 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 4x4 Permit Number 777874 5988340.9772 2097760.0505 37.7393773655768 -122.482876432223 (37.7393773655768, -122.482876432223) 1 8 3 29491 35
120709 253166 Planning Code 138.1 required 2 Pyrus kawakamii :: Evergreen Pear 83 2405 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2017 12:00:00 AM 3 3x3 Permit Number 778209 5986396.6612 2098868.17463 37.742306656921 -122.489680395865 (37.742306656921, -122.489680395865) 1 8 3 29491 35
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
82445 254665 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1771 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/2018 12:00:00 AM 3 3x3 Permit Number 778441 5989948 2103325 37.7547506343258 -122.477726795598 (37.7547506343258, -122.477726795598) 1 8 3 56 35
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
194213 253623 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1331 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2017 12:00:00 AM 3 3x3 Permit Number 778744 5983976.42262 2106100.27997 37.7620224120695 -122.498582815109 (37.7620224120695, -122.498582815109) 1 8 3 56 35
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
37533 253101 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3000x Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427 2106455 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734) 1 8 3 56 35
156097 253105 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1295 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427 2106455 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734) 1 8 3 56 35
169212 253102 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3000x Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427 2106455 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734) 1 8 3 56 35
176443 253103 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3000x Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427 2106455 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734) 1 8 3 56 35
186709 253104 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3000x Irving St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427 2106455 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734) 1 8 3 56 35
39420 253554 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1855 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2017 12:00:00 AM 3 3x3 Permit Number 778968 5986885.63083 2102641.2721 37.7526951056681 -122.488266922919 (37.7526951056681, -122.488266922919) 1 8 3 56 35
16409 54948 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1531 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/1972 12:00:00 AM 15 6x3 Permit Number 779312 5982470.8167 2104681.2673 37.7580377938942 -122.503684942327 (37.7580377938942, -122.503684942327) 1 8 3 56 35
35612 255646 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1542 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2018 12:00:00 AM 3 3x5 Permit Number 779777 5989956.05847 2104865.26605 37.7589802621415 -122.477811515827 (37.7589802621415, -122.477811515827) 1 8 3 56 35
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
102182 253344 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2586 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945) 1 8 3 29491 35
93370 255421 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2727 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   05/21/2018 12:00:00 AM 3 10x10 Permit Number 780223 5985829 2096861 37.7367623321138 -122.491495459369 (37.7367623321138, -122.491495459369) 1 8 3 29491 35
4820 253072 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1350 46th Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/18/2019 12:00:00 AM 3 6x10 Permit Number 780489 5981849.66657 2105897.22193 37.7613399178539 -122.50592325662 (37.7613399178539, -122.50592325662) 1 8 3 56 35
20702 37086 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1426 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/2017 12:00:00 AM 3   Permit Number 780691 5981873.63686209 2105374.96731705 37.7599073668224 -122.505801636192 (37.7599073668224, -122.505801636192) 1 8 3 56 35
41357 255423 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 1 8 3 29491 35
56985 255424 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 1 8 3 29491 35
170704 255422 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 1 8 3 29491 35
35632 182616 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1856 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   11/16/2018 12:00:00 AM 0 Width 0ft Permit Number 780914 5987553.0951 2102630.1854 37.7527035840583 -122.485957928463 (37.7527035840583, -122.485957928463) 1 8 3 56 35
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
81070 256613 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 2214 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2018 12:00:00 AM 3 3x3 Permit Number 781468 5985177 2100108 37.745639596763 -122.493988903155 (37.745639596763, -122.493988903155) 1 8 3 29491 35
4524 183636 Planning Code 138.1 required 2 Pittosporum crassifolium :: Karo Tree 95 1478 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/02/2020 12:00:00 AM 3 3x9 Permit Number 781673 5981570.9282 2105017.3718 37.7589076903569 -122.506822015648 (37.7589076903569, -122.506822015648) 1 8 3 56 35
131553 256083 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2187 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/2018 12:00:00 AM 3 3x3 Permit Number 781873 5989736 2100494 37.7469651502436 -122.478252958666 (37.7469651502436, -122.478252958666) 1 8 3 29491 35
22749 184649 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1688 42nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft Permit Number 782197 5983169.0582 2103665.8835 37.7552908641291 -122.501195062681 (37.7552908641291, -122.501195062681) 1 8 3 56 35
138593 56707 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1688 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8   Permit Number 782197 5983170.4061 2103643.307 37.7552289545408 -122.501188731534 (37.7552289545408, -122.501188731534) 1 8 3 56 35
14905 260579 Planning Code 138.1 required 2 Tree(s) :: 17 1662 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x3 Permit Number 782799 5985048 2103886 37.7560054004173 -122.494713443881 (37.7560054004173, -122.494713443881) 1 8 3 56 35
6587 261546 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 1955 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2020 12:00:00 AM 3 3X3 Permit Number 783144 5985360.77923 2101907.46183 37.750591180724 -122.493485992107 (37.750591180724, -122.493485992107) 1 8 3 29491 35
9544 261378 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1762 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2020 12:00:00 AM 3 3x3 Permit Number 784740 5990006.33488 2103376.99766 37.7548967913393 -122.477528860126 (37.7548967913393, -122.477528860126) 1 8 3 56 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)
);