Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6898 | 6898 | 2436 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 6004500.111269999 | 2111079.2700799997 | 37.7768757716325 | -122.427954126177 | (37.7768757716325, -122.427954126177) | ||
| 127078 | 127078 | 2465 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1832 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2000 12:00:00 AM | 3 | 4X4 | 6003995.999502901 | 2114715.2873188 | 37.7868308367846 | -122.429957429665 | (37.7868308367846, -122.429957429665) | ||
| 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) | ||
| 7900 | 7900 | 4617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 348 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 10 | 3x3 | 6010597.9091 | 2118822.5443 | 37.7984800429378 | -122.40740591699 | (37.7984800429378, -122.40740591699) | ||
| 18626 | 18626 | 5933 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/1990 12:00:00 AM | 3 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | ||
| 139811 | 139811 | 6418 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 350X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2016 12:00:00 AM | 6 | 3X3 | 6006767.0052256 | 2097982.925376 | 37.7410442330982 | -122.41918303237 | (37.7410442330982, -122.41918303237) | ||
| 14424 | 14424 | 6845 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 595X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 6 | 3x3 | 6015936.9719 | 2097716.00593 | 37.7408234823092 | -122.38745772460899 | (37.7408234823092, -122.387457724609) | ||
| 128038 | 128038 | 7193 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 898 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6003489.5579699995 | 2111353.68492 | 37.7775720243799 | -122.431469529604 | (37.7775720243799, -122.431469529604) | ||
| 89187 | 89187 | 7255 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1940X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/2011 12:00:00 AM | 3 | 3x3 | 6002883.203031099 | 2114120.5638209 | 37.785134793903104 | -122.433764919711 | (37.7851347939031, -122.433764919711) | ||
| 94428 | 94428 | 7306 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1913 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002897.81123 | 2114891.63011 | 37.787252775252 | -122.43376950997299 | (37.787252775252, -122.433769509973) | |||
| 142781 | 142781 | 7328 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2042 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002935.65629 | 2115353.59376 | 37.7885233572924 | -122.43367160320801 | (37.7885233572924, -122.433671603208) | |||
| 97907 | 97907 | 7335 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2095X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002868.54266 | 2115466.62702 | 37.788829909466706 | -122.43391188844801 | (37.7888299094667, -122.433911888448) | |||
| 96942 | 96942 | 8083 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004278.93609 | 2111494.4180400004 | 37.7780031505288 | -122.428748840382 | (37.7780031505288, -122.428748840382) | ||
| 109687 | 109687 | 8099 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 765 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004167.348119999 | 2111468.4499 | 37.7779255322683 | -122.429133010837 | (37.7779255322683, -122.429133010837) | ||
| 80017 | 80017 | 8107 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 785 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 3 | 4X4 | 6004040.717119999 | 2111448.77193 | 37.7778643322695 | -122.429569668288 | (37.7778643322695, -122.429569668288) | ||
| 140172 | 140172 | 8112 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 810 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 1 | 3X3 | 6003674.72306 | 2111615.24723 | 37.778300702455894 | -122.430847652747 | (37.7783007024559, -122.430847652747) | ||
| 23259 | 23259 | 8115 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 830 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1991 12:00:00 AM | 6 | 3X3 | 6003771.0154 | 2111470.5456 | 37.7779088429261 | -122.430504214514 | (37.7779088429261, -122.430504214514) | ||
| 92861 | 92861 | 8912 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5993182.362319999 | 2112722.76783 | 37.7807415869386 | -122.46722485031 | (37.7807415869386, -122.46722485031) | |||
| 146318 | 146318 | 8938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4649X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5992558.61151 | 2112698.79101 | 37.7806397269512 | -122.469380940837 | (37.7806397269512, -122.469380940837) | |||
| 101248 | 101248 | 10234 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 47 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/29/2011 12:00:00 AM | 3 | 4x4 | 6005872.37024 | 2109570.63288 | 37.772810956494396 | -122.42309980151501 | (37.7728109564944, -122.423099801515) | ||
| 128988 | 128988 | 10416 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1399 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999442.73592 | 2108734.00442 | 37.7701488573322 | -122.44528039770799 | (37.7701488573322, -122.445280397708) | |||
| 18752 | 18752 | 10423 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1401 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999371.8264 | 2108722.9096 | 37.7701143458549 | -122.44552487423 | (37.7701143458549, -122.44552487423) | |||
| 103525 | 103525 | 11173 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2717 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006873.7712695 | 2121594.1615236998 | 37.8058810553361 | -122.42048945327299 | (37.8058810553361, -122.420489453273) | |||
| 105262 | 105262 | 11462 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 41X HAWKINS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/1992 12:00:00 AM | 6 | 3X3 | 6016935.0 | 2095578.0 | 37.7350081734808 | -122.38385805308201 | (37.7350081734808, -122.383858053082) | ||
| 14701 | 14701 | 11464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.858519999 | 2095545.6720200002 | 37.734911327499205 | -122.384361070118 | (37.7349113274992, -122.384361070118) | ||
| 14147 | 14147 | 11467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 8 | 3X3 | 6016799.4589 | 2095596.1573400002 | 37.7350505362442 | -122.384327935502 | (37.7350505362442, -122.384327935502) | ||
| 98801 | 98801 | 14783 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1037 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004216.0719046 | 2111827.8420520998 | 37.7789150924062 | -122.42899008807801 | (37.7789150924062, -122.428990088078) | |||
| 17097 | 17097 | 15580 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 6 | 3X3 | 6006815.4591 | 2099977.9757 | 37.746524922000205 | -122.41915697739401 | (37.7465249220002, -122.419156977394) | ||
| 115748 | 115748 | 15637 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3620 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1999 12:00:00 AM | 3 | 3X3 | 6005316.03868 | 2097071.29075 | 37.7384592699819 | -122.42413513415899 | (37.7384592699819, -122.424135134159) | ||
| 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) | |||
| 78120 | 78120 | 16551 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 500X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/1998 12:00:00 AM | 3 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | ||
| 14937 | 14937 | 16560 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 702X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 12 | 3X3 | 6015615.61867 | 2097370.07413 | 37.7398558207833 | -122.38854471268299 | (37.7398558207833, -122.388544712683) | ||
| 79895 | 79895 | 16755 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1795 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002763.899780001 | 2113354.2774799997 | 37.7830239949229 | -122.434122873023 | (37.7830239949229, -122.434122873023) | |||
| 98310 | 98310 | 18253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1830 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1998 12:00:00 AM | 6 | 4X4 | 6003407.35543 | 2114195.13868 | 37.7853692861869 | -122.43195684400499 | (37.7853692861869, -122.431956844005) | ||
| 78063 | 78063 | 18261 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1870 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/1991 12:00:00 AM | 6 | 4X4 | 6003225.470724501 | 2114168.1799394 | 37.7852849514104 | -122.43258418353399 | (37.7852849514104, -122.432584183534) | ||
| 110618 | 110618 | 18636 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2000 12:00:00 AM | 3 | 3X3 | 6017095.3922155 | 2096110.4018038001 | 37.736478907812 | -122.38334056309999 | (37.736478907812, -122.3833405631) | ||
| 113449 | 113449 | 18638 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017121.136185501 | 2096199.8633465 | 37.736725974033604 | -122.383257779638 | (37.7367259740336, -122.383257779638) | ||
| 95631 | 95631 | 18654 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 85 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | ||
| 111452 | 111452 | 21728 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1945 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003313.60207 | 2114475.63128 | 37.7861341326159 | -122.432301241803 | (37.7861341326159, -122.432301241803) | |||
| 5860 | 5860 | 21732 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1961 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1997 12:00:00 AM | 3 | 3X3 | 6003208.5585 | 2114462.4267 | 37.78609191954679 | -122.432663720821 | (37.7860919195468, -122.432663720821) | ||
| 102226 | 102226 | 22817 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 57 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 2X2 | 5999134.8661569 | 2099418.6659097997 | 37.7445536617332 | -122.445675315466 | (37.7445536617332, -122.445675315466) | ||
| 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) | ||
| 14888 | 14888 | 24090 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 125X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1997 12:00:00 AM | 6 | 3x3 | 6016342.364159999 | 2095991.2568 | 37.736110114791 | -122.3859358217 | (37.736110114791, -122.3859358217) | ||
| 97965 | 97965 | 24186 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 55X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 4x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 144934 | 144934 | 24470 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 50X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 16 | 3x3 | 6006161.54315 | 2109606.56692 | 37.7729259368552 | -122.42210207116699 | (37.7729259368552, -122.422102071167) | ||
| 87312 | 87312 | 24482 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 103X Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002240.5138934 | 2096668.0977393002 | 37.7371780656004 | -122.434739971035 | (37.7371780656004, -122.434739971035) | |||
| 96945 | 96945 | 24562 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1800 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 4 | 3X3 | 6003046.3255 | 2114475.99542 | 37.786119973984206 | -122.43322597301099 | (37.7861199739842, -122.433225973011) | ||
| 105873 | 105873 | 24568 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2261 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2004 12:00:00 AM | 3 | 3X3 | 6002770.36332 | 2116069.69305 | 37.790480202582 | -122.43429470698 | (37.790480202582, -122.43429470698) | ||
| 146269 | 146269 | 24686 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6599X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5986563.55545 | 2112507.59289 | 37.77976647962429 | -122.49010635929599 | (37.7797664796243, -122.490106359296) | ||
| 16295 | 16295 | 27141 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1775 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011398.088769999 | 2095346.30396 | 37.7340643486912 | -122.402984937921 | (37.7340643486912, -122.402984937921) | |||
| 13142 | 13142 | 27250 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 747 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6006299.28886 | 2093605.00165 | 37.728997072755206 | -122.420489547272 | (37.7289970727552, -122.420489547272) | |||
| 85202 | 85202 | 29137 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 90x Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6009115.3969879 | 2112842.7343051997 | 37.781977847913204 | -122.41211305193501 | (37.7819778479132, -122.412113051935) | ||
| 115333 | 115333 | 30525 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.41362414398701 | (37.7811193385199, -122.413624143987) | |
| 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 | ||||||||
| 107582 | 107582 | 30615 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34576 | 6008169.65081501 | 2108823.23186566 | 37.7708881396338 | -122.415100307898 | (37.7708881396338, -122.415100307898) | ||
| 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) | |
| 15334 | 15334 | 30635 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008075.6555 | 2108643.1391 | 37.770388364567104 | -122.41541268929899 | (37.7703883645671, -122.415412689299) | |
| 125584 | 125584 | 30655 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Lafayette St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.773163916329295 | -122.41734957960699 | (37.7731639163293, -122.417349579607) |
| 127655 | 127655 | 30728 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 45 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.42162786237301 | (37.7736338888904, -122.421627862373) | ||
| 18932 | 18932 | 30938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1106 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 8 | 3x3 | Permit Number 772469 | 5995956.71997 | 2091289.90864 | 37.722052099618104 | -122.456077064214 | (37.7220520996181, -122.456077064214) | |
| 69527 | 69527 | 31227 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2598 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34913 | 5992091.019830001 | 2097838.61761 | 37.7398105749846 | -122.46991627883301 | (37.7398105749846, -122.469916278833) | |
| 48558 | 48558 | 31312 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.77639109406471 | -122.428032671161 | (37.7763910940647, -122.428032671161) | |||
| 59397 | 59397 | 31336 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 745 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 9 | Permit Number 34951 | 6004456.33645 | 2111073.11505 | 37.776856394839 | -122.42810511786001 | (37.776856394839, -122.42810511786) | ||
| 97789 | 97789 | 31405 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4249 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 34995 | 6002250.83987816 | 2104099.74238816 | 37.757584195724796 | -122.435235679993 | (37.7575841957248, -122.435235679993) | ||
| 37696 | 37696 | 32199 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1516 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35524 | 6009302.4465 | 2100450.1305 | 37.7479610974423 | -122.410590548539 | (37.7479610974423, -122.410590548539) | ||
| 97467 | 97467 | 33438 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 193 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37541 | 6006477.65745838 | 2098616.29315883 | 37.74276701964221 | -122.420228434519 | (37.7427670196422, -122.420228434519) | |||
| 109231 | 109231 | 33691 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 625 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37764 | 6004364.86581498 | 2110979.96495009 | 37.776595451912996 | -122.428414901604 | (37.776595451913, -122.428414901604) | |||
| 19275 | 19275 | 34240 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 135338 | 135338 | 34252 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38731 | 6006224.9654 | 2121058.41971 | 37.804373461439795 | -122.42269665353999 | (37.8043734614398, -122.42269665354) | |
| 139534 | 139534 | 35264 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2316 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52291 | 6006351.546323201 | 2118737.5484062 | 37.7980080796095 | -122.422093629292 | (37.7980080796095, -122.422093629292) | ||
| 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) | ||
| 89773 | 89773 | 38663 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 840 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | 5x3 | Permit Number 40585 | 6001023.37265886 | 2111553.49114647 | 37.7779805578681 | -122.44001520291401 | (37.7779805578681, -122.440015202914) | ||
| 123759 | 123759 | 38869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2439 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40694 | 5987327.75302366 | 2098677.68678111 | 37.7418379454862 | -122.486447023752 | (37.7418379454862, -122.486447023752) | ||
| 96891 | 96891 | 41132 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 11X Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 53576 | 5998162.17039542 | 2108554.54786356 | 37.769582935081296 | -122.449696907216 | (37.7695829350813, -122.449696907216) | |
| 124509 | 124509 | 41240 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 159656 | 159656 | 42168 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 9 | Permit Number 42460 | 6012645.95751 | 2111148.5484599997 | 37.7775234660795 | -122.399779856677 | (37.7775234660795, -122.399779856677) | ||
| 116602 | 116602 | 43385 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 847 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43133 | 6001928.68244613 | 2101630.19955263 | 37.75078512339571 | -122.436173106924 | (37.7507851233957, -122.436173106924) | ||
| 90598 | 90598 | 43924 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1100X HAMPSHIRE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43515 | 6010276.0 | 2102522.0 | 37.7537045273505 | -122.407370066225 | (37.7537045273505, -122.407370066225) | ||
| 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 | |||||||||
| 92284 | 92284 | 47639 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
| 52223 | 52223 | 48664 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1715REVISED Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 2 | Permit Number 45950 | 6004825.1941 | 2115340.0212 | 37.788593123793504 | -122.427133123433 | (37.7885931237935, -122.427133123433) | |
| 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) | ||
| 113962 | 113962 | 48861 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 135 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46853 | 5992938.7152954005 | 2098174.1666423 | 37.7407808726579 | -122.46700971886699 | (37.7407808726579, -122.467009718867) | ||
| 108781 | 108781 | 48863 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46854 | 5992914.37939707 | 2098147.89875638 | 37.740707342979995 | -122.467091953195 | (37.74070734298, -122.467091953195) | ||
| 157386 | 157386 | 49548 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2434@ TARAVAL 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2003 12:00:00 AM | 1 | Permit Number 46439 | 5989857.9655 | 2098790.1552 | 37.742293916006 | -122.47770669165199 | (37.742293916006, -122.477706691652) | ||
| 95467 | 95467 | 49612 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 88425 | 88425 | 49885 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59@ WILDWOOD Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | |||
| 148769 | 148769 | 50669 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3130 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 9 | Permit Number 47247 | 6002419.67533 | 2119034.32922 | 37.798600414646295 | -122.435720259485 | (37.7986004146463, -122.435720259485) | ||
| 118962 | 118962 | 51439 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 779 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47759 | 6007378.77949872 | 2095187.90508456 | 37.7334041569913 | -122.416869758383 | (37.7334041569913, -122.416869758383) | |||
| 128484 | 128484 | 52058 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3165 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48256 | 6006783.78749917 | 2099933.06553583 | 37.746399825173 | -122.419263309296 | (37.746399825173, -122.419263309296) | |||
| 165345 | 165345 | 52196 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2013 12:00:00 AM | 2 | Permit Number 770878 | 6007126.92706 | 2119460.55943 | 37.800036988073295 | -122.419461903656 | (37.8000369880733, -122.419461903656) | ||
| 56367 | 56367 | 52632 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 6 | Permit Number 48716 | 6006419.56903 | 2116963.2187099997 | 37.793140052215705 | -122.421732156715 | (37.7931400522157, -122.421732156715) | ||
| 87293 | 87293 | 52908 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 295 Gaven St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 3x3 | Permit Number 48898 | 6009070.24444642 | 2094849.33610342 | 37.732569516932294 | -122.41099796146001 | (37.7325695169323, -122.41099796146) | ||
| 84861 | 84861 | 53148 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1499@ LANE Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | Permit Number 49076 | 6015286.17606683 | 2093519.24782482 | 37.7292639697355 | -122.389414946979 | (37.7292639697355, -122.389414946979) | |||
| 95677 | 95677 | 59892 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 900 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 3x3 | Permit Number 774687 | 6009909.98280438 | 2103947.38661173 | 37.75759782727221 | -122.408736392824 | (37.7575978272722, -122.408736392824) | |
| 100827 | 100827 | 66615 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2252 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | Permit Number 29817 | 6002543.0 | 2107122.0 | 37.76589916997111 | -122.434441354631 | (37.7658991699711, -122.434441354631) | |||
| 47463 | 47463 | 70412 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | ||
| 59413 | 59413 | 70593 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | ||
| 88949 | 88949 | 70620 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1644 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1994 12:00:00 AM | 12 | 3x3 | 6006824.13924708 | 2117065.21920464 | 37.793442925898105 | -122.42033955937599 | (37.7934429258981, -122.420339559376) | ||
| 39309 | 39309 | 70680 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) |
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");