trees
159 rows where Supervisor Districts = 7 and qLegalStatus_id = 2 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
176471 | 252908 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 600 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | 8 | 4 | 7 | 28859 | 19 | |
176658 | 252906 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 600 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | 8 | 4 | 7 | 28859 | 19 | |
178976 | 252905 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 600 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | 8 | 4 | 7 | 28859 | 19 | |
58996 | 242613 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.7444035295914 | -122.417403753004 | (37.7444035295914, -122.417403753004) | 2 | 7 | 7 | 28859 | 2 | ||
120060 | 221127 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1218 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 778419 | 6008662.3869 | 2101444.26707 | 37.750654869142 | -122.412874131348 | (37.750654869142, -122.412874131348) | 2 | 4 | 7 | 28859 | 19 | |
524 | 225191 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
1462 | 225196 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007182.851 | 2103832.80652 | 37.7571300930895 | -122.418159821127 | (37.7571300930895, -122.418159821127) | 2 | 4 | 7 | 28859 | 19 | ||
1675 | 225195 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007206.11976 | 2103835.77909 | 37.7571395647689 | -122.418079559351 | (37.7571395647689, -122.418079559351) | 2 | 4 | 7 | 28859 | 19 | ||
3329 | 260429 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
3713 | 225189 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
6489 | 225192 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
7744 | 225194 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778605 | 6007219.63733 | 2103836.19178 | 37.7571414587344 | -122.418032839538 | (37.7571414587344, -122.418032839538) | 2 | 4 | 7 | 28859 | 19 | ||
9271 | 225190 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
11511 | 225198 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007149.23047 | 2103831.77129 | 37.7571253581517 | -122.418276020715 | (37.7571253581517, -122.418276020715) | 2 | 4 | 7 | 28859 | 19 | ||
11548 | 225197 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007163.79352 | 2103832.50742 | 37.7571281991351 | -122.418225708166 | (37.7571281991351, -122.418225708166) | 2 | 4 | 7 | 28859 | 19 | ||
12438 | 260430 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
13706 | 225187 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
17210 | 225188 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
100907 | 229627 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3662 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778622 | 6008456.11159 | 2097816.22885 | 37.7406815009641 | -122.413330912287 | (37.7406815009641, -122.413330912287) | 2 | 7 | 7 | 28859 | 2 | |
6077 | 230988 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 44 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2018 12:00:00 AM | 3 | 3x6 | Permit Number 778706 | 6007424.10799 | 2099038.48568 | 37.7439795505181 | -122.416985775987 | (37.7439795505181, -122.416985775987) | 2 | 7 | 7 | 28859 | 2 | |
3 | 121463 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
27 | 121462 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
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 | |
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 | |
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 | |
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 | |
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 | |
119839 | 152118 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 44 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780873 | 6006474.76942 | 2108215.62621 | 37.7691244070031 | -122.420919809024 | (37.7691244070031, -122.420919809024) | 8 | 4 | 7 | 28853 | 19 | |
21868 | 221950 | Planning Code 138.1 required 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 31 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 780973 | 6006097.6775 | 2099053.58173 | 37.7439462971915 | -122.421573349947 | (37.7439462971915, -122.421573349947) | 2 | 7 | 7 | 28859 | 2 | ||
685 | 151339 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781016 | 6009578.8057 | 2100900.01209 | 37.7492118628581 | -122.409666655187 | (37.7492118628581, -122.409666655187) | 2 | 4 | 7 | 28859 | 19 | |
99548 | 256905 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 338 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781421 | 6007824.5446 | 2092249.93927 | 37.7253622000817 | -122.415120729164 | (37.7253622000817, -122.415120729164) | 9 | 3 | 7 | 309 | 28 | |
182124 | 166234 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 2986 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781629 | 6008392.95809 | 2103319.50363 | 37.7557887182862 | -122.413938481678 | (37.7557887182862, -122.413938481678) | 2 | 4 | 7 | 28859 | 19 | |
173437 | 255664 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 368 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781650 | 6007860.32032 | 2092132.7947 | 37.7250425565594 | -122.414988767826 | (37.7250425565594, -122.414988767826) | 9 | 3 | 7 | 309 | 28 | |
71950 | 176972 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 161 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | Permit Number 781886 | 6008005.59306 | 2093164.83572 | 37.7278844827614 | -122.414559571484 | (37.7278844827614, -122.414559571484) | 9 | 3 | 7 | 309 | 28 | ||
5901 | 260465 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2019 12:00:00 AM | 3 | 3x4 | Permit Number 782033 | 6005003.24747 | 2095750.87761 | 37.7348160467336 | -122.425122689163 | (37.7348160467336, -122.425122689163) | 2 | 7 | 7 | 28861 | 2 | |
161840 | 148099 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 509 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782106 | 6009909.13224 | 2092063.05855 | 37.7249659929773 | -122.40790129952 | (37.7249659929773, -122.40790129952) | 10 | 3 | 7 | 309 | 28 | |
82212 | 156914 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 2995 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009047.12311 | 2101072.92433 | 37.7496568330138 | -122.411517443787 | (37.7496568330138, -122.411517443787) | 2 | 4 | 7 | 28859 | 19 | |
125934 | 256878 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
152203 | 152615 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
179256 | 152616 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009096.56353 | 2101019.92176 | 37.7495140728181 | -122.411342732484 | (37.7495140728181, -122.411342732484) | 2 | 4 | 7 | 28859 | 19 | |
8319 | 260505 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 760 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784870 | 6007464 | 2105234 | 37.7609932681872 | -122.417286789238 | (37.7609932681872, -122.417286789238) | 2 | 4 | 7 | 28859 | 19 |
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) );