Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2490 | 2490 | 119764 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2496 | 2496 | 119765 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2509 | 2509 | 119763 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
| 68024 | 68024 | 69158 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1287 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33194 | 5983034.7903 | 2106354.2675 | 37.7626645218276 | -122.501858295829 | (37.7626645218276, -122.501858295829) | |
| 9538 | 9538 | 24790 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7600X Geary Blvd To Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | 5983417.22641 | 2112490.7888700003 | 37.7795361021078 | -122.500989471143 | (37.7795361021078, -122.500989471143) | |||
| 2146 | 2146 | 87638 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7600 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5983555.0 | 2112529.0 | 37.779649107322506 | -122.50051568716002 | (37.7796491073225, -122.50051568716) | |||
| 186899 | 186899 | 50249 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1379 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 4 | Permit Number 46954 | 5985223.881 | 2105833.3788 | 37.761362655281296 | -122.49424873007 | (37.7613626552813, -122.49424873007) | |
| 61507 | 61507 | 182341 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3061 Kirkham St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985341.2243 | 2104975.4085 | 37.7590137734629 | -122.49377966796301 | (37.7590137734629, -122.493779667963) | |||
| 156445 | 156445 | 182236 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1422 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985589.87 | 2105519.0471 | 37.7605209981924 | -122.49295979089399 | (37.7605209981924, -122.492959790894) | |||
| 89653 | 89653 | 40856 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 539 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/1999 12:00:00 AM | Permit Number 41780 | 5985623.89484129 | 2112222.70100433 | 37.77892933008471 | -122.49333601508499 | (37.7789293300847, -122.493336015085) | |||
| 153301 | 153301 | 44183 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 523 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2000 12:00:00 AM | 4 | Permit Number 43645 | 5985624.48707 | 2112294.40068 | 37.7791262314693 | -122.493339250227 | (37.7791262314693, -122.493339250227) | ||
| 130537 | 130537 | 185054 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2779 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985836.7248 | 2096507.7341 | 37.735792809146204 | -122.49144275752501 | (37.7357928091462, -122.491442757525) | |||
| 109557 | 109557 | 41632 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 233 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42112 | 5985857.93299624 | 2114290.75052478 | 37.7846212855735 | -122.492678748494 | (37.7846212855735, -122.492678748494) | |||
| 65380 | 65380 | 185613 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2130 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5986374.9693 | 2100740.6968 | 37.747446833767796 | -122.489893086864 | (37.7474468337678, -122.489893086864) | |||
| 65131 | 65131 | 48994 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2418 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2002 12:00:00 AM | 3 | Permit Number 46181 | 5986497.397999999 | 2102350.7408 | 37.75187472720871 | -122.48958812016501 | (37.7518747272087, -122.489588120165) | ||
| 46168 | 46168 | 182759 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1760 31st Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986602.0349 | 2103247.8223 | 37.754343977501996 | -122.489292227735 | (37.754343977502, -122.489292227735) | |||
| 48135 | 48135 | 107707 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1798X 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5986607.5742 | 2103075.1785 | 37.75387026798779 | -122.48926037902599 | (37.7538702679878, -122.489260379026) | |||
| 148281 | 148281 | 250908 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 279 29th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986800.41209 | 2114076.10104 | 37.784086983657495 | -122.48940234284201 | (37.7840869836575, -122.489402342842) | |||
| 173824 | 173824 | 250907 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 279 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986800.59954 | 2114084.91795 | 37.7841112033057 | -122.489402342861 | (37.7841112033057, -122.489402342861) | |||
| 30561 | 30561 | 182746 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1779 30th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986859.1028 | 2103189.8409 | 37.754199778911 | -122.488398972402 | (37.754199778911, -122.488398972402) | |||
| 154219 | 154219 | 182747 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1781 30th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986861.2313 | 2103167.7322 | 37.7541391986218 | -122.488389986917 | (37.7541391986218, -122.488389986917) | |||
| 37223 | 37223 | 182750 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1795 30th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986862.6162 | 2103105.8758 | 37.7539694385611 | -122.488380652039 | (37.7539694385611, -122.488380652039) | |||
| 45845 | 45845 | 182751 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1799 30th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986864.4626 | 2103079.1022 | 37.753896033260396 | -122.48837229934601 | (37.7538960332604, -122.488372299346) | |||
| 172395 | 172395 | 250329 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 155 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5987389.94758 | 2114941.60729 | 37.786497813367205 | -122.487426387523 | (37.7864978133672, -122.487426387523) | |||
| 133832 | 133832 | 250330 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 155 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987390.3046699995 | 2114925.65751 | 37.7864540406708 | -122.48742398005501 | (37.7864540406708, -122.487423980055) | |||
| 151887 | 151887 | 185774 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2117 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987449.7004 | 2102326.4388 | 37.7518635518625 | -122.48629318373001 | (37.7518635518625, -122.48629318373) | |||
| 30784 | 30784 | 185775 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2115 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987466.6042 | 2102326.9841 | 37.7518660343399 | -122.48623476881399 | (37.7518660343399, -122.486234768814) | |||
| 19058 | 19058 | 93046 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 155 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5987682.5 | 2114946.6 | 37.7865285787391 | -122.48641460847601 | (37.7865285787391, -122.486414608476) | |||
| 121208 | 121208 | 89634 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3449X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5987884.67819 | 2111856.5842 | 37.7780560543276 | -122.485488287229 | (37.7780560543276, -122.485488287229) | ||
| 83839 | 83839 | 89635 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3449X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5987898.67965 | 2111857.1365799997 | 37.7780583867443 | -122.485439892315 | (37.7780583867443, -122.485439892315) | ||
| 123677 | 123677 | 89636 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3449X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5987913.1749599995 | 2111856.82902 | 37.778058386758794 | -122.48538972589701 | (37.7780583867588, -122.485389725897) | ||
| 86854 | 86854 | 89637 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3449X Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5987925.96134 | 2111856.3878200003 | 37.7780579202566 | -122.485345461397 | (37.7780579202566, -122.485345461397) | ||
| 22377 | 22377 | 9193 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 6137 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5987931.1239 | 2112533.881 | 37.77991842635 | -122.485377329982 | (37.77991842635, -122.485377329982) | ||
| 146219 | 146219 | 89638 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3449X Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5987937.00601 | 2111858.00138 | 37.7780629940654 | -122.485307372834 | (37.7780629940654, -122.485307372834) | ||
| 114638 | 114638 | 89457 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3436 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5987944.64094 | 2111914.04856 | 37.7782173286312 | -122.48528507483499 | (37.7782173286312, -122.485285074835) | ||
| 103430 | 103430 | 89639 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3429 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5987995.44369 | 2111858.48145 | 37.7780677163882 | -122.485105253696 | (37.7780677163882, -122.485105253696) | ||
| 56109 | 56109 | 42286 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1926 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50494 | 5987996.0839 | 2102403.744 | 37.7521076422463 | -122.484409406352 | (37.7521076422463, -122.484409406352) | |
| 100464 | 100464 | 90489 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 157 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2014 11:55:00 AM | 3 | 3x3 | 5988004.43303 | 2114943.08312 | 37.7865376821644 | -122.485300555524 | (37.7865376821644, -122.485300555524) | ||
| 110246 | 110246 | 89456 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3400 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988004.60259 | 2111915.96252 | 37.778226076744794 | -122.48507778860201 | (37.7782260767448, -122.485077788602) | ||
| 91460 | 91460 | 89455 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3400 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988025.86388 | 2111917.24947 | 37.7782308487839 | -122.485004333373 | (37.7782308487839, -122.485004333373) | ||
| 123510 | 123510 | 90495 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 301 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988041.80411 | 2113895.78877 | 37.783664287063296 | -122.485094393953 | (37.7836642870633, -122.485094393953) | ||
| 126730 | 126730 | 90496 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 301 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988042.96777 | 2113876.52916 | 37.783611473426106 | -122.48508895463999 | (37.7836114734261, -122.48508895464) | ||
| 101799 | 101799 | 90498 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 323 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988044.12043 | 2113803.81454 | 37.78341188686421 | -122.485079630129 | (37.7834118868642, -122.485079630129) | ||
| 107756 | 107756 | 90499 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 331 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988047.65256 | 2113726.79985 | 37.7832006321241 | -122.485061758165 | (37.7832006321241, -122.485061758165) | ||
| 4894 | 4894 | 90500 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 339 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/21/2016 12:00:00 AM | 3 | 3x3 | 5988049.93279 | 2113689.95178 | 37.783099590598 | -122.48505116522 | (37.783099590598, -122.48505116522) | ||
| 113445 | 113445 | 89454 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3400 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988065.727080001 | 2111917.8522099997 | 37.7782348255831 | -122.48486647790001 | (37.7782348255831, -122.4848664779) | ||
| 74094 | 74094 | 51002 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 403 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 4 | Permit Number 47482 | 5988066.53789 | 2113228.70309 | 37.781834099579 | -122.48495986854601 | (37.781834099579, -122.484959868546) | ||
| 83550 | 83550 | 90501 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 379 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/24/2015 01:10:00 PM | 3 | 3x3 | 5988067.184968 | 2113447.23729 | 37.782434170308 | -122.48497366779101 | (37.782434170308, -122.484973667791) | |
| 92903 | 92903 | 90503 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 423 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988071.70858 | 2113105.61871 | 37.7814964458606 | -122.484932947848 | (37.7814964458606, -122.484932947848) | ||
| 129439 | 129439 | 90486 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988073.188490001 | 2114585.7900099996 | 37.7855606623303 | -122.48503645801 | (37.7855606623303, -122.48503645801) | ||
| 91715 | 91715 | 90504 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 441 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988075.13836 | 2112980.21272 | 37.7811523162322 | -122.484911879632 | (37.7811523162322, -122.484911879632) | ||
| 114069 | 114069 | 90505 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 471 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988080.65939 | 2112825.78639 | 37.7807286267232 | -122.48488144743 | (37.7807286267232, -122.48488144743) | ||
| 54814 | 54814 | 95915 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1900 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767613 | 5988090.4089 | 2102404.3375 | 37.7521147639454 | -122.484083263842 | (37.7521147639454, -122.484083263842) |
| 94034 | 94034 | 90476 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 308 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988097.24041 | 2113893.73619 | 37.7836618802654 | -122.4849024572 | (37.7836618802654, -122.4849024572) | ||
| 101476 | 101476 | 90475 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 312 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988099.18114 | 2113866.7587900003 | 37.783587921018096 | -122.484893763307 | (37.7835879210181, -122.484893763307) | ||
| 120778 | 120778 | 90477 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 334 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988102.89809 | 2113735.3844 | 37.7832274207041 | -122.48487126320299 | (37.7832274207041, -122.484871263203) | ||
| 89753 | 89753 | 90478 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 346 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988106.65438 | 2113654.64286 | 37.7830059461076 | -122.484852342891 | (37.7830059461076, -122.484852342891) | ||
| 106930 | 106930 | 90479 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 378 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988113.78121 | 2113447.0957299997 | 37.7824364955772 | -122.484812456806 | (37.7824364955772, -122.484812456806) | ||
| 43706 | 43706 | 120216 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 382 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5988115.4379 | 2113385.82786 | 37.7822683678417 | -122.48480222947501 | (37.7822683678417, -122.484802229475) | |||
| 123803 | 123803 | 90512 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 601X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988116.27135 | 2111840.86835 | 37.778026393270395 | -122.48468598029899 | (37.7780263932704, -122.484685980299) | ||
| 126243 | 126243 | 90513 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 601X 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988116.28811 | 2111825.706 | 37.7779847626929 | -122.484684809804 | (37.7779847626929, -122.484684809804) | ||
| 141962 | 141962 | 90514 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 601X 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988117.8745 | 2111804.78254 | 37.7779274051371 | -122.484677786761 | (37.7779274051371, -122.484677786761) | ||
| 90696 | 90696 | 90516 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 609 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988118.9534599995 | 2111759.94748 | 37.7778043634905 | -122.48467076462099 | (37.7778043634905, -122.484670764621) | ||
| 79630 | 79630 | 90515 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 609 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988119.00098 | 2111778.14101 | 37.777854320582 | -122.48467193514799 | (37.777854320582, -122.484671935148) | ||
| 40209 | 40209 | 80574 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 619 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2002 12:00:00 AM | 3 | 5988121.26409 | 2111709.35839 | 37.777665594619 | -122.484659059603 | (37.777665594619, -122.484659059603) | ||
| 119687 | 119687 | 90518 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 621 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988122.30979 | 2111694.84803 | 37.7776258141426 | -122.48465437756 | (37.7776258141426, -122.48465437756) | ||
| 105770 | 105770 | 90519 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 635 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988122.90302 | 2111627.11146 | 37.777439863081206 | -122.484647355443 | (37.7774398630812, -122.484647355443) | ||
| 90835 | 90835 | 90474 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 400 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988124.36514 | 2113165.58152 | 37.7816641536353 | -122.484755183813 | (37.7816641536353, -122.484755183813) | ||
| 96340 | 96340 | 90520 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 643 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988125.87832 | 2111559.99835 | 37.7772557625831 | -122.484632138864 | (37.7772557625831, -122.484632138864) | ||
| 139649 | 139649 | 90473 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 432 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988127.90004 | 2113074.39224 | 37.78141397952329 | -122.484736263494 | (37.7814139795233, -122.484736263494) | ||
| 79230 | 79230 | 90521 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 657 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988129.58694 | 2111495.56459 | 37.7770790615264 | -122.484614582192 | (37.7770790615264, -122.484614582192) | ||
| 143231 | 143231 | 90522 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 665 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988130.3137 | 2111450.06285 | 37.7769541688304 | -122.484608729675 | (37.7769541688304, -122.484608729675) | ||
| 121903 | 121903 | 90523 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 685 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988134.30019 | 2111345.82297 | 37.7766681874923 | -122.484587291379 | (37.7766681874923, -122.484587291379) | ||
| 104857 | 104857 | 90524 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 689 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988134.37855 | 2111320.8303 | 37.7765995691866 | -122.484585186635 | (37.7765995691866, -122.484585186635) | ||
| 48377 | 48377 | 90525 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 693 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988135.49867 | 2111294.7552799997 | 37.776528039717 | -122.484579398781 | (37.776528039717, -122.484579398781) | ||
| 99888 | 99888 | 90472 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 466 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988137.12208 | 2112840.15355 | 37.780771363323495 | -122.48468717235599 | (37.7807713633235, -122.484687172356) | ||
| 116756 | 116756 | 90467 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 600 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988175.18575 | 2111777.29511 | 37.7778552698833 | -122.484477512762 | (37.7778552698833, -122.484477512762) | ||
| 69269 | 69269 | 90466 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 600 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988176.49909 | 2111762.5469 | 37.7778148519169 | -122.484471887506 | (37.7778148519169, -122.484471887506) | ||
| 86123 | 86123 | 90465 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 636 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988181.594769999 | 2111626.42264 | 37.777441389623796 | -122.484444273303 | (37.7774413896238, -122.484444273303) | ||
| 128345 | 128345 | 90464 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 668 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988187.4453 | 2111428.30837 | 37.7768977640601 | -122.484409500406 | (37.7768977640601, -122.484409500406) | ||
| 113432 | 113432 | 90463 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 672 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5988188.12056 | 2111411.3653599997 | 37.7768512826224 | -122.484405921528 | (37.7768512826224, -122.484405921528) | ||
| 20489 | 20489 | 96596 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3342 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988207.53014 | 2111924.69302 | 37.7782618665825 | -122.48437643702499 | (37.7782618665825, -122.484376437025) | ||
| 108973 | 108973 | 89453 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3342 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988224.70868 | 2111925.48746 | 37.7782650481644 | -122.484317069146 | (37.7782650481644, -122.484317069146) | ||
| 108372 | 108372 | 90917 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3342 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988262.25204 | 2111926.42905 | 37.778269819478396 | -122.484187263511 | (37.7782698194784, -122.484187263511) | ||
| 118243 | 118243 | 89642 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3333 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5988267.77031 | 2111868.1655599996 | 37.7781101655798 | -122.484163900121 | (37.7781101655798, -122.484163900121) | ||
| 80389 | 80389 | 90916 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3342 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988281.76291 | 2111927.4637 | 37.778273796306 | -122.48411984494899 | (37.778273796306, -122.484119844949) | ||
| 141557 | 141557 | 89643 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3315 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5988331.89397 | 2111871.06257 | 37.7781218531992 | -122.483942288438 | (37.7781218531992, -122.483942288438) | ||
| 79442 | 79442 | 90927 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3309 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988374.16306 | 2111873.0452900003 | 37.7781297578465 | -122.483796211577 | (37.7781297578465, -122.483796211577) | ||
| 75519 | 75519 | 93689 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52753 | 5988641.89 | 2097990.3646 | 37.7400272520846 | -122.481852887106 | (37.7400272520846, -122.481852887106) | |
| 165891 | 165891 | 93690 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52753 | 5988641.89 | 2098003.3381 | 37.7400628739271 | -122.481853837176 | (37.7400628739271, -122.481853837176) | |
| 148158 | 148158 | 93702 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52753 | 5988642.9279 | 2097975.5749 | 37.7399867037902 | -122.481848215448 | (37.7399867037902, -122.481848215448) | |
| 137190 | 137190 | 93687 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52753 | 5988644.4847 | 2097906.556 | 37.739797286447896 | -122.481837778425 | (37.7397972864479, -122.481837778425) | |
| 70670 | 70670 | 93700 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52753 | 5988645.7821 | 2097896.1772 | 37.739768864422494 | -122.481832532572 | (37.7397688644225, -122.481832532572) | |
| 167667 | 167667 | 93685 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52753 | 5988645.7821 | 2097885.02 | 37.7397382296637 | -122.481831715525 | (37.7397382296637, -122.481831715525) | |
| 45173 | 45173 | 93684 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52753 | 5988646.5605 | 2097872.306 | 37.7397033656059 | -122.48182809312999 | (37.7397033656059, -122.48182809313) | |
| 35399 | 35399 | 93697 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52753 | 5988648.6362 | 2097799.1356 | 37.739502579493205 | -122.481815558076 | (37.7395025794932, -122.481815558076) | |
| 31467 | 31467 | 93680 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52753 | 5988650.712 | 2097745.6849 | 37.739355938531105 | -122.481804466798 | (37.7393559385311, -122.481804466798) | |
| 163642 | 163642 | 93682 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52753 | 5988650.9715 | 2097783.5674 | 37.7394599690849 | -122.481806343675 | (37.7394599690849, -122.481806343675) | |
| 156835 | 156835 | 93693 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52753 | 5988651.4904 | 2097731.4141 | 37.7393167999034 | -122.481800730432 | (37.7393167999034, -122.481800730432) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");