trees
603 rows where qSpecies_id = 172
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27487 | 90241 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986391.93511 | 2111177.84451 | 37.7761053454235 | -122.490602199432 | (37.7761053454235, -122.490602199432) | 11 | 6 | 2 | 55 | 26 | ||
| 27628 | 43446 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999670.6407 | 2091179.60867 | 37.721961717728 | -122.443231082473 | (37.721961717728, -122.443231082473) | 9 | 7 | 6 | 28861 | 25 | |
| 28236 | 44161 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
| 28932 | 105444 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 20-28 ROSEMONT PL | 1 | Back Yard : Yard | Tree | Private 2 | 6005075.5 | 2108088.5 | 37.7686963767089 | -122.425750755404 | (37.7686963767089, -122.425750755404) | 8 | 4 | 5 | 28853 | 19 | |||||
| 29268 | 181535 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984891.4503 | 2105792.8068 | 37.7612317968807 | -122.495395459242 | (37.7612317968807, -122.495395459242) | 1 | 8 | 3 | 56 | 35 | |||
| 29708 | 247953 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7 Joy St | 6 | Side Yard : Yard | Tree | Private 2 | 10 | 6010438.9217 | 2098856.89307 | 37.7436500649912 | -122.406548391799 | (37.7436500649912, -122.406548391799) | 2 | 7 | 7 | 28859 | 2 | ||||
| 29969 | 44147 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
| 30190 | 43448 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999710.3638 | 2091158.16281 | 37.721905097333 | -122.443092230725 | (37.721905097333, -122.443092230725) | 9 | 7 | 6 | 28861 | 25 | |
| 30203 | 95755 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003450.90146 | 2092257.04406 | 37.7251349504027 | -122.430240505894 | (37.7251349504027, -122.430240505894) | 9 | 7 | 6 | 28861 | 5 |
| 30244 | 247948 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7 Joy St | 1 | Side Yard : Yard | Tree | Private 2 | 13 | 6010393.64964 | 2098873.99577 | 37.7436944924075 | -122.406706137374 | (37.7436944924075, -122.406706137374) | 2 | 7 | 7 | 28859 | 2 | ||||
| 30357 | 116670 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100 Esmeralda Ave | 8 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 30406 | 240234 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006339.6227 | 2095791.19011 | 37.7350021383438 | -122.420505229653 | (37.7350021383438, -122.420505229653) | 2 | 7 | 7 | 28859 | 2 | |||
| 30418 | 43375 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 415 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43123 | 6001833.61881402 | 2103424.63951289 | 37.7557068243023 | -122.436630274867 | (37.7557068243023, -122.436630274867) | 2 | 4 | 5 | 28862 | 22 | ||
| 31022 | 79408 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 322 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776851 | 6004758.73696772 | 2101857.84943819 | 37.7515705801104 | -122.426402728229 | (37.7515705801104, -122.426402728229) | 2 | 4 | 5 | 28862 | 22 | |
| 31036 | 82818 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
| 31480 | 197172 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900x Carolina St | 24 | Median : Yard | Tree | DPW 1 | 3 | 6012477.22941 | 2103487.19338 | 37.7564776943092 | -122.39982544149 | (37.7564776943092, -122.39982544149) | 10 | 3 | 8 | 28856 | 29 | ||||
| 31893 | 240235 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 10ft | 6006361.75511 | 2095789.26395 | 37.7349980967903 | -122.420428573244 | (37.7349980967903, -122.420428573244) | 2 | 7 | 7 | 28859 | 2 | |||
| 32109 | 256217 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 159X Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 7 | 7 | 28859 | 2 | ||||
| 32249 | 240288 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3980 22nd St | 2 | : | Tree | Private 2 | 20 | 6001954.91678 | 2102957.6016 | 37.7544313427449 | -122.43617736779 | (37.7544313427449, -122.43617736779) | 2 | 4 | 5 | 28862 | 22 | ||||
| 32883 | 197205 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6019275.32859 | 2093678.30312 | 37.7299210694925 | -122.375634959101 | (37.7299210694925, -122.375634959101) | 10 | 3 | 8 | 58 | 1 | ||||
| 33320 | 186228 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1701 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984813.4188 | 2103368.4703 | 37.7545706737005 | -122.495486523075 | (37.7545706737005, -122.495486523075) | 1 | 8 | 3 | 56 | 35 | |||
| 33362 | 247610 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6009501.25197 | 2096696.3834 | 37.7376652719307 | -122.409638179058 | (37.7376652719307, -122.409638179058) | 10 | 7 | 7 | 28859 | 2 | ||||
| 33386 | 18939 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2760 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6001611.94448 | 2115686.46462 | 37.7893621369983 | -122.438275289198 | (37.7893621369983, -122.438275289198) | 13 | 6 | 1 | 29490 | 27 | |||
| 33436 | 179343 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 26 Ervine St | 11 | Front Yard : Yard | Tree | Private 2 | 7 | 6009596.1537 | 2089161.02063 | 37.7169800734552 | -122.408778591782 | (37.7169800734552, -122.408778591782) | 9 | 7 | 8 | 309 | 18 | ||||
| 33649 | 90242 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986371.9113 | 2111177.50971 | 37.7761032565147 | -122.490671441556 | (37.7761032565147, -122.490671441556) | 11 | 6 | 2 | 55 | 26 | ||
| 33720 | 184764 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984675.2613 | 2106104.8671 | 37.7620759662771 | -122.496166178125 | (37.7620759662771, -122.496166178125) | 1 | 8 | 3 | 56 | 35 | |||
| 34414 | 240245 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006078.33577 | 2096854.32708 | 37.737906547446 | -122.42148407153 | (37.737906547446, -122.42148407153) | 2 | 7 | 7 | 28859 | 2 | |||
| 34820 | 240239 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 6006416.61409 | 2095785.43959 | 37.7349906872665 | -122.420238634604 | (37.7349906872665, -122.420238634604) | 2 | 7 | 7 | 28859 | 2 | |||
| 34942 | 247146 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4100 Cesar Chavez St | 5 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 6003161.19661 | 2100383.74309 | 37.7474325946487 | -122.431821977222 | (37.7474325946487, -122.431821977222) | 2 | 4 | 5 | 63 | 22 | ||||
| 35171 | 197186 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Illinois St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6016257.1896 | 2100643.95159 | 37.7488807495539 | -122.386554632611 | (37.7488807495539, -122.386554632611) | 10 | 3 | 8 | 58 | 1 | |||
| 35222 | 248061 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 18 Rutledge St | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 6010675.96291 | 2099385.23379 | 37.7451140326787 | -122.40576596453 | (37.7451140326787, -122.40576596453) | 2 | 7 | 7 | 28859 | 2 | ||||
| 35806 | 247833 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 88 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6009033.18663 | 2098163.22314 | 37.7416666542973 | -122.411360106478 | (37.7416666542973, -122.411360106478) | 10 | 7 | 7 | 28859 | 2 | ||||
| 36046 | 122242 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1628 Lake St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5990370.4799 | 2114772.22238 | 37.7862060986385 | -122.477102214032 | (37.7862060986385, -122.477102214032) | 11 | 6 | 1 | 55 | 33 | |||
| 36136 | 197192 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 14 | Front Yard : Yard | Tree | Private 2 | 18 | 6015810.17797 | 2099864.72659 | 37.7467164033528 | -122.388046043088 | (37.7467164033528, -122.388046043088) | 3 | 8 | 58 | 1 | |||||
| 36285 | 95758 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003422.17585 | 2092210.81209 | 37.7250063806226 | -122.430336510319 | (37.7250063806226, -122.430336510319) | 9 | 7 | 6 | 28861 | 5 |
| 36291 | 185651 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2100 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985060.0587 | 2100520.4285 | 37.7467651702303 | -122.494423659241 | (37.7467651702303, -122.494423659241) | 1 | 8 | 3 | 29491 | 35 | |||
| 36639 | 197190 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 9 | Front Yard : Yard | Tree | Private 2 | 13 | 6015846.29737 | 2099899.92461 | 37.7468150508735 | -122.387923600389 | (37.7468150508735, -122.387923600389) | 3 | 8 | 58 | 1 | |||||
| 36650 | 197202 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012375.40062 | 2096377.97464 | 37.7369516266217 | -122.399678458117 | (37.7369516266217, -122.399678458117) | 10 | 3 | 8 | 58 | 1 | ||||
| 36674 | 240226 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006225.25616 | 2095800.40659 | 37.735020998922 | -122.420901290175 | (37.735020998922, -122.420901290175) | 2 | 7 | 7 | 28859 | 2 | |||
| 37888 | 116374 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 170 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5987438.38703 | 2114824.73848 | 37.7861797499018 | -122.487250214084 | (37.7861797499018, -122.487250214084) | 11 | 6 | 1 | 55 | 33 | |||
| 38694 | 186265 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985011.4731 | 2102352.6681 | 37.7517931556361 | -122.494726722368 | (37.7517931556361, -122.494726722368) | 1 | 8 | 3 | 56 | 35 | |||
| 38698 | 187033 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2501 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984945.4124 | 2097823.2905 | 37.7393528488738 | -122.494621283251 | (37.7393528488738, -122.494621283251) | 1 | 8 | 3 | 29491 | 35 | |||
| 38894 | 95753 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003478.85461 | 2092303.36569 | 37.7252637225375 | -122.430147177848 | (37.7252637225375, -122.430147177848) | 9 | 7 | 6 | 28861 | 5 |
| 39180 | 240303 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4185 25th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002751.21968 | 2101207.63188 | 37.7496715504081 | -122.433298511121 | (37.7496715504081, -122.433298511121) | 2 | 4 | 5 | 28862 | 22 | |||
| 39611 | 46658 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 239 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | 12 | Permit Number 44789 | 5988674.72219 | 2113730.06993 | 37.7832461170437 | -122.482892615104 | (37.7832461170437, -122.482892615104) | 11 | 6 | 2 | 55 | 26 | |
| 40489 | 6510 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200X Evans Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 15 | 6017613.51756 | 2097076.90112 | 37.7391613427334 | -122.381616361724 | (37.7391613427334, -122.381616361724) | 10 | 3 | 8 | 58 | 1 | |||
| 40686 | 240281 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 691 29th St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002115.69765 | 2098827.32488 | 37.7430997140946 | -122.435325922949 | (37.7430997140946, -122.435325922949) | 2 | 7 | 5 | 63 | 7 | ||||
| 41047 | 184063 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984913.1434 | 2103955.4845 | 37.7561882912046 | -122.495184939624 | (37.7561882912046, -122.495184939624) | 1 | 8 | 3 | 56 | 35 | |||
| 41146 | 43456 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999514.70275 | 2091259.45123 | 37.7221720538917 | -122.443775852197 | (37.7221720538917, -122.443775852197) | 9 | 7 | 6 | 28861 | 25 | |
| 41187 | 186031 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985004.6307 | 2102018.5095 | 37.7508752473191 | -122.494725750209 | (37.7508752473191, -122.494725750209) | 1 | 8 | 3 | 29491 | 35 | |||
| 41673 | 90239 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986460.59173 | 2111180.188 | 37.7761157900861 | -122.490364873506 | (37.7761157900861, -122.490364873506) | 11 | 6 | 2 | 55 | 26 | ||
| 42061 | 37896 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1500 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52539 | 5995914.46450113 | 2094101.71045424 | 37.7297702097563 | -122.45642635192 | (37.7297702097563, -122.45642635192) | 9 | 7 | 4 | 28861 | 40 | ||
| 43750 | 253165 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1451 Bay St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||||
| 43771 | 247195 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900 Waller St | 9 | Front Yard : Yard | Tree | Private 2 | 20 | 6001251.02187 | 2108666.7471 | 37.7700672400275 | -122.439020747112 | (37.7700672400275, -122.439020747112) | 15 | 5 | 11 | 29492 | 9 | ||||
| 43774 | 123184 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 695 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993153.85102 | 2110782.22133 | 37.7754117246383 | -122.467182349196 | (37.7754117246383, -122.467182349196) | 11 | 6 | 2 | 54 | 11 | |||
| 43964 | 240231 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006293.37748 | 2095794.59249 | 37.7350088742503 | -122.420665357522 | (37.7350088742503, -122.420665357522) | 2 | 7 | 7 | 28859 | 2 | |||
| 43977 | 247900 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 353 Mayflower St | 2 | Side Yard : Yard | Tree | Private 2 | 20 | 6009993.56525 | 2098391.56097 | 37.7423474383843 | -122.408055523371 | (37.7423474383843, -122.408055523371) | 10 | 7 | 7 | 28859 | 2 | ||||
| 43981 | 52425 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 300 Seneca Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | Permit Number 48542 | 5999289.94205438 | 2090904.87008142 | 37.7211856330713 | -122.444527321415 | (37.7211856330713, -122.444527321415) | 9 | 7 | 6 | 28861 | 25 | |||
| 44586 | 122351 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
| 45286 | 213997 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500 16th Ave | 1 | Side Yard : Yard | Tree | Private 2 | 23 | 5991180.77064 | 2105068.88436 | 37.7596103459632 | -122.473590780095 | (37.7596103459632, -122.473590780095) | 1 | 8 | 4 | 56 | 12 | ||||
| 45313 | 59158 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1514 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1980 12:00:00 AM | 22 | 3x3 | Permit Number 18467 | 6003928.31861537 | 2099451.36110973 | 37.7449159459785 | -122.429102851606 | (37.7449159459785, -122.429102851606) | 2 | 7 | 5 | 63 | 22 | |
| 45451 | 88773 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 461 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2008 12:00:00 AM | 3x3 | Permit Number 51690 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | ||
| 45804 | 90968 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4149X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982697.48853 | 2110986.30028 | 37.7753629296515 | -122.503367879459 | (37.7753629296515, -122.503367879459) | 11 | 6 | 2 | 55 | 26 | ||
| 46105 | 240307 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 362 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001774.63442 | 2103722.50053 | 37.7565213267127 | -122.43685558343 | (37.7565213267127, -122.43685558343) | 2 | 4 | 5 | 28862 | 3 | |||
| 46360 | 44142 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
| 46599 | 43461 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1000 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43163 | 6000647.65925572 | 2091203.91791776 | 37.722084128815 | -122.439855525614 | (37.722084128815, -122.439855525614) | 9 | 7 | 6 | 28861 | 25 | |||
| 46694 | 240227 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006241.01631 | 2095800.08306 | 37.7350209989201 | -122.420846778675 | (37.7350209989201, -122.420846778675) | 2 | 7 | 7 | 28859 | 2 | |||
| 46764 | 247825 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 96 Banks St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6008677.79642 | 2098169.294 | 37.7416633843669 | -122.412589360112 | (37.7416633843669, -122.412589360112) | 10 | 7 | 7 | 28859 | 2 | ||||
| 47095 | 185687 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2101 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984902.932 | 2100564.5408 | 37.7468770936492 | -122.494970232 | (37.7468770936492, -122.494970232) | 1 | 8 | 3 | 29491 | 35 | |||
| 47120 | 200030 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015295.7414 | 2094553.9973 | 37.7321057143095 | -122.389454111911 | (37.7321057143095, -122.389454111911) | 10 | 3 | 8 | 58 | 1 | |||
| 47338 | 99497 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1400X Plymouth Ave | 4 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
| 48760 | 255654 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
| 49365 | 43453 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999638.45654 | 2091195.87208 | 37.7220045380552 | -122.443343502225 | (37.7220045380552, -122.443343502225) | 9 | 7 | 6 | 28861 | 25 | |
| 49665 | 247614 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 5 | Front Yard : Yard | Tree | Private 2 | 1 | 6009490.01081 | 2096755.59346 | 37.7378272200383 | -122.40968122332 | (37.7378272200383, -122.40968122332) | 10 | 7 | 7 | 28859 | 2 | ||||
| 50019 | 214004 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 143 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999098.84312 | 2093757.73609 | 37.7290080354696 | -122.445392917756 | (37.7290080354696, -122.445392917756) | 9 | 7 | 4 | 28861 | 40 | |||
| 50121 | 240237 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006385.38025 | 2095788.04313 | 37.7349960760111 | -122.420346805985 | (37.7349960760111, -122.420346805985) | 2 | 7 | 7 | 28859 | 2 | |||
| 50577 | 240228 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 6006254.27366 | 2095797.84836 | 37.735015610176 | -122.420800784622 | (37.735015610176, -122.420800784622) | 2 | 7 | 7 | 28859 | 2 | |||
| 50608 | 90293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
| 50901 | 185402 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2300 Sunset Blvd | 16 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985125.6291 | 2099042.93 | 37.7427121969825 | -122.494088049359 | (37.7427121969825, -122.494088049359) | 1 | 8 | 3 | 29491 | 35 | |||
| 51002 | 240326 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 343 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004069.13295 | 2109034.20183 | 37.7712361239812 | -122.429299145951 | (37.7712361239812, -122.429299145951) | 7 | 9 | 11 | 29492 | 10 | |||
| 51322 | 240316 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 310 Liberty St | 48 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003835.66179 | 2103919.16999 | 37.7571782571912 | -122.429741845306 | (37.7571782571912, -122.429741845306) | 2 | 4 | 5 | 28862 | 3 | |||
| 51341 | 97051 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 795 Wisconsin St | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.398775590174 | (37.7574425906128, -122.398775590174) | 10 | 3 | 8 | 28856 | 29 | |||
| 51511 | 83003 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015217.1468 | 2094533.6617 | 37.7320455189111 | -122.389724413212 | (37.7320455189111, -122.389724413212) | 10 | 3 | 8 | 58 | 1 | |
| 51635 | 43454 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 11 | Permit Number 43162 | 5999613.63458 | 2091208.86715 | 37.7220388040182 | -122.443430238238 | (37.7220388040182, -122.443430238238) | 9 | 7 | 6 | 28861 | 25 | |
| 52164 | 122364 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
| 52169 | 111442 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 8 | 5999909.42688 | 2091057.17434 | 37.7216391542992 | -122.44239687581 | (37.7216391542992, -122.44239687581) | 9 | 7 | 6 | 28861 | 25 | |||
| 52308 | 197207 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6019325.73842 | 2093646.8502 | 37.7298374801948 | -122.375458504919 | (37.7298374801948, -122.375458504919) | 10 | 3 | 8 | 58 | 1 | ||||
| 53189 | 46622 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015162.1856 | 2094456.1663 | 37.7318296842946 | -122.389909016355 | (37.7318296842946, -122.389909016355) | 10 | 3 | 8 | 58 | 1 | |
| 53513 | 42689 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |||
| 53600 | 247634 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 351 Bradford St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6009494.55377 | 2096596.6066 | 37.7373909310424 | -122.409654297605 | (37.7373909310424, -122.409654297605) | 10 | 7 | 7 | 28859 | 2 | ||||
| 54045 | 247106 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 24 | Front Yard : Yard | Tree | Private 2 | 10 | 6002702.97811 | 2098815.334 | 37.7431001241765 | -122.433294410209 | (37.7431001241765, -122.433294410209) | 2 | 7 | 5 | 63 | 22 | ||||
| 54174 | 240323 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 355 Masonic Ave | 10 | Front Yard : Yard | Tree | Private 2 | 11 | Width 3ft | 6000286.14451 | 2106902.79812 | 37.7651689296139 | -122.442231589424 | (37.7651689296139, -122.442231589424) | 15 | 5 | 5 | 28862 | 3 | |||
| 54420 | 197204 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 961 Le Conte Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6013357.29959 | 2089363.32814 | 37.7177455197262 | -122.395792202474 | (37.7177455197262, -122.395792202474) | 10 | 3 | 8 | 58 | 1 | ||||
| 55180 | 240213 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1000 San Jose Ave | 101 | Front Yard : Yard | Tree | Private 2 | 3 | 6005074.47126 | 2096982.94014 | 37.738203036831 | -122.424964073757 | (37.738203036831, -122.424964073757) | 2 | 7 | 5 | 28859 | 7 | ||||
| 55357 | 179347 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 111 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6004743.78868 | 2092719.75542 | 37.7264785996005 | -122.42580404683 | (37.7264785996005, -122.42580404683) | 9 | 7 | 6 | 28861 | 5 | ||||
| 55433 | 240233 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006323.63645 | 2095792.4995 | 37.7350048327147 | -122.420560592807 | (37.7350048327147, -122.420560592807) | 2 | 7 | 7 | 28859 | 2 | |||
| 55575 | 185967 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984828.2185 | 2101268.2412 | 37.7488048887282 | -122.495280467418 | (37.7488048887282, -122.495280467418) | 1 | 8 | 3 | 29491 | 35 | |||
| 55608 | 43458 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999537.11613 | 2091248.65338 | 37.72214368387 | -122.443697599487 | (37.72214368387, -122.443697599487) | 9 | 7 | 6 | 28861 | 25 | |
| 55783 | 249701 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2400 Baker St | 33 | Front Yard : Yard | Tree | Private 2 | 3 | 5999708.51738 | 2117216.5698 | 37.7934549597209 | -122.444970945052 | (37.7934549597209, -122.444970945052) | 13 | 9 | 1 | 57 | 27 | ||||
| 56517 | 247618 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 9 | Front Yard : Yard | Tree | Private 2 | 1 | 6009527.21147 | 2096859.2716 | 37.738113982375 | -122.409559917383 | (37.738113982375, -122.409559917383) | 10 | 7 | 7 | 28859 | 2 |
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) );