trees
443 rows where qSpecies_id = 32 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
140452 | 233472 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008783.57561 | 2104687.59979 | 37.7595671299267 | -122.412684307851 | (37.7595671299267, -122.412684307851) | 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 | ||
139810 | 233372 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3265 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009039.47947 | 2099686.62589 | 37.7458499362223 | -122.411445948568 | (37.7458499362223, -122.411445948568) | 2 | 7 | 7 | 28859 | 2 | |||
138652 | 91754 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2598 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008875.46007 | 2103341.542813 | 37.7558763196163 | -122.412271386078 | (37.7558763196163, -122.412271386078) | 2 | 4 | 7 | 28859 | 19 | ||
138417 | 233502 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 6 Park Hill Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6001148.61748 | 2107774.29044 | 37.7676109487195 | -122.439310982617 | (37.7676109487195, -122.439310982617) | 15 | 5 | 5 | 29492 | 3 | |||
138077 | 233414 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2627 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008932.10074 | 2103132.99229 | 37.7553068651207 | -122.412060765599 | (37.7553068651207, -122.412060765599) | 2 | 4 | 7 | 28859 | 19 | |||
137671 | 233408 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2949 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009035.34127 | 2101297.66233 | 37.7502732526072 | -122.411574062399 | (37.7502732526072, -122.411574062399) | 2 | 4 | 7 | 28859 | 19 | |||
137193 | 233435 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 650 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001680.56547 | 2099436.84867 | 37.7447486021689 | -122.436874115749 | (37.7447486021689, -122.436874115749) | 2 | 7 | 5 | 63 | 22 | |||
136993 | 507 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2755X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6008976.16945 | 2102362.07248 | 37.7531925653082 | -122.411853889149 | (37.7531925653082, -122.411853889149) | 2 | 4 | 7 | 28859 | 19 | ||
136895 | 29646 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 5 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015803.0705 | 2095958.3496 | 37.7359898984178 | -122.387798100273 | (37.7359898984178, -122.387798100273) | 10 | 3 | 8 | 58 | 1 | ||
136531 | 178357 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 700 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009625.93878 | 2090631.7553 | 37.7210200744845 | -122.408779340021 | (37.7210200744845, -122.408779340021) | 9 | 3 | 7 | 309 | 28 | |||
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 | ||
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 | ||
134828 | 233384 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008606.4822 | 2107885.73241 | 37.7683385236202 | -122.413522976899 | (37.7683385236202, -122.413522976899) | 8 | 4 | 7 | 28853 | 19 | |||
134754 | 233376 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 476 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003431.53598 | 2100120.0067 | 37.7467237571152 | -122.430868343305 | (37.7467237571152, -122.430868343305) | 2 | 7 | 5 | 63 | 22 | |||
134732 | 91766 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6008637.233081 | 2107758.360569 | 37.767990516791 | -122.413407603159 | (37.767990516791, -122.413407603159) | 8 | 4 | 7 | 28853 | 19 | ||
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 | ||
132838 | 26467 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 300X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2016 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | |
132142 | 100385 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1800 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2012 12:00:00 AM | 3x3 | Permit Number 769433 | 5990171 | 2106556 | 37.7636350362567 | -122.477191710239 | (37.7636350362567, -122.477191710239) | 1 | 8 | 3 | 56 | 35 | ||
131782 | 233419 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2525 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008908.13628 | 2103593.41402 | 37.7565697345137 | -122.412176180999 | (37.7565697345137, -122.412176180999) | 2 | 4 | 7 | 28859 | 19 | |||
131550 | 233462 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2598 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008860.64869 | 2103366.96238 | 37.7559452848687 | -122.412324405443 | (37.7559452848687, -122.412324405443) | 2 | 4 | 7 | 28859 | 19 | |||
131306 | 3871 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1540X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2013 12:00:00 AM | 3X3 | 6015830.0749765 | 2095995.2525495 | 37.7360927223499 | -122.3877073081 | (37.7360927223499, -122.3877073081) | 10 | 3 | 8 | 58 | 1 | |||
131234 | 132216 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999249.48209 | 2118404.06668 | 37.7966893013211 | -122.446644714701 | (37.7966893013211, -122.446644714701) | 13 | 9 | 1 | 57 | 17 | |||
130450 | 194526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 15 | : Yard | Tree | Private 2 | 5 | 6014989.61274 | 2102184.78595 | 37.7530413020381 | -122.391045631074 | (37.7530413020381, -122.391045631074) | 10 | 3 | 8 | 28856 | 29 | ||||
130437 | 233397 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007782.29383 | 2106638.7453 | 37.7648682754772 | -122.416285443329 | (37.7648682754772, -122.416285443329) | 8 | 4 | 7 | 28859 | 19 | |||
130406 | 233503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 354 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004006.37155 | 2109072.69928 | 37.7713382752792 | -122.429518986121 | (37.7713382752792, -122.429518986121) | 7 | 9 | 11 | 29492 | 10 | |||
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 | |||
129807 | 233368 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3505 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006128.23738 | 2104906.34475 | 37.7600183620686 | -122.421883341755 | (37.7600183620686, -122.421883341755) | 2 | 4 | 5 | 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 | |
129486 | 233438 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 125 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007605.04677 | 2098050.53292 | 37.7412770284006 | -122.416290169252 | (37.7412770284006, -122.416290169252) | 2 | 7 | 7 | 28859 | 2 | |||
129117 | 233389 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008670.89575 | 2107897.67859 | 37.7683749416751 | -122.413301020619 | (37.7683749416751, -122.413301020619) | 8 | 4 | 7 | 28853 | 19 | |||
129097 | 233493 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4103 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6001723.63115 | 2103489.69631 | 37.7558792035671 | -122.437015303929 | (37.7558792035671, -122.437015303929) | 2 | 4 | 5 | 28862 | 22 | |||
129061 | 233460 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008873.95519 | 2103097.13758 | 37.7552051536125 | -122.41225931703 | (37.7552051536125, -122.41225931703) | 2 | 4 | 7 | 28859 | 19 | |||
128800 | 233449 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3210 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008043.39989 | 2105643.53791 | 37.7621503452727 | -122.415311884029 | (37.7621503452727, -122.415311884029) | 8 | 4 | 7 | 28859 | 19 | |||
128475 | 233508 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008712.28974 | 2107211.2482 | 37.7664924870523 | -122.413109298673 | (37.7664924870523, -122.413109298673) | 8 | 4 | 7 | 28853 | 19 | |||
127900 | 233452 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2846 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008941.56896 | 2101881.90811 | 37.7518722004517 | -122.411939616143 | (37.7518722004517, -122.411939616143) | 2 | 4 | 7 | 28859 | 19 | |||
127261 | 194536 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 150 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014975.61342 | 2110964.15152 | 37.7771467490639 | -122.391707837847 | (37.7771467490639, -122.391707837847) | 6 | 2 | 9 | 28856 | 20 | |||
126685 | 211312 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992605.95071 | 2099584.48851 | 37.7446340456409 | -122.468262856351 | (37.7446340456409, -122.468262856351) | 1 | 8 | 4 | 29491 | 40 | |||
126321 | 118491 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 8245 Geary Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5981413.14873 | 2112317.48344 | 37.7789423808296 | -122.507909444403 | (37.7789423808296, -122.507909444403) | 11 | 6 | 2 | 55 | 26 | ||||
125810 | 194528 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 21 | : Yard | Tree | Private 2 | 3 | 6014977.55524 | 2102273.87418 | 37.7532852503289 | -122.391093555018 | (37.7532852503289, -122.391093555018) | 10 | 3 | 8 | 28856 | 29 | ||||
125518 | 194542 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012450.21381 | 2107404.91238 | 37.7672333764343 | -122.400194013336 | (37.7672333764343, -122.400194013336) | 14 | 3 | 8 | 28856 | 20 | |||
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 | ||
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 | ||
124180 | 96506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 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 | ||||
123820 | 233428 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2147 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.0081 | 2105817.64626 | 37.7626700032421 | -122.412762703536 | (37.7626700032421, -122.412762703536) | 8 | 4 | 7 | 28859 | 19 | |||
123792 | 233403 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3071 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009068.28085 | 2100690.59156 | 37.7486082190041 | -122.411417271913 | (37.7486082190041, -122.411417271913) | 2 | 4 | 7 | 28859 | 19 | |||
123609 | 139845 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 833 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005645.4131 | 2112373.0828 | 37.7804929927223 | -122.424084207294 | (37.7804929927223, -122.424084207294) | 7 | 9 | 11 | 28852 | 41 | |||
123473 | 233367 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1113 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010291.70011 | 2102620.11112 | 37.753974797412 | -122.407322687398 | (37.753974797412, -122.407322687398) | 10 | 4 | 7 | 28859 | 19 | |||
123302 | 233425 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008802.53088 | 2105481.30644 | 37.7617475308496 | -122.412674861355 | (37.7617475308496, -122.412674861355) | 8 | 4 | 7 | 28859 | 19 | |||
123083 | 233500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4090 20th St | 10 | : Yard | Tree | Private 2 | 3 | Width 3ft | 6003098.24212 | 2104183.0577 | 37.7578610449587 | -122.432310971886 | (37.7578610449587, -122.432310971886) | 2 | 4 | 5 | 28862 | 3 | |||
121618 | 233399 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007778.39498 | 2106706.34258 | 37.7650536626339 | -122.416303716638 | (37.7650536626339, -122.416303716638) | 8 | 4 | 7 | 28859 | 19 | |||
121600 | 194541 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012465.16673 | 2107386.76068 | 37.7671843696864 | -122.40014101809 | (37.7671843696864, -122.40014101809) | 14 | 3 | 8 | 28856 | 20 | |||
120951 | 35880 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 50 Elmira St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 7 | Permit Number 39083 | 6011141.46747 | 2096642.94504 | 37.7376103170696 | -122.403963378733 | (37.7376103170696, -122.403963378733) | 10 | 3 | 8 | 58 | 1 | |
120408 | 178359 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 235 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003629.76511 | 2092456.58351 | 37.7256929707372 | -122.429636417784 | (37.7256929707372, -122.429636417784) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
119545 | 91765 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008637.233081 | 2107758.360569 | 37.767990516791 | -122.413407603159 | (37.767990516791, -122.413407603159) | 8 | 4 | 7 | 28853 | 19 | ||
119326 | 233469 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008788.18662 | 2104615.29768 | 37.7593688636119 | -122.412663249315 | (37.7593688636119, -122.412663249315) | 2 | 4 | 7 | 28859 | 19 | |||
119309 | 233476 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.53012 | 2104788.45028 | 37.7598440959392 | -122.412688136268 | (37.7598440959392, -122.412688136268) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
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 | ||
119104 | 194546 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012481.42509 | 2107546.77644 | 37.7676246435913 | -122.40009602143 | (37.7676246435913, -122.40009602143) | 14 | 3 | 8 | 28856 | 20 | |||
119099 | 91809 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2727 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008956.545059 | 2102578.896484 | 37.7537868143213 | -122.411937075475 | (37.7537868143213, -122.411937075475) | 2 | 4 | 7 | 28859 | 19 | ||
119013 | 233396 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007784.70136 | 2106598.65312 | 37.7647583270588 | -122.416274276453 | (37.7647583270588, -122.416274276453) | 8 | 4 | 7 | 28859 | 19 | |||
118721 | 91767 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1750 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008620.908553 | 2108156.423024 | 37.7690825870348 | -122.413492224037 | (37.7690825870348, -122.413492224037) | 8 | 4 | 7 | 28853 | 19 | ||
118535 | 194531 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2221 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011908.13677 | 2101346.92633 | 37.75056924647 | -122.401643151235 | (37.75056924647, -122.401643151235) | 10 | 3 | 8 | 28856 | 1 | |||
118450 | 199989 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1054 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018046.698 | 2092242.698 | 37.7259114771391 | -122.379782821602 | (37.7259114771391, -122.379782821602) | 10 | 3 | 8 | 58 | 1 | |||
117702 | 233490 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 918 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001888.71802 | 2101354.60643 | 37.7500261396126 | -122.436291586193 | (37.7500261396126, -122.436291586193) | 2 | 4 | 5 | 28862 | 22 | |||
115599 | 96503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | |||
114657 | 9454 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005489.5152 | 2112411.3558 | 37.7805892777689 | -122.424626255587 | (37.7805892777689, -122.424626255587) | 7 | 9 | 11 | 28852 | 41 | ||
114649 | 194547 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 590 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6017544.15385 | 2096613.95658 | 37.7378863594562 | -122.381824001685 | (37.7378863594562, -122.381824001685) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
113956 | 233451 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2870 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008950.63348 | 2101756.58641 | 37.751528603671 | -122.411899414636 | (37.751528603671, -122.411899414636) | 2 | 4 | 7 | 28859 | 19 | |||
113569 | 9450 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 6 | Front Yard : Yard | Tree | Rec/Park 5 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.7806176146029 | -122.424439561439 | (37.7806176146029, -122.424439561439) | 7 | 9 | 11 | 28852 | 41 | |||
113488 | 233386 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008614.93876 | 2107785.11216 | 37.7680627186577 | -122.413486609222 | (37.7680627186577, -122.413486609222) | 8 | 4 | 7 | 28853 | 19 | |||
113333 | 32004 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2648 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 4 | Permit Number 35399 | 6000314.48806 | 2118206.69354 | 37.7962081442408 | -122.44294538314 | (37.7962081442408, -122.44294538314) | 13 | 9 | 1 | 57 | 17 | ||
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 |
112502 | 91739 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2814 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 4 | 3x3 | 6008944.07429 | 2102060.386342 | 37.7523624022397 | -122.411943563585 | (37.7523624022397, -122.411943563585) | 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 | |||
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 | ||
108313 | 96526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
107980 | 233484 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1818 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008611.01854 | 2107834.46107 | 37.7681979991668 | -122.413503659485 | (37.7681979991668, -122.413503659485) | 8 | 4 | 7 | 28853 | 19 | |||
107832 | 9453 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005504.6787 | 2112415.6882 | 37.7806020298362 | -122.424574106032 | (37.7806020298362, -122.424574106032) | 7 | 9 | 11 | 28852 | 41 | ||
107705 | 9458 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005390.9525 | 2112398.9001 | 37.7805495105702 | -122.424966344778 | (37.7805495105702, -122.424966344778) | 7 | 9 | 11 | 28852 | 41 | ||
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 |
107332 | 233378 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 514 Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007432.33067 | 2096315.60507 | 37.7365035861596 | -122.416764480695 | (37.7365035861596, -122.416764480695) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
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 | |
104740 | 29645 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 4 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015832.5829 | 2095938.2561 | 37.7359363605469 | -122.387694661666 | (37.7359363605469, -122.387694661666) | 10 | 3 | 8 | 58 | 1 | ||
104215 | 233392 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007791.82881 | 2106445.05823 | 37.7643369919914 | -122.416238745127 | (37.7643369919914, -122.416238745127) | 8 | 4 | 7 | 28859 | 19 | |||
103294 | 91752 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2660 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008895.550687 | 2102970.363593 | 37.7548582726151 | -122.412175673836 | (37.7548582726151, -122.412175673836) | 2 | 4 | 7 | 28859 | 19 | ||
103041 | 249943 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 331 Filbert St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011269.12703 | 2120027.36915 | 37.8018257441226 | -122.405168167193 | (37.8018257441226, -122.405168167193) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
101913 | 26527 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2011 12:00:00 AM | 3 | 3x3 | 6009007.86561 | 2102243.77418 | 37.7528695228702 | -122.411735918856 | (37.7528695228702, -122.411735918856) | 2 | 4 | 7 | 28859 | 19 | ||
101848 | 132211 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004866.10803 | 2118906.26122 | 37.7983874290946 | -122.427245699623 | (37.7983874290946, -122.427245699623) | 13 | 9 | 1 | 57 | 17 | |||
101767 | 233405 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2989 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009047.23113 | 2101093.61607 | 37.7497136539827 | -122.411518531957 | (37.7497136539827, -122.411518531957) | 2 | 4 | 7 | 28859 | 19 | |||
101577 | 233486 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008669.96247 | 2107902.14816 | 37.7683871616767 | -122.413304564874 | (37.7683871616767, -122.413304564874) | 8 | 4 | 7 | 28853 | 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) );