trees
614 rows where qSpecies_id = 29
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 68647 | 41746 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
| 68695 | 44311 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 339 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | 1 | Permit Number 43708 | 5998562.918 | 2115355.99866 | 37.7882808758015 | -122.448800711589 | (37.7882808758015, -122.448800711589) | 13 | 6 | 1 | 54 | 31 | ||
| 68740 | 50562 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2365 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2003 12:00:00 AM | Permit Number 47184 | 5998950.78977652 | 2112707.00584702 | 37.7810296062885 | -122.447268015984 | (37.7810296062885, -122.447268015984) | 15 | 5 | 1 | 54 | 16 | |||
| 68958 | 246759 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 6009196.74806 | 2098886.80636 | 37.7436626276403 | -122.410845655606 | (37.7436626276403, -122.410845655606) | 2 | 7 | 7 | 28859 | 2 | ||||
| 69114 | 122462 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1351 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | 1 | 8 | 3 | 56 | 35 | ||||
| 69393 | 184400 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2087 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5982288.7103 | 2100911.824 | 37.747677253327 | -122.504035534429 | (37.747677253327, -122.504035534429) | 1 | 8 | 3 | 29491 | 35 | |||
| 69805 | 179380 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5993077.06779 | 2086425.74691 | 37.7085305695939 | -122.465678009642 | (37.7085305695939, -122.465678009642) | 9 | 8 | 6 | 28861 | 25 | |||
| 69919 | 88224 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1821 Hayes St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51220 | 5999142 | 2110084 | 37.7738384306008 | -122.446417770519 | (37.7738384306008, -122.446417770519) | 15 | 5 | 11 | 29492 | 16 | |||
| 70017 | 240417 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001765.76464 | 2096530.83358 | 37.7367742056673 | -122.436371571893 | (37.7367742056673, -122.436371571893) | 2 | 7 | 5 | 63 | 7 | |||
| 70236 | 136304 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008621.36418 | 2116364.4323 | 37.791619846337 | -122.414071405095 | (37.791619846337, -122.414071405095) | 5 | 1 | 10 | 28857 | 21 | |||
| 70518 | 183218 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3150 Rivera St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983331.3887 | 2100197.9386 | 37.7457783815563 | -122.500377295432 | (37.7457783815563, -122.500377295432) | 1 | 8 | 3 | 29491 | 35 | |||
| 70554 | 240383 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004954.4402 | 2108809.15318 | 37.7706682749432 | -122.426220805247 | (37.7706682749432, -122.426220805247) | 7 | 9 | 5 | 28852 | 10 | |||
| 70662 | 35869 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Boutwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 6 | Permit Number 39080 | 6010666.93779 | 2096840.63562 | 37.7381266097475 | -122.405617981988 | (37.7381266097475, -122.405617981988) | 10 | 3 | 8 | 58 | 1 | |
| 72275 | 48457 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 6 | Permit Number 45824 | 6011919.3472 | 2110495.26684 | 37.7756891719521 | -122.402247516312 | (37.7756891719521, -122.402247516312) | 14 | 2 | 9 | 28853 | 34 | ||
| 72383 | 117792 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3801 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5983744.15991 | 2111021.91382 | 37.7755221883124 | -122.499749889479 | (37.7755221883124, -122.499749889479) | 11 | 6 | 2 | 55 | 26 | |||
| 72495 | 214040 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999932.25708 | 2094051.5429 | 37.729862301496 | -122.442532837136 | (37.729862301496, -122.442532837136) | 9 | 7 | 4 | 63 | 40 | |||
| 72560 | 42675 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007843.31475 | 2118863.44983 | 37.7984377983088 | -122.416940592258 | (37.7984377983088, -122.416940592258) | 5 | 1 | 10 | 28858 | 21 | ||
| 72922 | 136300 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 119 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997500.20956 | 2116012.95103 | 37.7900238635497 | -122.452524916594 | (37.7900238635497, -122.452524916594) | 11 | 6 | 1 | 54 | 31 | |||
| 73040 | 41177 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1555 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 3 | Permit Number 41896 | 6002761.36858 | 2121278.33423 | 37.8047812671151 | -122.434698443483 | (37.8047812671151, -122.434698443483) | 13 | 9 | 1 | 57 | 17 | |
| 75249 | 240426 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 60 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006672.38997 | 2109529.27096 | 37.7727425000967 | -122.420329500315 | (37.7727425000967, -122.420329500315) | 8 | 2 | 9 | 28853 | 19 | |||
| 75438 | 136320 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 North Point St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6010568.43745 | 2122006.80544 | 37.8072215900736 | -122.407732543518 | (37.8072215900736, -122.407732543518) | 3 | 1 | 10 | 308 | 23 | |||
| 75515 | 57281 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2469 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1995 12:00:00 AM | Permit Number 14578 | 5992015.46997478 | 2098642.50003897 | 37.7420134642029 | -122.470236020298 | (37.7420134642029, -122.470236020298) | 1 | 8 | 4 | 29491 | 40 | ||
| 75578 | 41266 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2929 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779089 | 6002905.04785 | 2118704.67592 | 37.7977228301084 | -122.434017142274 | (37.7977228301084, -122.434017142274) | 13 | 9 | 1 | 57 | 17 | ||
| 75848 | 67457 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 709 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52276 | 6002046.91633096 | 2110893.18552424 | 37.7762257387634 | -122.436427136673 | (37.7762257387634, -122.436427136673) | 15 | 5 | 11 | 29492 | 10 | ||
| 76211 | 41759 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
| 76259 | 186237 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984808.8655 | 2103347.0431 | 37.7545115739121 | -122.495500689099 | (37.7545115739121, -122.495500689099) | 1 | 8 | 3 | 56 | 35 | |||
| 76457 | 40784 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 410 Monticello St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | 9 | 8 | 4 | 59 | 40 | ||
| 76531 | 41700 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 135 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42150 | 6002619.11270974 | 2096812.53264581 | 37.7375961375204 | -122.433441302095 | (37.7375961375204, -122.433441302095) | 2 | 7 | 5 | 63 | 7 | ||
| 76954 | 214036 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 262 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992219.26388 | 2089623.39625 | 37.7172610279406 | -122.46887519663 | (37.7172610279406, -122.46887519663) | 9 | 8 | 6 | 64 | 24 | |||
| 76971 | 87871 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2335 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50842 | 6000134.07181 | 2119870.32478 | 37.8007657456038 | -122.443689233072 | (37.8007657456038, -122.443689233072) | 13 | 9 | 1 | 57 | 17 | |
| 77469 | 248239 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 298 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | 6006759.33465 | 2099019.31967 | 37.7438895076886 | -122.419283056374 | (37.7438895076886, -122.419283056374) | 2 | 7 | 7 | 28859 | 2 | ||||
| 77782 | 49152 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46274 | 5991742.04430079 | 2098660.96480908 | 37.7420483520093 | -122.471182775069 | (37.7420483520093, -122.471182775069) | 1 | 8 | 4 | 29491 | 40 | ||
| 78187 | 136309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008608.17525 | 2116456.59832 | 37.7918721709048 | -122.41412356217 | (37.7918721709048, -122.41412356217) | 5 | 1 | 10 | 28857 | 21 | |||
| 78352 | 247984 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 497 Peralta Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6009751.76686 | 2099644.86409 | 37.7457751935767 | -122.408980002136 | (37.7457751935767, -122.408980002136) | 2 | 7 | 7 | 28859 | 2 | ||||
| 79265 | 240420 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001790.09859 | 2096478.24715 | 37.7366311981596 | -122.436283676644 | (37.7366311981596, -122.436283676644) | 2 | 7 | 5 | 63 | 7 | |||
| 79723 | 35102 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 778 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767512 | 6001912.66160072 | 2089308.81779253 | 37.7169525342318 | -122.435347237927 | (37.7169525342318, -122.435347237927) | 9 | 7 | 6 | 28861 | 5 | |
| 79828 | 37976 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
| 79841 | 214044 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 119 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999274.87025 | 2093768.22401 | 37.7290468799003 | -122.444785134325 | (37.7290468799003, -122.444785134325) | 9 | 7 | 4 | 28861 | 40 | |||
| 80016 | 240399 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1636 Diamond St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6002005.77197 | 2099212.90242 | 37.7441521762959 | -122.435733596422 | (37.7441521762959, -122.435733596422) | 2 | 7 | 5 | 63 | 22 | |||
| 80073 | 214015 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1326 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5992108.78084 | 2106403.01661 | 37.763327220596 | -122.470478452218 | (37.763327220596, -122.470478452218) | 1 | 8 | 11 | 56 | 12 | |||
| 80217 | 42941 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 90 14TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | 10 | Permit Number 42835 | 6008035 | 2107992 | 37.768598204142 | -122.415507210488 | (37.768598204142, -122.415507210488) | 8 | 4 | 7 | 28853 | 19 | ||
| 80229 | 48906 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
| 80392 | 124542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992469.9646 | 2111331.12947 | 37.776879377114 | -122.46958801958 | (37.776879377114, -122.46958801958) | 11 | 6 | 2 | 54 | 11 | |||
| 80398 | 82767 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 398 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.7706164898271 | -122.412590100264 | (37.7706164898271, -122.412590100264) | 8 | 2 | 9 | 28853 | 19 | ||
| 80550 | 246767 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 11 | Front Yard : Yard | Tree | Private 2 | 13 | 6009322.26711 | 2098890.11567 | 37.7436787515713 | -122.410411873024 | (37.7436787515713, -122.410411873024) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80581 | 48903 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
| 80778 | 200055 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014871.4407 | 2094140.9637 | 37.7309480732984 | -122.390892168964 | (37.7309480732984, -122.390892168964) | 10 | 3 | 8 | 58 | 1 | |||
| 81022 | 102592 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 124 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 04/17/2010 12:00:00 AM | 3 | 6x6 | 6000765 | 2094428 | 37.7309433983829 | -122.439680933747 | (37.7309433983829, -122.439680933747) | 9 | 7 | 4 | 63 | 40 | |
| 81683 | 124546 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992441.4203 | 2111328.77742 | 37.7768712692618 | -122.469686590816 | (37.7768712692618, -122.469686590816) | 11 | 6 | 2 | 54 | 11 | |||
| 81719 | 8100 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 765 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004193.95704 | 2111472.64562 | 37.7779385589247 | -122.429041260431 | (37.7779385589247, -122.429041260431) | 7 | 9 | 11 | 28852 | 10 | ||
| 82091 | 33453 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 343 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37554 | 6006165.48085512 | 2098035.43238588 | 37.7411545114342 | -122.421266615711 | (37.7411545114342, -122.421266615711) | 2 | 7 | 7 | 28859 | 2 | |||
| 82279 | 47718 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45513 | 6003399.03676128 | 2096258.54340471 | 37.7361192276447 | -122.430705213698 | (37.7361192276447, -122.430705213698) | 2 | 7 | 5 | 63 | 7 | ||
| 82746 | 32576 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1366 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37050 | 5986201.05883385 | 2105941.9596711 | 37.7617179230551 | -122.49087711798 | (37.7617179230551, -122.49087711798) | 1 | 8 | 3 | 56 | 35 | |
| 82837 | 58515 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1465 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2004 12:00:00 AM | Permit Number 30484 | 5998691.7005411 | 2108280.83754266 | 37.7688616770507 | -122.447845581015 | (37.7688616770507, -122.447845581015) | 15 | 5 | 11 | 29492 | 9 | ||
| 83156 | 136302 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3362 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998728.18247 | 2115610.02714 | 37.788987820287 | -122.448247225637 | (37.788987820287, -122.448247225637) | 13 | 6 | 1 | 54 | 31 | |||
| 83782 | 69150 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 4 | Permit Number 33185 | 5984181.23627049 | 2098183.21295551 | 37.7402963417492 | -122.497289988005 | (37.7402963417492, -122.497289988005) | 1 | 8 | 3 | 29491 | 35 | |
| 84430 | 88271 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 142 Belvedere St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51257 | 5998321.8 | 2107947.7 | 37.7679258166536 | -122.449101033169 | (37.7679258166536, -122.449101033169) | 15 | 5 | 11 | 29492 | 9 | |||
| 85029 | 47745 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4201 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982377.51547 | 2113061.47559 | 37.7810419369254 | -122.50462850954 | (37.7810419369254, -122.50462850954) | 11 | 6 | 2 | 55 | 26 | |
| 85562 | 86997 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 248 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49939 | 6004323 | 2098701 | 37.7428779608266 | -122.42768466378 | (37.7428779608266, -122.42768466378) | 2 | 7 | 5 | 63 | 22 | ||
| 86413 | 69147 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2474 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50209 | 5983357.92346724 | 2098305.86052221 | 37.7405848112735 | -122.500145694224 | (37.7405848112735, -122.500145694224) | 1 | 8 | 3 | 29491 | 35 | |
| 86576 | 48460 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 102 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45825 | 6000209.55112 | 2088191.07942 | 37.7137866078303 | -122.44115390124 | (37.7137866078303, -122.44115390124) | 9 | 7 | 6 | 28861 | 5 | ||
| 87071 | 122288 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990072.17969 | 2111319.40231 | 37.7767083057208 | -122.477881737882 | (37.7767083057208, -122.477881737882) | 11 | 6 | 2 | 55 | 26 | |||
| 87337 | 95740 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 61 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767486 | 6004943.22126 | 2091523.89765 | 37.7232063048111 | -122.425029567755 | (37.7232063048111, -122.425029567755) | 9 | 7 | 6 | 28861 | 5 |
| 87519 | 112589 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009004 | 2110266 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | 8 | 2 | 9 | 28853 | 34 | |||||
| 87772 | 32524 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 862 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 4 | Permit Number 37026 | 6007537.57048 | 2095302.13495 | 37.7337267377908 | -122.416328859904 | (37.7337267377908, -122.416328859904) | 2 | 7 | 7 | 28859 | 2 | |
| 88325 | 32 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 753 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2016 06:10:00 AM | 3 | 3X3 | 6003820.62164 | 2107707.01694 | 37.7675779249973 | -122.43006406444 | (37.7675779249973, -122.43006406444) | 7 | 9 | 5 | 28862 | 3 | ||
| 88664 | 38062 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1802 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.7862031012974 | -122.439957367186 | (37.7862031012974, -122.439957367186) | 13 | 6 | 1 | 29490 | 27 | ||
| 89184 | 136306 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008615.34001 | 2116402.44898 | 37.7917238924876 | -122.414094939449 | (37.7917238924876, -122.414094939449) | 5 | 1 | 10 | 28857 | 21 | |||
| 89232 | 40031 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1656 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41273 | 6014957.20136248 | 2095924.63791994 | 37.7358504391775 | -122.390720277971 | (37.7358504391775, -122.390720277971) | 10 | 3 | 8 | 58 | 1 | ||
| 89675 | 23598 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 200X Vasquez Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.461921227095 | (37.7430347013579, -122.461921227095) | 1 | 8 | 4 | 59 | 40 | |||
| 89860 | 207052 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1266 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993336.08558 | 2106823.92199 | 37.7645538041289 | -122.466264232709 | (37.7645538041289, -122.466264232709) | 11 | 8 | 11 | 56 | 12 | |||
| 90134 | 214016 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1310 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992104.55451 | 2106488.09353 | 37.7635605748926 | -122.470499266141 | (37.7635605748926, -122.470499266141) | 1 | 8 | 11 | 56 | 12 | |||
| 90484 | 214026 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 124 Baden St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6000776.43659 | 2094502.29985 | 37.7311480595383 | -122.439646720232 | (37.7311480595383, -122.439646720232) | 9 | 7 | 4 | 63 | 40 | |||
| 91621 | 136312 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008787.57627 | 2116642.7504 | 37.7923933739042 | -122.413516003555 | (37.7923933739042, -122.413516003555) | 5 | 1 | 10 | 28857 | 21 | |||
| 91849 | 136305 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008618.49447 | 2116385.90895 | 37.7916786547855 | -122.414082854345 | (37.7916786547855, -122.414082854345) | 5 | 1 | 10 | 28857 | 21 | |||
| 92008 | 94657 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765 | 2094410 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) | 9 | 7 | 4 | 63 | 40 |
| 92149 | 87934 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3600 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309 | 2100840 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | 1 | 8 | 3 | 29491 | 35 | ||
| 93551 | 52639 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1634 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2006 12:00:00 AM | 3 | Permit Number 48720 | 5981612.27437325 | 2103952.63979264 | 37.7559866741692 | -122.506600058306 | (37.7559866741692, -122.506600058306) | 1 | 8 | 3 | 56 | 35 | |
| 94034 | 240379 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 87 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008087.13667 | 2107952.681 | 37.7684931737476 | -122.41532408966 | (37.7684931737476, -122.41532408966) | 8 | 4 | 7 | 28853 | 19 | |||
| 94833 | 214031 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 119 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997420.89454 | 2093944.4368 | 37.7294247417474 | -122.451207143595 | (37.7294247417474, -122.451207143595) | 9 | 7 | 4 | 28861 | 40 | |||
| 95168 | 69021 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2095 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | Permit Number 33025 | 5981665.37116425 | 2100840.03174895 | 37.7474434561007 | -122.506185646516 | (37.7474434561007, -122.506185646516) | 1 | 8 | 3 | 29491 | 35 | ||
| 95310 | 42677 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42702 | 6007869.31291 | 2118866.95146 | 37.7984488752774 | -122.416850878593 | (37.7984488752774, -122.416850878593) | 5 | 1 | 10 | 28858 | 21 | ||
| 95401 | 112529 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
| 95613 | 112546 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 464 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011322 | 2118712 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | 3 | 1 | 10 | 308 | 23 | |||
| 95948 | 197335 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1512 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014078.36763 | 2102008.61135 | 37.7525069563416 | -122.394184584264 | (37.7525069563416, -122.394184584264) | 10 | 3 | 8 | 28856 | 29 | |||
| 96775 | 124545 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992450.31032 | 2111329.62958 | 37.776874122883 | -122.46965589987 | (37.776874122883, -122.46965589987) | 11 | 6 | 2 | 54 | 11 | |||
| 96947 | 106210 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 585X Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774310 | 6010773.37918 | 2115862.19303 | 37.7903614528559 | -122.406590009715 | (37.7903614528559, -122.406590009715) | 5 | 1 | 10 | 28857 | 6 | |
| 97314 | 197347 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1245 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009016.84079 | 2110503.78617 | 37.7755501205886 | -122.41228864573 | (37.7755501205886, -122.41228864573) | 8 | 2 | 9 | 28853 | 34 | |||
| 97661 | 214013 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1483 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992099.86454 | 2105356.08672 | 37.7604521122998 | -122.470433040059 | (37.7604521122998, -122.470433040059) | 1 | 8 | 4 | 56 | 12 | |||
| 97806 | 207057 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 340 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991827.84816 | 2097768.26997 | 37.7396022020835 | -122.470821084031 | (37.7396022020835, -122.470821084031) | 1 | 8 | 4 | 59 | 40 | |||
| 97817 | 240394 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 27 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001499.24152 | 2098615.40839 | 37.742482813337 | -122.437442286753 | (37.742482813337, -122.437442286753) | 2 | 7 | 5 | 63 | 7 | |||
| 98374 | 101956 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 510X Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6x6 | 6012441.7 | 2108540.8 | 37.7703517934984 | -122.400303251175 | (37.7703517934984, -122.400303251175) | 14 | 2 | 8 | 28856 | 20 | |||
| 98469 | 22550 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 23 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2008 12:00:00 AM | 4 | 2x3 | 6001475.7294271 | 2098645.6307199 | 37.7425644600069 | -122.437525748228 | (37.7425644600069, -122.437525748228) | 2 | 7 | 5 | 63 | 7 | ||
| 98564 | 38030 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1400 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | 1 | 8 | 4 | 29491 | 40 | |||
| 98750 | 38059 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1802 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.7862031012974 | -122.439957367186 | (37.7862031012974, -122.439957367186) | 13 | 6 | 1 | 29490 | 27 | ||
| 99470 | 38034 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 71 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40237 | 5993126.63617522 | 2098605.576855 | 37.7419762612493 | -122.466391311334 | (37.7419762612493, -122.466391311334) | 1 | 8 | 4 | 59 | 40 | ||
| 100100 | 136315 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 895 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009067.06929 | 2119033.92208 | 37.7989746333364 | -122.41271806751 | (37.7989746333364, -122.41271806751) | 3 | 1 | 10 | 308 | 21 | |||
| 100145 | 240416 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 12 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003644.58951 | 2098299.35585 | 37.7417367402568 | -122.430001772769 | (37.7417367402568, -122.430001772769) | 2 | 7 | 5 | 63 | 7 | |||
| 100225 | 41749 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
| 100414 | 87936 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3600 Quintara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309 | 2100840 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | 1 | 8 | 3 | 29491 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );