trees
1,985 rows where qSpecies_id = 83 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||
45556 | 82630 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 160 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52216 | 6006410.24181442 | 2106937.54473832 | 37.7656114605169 | -122.421052246328 | (37.7656114605169, -122.421052246328) | 8 | 4 | 7 | 28853 | 19 | ||
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 | |||
54495 | 239273 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007374.78459 | 2107260.91087 | 37.7665536733524 | -122.417739020247 | (37.7665536733524, -122.417739020247) | 8 | 4 | 7 | 28853 | 19 | |||
55096 | 239276 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 313 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007404.6677 | 2107881.43658 | 37.7682591728601 | -122.41767964611 | (37.7682591728601, -122.41767964611) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |
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 | |
65118 | 91691 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 301-307 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007391.961989 | 2107907.789584 | 37.7683308170236 | -122.417725462175 | (37.7683308170236, -122.417725462175) | 8 | 4 | 7 | 28853 | 19 |
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 | ||
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 | |||
69329 | 239275 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 313 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007408.18179 | 2107851.42826 | 37.7681769748154 | -122.417665363987 | (37.7681769748154, -122.417665363987) | 8 | 4 | 7 | 28853 | 19 | |||
70363 | 111480 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | |||
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 |
72471 | 239266 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 181 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6007450.5138 | 2107918.29571 | 37.7683629591168 | -122.417523681168 | (37.7683629591168, -122.417523681168) | 8 | 4 | 7 | 28853 | 19 | |||
74916 | 108404 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 181-199 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007385 | 2107936 | 37.7684078844101 | -122.41775154294 | (37.7684078844101, -122.41775154294) | 8 | 4 | 7 | 28853 | 19 |
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 | ||
79497 | 239269 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 27 Woodward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006491.50571 | 2108328.68595 | 37.7694357855487 | -122.420869947001 | (37.7694357855487, -122.420869947001) | 8 | 4 | 7 | 28853 | 19 | |||
80492 | 197075 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 375 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010369.64742 | 2106560.63537 | 37.7647989539274 | -122.407330899099 | (37.7647989539274, -122.407330899099) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
84929 | 239263 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1511 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007270.56824 | 2107323.19533 | 37.7667188266493 | -122.418103903074 | (37.7667188266493, -122.418103903074) | 8 | 4 | 7 | 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 | |
87164 | 197073 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2310 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010516.44047 | 2106481.63446 | 37.7645902500634 | -122.406817609258 | (37.7645902500634, -122.406817609258) | 8 | 4 | 8 | 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 | |
88399 | 239265 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 153 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 6006453.3259 | 2106969.77306 | 37.7657023804906 | -122.420905516077 | (37.7657023804906, -122.420905516077) | 8 | 4 | 7 | 28853 | 19 | |||
88746 | 111484 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 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 | |||
97134 | 239271 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007373.17462 | 2107313.63566 | 37.7666983526646 | -122.417748326439 | (37.7666983526646, -122.417748326439) | 8 | 4 | 7 | 28853 | 19 | |||
97698 | 239267 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 174 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007529.81177 | 2107967.97324 | 37.7685038235247 | -122.417252916882 | (37.7685038235247, -122.417252916882) | 8 | 4 | 7 | 28853 | 19 | |||
111847 | 111483 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | ||||
112393 | 111488 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | ||||
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 | ||
121924 | 197071 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2300 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010571.86967 | 2106484.77334 | 37.7646019700183 | -122.406626114813 | (37.7646019700183, -122.406626114813) | 8 | 4 | 8 | 28853 | 19 | |||
124624 | 239262 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1515 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007244.80682 | 2107321.61346 | 37.7667130332001 | -122.41819289551 | (37.7667130332001, -122.41819289551) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |
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 |
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 | ||||
136090 | 239270 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007357.25381 | 2107576.0791 | 37.7674180648107 | -122.417821998892 | (37.7674180648107, -122.417821998892) | 8 | 4 | 7 | 28853 | 19 | |||
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 | ||
143035 | 108403 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 301-307 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007391.32185 | 2107918.98153 | 37.7683615114513 | -122.417728469751 | (37.7683615114513, -122.417728469751) | 8 | 4 | 7 | 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 | ||
145895 | 111487 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | ||||
149949 | 111485 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | ||||
150089 | 197072 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2300 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010557.18002 | 2106482.58278 | 37.7645951333716 | -122.406676768239 | (37.7645951333716, -122.406676768239) | 8 | 4 | 8 | 28853 | 19 | |||
153546 | 239274 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007375.13668 | 2107234.3347 | 37.7664807212325 | -122.417735918497 | (37.7664807212325, -122.417735918497) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |
164069 | 239264 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 160 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006412.02807 | 2106950.63266 | 37.7656474975546 | -122.42104699742 | (37.7656474975546, -122.42104699742) | 8 | 4 | 7 | 28853 | 19 | |||
164269 | 197074 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2310 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010495.70996 | 2106480.98982 | 37.7645873200617 | -122.406889265436 | (37.7645873200617, -122.406889265436) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
168471 | 111489 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 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 |
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 | ||
191475 | 31193 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 218 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34886 | 6011113.20919467 | 2107342.89093281 | 37.7669884386727 | -122.40481417533 | (37.7669884386727, -122.40481417533) | 8 | 2 | 8 | 28853 | 19 | |||
193678 | 239272 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007373.32106 | 2107298.89674 | 37.7666578912871 | -122.417746775107 | (37.7666578912871, -122.417746775107) | 8 | 4 | 7 | 28853 | 19 | |||
140115 | 94205 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 225 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 3 | 4 diameter | Permit Number 53606 | 6012323.95366 | 2116081.4267 | 37.7910500439823 | -122.401240507665 | (37.7910500439823, -122.401240507665) | 4 | 1 | 10 | 28854 | 6 | |
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 | |||
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 | |||
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 | |||
6409 | 61556 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2098X 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/25/1984 12:00:00 AM | Permit Number 21516 | 6012360 | 2102825 | 37.7546529200548 | -122.400184359163 | (37.7546529200548, -122.400184359163) | 10 | 3 | 8 | 28856 | 29 | ||
7485 | 61793 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2104 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 14 | Permit Number 21816 | 6012153.01638 | 2102841.49501 | 37.7546866683749 | -122.400901327432 | (37.7546866683749, -122.400901327432) | 10 | 3 | 8 | 28856 | 29 | |
9648 | 72127 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012120.03521 | 2102839.43148 | 37.7546791626274 | -122.401015240957 | (37.7546791626274, -122.401015240957) | 10 | 3 | 8 | 28856 | 29 | |||
10955 | 116918 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
13015 | 61560 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2117 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 9 | Permit Number 21520 | 6012109.3133 | 2102790.69622 | 37.7545447481545 | -122.401048896306 | (37.7545447481545, -122.401048896306) | 10 | 3 | 8 | 28856 | 29 | |
13308 | 74007 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2030 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012344.40813 | 2102849.33443 | 37.7547188676881 | -122.40023998939 | (37.7547188676881, -122.40023998939) | 10 | 3 | 8 | 28856 | 29 | ||
15461 | 197112 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2051 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012308.80023 | 2102801.31444 | 37.7545850296985 | -122.400359759302 | (37.7545850296985, -122.400359759302) | 10 | 3 | 8 | 28856 | 29 | |||
19055 | 61576 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2019 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 7 | Permit Number 21538 | 6012377.33608 | 2102802.45934 | 37.754591994948 | -122.400122823023 | (37.754591994948, -122.400122823023) | 10 | 3 | 8 | 28856 | 29 | |
20465 | 193326 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1398 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015584.37458 | 2102621.55349 | 37.754273559383 | -122.389019303814 | (37.754273559383, -122.389019303814) | 10 | 3 | 8 | 28856 | 29 | |||
20596 | 197113 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2030 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012295.98887 | 2102846.65042 | 37.7547087979762 | -122.400407248893 | (37.7547087979762, -122.400407248893) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
25494 | 48801 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
25557 | 197109 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012049.36164 | 2105557.39202 | 37.7621381396801 | -122.401450654931 | (37.7621381396801, -122.401450654931) | 10 | 3 | 8 | 28856 | 29 | ||||
26416 | 48800 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
26571 | 150167 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 333 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779492 | 6014367.55242 | 2105483.96934 | 37.7620656102492 | -122.393427719319 | (37.7620656102492, -122.393427719319) | 10 | 3 | 8 | 28856 | 29 | |
28541 | 51529 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 846 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47831 | 6013038.03413 | 2103130.63922 | 37.7555299221754 | -122.397860957035 | (37.7555299221754, -122.397860957035) | 10 | 3 | 8 | 28856 | 29 | ||
31005 | 94179 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 603 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53587 | 6010992.28107 | 2105475.07827 | 37.7618530869812 | -122.405100914986 | (37.7618530869812, -122.405100914986) | 10 | 3 | 8 | 28856 | 29 | |
31675 | 197094 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014478.47867 | 2102089.91001 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | 10 | 3 | 8 | 28856 | 29 | |||
32999 | 48812 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.05373 | 2102353.10418 | 37.7534744568981 | -122.392864530587 | (37.7534744568981, -122.392864530587) | 10 | 3 | 8 | 28856 | 29 | ||
33554 | 197092 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | 10 | 3 | 8 | 28856 | 29 | |||
34480 | 197115 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1231 Rhode Island St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011991.85547 | 2102642.48446 | 37.7541312380906 | -122.401444683423 | (37.7541312380906, -122.401444683423) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
35353 | 197076 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6014915.77906 | 2102946.70504 | 37.7551292724085 | -122.391354222641 | (37.7551292724085, -122.391354222641) | 10 | 3 | 8 | 28856 | 29 | |||
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 |
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) );