trees
443 rows where qSpecies_id = 32 sorted by qLegalStatus_id descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id ▲ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4192 | 264915 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 1461 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784397 | 6015819.34366 | 2093828.22518 | 37.7301419060949 | -122.387593270969 | (37.7301419060949, -122.387593270969) | 10 | 3 | 8 | 58 | 1 | |
12761 | 261857 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 176 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2020 12:00:00 AM | 3 | 5992988.80812 | 2088380.73889 | 37.7138934199028 | -122.466125014283 | (37.7138934199028, -122.466125014283) | 9 | 8 | 6 | 64 | 24 | |||
1405 | 96265 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | Permit Number 767311 | 6004841.3 | 2119075.5 | 37.798850712467 | -122.427343605274 | (37.798850712467, -122.427343605274) | 13 | 9 | 1 | 57 | 17 | |||
2751 | 32002 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 5x5 | Permit Number 35399 | 6000302.11365106 | 2118206.59769697 | 37.7962071755692 | -122.442988194102 | (37.7962071755692, -122.442988194102) | 13 | 9 | 1 | 57 | 17 | ||
4051 | 260659 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
7104 | 9470 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
8550 | 260661 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
9356 | 260660 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
17446 | 9465 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
17511 | 260658 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
18441 | 260662 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
23903 | 107340 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 300X EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773835 | 6006696 | 2098030 | 37.7411694904711 | -122.419431881915 | (37.7411694904711, -122.419431881915) | 2 | 7 | 7 | 28859 | 2 | |
27892 | 9514 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1024 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004658.34921 | 2112287.36137 | 37.7802018438259 | -122.427492819652 | (37.7802018438259, -122.427492819652) | 7 | 9 | 11 | 29490 | 41 | ||
30327 | 34199 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/1997 12:00:00 AM | Permit Number 38018 | 5994287.68885518 | 2098749.96127524 | 37.7424396309737 | -122.462387263533 | (37.7424396309737, -122.462387263533) | 1 | 8 | 4 | 59 | 40 | ||
33577 | 38310 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2003 12:00:00 AM | Permit Number 47228 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
34340 | 45171 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 47 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44018 | 6010456.17942581 | 2099626.75633158 | 37.7457649076199 | -122.406542957313 | (37.7457649076199, -122.406542957313) | 2 | 7 | 7 | 28859 | 2 | ||
34823 | 108597 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
34960 | 115370 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 481 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 773523 | 6007887 | 2096619.6 | 37.7373638523191 | -122.415214003631 | (37.7373638523191, -122.415214003631) | 2 | 7 | 7 | 28859 | 2 | ||
37442 | 87929 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
37896 | 9519 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1042 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2002 12:00:00 AM | 3 | 3X3 | 6004584.56967 | 2112292.20585 | 37.780210972327 | -122.427748402246 | (37.780210972327, -122.427748402246) | 7 | 9 | 11 | 29490 | 41 | ||
40487 | 96154 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 482 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767788 | 6008200 | 2096596 | 37.7373166375453 | -122.414130144574 | (37.7373166375453, -122.414130144574) | 2 | 7 | 7 | 28859 | 2 | |
44013 | 87743 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 335 Wilde Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50406 | 6011180.9 | 2088940.4 | 37.7164629306199 | -122.403285348147 | (37.7164629306199, -122.403285348147) | 9 | 7 | 8 | 309 | 39 | |||
46316 | 9558 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1195X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | ||
48429 | 94030 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2576 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2010 12:00:00 AM | 3x3 | Permit Number 53444 | 6008873.8 | 2103464.7 | 37.756214388248 | -122.412285831464 | (37.756214388248, -122.412285831464) | 2 | 4 | 7 | 28859 | 19 | ||
50919 | 108598 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
54744 | 108430 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3025 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772569 | 6008074.01196 | 2103843.74387 | 37.7572102444691 | -122.415078608854 | (37.7572102444691, -122.415078608854) | 2 | 4 | 7 | 28859 | 19 |
55733 | 39080 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2280X Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
58134 | 38018 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 26 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.7429295327147 | -122.46804846503 | (37.7429295327147, -122.46804846503) | 1 | 8 | 4 | 29491 | 40 | ||
60569 | 66609 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 28- 30 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | Permit Number 773746 | 6005799.80596486 | 2106395.73703004 | 37.7640893550041 | -122.423125096713 | (37.7640893550041, -122.423125096713) | 8 | 4 | 5 | 28859 | 19 | |
61050 | 38300 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
65592 | 38311 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | Permit Number 47228 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
77655 | 40289 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3698X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41436 | 6005153.62196948 | 2101950.32896523 | 37.7518468217067 | -122.42504374449 | (37.7518468217067, -122.42504374449) | 2 | 4 | 5 | 28859 | 19 |
82544 | 91762 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008660.813755 | 2107281.610975 | 37.7666827970273 | -122.413292321769 | (37.7666827970273, -122.413292321769) | 8 | 4 | 7 | 28853 | 19 | |||
83366 | 45466 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2211 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2001 12:00:00 AM | Permit Number 44247 | 6011994.00463493 | 2101339.69847182 | 37.7505541915496 | -122.401345703709 | (37.7505541915496, -122.401345703709) | 10 | 3 | 8 | 28856 | 1 | |||
86394 | 81256 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 885 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50448 | 6003133.58124947 | 2103094.76960314 | 37.7548748688717 | -122.432111038861 | (37.7548748688717, -122.432111038861) | 2 | 4 | 5 | 28862 | 22 | ||
91576 | 96266 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | Permit Number 767311 | 6004841.3 | 2119075.5 | 37.798850712467 | -122.427343605274 | (37.798850712467, -122.427343605274) | 13 | 9 | 1 | 57 | 17 | |||
93220 | 87932 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
94761 | 87930 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
95260 | 96264 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | Permit Number 767311 | 6004841.3 | 2119075.5 | 37.798850712467 | -122.427343605274 | (37.798850712467, -122.427343605274) | 13 | 9 | 1 | 57 | 17 | |||
96920 | 63999 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 595 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778275 | 6001356.36107438 | 2100834.50333121 | 37.7485677985315 | -122.438095249236 | (37.7485677985315, -122.438095249236) | 2 | 4 | 5 | 28862 | 22 | |
98560 | 178360 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 114 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781343 | 6009991.86293 | 2095011.33058 | 37.7330659573247 | -122.40782310796 | (37.7330659573247, -122.40782310796) | 10 | 3 | 7 | 309 | 28 |
106410 | 57835 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 254 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1977 12:00:00 AM | 30 | 3x10 | Permit Number 16776 | 5996589.21937103 | 2105630.13222731 | 37.7614631235225 | -122.4549263227 | (37.7614631235225, -122.4549263227) | 15 | 5 | 11 | 29492 | 12 | |
106723 | 60332 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 4033 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2013 12:00:00 AM | 3x3 | Permit Number 770595 | 6002797.86052916 | 2104715.61000638 | 37.7593062690744 | -122.433387871218 | (37.7593062690744, -122.433387871218) | 2 | 4 | 5 | 28862 | 3 | ||
107605 | 108437 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
108771 | 94031 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2576 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2010 12:00:00 AM | 3x3 | Permit Number 53444 | 6008873.8 | 2103464.7 | 37.756214388248 | -122.412285831464 | (37.756214388248, -122.412285831464) | 2 | 4 | 7 | 28859 | 19 | ||
110100 | 12389 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1450 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6004617.47643 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | 13 | 9 | 11 | 28858 | 41 | |||
112885 | 40291 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3698X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41436 | 6005153.62196948 | 2101950.32896523 | 37.7518468217067 | -122.42504374449 | (37.7518468217067, -122.42504374449) | 2 | 4 | 5 | 28859 | 19 |
114296 | 38316 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
119135 | 45703 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1796 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/2002 12:00:00 AM | Permit Number 44377 | 6014535.62783282 | 2096937.66705225 | 37.7386086105091 | -122.392248663491 | (37.7386086105091, -122.392248663491) | 10 | 3 | 8 | 58 | 1 | ||
119202 | 91819 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2415 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 8 | 3x3 | 6008857.839983 | 2104395.646442 | 37.7587696603701 | -122.412406827225 | (37.7587696603701, -122.412406827225) | 2 | 4 | 7 | 28859 | 19 | ||
120089 | 51755 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2964 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 771839 | 6009683.01299313 | 2101640.06724055 | 37.7512497292061 | -122.409358522845 | (37.7512497292061, -122.409358522845) | 2 | 4 | 7 | 28859 | 19 | |||
124043 | 93976 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3261 Harrison St | : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | Permit Number 53402 | 6009036 | 2099698 | 37.7458809718535 | -122.411458783557 | (37.7458809718535, -122.411458783557) | 2 | 7 | 7 | 28859 | 2 | ||||
124229 | 38308 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
124358 | 87931 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008038 | 2106791 | 37.7653007068824 | -122.415411798097 | (37.7653007068824, -122.415411798097) | 8 | 4 | 7 | 28859 | 19 | ||
129629 | 95626 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767393 | 6010051.6 | 2104518.5 | 37.7591739071678 | -122.408286901595 | (37.7591739071678, -122.408286901595) | 2 | 4 | 7 | 28859 | 19 | |
132552 | 120537 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 300X EUGENIA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778832 | 6006696 | 2098030 | 37.7411694904711 | -122.419431881915 | (37.7411694904711, -122.419431881915) | 2 | 7 | 7 | 28859 | 2 | |
132630 | 51917 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 4103 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/2006 12:00:00 AM | Permit Number 48118 | 6001789.43433007 | 2103492.65068775 | 37.7558910555827 | -122.436787946951 | (37.7558910555827, -122.436787946951) | 2 | 4 | 5 | 28862 | 22 | ||
133308 | 38305 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
134854 | 9492 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 875 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X | 6005394.0418 | 2112324.36064 | 37.7803450180147 | -122.424950352589 | (37.7803450180147, -122.424950352589) | 7 | 9 | 11 | 28852 | 41 | ||
135550 | 91742 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2870 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008961.550736 | 2101748.066686 | 37.7515058228972 | -122.4118610593 | (37.7515058228972, -122.4118610593) | 2 | 4 | 7 | 28859 | 19 | ||
140165 | 91805 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2959 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009030.231108 | 2101235.143415 | 37.7501013029605 | -122.411587317077 | (37.7501013029605, -122.411587317077) | 2 | 4 | 7 | 28859 | 19 | ||
141605 | 38019 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 26 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.7429295327147 | -122.46804846503 | (37.7429295327147, -122.46804846503) | 1 | 8 | 4 | 29491 | 40 | ||
144217 | 104308 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 652 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2013 12:00:00 AM | 3x3 | Permit Number 770798 | 5995451.6 | 2089938.7 | 37.7183129950309 | -122.457725404768 | (37.7183129950309, -122.457725404768) | 9 | 8 | 6 | 28861 | 24 | ||
147631 | 38312 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2016 12:00:00 AM | 3 | Permit Number 771420 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | |
149706 | 89031 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1536 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53922 | 5993414.1 | 2105027.2 | 37.7596249765547 | -122.465863845757 | (37.7596249765547, -122.465863845757) | 1 | 8 | 4 | 56 | 12 | |
156550 | 9488 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 855 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005478.3549 | 2112356.31338 | 37.7804375144956 | -122.424660947747 | (37.7804375144956, -122.424660947747) | 7 | 9 | 11 | 28852 | 41 | ||
159351 | 96524 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
162020 | 63570 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3025 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | Permit Number 772569 | 6008074.34299958 | 2103837.752816 | 37.757193813006 | -122.415077039936 | (37.757193813006, -122.415077039936) | 2 | 4 | 7 | 28859 | 19 | |
166993 | 35785 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 40 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39037 | 6005293.11940108 | 2105777.11117211 | 37.7623621487297 | -122.424833565344 | (37.7623621487297, -122.424833565344) | 8 | 4 | 5 | 28859 | 19 | ||
167745 | 39073 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2280X Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
168250 | 91804 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2959 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009030.231108 | 2101235.143415 | 37.7501013029605 | -122.411587317077 | (37.7501013029605, -122.411587317077) | 2 | 4 | 7 | 28859 | 19 | ||
170214 | 57728 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 354 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52544 | 6004003.00672697 | 2109073.0127901 | 37.7713389455863 | -122.429530647558 | (37.7713389455863, -122.429530647558) | 7 | 9 | 11 | 29492 | 10 | ||
170289 | 91744 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2770 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6008929.558302 | 2102330.335121 | 37.7531028065892 | -122.412012837787 | (37.7531028065892, -122.412012837787) | 2 | 4 | 7 | 28859 | 19 | ||
171861 | 35805 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 633 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39049 | 6007507.54352575 | 2105966.04756896 | 37.7630057507472 | -122.417188065421 | (37.7630057507472, -122.417188065421) | 8 | 4 | 7 | 28859 | 19 | ||
172455 | 9471 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
177686 | 9503 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 925 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005161.80896 | 2112312.16407 | 37.7802984087399 | -122.425752886207 | (37.7802984087399, -122.425752886207) | 7 | 9 | 11 | 28852 | 41 | ||
177707 | 108436 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
178420 | 55550 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 101 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50802 | 6000558.4706929 | 2104874.62393167 | 37.759615580312 | -122.441144156399 | (37.759615580312, -122.441144156399) | 2 | 4 | 5 | 28862 | 3 | ||
182852 | 115200 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 716 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774286 | 6004934.3 | 2104152.6 | 37.7578813515637 | -122.425958943462 | (37.7578813515637, -122.425958943462) | 2 | 4 | 5 | 28862 | 3 | |||
182963 | 109449 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 73 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773467 | 6000399 | 2101283.9 | 37.7497472407948 | -122.441438023758 | (37.7497472407948, -122.441438023758) | 2 | 4 | 5 | 28862 | 22 |
184152 | 63700 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1530 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53921 | 5993398.86039614 | 2105062.95124939 | 37.7597222610505 | -122.465919149256 | (37.7597222610505, -122.465919149256) | 1 | 8 | 4 | 56 | 12 | |
187382 | 38306 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
190246 | 95637 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2196 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767403 | 6008103 | 2105638 | 37.7621384889596 | -122.415105357383 | (37.7621384889596, -122.415105357383) | 8 | 4 | 7 | 28859 | 19 | |
192662 | 9763 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 827X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005605.94462 | 2112369.06058 | 37.7804797202246 | -122.424220461395 | (37.7804797202246, -122.424220461395) | 7 | 9 | 11 | 28852 | 41 | ||
193803 | 96153 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 482 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767788 | 6008200 | 2096596 | 37.7373166375453 | -122.414130144574 | (37.7373166375453, -122.414130144574) | 2 | 7 | 7 | 28859 | 2 | |
194076 | 96525 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
194332 | 237618 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 395 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787900 | 6001516.02196 | 2103550.89224 | 37.756035430207 | -122.437737665468 | (37.756035430207, -122.437737665468) | 2 | 4 | 5 | 28862 | 3 | |
81784 | 93874 | Significant Tree 6 | Pistacia chinensis :: Chinese Pistache 32 | 2614 Sacramento St | Front Yard : | Tree | Private 2 | 04/14/2010 12:00:00 AM | Permit Number 53370 | 6002291 | 2115777 | 37.7896493226209 | -122.435932319436 | (37.7896493226209, -122.435932319436) | 13 | 6 | 1 | 29490 | 27 | ||||
9107 | 264723 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 335 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782646 | 6008658.96802 | 2100212.34216 | 37.7472720863526 | -122.412798868954 | (37.7472720863526, -122.412798868954) | 2 | 7 | 7 | 28859 | 2 | |
9475 | 163463 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 109 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995872.36784 | 2087580.2575 | 37.7118614273349 | -122.456100577893 | (37.7118614273349, -122.456100577893) | 9 | 8 | 6 | 28861 | 24 | |
10091 | 163462 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995871.2375 | 2087597.30845 | 37.7119081803938 | -122.45610571662 | (37.7119081803938, -122.45610571662) | 9 | 8 | 6 | 28861 | 24 | |
17374 | 163460 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.33981 | 2087649.24929 | 37.7120507463226 | -122.45611257216 | (37.7120507463226, -122.45611257216) | 9 | 8 | 6 | 28861 | 24 | |
19607 | 163461 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.30801 | 2087623.97935 | 37.7119813591246 | -122.456110856234 | (37.7119813591246, -122.456110856234) | 9 | 8 | 6 | 28861 | 24 | |
96556 | 76323 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2111 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1994 12:00:00 AM | 3 | 3x3 | 6008755.93357293 | 2106237.29701545 | 37.7638206919277 | -122.412889475083 | (37.7638206919277, -122.412889475083) | 8 | 4 | 7 | 28859 | 19 | ||
102670 | 98213 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
129967 | 98212 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
140574 | 98214 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
157112 | 256075 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 1919 Jennings St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015778 | 2093027 | 37.7279396111572 | -122.387680322808 | (37.7279396111572, -122.387680322808) | 10 | 3 | 8 | 58 | 1 | |||||
164430 | 98211 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
10960 | 166315 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008872.21502 | 2103120.32489 | 37.7552687230844 | -122.412266973836 | (37.7552687230844, -122.412266973836) | 2 | 4 | 7 | 28859 | 19 |
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) );