Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qCaretaker
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5893 | 5893 | 46201 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 6305 | 6305 | 52146 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2005 12:00:00 AM | Permit Number 48337 | ||||||||
| 9250 | 9250 | 46200 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 11507 | 11507 | 30593 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 13405 | 13405 | 30592 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 103749 | 103749 | 69409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 990 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33514 | 6001528.72905075 | 2086815.30428152 | 37.710084087104896 | -122.43649593455099 | (37.7100840871049, -122.436495934551) | ||
| 65491 | 65491 | 69396 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 7 | Permit Number 33500 | 6001570.284530001 | 2087031.2786 | 37.7106794663567 | -122.436367757869 | (37.7106794663567, -122.436367757869) | |
| 128591 | 128591 | 69392 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1139 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33495 | 6001921.70531705 | 2087676.61824048 | 37.71247138896779 | -122.435199299374 | (37.7124713889678, -122.435199299374) | ||
| 119086 | 119086 | 69400 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33504 | 6001338.55016435 | 2087735.88894959 | 37.7126010005012 | -122.437219100024 | (37.7126010005012, -122.437219100024) | ||
| 78598 | 78598 | 69390 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | ||
| 119517 | 119517 | 69412 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 411 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33517 | 6002045.14092784 | 2087792.75766672 | 37.712797291006495 | -122.434780968582 | (37.7127972910065, -122.434780968582) | ||
| 172968 | 172968 | 39937 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 327 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50713 | 6009355.370709999 | 2088298.86848 | 37.7145992918994 | -122.40955005091499 | (37.7145992918994, -122.409550050915) | |
| 18016 | 18016 | 49368 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.40492785111799 | (37.7149060701976, -122.404927851118) | |||
| 157228 | 157228 | 39955 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 9 | Permit Number 41217 | 6009804.77414 | 2088411.3721599998 | 37.7149333756547 | -122.408004652316 | (37.7149333756547, -122.408004652316) | |
| 97120 | 97120 | 31159 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 159 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34861 | 5992168.57477518 | 2088923.19870563 | 37.7153355266741 | -122.46899947505 | (37.7153355266741, -122.46899947505) | ||
| 92856 | 92856 | 35042 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 158 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/1998 12:00:00 AM | Permit Number 38609 | 5996885.33354798 | 2089115.06440217 | 37.7161337438742 | -122.45271020646099 | (37.7161337438742, -122.452710206461) | ||
| 110528 | 110528 | 82705 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52460 | 6012945.60921507 | 2089212.94135713 | 37.7173096765194 | -122.397204701992 | (37.7173096765194, -122.397204701992) | ||
| 91753 | 91753 | 88469 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 921 Ingerson Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51423 | 6014544.1 | 2089500.7 | 37.7181886666833 | -122.39169953123199 | (37.7181886666833, -122.391699531232) | |||
| 158714 | 158714 | 35136 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 714 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 13 | Permit Number 38666 | 6002360.3768 | 2089504.48193 | 37.7175152006551 | -122.43381368236 | (37.7175152006551, -122.43381368236) | |
| 91690 | 91690 | 85246 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | Permit Number 49547 | 6001091.3 | 2089693.7 | 37.717962654310206 | -122.43821383738899 | (37.7179626543102, -122.438213837389) | |||
| 123540 | 123540 | 41462 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 454 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | Permit Number 42047 | 5993018.04440435 | 2090196.48136289 | 37.718880698161605 | -122.46615583377199 | (37.7188806981616, -122.466155833772) | |||
| 126104 | 126104 | 41461 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 460 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | Permit Number 42046 | 5993018.50469486 | 2090233.49581681 | 37.7189823574514 | -122.46615693113701 | (37.7189823574514, -122.466156931137) | |||
| 114914 | 114914 | 86713 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 938 Garfield St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2007 12:00:00 AM | Permit Number 49699 | 5991527.0 | 2090568.7 | 37.7198165808065 | -122.47133684225099 | (37.7198165808065, -122.471336842251) | ||||
| 105821 | 105821 | 36824 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49072 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 47669 | 47669 | 36825 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 5 | Permit Number 49072 | 6014545.9992 | 2090648.9983 | 37.721341772631895 | -122.39177321286199 | (37.7213417726319, -122.391773212862) | |
| 104090 | 104090 | 87073 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 110241 | 110241 | 87072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 18932 | 18932 | 30938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1106 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 8 | 3x3 | Permit Number 772469 | 5995956.71997 | 2091289.90864 | 37.722052099618104 | -122.456077064214 | (37.7220520996181, -122.456077064214) | |
| 148251 | 148251 | 55344 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1518 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/1972 12:00:00 AM | 11 | Permit Number 11275 | 6007044.75091 | 2091766.9119900002 | 37.723992057772 | -122.417782186794 | (37.723992057772, -122.417782186794) | ||
| 91771 | 91771 | 65172 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 332 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 27153 | 6003474.08618593 | 2091790.3446491002 | 37.72385481082 | -122.430127080192 | (37.72385481082, -122.430127080192) | ||
| 107246 | 107246 | 38191 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 642 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42701 | 6011185.93624372 | 2091843.1881073 | 37.7244336742141 | -122.403472045096 | (37.7244336742141, -122.403472045096) | ||
| 98228 | 98228 | 83904 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50528 | 6000071.45882216 | 2091861.79510204 | 37.7238576929528 | -122.441894497682 | (37.7238576929528, -122.441894497682) | ||
| 41799 | 41799 | 46849 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44917 | 6003953.72556 | 2091952.73307 | 37.724327847540295 | -122.42848061451201 | (37.7243278475403, -122.428480614512) | |
| 27408 | 27408 | 85487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010399.4592 | 2092794.41628 | 37.727001587734605 | -122.40625779115801 | (37.7270015877346, -122.406257791158) | ||
| 174554 | 174554 | 85486 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010415.33133 | 2092799.63405 | 37.7270168024731 | -122.406203288666 | (37.7270168024731, -122.406203288666) | ||
| 149179 | 149179 | 85485 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010430.57281 | 2092804.2489200002 | 37.72703032647411 | -122.40615092385299 | (37.7270303264741, -122.406150923853) | ||
| 75609 | 75609 | 38463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1998 12:00:00 AM | 4 | Permit Number 40473 | 6017671.3057 | 2092861.7612 | 37.727590590458604 | -122.38112356357 | (37.7275905904586, -122.38112356357) | ||
| 63414 | 63414 | 49886 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59@ WILDWOOD Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | |||
| 66013 | 66013 | 36339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | ||
| 88425 | 88425 | 49885 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59@ WILDWOOD Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | |||
| 74292 | 74292 | 54817 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1414 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49953 | 6015568.3491 | 2093032.3958 | 37.7279428116622 | -122.388405474303 | (37.7279428116622, -122.388405474303) | |
| 84861 | 84861 | 53148 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1499@ LANE Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | Permit Number 49076 | 6015286.17606683 | 2093519.24782482 | 37.7292639697355 | -122.389414946979 | (37.7292639697355, -122.389414946979) | |||
| 126794 | 126794 | 53150 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1499@ LANE Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | Permit Number 49076 | 6015286.17606683 | 2093519.24782482 | 37.7292639697355 | -122.389414946979 | (37.7292639697355, -122.389414946979) | |||
| 108331 | 108331 | 1688 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 19 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1993 12:00:00 AM | 6 | 3X3 | 6017679.592279 | 2093598.3775556 | 37.7296136527509 | -122.381146110708 | (37.7296136527509, -122.381146110708) | ||
| 122622 | 122622 | 1699 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 42 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1999 12:00:00 AM | 3 | 3X3 | 6017775.3254178 | 2093648.0174938 | 37.7297552383916 | -122.380818597255 | (37.7297552383916, -122.380818597255) | ||
| 3099 | 3099 | 197138 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2617 Quint St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 6 | Width 3ft | Permit Number 51436 | 6011420.8914 | 2093882.2827299999 | 37.7300457263229 | -122.402803173234 | (37.7300457263229, -122.402803173234) | |
| 80946 | 80946 | 88494 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2617 Quint St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51436 | 6011452.0 | 2093927.0 | 37.7301702475564 | -122.402698769845 | (37.7301702475564, -122.402698769845) | |||
| 130064 | 130064 | 52155 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1431 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 8 | Permit Number 48347 | 6016125.1581 | 2093936.3843 | 37.7304558237734 | -122.386543560163 | (37.7304558237734, -122.386543560163) | |
| 60896 | 60896 | 50021 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 137@ FELTON Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 8 | Permit Number 46755 | 6010268.64963 | 2093971.7239700002 | 37.730226909139105 | -122.406792936365 | (37.7302269091391, -122.406792936365) | |
| 162145 | 162145 | 60407 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1430 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 6 | Permit Number 19988 | 6016156.6712 | 2093985.1354 | 37.7305914290757 | -122.38643801167801 | (37.7305914290757, -122.386438011678) | |
| 130726 | 130726 | 60409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1448 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52503 | 6016089.8742 | 2094040.62 | 37.73074008090121 | -122.38667280863399 | (37.7307400809012, -122.386672808634) | |
| 32007 | 32007 | 83299 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52357 | 6014332.78372 | 2094054.3132099998 | 37.7306802456855 | -122.39274835074801 | (37.7306802456855, -122.392748350748) | |
| 103247 | 103247 | 68832 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32783 | 5999773.2281789 | 2094096.14609893 | 37.7299757052964 | -122.443085818741 | (37.7299757052964, -122.443085818741) | ||
| 174429 | 174429 | 35739 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 378 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | 9 | Permit Number 39013 | 6008634.39829 | 2094282.55173 | 37.7309887985962 | -122.41246474286999 | (37.7309887985962, -122.41246474287) | |
| 149171 | 149171 | 42714 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 419 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 11 | Permit Number 42727 | 6013037.066980001 | 2094313.85012 | 37.731320830081 | -122.39724606626301 | (37.731320830081, -122.397246066263) | |
| 36878 | 36878 | 81916 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52300 | 6013111.49661 | 2094334.1897900002 | 37.731380822071706 | -122.396990173153 | (37.7313808220717, -122.396990173153) | |
| 30146 | 30146 | 44337 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1386 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2001 12:00:00 AM | 10 | Permit Number 43722 | 6016111.020719999 | 2094370.93672 | 37.7316482354559 | -122.386622725671 | (37.7316482354559, -122.386622725671) | ||
| 129006 | 129006 | 68466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 60 Badger St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32328 | 6002354.04049623 | 2094409.88800929 | 37.7309839839817 | -122.434186069273 | (37.7309839839817, -122.434186069273) | ||
| 80568 | 80568 | 68465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 56 Badger St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32327 | 6002348.42397311 | 2094432.09629198 | 37.731044644088605 | -122.43420707357201 | (37.7310446440886, -122.434207073572) | ||
| 97041 | 97041 | 68464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 52 Badger St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32326 | 6002331.05144197 | 2094486.37219697 | 37.7311926873179 | -122.434271012127 | (37.7311926873179, -122.434271012127) | ||
| 66931 | 66931 | 38591 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1615 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | Permit Number 40546 | 6015135.7246 | 2094671.1157 | 37.7324184244611 | -122.390015508372 | (37.7324184244611, -122.390015508372) | |
| 84924 | 84924 | 88489 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 87921 | 87921 | 88492 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 90200 | 90200 | 88490 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 111056 | 111056 | 88488 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 117423 | 117423 | 88487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 145425 | 145425 | 88491 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 70015 | 70015 | 39981 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 45 Bay View St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 6 | Permit Number 41239 | 6014242.19126 | 2094737.80253 | 37.7325519363025 | -122.39310935121999 | (37.7325519363025, -122.39310935122) | |
| 87293 | 87293 | 52908 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 295 Gaven St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 3x3 | Permit Number 48898 | 6009070.24444642 | 2094849.33610342 | 37.732569516932294 | -122.41099796146001 | (37.7325695169323, -122.41099796146) | ||
| 95224 | 95224 | 52907 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 295 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 3x3 | Permit Number 48898 | 6009070.24444642 | 2094849.33610342 | 37.732569516932294 | -122.41099796146001 | (37.7325695169323, -122.41099796146) | ||
| 106468 | 106468 | 52905 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 295 Gaven St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 3x3 | Permit Number 48898 | 6009070.24444642 | 2094849.33610342 | 37.732569516932294 | -122.41099796146001 | (37.7325695169323, -122.41099796146) | ||
| 111046 | 111046 | 52906 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 295 Gaven St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 3x3 | Permit Number 48898 | 6009070.24444642 | 2094849.33610342 | 37.732569516932294 | -122.41099796146001 | (37.7325695169323, -122.41099796146) | ||
| 102319 | 102319 | 97759 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1699X Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014853.3 | 2094854.4 | 37.7329060184543 | -122.391004730192 | (37.7329060184543, -122.391004730192) | |||
| 96831 | 96831 | 94879 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 83 Ledyard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767655 | 6011819.0 | 2094865.0 | 37.7327662839989 | -122.40149589318399 | (37.7327662839989, -122.401495893184) |
| 9202 | 9202 | 1709 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 7X Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2006 12:00:00 AM | 5 | 3x3 | 6016610.521033701 | 2095134.7434862 | 37.7337731370994 | -122.384949031469 | (37.7337731370994, -122.384949031469) | ||
| 13371 | 13371 | 24145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016696.89665 | 2095171.76192 | 37.7338795595807 | -122.384652980151 | (37.7338795595807, -122.384652980151) | |||
| 118962 | 118962 | 51439 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 779 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47759 | 6007378.77949872 | 2095187.90508456 | 37.7334041569913 | -122.416869758383 | (37.7334041569913, -122.416869758383) | |||
| 123178 | 123178 | 51440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 779 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47759 | 6007378.77949872 | 2095187.90508456 | 37.7334041569913 | -122.416869758383 | (37.7334041569913, -122.416869758383) | |||
| 14904 | 14904 | 24147 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | |||
| 45610 | 45610 | 42453 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 550 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51619 | 5997786.60898589 | 2095288.02825485 | 37.7331348573333 | -122.45003964005 | (37.7331348573333, -122.45003964005) | ||
| 91340 | 91340 | 96161 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767793 | 6003680.0 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | |
| 109804 | 109804 | 86842 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49782 | 6008646.4 | 2095435.0 | 37.7341538468062 | -122.41250468368901 | (37.7341538468062, -122.412504683689) | |||
| 27085 | 27085 | 87158 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50139 | 6011083.99361 | 2095446.91838 | 37.7343230701451 | -122.404077946949 | (37.7343230701451, -122.404077946949) | |
| 85981 | 85981 | 86840 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 320 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49780 | 6008706.2 | 2095448.4 | 37.734193996145 | -122.41229888228001 | (37.734193996145, -122.41229888228) | |||
| 123996 | 123996 | 88467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176.0 | 2095454.0 | 37.7343476550611 | -122.40376034751101 | (37.7343476550611, -122.403760347511) | |||
| 95922 | 95922 | 86841 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 322 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49781 | 6008668.1 | 2095458.9 | 37.734220688835 | -122.412431348478 | (37.734220688835, -122.412431348478) | |||
| 79618 | 79618 | 86844 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 97062 | 97062 | 86846 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 110087 | 110087 | 86843 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 115259 | 115259 | 86845 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 16006 | 16006 | 11463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | ||
| 13377 | 13377 | 10610 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 29 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6016939.384330001 | 2095525.0457799998 | 37.7348630141201 | -122.38383920883801 | (37.7348630141201, -122.383839208838) | ||
| 14701 | 14701 | 11464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.858519999 | 2095545.6720200002 | 37.734911327499205 | -122.384361070118 | (37.7349113274992, -122.384361070118) | ||
| 14099 | 14099 | 11466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.967569999 | 2095560.66167 | 37.73495227093311 | -122.384375566285 | (37.7349522709331, -122.384375566285) | ||
| 13999 | 13999 | 10614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2001 12:00:00 AM | 3 | 3X3 | 6016916.49156 | 2095577.9947400002 | 37.7350071358711 | -122.383922043589 | (37.7350071358711, -122.383922043589) | ||
| 9296 | 9296 | 11461 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 41X HAWKINS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1992 12:00:00 AM | 12 | 3X3 | 6016935.0 | 2095578.0 | 37.7350081734808 | -122.38385805308201 | (37.7350081734808, -122.383858053082) | ||
| 9083 | 9083 | 10613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.501807599 | 2095595.9312573997 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | ||
| 14147 | 14147 | 11467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 8 | 3X3 | 6016799.4589 | 2095596.1573400002 | 37.7350505362442 | -122.384327935502 | (37.7350505362442, -122.384327935502) | ||
| 9321 | 9321 | 11465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016782.5188136 | 2095601.0665952999 | 37.7350630793796 | -122.384386845805 | (37.7350630793796, -122.384386845805) | ||
| 15074 | 15074 | 11468 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 6 | 3X3 | 6016817.53474 | 2095601.45988 | 37.735066095427705 | -122.384265809434 | (37.7350660954277, -122.384265809434) |
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");