Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4012 | 4012 | 252965 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:04:00 PM | 3 | ||||||||
| 4061 | 4061 | 252970 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 12:21:00 PM | 3 | ||||||||
| 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 | |||||||||
| 9603 | 9603 | 19972 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 36 | ||||||||
| 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 | ||||||||
| 179770 | 179770 | 71586 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994945.16185 | 2086428.98532 | 37.7086470380903 | -122.459221923276 | (37.7086470380903, -122.459221923276) | ||
| 167538 | 167538 | 179336 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 225 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6002643.14283 | 2086748.99011 | 37.709965266168105 | -122.43263957156 | (37.7099652661681, -122.43263957156) | |||
| 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) | ||
| 162050 | 162050 | 179330 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001459.59412 | 2086865.7197599998 | 37.71021858809021 | -122.43673848451999 | (37.7102185880902, -122.43673848452) | |||
| 161987 | 161987 | 179331 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001453.95042 | 2086881.4918 | 37.7102615738952 | -122.43675911853501 | (37.7102615738952, -122.436759118535) | |||
| 172017 | 172017 | 179332 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001443.39306 | 2086909.8506099998 | 37.7103388409345 | -122.43679763560301 | (37.7103388409345, -122.436797635603) | |||
| 180272 | 180272 | 179333 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001438.26403 | 2086921.6489 | 37.710370944937104 | -122.436816206603 | (37.7103709449371, -122.436816206603) | |||
| 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) | |
| 12987 | 12987 | 1848 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011043.028059999 | 2086938.1542099998 | 37.7109574665846 | -122.403621108454 | (37.7109574665846, -122.403621108454) | |||
| 3987 | 3987 | 159341 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 40 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:44:00 PM | 3 | Width 0ft | 5998211.297780001 | 2087238.08175 | 37.7110558677139 | -122.44799199802799 | (37.7110558677139, -122.447991998028) | ||
| 3419 | 3419 | 252969 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998180.94106 | 2087280.50358 | 37.711170613109104 | -122.448099970249 | (37.7111706131091, -122.448099970249) | |||||
| 4074 | 4074 | 252967 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:55:00 PM | 3 | 5998144.81293 | 2087318.48212 | 37.7112728281964 | -122.448227570418 | (37.7112728281964, -122.448227570418) | |||
| 4111 | 4111 | 159295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 118 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:16:00 PM | 3 | Width 0ft | 5998136.03876 | 2087321.1199900003 | 37.7112795695727 | -122.448258085851 | (37.7112795695727, -122.448258085851) | ||
| 4066 | 4066 | 252966 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:19:00 PM | 3 | 5998135.7809 | 2087327.97675 | 37.7112983819328 | -122.448259470506 | (37.7112983819328, -122.448259470506) | |||
| 4050 | 4050 | 159297 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:53:00 PM | 3 | Width 0ft | 5998096.339240001 | 2087362.0634299999 | 37.711389721237104 | -122.448398243388 | (37.7113897212371, -122.448398243388) | ||
| 4003 | 4003 | 159298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:11:00 PM | 3 | Width 0ft | 5998090.67137 | 2087368.5047400002 | 37.711407083550704 | -122.448418296488 | (37.7114070835507, -122.448418296488) | ||
| 65822 | 65822 | 74096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1994 12:00:00 AM | 10 | 6001902.78384 | 2087667.7277099998 | 37.712445903022704 | -122.435264062185 | (37.7124459030227, -122.435264062185) | ||
| 3425 | 3425 | 159220 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 372 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998655.59562 | 2087744.29121 | 37.71247119106079 | -122.446492798529 | (37.7124711910608, -122.446492798529) | |||
| 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) | ||
| 165666 | 165666 | 179334 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6001947.96661 | 2087712.00011 | 37.7125700310481 | -122.43511106143801 | (37.7125700310481, -122.435111061438) | |||
| 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) | ||
| 171035 | 171035 | 179335 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6001959.57443 | 2087726.76645 | 37.7126112352992 | -122.435071996701 | (37.7126112352992, -122.435071996701) | |||
| 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) | ||
| 3492 | 3492 | 159213 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Ellington Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998902.8056 | 2087977.93006 | 37.7131268274265 | -122.445655159179 | (37.7131268274265, -122.445655159179) | |||
| 59671 | 59671 | 213985 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 431 Capitol Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995022.34889 | 2088455.31671 | 37.714215306566 | -122.45910178282301 | (37.714215306566, -122.459101782823) | |||
| 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) | |
| 150336 | 150336 | 213982 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Lobos St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994935.45629 | 2088691.9546700001 | 37.714860062915 | -122.459419242599 | (37.714860062915, -122.459419242599) | |||
| 66294 | 66294 | 213983 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Lobos St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994955.32932 | 2088691.9508900002 | 37.7148611951615 | -122.45935055329201 | (37.7148611951615, -122.459350553292) | |||
| 135664 | 135664 | 213984 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Lobos St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994978.50476 | 2088691.4656200001 | 37.7148611951759 | -122.459270414704 | (37.7148611951759, -122.459270414704) | |||
| 78764 | 78764 | 111862 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 201x LOBOS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5994528.0 | 2088713.0 | 37.714894412350205 | -122.460829096166 | (37.7148944123502, -122.460829096166) | ||||
| 88644 | 88644 | 111861 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5994528.0 | 2088713.0 | 37.714894412350205 | -122.460829096166 | (37.7148944123502, -122.460829096166) | ||||
| 104395 | 104395 | 111863 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 201x LOBOS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5994528.0 | 2088713.0 | 37.714894412350205 | -122.460829096166 | (37.7148944123502, -122.460829096166) | ||||
| 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) | ||
| 174826 | 174826 | 213987 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5996535.27353 | 2089022.9105 | 37.7158606459376 | -122.45391352290599 | (37.7158606459376, -122.453913522906) | |||
| 149382 | 149382 | 213986 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5996577.00096 | 2089023.1695 | 37.7158637494767 | -122.45376931301399 | (37.7158637494767, -122.453769313014) | |||
| 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) | ||
| 62359 | 62359 | 197142 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012879.123819999 | 2089210.84364 | 37.717300215014205 | -122.39743436542601 | (37.7173002150142, -122.397434365426) | |||
| 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) | ||
| 165811 | 165811 | 197143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012876.3937800005 | 2089220.9678099998 | 37.717327861958296 | -122.397444511578 | (37.7173278619583, -122.397444511578) | |||
| 39419 | 39419 | 197144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.717368885441395 | -122.397447893917 | (37.7173688854414, -122.397447893917) | |||
| 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) | |||
| 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) | |||
| 70939 | 70939 | 200236 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 921 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014551.0541 | 2089524.7802 | 37.718255172199896 | -122.39167717639299 | (37.7182551721999, -122.391677176393) | |||
| 135080 | 135080 | 69741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6010157.175969999 | 2089735.57492 | 37.7185890892048 | -122.40687987112601 | (37.7185890892048, -122.406879871126) | ||
| 118181 | 118181 | 179285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010162.36149 | 2089750.0772799999 | 37.7186291998585 | -122.40686296837099 | (37.7186291998585, -122.406862968371) | |||
| 62088 | 62088 | 213946 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996526.79114 | 2090102.3106200001 | 37.718823939946795 | -122.454020752656 | (37.7188239399468, -122.454020752656) | |||
| 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) | |||
| 69823 | 69823 | 213978 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 250 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994758.88079 | 2090253.13715 | 37.7191365451831 | -122.460142594324 | (37.7191365451831, -122.460142594324) | |||
| 188252 | 188252 | 213979 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 254 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994759.40129 | 2090277.98422 | 37.719204799252296 | -122.46014259431999 | (37.7192047992523, -122.46014259432) | |||
| 42220 | 42220 | 213980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 258 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994759.30681 | 2090307.0454 | 37.7192845888893 | -122.460145025196 | (37.7192845888893, -122.460145025196) | |||
| 22361 | 22361 | 213977 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994717.86147 | 2090376.1855099997 | 37.719472047173205 | -122.460293291905 | (37.7194720471732, -122.460293291905) | |||
| 110346 | 110346 | 114383 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 418X SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 138436 | 138436 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 418X SERRANO DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 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) | ||||
| 25291 | 25291 | 179283 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 126 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004517.28509 | 2090394.86473 | 37.7200821580385 | -122.426421596896 | (37.7200821580385, -122.426421596896) | |||
| 50254 | 50254 | 213950 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995061.44128 | 2090626.04133 | 37.720177849497794 | -122.459123753274 | (37.7201778494978, -122.459123753274) | |||
| 81776 | 81776 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 93217 | 93217 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 164333 | 164333 | 213951 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 319 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994724.0479999995 | 2090709.9007700002 | 37.7203887054465 | -122.460296073498 | (37.7203887054465, -122.460296073498) | |||
| 186437 | 186437 | 71320 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | 6004289.26563 | 2090538.0021799998 | 37.720462289783896 | -122.42721997362601 | (37.7204622897839, -122.427219973626) | ||
| 160941 | 160941 | 213952 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994769.73406 | 2090948.84155 | 37.72104740759529 | -122.460155454611 | (37.7210474075953, -122.460155454611) | |||
| 151351 | 151351 | 213953 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994770.431919999 | 2090973.1015700002 | 37.7211140599462 | -122.460154799032 | (37.7211140599462, -122.460154799032) | |||
| 124104 | 124104 | 213976 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995023.46765 | 2090970.5982400002 | 37.7211217374705 | -122.459279952923 | (37.7211217374705, -122.459279952923) | |||
| 177196 | 177196 | 213954 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994772.0848 | 2091005.96515 | 37.721204390545104 | -122.460151465241 | (37.7212043905451, -122.460151465241) | |||
| 59382 | 59382 | 213975 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995024.51997 | 2091003.2487299999 | 37.7212114484221 | -122.45927867859501 | (37.7212114484221, -122.459278678595) | |||
| 33788 | 33788 | 213974 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995026.3935 | 2091022.299 | 37.7212638636298 | -122.459273581222 | (37.7212638636298, -122.459273581222) | |||
| 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) | ||
| 174480 | 174480 | 213955 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994772.87853 | 2091030.08167 | 37.721270654392 | -122.460150467873 | (37.721270654392, -122.460150467873) | |||
| 36604 | 36604 | 213973 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995027.24606 | 2091045.4090900002 | 37.721327367434604 | -122.459272306869 | (37.7213273674346, -122.459272306869) | |||
| 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) | |
| 44482 | 44482 | 213956 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994772.08022 | 2091060.8394799998 | 37.7213550620588 | -122.46015545460699 | (37.7213550620588, -122.460155454607) | |||
| 177551 | 177551 | 213972 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995029.65711 | 2091072.52436 | 37.721401958108295 | -122.459265935174 | (37.7214019581083, -122.459265935174) | |||
| 159725 | 159725 | 213957 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994771.7805 | 2091087.8520099998 | 37.7214292147603 | -122.460158446674 | (37.7214292147603, -122.460158446674) | |||
| 29544 | 29544 | 213971 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.07265 | 2091112.6142099998 | 37.7215118291791 | -122.459281227253 | (37.7215118291791, -122.459281227253) | |||
| 66368 | 66368 | 213958 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5994774.32905 | 2091126.87145 | 37.721536499390105 | -122.460152462564 | (37.7215364993901, -122.460152462564) | |||
| 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) | |||
| 186622 | 186622 | 213959 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994775.57323 | 2091144.94508 | 37.721586196813995 | -122.460149470543 | (37.721586196814, -122.460149470543) | |||
| 71421 | 71421 | 213970 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995027.09423 | 2091143.79671 | 37.721597507607996 | -122.45927995292699 | (37.721597507608, -122.459279952927) | |||
| 28648 | 28648 | 213960 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994774.81066 | 2091163.6355700002 | 37.7216374725616 | -122.460153459937 | (37.7216374725616, -122.460153459937) | |||
| 69936 | 69936 | 213969 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995027.18674 | 2091165.82123 | 37.7216579869959 | -122.459281227274 | (37.7216579869959, -122.459281227274) | |||
| 152237 | 152237 | 213961 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994775.27388 | 2091185.74798 | 37.7216982145873 | -122.460153459921 | (37.7216982145873, -122.460153459921) | |||
| 172877 | 172877 | 213968 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.496169999 | 2091185.65951 | 37.7217124184688 | -122.459285050266 | (37.7217124184688, -122.459285050266) | |||
| 152806 | 152806 | 213966 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994898.75092 | 2091213.04066 | 37.72178025523171 | -122.459728611213 | (37.7217802552317, -122.459728611213) | |||
| 44594 | 44594 | 213965 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994879.14088 | 2091213.45138 | 37.721780255249904 | -122.459796427288 | (37.7217802552499, -122.459796427288) | |||
| 184348 | 184348 | 213962 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994792.34345 | 2091215.55668 | 37.7217810439445 | -122.460096613778 | (37.7217810439445, -122.460096613778) | |||
| 154173 | 154173 | 213963 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994830.12755 | 2091215.05246 | 37.7217818326369 | -122.45996596837 | (37.7217818326369, -122.45996596837) |
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");