trees
145 rows where qSpecies_id = 181 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29622 | 96478 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2011 12:00:00 AM | 3x3 | Permit Numbe 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
30953 | 92220 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
31219 | 92221 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
33507 | 95540 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4750 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767327 | 6000130.6 | 2101122.2 | 37.7492879573628 | -122.442354552038 | (37.7492879573628, -122.442354552038) | 2 | 4 | 5 | 28862 | 22 | |
39655 | 114962 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 220 Evelyn Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.450116261368 | (37.7429206264442, -122.450116261368) | 9 | 7 | 4 | 59 | 40 | |||
41375 | 96477 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2011 12:00:00 AM | 3x3 | Permit number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
48916 | 45137 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1234 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53510 | 6000650.05093889 | 2109301.35578788 | 37.7717755038706 | -122.441145029184 | (37.7717755038706, -122.441145029184) | 15 | 5 | 11 | 29492 | 9 | ||
49877 | 88184 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 489 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767583 | 6010914.9 | 2111745.1 | 37.7790648045054 | -122.405810224266 | (37.7790648045054, -122.405810224266) | 14 | 2 | 9 | 28853 | 34 | ||
52396 | 115779 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 864 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775643 | 6009345.7 | 2104137.1 | 37.7580871157921 | -122.410701317143 | (37.7580871157921, -122.410701317143) | 2 | 4 | 7 | 28859 | 19 | ||
52532 | 256670 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2115 Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782609 | 6006830.64787 | 2118452.41017 | 37.7972521720159 | -122.42041554717 | (37.7972521720159, -122.42041554717) | 13 | 9 | 10 | 28858 | 32 | |
55226 | 88252 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1025 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131 | 2106547 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | 15 | 5 | 11 | 29492 | 9 | |||
59104 | 92219 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
61970 | 88249 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4758 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51235 | 5998426 | 2105687 | 37.7617244639768 | -122.448577782387 | (37.7617244639768, -122.448577782387) | 15 | 5 | 11 | 29492 | 9 | |||
63591 | 256687 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2325 Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782619 | 6006732.00195 | 2119165.45043 | 37.7992044415718 | -122.420807535438 | (37.7992044415718, -122.420807535438) | 5 | 9 | 1 | 28858 | 32 | |
65175 | 87928 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2x TRAINOR ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50952 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | ||
65448 | 84437 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 635 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53514 | 6007921.04355944 | 2104231.6010622 | 37.7582666141285 | -122.415635095313 | (37.7582666141285, -122.415635095313) | 2 | 4 | 7 | 28859 | 19 | ||
67156 | 88254 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 107 Belvedere St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51239 | 5998213 | 2108192 | 37.768590378969 | -122.449494963351 | (37.768590378969, -122.449494963351) | 15 | 5 | 11 | 29492 | 9 | |||
70681 | 63131 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 12 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52579 | 6007273.52756305 | 2099560.25449012 | 37.745403739192 | -122.417543422292 | (37.745403739192, -122.417543422292) | 2 | 7 | 7 | 28859 | 2 | ||
72908 | 32056 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 3516 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52612 | 6003328.9813191 | 2106558.55926414 | 37.7643966822396 | -122.431682578762 | (37.7643966822396, -122.431682578762) | 15 | 4 | 5 | 28862 | 3 | |
72954 | 95530 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 3325 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767321 | 5982880 | 2100129 | 37.7455625889452 | -122.501933006964 | (37.7455625889452, -122.501933006964) | 1 | 8 | 3 | 29491 | 35 | |
73236 | 88248 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4418 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51234 | 6000065 | 2105781 | 37.7620761444221 | -122.442915908064 | (37.7620761444221, -122.442915908064) | 15 | 5 | 5 | 28862 | 3 | |||
76201 | 92222 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
77188 | 95705 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 531 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767453 | 5992416 | 2103429 | 37.7551791102968 | -122.469199421964 | (37.7551791102968, -122.469199421964) | 1 | 8 | 4 | 56 | 12 | |
81594 | 95568 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 353 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767360 | 6002854 | 2101511 | 37.7505103579798 | -122.432964764241 | (37.7505103579798, -122.432964764241) | 2 | 4 | 5 | 28862 | 22 | |
88439 | 254690 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1666 28th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781577 | 5987504.11579 | 2103945.47752 | 37.7563121659062 | -122.486223855163 | (37.7563121659062, -122.486223855163) | 1 | 8 | 3 | 56 | 35 | |
89626 | 88352 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 700 VIENNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51333 | 6002601.8 | 2089436.1 | 37.7173411358396 | -122.432974311079 | (37.7173411358396, -122.432974311079) | 9 | 7 | 6 | 28861 | 5 | ||
101331 | 49926 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 639@ 20th ST Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53572 | 6007922.28440673 | 2104209.24888267 | 37.7582053099171 | -122.415629221325 | (37.7582053099171, -122.415629221325) | 2 | 4 | 7 | 28859 | 19 | ||
118405 | 62528 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4259 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53580 | 6000833.16850213 | 2102853.59020152 | 37.7540819566375 | -122.440049196257 | (37.7540819566375, -122.440049196257) | 2 | 4 | 5 | 28862 | 22 | ||
121189 | 88324 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 182 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51313 | 6003195 | 2092351 | 37.7253784345628 | -122.431131833246 | (37.7253784345628, -122.431131833246) | 9 | 7 | 6 | 28861 | 5 | |||
125779 | 112775 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 298X De Montfort Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774165 | 5994620.34335 | 2091897.94945 | 37.7236448360577 | -122.460740597397 | (37.7236448360577, -122.460740597397) | 9 | 8 | 4 | 28861 | 24 | ||
128073 | 88181 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 437 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51189 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
133805 | 254759 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1185 Vicente St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781601 | 5989303.86415 | 2097634.53427 | 37.7390887094016 | -122.479538051252 | (37.7390887094016, -122.479538051252) | 1 | 8 | 3 | 29491 | 35 | |
135010 | 99820 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 100X Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2012 12:00:00 AM | 8 | 3x3 | Permit Number 768974 | 6007364.7 | 2097747 | 37.7404300763526 | -122.417099703218 | (37.7404300763526, -122.417099703218) | 2 | 7 | 7 | 28859 | 2 |
141020 | 62882 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 107 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2015 12:00:00 AM | Permit Number 774278 | 6008878.23001524 | 2098033.75307574 | 37.7413024656019 | -122.41188674968 | (37.7413024656019, -122.41188674968) | 10 | 7 | 7 | 28859 | 2 | ||
148693 | 64873 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 710 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | Permit Number 772699 | 6002299.12581357 | 2108836.45328021 | 37.77059279087 | -122.435407516384 | (37.77059279087, -122.435407516384) | 15 | 5 | 11 | 29492 | 9 | ||
157786 | 95576 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 373 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767365 | 6003497 | 2099203 | 37.7442095786195 | -122.430576552899 | (37.7442095786195, -122.430576552899) | 2 | 7 | 5 | 63 | 22 | |
159282 | 96479 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | |||
172127 | 254562 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2743 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779392 | 5984613.41462 | 2096519.76609 | 37.7357542837064 | -122.495673043599 | (37.7357542837064, -122.495673043599) | 1 | 8 | 3 | 29491 | 35 | |
173197 | 63695 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1783 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/2014 12:00:00 AM | Permit Number 773244 | 5993095.47933652 | 2103351.7568476 | 37.7550062601161 | -122.466843987881 | (37.7550062601161, -122.466843987881) | 1 | 8 | 4 | 56 | 12 | ||
177534 | 131972 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1386 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782617 | 6006417.70095 | 2118709.68602 | 37.7979353075185 | -122.421862734678 | (37.7979353075185, -122.421862734678) | 13 | 9 | 10 | 28858 | 32 |
178822 | 88182 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 437 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51189 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
182313 | 65459 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 298X De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774165 | 5994499.27735341 | 2091923.17456246 | 37.7237071317421 | -122.46116092612 | (37.7237071317421, -122.46116092612) | 9 | 8 | 4 | 28861 | 24 | ||
189777 | 115404 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 355 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776433 | 6006990.5 | 2096060.3 | 37.7357777137995 | -122.418273984634 | (37.7357777137995, -122.418273984634) | 2 | 7 | 7 | 28859 | 2 | ||
35599 | 97045 | Property Tree 8 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
16285 | 114961 | Private 9 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 220 Evelyn Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.450116261368 | (37.7429206264442, -122.450116261368) | 9 | 7 | 4 | 59 | 40 |
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) );