trees
240 rows where PlotSize = "3x3" and qSpecies_id = 65 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
73676 | 102018 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 4252 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001333 | 2103370 | 37.7555283353782 | -122.438357655981 | (37.7555283353782, -122.438357655981) | 2 | 4 | 5 | 28862 | 3 | |||
72547 | 102082 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 577 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52510 | 5994678.1 | 2111611.2 | 37.7777757479831 | -122.461969778855 | (37.7777757479831, -122.461969778855) | 11 | 6 | 2 | 54 | 11 | |
93872 | 102475 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 38389 | 6007298 | 2103932 | 37.7574089362149 | -122.417768621509 | (37.7574089362149, -122.417768621509) | 2 | 4 | 7 | 28859 | 19 | |||
63335 | 102588 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 222 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002344.3 | 2109244.2 | 37.7717149279992 | -122.435280428905 | (37.7717149279992, -122.435280428905) | 15 | 5 | 11 | 29492 | 9 | |||
93586 | 102654 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 203X Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5995004 | 2088355 | 37.7139388056528 | -122.459157943572 | (37.7139388056528, -122.459157943572) | 9 | 8 | 6 | 28861 | 24 | |||
67823 | 103022 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 40X Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770067 | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 |
193981 | 104693 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2132 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770783 | 5988848.42745 | 2113351.68498 | 37.7822172841496 | -122.482263939923 | (37.7822172841496, -122.482263939923) | 11 | 6 | 2 | 55 | 26 | |
56274 | 104694 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2132 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770783 | 5988835.56911 | 2113350.38756 | 37.7822129738615 | -122.482308328405 | (37.7822129738615, -122.482308328405) | 11 | 6 | 2 | 55 | 26 | |
149788 | 105062 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 530 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 771082 | 5993803.2 | 2111872 | 37.7784414265163 | -122.465015282122 | (37.7784414265163, -122.465015282122) | 11 | 6 | 2 | 54 | 11 | ||||
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 | |
157166 | 106344 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
185739 | 106345 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 2 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
3681 | 106711 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3990 FOLSOM ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008366.1 | 2096547.2 | 37.7371919715517 | -122.413552407719 | (37.7371919715517, -122.413552407719) | 2 | 7 | 7 | 28859 | 2 | |||||
160053 | 107230 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005960.15833 | 2119639.59713 | 37.8004627936866 | -122.423512110213 | (37.8004627936866, -122.423512110213) | 13 | 9 | 1 | 28858 | 32 | |||
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 |
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 |
60136 | 108565 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 521 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772537 | 6010495.60195 | 2092202.94019 | 37.7253828953025 | -122.405883778414 | (37.7253828953025, -122.405883778414) | 10 | 3 | 7 | 309 | 28 |
83894 | 108683 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.20846 | 2086863.37515 | 37.7101463059777 | -122.440738464824 | (37.7101463059777, -122.440738464824) | 9 | 7 | 6 | 28861 | 5 |
39831 | 108691 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1638 41st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774623 | 5983468.36272 | 2103987.5899 | 37.7561917512468 | -122.500183776602 | (37.7561917512468, -122.500183776602) | 1 | 8 | 3 | 56 | 35 | |
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 | |
137107 | 108890 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 350 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773349 | 5999093.24367 | 2094395.39174 | 37.7307585689262 | -122.445458107682 | (37.7307585689262, -122.445458107682) | 9 | 7 | 4 | 59 | 40 | |
60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
76448 | 108926 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772355 | 6007347.4 | 2099299.8 | 37.7446927459132 | -122.417269529335 | (37.7446927459132, -122.417269529335) | 2 | 7 | 7 | 28859 | 2 |
125569 | 109039 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2439 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773557 | 5985453.6 | 2098605.4 | 37.7415300428197 | -122.492921815189 | (37.7415300428197, -122.492921815189) | 1 | 8 | 3 | 29491 | 35 |
135999 | 109068 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1216 COLE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774077 | 5998287 | 2106143.6 | 37.762970223958 | -122.449091419823 | (37.762970223958, -122.449091419823) | 15 | 5 | 11 | 29492 | 9 | |
92074 | 109191 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1340 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773400 | 5981564.2 | 2105932 | 37.7614186014043 | -122.506913128145 | (37.7614186014043, -122.506913128145) | 1 | 8 | 3 | 56 | 35 |
186632 | 109259 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1658 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773073 | 5981637.7 | 2103794 | 37.7555525913946 | -122.506500365189 | (37.7555525913946, -122.506500365189) | 1 | 8 | 3 | 56 | 35 |
93053 | 109277 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1787 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772804 | 5981271.8 | 2102925.3 | 37.7531458375643 | -122.507701279468 | (37.7531458375643, -122.507701279468) | 1 | 8 | 3 | 56 | 35 |
87243 | 109278 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773630 | 5981021.8 | 2103979.8 | 37.7560264628403 | -122.508644093874 | (37.7560264628403, -122.508644093874) | 1 | 8 | 3 | 56 | 35 |
174480 | 109282 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
162088 | 109283 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
52586 | 109284 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
126015 | 109285 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
48427 | 109287 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773636 | 5982487.2 | 2097095.3 | 37.7372098007713 | -122.503066669454 | (37.7372098007713, -122.503066669454) | 1 | 8 | 3 | 29491 | 35 |
31052 | 109288 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 274 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773379 | 6002625.7 | 2104315.8 | 37.7581987182413 | -122.433954706682 | (37.7581987182413, -122.433954706682) | 2 | 4 | 5 | 28862 | 3 |
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 | ||
136488 | 109499 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207237 | (37.7359945088656, -122.43418207237) | 2 | 7 | 5 | 63 | 7 |
108472 | 109743 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775046 | 6002641.7 | 2105066.1 | 37.7602597694278 | -122.433953002704 | (37.7602597694278, -122.433953002704) | 2 | 4 | 5 | 28862 | 3 |
117746 | 109922 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Dashiell Hammett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010385.90065 | 2115990.02467 | 37.7906907621072 | -122.407939683476 | (37.7906907621072, -122.407939683476) | 5 | 1 | 10 | 28857 | 21 | |||
1599 | 110941 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2484 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 3x3 | 5984310 | 2098290 | 37.7405970958294 | -122.496852660576 | (37.7405970958294, -122.496852660576) | 1 | 8 | 3 | 29491 | 35 | ||
135740 | 112364 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 501X 09TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5993143 | 2111731 | 37.7780161887977 | -122.467288887933 | (37.7780161887977, -122.467288887933) | 11 | 6 | 2 | 54 | 11 | |||
172907 | 112365 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 501x 09TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993143 | 2111731 | 37.7780161887977 | -122.467288887933 | (37.7780161887977, -122.467288887933) | 11 | 6 | 2 | 54 | 11 | ||||
100013 | 112856 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 1700x BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6000040 | 2114920 | 37.7871680933118 | -122.443658934554 | (37.7871680933118, -122.443658934554) | 15 | 6 | 1 | 29490 | 31 | |||
88447 | 113211 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
186207 | 114881 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004593 | 2095924 | 37.7352682180932 | -122.426553380791 | (37.7352682180932, -122.426553380791) | 2 | 7 | 5 | 28861 | 2 | |||
69208 | 119901 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
52019 | 119902 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
106236 | 120108 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3528 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778087 | 6004858 | 2103141 | 37.7550994230029 | -122.426150804554 | (37.7550994230029, -122.426150804554) | 2 | 4 | 5 | 28862 | 22 | |
163225 | 120637 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 401 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 3x3 | 6000628.4194 | 2110406.526 | 37.77480879071 | -122.441299165195 | (37.77480879071, -122.441299165195) | 15 | 5 | 11 | 29492 | 16 | |||
162286 | 121320 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 550 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5993807 | 2111747 | 37.7780984292352 | -122.464993055827 | (37.7780984292352, -122.464993055827) | 11 | 6 | 2 | 54 | 11 | ||||
138216 | 121328 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2455 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5986403.9195 | 2098529.3345 | 37.7413767161187 | -122.489630387324 | (37.7413767161187, -122.489630387324) | 1 | 8 | 3 | 29491 | 35 | |||
143712 | 1265 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5992172.84146 | 2087217.03484 | 37.7106510585713 | -122.468860642897 | (37.7106510585713, -122.468860642897) | 9 | 8 | 4 | 64 | 24 | ||
151383 | 1266 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5992143.83128 | 2087204.78999 | 37.7106157610663 | -122.46896001711 | (37.7106157610663, -122.46896001711) | 9 | 8 | 4 | 64 | 24 | |||
4034 | 158226 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6004403.18115 | 2097173.01672 | 37.7386870025035 | -122.427298598675 | (37.7386870025035, -122.427298598675) | 2 | 7 | 5 | 63 | 7 | |||
180750 | 158239 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780004 | 6003126.50979 | 2096349.74034 | 37.7363541898933 | -122.43165395869 | (37.7363541898933, -122.43165395869) | 2 | 7 | 5 | 63 | 7 |
63785 | 158240 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003134.83556 | 2096356.78559 | 37.7363740064603 | -122.43162567588 | (37.7363740064603, -122.43162567588) | 2 | 7 | 5 | 63 | 7 |
117767 | 158241 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003145.71012 | 2096365.89505 | 37.7363996353363 | -122.431588728148 | (37.7363996353363, -122.431588728148) | 2 | 7 | 5 | 63 | 7 |
38682 | 158242 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003158.9626 | 2096376.80466 | 37.7364303417798 | -122.431543687401 | (37.7364303417798, -122.431543687401) | 2 | 7 | 5 | 63 | 7 |
56352 | 238396 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2221 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782349 | 6002719.76824 | 2107072.27368 | 37.7657726661007 | -122.433826396093 | (37.7657726661007, -122.433826396093) | 15 | 5 | 5 | 28862 | 3 | |
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 | ||||
192665 | 254027 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1486 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781497 | 5981881.09813 | 2104983.58381 | 37.7588331784594 | -122.505746816877 | (37.7588331784594, -122.505746816877) | 1 | 8 | 3 | 56 | 35 |
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 |
108513 | 254649 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 929 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781532 | 6000895.17385 | 2091578.90462 | 37.7231278434042 | -122.439026791536 | (37.7231278434042, -122.439026791536) | 9 | 7 | 6 | 28861 | 25 |
110025 | 255477 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2669 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780207 | 6000139.26098 | 2118831.12681 | 37.7979126806609 | -122.443596582177 | (37.7979126806609, -122.443596582177) | 13 | 9 | 1 | 57 | 17 | |
134976 | 255531 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2130 15th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782019 | 6003380.68215 | 2107148.89983 | 37.7660205449408 | -122.431545908158 | (37.7660205449408, -122.431545908158) | 15 | 5 | 5 | 28862 | 3 | |
57192 | 258208 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1751 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783177 | 5982833.22444 | 2103206.19232 | 37.7540089544563 | -122.50232243849 | (37.7540089544563, -122.50232243849) | 1 | 8 | 3 | 56 | 35 | |
19544 | 261022 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 393 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5986499 | 2113341 | 37.7820510072297 | -122.490391009154 | (37.7820510072297, -122.490391009154) | 11 | 6 | 2 | 55 | 26 | |||
4589 | 261026 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 758 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5989802 | 2110189 | 37.7735888483109 | -122.478733667362 | (37.7735888483109, -122.478733667362) | 11 | 6 | 2 | 55 | 26 | |||
11799 | 261147 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | |||
16950 | 261148 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | ||||
1070 | 261149 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 322x Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991839 | 2099782 | 37.7451320352893 | -122.470929181064 | (37.7451320352893, -122.470929181064) | 1 | 8 | 4 | 29491 | 40 | ||||
9568 | 261150 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | ||||
17368 | 261151 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2107 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982896 | 2100761 | 37.7472988260012 | -122.501924436785 | (37.7472988260012, -122.501924436785) | 1 | 8 | 3 | 29491 | 35 | |||
12483 | 261152 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2279 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982935 | 2099631 | 37.7441984490884 | -122.501705991239 | (37.7441984490884, -122.501705991239) | 1 | 8 | 3 | 29491 | 35 | |||
15772 | 261153 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2291 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982938 | 2099557 | 37.7439954416833 | -122.501690144388 | (37.7439954416833, -122.501690144388) | 1 | 8 | 3 | 29491 | 35 | |||
12905 | 261154 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2246 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982704 | 2099822 | 37.7447093112365 | -122.502518859637 | (37.7447093112365, -122.502518859637) | 1 | 8 | 3 | 29491 | 35 | |||
5467 | 261155 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2119 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 3x3 | 5983519 | 2100707 | 37.7471871347586 | -122.499766192027 | (37.7471871347586, -122.499766192027) | 1 | 8 | 3 | 29491 | 35 | |||
18580 | 262400 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
7501 | 262401 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
3053 | 262433 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 470 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3x3 | 6001714 | 2091050 | 37.7217221467453 | -122.43615844491 | (37.7217221467453, -122.43615844491) | 9 | 7 | 6 | 28861 | 5 | |||
8836 | 262545 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 1919 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 3x3 | 6011672 | 2093386 | 37.7286970547273 | -122.401900181645 | (37.7286970547273, -122.401900181645) | 10 | 3 | 8 | 58 | 1 | ||
61694 | 26511 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008945.12722 | 2101866.39993 | 37.7518298180943 | -122.411926215341 | (37.7518298180943, -122.411926215341) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |
754 | 34739 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3x3 | Permit Number 38389 | 6007302.61875581 | 2103939.58827334 | 37.7574300317864 | -122.417753185833 | (37.7574300317864, -122.417753185833) | 2 | 4 | 7 | 28859 | 19 | |
30504 | 37659 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 486 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51139 | 5991909.24916 | 2112157.7974 | 37.7791167592266 | -122.471587940686 | (37.7791167592266, -122.471587940686) | 11 | 6 | 2 | 54 | 11 | |
95563 | 38954 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 293 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2008 12:00:00 AM | 3x3 | Permit Number 50374 | 6000154.66929043 | 2094929.77821336 | 37.73228640687 | -122.441826941763 | (37.73228640687, -122.441826941763) | 9 | 7 | 4 | 63 | 40 | ||
94208 | 52929 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.7274719160952 | -122.433397195531 | (37.7274719160952, -122.433397195531) | 9 | 7 | 6 | 28861 | 25 |
12461 | 70586 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1829 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 3x3 | 5989790.05617 | 2113327.40851 | 37.7822053543666 | -122.479004586193 | (37.7822053543666, -122.479004586193) | 11 | 6 | 2 | 55 | 26 | ||
9976 | 73440 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1829 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 5989774.97686 | 2113326.97705 | 37.7822032940119 | -122.479056721694 | (37.7822032940119, -122.479056721694) | 11 | 6 | 2 | 55 | 26 | ||
111705 | 74111 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 500X Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1994 12:00:00 AM | 15 | 3x3 | 6003976.59234436 | 2092494.78352221 | 37.7258174919201 | -122.428440184616 | (37.7258174919201, -122.428440184616) | 9 | 7 | 6 | 28861 | 5 | ||
130795 | 81299 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 109 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50541 | 6006708.25661782 | 2103139.88479614 | 37.7552007652727 | -122.419751988993 | (37.7552007652727, -122.419751988993) | 2 | 4 | 7 | 28859 | 19 | |
90858 | 81824 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 465 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49841 | 5998560.4175518 | 2097716.54493852 | 37.7398472336872 | -122.447539136623 | (37.7398472336872, -122.447539136623) | 9 | 7 | 4 | 59 | 40 | ||
158268 | 81935 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 23 Gaviota Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49833 | 5998498.7012246 | 2097562.09988585 | 37.7394196374476 | -122.447741409302 | (37.7394196374476, -122.447741409302) | 9 | 7 | 4 | 59 | 40 | ||
106840 | 82673 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Jennings Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52499 | 6012920.29338 | 2089198.31583 | 37.7172681083272 | -122.397291182543 | (37.7172681083272, -122.397291182543) | 10 | 3 | 8 | 58 | 1 | |
88150 | 82830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1475 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52467 | 6015906.1825 | 2094100.414 | 37.7308940918936 | -122.387312034756 | (37.7308940918936, -122.387312034756) | 10 | 3 | 8 | 58 | 1 | |
186443 | 83009 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 622 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52378 | 6012068.99141 | 2105489.95153 | 37.7619540583423 | -122.401378022995 | (37.7619540583423, -122.401378022995) | 10 | 3 | 8 | 28856 | 29 | |
187229 | 83487 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2051 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50156 | 5982589.2289 | 2101159.5488 | 37.7483751044578 | -122.503014711943 | (37.7483751044578, -122.503014711943) | 1 | 8 | 3 | 29491 | 35 | |
110639 | 83535 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1779 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50180 | 5981283.63190284 | 2102973.80068941 | 37.7532797037627 | -122.507663961783 | (37.7532797037627, -122.507663961783) | 1 | 8 | 3 | 56 | 35 | |||
178764 | 83799 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1200 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 3x3 | Permit Number 53146 | 5982135.42302083 | 2106787.40938389 | 37.7638009337056 | -122.505000931873 | (37.7638009337056, -122.505000931873) | 1 | 8 | 3 | 56 | 35 | ||
114804 | 83800 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1206 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50158 | 5982131.5385 | 2106862.8908 | 37.764007955481 | -122.505019961028 | (37.764007955481, -122.505019961028) | 1 | 8 | 3 | 56 | 35 |
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) );