trees
665 rows where qSpecies_id = 89 sorted by Supervisor 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2382 | 255210 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 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 | ||||||||||||
| 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 | ||||||||||||
| 14704 | 255211 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 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 | ||||||||||||
| 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 | ||||
| 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 | ||||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | |||
| 44125 | 120266 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 24th Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5988365.77159 | 2115120.59325 | 37.7870461179038 | -122.484063450514 | (37.7870461179038, -122.484063450514) | 11 | 6 | 1 | 55 | 33 | ||||
| 45904 | 27672 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
| 46336 | 125437 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.444069220022 | (37.8045448847905, -122.444069220022) | 13 | 9 | 1 | 57 | 17 | |||
| 48705 | 27670 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
| 49659 | 28777 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
| 51637 | 125493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006021.47381 | 2120333.65457 | 37.8023719590496 | -122.423349300554 | (37.8023719590496, -122.423349300554) | 5 | 9 | 1 | 28858 | 32 | |||
| 51778 | 102757 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002051.95846 | 2117801.73169 | 37.7951951298959 | -122.436904386043 | (37.7951951298959, -122.436904386043) | 13 | 9 | 1 | 57 | 27 | |||
| 54441 | 125460 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2416 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003175.77984 | 2117097.00502 | 37.7933239410913 | -122.432965418428 | (37.7933239410913, -122.432965418428) | 13 | 9 | 1 | 29490 | 27 | |||
| 59297 | 125452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002068.61749 | 2117342.59163 | 37.7939353973611 | -122.436813859368 | (37.7939353973611, -122.436813859368) | 13 | 9 | 1 | 29490 | 27 | |||
| 61917 | 27665 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
| 62733 | 27668 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
| 62853 | 250093 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.7893943794989 | -122.425398617158 | (37.7893943794989, -122.425398617158) | 13 | 9 | 1 | 28858 | 41 | |||
| 63927 | 125438 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 250 Euclid Ave | 0 | Front Yard : Yard | Tree | Private 2 | 15 | 5998091.24108 | 2114006.24691 | 37.78454782955 | -122.450335292242 | (37.78454782955, -122.450335292242) | 15 | 6 | 1 | 54 | 31 | ||||
| 64387 | 104356 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004967.00865 | 2119154.82266 | 37.7990756208885 | -122.426914264396 | (37.7990756208885, -122.426914264396) | 13 | 9 | 1 | 57 | 17 | ||
| 64447 | 125502 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6007468.42884 | 2120195.87716 | 37.8020752142594 | -122.418332338987 | (37.8020752142594, -122.418332338987) | 5 | 1 | 1 | 28858 | 32 | |||
| 64715 | 125443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2298 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | 13 | 9 | 1 | 57 | 17 | |||
| 70682 | 125454 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002093.86703 | 2117345.78422 | 37.7939455983674 | -122.43672672227 | (37.7939455983674, -122.43672672227) | 13 | 9 | 1 | 29490 | 27 | |||
| 73410 | 125496 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6006063.84143 | 2120339.68716 | 37.8023909140602 | -122.423203116649 | (37.8023909140602, -122.423203116649) | 5 | 9 | 1 | 28858 | 32 | |||
| 74610 | 125446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003103.60158 | 2120772.63456 | 37.8034121715947 | -122.433477951057 | (37.8034121715947, -122.433477951057) | 13 | 9 | 1 | 57 | 17 | |||
| 76702 | 125458 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002284.26434 | 2117368.32549 | 37.7940183094364 | -122.436069543591 | (37.7940183094364, -122.436069543591) | 13 | 9 | 1 | 29490 | 27 | |||
| 77242 | 27669 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
| 82326 | 125441 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 2 | : | Tree | Private 2 | 4 | Width 2ft | 6000221.62171 | 2120363.59067 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | 13 | 9 | 1 | 57 | 17 | |||
| 82689 | 24521 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
| 84618 | 125504 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6007489.69173 | 2120199.07294 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | 5 | 1 | 1 | 28858 | 32 | |||
| 86571 | 125453 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002078.25785 | 2117342.70193 | 37.793936248105 | -122.436780510733 | (37.793936248105, -122.436780510733) | 13 | 9 | 1 | 29490 | 27 | |||
| 86838 | 34190 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 1 | 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 | ||
| 87363 | 125495 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006051.2199 | 2120336.9264 | 37.8023826214287 | -122.423246597049 | (37.8023826214287, -122.423246597049) | 5 | 9 | 1 | 28858 | 32 | |||
| 87861 | 27666 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
| 88253 | 125522 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | 5 | 1 | 1 | 308 | 32 | |||
| 89453 | 18924 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2675 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2013 12:00:00 AM | 3 | 4x4 | Permit Number 770153 | 6002021.65815 | 2115693.95851 | 37.7894060077371 | -122.436858266107 | (37.7894060077371, -122.436858266107) | 13 | 6 | 1 | 29490 | 27 | |
| 90579 | 125457 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.7951716162211 | -122.436898435221 | (37.7951716162211, -122.436898435221) | 13 | 9 | 1 | 57 | 27 | |||
| 90775 | 249549 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Fern St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6005525.06192 | 2114997.09858 | 37.7876910959164 | -122.424687279516 | (37.7876910959164, -122.424687279516) | 13 | 9 | 1 | 28858 | 41 | |||
| 95499 | 34189 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 4 | 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 | ||
| 96919 | 249550 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Fern St | 2 | : | Tree | Private 2 | 7 | Width 2ft | 6005507.22761 | 2114996.10092 | 37.7876873493358 | -122.424748911848 | (37.7876873493358, -122.424748911848) | 13 | 9 | 1 | 28858 | 41 | |||
| 97812 | 125456 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6002104.20596 | 2117349.59529 | 37.7939566501408 | -122.436691221543 | (37.7939566501408, -122.436691221543) | 13 | 9 | 1 | 29490 | 27 | |||
| 98180 | 7129 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.65603 | 37.7876230577135 | -122.424742207381 | (37.7876230577135, -122.424742207381) | 13 | 9 | 1 | 28858 | 41 | ||
| 98897 | 7122 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 3 | 3x3 | 6005816.45791 | 2115038.11546 | 37.787820171109 | -122.423682021812 | (37.787820171109, -122.423682021812) | 13 | 9 | 1 | 28858 | 41 | ||
| 101500 | 250077 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 3 | : | Tree | Private 2 | 13 | Width 3ft | 6005420.83643 | 2115306.80822 | 37.7885355944018 | -122.425069924841 | (37.7885355944018, -122.425069924841) | 13 | 9 | 1 | 28858 | 41 | |||
| 103800 | 24506 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 360X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005494.49314 | 2114994.92622 | 37.7876834046589 | -122.424792887097 | (37.7876834046589, -122.424792887097) | 13 | 9 | 1 | 28858 | 41 | |||
| 113174 | 125497 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6006282.86688 | 2120431.59702 | 37.8026556331117 | -122.422451714169 | (37.8026556331117, -122.422451714169) | 5 | 9 | 1 | 28858 | 32 | |||
| 114436 | 250079 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 5 | : | Tree | Private 2 | 13 | Width 3ft | 6005448.26526 | 2115310.78255 | 37.7885480563034 | -122.424975308091 | (37.7885480563034, -122.424975308091) | 13 | 9 | 1 | 28858 | 41 | |||
| 115971 | 66783 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 5 | Permit Number 30054 | 6005979.75561 | 2120327.60903 | 37.8023530049553 | -122.423493236148 | (37.8023530049553, -122.423493236148) | 5 | 9 | 1 | 28858 | 32 | |
| 116562 | 125448 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3057 Franklin St | 2 | : | Tree | Private 2 | 5 | Width 2ft | 6005070.86935 | 2120497.70862 | 37.8027687129688 | -122.426650549882 | (37.8027687129688, -122.426650549882) | 13 | 9 | 1 | 57 | 17 | |||
| 121196 | 125494 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | 5 | 9 | 1 | 28858 | 32 | |||
| 128405 | 28059 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 3 | 3X3 | 6005443.48959 | 2114960.28563 | 37.7875854093804 | -122.42496688413 | (37.7875854093804, -122.42496688413) | 13 | 9 | 1 | 28858 | 41 | ||
| 128968 | 92753 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3356 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999299.39389 | 2120397.78777 | 37.8021663758311 | -122.446615526285 | (37.8021663758311, -122.446615526285) | 13 | 9 | 1 | 57 | 17 | |
| 129154 | 17785 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1798X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005398.04469 | 2115519.90556 | 37.7891194189645 | -122.425163949857 | (37.7891194189645, -122.425163949857) | 13 | 9 | 1 | 28858 | 41 | |||
| 129795 | 125436 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3157 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001892.57083 | 2119015.7946 | 37.798519569189 | -122.437542875929 | (37.798519569189, -122.437542875929) | 13 | 9 | 1 | 57 | 17 | |||
| 130988 | 125455 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002099.50591 | 2117347.8348 | 37.7939515491883 | -122.436707358076 | (37.7939515491883, -122.436707358076) | 13 | 9 | 1 | 29490 | 27 | |||
| 131522 | 24519 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
| 132440 | 125450 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.7940985496517 | -122.44069290605 | (37.7940985496517, -122.44069290605) | 13 | 9 | 1 | 57 | 27 | |||
| 134327 | 18926 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.436984817806 | (37.7893971628975, -122.436984817806) | 13 | 6 | 1 | 29490 | 27 | |||
| 134937 | 27667 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
| 135907 | 24520 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
| 138069 | 250078 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6005435.52045 | 2115308.45101 | 37.7885409345647 | -122.425019237271 | (37.7885409345647, -122.425019237271) | 13 | 9 | 1 | 28858 | 41 | |||
| 138499 | 125449 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3101 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5999876.27718 | 2115725.03781 | 37.7893691777902 | -122.444283251471 | (37.7893691777902, -122.444283251471) | 13 | 6 | 1 | 29490 | 27 | |||
| 139279 | 7126 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005719.58539 | 2115024.09543 | 37.7877762068484 | -122.424016185622 | (37.7877762068484, -122.424016185622) | 13 | 9 | 1 | 28858 | 41 | ||
| 139288 | 24518 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
| 140751 | 250128 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1798 Pine St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6005370.71997 | 2115516.69917 | 37.7891090713658 | -122.425258261764 | (37.7891090713658, -122.425258261764) | 13 | 9 | 1 | 28858 | 41 | |||
| 141457 | 33132 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) | 13 | 9 | 1 | 57 | 17 |
| 142231 | 31949 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 2 | 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 | ||
| 143706 | 125451 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001095.19419 | 2117566.78183 | 37.7944955940578 | -122.440198075675 | (37.7944955940578, -122.440198075675) | 13 | 9 | 1 | 57 | 27 | |||
| 145672 | 7128 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 12 | 3X3 | 6005491.12747 | 2114969.49683 | 37.7876133917897 | -122.424802721882 | (37.7876133917897, -122.424802721882) | 13 | 9 | 1 | 28858 | 41 | ||
| 145970 | 125447 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3057 Franklin St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6005068.76254 | 2120514.19483 | 37.8028138607435 | -122.426659015206 | (37.8028138607435, -122.426659015206) | 13 | 9 | 1 | 57 | 17 | |||
| 146159 | 250076 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6005407.46076 | 2115305.46211 | 37.7885311427353 | -122.425116106829 | (37.7885311427353, -122.425116106829) | 13 | 9 | 1 | 28858 | 41 | |||
| 148477 | 7127 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005701.71486 | 2115022.25762 | 37.7877701517306 | -122.424077883603 | (37.7877701517306, -122.424077883603) | 13 | 9 | 1 | 28858 | 41 | ||
| 149402 | 125492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006010.16913 | 2120331.72981 | 37.8023660361287 | -122.423388283439 | (37.8023660361287, -122.423388283439) | 5 | 9 | 1 | 28858 | 32 | |||
| 149655 | 111999 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2414 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 24 | 4x4 | Permit Number 776155 | 6003178.79126 | 2117077.11494 | 37.7932694988467 | -122.432953577047 | (37.7932694988467, -122.432953577047) | 13 | 9 | 1 | 29490 | 27 | |
| 150651 | 250070 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 1 | : | Tree | DPW 1 | 2 | Width 3ft | 6005393.47416 | 2115303.01268 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | 13 | 9 | 1 | 28858 | 41 | |||
| 150762 | 34186 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 7 | 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 | ||
| 151012 | 7124 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005782.02097 | 2115033.60586 | 37.7878058449088 | -122.423800846553 | (37.7878058449088, -122.423800846553) | 13 | 9 | 1 | 28858 | 41 | ||
| 156024 | 7130 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 5 | 3X3 | 6005539.58789 | 2114975.93468 | 37.7876338054953 | -122.42463551632 | (37.7876338054953, -122.42463551632) | 13 | 9 | 1 | 28858 | 41 | ||
| 156119 | 24504 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 360X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005526.31532 | 2114998.99681 | 37.7876963787723 | -122.424683078077 | (37.7876963787723, -122.424683078077) | 13 | 9 | 1 | 28858 | 41 | |||
| 159536 | 125444 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3676 Fillmore St | 3 | : | Tree | Private 2 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | 13 | 9 | 1 | 57 | 17 | |||
| 160051 | 27671 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
| 161911 | 41212 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691 | (37.804135222937, -122.43679910691) | 13 | 9 | 1 | 57 | 17 | |
| 162245 | 125461 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1845 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004195.45414 | 2118342.02418 | 37.7968002290978 | -122.429526106064 | (37.7968002290978, -122.429526106064) | 13 | 9 | 1 | 57 | 17 | |||
| 164297 | 34667 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3065 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38339 | 6003364.40129 | 2118901.01049 | 37.7982879721724 | -122.432441684758 | (37.7982879721724, -122.432441684758) | 13 | 9 | 1 | 57 | 17 |
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) );