trees
51 rows where Neighborhoods (old) = 12 and qSpecies_id = 65 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3963 | 203515 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993048.57106 | 2102513.42561 | 37.7527017117304 | -122.466945265911 | (37.7527017117304, -122.466945265911) | 1 | 8 | 4 | 29491 | 12 | |||
| 9645 | 203569 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994053.625 | 2104649.1203 | 37.7586237384107 | -122.463624625377 | (37.7586237384107, -122.463624625377) | 1 | 5 | 4 | 56 | 12 | |||
| 16596 | 203511 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1359 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992377.24702 | 2106218.29367 | 37.7628355396396 | -122.469536476251 | (37.7628355396396, -122.469536476251) | 1 | 8 | 11 | 56 | 12 | |||
| 21803 | 203503 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5991430.94358 | 2106235.13725 | 37.7628270518373 | -122.472810604751 | (37.7628270518373, -122.472810604751) | 1 | 8 | 11 | 56 | 12 | |||
| 35299 | 203521 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 54 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991886.81261 | 2104359.60659 | 37.757703719373 | -122.471097283818 | (37.757703719373, -122.471097283818) | 1 | 8 | 4 | 56 | 12 | |||
| 43499 | 203561 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 509 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5992707.23353 | 2104539.55392 | 37.7582452263566 | -122.468273046583 | (37.7582452263566, -122.468273046583) | 1 | 8 | 4 | 56 | 12 | |||
| 48944 | 203504 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1443 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991444.34023 | 2105597.09319 | 37.761075927938 | -122.472717747032 | (37.761075927938, -122.472717747032) | 1 | 8 | 4 | 56 | 12 | |||
| 54980 | 203512 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1742 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5993754.13818 | 2103625.89987 | 37.7557969785536 | -122.464586080687 | (37.7557969785536, -122.464586080687) | 1 | 8 | 4 | 56 | 12 | |||
| 59779 | 221868 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 30 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997080.14125 | 2106419.81481 | 37.7636595407827 | -122.45328544896 | (37.7636595407827, -122.45328544896) | 15 | 5 | 11 | 29492 | 12 | |||
| 73816 | 203517 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993021.77901 | 2102511.9902 | 37.7526962240514 | -122.467037812458 | (37.7526962240514, -122.467037812458) | 1 | 8 | 4 | 29491 | 12 | |||
| 76975 | 203510 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993979.28828 | 2106206.5915 | 37.7628958661671 | -122.46399477014 | (37.7628958661671, -122.46399477014) | 1 | 5 | 11 | 56 | 12 | |||
| 80302 | 203507 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 920 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5991972.62617 | 2105259.84917 | 37.7601805116332 | -122.470866084321 | (37.7601805116332, -122.470866084321) | 1 | 8 | 4 | 56 | 12 | |||
| 93698 | 203506 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 910 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5992059 | 2105289 | 37.7602655469825 | -122.470569484113 | (37.7602655469825, -122.470569484113) | 1 | 8 | 4 | 56 | 12 | |||
| 94909 | 203568 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1570 07th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994029.22996 | 2104753.97916 | 37.7589102480363 | -122.463716604458 | (37.7589102480363, -122.463716604458) | 1 | 5 | 4 | 56 | 12 | |||
| 100177 | 203509 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 942 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5991897.43235 | 2105257.276 | 37.7601690974381 | -122.471125954211 | (37.7601690974381, -122.471125954211) | 1 | 8 | 4 | 56 | 12 | |||
| 101049 | 203522 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 62 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991862.2088 | 2104389.33207 | 37.7577839146257 | -122.471184538744 | (37.7577839146257, -122.471184538744) | 1 | 8 | 4 | 56 | 12 | |||
| 101822 | 203519 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1531 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994271.83336 | 2105139.6012 | 37.7599830430151 | -122.462905551751 | (37.7599830430151, -122.462905551751) | 1 | 5 | 4 | 56 | 12 | |||
| 115923 | 203562 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1231 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5992350.00783 | 2107041.67016 | 37.7650947391427 | -122.469690631732 | (37.7650947391427, -122.469690631732) | 11 | 8 | 11 | 56 | 12 | |||
| 135676 | 203502 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1277 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990781.19981 | 2106711.00663 | 37.7640960267437 | -122.475092558003 | (37.7640960267437, -122.475092558003) | 11 | 8 | 3 | 56 | 12 | |||
| 137299 | 203520 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994273.74981 | 2105115.42997 | 37.7599167854573 | -122.462897170087 | (37.7599167854573, -122.462897170087) | 1 | 5 | 4 | 56 | 12 | |||
| 142588 | 203516 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993037.18841 | 2102512.99868 | 37.7526998825032 | -122.466984597774 | (37.7526998825032, -122.466984597774) | 1 | 8 | 4 | 29491 | 12 | |||
| 149376 | 203563 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1725 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993082.43615 | 2103702.81326 | 37.7559694172734 | -122.466914614344 | (37.7559694172734, -122.466914614344) | 1 | 8 | 4 | 56 | 12 | |||
| 151328 | 203513 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 112 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993653.12973 | 2102595.20165 | 37.7529611229783 | -122.464860549271 | (37.7529611229783, -122.464860549271) | 1 | 8 | 4 | 56 | 12 | |||
| 151960 | 203505 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1219 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991724.86879 | 2107100.15924 | 37.7652191828301 | -122.471857076945 | (37.7652191828301, -122.471857076945) | 11 | 8 | 11 | 56 | 12 | |||
| 158319 | 203508 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 936 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5991919.73486 | 2105259.11564 | 37.7601754385635 | -122.471048955151 | (37.7601754385635, -122.471048955151) | 1 | 8 | 4 | 56 | 12 | |||
| 159409 | 203518 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 415 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993563.6385 | 2105259.44911 | 37.7602712973034 | -122.465363541894 | (37.7602712973034, -122.465363541894) | 1 | 8 | 4 | 56 | 12 | |||
| 189079 | 253703 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1221 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998953 | 2105574 | 37.7614443133046 | -122.446746977382 | (37.7614443133046, -122.446746977382) | 15 | 5 | 11 | 29492 | 12 | ||||
| 190416 | 203514 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1206 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5993631.78497 | 2107236.32673 | 37.7657032159447 | -122.465271454925 | (37.7657032159447, -122.465271454925) | 11 | 8 | 11 | 56 | 12 | |||
| 181605 | 107942 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 415 KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2016 12:00:00 AM | 3 | 6x5 | Permit Number 775659 | 5993574.7 | 2105234.4 | 37.760203156894 | -122.465323466087 | (37.760203156894, -122.465323466087) | 1 | 8 | 4 | 56 | 12 | |
| 10364 | 64114 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1270 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24882 | 5992718.32165221 | 2106821.08244246 | 37.7645103445899 | -122.468400685881 | (37.7645103445899, -122.468400685881) | 11 | 8 | 11 | 56 | 12 | ||
| 21373 | 109405 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 112 ORTEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 775093 | 5993662.3 | 2102610.6 | 37.7530039316177 | -122.46482995514 | (37.7530039316177, -122.46482995514) | 1 | 8 | 4 | 56 | 12 | ||
| 31725 | 35065 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1725 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38620 | 5993082.12771331 | 2103730.13138284 | 37.7560444079518 | -122.46691766691 | (37.7560444079518, -122.46691766691) | 1 | 8 | 4 | 56 | 12 | ||
| 43220 | 32893 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1262 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774785 | 5993955.18913569 | 2106899.23772087 | 37.764796302786 | -122.464128405479 | (37.764796302786, -122.464128405479) | 11 | 5 | 11 | 56 | 12 | |
| 60347 | 62771 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1628 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23125 | 5993111.44496049 | 2104385.34678202 | 37.7578451513046 | -122.466863908769 | (37.7578451513046, -122.466863908769) | 1 | 8 | 4 | 56 | 12 | ||
| 68631 | 68056 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31793 | 5993375.65948901 | 2104224.93951181 | 37.7574199602528 | -122.465938496778 | (37.7574199602528, -122.465938496778) | 1 | 8 | 4 | 56 | 12 | ||
| 69330 | 62770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1622 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23124 | 5993110.09884511 | 2104424.43713032 | 37.7579524055375 | -122.466871405848 | (37.7579524055375, -122.466871405848) | 1 | 8 | 4 | 56 | 12 | ||
| 73034 | 94147 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53552 | 5992870.9 | 2102941.4 | 37.7538665624087 | -122.467590799812 | (37.7538665624087, -122.467590799812) | 1 | 8 | 4 | 56 | 12 | ||
| 76736 | 94821 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1435 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53901 | 5991436.1 | 2105639 | 37.7611905159112 | -122.472749301819 | (37.7611905159112, -122.472749301819) | 1 | 8 | 4 | 56 | 12 | |
| 85395 | 64103 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1274 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24869 | 5992719.22945305 | 2106794.6949286 | 37.7644379438855 | -122.468395626163 | (37.7644379438855, -122.468395626163) | 11 | 8 | 11 | 56 | 12 | ||
| 95663 | 108501 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1221 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773645 | 5991730.30424 | 2107117.25477 | 37.7652664370978 | -122.471839523232 | (37.7652664370978, -122.471839523232) | 11 | 8 | 11 | 56 | 12 |
| 101694 | 94830 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53908 | 5994260.8 | 2105105.8 | 37.7598895981479 | -122.462941258172 | (37.7598895981479, -122.462941258172) | 1 | 5 | 4 | 56 | 12 | |
| 115535 | 94829 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1531 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53907 | 5994259.9 | 2105131.8 | 37.75996093558 | -122.462946257172 | (37.75996093558, -122.462946257172) | 1 | 5 | 4 | 56 | 12 | |
| 122464 | 94832 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1212 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993646.6 | 2107243.8 | 37.7657245899289 | -122.465220756233 | (37.7657245899289, -122.465220756233) | 11 | 8 | 11 | 56 | 12 | ||||
| 124223 | 108505 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773650 | 5991435.09722 | 2106251.41391 | 37.7628719836646 | -122.472797425789 | (37.7628719836646, -122.472797425789) | 1 | 8 | 11 | 56 | 12 |
| 124672 | 94831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1541 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53909 | 5994261.6 | 2105082.3 | 37.759825119308 | -122.462936786411 | (37.759825119308, -122.462936786411) | 1 | 5 | 4 | 56 | 12 | |
| 133938 | 106164 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771080 | 5993998.9 | 2106208.9 | 37.7629033349313 | -122.463927108118 | (37.7629033349313, -122.463927108118) | 1 | 5 | 11 | 56 | 12 | |
| 135735 | 97220 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 120 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776182 | 5993132 | 2101212 | 37.749133146159 | -122.466562169914 | (37.749133146159, -122.466562169914) | 1 | 8 | 4 | 29491 | 12 | |||
| 147875 | 254474 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1526 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/15/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781401 | 5994010.7409 | 2105109.99448 | 37.7598867084746 | -122.463806388501 | (37.7598867084746, -122.463806388501) | 1 | 5 | 4 | 56 | 12 |
| 178762 | 108734 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 54 Aloha Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774639 | 5991915.16633 | 2104292.89593 | 37.7575221893456 | -122.470994366205 | (37.7575221893456, -122.470994366205) | 1 | 8 | 4 | 56 | 12 | |
| 187355 | 115291 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1811 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775894 | 5990908.2 | 2103066.5 | 37.7540965389008 | -122.474387332213 | (37.7540965389008, -122.474387332213) | 1 | 8 | 4 | 56 | 12 | |||
| 188754 | 94833 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1208 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53910 | 5993657.5 | 2107252.8 | 37.7657499301273 | -122.465183709555 | (37.7657499301273, -122.465183709555) | 11 | 8 | 11 | 56 | 12 |
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) );