trees
665 rows where qSpecies_id = 89 sorted by Police Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▲ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 43755 | 256846 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 44580 | 16399 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 12 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
| 45841 | 249532 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006202.66878 | 2114026.79682 | 37.7850651330954 | -122.422273921828 | (37.7850651330954, -122.422273921828) | 13 | 9 | 11 | 28858 | 41 | |||
| 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 | |||
| 48506 | 125464 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 887 Eddy St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6006280.54306 | 2113153.33425 | 37.7826712115607 | -122.4219424317 | (37.7826712115607, -122.4219424317) | 7 | 9 | 11 | 28852 | 41 | |||
| 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 | |||
| 63826 | 256843 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 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 | ||
| 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 | |||
| 66789 | 16404 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
| 69039 | 16401 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
| 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 | |||
| 79790 | 51611 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 999 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47908 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | |||
| 82115 | 42786 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 269 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42753 | 6005259.26650222 | 2110063.08095744 | 37.7741284823912 | -122.425255647592 | (37.7741284823912, -122.425255647592) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 83244 | 32142 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 163X Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.7759537443519 | -122.422189614353 | (37.7759537443519, -122.422189614353) | 7 | 9 | 11 | 28852 | 10 | ||
| 84543 | 256847 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 86100 | 32141 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 163X Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.7759537443519 | -122.422189614353 | (37.7759537443519, -122.422189614353) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 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 | |||
| 87449 | 30702 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 361 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34614 | 6005271.42565012 | 2110238.90565505 | 37.7746119412537 | -122.425226100731 | (37.7746119412537, -122.425226100731) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 87885 | 16912 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 474 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3X3 | 6004730.16481 | 2110223.37403 | 37.7745387026084 | -122.427097323497 | (37.7745387026084, -122.427097323497) | 7 | 9 | 11 | 28852 | 10 | |||
| 88708 | 256845 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 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 | |||
| 94418 | 249544 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 298 Myrtle St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6006142.87898 | 2114042.34322 | 37.7851044469485 | -122.422481881052 | (37.7851044469485, -122.422481881052) | 13 | 9 | 11 | 28858 | 41 | |||
| 94779 | 256849 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 96258 | 256848 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 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 | ||
| 98279 | 256844 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 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 | ||
| 99030 | 125463 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006804.24109 | 2113922.09635 | 37.7848115656375 | -122.420185233786 | (37.7848115656375, -122.420185233786) | 7 | 9 | 9 | 28858 | 36 | |||
| 99651 | 249529 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1035 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006430.75514 | 2114125.51985 | 37.7853490652506 | -122.4214918273 | (37.7853490652506, -122.4214918273) | 13 | 9 | 11 | 28858 | 41 | |||
| 100280 | 8408 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1570 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1999 12:00:00 AM | 3 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711 | (37.7849669496355, -122.42916474711) | 13 | 9 | 11 | 29490 | 13 | ||
| 100911 | 16943 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 104419 | 256840 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 105504 | 18245 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1815X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003482.1216 | 2114150.20266 | 37.7852501414757 | -122.431694966286 | (37.7852501414757, -122.431694966286) | 13 | 9 | 11 | 29490 | 13 | |||
| 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 | |||
| 117100 | 256841 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 117721 | 64654 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1315 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1988 12:00:00 AM | Permit Number 25578 | 6006760.4974846 | 2115419.54547338 | 37.7889207278004 | -122.420442899695 | (37.7889207278004, -122.420442899695) | 13 | 9 | 10 | 28858 | 21 | ||
| 119583 | 31957 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35362 | 6006823.22516911 | 2113923.34802193 | 37.7848160720716 | -122.42011964381 | (37.7848160720716, -122.42011964381) | 7 | 9 | 9 | 28858 | 36 | ||
| 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 | |||
| 124968 | 221767 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 287 Hermann St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003902.82897 | 2108654.79623 | 37.770184952298 | -122.429847331292 | (37.770184952298, -122.429847331292) | 7 | 9 | 5 | 29492 | 10 | |||
| 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 | ||
| 128595 | 256842 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 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 | |||
| 131213 | 16913 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 477 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004718.6652 | 2110142.96999 | 37.7743172824327 | -122.42713137469 | (37.7743172824327, -122.42713137469) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 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 | |||
| 136505 | 249533 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6006226.92854 | 2114031.46887 | 37.78507932978 | -122.42219032262 | (37.78507932978, -122.42219032262) | 13 | 9 | 11 | 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 | |||
| 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 |
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) );