trees
61 rows where qLegalStatus_id = 2 and qSpecies_id = 14 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98758 | 101942 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010108.29372 | 2111885.47528 | 37.7794051005107 | -122.408610520167 | (37.7794051005107, -122.408610520167) | 14 | 2 | 9 | 28853 | 34 | |
191974 | 108030 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 601 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2014 12:00:00 AM | 3 | 3x3 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
161064 | 114972 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1431 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777191 | 6000962.5 | 2110659.8 | 37.7755232425188 | -122.440161680014 | (37.7755232425188, -122.440161680014) | 15 | 5 | 11 | 29492 | 10 | |
122740 | 115096 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010119.08101 | 2111896.4319 | 37.7794357889593 | -122.408573975335 | (37.7794357889593, -122.408573975335) | 14 | 2 | 9 | 28853 | 34 | |
183224 | 115097 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010133.89472 | 2111910.59383 | 37.779475503918 | -122.408523727481 | (37.779475503918, -122.408523727481) | 14 | 2 | 9 | 28853 | 34 | |
57149 | 115098 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010148.06204 | 2111925.42664 | 37.7795170247346 | -122.408475763058 | (37.7795170247346, -122.408475763058) | 14 | 2 | 9 | 28853 | 34 | |
167439 | 115530 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007332.44961 | 2111311.79762 | 37.7776740647351 | -122.418172674243 | (37.7776740647351, -122.418172674243) | 7 | 9 | 9 | 28852 | 36 | |
84579 | 116262 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 35 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2016 12:00:00 AM | 3 | 3x4 | 6005278.18089 | 2092026.49943 | 37.7246052551119 | -122.42390739822 | (37.7246052551119, -122.42390739822) | 9 | 7 | 6 | 309 | 5 | ||
27582 | 116803 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 931 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2016 12:00:00 AM | 3 | 3x3 | 6007342.71844 | 2093540.39539 | 37.7288784251848 | -122.416877747635 | (37.7288784251848, -122.416877747635) | 9 | 3 | 7 | 309 | 28 | ||
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 | |
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 | |
2678 | 157809 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 647 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781831 | 6002443.37703 | 2099727.28553 | 37.7455893990301 | -122.4342572226 | (37.7455893990301, -122.4342572226) | 2 | 7 | 5 | 63 | 22 | |
11885 | 157920 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4147 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777832 | 6002961.17206 | 2100636.31842 | 37.7481147664022 | -122.432531686182 | (37.7481147664022, -122.432531686182) | 2 | 4 | 5 | 63 | 22 | |
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 | |
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 | |
167666 | 173650 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Entrada Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.45657 | 2092194.59394 | 37.7243327619491 | -122.468352901223 | (37.7243327619491, -122.468352901223) | 9 | 8 | 4 | 59 | 40 | ||
126952 | 175423 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 175 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2017 12:00:00 AM | 3 | Width 3ft | 6004547.44022 | 2093795.9618 | 37.7294225258266 | -122.426559415306 | (37.7294225258266, -122.426559415306) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |
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 | |
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 | |
48832 | 243143 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
100425 | 243144 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
71010 | 251406 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 445 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2017 12:00:00 AM | 3 | 3x3 | 6001636 | 2088904 | 37.7158252789105 | -122.436274566668 | (37.7158252789105, -122.436274566668) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |
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 | |
122256 | 254396 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774780 | 6006150.23201 | 2093073.81475 | 37.7275301484246 | -122.420967149802 | (37.7275301484246, -122.420967149802) | 9 | 7 | 7 | 309 | 5 | |
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 | ||
24808 | 254852 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2816 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5986739 | 2113291 | 37.7819277358837 | -122.48955705182 | (37.7819277358837, -122.48955705182) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
176317 | 256115 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 503 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774745 | 6007867.72621 | 2096528.91607 | 37.7371137709195 | -122.41527422465 | (37.7371137709195, -122.41527422465) | 2 | 7 | 7 | 28859 | 2 | |
172284 | 256143 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4068 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2018 12:00:00 AM | 3 | 3x3 | 6003463 | 2100411 | 37.7475245395629 | -122.430780306583 | (37.7475245395629, -122.430780306583) | 2 | 4 | 5 | 63 | 22 | ||
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 | |
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 | |
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 | |
140218 | 256881 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3075 25th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x10 | Permit Number 781920 | 5988824.60597 | 2094879.63635 | 37.7314966214822 | -122.480993433312 | (37.7314966214822, -122.480993433312) | 1 | 8 | 4 | 64 | 35 | |
95904 | 256882 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3075 25th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x10 | Permit Number 781920 | 5988824.60597 | 2094879.63635 | 37.7314966214822 | -122.480993433312 | (37.7314966214822, -122.480993433312) | 1 | 8 | 4 | 64 | 35 | |
170182 | 258184 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 95 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003372 | 2097903 | 37.74063299685 | -122.430916015884 | (37.74063299685, -122.430916015884) | 2 | 7 | 5 | 63 | 7 | ||||
120065 | 258340 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 121 Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2019 12:00:00 AM | 3 | 3x3 | 6010033.53413 | 2086907.42536 | 37.7108166491636 | -122.407108010284 | (37.7108166491636, -122.407108010284) | 9 | 7 | 8 | 309 | 39 | ||
11143 | 258742 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 367 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774042 | 6003945 | 2103884 | 37.7570878795298 | -122.429361203627 | (37.7570878795298, -122.429361203627) | 2 | 4 | 5 | 28862 | 3 | |
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 | |
131750 | 39246 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3524 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 1 | Permit Number 772836 | 5997390.1418 | 2116079.35829 | 37.7901998932662 | -122.452910535096 | (37.7901998932662, -122.452910535096) | 11 | 6 | 1 | 54 | 31 | ||
40028 | 57959 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 336 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774423 | 5999490.29697456 | 2086502.70799744 | 37.7091097236101 | -122.443518692288 | (37.7091097236101, -122.443518692288) | 9 | 7 | 6 | 28861 | 5 | |
119022 | 60277 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2690 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51145 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||
17726 | 65839 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2328 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2018 12:00:00 AM | 3 | 6x6 | Permit Number 772721 | 5999589.88517 | 2120533.82376 | 37.802556482867 | -122.445620078411 | (37.802556482867, -122.445620078411) | 13 | 9 | 1 | 57 | 17 |
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) );