Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 147189 | 147189 | 213947 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995892.36071 | 2091233.5723299999 | 37.7218937190991 | -122.456295465473 | (37.7218937190991, -122.456295465473) | |||
| 47148 | 47148 | 72144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 5 | 6000049.527000001 | 2091859.62504 | 37.723850484693706 | -122.441970156497 | (37.7238504846937, -122.441970156497) | ||
| 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) | |
| 4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
| 161134 | 161134 | 199943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6017830.3585 | 2092664.2977 | 37.7270571724447 | -122.380559991407 | (37.7270571724447, -122.380559991407) | |||
| 170803 | 170803 | 179301 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 324 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003618.31142 | 2092719.8675400002 | 37.7264152414524 | -122.429694781997 | (37.7264152414524, -122.429694781997) | |||
| 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) | ||
| 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) | |
| 165380 | 165380 | 85614 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1200X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 5 | 3x3 | 6017331.5604 | 2093113.8652 | 37.728264058993396 | -122.382315610259 | (37.7282640589934, -122.382315610259) | ||
| 71297 | 71297 | 199665 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015244.0778 | 2093456.6965 | 37.729089882168395 | -122.389556118834 | (37.7290898821684, -122.389556118834) | |||
| 119496 | 119496 | 199666 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015268.2608 | 2093490.7724 | 37.72918478862329 | -122.389474894337 | (37.7291847886233, -122.389474894337) | |||
| 164981 | 164981 | 197167 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Baldwin Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6017931.28632 | 2093542.2184 | 37.729473341113895 | -122.380272067717 | (37.7294733411139, -122.380272067717) | |||
| 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) | |
| 181073 | 181073 | 78383 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | 6015869.5519 | 2094203.8416 | 37.7311760546893 | -122.387445886397 | (37.7311760546893, -122.387445886397) | ||
| 48741 | 48741 | 71411 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | ||
| 68096 | 68096 | 200038 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015316.6267 | 2094740.3159 | 37.7326184655785 | -122.38939491276501 | (37.7326184655785, -122.389394912765) | |||
| 163220 | 163220 | 200741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014891.7516 | 2094855.5671 | 37.7329113566731 | -122.39087187355699 | (37.7329113566731, -122.390871873557) | |||
| 76235 | 76235 | 179325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009883.98076 | 2094924.5226900002 | 37.7328215611604 | -122.408189966611 | (37.7328215611604, -122.408189966611) | |||
| 180761 | 180761 | 200726 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1660 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014855.123 | 2094958.2582 | 37.7331912931628 | -122.39100568396299 | (37.7331912931628, -122.391005683963) | |||
| 54424 | 54424 | 197151 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 99 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6016637.91847 | 2095129.63156 | 37.7337606161438 | -122.384853953468 | (37.7337606161438, -122.384853953468) | |||
| 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) | ||
| 44291 | 44291 | 247563 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6008788.9631 | 2095462.99791 | 37.734238722726495 | -122.41201377422199 | (37.7342387227265, -122.412013774222) | |||
| 164209 | 164209 | 197155 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 36 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016950.769830001 | 2095599.6717299998 | 37.73506855147429 | -122.38380503909401 | (37.7350685514743, -122.383805039094) | |||
| 135819 | 135819 | 197165 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017366.51517 | 2096051.5594799998 | 37.7363323183867 | -122.382399074074 | (37.7363323183867, -122.382399074074) | |||
| 175081 | 175081 | 240201 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3004 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002850.8471 | 2096117.4239599998 | 37.735700673245 | -122.432590449705 | (37.735700673245, -122.432590449705) | |||
| 173343 | 173343 | 197137 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1611 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6015105.04683 | 2096793.47619 | 37.7382442932251 | -122.39026979671699 | (37.7382442932251, -122.390269796717) | |||
| 56227 | 56227 | 197135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015262.92854 | 2096819.7411099998 | 37.738325167482294 | -122.389725749154 | (37.7383251674823, -122.389725749154) | |||
| 186113 | 186113 | 240179 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 419 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008252.0977 | 2096866.76003 | 37.7380630114909 | -122.41396916654199 | (37.7380630114909, -122.413969166542) | |||
| 30825 | 30825 | 240180 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008254.09787 | 2096890.0031299999 | 37.738126944293796 | -122.413963894722 | (37.7381269442938, -122.413963894722) | |||
| 126705 | 126705 | 47740 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3583 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45523 | 6005444.07123 | 2097374.1868 | 37.7392981824927 | -122.42371398959101 | (37.7392981824927, -122.423713989591) | |
| 176735 | 176735 | 197125 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 31 Apparel Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6011537.38847 | 2097577.661 | 37.7401989607078 | -122.402660197209 | (37.7401989607078, -122.402660197209) | |||
| 56408 | 56408 | 197131 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 17 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015885.54456 | 2097735.3383299997 | 37.740873716654 | -122.38763689115 | (37.740873716654, -122.38763689115) | |||
| 73028 | 73028 | 197130 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 16 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015893.1870800005 | 2097747.64492 | 37.7409079313583 | -122.38761132431299 | (37.7409079313583, -122.387611324313) | |||
| 165428 | 165428 | 197129 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 11 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015974.4503 | 2097856.83037 | 37.741212233148495 | -122.387337958305 | (37.7412122331485, -122.387337958305) | |||
| 57568 | 57568 | 213989 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2583 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992043.57751 | 2097881.5544 | 37.7399257259925 | -122.47008343851299 | (37.7399257259925, -122.470083438513) | |||
| 27910 | 27910 | 183007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2440 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989549.7088 | 2098739.1145 | 37.742135877465294 | -122.478768805014 | (37.7421358774653, -122.478768805014) | |||
| 150051 | 150051 | 239358 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1560 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003940.0433 | 2099157.5205099997 | 37.744109791227395 | -122.42904136337098 | (37.7441097912274, -122.429041363371) | |||
| 112664 | 112664 | 32235 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 5 | Permit Number 35550 | 6008746.13073 | 2099389.39192 | 37.7450173393701 | -122.412439304646 | (37.7450173393701, -122.412439304646) | |
| 178581 | 178581 | 32236 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1599 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 5 | Permit Number 35551 | 6008785.95411 | 2099394.95601 | 37.745034851884796 | -122.41230199523599 | (37.7450348518848, -122.412301995236) | |
| 133498 | 133498 | 239325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009350.01559 | 2099840.2126 | 37.746289064404294 | -122.410382996672 | (37.7462890644043, -122.410382996672) | |||
| 32581 | 32581 | 197122 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013973.73168 | 2100142.08459 | 37.747376054258105 | -122.394415755007 | (37.7473760542581, -122.394415755007) | |||
| 136232 | 136232 | 240135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 277 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004681.7574 | 2100144.35115 | 37.74686135877779 | -122.426546933603 | (37.7468613587778, -122.426546933603) | |||
| 150776 | 150776 | 239247 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010310.37957 | 2101498.2335 | 37.7508954153113 | -122.407179012596 | (37.7508954153113, -122.407179012596) | |||
| 157309 | 157309 | 197105 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014414.64892 | 2102038.8947099997 | 37.752608793773796 | -122.393023776248 | (37.7526087937738, -122.393023776248) | |||
| 45418 | 45418 | 197094 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014478.47867 | 2102089.9100099998 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | |||
| 149097 | 149097 | 197092 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | |||
| 27161 | 27161 | 197088 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014473.69906 | 2102184.6927400003 | 37.753012404101 | -122.39282976818998 | (37.753012404101, -122.39282976819) | |||
| 160169 | 160169 | 197087 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014472.10243 | 2102198.29911 | 37.753049675611 | -122.39283624152 | (37.753049675611, -122.39283624152) | |||
| 161197 | 161197 | 48810 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014469.89088 | 2102291.4479400003 | 37.753305319601495 | -122.392850405821 | (37.7533053196015, -122.392850405821) | ||
| 151589 | 151589 | 48815 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.97393 | 2102326.82142 | 37.7534023411579 | -122.392859509671 | (37.7534023411579, -122.392859509671) | ||
| 53523 | 53523 | 48812 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.053730001 | 2102353.10418 | 37.753474456898104 | -122.392864530587 | (37.7534744568981, -122.392864530587) | ||
| 151617 | 151617 | 48799 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014465.83632 | 2102364.69447 | 37.753506213741396 | -122.392869551502 | (37.7535062137414, -122.392869551502) | ||
| 15141 | 15141 | 81729 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015012.434719999 | 2102924.7634900003 | 37.7550743894922 | -122.391018422974 | (37.7550743894922, -122.391018422974) |
| 94122 | 94122 | 81726 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 171356 | 171356 | 51529 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 846 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47831 | 6013038.0341300005 | 2103130.6392200002 | 37.7555299221754 | -122.39786095703501 | (37.7555299221754, -122.397860957035) | ||
| 89195 | 89195 | 84586 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3280 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51600 | 6006479.54925803 | 2103214.61842513 | 37.7553930801265 | -122.420548232521 | (37.7553930801265, -122.420548232521) | |
| 166878 | 166878 | 182744 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1769 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986859.8585 | 2103239.7166 | 37.754336768117206 | -122.488400024275 | (37.7543367681172, -122.488400024275) | |||
| 187016 | 187016 | 239284 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2750 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009668.03436 | 2105500.1290599997 | 37.761847752195294 | -122.409682747679 | (37.7618477521953, -122.409682747679) | |||
| 119603 | 119603 | 239286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1999 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009565.6404099995 | 2105513.83187 | 37.761879638550504 | -122.410037856662 | (37.7618796385505, -122.410037856662) | |||
| 164269 | 164269 | 239282 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3562 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005817.754430001 | 2105515.28617 | 37.761672857446 | -122.42300043553499 | (37.761672857446, -122.423000435535) | |||
| 65149 | 65149 | 197108 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012056.73956 | 2105565.85317 | 37.762161783771205 | -122.401425732033 | (37.7621617837712, -122.401425732033) | ||||
| 29178 | 29178 | 197081 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015537.3565 | 2105827.07749 | 37.7630726369229 | -122.389405745189 | (37.7630726369229, -122.389405745189) | |||
| 71612 | 71612 | 197082 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015524.49345 | 2105827.33722 | 37.7630726369153 | -122.38945025263901 | (37.7630726369153, -122.389450252639) | |||
| 122012 | 122012 | 197080 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015550.01358 | 2105828.2198099997 | 37.7630764752211 | -122.389362048039 | (37.7630764752211, -122.389362048039) | |||
| 160986 | 160986 | 240145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1209 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998178.05243 | 2106154.45126 | 37.7629937870534 | -122.44946901220301 | (37.7629937870534, -122.449469012203) | |||
| 182814 | 182814 | 240185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 42 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001017.63107 | 2106166.1197099998 | 37.76318785445999 | -122.439648742804 | (37.76318785446, -122.439648742804) | |||
| 170342 | 170342 | 240170 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1210 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997763.42944 | 2106350.69035 | 37.763508882764796 | -122.45091719498699 | (37.7635088827648, -122.450917194987) | |||
| 156477 | 156477 | 197073 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2310 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010516.44047 | 2106481.63446 | 37.7645902500634 | -122.406817609258 | (37.7645902500634, -122.406817609258) | |||
| 64524 | 64524 | 197071 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2300 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010571.86967 | 2106484.7733400003 | 37.7646019700183 | -122.40662611481301 | (37.7646019700183, -122.406626114813) | |||
| 62957 | 62957 | 213921 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 28 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996377.267469999 | 2106728.36623 | 37.7644664323134 | -122.45573876085501 | (37.7644664323134, -122.455738760855) | |||
| 159587 | 159587 | 213922 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 28 Hill Point Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996376.57374 | 2106740.0599 | 37.7644985003194 | -122.45574200560499 | (37.7644985003194, -122.455742005605) | |||
| 25141 | 25141 | 213923 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996379.96302 | 2106767.55131 | 37.76457417918571 | -122.455732270441 | (37.7645741791857, -122.455732270441) | |||
| 25023 | 25023 | 213915 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1221 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993897.03256 | 2107168.07527 | 37.7655311082052 | -122.464349072465 | (37.7655311082052, -122.464349072465) | |||
| 68138 | 68138 | 239270 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007357.25381 | 2107576.0791 | 37.767418064810705 | -122.41782199889201 | (37.7674180648107, -122.417821998892) | |||
| 56000 | 56000 | 30618 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1645 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34580 | 6008139.305 | 2108622.0896 | 37.7703341448356 | -122.41519103466601 | (37.7703341448356, -122.415191034666) | |
| 160235 | 160235 | 246010 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1509 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998926.3648 | 2108660.5268 | 37.7699176174446 | -122.447061224692 | (37.7699176174446, -122.447061224692) | |||
| 149670 | 149670 | 30617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1625 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34579 | 6008161.857999999 | 2108672.7086 | 37.7704744001626 | -122.41511660718399 | (37.7704744001626, -122.415116607184) | |
| 59877 | 59877 | 142215 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999732.1302 | 2109994.3314 | 37.7736259111784 | -122.444369976113 | (37.7736259111784, -122.444369976113) | |||
| 76800 | 76800 | 67939 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 424 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1993 12:00:00 AM | 5 | Permit Number 31653 | 5999771.9705 | 2110008.0811 | 37.7736659373793 | -122.444233151163 | (37.7736659373793, -122.444233151163) | ||
| 160765 | 160765 | 68930 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 768 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32914 | 5993218.422259999 | 2110247.19429 | 37.7739464110699 | -122.466920079783 | (37.7739464110699, -122.466920079783) | |
| 156662 | 156662 | 141624 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1801 GROVE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998927.5552 | 2110401.5996 | 37.7746982273973 | -122.447182428734 | (37.7746982273973, -122.447182428734) | |||
| 73788 | 73788 | 138936 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 611 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004391.0086 | 2110998.5233 | 37.776647887890896 | -122.428325789109 | (37.7766478878909, -122.428325789109) | |||
| 1366 | 1366 | 81793 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.42359327476801 | (37.7767477786156, -122.423593274768) | |
| 175163 | 175163 | 142043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005850.7541 | 2111017.8349 | 37.776783403593996 | -122.42327746856199 | (37.776783403594, -122.423277468562) | |||
| 38106 | 38106 | 142044 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005880.5674 | 2111021.3015 | 37.7767946045442 | -122.423174581774 | (37.7767946045442, -122.423174581774) | |||
| 73927 | 73927 | 139494 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1282 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001605.3645 | 2111168.2484 | 37.776955892433705 | -122.437974289048 | (37.7769558924337, -122.437974289048) | |||
| 136061 | 136061 | 139287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 894 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6003017.2906 | 2111263.9995 | 37.7772989926884 | -122.43309685014499 | (37.7772989926884, -122.433096850145) | |||
| 171856 | 171856 | 139399 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 896 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6003012.8594 | 2111291.1403 | 37.7773732632111 | -122.433114118747 | (37.7773732632111, -122.433114118747) |
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");