trees
443 rows where qSpecies_id = 32 sorted by Police Districts
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▼ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
141011 | 5490 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 714 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 12/28/2015 12:00:00 AM | 1 | 4X4 | Permit Number 774286 | 6004953.58017 | 2104162.27117 | 37.7579089959252 | -122.425892952911 | (37.7579089959252, -122.425892952911) | 2 | 4 | 5 | 28862 | 3 |
143745 | 91737 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3050 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009013.94236 | 2100807.207547 | 37.7489253726566 | -122.411613412745 | (37.7489253726566, -122.411613412745) | 2 | 4 | 7 | 28859 | 19 | |||
144188 | 233489 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1850 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008682.13256 | 2107685.30091 | 37.7677924328048 | -122.413247133243 | (37.7677924328048, -122.413247133243) | 8 | 4 | 7 | 28853 | 19 | |||
144954 | 233390 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1717 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008668.46209 | 2108152.59543 | 37.7690747473364 | -122.413327467893 | (37.7690747473364, -122.413327467893) | 8 | 4 | 7 | 28853 | 19 | |||
145019 | 233421 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2415 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008868.39184 | 2104298.37433 | 37.7585031654107 | -122.412363458525 | (37.7585031654107, -122.412363458525) | 2 | 4 | 7 | 28859 | 19 | |||
146063 | 96501 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 2 | 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 | ||
146681 | 91749 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.412262362741 | (37.7557803438331, -122.412262362741) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |
148038 | 233491 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 580 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001369.26473 | 2101468.92323 | 37.7503104980297 | -122.438096067791 | (37.7503104980297, -122.438096067791) | 2 | 4 | 5 | 28862 | 22 | |||
148679 | 233387 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008673.96808 | 2107833.61209 | 37.768199202458 | -122.41328586256 | (37.768199202458, -122.41328586256) | 8 | 4 | 7 | 28853 | 19 | |||
149857 | 91824 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2151 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008766 | 2105886 | 37.7628566761401 | -122.412829820139 | (37.7628566761401, -122.412829820139) | 8 | 4 | 7 | 28859 | 19 | ||
150163 | 233365 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 200 Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006473.17565 | 2104847.55108 | 37.7598763753088 | -122.420686190322 | (37.7598763753088, -122.420686190322) | 2 | 4 | 7 | 28859 | 19 | |||
150663 | 91759 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2100X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008715.935636 | 2106109.169361 | 37.7634666376506 | -122.413018756224 | (37.7634666376506, -122.413018756224) | 8 | 4 | 7 | 28859 | 19 | ||
152223 | 233459 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008875.1197 | 2103072.85924 | 37.7551385561152 | -122.412253573936 | (37.7551385561152, -122.412253573936) | 2 | 4 | 7 | 28859 | 19 | |||
152413 | 233363 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1750 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008602.87705 | 2108217.80859 | 37.7692501250135 | -122.413558936315 | (37.7692501250135, -122.413558936315) | 8 | 4 | 7 | 28853 | 19 | |||
152499 | 233393 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007793.07408 | 2106462.86184 | 37.7643859465871 | -122.416235699112 | (37.7643859465871, -122.416235699112) | 8 | 4 | 7 | 28859 | 19 | |||
155461 | 233473 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008782.8633 | 2104706.90651 | 37.7596201017978 | -122.412688136266 | (37.7596201017978, -122.412688136266) | 2 | 4 | 7 | 28859 | 19 | |||
156920 | 233417 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2595 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008920.69253 | 2103375.89006 | 37.7559731674471 | -122.412117384237 | (37.7559731674471, -122.412117384237) | 2 | 4 | 7 | 28859 | 19 | |||
158092 | 233445 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 490 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007223.95865 | 2104457.82895 | 37.7588485743169 | -122.418061963207 | (37.7588485743169, -122.418061963207) | 2 | 4 | 7 | 28859 | 19 | |||
158444 | 233481 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008647.40135 | 2107231.86549 | 37.7665454544288 | -122.413335194872 | (37.7665454544288, -122.413335194872) | 8 | 4 | 7 | 28853 | 19 | |||
159245 | 233477 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008779.60533 | 2104818.31587 | 37.7599258236246 | -122.412707280136 | (37.7599258236246, -122.412707280136) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |
162724 | 233488 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008674.82028 | 2107841.97486 | 37.768222212525 | -122.413283506332 | (37.768222212525, -122.413283506332) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
166080 | 91817 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2595 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008914.192408 | 2103366.044871 | 37.7559457700652 | -122.41213916812 | (37.7559457700652, -122.41213916812) | 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 | ||
168397 | 233499 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4033 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002782.35328 | 2104714.28422 | 37.7593017489969 | -122.43344140802 | (37.7593017489969, -122.43344140802) | 2 | 4 | 5 | 28862 | 3 | |||
169625 | 233398 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007780.05383 | 2106672.69613 | 37.7649613705955 | -122.416295595781 | (37.7649613705955, -122.416295595781) | 8 | 4 | 7 | 28859 | 19 | |||
169761 | 91816 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2595 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008914.192408 | 2103366.044871 | 37.7559457700652 | -122.41213916812 | (37.7559457700652, -122.41213916812) | 2 | 4 | 7 | 28859 | 19 | ||
169947 | 233431 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2803 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007983.75701 | 2106759.69521 | 37.7652117022958 | -122.415597195761 | (37.7652117022958, -122.415597195761) | 8 | 4 | 7 | 28859 | 19 | |||
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 | ||
170559 | 91755 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2598 Harrison St | 2 | 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 | ||
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 | ||
172596 | 233415 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2621 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008930.78864 | 2103161.2361 | 37.7553843426301 | -122.412067299176 | (37.7553843426301, -122.412067299176) | 2 | 4 | 7 | 28859 | 19 | |||
173642 | 91764 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1818 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008632.668655 | 2107855.226552 | 37.7682562319719 | -122.413430242408 | (37.7682562319719, -122.413430242408) | 8 | 4 | 7 | 28853 | 19 | ||
174477 | 233422 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2349 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008855.0309 | 2104568.88986 | 37.7592451897218 | -122.41242878797 | (37.7592451897218, -122.41242878797) | 2 | 4 | 7 | 28859 | 19 | |||
174518 | 233478 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008776.66854 | 2104837.11683 | 37.7599772819377 | -122.41271876626 | (37.7599772819377, -122.41271876626) | 2 | 4 | 7 | 28859 | 19 | |||
174718 | 91812 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2685 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008942.770855 | 2102838.050886 | 37.754497621185 | -122.412003022866 | (37.754497621185, -122.412003022866) | 2 | 4 | 7 | 28859 | 19 | ||
174969 | 233447 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3250 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008424.63388 | 2104490.13055 | 37.759004772158 | -122.41391174213 | (37.759004772158, -122.41391174213) | 2 | 4 | 7 | 28859 | 19 | |||
174979 | 233404 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2997 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Cleary Bros. Landscape 22 | 5 | Width 3ft | 6009042 | 2101022 | 37.7495167187784 | -122.41153156233 | (37.7495167187784, -122.41153156233) | 2 | 4 | 7 | 28859 | 19 | |||
176036 | 233456 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2708 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008901.95607 | 2102598.24372 | 37.7538368746765 | -122.412127224618 | (37.7538368746765, -122.412127224618) | 2 | 4 | 7 | 28859 | 19 | |||
176128 | 233391 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 275 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007803.17814 | 2106268.28503 | 37.763852252016 | -122.416186970269 | (37.763852252016, -122.416186970269) | 8 | 4 | 7 | 28859 | 19 | |||
177011 | 233406 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2967 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009040.76192 | 2101208.50526 | 37.7500287512299 | -122.411549018972 | (37.7500287512299, -122.411549018972) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
179917 | 91756 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2450 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | ||
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 |
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 | ||
189404 | 96510 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 12 | 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 | ||
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 |
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) );