trees
603 rows where qSpecies_id = 172 sorted by Police Districts
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▼ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1168 | 39947 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 1286 | 39945 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 3382 | 46731 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 5647 | 46732 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 6590 | 39944 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 7296 | 39946 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 9758 | 46722 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 10645 | 46730 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 11952 | 39952 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 12633 | 39951 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 14549 | 39950 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 14616 | 39953 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 15472 | 46729 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 17495 | 39948 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 18303 | 39949 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 14514 | 264671 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 14 | Front Yard : Yard | Tree | Private 2 | 11/12/2020 02:25:00 PM | 3 | 6009001.70233 | 2118702.23978 | 37.798060246745 | -122.412920796267 | (37.798060246745, -122.412920796267) | 3 | 1 | 10 | 308 | 21 | |||
| 15073 | 264670 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 13 | Front Yard : Yard | Tree | Private 2 | 11/12/2020 02:23:00 PM | 3 | 6009001.70233 | 2118702.23978 | 37.798060246745 | -122.412920796267 | (37.798060246745, -122.412920796267) | 3 | 1 | 10 | 308 | 21 | |||
| 18562 | 136282 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 12 | Front Yard : Yard | Tree | Private 2 | 11/12/2020 09:08:00 AM | 3 | 6009001.70233 | 2118702.23978 | 37.798060246745 | -122.412920796267 | (37.798060246745, -122.412920796267) | 3 | 1 | 10 | 308 | 21 | |||
| 72764 | 136281 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 8 | Front Yard : Yard | Tree | Private 2 | 3 | 6008944.09485 | 2118690.11186 | 37.7980237126691 | -122.413119277553 | (37.7980237126691, -122.413119277553) | 3 | 1 | 10 | 308 | 21 | ||||
| 78983 | 249881 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 230 Greenwich St | 17 | Back Yard : Yard | Tree | Private 2 | 16 | Width 0ft | 6011514.20842 | 2120460.74576 | 37.8030293886471 | -122.404350588107 | (37.8030293886471, -122.404350588107) | 3 | 1 | 10 | 28860 | 6 | |||
| 85274 | 136279 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1151 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6006698.81265 | 2120089.55435 | 37.8017399263049 | -122.420988029784 | (37.8017399263049, -122.420988029784) | 5 | 1 | 1 | 28858 | 32 | ||||
| 135496 | 136280 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1080 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6008340.68232 | 2118631.36541 | 37.797828516615 | -122.415203104753 | (37.797828516615, -122.415203104753) | 5 | 1 | 10 | 308 | 21 | ||||
| 126888 | 197203 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 88 05th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6010503.85094 | 2113243.76912 | 37.7831568013875 | -122.407337895824 | (37.7831568013875, -122.407337895824) | 14 | 2 | 9 | 28853 | 34 | ||||
| 8107 | 260620 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1510 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015860.79811 | 2095596.0425 | 37.7349982739746 | -122.387573242087 | (37.7349982739746, -122.387573242087) | 10 | 3 | 8 | 58 | 1 | ||
| 16859 | 197195 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1700x Quesada Ave | 52 | Median : Yard | Tree | DPW 1 | 5 | 6014229.96459 | 2095381.00329 | 37.7343173549634 | -122.393196613328 | (37.7343173549634, -122.393196613328) | 10 | 3 | 8 | 58 | 1 | ||||
| 18259 | 51502 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 6 | Permit Number 47813 | 6012107.99979 | 2092823.48534 | 37.7271768287335 | -122.400353400198 | (37.7271768287335, -122.400353400198) | 10 | 3 | 8 | 58 | 1 | ||
| 19403 | 197209 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6019354.09765 | 2093629.33991 | 37.7297909609772 | -122.375359249432 | (37.7297909609772, -122.375359249432) | 10 | 3 | 8 | 58 | 1 | ||||
| 20588 | 197185 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 651 Missouri St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6013630.37789 | 2103829.16713 | 37.7574808988518 | -122.395861379221 | (37.7574808988518, -122.395861379221) | 10 | 3 | 8 | 28856 | 29 | ||||
| 20981 | 197177 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 6 | Front Yard : Yard | Tree | Private 2 | 13 | 6012740.29154 | 2102830.02856 | 37.7546879247201 | -122.398869552986 | (37.7546879247201, -122.398869552986) | 10 | 3 | 8 | 28856 | 29 | ||||
| 26327 | 82822 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
| 31036 | 82818 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
| 31480 | 197172 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900x Carolina St | 24 | Median : Yard | Tree | DPW 1 | 3 | 6012477.22941 | 2103487.19338 | 37.7564776943092 | -122.39982544149 | (37.7564776943092, -122.39982544149) | 10 | 3 | 8 | 28856 | 29 | ||||
| 32883 | 197205 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6019275.32859 | 2093678.30312 | 37.7299210694925 | -122.375634959101 | (37.7299210694925, -122.375634959101) | 10 | 3 | 8 | 58 | 1 | ||||
| 35171 | 197186 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Illinois St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6016257.1896 | 2100643.95159 | 37.7488807495539 | -122.386554632611 | (37.7488807495539, -122.386554632611) | 10 | 3 | 8 | 58 | 1 | |||
| 36136 | 197192 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 14 | Front Yard : Yard | Tree | Private 2 | 18 | 6015810.17797 | 2099864.72659 | 37.7467164033528 | -122.388046043088 | (37.7467164033528, -122.388046043088) | 3 | 8 | 58 | 1 | |||||
| 36639 | 197190 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 9 | Front Yard : Yard | Tree | Private 2 | 13 | 6015846.29737 | 2099899.92461 | 37.7468150508735 | -122.387923600389 | (37.7468150508735, -122.387923600389) | 3 | 8 | 58 | 1 | |||||
| 36650 | 197202 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012375.40062 | 2096377.97464 | 37.7369516266217 | -122.399678458117 | (37.7369516266217, -122.399678458117) | 10 | 3 | 8 | 58 | 1 | ||||
| 40489 | 6510 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200X Evans Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 15 | 6017613.51756 | 2097076.90112 | 37.7391613427334 | -122.381616361724 | (37.7391613427334, -122.381616361724) | 10 | 3 | 8 | 58 | 1 | |||
| 47120 | 200030 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015295.7414 | 2094553.9973 | 37.7321057143095 | -122.389454111911 | (37.7321057143095, -122.389454111911) | 10 | 3 | 8 | 58 | 1 | |||
| 51341 | 97051 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 795 Wisconsin St | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.398775590174 | (37.7574425906128, -122.398775590174) | 10 | 3 | 8 | 28856 | 29 | |||
| 51511 | 83003 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015217.1468 | 2094533.6617 | 37.7320455189111 | -122.389724413212 | (37.7320455189111, -122.389724413212) | 10 | 3 | 8 | 58 | 1 | |
| 52308 | 197207 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6019325.73842 | 2093646.8502 | 37.7298374801948 | -122.375458504919 | (37.7298374801948, -122.375458504919) | 10 | 3 | 8 | 58 | 1 | ||||
| 53189 | 46622 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015162.1856 | 2094456.1663 | 37.7318296842946 | -122.389909016355 | (37.7318296842946, -122.389909016355) | 10 | 3 | 8 | 58 | 1 | |
| 54420 | 197204 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 961 Le Conte Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6013357.29959 | 2089363.32814 | 37.7177455197262 | -122.395792202474 | (37.7177455197262, -122.395792202474) | 10 | 3 | 8 | 58 | 1 | ||||
| 56664 | 97021 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 59942 | 200032 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015330.9166 | 2094529.2648 | 37.7320397540499 | -122.389330775989 | (37.7320397540499, -122.389330775989) | 10 | 3 | 8 | 58 | 1 | |||
| 66368 | 82820 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
| 67171 | 53858 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 730 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1972 12:00:00 AM | 6 | Permit Number 9568 | 6015422.25071 | 2105620.89151 | 37.762500112301 | -122.389789458021 | (37.762500112301, -122.389789458021) | 10 | 3 | 8 | 28856 | 29 | ||
| 70543 | 51357 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 50 Pomona St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014147.24137 | 2094593.61459 | 37.732150750552 | -122.393427531355 | (37.732150750552, -122.393427531355) | 10 | 3 | 8 | 58 | 1 |
| 71600 | 197181 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Rhode Island St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 7ft | 6011998.69489 | 2102279.56036 | 37.7531351094233 | -122.401395527392 | (37.7531351094233, -122.401395527392) | 10 | 3 | 8 | 28856 | 29 | |||
| 72156 | 202100 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012079.44226 | 2092845.19967 | 37.727234859285 | -122.400453648533 | (37.727234859285, -122.400453648533) | 10 | 3 | 8 | 58 | 1 | ||||
| 73008 | 197182 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1750 22nd St | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6012809.54728 | 2103799.82503 | 37.7573546331292 | -122.398698099955 | (37.7573546331292, -122.398698099955) | 10 | 3 | 8 | 28856 | 29 | ||||
| 75706 | 82819 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
| 75933 | 202101 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012067.0135 | 2092854.03168 | 37.7272584170419 | -122.400497235069 | (37.7272584170419, -122.400497235069) | 10 | 3 | 8 | 58 | 1 | ||||
| 76209 | 197188 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Illinois St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6016258.08648 | 2100618.43223 | 37.7488107283357 | -122.386549751994 | (37.7488107283357, -122.386549751994) | 10 | 3 | 8 | 58 | 1 | |||
| 83115 | 197183 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1501 22nd St | 14 | Front Yard : Yard | Tree | Private 2 | 9 | 6013372.36986 | 2103823.70957 | 37.7574515566677 | -122.396753298024 | (37.7574515566677, -122.396753298024) | 10 | 3 | 8 | 28856 | 29 | ||||
| 84794 | 200174 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1022 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6013889.8173 | 2089740.206 | 37.718809961526 | -122.393977881076 | (37.718809961526, -122.393977881076) | 10 | 3 | 8 | 58 | 1 | |||
| 86307 | 197178 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 24 | Median : Yard | Tree | DPW 1 | 1 | 6012271.91368 | 2102115.47955 | 37.7526998195515 | -122.400439152361 | (37.7526998195515, -122.400439152361) | 10 | 3 | 8 | 28856 | 29 | ||||
| 86666 | 51501 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 3 | Permit Number 47813 | 6012094.35334 | 2092834.4343 | 37.7272061313316 | -122.400401344869 | (37.7272061313316, -122.400401344869) | 10 | 3 | 8 | 58 | 1 | ||
| 87367 | 197179 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 13 | Median : Yard | Tree | DPW 1 | 2 | 6012255.14184 | 2102164.55152 | 37.7528336251844 | -122.400500599441 | (37.7528336251844, -122.400500599441) | 10 | 3 | 8 | 28856 | 29 | ||||
| 89510 | 202102 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6012051.06489 | 2092865.44567 | 37.7272888680664 | -122.400553171109 | (37.7272888680664, -122.400553171109) | 10 | 3 | 8 | 58 | 1 | ||||
| 91699 | 197189 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 7 | Front Yard : Yard | Tree | Private 2 | 21 | 6015936.19644 | 2099934.12978 | 37.7469139511226 | -122.387615121238 | (37.7469139511226, -122.387615121238) | 3 | 8 | 58 | 1 | |||||
| 92934 | 46623 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52363 | 6015139.1019 | 2094428.6857 | 37.7317529479126 | -122.3899869032 | (37.7317529479126, -122.3899869032) | 10 | 3 | 8 | 58 | 1 | |
| 93239 | 197199 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012275.41688 | 2096456.43356 | 37.7371614843067 | -122.400029656869 | (37.7371614843067, -122.400029656869) | 10 | 3 | 8 | 58 | 1 | ||||
| 94487 | 197184 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1501 22nd St | 20 | Front Yard : Yard | Tree | Private 2 | 8 | 6013333.16365 | 2103831.67556 | 37.7574712473141 | -122.396889448187 | (37.7574712473141, -122.396889448187) | 10 | 3 | 8 | 28856 | 29 | ||||
| 95375 | 28089 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1100 Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3x4 | 6018138.7903974 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | 10 | 3 | 8 | 58 | 1 | ||
| 99577 | 201569 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 600 Donahue St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 6020624.73776 | 2092976.30056 | 37.7280676809716 | -122.370921308297 | (37.7280676809716, -122.370921308297) | 10 | 3 | 8 | 58 | 1 | |||
| 103485 | 200173 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1022 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6013894.556 | 2089735.8088 | 37.7187981510491 | -122.393961193506 | (37.7187981510491, -122.393961193506) | 10 | 3 | 8 | 58 | 1 | |||
| 107973 | 200034 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015379.8321 | 2094494.6392 | 37.7319473909121 | -122.389159246189 | (37.7319473909121, -122.389159246189) | 10 | 3 | 8 | 58 | 1 | |||
| 112243 | 82829 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015168.781 | 2094466.0594 | 37.731857214516 | -122.389886905293 | (37.731857214516, -122.389886905293) | 10 | 3 | 8 | 58 | 1 | |
| 113028 | 197197 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6012251.10105 | 2096472.21303 | 37.7372034556659 | -122.400114836148 | (37.7372034556659, -122.400114836148) | 10 | 3 | 8 | 58 | 1 | ||||
| 113073 | 197196 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1951 Revere Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 6013056.64262 | 2095884.22793 | 37.7356338527108 | -122.397288471104 | (37.7356338527108, -122.397288471104) | 10 | 3 | 8 | 58 | 1 | ||||
| 114102 | 46624 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015146.2469 | 2094436.9299 | 37.7317759810825 | -122.389962776954 | (37.7317759810825, -122.389962776954) | 10 | 3 | 8 | 58 | 1 | |
| 115893 | 82824 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
| 116223 | 197175 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 6012742.61039 | 2102842.03619 | 37.7547210242675 | -122.398862376408 | (37.7547210242675, -122.398862376408) | 10 | 3 | 8 | 28856 | 29 | ||||
| 117815 | 200031 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015313.8786 | 2094541.9059 | 37.7320735193499 | -122.389390563006 | (37.7320735193499, -122.389390563006) | 10 | 3 | 8 | 58 | 1 | |||
| 119840 | 113507 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 200x Mansell St | 13 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011128.47606 | 2090549.92676 | 37.720879434926 | -122.40357972974 | (37.720879434926, -122.40357972974) | 10 | 3 | 7 | 309 | 28 | |||
| 126782 | 52156 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1771 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 11 | Permit Number 48348 | 6014341.22767 | 2095259.71993 | 37.733990516147 | -122.392803455827 | (37.733990516147, -122.392803455827) | 10 | 3 | 8 | 58 | 1 | |
| 128850 | 202106 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6011990.13515 | 2092907.27832 | 37.7274003336589 | -122.400766743908 | (37.7274003336589, -122.400766743908) | 10 | 3 | 8 | 58 | 1 | |||
| 129326 | 197194 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 37 | Front Yard : Yard | Tree | Private 2 | 12 | 6015675.19682 | 2099860.17709 | 37.746696432096 | -122.388512480964 | (37.746696432096, -122.388512480964) | 3 | 8 | 58 | 1 | |||||
| 134803 | 197187 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Illinois St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6016257.35591 | 2100633.78015 | 37.7488528300966 | -122.386553348365 | (37.7488528300966, -122.386553348365) | 10 | 3 | 8 | 58 | 1 | |||
| 139094 | 202103 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012036.54433 | 2092874.73876 | 37.7273135751543 | -122.400604021475 | (37.7273135751543, -122.400604021475) | 10 | 3 | 8 | 58 | 1 | |||
| 140317 | 202104 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6012020.3729 | 2092885.52976 | 37.7273423030982 | -122.400660684147 | (37.7273423030982, -122.400660684147) | 10 | 3 | 8 | 58 | 1 | |||
| 140467 | 197206 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6019299.00025 | 2093665.65157 | 37.7298876336035 | -122.375552245738 | (37.7298876336035, -122.375552245738) | 10 | 3 | 8 | 58 | 1 | ||||
| 144174 | 197201 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012348.82133 | 2096403.61302 | 37.7370205425534 | -122.399772154858 | (37.7370205425534, -122.399772154858) | 10 | 3 | 8 | 58 | 1 | ||||
| 149518 | 109194 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 4705 03rd St | Back Yard : Yard | Tree | Arts Commission 19 | 45 | 6015121.6 | 2095617 | 37.7350148477359 | -122.390130397219 | (37.7350148477359, -122.390130397219) | 10 | 3 | 8 | 58 | 1 | |||||
| 149673 | 82823 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
| 152026 | 197193 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 15 | Front Yard : Yard | Tree | Private 2 | 10 | 6015814.64437 | 2099848.11828 | 37.7466710478274 | -122.388029439803 | (37.7466710478274, -122.388029439803) | 3 | 8 | 58 | 1 | |||||
| 152360 | 197180 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 11 | Median : Yard | Tree | DPW 1 | 1 | 6012255.35088 | 2102175.8421 | 37.752864638318 | -122.400500669565 | (37.752864638318, -122.400500669565) | 10 | 3 | 8 | 28856 | 29 | ||||
| 153671 | 46627 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1426 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 0 | 3x3 | Permit Number 51060 | 6016155.81653285 | 2095029.68224774 | 37.7334594988152 | -122.386513771605 | (37.7334594988152, -122.386513771605) | 10 | 3 | 8 | 58 | 1 | |
| 154848 | 83004 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52363 | 6015190.2158 | 2094494.6392 | 37.7319368775726 | -122.38981479563 | (37.7319368775726, -122.38981479563) | 10 | 3 | 8 | 58 | 1 | |
| 155260 | 82821 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
| 155576 | 197176 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 6012733.87653 | 2102837.73579 | 37.7547087296482 | -122.398892278868 | (37.7547087296482, -122.398892278868) | 10 | 3 | 8 | 28856 | 29 | ||||
| 155710 | 197191 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 12 | Front Yard : Yard | Tree | Private 2 | 18 | 6015839.12005 | 2099880.54912 | 37.7467614521736 | -122.387947067298 | (37.7467614521736, -122.387947067298) | 3 | 8 | 58 | 1 | |||||
| 156170 | 197174 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 6012741.09137 | 2102852.39923 | 37.754749394281 | -122.3988683569 | (37.754749394281, -122.3988683569) | 10 | 3 | 8 | 28856 | 29 | ||||
| 156274 | 197171 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 670 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015971.35988 | 2105878.87725 | 37.7632389206717 | -122.387908275953 | (37.7632389206717, -122.387908275953) | 14 | 3 | 8 | 28856 | 29 | |||
| 156991 | 179339 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 340 Tocoloma Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6012524.83653 | 2086861.12373 | 37.7108286189149 | -122.398494192156 | (37.7108286189149, -122.398494192156) | 10 | 3 | 8 | 309 | 1 | |||
| 157597 | 200033 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015359.4964 | 2094508.3795 | 37.7319839916649 | -122.389230510733 | (37.7319839916649, -122.389230510733) | 10 | 3 | 8 | 58 | 1 | |||
| 160990 | 197198 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012265.63539 | 2096460.02897 | 37.7371708111791 | -122.400063728568 | (37.7371708111791, -122.400063728568) | 10 | 3 | 8 | 58 | 1 | ||||
| 161527 | 29651 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500X La Salle Ave | 10 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015684.3928 | 2096048.7707 | 37.7362316014874 | -122.388214728777 | (37.7362316014874, -122.388214728777) | 10 | 3 | 8 | 58 | 1 |
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) );