trees
1,011 rows where qLegalStatus_id = 2 sorted by PermitNotes descending
This data as json, CSV (advanced)
qSiteInfo ✖
- Sidewalk: Curb side : Cutout 775
- Sidewalk: Property side : Cutout 54
- Sidewalk: Property side : Yard 22
- Front Yard : Yard 14
- Sidewalk: Curb side : Yard 9
- : 8
- Back Yard : Yard 6
- Unaccepted Street : Yard 6
- Sidewalk: Curb side : Pot 5
- Front Yard : Cutout 4
- Side Yard : Cutout 3
- Side Yard : Yard 3
- Back Yard : Cutout 1
- Unaccepted Street : Cutout 1
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
86670 | 146397 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3318 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 780850 | 6000857.39871 | 2119780.85133 | 37.8005613036105 | -122.441179804419 | (37.8005613036105, -122.441179804419) | 13 | 9 | 1 | 57 | 17 | |
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 | |
37766 | 150676 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 548 Rhode Island St | 1 | Front Yard : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780811 | 6011754.98399 | 2105812.52377 | 37.7628222449765 | -122.402486741392 | (37.7628222449765, -122.402486741392) | 8 | 3 | 8 | 28856 | 29 | |
4743 | 167761 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 451 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780770 | 6000439.87639 | 2107208.3352 | 37.7660166188918 | -122.441721798828 | (37.7660166188918, -122.441721798828) | 15 | 5 | 5 | 29492 | 3 | |
1810 | 253859 | Planning Code 138.1 required 2 | Prunus spp :: Cherry 68 | 130 Graystone Ter | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | Permit Number 780749 | 5998952.88335 | 2104176.47413 | 37.7576070480405 | -122.446646826709 | (37.7576070480405, -122.446646826709) | 2 | 5 | 5 | 28862 | 3 | |||
27355 | 239457 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | 2 | 7 | 5 | 63 | 7 | |
90355 | 222216 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | 2 | 7 | 5 | 63 | 7 | ||
115391 | 224618 | Planning Code 138.1 required 2 | Ficus microcarpa :: Chinese Banyan 97 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | 2 | 7 | 5 | 63 | 7 | ||
159683 | 239458 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Sussex St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001977.4736 | 2096494.97635 | 37.7366877772239 | -122.435637038029 | (37.7366877772239, -122.435637038029) | 2 | 7 | 5 | 63 | 7 | |
152110 | 239088 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.40071 | 37.748496089722 | -122.426200479689 | (37.748496089722, -122.426200479689) | 2 | 4 | 5 | 63 | 22 | ||
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 | |
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 | |
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 | |
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 | |
178223 | 256896 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 470 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780643 | 5985651.17942 | 2112710.44444 | 37.7802701294342 | -122.493277571063 | (37.7802701294342, -122.493277571063) | 11 | 6 | 2 | 55 | 26 | |
1902 | 261997 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 3 | 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 | |
2224 | 236583 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 1 | 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 | |
3426 | 231237 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009518.21853 | 2105339.01767 | 37.7613969805183 | -122.410189528218 | (37.7613969805183, -122.410189528218) | 2 | 4 | 7 | 28859 | 19 | |
3779 | 231240 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009523.77815 | 2105243.21899 | 37.7611342507514 | -122.410163536041 | (37.7611342507514, -122.410163536041) | 2 | 4 | 7 | 28859 | 19 | |
5042 | 231235 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009517.2839 | 2105385.27542 | 37.7615239413898 | -122.410196026727 | (37.7615239413898, -122.410196026727) | 2 | 4 | 7 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
14212 | 253124 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 399x Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780530 | |||||||||||
141327 | 253287 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1237 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780510 | 6016839.12241 | 2092718.79414 | 37.7271520593202 | -122.383990506478 | (37.7271520593202, -122.383990506478) | 10 | 3 | 8 | 58 | 1 | |
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 | |
36929 | 256611 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Terra Vista Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
78803 | 256612 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2375 Ofarrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
99613 | 256169 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
102847 | 256610 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Terra Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
30794 | 10153 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 978 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:51:00 AM | 3 | 3x3 | Permit Number 780464 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | 2 | 4 | 5 | 28859 | 19 | |
45743 | 161753 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022 | 2087749 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | 9 | 7 | 6 | 28861 | 5 | |
114847 | 253246 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173 | 2087586 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | 9 | 7 | 6 | 28861 | 5 | |
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 | |
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 | |
67232 | 256000 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Springfield Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2018 12:00:00 AM | 3 | 6x10 | Permit Number 780036 | 5986792.13129 | 2095812.03329 | 37.733938381975 | -122.488088482457 | (37.733938381975, -122.488088482457) | 1 | 8 | 4 | 64 | 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 | |
145785 | 253796 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.7331586170673 | -122.400946899168 | (37.7331586170673, -122.400946899168) | 10 | 3 | 8 | 58 | 1 | ||
64837 | 253415 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 Stoneybrook Ave | Front Yard : Cutout | Tree | Private 2 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.42686 | 37.7299849530428 | -122.421802746417 | (37.7299849530428, -122.421802746417) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |
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 | |
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 | |
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 | |
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 | |
8011 | 260843 | Planning Code 138.1 required 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1015 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779771 | 6011450.48648 | 2090129.50026 | 37.719743011404 | -122.402437083292 | (37.719743011404, -122.402437083292) | 10 | 7 | 8 | 309 | 28 | |
15356 | 251313 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 390 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2019 12:00:00 AM | 3 | 4x4 | Permit Number 779703 | 6003369 | 2099547 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | 2 | 7 | 5 | 63 | 22 | |
18657 | 251312 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2019 12:00:00 AM | 3 | 4x4 | Permit Number 779703 | 6003369 | 2099547 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | 2 | 7 | 5 | 63 | 22 | |
27287 | 255049 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 925 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779631 | 6009075.60356 | 2091383.60862 | 37.7230536656288 | -122.410734764023 | (37.7230536656288, -122.410734764023) | 9 | 3 | 7 | 309 | 28 | |
25098 | 257924 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1490x Green St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779557 | 6005922 | 2118675 | 37.79781210117 | -122.423575535726 | (37.79781210117, -122.423575535726) | 13 | 9 | 10 | 28858 | 32 | |
50619 | 257922 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1490x Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779557 | 6005922 | 2118675 | 37.79781210117 | -122.423575535726 | (37.79781210117, -122.423575535726) | 13 | 9 | 10 | 28858 | 32 | |
104150 | 257920 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1490x Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779557 | 6005922 | 2118675 | 37.79781210117 | -122.423575535726 | (37.79781210117, -122.423575535726) | 13 | 9 | 10 | 28858 | 32 | |
178936 | 257923 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1490x Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779557 | 6005922 | 2118675 | 37.79781210117 | -122.423575535726 | (37.79781210117, -122.423575535726) | 13 | 9 | 10 | 28858 | 32 | |
186623 | 257921 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1490x Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779557 | 6005922 | 2118675 | 37.79781210117 | -122.423575535726 | (37.79781210117, -122.423575535726) | 13 | 9 | 10 | 28858 | 32 | |
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 | |
179761 | 160920 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 666 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779533 | 6002104.11317 | 2090113.36167 | 37.7191725036747 | -122.434742983299 | (37.7191725036747, -122.434742983299) | 9 | 7 | 6 | 28861 | 5 | |
26571 | 150167 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 333 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779492 | 6014367.55242 | 2105483.96934 | 37.7620656102492 | -122.393427719319 | (37.7620656102492, -122.393427719319) | 10 | 3 | 8 | 28856 | 29 | |
8065 | 255771 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
8434 | 255770 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
71449 | 255772 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
172142 | 255773 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
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 | |||
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 | |
59056 | 160371 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001686.38396 | 2088939.39451 | 37.7159253269669 | -122.436102948002 | (37.7159253269669, -122.436102948002) | 9 | 7 | 6 | 28861 | 5 | |
158600 | 160369 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001700.06015 | 2088961.7176 | 37.7159873981889 | -122.436057273237 | (37.7159873981889, -122.436057273237) | 9 | 7 | 6 | 28861 | 5 | |
179839 | 160370 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001693.73373 | 2088950.71414 | 37.715956825716 | -122.436078353349 | (37.715956825716, -122.436078353349) | 9 | 7 | 6 | 28861 | 5 | |
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 | |
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 | |
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 | |
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 | |
177206 | 36045 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 2 | 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 | |
49446 | 257939 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 65 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779175 | 6001128.17111 | 2108817.40029 | 37.7704739053605 | -122.439456486198 | (37.7704739053605, -122.439456486198) | 15 | 5 | 11 | 29492 | 9 | |
161200 | 257940 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 65 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779175 | 6001128.17111 | 2108817.40029 | 37.7704739053605 | -122.439456486198 | (37.7704739053605, -122.439456486198) | 15 | 5 | 11 | 29492 | 9 | |
103770 | 170499 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 1178 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003338.82121 | 2094328.64534 | 37.7308167537817 | -122.430775723045 | (37.7308167537817, -122.430775723045) | 9 | 7 | 5 | 28861 | 25 | |
147840 | 170500 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 1178 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003320.2391 | 2094320.37512 | 37.7307929928046 | -122.430839374365 | (37.7307929928046, -122.430839374365) | 9 | 7 | 5 | 28861 | 25 | |
151446 | 170486 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 121 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003308.3245 | 2094432.02915 | 37.7310988944888 | -122.430888530379 | (37.7310988944888, -122.430888530379) | 9 | 7 | 5 | 28861 | 25 | |
163376 | 253126 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 182 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779117 | 6002742.73008 | 2092646.20381 | 37.7261633586637 | -122.432716365158 | (37.7261633586637, -122.432716365158) | 9 | 7 | 6 | 28861 | 5 | ||
1962 | 122597 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
19209 | 122592 | Planning Code 138.1 required 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
27168 | 75842 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
29570 | 105276 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 64 Townsend St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015520.22928 | 2112423.42174 | 37.7811837949483 | -122.389925782657 | (37.7811837949483, -122.389925782657) | 6 | 2 | 9 | 28856 | 6 | |
34241 | 122599 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
60760 | 122593 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 72 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
72432 | 122594 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 72 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
95774 | 105277 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 64 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015510.23316 | 2112419.28649 | 37.7811718861147 | -122.38996007562 | (37.7811718861147, -122.38996007562) | 6 | 2 | 9 | 28856 | 6 | |
100384 | 122598 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
104520 | 105275 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 64 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015531.53579 | 2112438.89481 | 37.7812269075454 | -122.389887748547 | (37.7812269075454, -122.389887748547) | 6 | 2 | 9 | 28856 | 6 | |
111086 | 122596 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
118733 | 72480 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
180599 | 75872 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
5173 | 169519 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1753 Noe St | 1 | Front Yard : Yard | Tree | Private 2 | 0 | 8x8 | Permit Number 779099 | 6003417.91334 | 2098032.77345 | 37.7409919262491 | -122.430766523865 | (37.7409919262491, -122.430766523865) | 2 | 7 | 5 | 63 | 7 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );