trees
356 rows where qSpecies_id = 91 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 176676 | 214164 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900 Junipero Serra Blvd | 99 | : | Tree | Private 2 | 5 | Width 0ft | 5991142.14923 | 2090504.71444 | 37.7196186222819 | -122.47266246032 | (37.7196186222819, -122.47266246032) | 9 | 8 | 4 | 64 | 40 | |||
| 148145 | 119668 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
| 102833 | 214157 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 Vista Verde Ct | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999199.91271 | 2096059.32177 | 37.7353334179866 | -122.445208921854 | (37.7353334179866, -122.445208921854) | 9 | 7 | 4 | 63 | 40 | |||
| 3568 | 197493 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 950x Kansas St | 7 | Median : Yard | Tree | DPW 1 | 25 | 6011595.70122 | 2103803.27065 | 37.7572963894245 | -122.402896325021 | (37.7572963894245, -122.402896325021) | 10 | 3 | 8 | 28856 | 29 | ||||
| 36387 | 251333 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1245 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007705.96721 | 2102462.31706 | 37.7533964721949 | -122.416253615419 | (37.7533964721949, -122.416253615419) | 2 | 4 | 7 | 28859 | 19 | |
| 91095 | 197506 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012767.16405 | 2089807.75284 | 37.7189329737454 | -122.397863208018 | (37.7189329737454, -122.397863208018) | 10 | 3 | 8 | 58 | 1 | |||
| 115227 | 239665 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3977 22nd St | 7 | : | Tree | Private 2 | 1 | 6001970.62949 | 2102924.44279 | 37.7543411893077 | -122.436120656556 | (37.7543411893077, -122.436120656556) | 2 | 4 | 5 | 28862 | 22 | ||||
| 145663 | 119666 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
| 167131 | 247586 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 800 Tompkins Ave | 7 | Front Yard : Yard | Tree | Private 2 | 21 | 6008976.64658 | 2096466.10816 | 37.7370035750634 | -122.411435734088 | (37.7370035750634, -122.411435734088) | 10 | 7 | 7 | 28859 | 2 | ||||
| 12625 | 97159 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012757.60574 | 2089814.3813 | 37.7189506418481 | -122.397896712286 | (37.7189506418481, -122.397896712286) | 10 | 3 | 8 | 58 | 1 | ||
| 20433 | 239596 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1816 Castro St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6002590.68382 | 2100212.92694 | 37.7469312162962 | -122.433782563125 | (37.7469312162962, -122.433782563125) | 2 | 7 | 5 | 63 | 22 | ||||
| 54324 | 239588 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1245 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007705.96721 | 2102462.31706 | 37.7533964721949 | -122.416253615419 | (37.7533964721949, -122.416253615419) | 2 | 4 | 7 | 28859 | 19 | |||
| 68839 | 119665 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
| 132958 | 32950 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
| 6293 | 97158 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012744.23117 | 2089823.98249 | 37.7189762599209 | -122.397943616401 | (37.7189762599209, -122.397943616401) | 10 | 3 | 8 | 58 | 1 | ||
| 19961 | 142238 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 689 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004757.5201 | 2110863.998 | 37.776299246383 | -122.427048334097 | (37.776299246383, -122.427048334097) | 7 | 9 | 11 | 28852 | 10 | |||
| 40104 | 156622 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1245 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007708.67537 | 2102405.47581 | 37.7532405513196 | -122.416240224501 | (37.7532405513196, -122.416240224501) | 2 | 4 | 7 | 28859 | 19 | |
| 54807 | 136367 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 689 Hayes St | 5 | : | Tree | Private 2 | 16 | Width 3ft | 6004762.56149 | 2110859.02755 | 37.7762858838177 | -122.427030540428 | (37.7762858838177, -122.427030540428) | 7 | 9 | 11 | 28852 | 10 | |||
| 154950 | 214159 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 711 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5997419.66265 | 2094969.48638 | 37.7322392132651 | -122.451285300082 | (37.7322392132651, -122.451285300082) | 9 | 7 | 4 | 59 | 40 | ||||
| 162055 | 99797 | Undocumented 4 | Schinus molle :: California Pepper 91 | 703-705 Elizabeth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102041 | 37.7519091810186 | -122.436440015083 | (37.7519091810186, -122.436440015083) | 2 | 4 | 5 | 28862 | 22 | ||||
| 168964 | 29596 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900X Junipero Serra Blvd | 5 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991179.03639 | 2091124.89815 | 37.7213236289735 | -122.472580148063 | (37.7213236289735, -122.472580148063) | 9 | 8 | 4 | 64 | 40 | ||
| 172673 | 32951 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
| 180003 | 119664 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
| 190814 | 214161 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 112 Marston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998700.79375 | 2093221.28064 | 37.7275123235144 | -122.446730415591 | (37.7275123235144, -122.446730415591) | 9 | 7 | 4 | 28861 | 40 | ||||
| 56212 | 197490 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 43 | Front Yard : Yard | Tree | Private 2 | 13 | 6015358.4418 | 2102466.66646 | 37.7538357460423 | -122.38978982496 | (37.7538357460423, -122.38978982496) | 10 | 3 | 8 | 28856 | 29 | ||||
| 20260 | 197489 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 42 | Front Yard : Yard | Tree | Private 2 | 8 | 6015361.30396 | 2102471.04633 | 37.753847930956 | -122.389780232768 | (37.753847930956, -122.389780232768) | 10 | 3 | 8 | 28856 | 29 | ||||
| 6035 | 264650 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
| 9816 | 32952 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
| 15670 | 19820 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY25 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 10ST | |||||||||||||
| 16158 | 19973 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY44 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
| 17171 | 239598 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1287 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 6ft | 6003265.33612 | 2100745.73511 | 37.7484324428976 | -122.431487708187 | (37.7484324428976, -122.431487708187) | 2 | 4 | 5 | 28862 | 22 | |||
| 18330 | 97157 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 2 | Permit Number 768080 | 6012734.70575 | 2089832.2191 | 37.7189983454895 | -122.397977119771 | (37.7189983454895, -122.397977119771) | 10 | 3 | 8 | 58 | 1 | ||
| 20349 | 124365 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 69 Palm Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 5995847.94198 | 2114000.61223 | 37.7844037185844 | -122.458095888318 | (37.7844037185844, -122.458095888318) | 11 | 6 | 1 | 54 | 31 | |||
| 23853 | 35615 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
| 46065 | 136368 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000986.41607 | 2118529.18744 | 37.797131913463 | -122.440643524276 | (37.797131913463, -122.440643524276) | 13 | 9 | 1 | 57 | 17 | |||
| 70623 | 138859 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004948.1933 | 2110978.3343 | 37.7766239660594 | -122.426396885095 | (37.7766239660594, -122.426396885095) | 7 | 9 | 11 | 28852 | 10 | |||
| 73636 | 136377 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 633 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009222.09013 | 2115205.65792 | 37.7884718549403 | -122.41191097002 | (37.7884718549403, -122.41191097002) | 5 | 1 | 10 | 28852 | 21 | |||
| 98337 | 239657 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 671 Church St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6004329.6886 | 2104859.6882 | 37.7597886599416 | -122.428100332557 | (37.7597886599416, -122.428100332557) | 2 | 4 | 5 | 28862 | 3 | |||
| 125492 | 119663 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
| 128413 | 244460 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 690 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003277.2679 | 2109662.4318 | 37.7729162274022 | -122.432083107592 | (37.7729162274022, -122.432083107592) | 15 | 9 | 11 | 29492 | 10 | |||
| 131919 | 239655 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 315 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003584.30488 | 2106480.06785 | 37.7641956329586 | -122.430793883956 | (37.7641956329586, -122.430793883956) | 8 | 4 | 5 | 28862 | 3 | |||
| 184088 | 108112 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 690 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003299.11292 | 2109682.74913 | 37.7729732522628 | -122.432008994211 | (37.7729732522628, -122.432008994211) | 15 | 9 | 11 | 29492 | 10 | |||||
| 47859 | 239656 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 701 Church St | 39 | Front Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 6004336.93411 | 2104791.99581 | 37.759603202641 | -122.428070449907 | (37.759603202641, -122.428070449907) | 2 | 4 | 5 | 28862 | 3 | |||
| 3344 | 197494 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 401 Texas St | 3 | : | Tree | Private 2 | 23 | Width 7ft | 6013811.84722 | 2105166.53521 | 37.7611631145139 | -122.395327465206 | (37.7611631145139, -122.395327465206) | 10 | 3 | 8 | 28856 | 29 | |||
| 7939 | 264649 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
| 12626 | 97156 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012721.62132 | 2089840.20593 | 37.7190195469812 | -122.398022907844 | (37.7190195469812, -122.398022907844) | 10 | 3 | 8 | 58 | 1 | ||
| 12994 | 239597 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1287 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 6003266.18046 | 2100734.45358 | 37.7484015143127 | -122.431483983218 | (37.7484015143127, -122.431483983218) | 2 | 4 | 5 | 28862 | 22 | |||
| 23040 | 239637 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003808.38299 | 2103603.27195 | 37.7563093313217 | -122.429813654389 | (37.7563093313217, -122.429813654389) | 2 | 4 | 5 | 28862 | 22 | |||
| 23225 | 239627 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3885 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002571.81479 | 2103540.6818 | 37.7560673714328 | -122.434085656222 | (37.7560673714328, -122.434085656222) | 2 | 4 | 5 | 28862 | 22 | |||
| 36540 | 49625 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 180 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | 6 | Permit Number 768701 | 6007969.67353 | 2109667.22612 | 37.773194308705 | -122.415851810006 | (37.773194308705, -122.415851810006) | 8 | 2 | 9 | 28853 | 19 | ||
| 37249 | 35756 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 6838 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 8 | Permit Number 39022 | 5985797.58958 | 2112563.51135 | 37.7798752557854 | -122.492760252761 | (37.7798752557854, -122.492760252761) | 11 | 6 | 2 | 55 | 26 | ||
| 49320 | 32953 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
| 74800 | 214156 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5993555.55486 | 2101853.98601 | 37.7509203085364 | -122.465144146879 | (37.7509203085364, -122.465144146879) | 1 | 8 | 4 | 29491 | 40 | |||
| 82754 | 239645 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4 Ford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003486.01122 | 2105681.39131 | 37.7619970900117 | -122.431076844836 | (37.7619970900117, -122.431076844836) | 15 | 4 | 5 | 28862 | 3 | |||
| 107727 | 136369 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000984.79842 | 2118544.66291 | 37.7971743129098 | -122.440650232318 | (37.7971743129098, -122.440650232318) | 13 | 9 | 1 | 57 | 17 | |||
| 114058 | 239648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004246.22251 | 2104509.47954 | 37.7588223473949 | -122.42836403987 | (37.7588223473949, -122.42836403987) | 2 | 4 | 5 | 28862 | 3 | |||
| 115137 | 251332 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 920X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007731 | 2102403 | 37.7532350085981 | -122.416162845847 | (37.7532350085981, -122.416162845847) | 2 | 4 | 7 | 28859 | 19 | |
| 121062 | 46566 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3900 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44701 | 6002455.82917315 | 2102994.91492425 | 37.7545622428397 | -122.434447752947 | (37.7545622428397, -122.434447752947) | 2 | 4 | 5 | 28862 | 22 | |||
| 129925 | 200733 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1462 Oakdale Ave | 3 | unknown : Yard | Tree | Private 2 | 14 | Width 0ft | 6015790.512 | 2094948.0194 | 37.7332150397253 | -122.387771048105 | (37.7332150397253, -122.387771048105) | 10 | 3 | 8 | 58 | 1 | |||
| 132843 | 119662 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
| 133977 | 187556 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 3 | Side Yard : Yard | Tree | Private 2 | 23 | 6011365.57696 | 2088364.56073 | 37.7148921048592 | -122.402606539166 | (37.7148921048592, -122.402606539166) | 10 | 7 | 8 | 309 | 39 | ||||
| 144402 | 187554 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6011368.52295 | 2088357.85007 | 37.7148738432156 | -122.402595884908 | (37.7148738432156, -122.402595884908) | 10 | 7 | 8 | 309 | 39 | ||||
| 149656 | 40810 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 240 Maywood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41757 | 5994290.46519005 | 2095120.08849436 | 37.732473059968 | -122.462114481375 | (37.732473059968, -122.462114481375) | 9 | 8 | 4 | 59 | 40 | |||
| 158555 | 104220 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 642-652 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002365 | 2104465 | 37.7585935873912 | -122.434866988999 | (37.7585935873912, -122.434866988999) | 2 | 4 | 5 | 28862 | 3 | ||||
| 169069 | 112686 | Undocumented 4 | Schinus molle :: California Pepper 91 | 86 STANTON ST | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000281 | 2103909 | 37.7569484049338 | -122.442034474193 | (37.7569484049338, -122.442034474193) | 2 | 4 | 5 | 28862 | 38 | ||||
| 173467 | 35617 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
| 179961 | 138858 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004946.3367 | 2111001.3561 | 37.7766870733429 | -122.426404947187 | (37.7766870733429, -122.426404947187) | 7 | 9 | 11 | 28852 | 10 | |||
| 181076 | 197484 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 99 Lafayette St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6007489.31465 | 2109652.98843 | 37.7731281986314 | -122.417512429769 | (37.7731281986314, -122.417512429769) | 8 | 2 | 9 | 28853 | 19 | |||
| 116094 | 197488 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 29 | Front Yard : Yard | Tree | Private 2 | 9 | 6015374.95978 | 2102473.44448 | 37.753855273025 | -122.389733174866 | (37.753855273025, -122.389733174866) | 10 | 3 | 8 | 28856 | 29 | ||||
| 58030 | 197487 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 28 | Front Yard : Yard | Tree | Private 2 | 11 | 6015378.84744 | 2102468.94598 | 37.7538431366753 | -122.389719416144 | (37.7538431366753, -122.389719416144) | 10 | 3 | 8 | 28856 | 29 | ||||
| 184817 | 197500 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013593.70141 | 2104032.4139 | 37.7580369298728 | -122.396002464843 | (37.7580369298728, -122.396002464843) | 10 | 3 | 8 | 28856 | 29 | ||||
| 128125 | 197491 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900x Carolina St | 23 | Median : Yard | Tree | DPW 1 | 1 | 6012477.42612 | 2103497.47149 | 37.7565059267156 | -122.399825482885 | (37.7565059267156, -122.399825482885) | 10 | 3 | 8 | 28856 | 29 | ||||
| 187579 | 197499 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013595.97387 | 2103991.32166 | 37.7579242259433 | -122.395991726059 | (37.7579242259433, -122.395991726059) | 10 | 3 | 8 | 28856 | 29 | ||||
| 139364 | 29613 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900X Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.63654 | 2090933.64994 | 37.7207977908582 | -122.472609073865 | (37.7207977908582, -122.472609073865) | 9 | 8 | 4 | 64 | 40 | ||
| 188324 | 197498 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6013596.26371 | 2103973.99117 | 37.757876656309 | -122.395989509211 | (37.757876656309, -122.395989509211) | 10 | 3 | 8 | 28856 | 29 | ||||
| 65868 | 197492 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1501 25th St | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6014180.0421 | 2101964.05724 | 37.7523902711102 | -122.393829855665 | (37.7523902711102, -122.393829855665) | 10 | 3 | 8 | 28856 | 1 | ||||
| 888 | 246022 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 625 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998964.2184 | 2108548.4801 | 37.769612128289 | -122.446922226392 | (37.769612128289, -122.446922226392) | 15 | 5 | 11 | 29492 | 9 | |||
| 3391 | 122720 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1023 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008692.81337 | 2118287.13673 | 37.796903132994 | -122.413960264957 | (37.796903132994, -122.413960264957) | 5 | 1 | 10 | 308 | 21 | ||||
| 7042 | 264648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
| 9411 | 33144 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4238 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37370 | 6001375.34520428 | 2103384.04824408 | 37.7555693169237 | -122.438212219782 | (37.7555693169237, -122.438212219782) | 2 | 4 | 5 | 28862 | 3 | |||
| 13603 | 239638 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3689 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003857.31467 | 2103604.80906 | 37.7563163226577 | -122.429644541356 | (37.7563163226577, -122.429644541356) | 2 | 4 | 5 | 28862 | 22 | |||
| 18353 | 97155 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012703.24235 | 2089857.95173 | 37.7190672497343 | -122.398087681509 | (37.7190672497343, -122.398087681509) | 10 | 3 | 8 | 58 | 1 | ||
| 18879 | 19971 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY44 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
| 20090 | 104219 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 642-652 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002365 | 2104465 | 37.7585935873912 | -122.434866988999 | (37.7585935873912, -122.434866988999) | 2 | 4 | 5 | 28862 | 3 | ||||
| 21141 | 51696 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4384@ TEMPLE 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47972 | 6000123.14739521 | 2105790.85513139 | 37.7621065191401 | -122.442715506918 | (37.7621065191401, -122.442715506918) | 15 | 5 | 5 | 28862 | 3 | |||
| 23648 | 239611 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 230 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6007188.60592 | 2098802.03139 | 37.7433170496408 | -122.417783333431 | (37.7433170496408, -122.417783333431) | 2 | 7 | 7 | 28859 | 2 | |||
| 25942 | 197503 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6013488.947 | 2101929.32561 | 37.7522564753565 | -122.396217358746 | (37.7522564753565, -122.396217358746) | 10 | 3 | 8 | 28856 | 1 | |||
| 26202 | 32764 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 274 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | Permit Number 37139 | 5995268.23997636 | 2113729.87048347 | 37.7836270090334 | -122.460081822154 | (37.7836270090334, -122.460081822154) | 11 | 6 | 2 | 54 | 11 | |||
| 29837 | 214153 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 391 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5992476.67943 | 2094212.83068 | 37.7298773579434 | -122.46831913414 | (37.7298773579434, -122.46831913414) | 9 | 8 | 4 | 59 | 40 | |||
| 32012 | 35755 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 6838 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 7 | Permit Number 39022 | 5985827.97682 | 2112563.40957 | 37.7798767531698 | -122.49265512383 | (37.7798767531698, -122.49265512383) | 11 | 6 | 2 | 55 | 26 | ||
| 33437 | 239641 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3637 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004113.74882 | 2103625.61972 | 37.7563879806327 | -122.428759186701 | (37.7563879806327, -122.428759186701) | 2 | 4 | 5 | 28862 | 22 | |||
| 33717 | 99818 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1134 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002486 | 2102282 | 37.7526064609065 | -122.434292449268 | (37.7526064609065, -122.434292449268) | 2 | 4 | 5 | 28862 | 22 | ||||
| 34897 | 136370 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000983.74683 | 2118556.26599 | 37.7972061120278 | -122.440654703763 | (37.7972061120278, -122.440654703763) | 13 | 9 | 1 | 57 | 17 | |||
| 35161 | 239594 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 636 Douglass St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6001191.4238 | 2102669.11785 | 37.7535958285084 | -122.43879704705 | (37.7535958285084, -122.43879704705) | 2 | 4 | 5 | 28862 | 22 | |||
| 35370 | 35616 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
| 36697 | 33682 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 417 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37761 | 6005332.3776 | 2111131.0936 | 37.7770651154691 | -122.425078750067 | (37.7770651154691, -122.425078750067) | 7 | 9 | 11 | 28852 | 10 | ||
| 40288 | 239571 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 254 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 3ft | 6004273.21361 | 2098704.8278 | 37.742885654747 | -122.427857083959 | (37.742885654747, -122.427857083959) | 2 | 7 | 5 | 63 | 22 | |||
| 43385 | 136376 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5999781.6675 | 2117438.62155 | 37.7940688297731 | -122.444733809114 | (37.7940688297731, -122.444733809114) | 13 | 9 | 1 | 57 | 27 | |||
| 44107 | 111384 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 340 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x5 | 6014593.21542 | 2112428.75748 | 37.7811469919725 | -122.393133189548 | (37.7811469919725, -122.393133189548) | 6 | 2 | 9 | 28856 | 6 | |||
| 44499 | 197504 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1798 Revere Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6014086.53204 | 2095170.83461 | 37.733732305508 | -122.393677804596 | (37.733732305508, -122.393677804596) | 10 | 3 | 8 | 58 | 1 |
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) );