trees
90 rows where qSpecies_id = 141 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6728 | 115283 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 70 Lurline St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 773684 | 5991870.1 | 2105051.8 | 37.7596033336043 | -122.471205512413 | (37.7596033336043, -122.471205512413) | 1 | 8 | 4 | 56 | 12 | |||
11308 | 51326 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 489 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Permit Number 47685 | 6013940.29088 | 2112585.38247 | 37.7815407556469 | -122.395402975878 | (37.7815407556469, -122.395402975878) | 6 | 2 | 9 | 28856 | 6 | ||
12054 | 65923 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 102 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 4 | Permit Number 28939 | 6014289.96191 | 2112626.22069 | 37.7816723300522 | -122.394196132467 | (37.7816723300522, -122.394196132467) | 6 | 2 | 9 | 28856 | 6 | |
15050 | 106111 | Undocumented 4 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | ||||
54696 | 58589 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 232 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1979 12:00:00 AM | Permit Number 17789 | 5997635.76865 | 2106178.20779874 | 37.7630279802836 | -122.451346290086 | (37.7630279802836, -122.451346290086) | 15 | 5 | 11 | 29492 | 9 | |||
61853 | 106112 | Undocumented 4 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | |||
70473 | 115284 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 70 Lurline St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 773684 | 5991870.1 | 2105051.8 | 37.7596033336043 | -122.471205512413 | (37.7596033336043, -122.471205512413) | 1 | 8 | 4 | 56 | 12 | |||
74842 | 53947 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 100 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1972 12:00:00 AM | 2 | Permit Number 9662 | 6010008.98982 | 2095241.82801 | 37.7336998129817 | -122.407780142849 | (37.7336998129817, -122.407780142849) | 10 | 3 | 7 | 309 | 28 | ||
80247 | 34442 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 51 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38186 | 6002033.25369179 | 2096285.02553427 | 37.7361144689001 | -122.435429168133 | (37.7361144689001, -122.435429168133) | 2 | 7 | 5 | 63 | 7 | ||
81732 | 177285 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 105 Burrows St | 1 | Side Yard : Yard | Tree | Private 2 | 2 | 6011169.81083 | 2093473.60128 | 37.728909549831 | -122.403642451135 | (37.728909549831, -122.403642451135) | 10 | 3 | 7 | 309 | 28 | ||||
82164 | 117425 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 218 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775470 | 6004576.76699 | 2091985.71039 | 37.724453633907 | -122.426329194258 | (37.724453633907, -122.426329194258) | 9 | 7 | 6 | 28861 | 5 | ||
89144 | 110719 | Undocumented 4 | Magnolia champaca :: Champa 141 | 250 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993202.3 | 2102594.8 | 37.7529340165375 | -122.466419562057 | (37.7529340165375, -122.466419562057) | 1 | 8 | 4 | 56 | 12 | |||||
94789 | 177287 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 104 Burrows St | 4 | Side Yard : Yard | Tree | Private 2 | 1 | 6011161.858 | 2093502.53112 | 37.7289885408852 | -122.403671979495 | (37.7289885408852, -122.403671979495) | 10 | 3 | 7 | 309 | 28 | ||||
105089 | 177286 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 104 Burrows St | 3 | Side Yard : Yard | Tree | Private 2 | 2 | 6011163.93479 | 2093493.48317 | 37.7289638131138 | -122.403664163474 | (37.7289638131138, -122.403664163474) | 10 | 3 | 7 | 309 | 28 | ||||
109319 | 177277 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 247 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998677.48032 | 2089600.90365 | 37.7175702751156 | -122.446550650088 | (37.7175702751156, -122.446550650088) | 9 | 7 | 6 | 28861 | 25 | ||||
119121 | 177278 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 247 Mount Vernon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998683.47325 | 2089596.01015 | 37.7175571809995 | -122.446529583477 | (37.7175571809995, -122.446529583477) | 9 | 7 | 6 | 28861 | 25 | ||||
122278 | 106109 | Significant Tree 6 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/23/2014 12:00:00 AM | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | |||
122601 | 47439 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 855 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 4 | Permit Number 45350 | 5982911.03807 | 2109970.63017 | 37.772586745673 | -122.50255398243 | (37.772586745673, -122.50255398243) | 11 | 6 | 2 | 55 | 26 | |
133614 | 34408 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 153 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2005 12:00:00 AM | Permit Number 48126 | 6004564.73535669 | 2097520.70439989 | 37.7396508092604 | -122.426764774135 | (37.7396508092604, -122.426764774135) | 2 | 7 | 5 | 63 | 7 | ||
133627 | 67995 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 242 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31720 | 5994595.75102873 | 2089048.56400841 | 37.7158196896579 | -122.460619224226 | (37.7158196896579, -122.460619224226) | 9 | 8 | 6 | 28861 | 24 | ||
136585 | 52529 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 142 San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2005 12:00:00 AM | 7 | Permit Number 48628 | 6001327.58175 | 2092279.55294 | 37.7250762588572 | -122.437582197876 | (37.7250762588572, -122.437582197876) | 9 | 7 | 6 | 28861 | 25 | ||
141941 | 106110 | Undocumented 4 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | |||
161777 | 42836 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1184 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | 3 | Permit Number 42768 | 6006179.23317 | 2120408.85746 | 37.8025873493742 | -122.422808722571 | (37.8025873493742, -122.422808722571) | 5 | 9 | 1 | 28858 | 32 | |
162354 | 115009 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 118 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 2 | Permit Number 772567 | 6009049.21321 | 2093699.6892 | 37.7294116530064 | -122.410989499484 | (37.7294116530064, -122.410989499484) | 9 | 3 | 7 | 309 | 28 | ||
169310 | 106108 | Undocumented 4 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | ||||
171214 | 57815 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 154 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1977 12:00:00 AM | 5 | Permit Number 16752 | 5988698.71147 | 2114305.32947 | 37.7848270128848 | -122.482851795657 | (37.7848270128848, -122.482851795657) | 11 | 6 | 2 | 55 | 26 | ||
183783 | 49471 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 3328@ VALENCIA 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/2003 12:00:00 AM | Permit Number 46396 | 6006136.25469951 | 2103196.12306543 | 37.7553229433082 | -122.421734137516 | (37.7553229433082, -122.421734137516) | 2 | 4 | 5 | 28859 | 19 | ||
188800 | 106107 | Significant Tree 6 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/23/2014 12:00:00 AM | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | |||
193497 | 51325 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 489 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2004 12:00:00 AM | 2 | Permit Number 47685 | 6013925.58695 | 2112575.54425 | 37.7815129243211 | -122.395453155354 | (37.7815129243211, -122.395453155354) | 6 | 2 | 9 | 28856 | 6 | ||
801 | 261069 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1256 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014418 | 2090762 | 37.7216449464937 | -122.392223572812 | (37.7216449464937, -122.392223572812) | 10 | 3 | 8 | 58 | 1 | ||||
7469 | 90566 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1800 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 12/27/2014 12:01:00 PM | 3 | 3x3 | 5989998.07126 | 2110625.47725 | 37.7747986774394 | -122.478087352371 | (37.7747986774394, -122.478087352371) | 11 | 6 | 2 | 55 | 26 | |
7484 | 90567 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1800 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5989974.77369 | 2110623.83605 | 37.7747928188343 | -122.47816782258 | (37.7747928188343, -122.47816782258) | 11 | 6 | 2 | 55 | 26 | |
8585 | 115778 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1256 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 772460 | 6014418 | 2090762 | 37.7216449464937 | -122.392223572812 | (37.7216449464937, -122.392223572812) | 10 | 3 | 8 | 58 | 1 | |
14264 | 96728 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1512 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6015795.15205 | 2096700.49515 | 37.7380272409624 | -122.38787724665 | (37.7380272409624, -122.38787724665) | 10 | 3 | 8 | 58 | 1 | ||
23386 | 252904 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1216 Clay St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008866 | 2117029 | 37.7934583239602 | -122.413271980668 | (37.7934583239602, -122.413271980668) | 5 | 1 | 10 | 28857 | 21 | ||||
24504 | 93143 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 249 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5990845.47769 | 2113717.02599 | 37.78333636898 | -122.475381793838 | (37.78333636898, -122.475381793838) | 11 | 6 | 2 | 54 | 26 | |||
24513 | 108504 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 1445 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773649 | 5991782.44635 | 2105596.59043 | 37.7610941136514 | -122.471548358504 | (37.7610941136514, -122.471548358504) | 1 | 8 | 4 | 56 | 12 |
49852 | 254213 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 2395 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781237 | 5992629.69291 | 2099162.15804 | 37.7434758049124 | -122.468150045235 | (37.7434758049124, -122.468150045235) | 1 | 8 | 4 | 29491 | 40 |
70580 | 82365 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 74 West View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53884 | 6007138.42533 | 2094313.10717 | 37.7309886304042 | -122.417638750344 | (37.7309886304042, -122.417638750344) | 9 | 3 | 7 | 309 | 28 | |
82444 | 102301 | Undocumented 4 | Magnolia champaca :: Champa 141 | 1150 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773621 | 6003812 | 2101578 | 37.7507486162623 | -122.42965670576 | (37.7507486162623, -122.42965670576) | 2 | 4 | 5 | 28862 | 22 | |
83789 | 95560 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 708 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767354 | 6001217 | 2102264 | 37.75248492744 | -122.438679572623 | (37.75248492744, -122.438679572623) | 2 | 4 | 5 | 28862 | 22 | |
114531 | 97547 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 90X Valparaiso St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 769183 | 6008640 | 2119879 | 37.8012710279062 | -122.4142556975 | (37.8012710279062, -122.4142556975) | 3 | 1 | 10 | 308 | 32 | ||
143482 | 89097 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 555 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990302.8549 | 2111587.58399 | 37.7774580439741 | -122.477103374633 | (37.7774580439741, -122.477103374633) | 11 | 6 | 2 | 55 | 26 | ||
193363 | 108532 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 70 Lurline St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773684 | 5991847.86236 | 2105069.58022 | 37.759650867089 | -122.471283716023 | (37.759650867089, -122.471283716023) | 1 | 8 | 4 | 56 | 12 |
6541 | 60873 | Permitted Site 7 | Magnolia champaca :: Champa 141 | 2028 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2012 12:00:00 AM | 4x4 | Permit Number 768154 | 6008629.04829533 | 2119833.32118677 | 37.8011449901029 | -122.414290361568 | (37.8011449901029, -122.414290361568) | 3 | 1 | 10 | 308 | 32 | ||
3948 | 261068 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1256 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2019 12:00:00 AM | 3 | 4x6 | 6014418 | 2090762 | 37.7216449464937 | -122.392223572812 | (37.7216449464937, -122.392223572812) | 10 | 3 | 8 | 58 | 1 | |
62179 | 102300 | Undocumented 4 | Magnolia champaca :: Champa 141 | 1150 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2014 12:00:00 AM | 3 | 5x5 | Permit Number 773621 | 6003812 | 2101578 | 37.7507486162623 | -122.42965670576 | (37.7507486162623, -122.42965670576) | 2 | 4 | 5 | 28862 | 22 | |
15451 | 200168 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1101 Gilman Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6014990.039 | 2089901.3883 | 37.7193136223873 | -122.390186075408 | (37.7193136223873, -122.390186075408) | 10 | 3 | 8 | 58 | 1 | |||
99124 | 254581 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 500 Ivy St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | ||||
147415 | 249993 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 230 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011552.45042 | 2120107.96265 | 37.8020628692688 | -122.404193406414 | (37.8020628692688, -122.404193406414) | 3 | 1 | 10 | 308 | 23 | |||
24011 | 130430 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 89 Valparaiso St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6008655.47959 | 2119859.36383 | 37.8012179813792 | -122.414200741082 | (37.8012179813792, -122.414200741082) | 3 | 1 | 10 | 308 | 32 | |||
51109 | 229212 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 67 Belcher St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003822.24393 | 2107963.26072 | 37.768281600153 | -122.430076734873 | (37.768281600153, -122.430076734873) | 7 | 9 | 5 | 28862 | 3 | |||
52133 | 229214 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002775.66665 | 2096156.2936 | 37.7358031366028 | -122.432853153354 | (37.7358031366028, -122.432853153354) | 2 | 7 | 5 | 63 | 7 | |||
139275 | 177284 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 50 Gladstone Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6006368.59869 | 2094147.86405 | 37.7304915598166 | -122.420288451661 | (37.7304915598166, -122.420288451661) | 9 | 7 | 7 | 28861 | 5 | |||
185175 | 123607 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 172 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994619.74414 | 2114496.4791 | 37.785694588746 | -122.462380974399 | (37.785694588746, -122.462380974399) | 11 | 6 | 1 | 54 | 11 | |||
9457 | 146702 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 843 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5985389.01338 | 2110118.19481 | 37.7731372161446 | -122.493993410689 | (37.7731372161446, -122.493993410689) | 11 | 6 | 2 | 55 | 26 | |||
27510 | 229207 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010677.34629 | 2100029.09065 | 37.7468820009005 | -122.405806525749 | (37.7468820009005, -122.405806525749) | 2 | 7 | 7 | 28859 | 2 | |||
27575 | 229206 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 3703 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005754.08404 | 2100791.82852 | 37.7486997466004 | -122.422884932902 | (37.7486997466004, -122.422884932902) | 2 | 4 | 5 | 28859 | 19 | |||
32539 | 229213 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 44 Levant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000267.31674 | 2106588.21137 | 37.7643040794818 | -122.44227412465 | (37.7643040794818, -122.44227412465) | 15 | 5 | 5 | 28862 | 3 | |||
32709 | 121920 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 746 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990705.75047 | 2110306.02269 | 37.7739625940269 | -122.475616037623 | (37.7739625940269, -122.475616037623) | 11 | 6 | 2 | 54 | 26 | |||
51855 | 130431 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 220 Joice St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010221.29362 | 2116953.37986 | 37.7933266858222 | -122.408577203898 | (37.7933266858222, -122.408577203898) | 3 | 1 | 10 | 28857 | 4 | |||
64232 | 229211 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 69 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003825.75049 | 2107873.30523 | 37.7680348027992 | -122.430058188146 | (37.7680348027992, -122.430058188146) | 7 | 9 | 5 | 28862 | 3 | |||
68458 | 177283 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 184 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003174.52828 | 2092323.89174 | 37.7253028412412 | -122.431200667976 | (37.7253028412412, -122.431200667976) | 9 | 7 | 6 | 28861 | 5 | |||
81708 | 192807 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 816 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011469.60353 | 2109439.42754 | 37.7727649651647 | -122.403728991106 | (37.7727649651647, -122.403728991106) | 14 | 2 | 9 | 28853 | 34 | |||
91108 | 177276 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 57 Danton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002839.91705 | 2094626.90551 | 37.7316074296218 | -122.432521808961 | (37.7316074296218, -122.432521808961) | 9 | 7 | 5 | 28861 | 25 | |||
95268 | 208539 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 278 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994218.38162 | 2087785.93969 | 37.7123311045757 | -122.461832077791 | (37.7123311045757, -122.461832077791) | 9 | 8 | 6 | 28861 | 24 | |||
100792 | 229205 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 2670 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010018.96643 | 2103993.2259 | 37.7577297952205 | -122.408362714678 | (37.7577297952205, -122.408362714678) | 2 | 4 | 7 | 28859 | 19 | |||
132531 | 120083 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 279 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5987730.93691 | 2114104.57781 | 37.784219449415 | -122.486185194855 | (37.784219449415, -122.486185194855) | 11 | 6 | 1 | 55 | 26 | |||
136537 | 229208 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 125 Mullen Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009844.46496 | 2099854.56746 | 37.746356185285 | -122.40867425512 | (37.746356185285, -122.40867425512) | 2 | 7 | 7 | 28859 | 2 | |||
147360 | 192804 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 102 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014277.78619 | 2112617.17875 | 37.781646826173 | -122.394237621778 | (37.781646826173, -122.394237621778) | 6 | 2 | 9 | 28856 | 6 | |||
152469 | 242340 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 232 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997593.66914 | 2106162.79262 | 37.7629832433987 | -122.451490785271 | (37.7629832433987, -122.451490785271) | 15 | 5 | 11 | 29492 | 9 | |||
154196 | 229209 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 125 Mullen Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009806.83147 | 2099879.64563 | 37.7464229365797 | -122.408806156877 | (37.7464229365797, -122.408806156877) | 2 | 7 | 7 | 28859 | 2 | |||
172642 | 177282 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 184 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003183.02796 | 2092335.82802 | 37.7253360972661 | -122.43117213701 | (37.7253360972661, -122.43117213701) | 9 | 7 | 6 | 28861 | 5 | |||
172892 | 192806 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 816 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011545.92894 | 2109512.95775 | 37.7729711257451 | -122.403470145551 | (37.7729711257451, -122.403470145551) | 14 | 2 | 9 | 28853 | 34 | |||
173164 | 229215 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 151 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004588.6646 | 2097530.93543 | 37.7396802542509 | -122.426682765415 | (37.7396802542509, -122.426682765415) | 2 | 7 | 5 | 63 | 7 | |||
181363 | 192805 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 816 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011561.22254 | 2109527.20961 | 37.7730111123052 | -122.403418245661 | (37.7730111123052, -122.403418245661) | 14 | 2 | 9 | 28853 | 34 | |||
39877 | 229210 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 157 Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5997866.99015 | 2106170.0935 | 37.7630189374956 | -122.450545992616 | (37.7630189374956, -122.450545992616) | 15 | 5 | 11 | 29492 | 9 | |||
97970 | 192810 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 699 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6015748.32863 | 2097474.20418 | 37.7401490942054 | -122.388093118111 | (37.7401490942054, -122.388093118111) | 10 | 3 | 8 | 58 | 1 | |||
100891 | 192811 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 699 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6015760.75938 | 2097489.04776 | 37.740190540353 | -122.388051172818 | (37.740190540353, -122.388051172818) | 10 | 3 | 8 | 58 | 1 | |||
120459 | 192812 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 699 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6015782.20079 | 2097521.5447 | 37.7402809582086 | -122.38797930352 | (37.7402809582086, -122.38797930352) | 10 | 3 | 8 | 58 | 1 | |||
55269 | 177280 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 835 Excelsior Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 5ft | 6004480.81499 | 2091450.56223 | 37.7229788105017 | -122.426622797701 | (37.7229788105017, -122.426622797701) | 9 | 7 | 6 | 28861 | 5 | |||
95396 | 192809 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1596 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015761.01767 | 2097422.05642 | 37.7400066101295 | -122.388045606039 | (37.7400066101295, -122.388045606039) | 10 | 3 | 8 | 58 | 1 | |||
106924 | 192808 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1596 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015772.9846 | 2097413.5377 | 37.7399838824604 | -122.388003634662 | (37.7399838824604, -122.388003634662) | 10 | 3 | 8 | 58 | 1 | |||
166097 | 177281 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 835 Excelsior Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6004474.64827 | 2091455.68598 | 37.7229925305564 | -122.426644479486 | (37.7229925305564, -122.426644479486) | 9 | 7 | 6 | 28861 | 5 | |||
7327 | 123578 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 90 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 5994289.23744 | 2114960.32648 | 37.7869491502366 | -122.463558099781 | (37.7869491502366, -122.463558099781) | 11 | 6 | 1 | 54 | 11 | |||
22820 | 123579 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 90 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 5994289.50047 | 2114946.6049 | 37.7869114896689 | -122.463556193559 | (37.7869114896689, -122.463556193559) | 11 | 6 | 1 | 54 | 11 | |||
135470 | 123577 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 90 05th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 5994288.85987 | 2114975.14753 | 37.7869898230497 | -122.463560482108 | (37.7869898230497, -122.463560482108) | 11 | 6 | 1 | 54 | 11 | |||
187646 | 180664 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 339 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:55:00 PM | 3 | Width 6ft | 6002468.5653 | 2086489.08528 | 37.7092417219876 | -122.433224385404 | (37.7092417219876, -122.433224385404) | 9 | 7 | 6 | 28861 | 5 | ||
91202 | 202200 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 1946 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 6013086.08016 | 2093479.71408 | 37.7290331922147 | -122.397018153772 | (37.7290331922147, -122.397018153772) | 10 | 3 | 8 | 58 | 1 | |||
164948 | 177279 | DPW Maintained 1 | Magnolia champaca :: Champa 141 | 279 Niagara Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998927.0517 | 2089991.78935 | 37.718657809988 | -122.445716093636 | (37.718657809988, -122.445716093636) | 9 | 7 | 6 | 28861 | 25 |
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) );