trees
603 rows where qSpecies_id = 172 sorted by qCaretaker_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2760 | 111440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 12 | 5999883.47669 | 2091070.55057 | 37.7216744032298 | -122.442487538293 | (37.7216744032298, -122.442487538293) | 9 | 7 | 6 | 28861 | 25 | |||
| 6898 | 43451 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999743.13158 | 2091140.97159 | 37.7218597624867 | -122.442977727254 | (37.7218597624867, -122.442977727254) | 9 | 7 | 6 | 28861 | 25 | |
| 6925 | 43437 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 19 | Permit Number 43162 | 5999381.26407 | 2091328.91122 | 37.7223551630339 | -122.444242104791 | (37.7223551630339, -122.444242104791) | 9 | 7 | 6 | 28861 | 25 | |
| 8107 | 260620 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1510 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015860.79811 | 2095596.0425 | 37.7349982739746 | -122.387573242087 | (37.7349982739746, -122.387573242087) | 10 | 3 | 8 | 58 | 1 | ||
| 13698 | 179341 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100x Mansell St | 9 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6011434.85378 | 2090631.08875 | 37.7211193983363 | -122.402526372706 | (37.7211193983363, -122.402526372706) | 10 | 7 | 8 | 309 | 28 | |||
| 14029 | 117209 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7X CONGO ST | 1 | Median : Cutout | Tree | DPW 1 | 18 | 30x20 | 6000046 | 2093900 | 37.7294526827424 | -122.442128742048 | (37.7294526827424, -122.442128742048) | 9 | 7 | 4 | 63 | 40 | |||
| 14808 | 43442 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 14 | Permit Number 774294 | 5999458.08811 | 2091290.64416 | 37.7222544731451 | -122.443973794765 | (37.7222544731451, -122.443973794765) | 9 | 7 | 6 | 28861 | 25 | |
| 15094 | 43443 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 6 | Permit Number 43162 | 5999469.30626 | 2091283.8759 | 37.7222365289812 | -122.44393453037 | (37.7222365289812, -122.44393453037) | 9 | 7 | 6 | 28861 | 25 | |
| 16859 | 197195 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1700x Quesada Ave | 52 | Median : Yard | Tree | DPW 1 | 5 | 6014229.96459 | 2095381.00329 | 37.7343173549634 | -122.393196613328 | (37.7343173549634, -122.393196613328) | 10 | 3 | 8 | 58 | 1 | ||||
| 21634 | 123489 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 600 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 5995672.03179 | 2111788.60232 | 37.7783200198099 | -122.458544293173 | (37.7783200198099, -122.458544293173) | 11 | 6 | 2 | 54 | 16 | |||
| 24009 | 43438 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999550.19859 | 2091242.74615 | 37.7221282101348 | -122.443651952598 | (37.7221282101348, -122.443651952598) | 9 | 7 | 6 | 28861 | 25 | |
| 27209 | 43436 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999647.97046 | 2091192.04874 | 37.7219945825726 | -122.443310340608 | (37.7219945825726, -122.443310340608) | 9 | 7 | 6 | 28861 | 25 | |
| 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 | |
| 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 | |
| 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 | |||||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | |
| 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 | |
| 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 | |
| 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 | |||
| 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 | |
| 60942 | 247939 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 29 Joy St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 12 | Permit Number 775404 | 6010258.29977 | 2098917.51569 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | 2 | 7 | 7 | 28859 | 2 | |||
| 63486 | 116675 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100 Esmeralda Ave | 14 | Unaccepted Street : Yard | Tree | DPW 1 | 14 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | ||||
| 65505 | 240287 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4300x 21st St | 1 | Median : Yard | Tree | DPW 1 | 10 | Width 10ft | 6000783.43844 | 2103265.50609 | 37.755210146643 | -122.440250712118 | (37.755210146643, -122.440250712118) | 2 | 4 | 5 | 28862 | 22 | |||
| 66489 | 96226 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 14X CAINE AVE | 11 | Median : Cutout | Tree | DPW 1 | 08/24/2011 12:00:00 AM | 3 | 6x300 | 5997641.2 | 2089761.8 | 37.7179528127364 | -122.450144172407 | (37.7179528127364, -122.450144172407) | 9 | 8 | 6 | 28861 | 24 | ||
| 71335 | 43459 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999660.0285 | 2091185.48027 | 37.7219772346577 | -122.443268187573 | (37.7219772346577, -122.443268187573) | 9 | 7 | 6 | 28861 | 25 | |
| 74404 | 111444 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.7215516403644 | -122.442184051271 | (37.7215516403644, -122.442184051271) | 9 | 7 | 6 | 28861 | 25 | ||
| 74998 | 43439 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 12 | Permit Number 774294 | 5999436.71838 | 2091300.71882 | 37.7222809168058 | -122.444048388121 | (37.7222809168058, -122.444048388121) | 9 | 7 | 6 | 28861 | 25 | |
| 77433 | 29594 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991181.08119 | 2091145.24325 | 37.7213796099522 | -122.472574562389 | (37.7213796099522, -122.472574562389) | 9 | 8 | 4 | 64 | 40 | ||
| 77611 | 179340 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 10x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6011654.04439 | 2090707.03922 | 37.7213401773752 | -122.401774025963 | (37.7213401773752, -122.401774025963) | 10 | 7 | 8 | 309 | 28 | |||
| 79021 | 111446 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
| 82205 | 90292 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 2 | 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 | |
| 82890 | 43444 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999490.75065 | 2091271.846 | 37.7222047208672 | -122.443859538611 | (37.7222047208672, -122.443859538611) | 9 | 7 | 6 | 28861 | 25 | |
| 83096 | 109209 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 2401x CASTRO ST | 5 | Median : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
| 83216 | 111448 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6x7 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | |||
| 84319 | 254441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 501X Brotherhood Way | 19 | Median : Yard | Tree | DPW 1 | 10x10 | 5992686 | 2087818 | 37.7123307991194 | -122.467130733446 | (37.7123307991194, -122.467130733446) | 9 | 8 | 4 | 64 | 24 | ||||
| 86307 | 197178 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 24 | Median : Yard | Tree | DPW 1 | 1 | 6012271.91368 | 2102115.47955 | 37.7526998195515 | -122.400439152361 | (37.7526998195515, -122.400439152361) | 10 | 3 | 8 | 28856 | 29 | ||||
| 86423 | 111242 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 745X SANCHEZ ST | 3 | Median : Yard | Tree | DPW 1 | 8 | 3x3 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | |||
| 87367 | 197179 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 13 | Median : Yard | Tree | DPW 1 | 2 | 6012255.14184 | 2102164.55152 | 37.7528336251844 | -122.400500599441 | (37.7528336251844, -122.400500599441) | 10 | 3 | 8 | 28856 | 29 | ||||
| 90750 | 240285 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 500x 27th St | 12 | Median : Cutout | Tree | DPW 1 | 7 | Width 4ft | 6002820.0132 | 2100066.22861 | 37.7465414276378 | -122.432979084538 | (37.7465414276378, -122.432979084538) | 2 | 7 | 5 | 63 | 22 | |||
| 93435 | 122493 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 69x Bonview St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
| 95375 | 28089 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1100 Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3x4 | 6018138.7903974 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | 10 | 3 | 8 | 58 | 1 | ||
| 97911 | 90236 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986564.88308 | 2111184.05617 | 37.7761325015309 | -122.49000439126 | (37.7761325015309, -122.49000439126) | 11 | 6 | 2 | 55 | 26 | ||
| 98190 | 90273 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4138 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982680.48649 | 2111041.10638 | 37.7755124117331 | -122.50343075165 | (37.7755124117331, -122.50343075165) | 11 | 6 | 2 | 55 | 26 | ||
| 99974 | 43441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 7 | Permit Number 774294 | 5999448.10749 | 2091294.70392 | 37.7222650509726 | -122.444008586831 | (37.7222650509726, -122.444008586831) | 9 | 7 | 6 | 28861 | 25 | |
| 103542 | 26915 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 10 Caine Ave | 11 | Median : Cutout | Tree | DPW 1 | 01/26/1999 12:00:00 AM | 3 | 10 | 5997570.4467 | 2089598.14436 | 37.7174994031582 | -122.450376943463 | (37.7174994031582, -122.450376943463) | 9 | 8 | 6 | 28861 | 24 | ||
| 105012 | 43447 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999697.54909 | 2091165.42889 | 37.7219243176433 | -122.443137049362 | (37.7219243176433, -122.443137049362) | 9 | 7 | 6 | 28861 | 25 | |
| 111388 | 96227 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 14X CAINE AVE | 10 | Median : Cutout | Tree | DPW 1 | 08/24/2011 12:00:00 AM | 3 | 6x300 | 5997641.2 | 2089761.8 | 37.7179528127364 | -122.450144172407 | (37.7179528127364, -122.450144172407) | 9 | 8 | 6 | 28861 | 24 | ||
| 112600 | 12733 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 5990471.06768 | 2114763.19979 | 37.7861871602608 | -122.476753550914 | (37.7861871602608, -122.476753550914) | 11 | 6 | 1 | 55 | 33 | |||
| 113750 | 43445 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999858.82768 | 2091082.35027 | 37.7217053974709 | -122.442573589903 | (37.7217053974709, -122.442573589903) | 9 | 7 | 6 | 28861 | 25 | |
| 116073 | 111445 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 7 | 5999980.84773 | 2091017.84349 | 37.7215352313433 | -122.442147171851 | (37.7215352313433, -122.442147171851) | 9 | 7 | 6 | 28861 | 25 | |||
| 116691 | 90294 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 4 | 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 | |
| 118932 | 90237 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986502.49805 | 2111182.03545 | 37.7761233100942 | -122.490220046223 | (37.7761233100942, -122.490220046223) | 11 | 6 | 2 | 55 | 26 | ||
| 119840 | 113507 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 200x Mansell St | 13 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011128.47606 | 2090549.92676 | 37.720879434926 | -122.40357972974 | (37.720879434926, -122.40357972974) | 10 | 3 | 7 | 309 | 28 | |||
| 120475 | 90731 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4575 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981455 | 2110247 | 37.7732599086068 | -122.50761099125 | (37.7732599086068, -122.50761099125) | 11 | 6 | 2 | 55 | 26 | ||
| 121538 | 90297 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4545X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981520.769284 | 2110951.300184 | 37.7751975846267 | -122.50743575643 | (37.7751975846267, -122.50743575643) | 11 | 6 | 2 | 55 | 26 | |
| 126055 | 43435 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 14 | Permit Number 43162 | 5999819.49506 | 2091104.19362 | 37.7217631321556 | -122.442711119627 | (37.7217631321556, -122.442711119627) | 9 | 7 | 6 | 28861 | 25 | |
| 128545 | 12728 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2005 12:00:00 AM | 2 | 4X4 | 5990457.1993 | 2114785.86556 | 37.7862485896694 | -122.476803188002 | (37.7862485896694, -122.476803188002) | 11 | 6 | 1 | 55 | 33 | ||
| 129541 | 111443 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 17 | 5999927.23458 | 2091047.72982 | 37.7216142367899 | -122.442334641847 | (37.7216142367899, -122.442334641847) | 9 | 7 | 6 | 28861 | 25 | |||
| 132280 | 43432 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999683.18724 | 2091173.0602 | 37.7219444525549 | -122.443187242296 | (37.7219444525549, -122.443187242296) | 9 | 7 | 6 | 28861 | 25 | |
| 134429 | 18936 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2721 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001590.13521 | 2115636.51425 | 37.7892237457171 | -122.438347166582 | (37.7892237457171, -122.438347166582) | 13 | 6 | 1 | 29490 | 27 | |||
| 134473 | 43434 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999832.90051 | 2091096.83279 | 37.7217436851966 | -122.44266425237 | (37.7217436851966, -122.44266425237) | 9 | 7 | 6 | 28861 | 25 | |
| 135580 | 111441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5 | 5999897.1183 | 2091063.84845 | 37.7216567783095 | -122.442439902078 | (37.7216567783095, -122.442439902078) | 9 | 7 | 6 | 28861 | 25 | |||
| 136434 | 43457 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999502.576 | 2091265.96486 | 37.7221892471271 | -122.443818239036 | (37.7221892471271, -122.443818239036) | 9 | 7 | 6 | 28861 | 25 | |
| 139145 | 43449 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999756.32409 | 2091134.05765 | 37.7218415305512 | -122.442931628018 | (37.7218415305512, -122.442931628018) | 9 | 7 | 6 | 28861 | 25 | |
| 140411 | 90246 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986239.468923 | 2111161.958067 | 37.7760528187899 | -122.491128444049 | (37.7760528187899, -122.491128444049) | 11 | 6 | 2 | 55 | 26 | |
| 144216 | 111439 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6 | 5999870.68262 | 2091075.24274 | 37.7216865575792 | -122.442532100582 | (37.7216865575792, -122.442532100582) | 9 | 7 | 6 | 28861 | 25 | |||
| 144463 | 43455 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | Permit Number 43162 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||
| 147980 | 111447 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
| 149820 | 43450 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999728.91774 | 2091148.65353 | 37.7218800449238 | -122.443027412104 | (37.7218800449238, -122.443027412104) | 9 | 7 | 6 | 28861 | 25 | |
| 152360 | 197180 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 11 | Median : Yard | Tree | DPW 1 | 1 | 6012255.35088 | 2102175.8421 | 37.752864638318 | -122.400500669565 | (37.752864638318, -122.400500669565) | 10 | 3 | 8 | 28856 | 29 | ||||
| 157288 | 90245 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986200.19499 | 2111171.72975 | 37.7760773543178 | -122.491265020448 | (37.7760773543178, -122.491265020448) | 11 | 6 | 2 | 55 | 26 | ||
| 160862 | 90295 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 5 | 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 | |
| 161527 | 29651 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500X La Salle Ave | 10 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015684.3928 | 2096048.7707 | 37.7362316014874 | -122.388214728777 | (37.7362316014874, -122.388214728777) | 10 | 3 | 8 | 58 | 1 | ||
| 168158 | 90298 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4527 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981574.06475 | 2110953.226782 | 37.7752060137503 | -122.507251541607 | (37.7752060137503, -122.507251541607) | 11 | 6 | 2 | 55 | 26 | |
| 171828 | 90244 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986220.07913 | 2111172.67589 | 37.7760811139804 | -122.491196306516 | (37.7760811139804, -122.491196306516) | 11 | 6 | 2 | 55 | 26 | ||
| 172013 | 43433 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 16 | Permit Number 43162 | 5999846.51913 | 2091089.02473 | 37.7217230223792 | -122.442616616172 | (37.7217230223792, -122.442616616172) | 9 | 7 | 6 | 28861 | 25 | |
| 176100 | 90288 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4790X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980763.025413 | 2110963.934321 | 37.7751876098256 | -122.51005785431 | (37.7751876098256, -122.51005785431) | 11 | 6 | 2 | 55 | 26 | |
| 177162 | 90271 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4100X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982889.660166 | 2111040.818849 | 37.7755239169344 | -122.502707160377 | (37.7755239169344, -122.502707160377) | 11 | 6 | 2 | 55 | 26 | |
| 181117 | 113496 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 200x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | 6011235.51183 | 2090583.52363 | 37.7209776633755 | -122.403212099473 | (37.7209776633755, -122.403212099473) | 10 | 3 | 7 | 309 | 28 | |||
| 182050 | 18938 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2730 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 6 | 4X4 | 6001751.73398 | 2115704.11419 | 37.7894185478752 | -122.437792899137 | (37.7894185478752, -122.437792899137) | 13 | 6 | 1 | 29490 | 27 | ||
| 183826 | 90272 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4122 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982765.5809 | 2111043.53002 | 37.7755240685037 | -122.503136574036 | (37.7755240685037, -122.503136574036) | 11 | 6 | 2 | 55 | 26 | ||
| 184999 | 43452 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 10 | Permit Number 43162 | 5999577.25447 | 2091228.40825 | 37.7220903846374 | -122.443557397876 | (37.7220903846374, -122.443557397876) | 9 | 7 | 6 | 28861 | 25 | |
| 185182 | 29652 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500X La Salle Ave | 11 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015669.3226 | 2096063.213 | 37.7362704220955 | -122.388267840771 | (37.7362704220955, -122.388267840771) | 10 | 3 | 8 | 58 | 1 | ||
| 186898 | 43440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999628.40371 | 2091200.8294 | 37.7220175764452 | -122.443378608135 | (37.7220175764452, -122.443378608135) | 9 | 7 | 6 | 28861 | 25 | |
| 194172 | 240286 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 5200x Diamond Heights Blvd | 42 | Median : Yard | Tree | DPW 1 | 2 | 6001709.51148 | 2098788.78469 | 37.7429708160432 | -122.436727644972 | (37.7429708160432, -122.436727644972) | 2 | 7 | 5 | 63 | 7 | ||||
| 1132 | 87818 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 85 Mendosa Ave | 1 | Median : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | Permit Number 50680 | 5993356 | 2100787 | 37.747979128324 | -122.465756707117 | (37.747979128324, -122.465756707117) | 1 | 8 | 4 | 29491 | 40 | |||
| 1168 | 39947 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 1286 | 39945 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 1380 | 240268 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 601x Powhattan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6008545.16525 | 2098123.68757 | 37.7415307145772 | -122.413044731843 | (37.7415307145772, -122.413044731843) | 10 | 7 | 7 | 28859 | 2 | ||||
| 2164 | 240263 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 400X Powhattan Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 6008170.52393 | 2098149.53855 | 37.7415806575183 | -122.414341946344 | (37.7415806575183, -122.414341946344) | 2 | 7 | 7 | 28859 | 2 | ||||
| 2184 | 185987 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984879.8852 | 2101041.6583 | 37.7481857789236 | -122.495085101033 | (37.7481857789236, -122.495085101033) | 1 | 8 | 3 | 29491 | 35 | |||
| 2307 | 240272 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 99 Prentiss St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008870 | 2098076 | 37.7414180046723 | -122.41191819098 | (37.7414180046723, -122.41191819098) | 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) );