trees
665 rows where qSpecies_id = 89 sorted by PlantType
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 | |||
414 | 8435 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1730 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/1997 12:00:00 AM | 13 | 3X3 | 6003010.73492 | 2113853.74303 | 37.784409407274 | -122.433304626878 | (37.784409407274, -122.433304626878) | 13 | 9 | 11 | 29490 | 13 | ||
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 | |||
5122 | 50073 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2622 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46804 | 5991453.86395603 | 2097563.96514649 | 37.7390195978985 | -122.472099259809 | (37.7390195978985, -122.472099259809) | 1 | 8 | 4 | 29491 | 40 | ||
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 | ||||
6336 | 261055 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1948 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780729 | 6013389.35902 | 2096036.97619 | 37.7360717858924 | -122.396148836191 | (37.7360717858924, -122.396148836191) | 10 | 3 | 8 | 58 | 1 |
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 | |||
8824 | 261056 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1952 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780727 | 6013369.93114 | 2096051.4395 | 37.7361104181421 | -122.396217020065 | (37.7361104181421, -122.396217020065) | 10 | 3 | 8 | 58 | 1 |
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 | |||
20586 | 45268 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 656 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44114 | 6008478.34688269 | 2095821.77218586 | 37.7352064067106 | -122.413113037779 | (37.7352064067106, -122.413113037779) | 10 | 7 | 7 | 28859 | 2 | ||
21321 | 42092 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 37 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42398 | 6008159.28675644 | 2099396.47385495 | 37.7450038344364 | -122.414469013279 | (37.7450038344364, -122.414469013279) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
24461 | 16391 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 248X Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2003 12:00:00 AM | 3 | 3X3 | 6006237.34556 | 2114081.50477 | 37.7852173036048 | -122.422157838958 | (37.7852173036048, -122.422157838958) | 13 | 9 | 11 | 28858 | 41 | ||
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 | |||
24509 | 34187 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
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 | |||
27673 | 34184 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
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 |
28791 | 34191 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
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 | |||
29617 | 50533 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47172 | 6014106.88689945 | 2104884.78697192 | 37.760405899811 | -122.394287314563 | (37.760405899811, -122.394287314563) | 10 | 3 | 8 | 28856 | 29 | |||
30160 | 34278 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 239 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1997 12:00:00 AM | Permit Number 38235 | 5987102.15938314 | 2114264.59763142 | 37.7846221515938 | -122.488372277385 | (37.7846221515938, -122.488372277385) | 11 | 6 | 1 | 55 | 33 | ||
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 | |||
30401 | 42094 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 45 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42400 | 6008105.01217426 | 2099392.98476779 | 37.744991204982 | -122.414656438734 | (37.744991204982, -122.414656438734) | 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 | |||
31263 | 30606 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 40 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.419697886953 | (37.773818193258, -122.419697886953) | 8 | 2 | 9 | 28853 | 19 | ||
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 | |||
33164 | 96256 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 192@ Congdon Ney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
34102 | 31948 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | 13 | 9 | 1 | 28858 | 41 | ||
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 | |||
34602 | 97033 | Property Tree 8 | Afrocarpus gracilior :: Fern Pine 89 | 61 Vicksburg St | Back Yard : Yard | Tree | Private 2 | Possible significant tree; Nellie RoW; rear yard | 6004120 | 2102703 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | 2 | 4 | 5 | 28862 | 22 | |||||
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 |
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) );