trees
1,914 rows where qSpecies_id = 45 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183645 | 109178 | Permitted Site 7 | :: 45 | 2832 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2015 12:00:00 AM | 3 | 6001592.1 | 2118171.6 | 37.7961845444049 | -122.438522078694 | (37.7961845444049, -122.438522078694) | 13 | 9 | 1 | 57 | 17 | |||
| 138288 | 109261 | Permitted Site 7 | :: 45 | 3338X Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | 1 | 8 | 3 | 29491 | 35 | |||
| 74354 | 109262 | Permitted Site 7 | :: 45 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | 1 | 8 | 3 | 29491 | 35 | |||
| 110859 | 109342 | DPW Maintained 1 | :: 45 | 3211 Baker St | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 82433 | 109343 | DPW Maintained 1 | :: 45 | 3211 Baker St | 2 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 71605 | 109344 | DPW Maintained 1 | :: 45 | 3211 Baker St | 3 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 79210 | 109345 | DPW Maintained 1 | :: 45 | 3211 Baker St | 4 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 166540 | 109364 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 154649 | 109365 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 66039 | 109366 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 45114 | 109367 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 152658 | 109368 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 388 | 109369 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
| 143343 | 109370 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 13x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
| 113988 | 109518 | Undocumented 4 | :: 45 | 4801X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999644.57626 | 2104777.09851 | 37.7592957011711 | -122.444297841065 | (37.7592957011711, -122.444297841065) | 2 | 4 | 5 | 28862 | 3 | |||||
| 51980 | 109520 | Undocumented 4 | :: 45 | 4801X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999644.57626 | 2104777.09851 | 37.7592957011711 | -122.444297841065 | (37.7592957011711, -122.444297841065) | 2 | 4 | 5 | 28862 | 3 | |||||
| 78553 | 109534 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 64175 | 109535 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 123221 | 109536 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 174987 | 109571 | Permitted Site 7 | :: 45 | 400 Brazil Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003029.6 | 2091527.8 | 37.7231087370031 | -122.431644859747 | (37.7231087370031, -122.431644859747) | 9 | 7 | 6 | 28861 | 5 | |||
| 14351 | 109754 | Permitted Site 7 | :: 45 | 601 Steiner St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1x12 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | ||||
| 112455 | 109755 | DPW Maintained 1 | :: 45 | 601 Steiner St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1x12 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | ||||
| 114988 | 109756 | DPW Maintained 1 | :: 45 | 601 Steiner St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1x12 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | ||||
| 1416 | 109762 | DPW Maintained 1 | :: 45 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.7865004107291 | -122.438547564751 | (37.7865004107291, -122.438547564751) | 13 | 6 | 1 | 29490 | 27 | ||||
| 157539 | 109767 | DPW Maintained 1 | :: 45 | 1801 Scott St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 11.75x1.5+3.6x3.6 | 6001511.7 | 2114646.3 | 37.7865004107291 | -122.438547564751 | (37.7865004107291, -122.438547564751) | 13 | 6 | 1 | 29490 | 27 | ||||
| 158438 | 109768 | DPW Maintained 1 | :: 45 | 2502X Bush St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x13 | 6001313.62368 | 2114572.17699 | 37.7862856185892 | -122.439227543381 | (37.7862856185892, -122.439227543381) | 13 | 6 | 1 | 29490 | 27 | ||||
| 59373 | 109769 | DPW Maintained 1 | :: 45 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.7862856185892 | -122.439227543381 | (37.7862856185892, -122.439227543381) | 13 | 6 | 1 | 29490 | 27 | ||||
| 127804 | 109831 | DPW Maintained 1 | :: 45 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | 9 | 7 | 4 | 28861 | 40 | ||||
| 45738 | 109978 | Undocumented 4 | :: 45 | 75 Escondido Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986097 | 2096084.1 | 37.73464482809 | -122.490511739576 | (37.73464482809, -122.490511739576) | 1 | 8 | 3 | 64 | 35 | ||||
| 88721 | 110024 | Undocumented 4 | :: 45 | 432X Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997770.4 | 2107507.4 | 37.7666853128725 | -122.450976500583 | (37.7666853128725, -122.450976500583) | 15 | 5 | 11 | 29492 | 9 | |||||
| 45772 | 110159 | Permitted Site 7 | :: 45 | 1041 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 55966 | 6008597.3 | 2118278.8 | 37.7968748776387 | -122.414290174718 | (37.7968748776387, -122.414290174718) | 5 | 1 | 10 | 308 | 21 | |||
| 55781 | 110246 | DPW Maintained 1 | :: 45 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/01/2015 12:00:00 AM | 3 | 1.5x12 | 5987540.7 | 2103643.4 | 37.7554848751362 | -122.486075162345 | (37.7554848751362, -122.486075162345) | 1 | 8 | 3 | 56 | 35 | ||
| 141783 | 110320 | Property Tree 8 | :: 45 | 9 Imperial Aly | Back Yard : Yard | Landscaping | Private 2 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | 13 | 9 | 1 | 57 | 17 | ||||||
| 152691 | 111758 | DPW Maintained 1 | :: 45 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 06/23/2015 12:00:00 AM | 3 | 6x6 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.507284463143 | (37.7634442160317, -122.507284463143) | 1 | 8 | 3 | 56 | 35 | ||
| 31704 | 111759 | DPW Maintained 1 | :: 45 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard | Landscaping | Private 2 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.507284463143 | (37.7634442160317, -122.507284463143) | 1 | 8 | 3 | 56 | 35 | ||
| 54145 | 111850 | Undocumented 4 | :: 45 | 245 STATES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000624 | 2106601 | 37.764359516173 | -122.441041378606 | (37.764359516173, -122.441041378606) | 15 | 5 | 5 | 28862 | 3 | |||
| 43088 | 112378 | Significant Tree 6 | :: 45 | 1850 19TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5990394 | 2102783 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | 1 | 8 | 4 | 56 | 12 | |||
| 15400 | 112605 | DPW Maintained 1 | :: 45 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/10/2015 12:00:00 AM | 5.6x12 | 6000465 | 2110329.2 | 37.7745871625182 | -122.441858914128 | (37.7745871625182, -122.441858914128) | 15 | 5 | 11 | 29492 | 16 | |||
| 65380 | 113382 | Undocumented 4 | :: 45 | 146 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5994461 | 2101055 | 37.7487786662853 | -122.461955122224 | (37.7487786662853, -122.461955122224) | 1 | 8 | 4 | 29491 | 40 | |||
| 120615 | 113719 | Undocumented 4 | :: 45 | 1705 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000536 | 2114563 | 37.7862161402131 | -122.441917253951 | (37.7862161402131, -122.441917253951) | 13 | 6 | 1 | 29490 | 27 | ||||
| 179 | 113995 | DPW Maintained 1 | :: 45 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692457 | -122.446411428366 | (37.789931692457, -122.446411428366) | 13 | 6 | 1 | 29490 | 31 | |||
| 122321 | 113996 | DPW Maintained 1 | :: 45 | 58 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989321.8 | 2114884.9 | 37.7864545841357 | -122.480738581989 | (37.7864545841357, -122.480738581989) | 11 | 6 | 1 | 55 | 33 | |||||
| 56508 | 113997 | DPW Maintained 1 | :: 45 | 58 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989321.8 | 2114884.9 | 37.7864545841357 | -122.480738581989 | (37.7864545841357, -122.480738581989) | 11 | 6 | 1 | 55 | 33 | |||||
| 26512 | 114567 | Permitted Site 7 | :: 45 | 1930 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/2015 12:00:00 AM | 3x3 | 6008702.7 | 2119505.5 | 37.8002490116896 | -122.414012289596 | (37.8002490116896, -122.414012289596) | 3 | 1 | 10 | 308 | 32 | ||
| 9359 | 114615 | Undocumented 4 | :: 45 | 2400X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 141089 | 114618 | Undocumented 4 | :: 45 | 2400X Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 55571 | 114619 | Undocumented 4 | :: 45 | 2400X Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 122809 | 114620 | Undocumented 4 | :: 45 | 2400X Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 427 | 114621 | Undocumented 4 | :: 45 | 2400X Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 108003 | 114622 | Undocumented 4 | :: 45 | 2400X Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 47967 | 114623 | Undocumented 4 | :: 45 | 2400X Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 23428 | 114625 | Undocumented 4 | :: 45 | 2400X Post St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 52408 | 114626 | Undocumented 4 | :: 45 | 2400X Post St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 65595 | 114627 | Undocumented 4 | :: 45 | 2400X Post St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 72867 | 114628 | Undocumented 4 | :: 45 | 2400X Post St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 15784 | 114629 | Undocumented 4 | :: 45 | 2400X Post St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 10564 | 114630 | Undocumented 4 | :: 45 | 2400X Post St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
| 140500 | 114670 | Undocumented 4 | :: 45 | 176X Peralta Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | 2 | 7 | 7 | 28859 | 2 | |||||
| 110899 | 114725 | Significant Tree 6 | :: 45 | 520 Townsend St | 1 | Front Yard : Yard | Tree | Private 2 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.400146236912 | (37.7731959986981, -122.400146236912) | 14 | 2 | 9 | 28853 | 34 | |||||
| 8301 | 114726 | Significant Tree 6 | :: 45 | 520 Townsend St | 2 | Front Yard : Yard | Tree | Private 2 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.400146236912 | (37.7731959986981, -122.400146236912) | 14 | 2 | 9 | 28853 | 34 | |||||
| 77837 | 114785 | Permitted Site 7 | :: 45 | 2459 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2015 12:00:00 AM | 6000398.9 | 2113706 | 37.7838552262656 | -122.442330036457 | (37.7838552262656, -122.442330036457) | 15 | 6 | 1 | 29490 | 13 | ||||
| 62738 | 115002 | Undocumented 4 | :: 45 | 46 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993155.2 | 2098864.2 | 37.7426880232123 | -122.46631133897 | (37.7426880232123, -122.46631133897) | 1 | 8 | 4 | 59 | 40 | |||||
| 163577 | 115013 | Permitted Site 7 | :: 45 | 2493 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 5999602.09209 | 2119817.77431 | 37.8005911003042 | -122.445526316815 | (37.8005911003042, -122.445526316815) | 13 | 9 | 1 | 57 | 17 | ||||
| 18399 | 115024 | Permitted Site 7 | :: 45 | 2500 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 5983385.7 | 2098079 | 37.7399635443515 | -122.500032889381 | (37.7399635443515, -122.500032889381) | 1 | 8 | 3 | 29491 | 35 | ||||
| 95951 | 115061 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 162453 | 115062 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 177789 | 115063 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 182182 | 115064 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 150847 | 115065 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 115561 | 115066 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 375 | 115067 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 57503 | 115068 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 154502 | 115069 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 96682 | 115070 | Significant Tree 6 | :: 45 | 401 DARIEN WAY | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5992724 | 2094938 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | 9 | 8 | 4 | 59 | 40 | ||||
| 127177 | 115258 | DPW Maintained 1 | :: 45 | 2150 Jackson St | : Cutout | Landscaping | Private 2 | 01/21/2016 12:00:00 AM | 6x12 | 6003858 | 2116995.5 | 37.7930839063862 | -122.430597643601 | (37.7930839063862, -122.430597643601) | 13 | 9 | 1 | 29490 | 27 | ||||
| 26240 | 115259 | DPW Maintained 1 | :: 45 | 2130 Jackson St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/21/2016 12:00:00 AM | 6x12 | 6003918.8 | 2117004 | 37.7931106894063 | -122.430387878845 | (37.7931106894063, -122.430387878845) | 13 | 9 | 1 | 29490 | 27 | ||||
| 257 | 115298 | Permitted Site 7 | :: 45 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||||
| 171514 | 115762 | Undocumented 4 | :: 45 | 84X Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | on Athens Street frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | |||
| 31879 | 115804 | Undocumented 4 | :: 45 | 282X GRAYSTONE TER | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5999572 | 2103825 | 37.7566773324243 | -122.444480417383 | (37.7566773324243, -122.444480417383) | 2 | 5 | 5 | 28862 | 38 | ||||
| 189112 | 115869 | Undocumented 4 | :: 45 | 84X Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
| 192835 | 115870 | Undocumented 4 | :: 45 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
| 169566 | 115891 | DPW Maintained 1 | :: 45 | 1900X Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.60834 | 37.75961937033 | -122.481684343854 | (37.75961937033, -122.481684343854) | 1 | 8 | 3 | 56 | 35 | |||
| 7270 | 115892 | DPW Maintained 1 | :: 45 | 1900X Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.60834 | 37.75961937033 | -122.481684343854 | (37.75961937033, -122.481684343854) | 1 | 8 | 3 | 56 | 35 | |||
| 147314 | 115893 | DPW Maintained 1 | :: 45 | 1900X Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.60834 | 37.75961937033 | -122.481684343854 | (37.75961937033, -122.481684343854) | 1 | 8 | 3 | 56 | 35 | |||
| 154963 | 115894 | DPW Maintained 1 | :: 45 | 1900X Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.60834 | 37.75961937033 | -122.481684343854 | (37.75961937033, -122.481684343854) | 1 | 8 | 3 | 56 | 35 | |||
| 88587 | 115931 | Undocumented 4 | :: 45 | 847 43RD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585 | 2109998 | 37.7726427311472 | -122.503683790346 | (37.7726427311472, -122.503683790346) | 11 | 6 | 2 | 55 | 26 | ||
| 43484 | 115963 | Undocumented 4 | :: 45 | 847 43RD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585 | 2109998 | 37.7726427311472 | -122.503683790346 | (37.7726427311472, -122.503683790346) | 11 | 6 | 2 | 55 | 26 | ||
| 53076 | 115981 | Undocumented 4 | :: 45 | 3647 22ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003911 | 2103006 | 37.754675174124 | -122.429416177944 | (37.754675174124, -122.429416177944) | 2 | 4 | 5 | 28862 | 22 | ||||
| 59703 | 115996 | Undocumented 4 | :: 45 | 136 DUNCAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005652 | 2099949 | 37.7463797716398 | -122.423178037621 | (37.7463797716398, -122.423178037621) | 2 | 7 | 5 | 28859 | 22 | |||
| 119819 | 116222 | Undocumented 4 | :: 45 | 27 RAMONA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005254 | 2107682 | 37.7675903103517 | -122.425104409689 | (37.7675903103517, -122.425104409689) | 8 | 4 | 5 | 28853 | 19 | ||||
| 183044 | 116274 | Undocumented 4 | :: 45 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 466 | 116275 | Undocumented 4 | :: 45 | 700X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 48387 | 116276 | Undocumented 4 | :: 45 | 700X Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 166962 | 116277 | Undocumented 4 | :: 45 | 700X Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 172525 | 116278 | Undocumented 4 | :: 45 | 700X Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 47978 | 116279 | Undocumented 4 | :: 45 | 700X Greenwich St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 179164 | 116280 | Undocumented 4 | :: 45 | 700X Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 133404 | 116281 | Undocumented 4 | :: 45 | 700X Greenwich St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 109200 | 116282 | Undocumented 4 | :: 45 | 700X Greenwich St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 94093 | 116283 | Undocumented 4 | :: 45 | 700X Greenwich St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 |
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) );