trees
115 rows where qSpecies_id = 267
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3839 | 220582 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1970 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008663.55208 | 2106884.85799 | 37.7655935589308 | -122.413254790993 | (37.7655935589308, -122.413254790993) | 8 | 4 | 7 | 28853 | 19 | |||
4143 | 5341 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 170 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5x5 | 6004776.50982 | 2107393.36664 | 37.7667708074641 | -122.426735430613 | (37.7667708074641, -122.426735430613) | 8 | 4 | 5 | 28862 | 3 | |||
4491 | 5344 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 180 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5x5 | 6004766.75319 | 2107347.68893 | 37.7666448358082 | -122.42676592393 | (37.7666448358082, -122.42676592393) | 8 | 4 | 5 | 28862 | 3 | |||
5727 | 72852 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 864 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012111.42682 | 2104322.01833 | 37.7587495400776 | -122.401149183293 | (37.7587495400776, -122.401149183293) | 10 | 3 | 8 | 28856 | 29 | |||
7093 | 167051 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 4243 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 5x6 | 6001803.12366 | 2105242.78708 | 37.7606972845723 | -122.436865887855 | (37.7606972845723, -122.436865887855) | 2 | 4 | 5 | 28862 | 3 | |||
9339 | 220579 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 17 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006961.59304 | 2100069.04845 | 37.7467832157815 | -122.418658118381 | (37.7467832157815, -122.418658118381) | 2 | 7 | 7 | 28859 | 2 | |||
13423 | 244887 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 163 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999854.6506 | 2109116.5264 | 37.7712226704839 | -122.443883080705 | (37.7712226704839, -122.443883080705) | 15 | 5 | 11 | 29492 | 9 | |||
17033 | 220583 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 432 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6004144.54051 | 2101440.53438 | 37.7503899918234 | -122.428496954298 | (37.7503899918234, -122.428496954298) | 2 | 4 | 5 | 28862 | 22 | |||
17220 | 5784 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 529 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003264.5891465 | 2108312.4032751 | 37.7692086613355 | -122.432030542626 | (37.7692086613355, -122.432030542626) | 15 | 5 | 5 | 28862 | 3 | |||
19714 | 244894 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 157 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999856.5482 | 2109090.9093 | 37.7711524406356 | -122.443874676044 | (37.7711524406356, -122.443874676044) | 15 | 5 | 11 | 29492 | 9 | |||
26088 | 47513 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 200 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45391 | 6001209.62107748 | 2093323.4940375 | 37.7279359754206 | -122.438064719936 | (37.7279359754206, -122.438064719936) | 9 | 7 | 6 | 28861 | 25 | ||
26217 | 5640 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1281 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/1997 12:00:00 AM | 3 | 4X4 | 6005220.37087 | 2100924.60238 | 37.7490341837912 | -122.424739954607 | (37.7490341837912, -122.424739954607) | 2 | 4 | 5 | 28859 | 19 | ||
30009 | 99508 | Undocumented 4 | Aesculus x carnea :: Red Horse Chestnut 267 | 2828 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000030 | 2117468 | 37.7941636633745 | -122.443876667305 | (37.7941636633745, -122.443876667305) | 13 | 9 | 1 | 57 | 27 | ||||
31082 | 5653 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1331 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1997 12:00:00 AM | 6 | 3x3 | 6005239.63118 | 2100605.43631 | 37.748158914998 | -122.424650651006 | (37.748158914998, -122.424650651006) | 2 | 4 | 5 | 28859 | 19 | ||
31880 | 189148 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 351 Cargo Way | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6017279.01029 | 2098696.34495 | 37.7435895334235 | -122.382885619892 | (37.7435895334235, -122.382885619892) | 10 | 3 | 8 | 58 | 1 | |||
32272 | 220575 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 4537 25th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6000809.16265 | 2101101.43994 | 37.7492696074192 | -122.440006586656 | (37.7492696074192, -122.440006586656) | 2 | 4 | 5 | 28862 | 22 | |||
32526 | 36591 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 1322 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39449 | 6009503.36363014 | 2101463.13072945 | 37.7507538338304 | -122.409967283502 | (37.7507538338304, -122.409967283502) | 2 | 4 | 7 | 28859 | 19 | ||
33293 | 125427 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2928 Vallejo St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 5999992.96171 | 2117466.62081 | 37.7941577637301 | -122.44400472425 | (37.7941577637301, -122.44400472425) | 13 | 9 | 1 | 57 | 27 | |||
33707 | 5590 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1083 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/1990 12:00:00 AM | 18 | 3x3 | 6005159.4457 | 2102050.19328 | 37.7521213549276 | -122.425030709901 | (37.7521213549276, -122.425030709901) | 2 | 4 | 5 | 28859 | 19 | ||
33804 | 101244 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 4248-4250 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2012 12:00:00 AM | 3x3 | Permit Number 769397 | 6002254 | 2101219 | 37.7496745444618 | -122.435018725879 | (37.7496745444618, -122.435018725879) | 2 | 4 | 5 | 28862 | 22 | ||
34410 | 5723 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1670 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/27/1998 12:00:00 AM | 18 | 3X3 | 6005263.96328 | 2098615.04936 | 37.742695141477 | -122.42442495986 | (37.742695141477, -122.42442495986) | 2 | 7 | 5 | 63 | 22 | ||
35645 | 5404 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 378 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/1999 12:00:00 AM | 16 | 3x3 | 6004843.86824 | 2106164.84267 | 37.7634013822954 | -122.426414967077 | (37.7634013822954, -122.426414967077) | 8 | 4 | 5 | 28859 | 3 | ||
37586 | 220571 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 704 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007751.9682 | 2095656.53748 | 37.734711903726 | -122.41561270548 | (37.734711903726, -122.41561270548) | 2 | 7 | 7 | 28859 | 2 | |||
38601 | 109730 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 4201 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775045 | 6001939.5 | 2105236.4 | 37.7606874972289 | -122.436393767062 | (37.7606874972289, -122.436393767062) | 2 | 4 | 5 | 28862 | 3 |
40553 | 3475 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 301X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
40845 | 225591 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 100 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002852.39104 | 2108929.65902 | 37.7708801165623 | -122.433500429628 | (37.7708801165623, -122.433500429628) | 15 | 5 | 11 | 29492 | 9 | |||
44313 | 66785 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1053 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 10 | Permit Number 30058 | 6007897.37697 | 2119565.10503 | 37.8003674088918 | -122.416803255883 | (37.8003674088918, -122.416803255883) | 5 | 1 | 1 | 308 | 32 | |
44591 | 203441 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1473 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5994261.47105 | 2105509.2927 | 37.7609975232464 | -122.462968212035 | (37.7609975232464, -122.462968212035) | 1 | 5 | 11 | 56 | 12 | |||
46144 | 3507 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 201X Cargo Way | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 6017965.04003 | 2098144.38706 | 37.7421118483876 | -122.380475117526 | (37.7421118483876, -122.380475117526) | 10 | 3 | 8 | 58 | 1 | |||
47700 | 125425 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2928 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6000023.6468 | 2117473.30633 | 37.7941778707649 | -122.443899031423 | (37.7941778707649, -122.443899031423) | 13 | 9 | 1 | 57 | 27 | |||
49399 | 1598 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 716 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/27/2015 12:00:00 AM | 3 | 3X3 | 5995689.23492 | 2111209.34792 | 37.7767305290971 | -122.458442841274 | (37.7767305290971, -122.458442841274) | 11 | 6 | 2 | 54 | 16 | ||
50664 | 220565 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 824 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004994.41271 | 2103503.72322 | 37.7561030853021 | -122.425704865097 | (37.7561030853021, -122.425704865097) | 2 | 4 | 5 | 28862 | 22 | |||
52366 | 256128 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1250X Florida St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
55422 | 220560 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 199 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005106.61398 | 2103972.26371 | 37.7573959272964 | -122.425350176086 | (37.7573959272964, -122.425350176086) | 2 | 4 | 5 | 28859 | 19 | |||
57210 | 220578 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 3980 22nd St | 5 | : | Tree | Private 2 | 9 | 6001940.74385 | 2102950.1671 | 37.7544101241454 | -122.436225849359 | (37.7544101241454, -122.436225849359) | 2 | 4 | 5 | 28862 | 22 | ||||
61084 | 256127 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1250X Florida St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
62046 | 220569 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1493 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005287.84546 | 2099674.63115 | 37.7456058602259 | -122.424417731116 | (37.7456058602259, -122.424417731116) | 2 | 7 | 5 | 28859 | 22 | |||
62573 | 220562 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 180 Fair Oaks St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005403.74239 | 2102621.49562 | 37.7537038155022 | -122.424226521752 | (37.7537038155022, -122.424226521752) | 2 | 4 | 5 | 28859 | 19 | |||
63760 | 220568 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1493 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005289.52426 | 2099654.61108 | 37.7455509844911 | -122.424410502356 | (37.7455509844911, -122.424410502356) | 2 | 7 | 5 | 28859 | 22 | |||
65887 | 256129 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1250X Florida St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
69739 | 125435 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2671 Leavenworth St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6007321.89472 | 2121819.7071 | 37.8065255894616 | -122.418954656349 | (37.8065255894616, -122.418954656349) | 5 | 1 | 1 | 28858 | 32 | ||||
73120 | 125426 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2928 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 6000010.5484 | 2117469.0719 | 37.7941654969806 | -122.443944048787 | (37.7941654969806, -122.443944048787) | 13 | 9 | 1 | 57 | 27 | |||
73155 | 3471 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 301X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
75875 | 121345 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 399X Cargo Way | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
78179 | 220585 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 4201 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001948.84946 | 2105253.2195 | 37.7607342107348 | -122.436362635325 | (37.7607342107348, -122.436362635325) | 2 | 4 | 5 | 28862 | 3 | |||
81534 | 28374 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 884 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005007.6879 | 2103215.15769 | 37.7553115020308 | -122.425638417778 | (37.7553115020308, -122.425638417778) | 2 | 4 | 5 | 28862 | 22 | |||
82410 | 41270 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 3219 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | 7 | Permit Number 41953 | 6013574.0809 | 2090117.634 | 37.7198287508508 | -122.395095686375 | (37.7198287508508, -122.395095686375) | 10 | 3 | 8 | 58 | 1 | ||
85387 | 256125 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1250X Florida St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
86914 | 125433 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2700 Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780237 | 6000667.51729 | 2117651.20267 | 37.794703033475 | -122.441683948183 | (37.794703033475, -122.441683948183) | 13 | 9 | 1 | 57 | 27 | |
86957 | 91418 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1150 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/26/2008 12:00:00 AM | 3x3 | 6005120 | 2101662 | 37.7510532378739 | -122.425139500126 | (37.7510532378739, -122.425139500126) | 2 | 4 | 5 | 28862 | 22 | |||
96294 | 47514 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 200 Santa Rosa Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45391 | 6001209.62107748 | 2093323.4940375 | 37.7279359754206 | -122.438064719936 | (37.7279359754206, -122.438064719936) | 9 | 7 | 6 | 28861 | 25 | ||
97751 | 3493 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 201X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/1990 12:00:00 AM | 3 | 3X3 | 6017614.96408 | 2098401.28975 | 37.7427979276792 | -122.381703445764 | (37.7427979276792, -122.381703445764) | 10 | 3 | 8 | 58 | 1 | ||
98165 | 220586 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 110 Henry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002743.62955 | 2107408.58103 | 37.7666974380494 | -122.433767904159 | (37.7666974380494, -122.433767904159) | 15 | 5 | 5 | 28862 | 3 | |||
100645 | 220572 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 572 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007801.48837 | 2096211.01853 | 37.7362371710113 | -122.415480739843 | (37.7362371710113, -122.415480739843) | 2 | 7 | 7 | 28859 | 2 | |||
104287 | 125431 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2700 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000672.22122 | 2117609.68414 | 37.7945893025098 | -122.441664690989 | (37.7945893025098, -122.441664690989) | 13 | 9 | 1 | 57 | 27 | |||
104316 | 104170 | Undocumented 4 | Aesculus x carnea :: Red Horse Chestnut 267 | 4537 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769080 | 6000821.1 | 2101080.3 | 37.7492122417659 | -122.439963791599 | (37.7492122417659, -122.439963791599) | 2 | 4 | 5 | 28862 | 22 | ||||
104723 | 220567 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1562 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6005227.20877 | 2099209.44767 | 37.7443251482875 | -122.424594319282 | (37.7443251482875, -122.424594319282) | 2 | 7 | 5 | 63 | 22 | |||
106684 | 125429 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2700 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6000677.56887 | 2117585.07036 | 37.7945220242189 | -122.441644420247 | (37.7945220242189, -122.441644420247) | 13 | 9 | 1 | 57 | 27 | |||
107655 | 125434 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1302 Columbus Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6007306.78534 | 2121812.18532 | 37.8065040857636 | -122.419006411423 | (37.8065040857636, -122.419006411423) | 5 | 1 | 1 | 28858 | 32 | ||||
109652 | 3510 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 201X Cargo Way | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/1990 12:00:00 AM | 12 | 3X3 | 6018015.12346 | 2098106.997 | 37.7420119463022 | -122.380299345034 | (37.7420119463022, -122.380299345034) | 10 | 3 | 8 | 58 | 1 | ||
110635 | 5518 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 849 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1998 12:00:00 AM | 9 | 4X4 | 6005079.63126 | 2103419.60056 | 37.7558769193029 | -122.425404164166 | (37.7558769193029, -122.425404164166) | 2 | 4 | 5 | 28859 | 19 | ||
112027 | 99507 | Undocumented 4 | Aesculus x carnea :: Red Horse Chestnut 267 | 2828 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000030 | 2117468 | 37.7941636633745 | -122.443876667305 | (37.7941636633745, -122.443876667305) | 13 | 9 | 1 | 57 | 27 | ||||
114367 | 3483 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 301X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | 3 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
118709 | 220581 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2080 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007873.20348 | 2106220.08996 | 37.7637238567005 | -122.415941360002 | (37.7637238567005, -122.415941360002) | 8 | 4 | 7 | 28859 | 19 | |||
120385 | 220584 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 3823 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003420.93714 | 2105922.01919 | 37.7626541086221 | -122.431319088 | (37.7626541086221, -122.431319088) | 15 | 4 | 5 | 28862 | 3 | |||
122183 | 220561 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 199 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005127.30767 | 2103971.92079 | 37.7573961548348 | -122.425278584639 | (37.7573961548348, -122.425278584639) | 2 | 4 | 5 | 28859 | 19 | |||
122645 | 3699 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 401X Cargo Way | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016428.13019 | 2099338.24362 | 37.7453050064279 | -122.3858725148 | (37.7453050064279, -122.3858725148) | 10 | 3 | 8 | 58 | 1 | |||
125969 | 125432 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2700 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000671.91395 | 2117623.1086 | 37.7946261450435 | -122.441666718049 | (37.7946261450435, -122.441666718049) | 13 | 9 | 1 | 57 | 27 | |||
127175 | 5677 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 1466 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2010 12:00:00 AM | 3 | 3X3 | 6005192.4040865 | 2099806.5348922 | 37.7459626476718 | -122.424757135148 | (37.7459626476718, -122.424757135148) | 2 | 7 | 5 | 63 | 22 | ||
131251 | 5535 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 900X Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6X6 | 6005026.93997 | 2102900.52226 | 37.7544486744687 | -122.425549446969 | (37.7544486744687, -122.425549446969) | 2 | 4 | 5 | 28862 | 22 | |||
133815 | 220587 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 574 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002918.27043 | 2108919.45183 | 37.7708558276618 | -122.433271821959 | (37.7708558276618, -122.433271821959) | 15 | 5 | 11 | 29492 | 9 | |||
134739 | 5652 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1328 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/05/2004 12:00:00 AM | 8 | 4X4 | 6005154.95046 | 2100611.44692 | 37.7481706358831 | -122.424943901953 | (37.7481706358831, -122.424943901953) | 2 | 4 | 5 | 63 | 22 | ||
134817 | 47515 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 200 Santa Rosa Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45391 | 6001209.62107748 | 2093323.4940375 | 37.7279359754206 | -122.438064719936 | (37.7279359754206, -122.438064719936) | 9 | 7 | 6 | 28861 | 25 | ||
134872 | 5815 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1466X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1998 12:00:00 AM | 14 | 3X3 | 6005195.19449 | 2099842.55873 | 37.7460617184842 | -122.424750048586 | (37.7460617184842, -122.424750048586) | 2 | 7 | 5 | 63 | 22 | ||
137176 | 3502 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 201X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/1998 12:00:00 AM | 3 | 3X3 | 6017776.09784 | 2098280.32735 | 37.7424746852726 | -122.381137876511 | (37.7424746852726, -122.381137876511) | 10 | 3 | 8 | 58 | 1 | ||
140360 | 220563 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 180 Fair Oaks St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005403.99517 | 2102602.99511 | 37.7536530316709 | -122.424224331908 | (37.7536530316709, -122.424224331908) | 2 | 4 | 5 | 28859 | 19 | |||
140474 | 125428 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2928 Vallejo St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 4ft | 5999973.68437 | 2117464.48653 | 37.7941508038799 | -122.444071272288 | (37.7941508038799, -122.444071272288) | 13 | 9 | 1 | 57 | 27 | |||
142503 | 5403 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 372 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/1999 12:00:00 AM | 8 | 3X3 | 6004842.3599 | 2106185.15313 | 37.7634570647172 | -122.426421630165 | (37.7634570647172, -122.426421630165) | 8 | 4 | 5 | 28859 | 3 | ||
144159 | 5634 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1257 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1997 12:00:00 AM | 18 | 3X3 | 6005215.51559 | 2101038.93229 | 37.749347833153 | -122.424764876613 | (37.749347833153, -122.424764876613) | 2 | 4 | 5 | 28859 | 19 | ||
144809 | 220564 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 367 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004224.93101 | 2106773.34876 | 37.7650371870506 | -122.428599048923 | (37.7650371870506, -122.428599048923) | 8 | 4 | 5 | 28862 | 3 | |||
146777 | 3476 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 301X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/1999 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
148375 | 5456 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 573 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x4 | 6004993.16703 | 2105051.33829 | 37.7603524017606 | -122.425819327205 | (37.7603524017606, -122.425819327205) | 2 | 4 | 5 | 28859 | 19 | |||
151407 | 125424 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2190 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999755.54002 | 2120902.07303 | 37.8035770523872 | -122.445073321194 | (37.8035770523872, -122.445073321194) | 13 | 9 | 1 | 57 | 17 | |||
151551 | 3512 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 201X Cargo Way | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018049.38641 | 2098082.73153 | 37.741947208609 | -122.380179187546 | (37.741947208609, -122.380179187546) | 10 | 3 | 8 | 58 | 1 | |||
152779 | 220557 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 420 Dolores St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004878.61123 | 2105553.35269 | 37.7617243400403 | -122.426251264381 | (37.7617243400403, -122.426251264381) | 8 | 4 | 5 | 28862 | 3 | |||
155553 | 5747 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1765 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1996 12:00:00 AM | 20 | 3X3 | 6005375.85282 | 2098122.03474 | 37.7413477528889 | -122.424003025841 | (37.7413477528889, -122.424003025841) | 2 | 7 | 5 | 28859 | 7 | ||
156311 | 5641 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1284 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/1997 12:00:00 AM | 12 | 3X2 | 6005137.94606 | 2100872.53029 | 37.7488865501777 | -122.425021276032 | (37.7488865501777, -122.425021276032) | 2 | 4 | 5 | 28862 | 22 | ||
156615 | 32077 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 3827 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 8 | Permit Number 35450 | 6003391.4377 | 2105919.76676 | 37.7626462521437 | -122.431420955128 | (37.7626462521437, -122.431420955128) | 15 | 4 | 5 | 28862 | 3 | |
158910 | 220570 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 126 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005060.58541 | 2099334.96401 | 37.744660375968 | -122.425179397529 | (37.744660375968, -122.425179397529) | 2 | 7 | 5 | 63 | 22 | |||
161837 | 99506 | Undocumented 4 | Aesculus x carnea :: Red Horse Chestnut 267 | 2828 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000030 | 2117468 | 37.7941636633745 | -122.443876667305 | (37.7941636633745, -122.443876667305) | 13 | 9 | 1 | 57 | 27 | ||||
162184 | 81672 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 17 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50248 | 6006951.93475538 | 2100077.40806786 | 37.7468056256291 | -122.418692108599 | (37.7468056256291, -122.418692108599) | 2 | 7 | 7 | 28859 | 2 | ||
163547 | 3520 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 201X Cargo Way | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/1990 12:00:00 AM | 6 | 3X3 | 6018169.02375 | 2097993.05748 | 37.7417075815435 | -122.379759286875 | (37.7417075815435, -122.379759286875) | 10 | 3 | 8 | 58 | 1 | ||
164789 | 175150 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 141 Goethe St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5994849.69598 | 2086516.03158 | 37.708880557851 | -122.459558163573 | (37.708880557851, -122.459558163573) | 9 | 8 | 6 | 28861 | 25 | |||
167320 | 125430 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 2700 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000675.19389 | 2117597.66288 | 37.7945564646566 | -122.441653542082 | (37.7945564646566, -122.441653542082) | 13 | 9 | 1 | 57 | 27 | |||
167595 | 5547 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 945 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/1989 12:00:00 AM | 8 | 3X3 | 6005116.50636 | 2102823.73281 | 37.7542428889218 | -122.425234239062 | (37.7542428889218, -122.425234239062) | 2 | 4 | 5 | 28859 | 19 | ||
167724 | 189151 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 351 Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017468.01148 | 2098526.96006 | 37.7431348775871 | -122.382220312235 | (37.7431348775871, -122.382220312235) | 10 | 3 | 8 | 58 | 1 | |||
168130 | 3490 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 301X Cargo Way | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/1996 12:00:00 AM | 3 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
169405 | 1557 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 545 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2017 12:00:00 AM | 8 | 3X3 | 5995578.89655 | 2112509.35885 | 37.7802936727782 | -122.458918678629 | (37.7802936727782, -122.458918678629) | 11 | 6 | 2 | 54 | 11 | ||
169560 | 220580 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 3496X 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006502.60842 | 2101457.78327 | 37.750570513641 | -122.420343797747 | (37.750570513641, -122.420343797747) | 2 | 4 | 7 | 28859 | 19 | |||
170427 | 220558 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 100 Alemany Blvd | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6009447.19791 | 2095939.14037 | 37.7355830167279 | -122.409771634864 | (37.7355830167279, -122.409771634864) | 10 | 7 | 7 | 28859 | 2 |
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) );