trees
1,985 rows where qSpecies_id = 83 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▲ | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
2453 | 49617 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
8128 | 90393 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007146.175112 | 2109626.370927 | 37.7730357998282 | -122.418697508419 | (37.7730357998282, -122.418697508419) | 8 | 2 | 9 | 28853 | 19 | ||
9559 | 90383 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
12199 | 30624 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1655 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 7 | Permit Number 35324 | 6008124.7709 | 2108587.5084 | 37.7702383761626 | -122.41523885993 | (37.7702383761626, -122.41523885993) | 8 | 2 | 9 | 28853 | 19 | |
23362 | 93821 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
25420 | 30655 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 35 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.7731639163293 | -122.417349579607 | (37.7731639163293, -122.417349579607) | 8 | 2 | 9 | 28853 | 19 |
26265 | 120516 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
34547 | 93825 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
35420 | 93812 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
39932 | 49616 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
40700 | 30616 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1621 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 7 | Permit Number 34577 | 6008176.3922 | 2108702.7792 | 37.7705577837388 | -122.415068461945 | (37.7705577837388, -122.415068461945) | 8 | 2 | 9 | 28853 | 19 | |
41531 | 30628 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008014.7624 | 2108466.4739 | 37.7698998606983 | -122.415610809035 | (37.7698998606983, -122.415610809035) | 8 | 2 | 9 | 28853 | 19 | |
43433 | 120515 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
44419 | 42167 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 525 05th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 14 | Permit Number 42460 | 6012577.4664 | 2111216.9324 | 37.7777074143023 | -122.400021595319 | (37.7777074143023, -122.400021595319) | 6 | 2 | 9 | 28856 | 34 | ||
44864 | 90394 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 314 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 6008277.004378 | 2108757.643904 | 37.770714082787 | -122.41472432574 | (37.770714082787, -122.41472432574) | 8 | 2 | 9 | 28853 | 19 | ||
52287 | 93818 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
52869 | 30620 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1645 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 9 | Permit Number 34580 | 6008131.7874 | 2108606.0519 | 37.7702896865902 | -122.415215902671 | (37.7702896865902, -122.415215902671) | 8 | 2 | 9 | 28853 | 19 | |
53261 | 49614 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
53695 | 42170 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 525 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 12 | Permit Number 42460 | 6012634.74531 | 2111162.8232 | 37.7775620361946 | -122.399819646269 | (37.7775620361946, -122.399819646269) | 6 | 2 | 9 | 28856 | 34 | ||
58952 | 30634 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008069.1402 | 2108631.1108 | 37.7703549714818 | -122.415434374116 | (37.7703549714818, -122.415434374116) | 8 | 2 | 9 | 28853 | 19 | |
63861 | 93819 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
64761 | 30627 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008040.0718 | 2108546.913 | 37.770122150229 | -122.415528959959 | (37.770122150229, -122.415528959959) | 8 | 2 | 9 | 28853 | 19 | |
65262 | 93820 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
67048 | 90388 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
67141 | 29137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 90x Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6009115.3969879 | 2112842.7343052 | 37.7819778479132 | -122.412113051935 | (37.7819778479132, -122.412113051935) | 14 | 10 | 9 | 28852 | 36 | ||
68224 | 49615 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
68591 | 93828 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
70430 | 142788 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | 7 | 9 | 9 | 28858 | 36 | ||
71126 | 30636 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47466 | 6008078.6625 | 2108652.1603 | 37.7704133036734 | -122.4154029268 | (37.7704133036734, -122.4154029268) | 8 | 2 | 9 | 28853 | 19 |
72781 | 93822 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
77054 | 67883 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | ||
80050 | 93817 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
83899 | 49612 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
85449 | 85551 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 288 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 3 | 6008109.65239 | 2108844.36385 | 37.7709427912139 | -122.415309340752 | (37.7709427912139, -122.415309340752) | 8 | 2 | 9 | 28853 | 19 | |||
85625 | 30637 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008025.7883 | 2108500.0528 | 37.7699926802506 | -122.415575048334 | (37.7699926802506, -122.415575048334) | 8 | 2 | 9 | 28853 | 19 | |
87410 | 30626 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 769481 | 6008034.8095 | 2108530.1235 | 37.7700757544141 | -122.415545973379 | (37.7700757544141, -122.415545973379) | 8 | 2 | 9 | 28853 | 19 | |
88112 | 30635 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008075.6555 | 2108643.1391 | 37.7703883645671 | -122.415412689299 | (37.7703883645671, -122.415412689299) | 8 | 2 | 9 | 28853 | 19 | |
88987 | 30618 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1645 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 5 | Permit Number 34580 | 6008139.305 | 2108622.0896 | 37.7703341448356 | -122.415191034666 | (37.7703341448356, -122.415191034666) | 8 | 2 | 9 | 28853 | 19 | |
92738 | 49613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
103131 | 249400 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 230 Hyde St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6008085.57169 | 2113256.87585 | 37.7830571448252 | -122.415705117997 | (37.7830571448252, -122.415705117997) | 7 | 10 | 9 | 28852 | 36 | |||
103416 | 93827 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
112271 | 93826 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
115469 | 93829 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
120221 | 30615 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34576 | 6008169.65081501 | 2108823.23186566 | 37.7708881396338 | -122.415100307898 | (37.7708881396338, -122.415100307898) | 8 | 2 | 9 | 28853 | 19 | ||
125017 | 93815 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
125777 | 30638 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008054.606 | 2108589.5131 | 37.7702399370436 | -122.415481702601 | (37.7702399370436, -122.415481702601) | 8 | 2 | 9 | 28853 | 19 | |
127187 | 249399 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 222 Hyde St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6008090.57738 | 2113215.48771 | 37.7829437843643 | -122.41568486887 | (37.7829437843643, -122.41568486887) | 7 | 10 | 9 | 28852 | 36 | |||
128309 | 90391 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 74 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007027.339502 | 2109746.308859 | 37.7733584293936 | -122.419117085527 | (37.7733584293936, -122.419117085527) | 8 | 2 | 9 | 28853 | 19 | ||
130521 | 30657 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 35 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.7731639163293 | -122.417349579607 | (37.7731639163293, -122.417349579607) | 8 | 2 | 9 | 28853 | 19 |
131983 | 93816 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
132092 | 90384 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
133422 | 90390 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 68 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006999.109217 | 2109777.167755 | 37.7734415707499 | -122.419216927652 | (37.7734415707499, -122.419216927652) | 8 | 2 | 9 | 28853 | 19 | ||
133573 | 30631 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008010.753 | 2108447.9304 | 37.7698487192253 | -122.415623364383 | (37.7698487192253, -122.415623364383) | 8 | 2 | 9 | 28853 | 19 | |
134947 | 112164 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 701 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011822 | 2114512 | 37.7867127527861 | -122.4028668317 | (37.7867127527861, -122.4028668317) | 12 | 2 | 9 | 28853 | 6 | ||||
140003 | 30525 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.413624143987 | (37.7811193385199, -122.413624143987) | 7 | 10 | 9 | 28852 | 36 | |
140812 | 90392 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6007146.175112 | 2109626.370927 | 37.7730357998282 | -122.418697508419 | (37.7730357998282, -122.418697508419) | 8 | 2 | 9 | 28853 | 19 | ||
141214 | 90387 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2014 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
143139 | 24469 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 50X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2000 12:00:00 AM | 6 | 3x3 | 6006161.54315 | 2109606.56692 | 37.7729259368552 | -122.422102071167 | (37.7729259368552, -122.422102071167) | 7 | 2 | 9 | 28853 | 19 | ||
143955 | 197141 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 502 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015667.2078 | 2114177.54158 | 37.7860083618524 | -122.389539847588 | (37.7860083618524, -122.389539847588) | 6 | 2 | 9 | 28856 | 6 | |||
144409 | 42172 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 525 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 11 | Permit Number 42460 | 6012593.26461 | 2111204.07737 | 37.7776729981365 | -122.399966040597 | (37.7776729981365, -122.399966040597) | 6 | 2 | 9 | 28856 | 34 | ||
145649 | 93831 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
149974 | 42171 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 525 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 8 | Permit Number 42460 | 6012613.23479 | 2111182.92549 | 37.7776160332845 | -122.399895470812 | (37.7776160332845, -122.399895470812) | 6 | 2 | 9 | 28856 | 34 | ||
155639 | 93814 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
156125 | 30614 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34576 | 6008169.65081501 | 2108823.23186566 | 37.7708881396338 | -122.415100307898 | (37.7708881396338, -122.415100307898) | 8 | 2 | 9 | 28853 | 19 | ||
157649 | 30632 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008058.1142 | 2108604.0472 | 37.7702800414561 | -122.415470596847 | (37.7702800414561, -122.415470596847) | 8 | 2 | 9 | 28853 | 19 | |
160761 | 90382 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
161322 | 30617 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1625 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 5 | Permit Number 34579 | 6008161.858 | 2108672.7086 | 37.7704744001626 | -122.415116607184 | (37.7704744001626, -122.415116607184) | 8 | 2 | 9 | 28853 | 19 | |
162373 | 30629 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008019.273 | 2108482.0104 | 37.7699427738264 | -122.415596307092 | (37.7699427738264, -122.415596307092) | 8 | 2 | 9 | 28853 | 19 | |
163928 | 93813 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
167127 | 120517 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
168127 | 200945 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1620 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008108.7332 | 2108716.8122 | 37.7705925126951 | -122.415303489324 | (37.7705925126951, -122.415303489324) | 8 | 2 | 9 | 28853 | 19 | |||
177631 | 30656 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 35 Lafayette St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.7731639163293 | -122.417349579607 | (37.7731639163293, -122.417349579607) | 8 | 2 | 9 | 28853 | 19 |
178214 | 42169 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 525 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 9 | Permit Number 42460 | 6012658.26755 | 2111134.89994 | 37.7774866766072 | -122.399736313291 | (37.7774866766072, -122.399736313291) | 6 | 2 | 9 | 28856 | 34 | |
179186 | 42168 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 525 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 9 | Permit Number 42460 | 6012645.95751 | 2111148.54846 | 37.7775234660795 | -122.399779856677 | (37.7775234660795, -122.399779856677) | 6 | 2 | 9 | 28856 | 34 | ||
183359 | 93823 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
185707 | 30630 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008012.82240629 | 2108413.03711614 | 37.7697530267823 | -122.415613735449 | (37.7697530267823, -122.415613735449) | 8 | 4 | 9 | 28853 | 19 | |
189284 | 90389 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 68 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006999.109217 | 2109777.167755 | 37.7734415707499 | -122.419216927652 | (37.7734415707499, -122.419216927652) | 8 | 2 | 9 | 28853 | 19 | ||
191089 | 24470 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 50X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 16 | 3x3 | 6006161.54315 | 2109606.56692 | 37.7729259368552 | -122.422102071167 | (37.7729259368552, -122.422102071167) | 7 | 2 | 9 | 28853 | 19 | ||
192585 | 93830 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
193929 | 93824 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
328 | 197129 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Newhall St | 11 | : | Tree | Private 2 | 5 | Width 3ft | 6015974.4503 | 2097856.83037 | 37.7412122331485 | -122.387337958305 | (37.7412122331485, -122.387337958305) | 10 | 3 | 8 | 58 | 1 | |||
611 | 10613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.5018076 | 2095595.9312574 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | 10 | 3 | 8 | 58 | 1 | ||
670 | 197144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.7173688854414 | -122.397447893917 | (37.7173688854414, -122.397447893917) | 10 | 3 | 8 | 58 | 1 | |||
691 | 199940 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017562.0246 | 2092865.5482 | 37.7275949559017 | -122.381501616556 | (37.7275949559017, -122.381501616556) | 10 | 3 | 8 | 58 | 1 | |||
810 | 75303 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.406566076957 | (37.7648621726769, -122.406566076957) | 8 | 4 | 8 | 28853 | 19 | |||
971 | 16508 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 325 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016639.93914 | 2098306.03692 | 37.7424824967653 | -122.385068203435 | (37.7424824967653, -122.385068203435) | 10 | 3 | 8 | 58 | 1 | |||
1561 | 24107 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
1601 | 39981 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 45 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | 6 | Permit Number 41239 | 6014242.19126 | 2094737.80253 | 37.7325519363025 | -122.39310935122 | (37.7325519363025, -122.39310935122) | 10 | 3 | 8 | 58 | 1 | |
1758 | 73714 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012133.53509 | 2102840.64813 | 37.7546832563417 | -122.400968639917 | (37.7546832563417, -122.400968639917) | 10 | 3 | 8 | 28856 | 29 | |||
1933 | 193325 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1398 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015584.15702 | 2102639.39931 | 37.7543225481714 | -122.389021302106 | (37.7543225481714, -122.389021302106) | 10 | 3 | 8 | 28856 | 29 | |||
2621 | 202038 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 75 Crane St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6012275.87253 | 2090920.17769 | 37.7219600944649 | -122.399639484201 | (37.7219600944649, -122.399639484201) | 10 | 3 | 8 | 58 | 1 | |||
2641 | 262546 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Apollo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 6012643 | 2094250 | 37.731123564074 | -122.398603958182 | (37.731123564074, -122.398603958182) | 10 | 3 | 8 | 58 | 1 | |||
2819 | 70680 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) | 8 | 4 | 8 | 28853 | 19 | |||
3614 | 72128 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2012 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6012399.20292 | 2102851.6444 | 37.7547282656006 | -122.400050655116 | (37.7547282656006, -122.400050655116) | 10 | 3 | 8 | 28856 | 29 | |||
4044 | 11466 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.96757 | 2095560.66167 | 37.7349522709331 | -122.384375566285 | (37.7349522709331, -122.384375566285) | 10 | 3 | 8 | 58 | 1 | ||
5604 | 197168 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017908.19776 | 2093591.9406 | 37.729608594643 | -122.380355342249 | (37.729608594643, -122.380355342249) | 10 | 3 | 8 | 58 | 1 | |||
5684 | 83143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6016637.51216 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | 10 | 3 | 8 | 58 | 1 | |||
6129 | 85658 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1643 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015004.908 | 2094769.8823 | 37.7326823614983 | -122.3904746745 | (37.7326823614983, -122.3904746745) | 10 | 3 | 8 | 58 | 1 | ||
6142 | 73715 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2012 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012416.66148 | 2102853.00124 | 37.7547329645749 | -122.399990373555 | (37.7547329645749, -122.399990373555) | 10 | 3 | 8 | 28856 | 29 |
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) );