trees
665 rows where qSpecies_id = 89 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 317 | 189161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6008149.50016 | 2109391.65635 | 37.7724477670719 | -122.415210253457 | (37.7724477670719, -122.415210253457) | 8 | 2 | 9 | 28853 | 19 | |||
| 420 | 35740 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 9 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | 12 | Permit Number 39014 | 6007525.01662 | 2093953.73286 | 37.7300236128799 | -122.416276791867 | (37.7300236128799, -122.416276791867) | 9 | 3 | 7 | 309 | 28 | |
| 823 | 33293 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 166 Sproule Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 10 | Permit Number 37451 | 6009221.08576 | 2116982.79677 | 37.7933513902069 | -122.412040085683 | (37.7933513902069, -122.412040085683) | 3 | 1 | 10 | 28857 | 21 | |
| 1264 | 125499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 10 Hastings Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007355.47144 | 2119286.08851 | 37.7995708047014 | -122.418658671469 | (37.7995708047014, -122.418658671469) | 5 | 1 | 1 | 28858 | 32 | ||||
| 1455 | 176735 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007785.06482 | 2091940.88647 | 37.7245113883837 | -122.415235340041 | (37.7245113883837, -122.415235340041) | 9 | 3 | 7 | 309 | 28 | ||
| 1616 | 249984 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 226 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011604.5053 | 2120111.99388 | 37.8020768465317 | -122.404013554575 | (37.8020768465317, -122.404013554575) | 3 | 1 | 10 | 308 | 23 | |||
| 1720 | 221753 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 466 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003367.55908 | 2102748.60922 | 37.7539376572014 | -122.431277170628 | (37.7539376572014, -122.431277170628) | 2 | 4 | 5 | 28862 | 22 | |||
| 1725 | 261074 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 545 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012421 | 2094417 | 37.7315697407484 | -122.399383175238 | (37.7315697407484, -122.399383175238) | 10 | 3 | 8 | 58 | 1 | |
| 2235 | 16944 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
| 2382 | 255210 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 2997 | 220656 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 498X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008322.74158 | 2096484.80156 | 37.737018204322 | -122.41369790583 | (37.737018204322, -122.41369790583) | 2 | 7 | 7 | 28859 | 2 | |||
| 3711 | 125506 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | 3 | 1 | 10 | 308 | 21 | |||
| 3907 | 66747 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 731 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 4 | Permit Number 32132 | 5983183.98032 | 2110807.82823 | 37.7749014841497 | -122.501671811672 | (37.7749014841497, -122.501671811672) | 11 | 6 | 2 | 55 | 26 | |
| 4217 | 220655 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 390X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008083.69599 | 2096082.25636 | 37.7358994764657 | -122.414495920166 | (37.7358994764657, -122.414495920166) | 2 | 7 | 7 | 28859 | 2 | |||
| 4345 | 248094 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 8 Brewster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010447.33936 | 2099861.69566 | 37.7464095052133 | -122.406590078085 | (37.7464095052133, -122.406590078085) | 2 | 7 | 7 | 28859 | 2 | |||
| 4866 | 220627 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 665 Elizabeth St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6002180.12335 | 2102046.50109 | 37.7519424707911 | -122.435333378334 | (37.7519424707911, -122.435333378334) | 2 | 4 | 5 | 28862 | 22 | |||
| 4902 | 262165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 725 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/07/2019 12:00:00 AM | 3 | 6009246.1256 | 2087178.55003 | 37.7115170052904 | -122.409848612702 | (37.7115170052904, -122.409848612702) | 9 | 7 | 8 | 309 | 39 | |||
| 6257 | 125500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 12 Hastings Ter | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007269.76384 | 2119273.06582 | 37.7995302219096 | -122.418954327193 | (37.7995302219096, -122.418954327193) | 5 | 1 | 1 | 28858 | 32 | ||||
| 7190 | 120690 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 358 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782203 | 5989057.83806 | 2112937.05315 | 37.7810910000946 | -122.481509105367 | (37.7810910000946, -122.481509105367) | 11 | 6 | 2 | 55 | 26 | |
| 8154 | 220632 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 18 Kronquist Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6002213.33941 | 2100174.25358 | 37.7468036087954 | -122.435084618683 | (37.7468036087954, -122.435084618683) | 2 | 7 | 5 | 63 | 22 | |||
| 8425 | 175169 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 728 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009133.75655 | 2092888.51191 | 37.7271890729929 | -122.41063996266 | (37.7271890729929, -122.41063996266) | 9 | 3 | 7 | 309 | 28 | |||
| 9003 | 259743 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x Quesada Ave | 1 | Side Yard : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
| 9079 | 220625 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 665 Elizabeth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002079.84367 | 2102040.673 | 37.7519207728238 | -122.43567974235 | (37.7519207728238, -122.43567974235) | 2 | 4 | 5 | 28862 | 22 | |||
| 9227 | 249036 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 14 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013092.81558 | 2091032.06192 | 37.7223128112827 | -122.396823338154 | (37.7223128112827, -122.396823338154) | 10 | 3 | 8 | 58 | 1 | |
| 10180 | 125521 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008568.41134 | 2119026.06198 | 37.7989250510158 | -122.414443039112 | (37.7989250510158, -122.414443039112) | 5 | 1 | 10 | 308 | 32 | |||
| 10211 | 249538 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 7 | : | Tree | Private 2 | 4 | Width 3ft | 6006360.10871 | 2114050.01147 | 37.7851377542393 | -122.421730877876 | (37.7851377542393, -122.421730877876) | 13 | 9 | 11 | 28858 | 41 | |||
| 11971 | 220654 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 390X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008103.73158 | 2096079.3451 | 37.735892608341 | -122.414426443037 | (37.735892608341, -122.414426443037) | 2 | 7 | 7 | 28859 | 2 | |||
| 12247 | 16942 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
| 13613 | 261072 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1301 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2020 04:47:00 PM | 3 | 4x6 | 6014770 | 2090698 | 37.7214887539174 | -122.391002321697 | (37.7214887539174, -122.391002321697) | 10 | 3 | 8 | 58 | 1 | |
| 13876 | 189183 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6013471.29582 | 2110911.40867 | 37.7769183095594 | -122.396908085761 | (37.7769183095594, -122.396908085761) | 6 | 2 | 9 | 28856 | 34 | |||
| 13926 | 176734 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007778.84426 | 2091938.91597 | 37.7245056282085 | -122.415256704327 | (37.7245056282085, -122.415256704327) | 9 | 3 | 7 | 309 | 28 | ||
| 14262 | 92752 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | 13 | 9 | 1 | 57 | 17 | |
| 14396 | 220653 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 390X Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008119.35429 | 2096079.02548 | 37.7358926083592 | -122.41437240636 | (37.7358926083592, -122.41437240636) | 2 | 7 | 7 | 28859 | 2 | |||
| 14680 | 259744 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x Quesada Ave | 2 | Side Yard : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
| 14699 | 220657 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 498X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008343.07833 | 2096482.99595 | 37.737014388513 | -122.413627464658 | (37.737014388513, -122.413627464658) | 2 | 7 | 7 | 28859 | 2 | |||
| 14704 | 255211 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 14764 | 203487 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 828 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998282.18197 | 2096469.86688 | 37.736408249925 | -122.448411398672 | (37.736408249925, -122.448411398672) | 9 | 7 | 4 | 59 | 40 | |||
| 15364 | 259745 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x Quesada Ave | 3 | Side Yard : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
| 15503 | 221757 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2 Seward St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6001069.49524 | 2104258.14697 | 37.7579519799282 | -122.439332593347 | (37.7579519799282, -122.439332593347) | 2 | 4 | 5 | 28862 | 38 | |||
| 15512 | 203483 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 459 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995499.06215 | 2095368.93495 | 37.7332258441801 | -122.457954104018 | (37.7332258441801, -122.457954104018) | 9 | 7 | 4 | 59 | 40 | |||
| 16090 | 70151 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 846 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6007647.41454 | 2114440.4952 | 37.786282435643 | -122.417304870747 | (37.786282435643, -122.417304870747) | 13 | 1 | 9 | 28858 | 36 | |||
| 16888 | 171233 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 65 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003693 | 2093019 | 37.7272408214237 | -122.42945790991 | (37.7272408214237, -122.42945790991) | 9 | 7 | 6 | 28861 | 5 | ||
| 18869 | 261135 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 401 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6003851 | 2092597 | 37.7260910477872 | -122.428881632271 | (37.7260910477872, -122.428881632271) | 9 | 7 | 6 | 28861 | 5 | ||||
| 19869 | 37653 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1707 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 4 | Permit Number 40063 | 5990244.83767 | 2111259.26404 | 37.7765532018856 | -122.477280073273 | (37.7765532018856, -122.477280073273) | 11 | 6 | 2 | 55 | 26 | |
| 20069 | 249536 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6006331.73852 | 2114045.88325 | 37.7851248193023 | -122.421828736708 | (37.7851248193023, -122.421828736708) | 13 | 9 | 11 | 28858 | 41 | |||
| 20279 | 7125 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.17658 | 2115026.96294 | 37.7877851299198 | -122.423952067531 | (37.7877851299198, -122.423952067531) | 13 | 9 | 1 | 28858 | 41 | ||
| 20384 | 189165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | 10 | 3 | 8 | 28856 | 29 | |||
| 21355 | 125539 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 31 Spofford St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6010570.5264 | 2117382.56278 | 37.7945246709392 | -122.407399099212 | (37.7945246709392, -122.407399099212) | 3 | 1 | 10 | 28857 | 4 | |||
| 21935 | 91500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009901.41754 | 2113830.53604 | 37.784734187987 | -122.40946350554 | (37.784734187987, -122.40946350554) | 14 | 10 | 9 | 28852 | 36 | |
| 22266 | 189179 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012646.32236 | 2115321.24239 | 37.7889807363318 | -122.400071707361 | (37.7889807363318, -122.400071707361) | 12 | 2 | 9 | 28855 | 6 | |||
| 23055 | 189156 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012246.95244 | 2112466.10025 | 37.7811189079475 | -122.401252766302 | (37.7811189079475, -122.401252766302) | 6 | 2 | 9 | 28856 | 34 | |||
| 23673 | 125501 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6007553.74728 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | 5 | 1 | 1 | 28858 | 32 | |||
| 24163 | 220599 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 714 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010100.45141 | 2104938.60727 | 37.7603301624296 | -122.408147577953 | (37.7603301624296, -122.408147577953) | 2 | 4 | 8 | 28859 | 19 | |||
| 24223 | 125520 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.7989262722777 | -122.414435828363 | (37.7989262722777, -122.414435828363) | 5 | 1 | 10 | 308 | 32 | |||
| 24271 | 125480 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 70 Pleasant St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6008592.70141 | 2116811.84206 | 37.7928467140568 | -122.414202246537 | (37.7928467140568, -122.414202246537) | 5 | 1 | 10 | 28857 | 21 | |||
| 24487 | 125483 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1471 Washington St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6007681.40554 | 2117137.66068 | 37.7936901018702 | -122.417378482047 | (37.7936901018702, -122.417378482047) | 5 | 1 | 10 | 28858 | 32 | |||
| 24680 | 220592 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1383 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007189.08287 | 2107465.79435 | 37.7671057833397 | -122.418395859874 | (37.7671057833397, -122.418395859874) | 8 | 4 | 7 | 28853 | 19 | |||
| 24813 | 125514 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008590.31929 | 2119027.39259 | 37.7989299352366 | -122.414367324317 | (37.7989299352366, -122.414367324317) | 5 | 1 | 10 | 308 | 32 | |||
| 26386 | 221771 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | 2 | 7 | 5 | 63 | 7 | |||
| 26479 | 220593 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008525.9203 | 2107974.98193 | 37.7685790581131 | -122.413807947778 | (37.7685790581131, -122.413807947778) | 8 | 4 | 7 | 28853 | 19 | |||
| 26980 | 19287 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2810X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001358.59585 | 2115648.89401 | 37.7892445650455 | -122.439149150528 | (37.7892445650455, -122.439149150528) | 13 | 6 | 1 | 29490 | 27 | |||
| 27231 | 118929 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 875 La Playa | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5980750.23602 | 2109645.2788 | 37.7715662158284 | -122.510004109936 | (37.7715662158284, -122.510004109936) | 11 | 6 | 2 | 55 | 26 | |||
| 27574 | 203500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 77 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999471.94159 | 2093749.5809 | 37.729006934723 | -122.444102506626 | (37.729006934723, -122.444102506626) | 9 | 7 | 4 | 63 | 40 | |||
| 28238 | 31130 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 127 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 2 | 3x3 | Permit Number 34845 | 5998083.60465 | 2093967.15586 | 37.7295250449277 | -122.448917737661 | (37.7295250449277, -122.448917737661) | 9 | 7 | 4 | 28861 | 40 |
| 29202 | 125468 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6008726.14199 | 2116272.16952 | 37.7913723996763 | -122.413702344902 | (37.7913723996763, -122.413702344902) | 5 | 1 | 10 | 28857 | 21 | |||
| 30380 | 220601 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 75 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010687.7942 | 2100021.12984 | 37.7468607265348 | -122.405769837005 | (37.7468607265348, -122.405769837005) | 2 | 7 | 7 | 28859 | 2 | |||
| 30576 | 220607 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 512 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007434.64615 | 2096337.15194 | 37.7365628793641 | -122.416758001093 | (37.7365628793641, -122.416758001093) | 2 | 7 | 7 | 28859 | 2 | |||
| 30749 | 17018 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1048 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001982.80486 | 2109858.77961 | 37.7733818753695 | -122.436574858617 | (37.7733818753695, -122.436574858617) | 15 | 5 | 11 | 29492 | 10 | ||
| 30986 | 7123 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 9 | 3x3 | 6005797.9204 | 2115035.94869 | 37.7878131752727 | -122.423746004087 | (37.7878131752727, -122.423746004087) | 13 | 9 | 1 | 28858 | 41 | ||
| 31145 | 220664 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1192 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003819.11819 | 2101351.99344 | 37.7501284581809 | -122.429615973494 | (37.7501284581809, -122.429615973494) | 2 | 4 | 5 | 28862 | 22 | |||
| 31167 | 220602 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003653.16044 | 2099206.97915 | 37.7442293498199 | -122.430036867914 | (37.7442293498199, -122.430036867914) | 2 | 7 | 5 | 63 | 22 | |||
| 31391 | 125527 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 29 Miller Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010066.41664 | 2116970.44466 | 37.7933648665474 | -122.409114296086 | (37.7933648665474, -122.409114296086) | 3 | 1 | 10 | 28857 | 4 | |||
| 31461 | 249983 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 226 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011603.53088 | 2120119.93244 | 37.8020985894405 | -122.404017485543 | (37.8020985894405, -122.404017485543) | 3 | 1 | 10 | 308 | 23 | |||
| 32049 | 249535 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6006279.61488 | 2114039.53426 | 37.7851044469537 | -122.422008617322 | (37.7851044469537, -122.422008617322) | 13 | 9 | 11 | 28858 | 41 | |||
| 32468 | 189167 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x De Haro St | 18 | Median : Yard | Tree | DPW 1 | 1 | 6012264.80612 | 2102152.75254 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | 10 | 3 | 8 | 28856 | 29 | ||||
| 32554 | 99407 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
| 33000 | 220606 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007224.12082 | 2095985.37984 | 37.7355851472373 | -122.41746095617 | (37.7355851472373, -122.41746095617) | 2 | 7 | 7 | 28859 | 2 | |||
| 33069 | 125528 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 29 Miller Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010067.56823 | 2116961.57421 | 37.7933405749546 | -122.409109685279 | (37.7933405749546, -122.409109685279) | 3 | 1 | 10 | 28857 | 4 | |||
| 33499 | 246911 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 459 Frederick St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5997556.58518 | 2107424.48902 | 37.7664454174412 | -122.451710064262 | (37.7664454174412, -122.451710064262) | 15 | 5 | 11 | 29492 | 9 | |||
| 34435 | 118571 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7940 Geary Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 6 | 5982344.86422 | 2112440.78156 | 37.7793357732303 | -122.504695460976 | (37.7793357732303, -122.504695460976) | 11 | 6 | 2 | 55 | 26 | ||||
| 34525 | 125530 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010077.84381 | 2116891.68093 | 37.7931492405824 | -122.40906919691 | (37.7931492405824, -122.40906919691) | 3 | 1 | 10 | 28857 | 4 | |||
| 34762 | 249988 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011583.89861 | 2120104.21147 | 37.8020543265962 | -122.404084315938 | (37.8020543265962, -122.404084315938) | 3 | 1 | 10 | 308 | 23 | |||
| 34872 | 125482 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Nob Hill Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 6009469.59091 | 2116291.78471 | 37.7914679787239 | -122.411131403485 | (37.7914679787239, -122.411131403485) | 5 | 1 | 10 | 28857 | 21 | |||
| 34992 | 125491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005994.09185 | 2120329.47146 | 37.8023589278732 | -122.423443758146 | (37.8023589278732, -122.423443758146) | 5 | 9 | 1 | 28858 | 32 | |||
| 35518 | 125505 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 45 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6007613.99229 | 2119386.63886 | 37.7998614422209 | -122.41777122496 | (37.7998614422209, -122.41777122496) | 5 | 1 | 1 | 28858 | 32 | ||||
| 36154 | 64967 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004948.17442 | 2119151.63157 | 37.7990657940144 | -122.426979209822 | (37.7990657940144, -122.426979209822) | 13 | 9 | 1 | 57 | 17 | |
| 36532 | 175163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.441826421457 | (37.7251102235329, -122.441826421457) | 9 | 7 | 6 | 28861 | 25 | |||
| 37305 | 189152 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1665 Hudson Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6015368.44602 | 2097645.03721 | 37.7405971121722 | -122.389418536259 | (37.7405971121722, -122.389418536259) | 10 | 3 | 8 | 58 | 1 | |||
| 37925 | 125477 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009239.02025 | 2116870.71678 | 37.793044652131 | -122.411970106748 | (37.793044652131, -122.411970106748) | 3 | 1 | 10 | 28857 | 21 | |||
| 38146 | 220652 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 324 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | 2 | 7 | 7 | 28859 | 2 | |||
| 38197 | 28058 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 7 | 3X3 | 6005467.03901 | 2114965.36006 | 37.7876006726807 | -122.424885768876 | (37.7876006726807, -122.424885768876) | 13 | 9 | 1 | 28858 | 41 | ||
| 38269 | 175168 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004674.59943 | 2093952.62434 | 37.7298598742113 | -122.426130962075 | (37.7298598742113, -122.426130962075) | 9 | 7 | 6 | 28861 | 5 | |||
| 38406 | 220594 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008571.39642 | 2107977.23283 | 37.7685877923289 | -122.413650808341 | (37.7685877923289, -122.413650808341) | 8 | 4 | 7 | 28853 | 19 | |||
| 40013 | 203466 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 480 Hearst Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5998189.16786 | 2094420.93356 | 37.7307770478103 | -122.448585465162 | (37.7307770478103, -122.448585465162) | 9 | 7 | 4 | 59 | 40 | |||
| 40160 | 125440 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.443425105788 | (37.8021484793247, -122.443425105788) | 13 | 9 | 1 | 57 | 17 | |||
| 41103 | 175165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004671.92277 | 2094015.32561 | 37.730031886663 | -122.42614467765 | (37.730031886663, -122.42614467765) | 9 | 7 | 6 | 28861 | 5 | |||
| 41180 | 220663 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003819.29636 | 2101374.54384 | 37.7501903863949 | -122.42961696547 | (37.7501903863949, -122.42961696547) | 2 | 4 | 5 | 28862 | 22 | |||
| 41938 | 125534 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010079.0906 | 2116883.16981 | 37.793125940953 | -122.409064282098 | (37.793125940953, -122.409064282098) | 3 | 1 | 10 | 28857 | 4 | |||
| 41972 | 248095 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 8 Brewster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010444.10359 | 2099844.52048 | 37.746362164885 | -122.406600056945 | (37.746362164885, -122.406600056945) | 2 | 7 | 7 | 28859 | 2 | |||
| 43086 | 203451 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | 1 | 8 | 4 | 56 | 12 |
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) );