trees
614 rows where qSpecies_id = 29 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2794 | 254529 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 421 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769845 | ||||||||||
| 4016 | 52794 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
| 5667 | 52792 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
| 11431 | 35742 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
| 13707 | 35743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
| 13860 | 52793 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
| 5774 | 112542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.92574 | 37.7982159634572 | -122.40460495956 | (37.7982159634572, -122.40460495956) | 3 | 1 | 10 | 308 | 23 | ||
| 9509 | 136313 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008832.97743 | 2116650.20878 | 37.7924164019518 | -122.413359441492 | (37.7924164019518, -122.413359441492) | 5 | 1 | 10 | 28857 | 21 | |||
| 13641 | 136307 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008614.23308 | 2116420.22843 | 37.7917726483359 | -122.41410002782 | (37.7917726483359, -122.41410002782) | 5 | 1 | 10 | 28857 | 21 | |||
| 22588 | 44207 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 701 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2000 12:00:00 AM | Permit Number 43655 | 6009221.06713893 | 2115299.96241651 | 37.7887307349007 | -122.411921176175 | (37.7887307349007, -122.411921176175) | 5 | 1 | 10 | 28852 | 21 | ||
| 23194 | 136319 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 North Point St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6010537.58998 | 2122003.14861 | 37.8072098224406 | -122.407839040359 | (37.8072098224406, -122.407839040359) | 3 | 1 | 10 | 308 | 23 | |||
| 36318 | 112537 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011527.0722 | 2118728.84616 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | 3 | 1 | 10 | 308 | 23 | |||
| 38756 | 41743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 6 | 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 | ||
| 40164 | 136317 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 954 Vallejo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008931.36114 | 2118725.70113 | 37.7981207171523 | -122.413165857925 | (37.7981207171523, -122.413165857925) | 3 | 1 | 10 | 308 | 21 | |||
| 45998 | 112547 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 462 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011324 | 2118723 | 37.798247331278 | -122.404886391926 | (37.798247331278, -122.404886391926) | 3 | 1 | 10 | 308 | 23 | ||||
| 49381 | 97195 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 390X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 3 | Permit Number 775228 | 6011720.2 | 2118742.9 | 37.7983241100995 | -122.403516814582 | (37.7983241100995, -122.403516814582) | 3 | 1 | 10 | 308 | 23 | ||
| 49755 | 112541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | 3 | 1 | 10 | 308 | 23 | |||
| 51701 | 98673 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
| 52120 | 136324 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011401 | 2118734 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | 3 | 1 | 10 | 308 | 23 | |||
| 52593 | 98672 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
| 53841 | 136322 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | 6011695.90155 | 2118747.3363 | 37.7983349338553 | -122.403601207338 | (37.7983349338553, -122.403601207338) | 3 | 1 | 10 | 308 | 23 | ||
| 58873 | 41744 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 10 | 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 | ||
| 59349 | 136311 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008756.30767 | 2116638.98455 | 37.7923812780273 | -122.413623927626 | (37.7923812780273, -122.413623927626) | 5 | 1 | 10 | 28857 | 21 | |||
| 59848 | 112528 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
| 65177 | 136326 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 463 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011288.49181 | 2118628.67213 | 37.79798634496 | -122.405002616378 | (37.79798634496, -122.405002616378) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 104544 | 112525 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 471 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011292 | 2118586 | 37.7978693737352 | -122.404987470864 | (37.7978693737352, -122.404987470864) | 3 | 1 | 10 | 308 | 23 | ||||
| 108733 | 112527 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
| 115176 | 136327 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 463 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011305.85301 | 2118630.68117 | 37.7979928317715 | -122.404942682854 | (37.7979928317715, -122.404942682854) | 3 | 1 | 10 | 308 | 23 | |||
| 115957 | 112538 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2016 12:00:00 AM | 2 | 3x3 | 6011488.50983 | 2118723.01839 | 37.7982565759239 | -122.404317136927 | (37.7982565759239, -122.404317136927) | 3 | 1 | 10 | 308 | 23 | ||
| 123940 | 112530 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 07:26:00 AM | 3 | 3x3 | 6011409.86951 | 2118646.99301 | 37.7980434339179 | -122.404583902832 | (37.7980434339179, -122.404583902832) | 3 | 1 | 10 | 308 | 23 | ||
| 124867 | 41751 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 1 | 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 | ||
| 126649 | 136328 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 447 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6011327.03299 | 2118633.79421 | 37.7980025633245 | -122.404869612942 | (37.7980025633245, -122.404869612942) | 3 | 1 | 10 | 308 | 23 | |||
| 127392 | 136303 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008623.1195 | 2116351.39928 | 37.7915841594399 | -122.414064409258 | (37.7915841594399, -122.414064409258) | 5 | 1 | 10 | 28857 | 21 | |||
| 131847 | 112540 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 432 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011444.64707 | 2118714.34063 | 37.7982302977556 | -122.404468304876 | (37.7982302977556, -122.404468304876) | 3 | 1 | 10 | 308 | 23 | |||
| 133154 | 136325 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 464 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011322 | 2118712 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | 3 | 1 | 10 | 308 | 23 | |||
| 134101 | 41747 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 5 | 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 | ||
| 135679 | 136330 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 447 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6011365.83057 | 2118639.85606 | 37.7980213762507 | -122.40473578842 | (37.7980213762507, -122.40473578842) | 3 | 1 | 10 | 308 | 23 | |||
| 138587 | 41752 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 8 | 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 | ||
| 138670 | 74680 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 493 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2013 12:00:00 AM | 3x3 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.7979605016561 | -122.405348925503 | (37.7979605016561, -122.405348925503) | 3 | 1 | 10 | 308 | 23 | ||
| 141151 | 41755 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1630 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 5 | Permit Number 42184 | 6008378.01882 | 2118113.9596 | 37.7964099467207 | -122.415037267971 | (37.7964099467207, -122.415037267971) | 5 | 1 | 10 | 308 | 21 | ||
| 143437 | 136314 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 107 Bernard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | 5 | 1 | 10 | 28858 | 21 | |||
| 145308 | 41748 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 4 | 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 | ||
| 145993 | 112531 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011430 | 2118629 | 37.7979951544919 | -122.404512977901 | (37.7979951544919, -122.404512977901) | 3 | 1 | 10 | 308 | 23 | ||||
| 147403 | 98671 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
| 147857 | 41750 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 2 | 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 | ||
| 148706 | 41756 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1630 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 9 | Permit Number 42184 | 6008372.67518 | 2118139.66101 | 37.7964802161469 | -122.41505757827 | (37.7964802161469, -122.41505757827) | 5 | 1 | 10 | 308 | 21 | ||
| 154166 | 136329 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 447 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6011341.08824 | 2118636.57968 | 37.7980109971731 | -122.404821173685 | (37.7980109971731, -122.404821173685) | 3 | 1 | 10 | 308 | 23 | |||
| 154298 | 187666 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 107 Bernard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | 5 | 1 | 10 | 28858 | 21 | ||||
| 162832 | 42678 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42702 | 6007821.24509 | 2118860.5405 | 37.7984285685682 | -122.417016754032 | (37.7984285685682, -122.417016754032) | 5 | 1 | 10 | 28858 | 21 | |
| 167630 | 136323 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | Permit Number 775228 | 6011675.19116 | 2118742.88561 | 37.7983215564568 | -122.403672558643 | (37.7983215564568, -122.403672558643) | 3 | 1 | 10 | 308 | 23 | |
| 168528 | 136308 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008610.17492 | 2116437.51898 | 37.7918198960214 | -122.414115292883 | (37.7918198960214, -122.414115292883) | 5 | 1 | 10 | 28857 | 21 | |||
| 173586 | 136310 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008741.78085 | 2116636.60472 | 37.7923739278622 | -122.413674022565 | (37.7923739278622, -122.413674022565) | 5 | 1 | 10 | 28857 | 21 | |||
| 177388 | 136316 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 895 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009084.75499 | 2119036.14381 | 37.798981726274 | -122.412657026025 | (37.798981726274, -122.412657026025) | 3 | 1 | 10 | 308 | 21 | |||
| 178687 | 112543 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011394 | 2118786 | 37.798424226523 | -122.404648607058 | (37.798424226523, -122.404648607058) | 3 | 1 | 10 | 308 | 23 | ||||
| 178825 | 42676 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007858.06857 | 2118865.16486 | 37.7984433372469 | -122.416889660934 | (37.7984433372469, -122.416889660934) | 5 | 1 | 10 | 28858 | 21 | ||
| 178870 | 112526 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 471 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011292 | 2118586 | 37.7978693737352 | -122.404987470864 | (37.7978693737352, -122.404987470864) | 3 | 1 | 10 | 308 | 23 | ||||
| 179944 | 112532 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011441.2715 | 2118651.07916 | 37.7980564084299 | -122.404475530047 | (37.7980564084299, -122.404475530047) | 3 | 1 | 10 | 308 | 23 | |||
| 180058 | 98670 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
| 180060 | 136318 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2431 Jones St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6007955.59027 | 2120758.45752 | 37.8036473290331 | -122.416686400679 | (37.8036473290331, -122.416686400679) | 5 | 1 | 1 | 308 | 32 | |||
| 183798 | 42698 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1659 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | Permit Number 45472 | 6009187.38661424 | 2118931.29098858 | 37.798699585947 | -122.412294470142 | (37.798699585947, -122.412294470142) | 3 | 1 | 10 | 308 | 21 | ||
| 189923 | 41745 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 9 | 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 | ||
| 190698 | 136321 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Francisco St | 13 | Front Yard : Yard | Tree | Private 2 | 7 | 6010437.78302 | 2121369.6786 | 37.8054648831642 | -122.408139740375 | (37.8054648831642, -122.408139740375) | 3 | 1 | 10 | 308 | 23 | ||||
| 192914 | 89014 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2147 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2008 12:00:00 AM | 3X3 | Permit Number 51763 | 6008963 | 2120596 | 37.803257869178 | -122.413188701365 | (37.803257869178, -122.413188701365) | 3 | 1 | 10 | 308 | 23 | |||
| 193050 | 112539 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | 3 | 1 | 10 | 308 | 23 | ||
| 7825 | 197345 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.412680506426 | (37.7752450102959, -122.412680506426) | 8 | 2 | 9 | 28853 | 34 | |||
| 12760 | 32019 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 900 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.400057399946 | (37.7704413522571, -122.400057399946) | 14 | 2 | 8 | 28856 | 20 | |||
| 13087 | 103083 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.400211142746 | (37.785359006363, -122.400211142746) | 12 | 2 | 9 | 28855 | 6 | |||
| 14362 | 197348 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | 8 | 2 | 9 | 28853 | 34 | |||
| 21604 | 48459 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.7756213756527 | -122.40216174349 | (37.7756213756527, -122.40216174349) | 14 | 2 | 9 | 28853 | 34 | ||
| 27362 | 197344 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012519.57167 | 2113947.09446 | 37.7852005799736 | -122.400413690752 | (37.7852005799736, -122.400413690752) | 12 | 2 | 9 | 28855 | 6 | |||
| 46975 | 82884 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 398 11th St | 1 | 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 | ||
| 49609 | 48458 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 3 | Permit Number 45824 | 6011932.18219 | 2110480.19141 | 37.7756484947135 | -122.402202056493 | (37.7756484947135, -122.402202056493) | 14 | 2 | 9 | 28853 | 34 | ||
| 58885 | 197342 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012547.87891 | 2113973.86639 | 37.785275667977 | -122.400317636871 | (37.785275667977, -122.400317636871) | 12 | 2 | 9 | 28855 | 6 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||||
| 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 | |||
| 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 | |||
| 110728 | 197350 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 719 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009290.40599 | 2110497.98819 | 37.7755495477154 | -122.411341904202 | (37.7755495477154, -122.411341904202) | 8 | 2 | 9 | 28853 | 34 | |||
| 119382 | 112588 | 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 | |||||
| 132076 | 197343 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012532.19574 | 2113959.45979 | 37.7852352362655 | -122.400370883928 | (37.7852352362655, -122.400370883928) | 12 | 2 | 9 | 28855 | 6 | |||
| 132392 | 30659 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 54 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34592 | 6007591.74325 | 2109572.72569 | 37.7729135790239 | -122.41715242667 | (37.7729135790239, -122.41715242667) | 8 | 2 | 9 | 28853 | 19 |
| 157180 | 41736 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1675 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42175 | 6007516.69169836 | 2108778.794217 | 37.7707294087229 | -122.417355765748 | (37.7707294087229, -122.417355765748) | 8 | 2 | 9 | 28853 | 19 | ||
| 157735 | 197346 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1245 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008998.58265 | 2110487.32292 | 37.7755038918289 | -122.412350641372 | (37.7755038918289, -122.412350641372) | 8 | 2 | 9 | 28853 | 34 | |||
| 165949 | 48456 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 7 | Permit Number 45824 | 6011955.48397 | 2110455.52014 | 37.7755820536976 | -122.402119714552 | (37.7755820536976, -122.402119714552) | 14 | 2 | 9 | 28853 | 34 |
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) );