Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, PlotSize
| 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 | ||||||||
| 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 | ||||||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 84362 | 84362 | 85635 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017893.31364 | 2092631.421507 | 37.7269703746724 | -122.38034007025401 | (37.7269703746724, -122.380340070254) | ||
| 138771 | 138771 | 199941 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1161 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6017637.7639999995 | 2092806.0386 | 37.7274357354826 | -122.38123564590401 | (37.7274357354826, -122.381235645904) | |||
| 16510 | 16510 | 85610 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1132 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017745.1516 | 2092811.7191 | 37.727457260594704 | -122.38086479752899 | (37.7274572605947, -122.380864797529) | ||
| 128443 | 128443 | 85636 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1161 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017631.370144 | 2092826.6872430001 | 37.727492079674896 | -122.381259184857 | (37.7274920796749, -122.381259184857) | ||
| 15328 | 15328 | 85611 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1150 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017700.249 | 2092841.4739 | 37.7275364831055 | -122.381022095395 | (37.7275364831055, -122.381022095395) | ||
| 116614 | 116614 | 85637 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017561.518521 | 2092878.7581240002 | 37.7276311998388 | -122.381504284348 | (37.7276311998388, -122.381504284348) | ||
| 96513 | 96513 | 85612 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017578.234449 | 2092916.188247 | 37.7277348985577 | -122.381449098373 | (37.7277348985577, -122.381449098373) | ||
| 14131 | 14131 | 85613 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1190 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017458.1534 | 2093022.4369 | 37.728020006278 | -122.38187161186 | (37.728020006278, -122.38187161186) | ||
| 16538 | 16538 | 85640 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017322.9044 | 2093043.5358 | 37.7280704700942 | -122.382340643729 | (37.7280704700942, -122.382340643729) | ||
| 16642 | 16642 | 85639 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017307.7565 | 2093058.1427 | 37.7281097410693 | -122.382394026885 | (37.7281097410693, -122.382394026885) | ||
| 92125 | 92125 | 85615 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1200X Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017380.895351999 | 2093063.294675 | 37.7281279271047 | -122.38214153905899 | (37.7281279271047, -122.382141539059) | ||
| 16579 | 16579 | 85638 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017293.1497 | 2093067.8806 | 37.728135672587904 | -122.382445200849 | (37.7281356725879, -122.382445200849) | ||
| 14255 | 14255 | 85641 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1215 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017274.7558 | 2093081.4055 | 37.72817179324429 | -122.382509730509 | (37.7281717932443, -122.382509730509) | ||
| 119720 | 119720 | 85642 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1227 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017224.2236089995 | 2093130.194602 | 37.7283029670068 | -122.38268781752501 | (37.7283029670068, -122.382687817525) | ||
| 13802 | 13802 | 85643 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1235 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017171.4256 | 2093155.5219 | 37.7283695937915 | -122.38287210620199 | (37.7283695937915, -122.382872106202) | ||
| 16358 | 16358 | 85616 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1258 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017082.7023 | 2093297.2628 | 37.7287538840188 | -122.383188691469 | (37.7287538840188, -122.383188691469) | ||
| 15002 | 15002 | 85644 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1275 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016975.0441 | 2093297.8038 | 37.728749419657 | -122.383560914081 | (37.728749419657, -122.383560914081) | ||
| 13415 | 13415 | 85617 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1274 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017015.0778 | 2093348.1164 | 37.7288897808137 | -122.383426014631 | (37.7288897808137, -122.383426014631) | ||
| 16855 | 16855 | 85645 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1313 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016677.8494 | 2093524.29 | 37.7293548752151 | -122.384604114815 | (37.7293548752151, -122.384604114815) | ||
| 16554 | 16554 | 85618 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1314 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016773.2527 | 2093530.9730000002 | 37.729378500955896 | -122.384274758873 | (37.7293785009559, -122.384274758873) | ||
| 14204 | 14204 | 85646 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1321 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016609.4363 | 2093572.233 | 37.7294827335965 | -122.38484396608999 | (37.7294827335965, -122.38484396609) | ||
| 13961 | 13961 | 85647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1351 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016557.1838 | 2093613.7118 | 37.7295937360014 | -122.385027498588 | (37.7295937360014, -122.385027498588) | ||
| 13600 | 13600 | 85619 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1338 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016653.5768 | 2093624.593 | 37.729628945087704 | -122.384695012523 | (37.7296289450877, -122.384695012523) | ||
| 15196 | 15196 | 85648 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1357 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016534.0204 | 2093632.0271 | 37.7296427448929 | -122.38510885322701 | (37.7296427448929, -122.385108853227) | ||
| 13554 | 13554 | 85620 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1344 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016632.8917 | 2093635.0593 | 37.729656539473 | -122.384767252586 | (37.729656539473, -122.384767252586) | ||
| 123953 | 123953 | 1701 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 46 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2015 02:11:00 PM | 3 | 3X3 | 6017792.761566999 | 2093643.6318374001 | 37.7297441585391 | -122.38075801318199 | (37.7297441585391, -122.380758013182) | ||
| 84224 | 84224 | 1689 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 03:07:00 PM | 3 | 3X3 | 6017662.008057199 | 2093645.2163419998 | 37.729741292224205 | -122.381210157278 | (37.7297412922242, -122.381210157278) | ||
| 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) | ||
| 77627 | 77627 | 1693 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040294999 | 37.7297694248505 | -122.38109767205201 | (37.7297694248505, -122.381097672052) | ||
| 15458 | 15458 | 85621 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1356 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016575.2959 | 2093679.014 | 37.7297740447744 | -122.38496943038601 | (37.7297740447744, -122.384969430386) | ||
| 14162 | 14162 | 85622 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1360 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016552.9396 | 2093696.0654 | 37.729819627930105 | -122.385047906896 | (37.7298196279301, -122.385047906896) | ||
| 15931 | 15931 | 85649 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1399 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016350.3286 | 2093764.5437 | 37.7299964462298 | -122.385753133703 | (37.7299964462298, -122.385753133703) | ||
| 14774 | 14774 | 85650 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1419 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016182.7975 | 2093891.6734 | 37.730336247224706 | -122.386341174586 | (37.7303362472247, -122.386341174586) | ||
| 15934 | 15934 | 85623 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1404 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016275.7207 | 2093898.407 | 37.7303598794973 | -122.38602039250401 | (37.7303598794973, -122.386020392504) | ||
| 15360 | 15360 | 85624 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016199.7661 | 2093954.969 | 37.7305109836044 | -122.38628692243 | (37.7305109836044, -122.38628692243) | ||
| 83796 | 83796 | 85625 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1430 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016164.799973001 | 2093969.832807 | 37.730549861172705 | -122.38640884249901 | (37.7305498611727, -122.386408842499) | ||
| 15649 | 15649 | 85651 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1467 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015942.8131 | 2094070.7863 | 37.730814768733396 | -122.387183329829 | (37.7308147687334, -122.387183329829) | ||
| 16109 | 16109 | 85626 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1454 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016038.1604 | 2094077.7893 | 37.7308392772335 | -122.38685418415001 | (37.7308392772335, -122.38685418415) | ||
| 14960 | 14960 | 85627 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1466 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015977.8277 | 2094121.4228 | 37.730955745426606 | -122.387065808076 | (37.7309557454266, -122.387065808076) | ||
| 13396 | 13396 | 85628 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1470 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015957.8963 | 2094137.5833 | 37.730999015226104 | -122.387135841638 | (37.7309990152261, -122.387135841638) | ||
| 111278 | 111278 | 85629 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015857.0244309995 | 2094199.26405 | 37.7311627918046 | -122.38748887723801 | (37.7311627918046, -122.387488877238) | ||
| 14632 | 14632 | 85652 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1519 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015655.7374 | 2094284.1377 | 37.7313846871586 | -122.388190689138 | (37.7313846871586, -122.388190689138) | ||
| 14120 | 14120 | 85653 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1541 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015555.708 | 2094360.5338 | 37.731588912651404 | -122.388541843069 | (37.7315889126514, -122.388541843069) | ||
| 15814 | 15814 | 85630 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1518 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015608.4708 | 2094395.709 | 37.7316884205401 | -122.388361884277 | (37.7316884205401, -122.388361884277) | ||
| 68861 | 68861 | 197140 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 53 Pomona St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6014151.58684 | 2094423.9633799999 | 37.7316851643341 | -122.39340063984 | (37.7316851643341, -122.39340063984) | |||
| 174223 | 174223 | 179286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002271.23579 | 2094443.82332 | 37.7310724625286 | -122.43447476411801 | (37.7310724625286, -122.434474764118) | |||
| 157489 | 157489 | 179290 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002318.3672 | 2094465.3447 | 37.7311342306478 | -122.43431336098601 | (37.7311342306478, -122.434313360986) | |||
| 145935 | 145935 | 85631 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015497.489333999 | 2094466.5036189999 | 37.7318766579731 | -122.38875051314301 | (37.7318766579731, -122.388750513143) | ||
| 14505 | 14505 | 85632 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1582 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015365.5421 | 2094575.4322 | 37.7321684400373 | -122.38921428964 | (37.7321684400373, -122.38921428964) | ||
| 16244 | 16244 | 85633 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1590 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015320.4739 | 2094608.4089 | 37.732256488847106 | -122.38937240380899 | (37.7322564888471, -122.389372403809) | ||
| 103676 | 103676 | 26760 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 930X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5995872.4804074 | 2094645.0571617 | 37.731259698358 | -122.456610772668 | (37.731259698358, -122.456610772668) | ||
| 96853 | 96853 | 85660 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1615 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015165.828644999 | 2094663.285506 | 37.7323985938789 | -122.389910883982 | (37.7323985938789, -122.389910883982) | ||
| 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) | |
| 14882 | 14882 | 85659 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1623 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015103.6745 | 2094694.6627 | 37.7324813021879 | -122.390127958436 | (37.7324813021879, -122.390127958436) | ||
| 83194 | 83194 | 87400 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 96662 | 96662 | 87399 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 117485 | 117485 | 87401 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 99327 | 99327 | 16156 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
| 113103 | 113103 | 16159 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
| 114141 | 114141 | 27681 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
| 121740 | 121740 | 16161 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | G | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | ||
| 120810 | 120810 | 16331 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 800X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996797.9550648 | 2094752.6454838002 | 37.7316082025531 | -122.453419021963 | (37.7316082025531, -122.453419021963) | ||
| 13512 | 13512 | 85658 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1643 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015004.908 | 2094769.8823 | 37.7326823614983 | -122.39047467450001 | (37.7326823614983, -122.3904746745) | ||
| 15537 | 15537 | 85657 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1651 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014964.3549 | 2094799.3159999999 | 37.7327609307407 | -122.39061693379999 | (37.7327609307407, -122.3906169338) | ||
| 34771 | 34771 | 200748 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014912.0282 | 2094835.2906 | 37.73285680655879 | -122.39080035501699 | (37.7328568065588, -122.390800355017) | |||
| 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) | |||
| 33109 | 33109 | 197147 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017204.67342 | 2094944.70699 | 37.7332841805136 | -122.38288162868099 | (37.7332841805136, -122.382881628681) | |||
| 79081 | 79081 | 85656 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1699X Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014788.408146 | 2094944.7735630001 | 37.7331505648623 | -122.39123539488199 | (37.7331505648623, -122.391235394882) | ||
| 87188 | 87188 | 85655 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1699X Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014788.408146 | 2094944.7735630001 | 37.7331505648623 | -122.39123539488199 | (37.7331505648623, -122.391235394882) | ||
| 141199 | 141199 | 85654 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1699X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014788.408146 | 2094944.7735630001 | 37.7331505648623 | -122.39123539488199 | (37.7331505648623, -122.391235394882) | ||
| 112625 | 112625 | 85634 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1690X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014848.267124 | 2094950.029371 | 37.733168318034004 | -122.39102881183202 | (37.733168318034, -122.391028811832) | ||
| 168763 | 168763 | 213992 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6001188.39506 | 2095218.69175 | 37.733138545197704 | -122.43827381338801 | (37.7331385451977, -122.438273813388) | |||
| 69161 | 69161 | 247568 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 322 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6008688.67784 | 2095404.14208 | 37.734071490194296 | -122.41235633497101 | (37.7340714901943, -122.412356334971) | |||
| 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) | ||
| 77015 | 77015 | 197152 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016707.19345 | 2095564.5930700002 | 37.734958764918396 | -122.384644735176 | (37.7349587649184, -122.384644735176) | |||
| 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) | ||
| 90769 | 90769 | 4354 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 15X Burnside Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2008 12:00:00 AM | 3 | 3X3 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.43847191328899 | (37.7344491599181, -122.438471913289) | ||
| 110737 | 110737 | 4356 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 15X Burnside Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2011 12:00:00 AM | 3 | 5x5 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.43847191328899 | (37.7344491599181, -122.438471913289) | ||
| 143349 | 143349 | 4363 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 16X Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2005 12:00:00 AM | 3 | 3x3 | 6001247.5637 | 2095900.9603400002 | 37.7350152618906 | -122.438118108566 | (37.7350152618906, -122.438118108566) | ||
| 45950 | 45950 | 197160 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Mabrey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016488.26571 | 2095902.24457 | 37.7358737783612 | -122.385425174944 | (37.7358737783612, -122.385425174944) | |||
| 96907 | 96907 | 4339 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 07:58:00 AM | 3 | 3X3 | 6001465.6431599995 | 2095917.8806599998 | 37.7350741214051 | -122.437365343013 | (37.7350741214051, -122.437365343013) | ||
| 17939 | 17939 | 26869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 3 | 3X3 | 6001564.842 | 2095930.60071 | 37.7351146866797 | -122.437023288105 | (37.7351146866797, -122.437023288105) | ||
| 9255 | 9255 | 24072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 161X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016395.7853594 | 2095946.5828375 | 37.735990405317004 | -122.385748008424 | (37.735990405317, -122.385748008424) | ||
| 9104 | 9104 | 24127 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 140X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016343.6401634 | 2095980.6654178002 | 37.736081103602096 | -122.38593067194799 | (37.7360811036021, -122.385930671948) | ||
| 9107 | 9107 | 24086 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.38575832291299 | (37.7360921261264, -122.385758322913) | ||
| 100023 | 100023 | 4364 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 16X Burnside Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2012 12:00:00 AM | 3 | 3x3 | 6001221.764219999 | 2095989.4346900003 | 37.7352567246132 | -122.43821364238701 | (37.7352567246132, -122.438213642387) |
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");