Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1966 | 1966 | 138440 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2014 12:00:00 AM | 6 | Width 0ft | 6003498.0109 | 2114207.9928 | 37.7854097192823 | -122.431644121578 | (37.7854097192823, -122.431644121578) | ||
| 3099 | 3099 | 197138 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2617 Quint St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 6 | Width 3ft | Permit Number 51436 | 6011420.8914 | 2093882.2827299999 | 37.7300457263229 | -122.402803173234 | (37.7300457263229, -122.402803173234) | |
| 3392 | 3392 | 7175 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 814 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 6 | 3X3 | 6003515.4229999995 | 2111193.7442 | 37.7771343327183 | -122.43136863367201 | (37.7771343327183, -122.431368633672) | ||
| 3763 | 3763 | 18277 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1950 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002776.9831 | 2114109.0569 | 37.7850971709049 | -122.434131584258 | (37.7850971709049, -122.434131584258) | ||
| 5575 | 5575 | 105537 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002561.80287 | 2118173.8704 | 37.796245890587 | -122.435166876954 | (37.796245890587, -122.435166876954) | |||
| 6172 | 6172 | 7253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1701 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1991 12:00:00 AM | 6 | 4X4 | 6003034.749 | 2114248.1919 | 37.7854938264749 | -122.433249741154 | (37.7854938264749, -122.433249741154) | ||
| 6434 | 6434 | 7318 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 6 | 3x3 | 6002895.5378 | 2115212.2273 | 37.7881329245579 | -122.43380029876002 | (37.7881329245579, -122.43380029876) | ||
| 8221 | 8221 | 5902 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1230 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004519.1281 | 2112960.2158 | 37.7820414601118 | -122.428022411289 | (37.7820414601118, -122.428022411289) | |||
| 8721 | 8721 | 94275 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 850 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6001000.8133 | 2111684.213 | 37.778338202659995 | -122.440102619662 | (37.77833820266, -122.440102619662) | ||||
| 8801 | 8801 | 94278 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 850@Golden Gate Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6001005.8896 | 2111653.4167 | 37.7782539328231 | -122.440082850024 | (37.7782539328231, -122.440082850024) | ||||
| 9215 | 9215 | 10617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 74 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1992 12:00:00 AM | 6 | 3X3 | 6016731.0735863 | 2095616.8317798001 | 37.7351035225916 | -122.38456580983299 | (37.7351035225916, -122.384565809833) | ||
| 9321 | 9321 | 11465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016782.5188136 | 2095601.0665952999 | 37.7350630793796 | -122.384386845805 | (37.7350630793796, -122.384386845805) | ||
| 10316 | 10316 | 110495 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003598.79471 | 2092490.0157299999 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | |||
| 10895 | 10895 | 27085 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 747 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6006317.37103 | 2093607.15152 | 37.729003994832 | -122.420427188268 | (37.729003994832, -122.420427188268) | |||
| 11111 | 11111 | 110496 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003585.89382 | 2092469.97138 | 37.7257272466074 | -122.429789031845 | (37.7257272466074, -122.429789031845) | |||
| 12987 | 12987 | 1848 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011043.028059999 | 2086938.1542099998 | 37.7109574665846 | -122.403621108454 | (37.7109574665846, -122.403621108454) | |||
| 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) | |||
| 13377 | 13377 | 10610 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 29 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6016939.384330001 | 2095525.0457799998 | 37.7348630141201 | -122.38383920883801 | (37.7348630141201, -122.383839208838) | ||
| 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) | ||
| 14570 | 14570 | 16549 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015994.10911 | 2097882.11034 | 37.7412827355083 | -122.38727174751001 | (37.7412827355083, -122.38727174751) | |||
| 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) | ||
| 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) | ||
| 15074 | 15074 | 11468 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 6 | 3X3 | 6016817.53474 | 2095601.45988 | 37.735066095427705 | -122.384265809434 | (37.7350660954277, -122.384265809434) | ||
| 15644 | 15644 | 16542 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016097.47551 | 2098025.0219 | 37.741680865376 | -122.386924304309 | (37.741680865376, -122.386924304309) | |||
| 16006 | 16006 | 11463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | ||
| 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) | ||
| 17348 | 17348 | 4322 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 752 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002136.242880001 | 2095781.1252 | 37.7347367232032 | -122.435037065224 | (37.7347367232032, -122.435037065224) | |||
| 18749 | 18749 | 10444 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1508 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1999 12:00:00 AM | 6 | 3x3 | 5998873.5099 | 2108710.5533 | 37.770051957545704 | -122.447247648975 | (37.7700519575457, -122.447247648975) | ||
| 18926 | 18926 | 15619 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005685.7885 | 2097881.8817 | 37.7407058402708 | -122.422914311238 | (37.7407058402708, -122.422914311238) | ||
| 20207 | 20207 | 4337 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 906 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2001 12:00:00 AM | 6 | 3X3 | 6001499.188490001 | 2095960.05903 | 37.735191840439896 | -122.437252384095 | (37.7351918404399, -122.437252384095) | ||
| 20482 | 20482 | 15620 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3529 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6005636.1083 | 2097793.1908 | 37.740459511674 | -122.423079784271 | (37.740459511674, -122.423079784271) | ||
| 20547 | 20547 | 15616 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3461 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6005827.515 | 2098142.9917 | 37.741430785549205 | -122.422442822684 | (37.7414307855492, -122.422442822684) | ||
| 20573 | 20573 | 15605 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3349 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2000 12:00:00 AM | 6 | 3X3 | 6006192.9166 | 2098824.6926 | 37.743323189063 | -122.42122778433998 | (37.743323189063, -122.42122778434) | ||
| 21028 | 21028 | 15622 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3535 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005607.2671 | 2097740.6765 | 37.7403136916677 | -122.423175774097 | (37.7403136916677, -122.423175774097) | ||
| 21828 | 21828 | 15579 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 6 | 3X3 | 6006811.7424 | 2099968.3124 | 37.7464981794513 | -122.419169144026 | (37.7464981794513, -122.419169144026) | ||
| 21988 | 21988 | 15585 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3181 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6006711.3923 | 2099783.2222 | 37.7459843117401 | -122.419503015091 | (37.7459843117401, -122.419503015091) | ||
| 22887 | 22887 | 120259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988369.32629 | 2115004.14379 | 37.7867265878172 | -122.484042609601 | (37.7867265878172, -122.484042609601) | |||
| 23105 | 23105 | 15636 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 3620 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005333.6922 | 2097119.1421 | 37.7385916557518 | -122.424077498789 | (37.7385916557518, -122.424077498789) | |||
| 23213 | 23213 | 10408 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1391 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5999500.982999999 | 2108743.0478 | 37.7701770128525 | -122.445079572577 | (37.7701770128525, -122.445079572577) | |||
| 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) | ||
| 26661 | 26661 | 213931 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 23 Hill Point Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996332.88729 | 2106669.96482 | 37.7643035299972 | -122.455888036623 | (37.7643035299972, -122.455888036623) | |||
| 27678 | 27678 | 68339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 410 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32156 | 5991257.09324 | 2112608.74204 | 37.7803171779643 | -122.47387689925101 | (37.7803171779643, -122.473876899251) | |
| 27916 | 27916 | 197079 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6015561.72583 | 2105828.91514 | 37.763079033783605 | -122.389321587544 | (37.7630790337836, -122.389321587544) | |||
| 30381 | 30381 | 197107 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014386.38736 | 2102037.52751 | 37.7526034697945 | -122.393121414743 | (37.7526034697945, -122.393121414743) | |||
| 30859 | 30859 | 136223 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3699 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000162.373980001 | 2120896.2706299997 | 37.8035843324119 | -122.44366504043501 | (37.8035843324119, -122.443665040435) | |||
| 31714 | 31714 | 46872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2006 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 6 | Permit Number 44935 | 6006916.93752 | 2118140.46696 | 37.7964005164122 | -122.420094813224 | (37.7964005164122, -122.420094813224) | |
| 35501 | 35501 | 197166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017812.186480001 | 2093598.1535200002 | 37.729620355985205 | -122.380687698389 | (37.7296203559852, -122.380687698389) | |||
| 36094 | 36094 | 136210 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3501 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997980.46007 | 2115787.2108299998 | 37.7894315448801 | -122.450847014574 | (37.7894315448801, -122.450847014574) | |||
| 36622 | 36622 | 102487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999337.8085 | 2111150.0142 | 37.7767766147896 | -122.445817121147 | (37.7767766147896, -122.445817121147) | |||
| 38315 | 38315 | 179295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 103 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004297.98606 | 2093012.3139099998 | 37.727256697520204 | -122.42736600014 | (37.7272566975202, -122.42736600014) | |||
| 38745 | 38745 | 121984 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 410 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991256.96696 | 2112622.26651 | 37.780354305120504 | -122.47387832307501 | (37.7803543051205, -122.473878323075) | |||
| 41596 | 41596 | 197086 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014471.44073 | 2102209.38753 | 37.7530800852958 | -122.39283930551599 | (37.7530800852958, -122.392839305516) | |||
| 44193 | 44193 | 240203 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 50 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002560.6439 | 2096455.85562 | 37.736613467133004 | -122.433617972817 | (37.736613467133, -122.433617972817) | |||
| 44860 | 44860 | 240204 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002560.276330001 | 2096896.15431 | 37.7378224050816 | -122.43365070183901 | (37.7378224050816, -122.433650701839) | |||
| 45516 | 45516 | 117917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | |||
| 48288 | 48288 | 49992 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 300@ GOUGH Linden St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2003 12:00:00 AM | 6 | Permit Number 46733 | 6005873.634 | 2110881.2484 | 37.7764096614269 | -122.42318860884 | (37.7764096614269, -122.42318860884) | ||
| 48649 | 48649 | 240191 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 31 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004293.70696 | 2098089.97952 | 37.7411985814464 | -122.427742424874 | (37.7411985814464, -122.427742424874) | |||
| 49555 | 49555 | 120257 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 140 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988368.87318 | 2114954.3645200003 | 37.786589881739104 | -122.484040525506 | (37.7865898817391, -122.484040525506) | |||
| 50367 | 50367 | 142842 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1343 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6006739.5174 | 2115575.1482 | 37.789346792117705 | -122.420526537815 | (37.7893467921177, -122.420526537815) | |||
| 50615 | 50615 | 137711 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1695 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001100.0524 | 2111395.1736 | 37.777550222844 | -122.439738587802 | (37.777550222844, -122.439738587802) | |||
| 50979 | 50979 | 213925 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996354.0642099995 | 2106807.80111 | 37.7646832084757 | -122.45582475672701 | (37.7646832084757, -122.455824756727) | |||
| 51010 | 51010 | 136194 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.43528810647699 | (37.7965053162169, -122.435288106477) | |||
| 51590 | 51590 | 138446 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003295.7109 | 2114182.3135 | 37.7853277416205 | -122.43234218389799 | (37.7853277416205, -122.432342183898) | |||
| 53362 | 53362 | 136246 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006533.72276 | 2116650.00017 | 37.7922864687885 | -122.421314924346 | (37.7922864687885, -122.421314924346) | |||
| 54162 | 54162 | 213964 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994850.90322 | 2091215.19212 | 37.7217834109648 | -122.459894162891 | (37.7217834109648, -122.459894162891) | |||
| 54566 | 54566 | 141886 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 EDDY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004027.64 | 2112849.1164 | 37.7817085903995 | -122.429714809344 | (37.7817085903995, -122.429714809344) | |||
| 55020 | 55020 | 239302 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2758 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010190.62903 | 2102833.93445 | 37.7545562513823 | -122.407687292349 | (37.7545562513823, -122.407687292349) | |||
| 55248 | 55248 | 197103 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014438.05571 | 2102040.91433 | 37.7526156394141 | -122.392942972153 | (37.7526156394141, -122.392942972153) | |||
| 55755 | 55755 | 48872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2002 12:00:00 AM | 6 | 3x3 | Permit Number 46081 | 6011751.8076 | 2120847.07255 | 37.8041034220013 | -122.403555563145 | (37.8041034220013, -122.403555563145) | |
| 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) | ||
| 57520 | 57520 | 69320 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1546 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1994 12:00:00 AM | 6 | Permit Number 33401 | 6004443.14953 | 2120171.11922 | 37.801836474839796 | -122.428799484421 | (37.8018364748398, -122.428799484421) | |
| 57613 | 57613 | 240158 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 569 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5998608.31571 | 2105895.72511 | 37.7623079937314 | -122.447962256561 | (37.7623079937314, -122.447962256561) | |||
| 58666 | 58666 | 69359 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3130 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 6 | Permit Number 33453 | 6004667.124009999 | 2120354.39385 | 37.8023523736266 | -122.428037496051 | (37.8023523736266, -122.428037496051) | |
| 59141 | 59141 | 240169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 204 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5998975.98045 | 2106976.10403 | 37.7652954525443 | -122.446768387673 | (37.7652954525443, -122.446768387673) | |||
| 59502 | 59502 | 244531 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1504 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998919.2255 | 2108717.3892 | 37.7700733392593 | -122.44709001202 | (37.7700733392593, -122.44709001202) | |||
| 59609 | 59609 | 213995 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999776.55649 | 2094090.41195 | 37.729960150431 | -122.44307390075399 | (37.729960150431, -122.443073900754) | |||
| 59666 | 59666 | 179298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004373.55102 | 2093025.79015 | 37.7272979737044 | -122.427105731855 | (37.7272979737044, -122.427105731855) | |||
| 59667 | 59667 | 239240 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2675 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009999.7330599995 | 2103946.90887 | 37.7576015419924 | -122.408425964904 | (37.7576015419924, -122.408425964904) | |||
| 60352 | 60352 | 44270 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2001 12:00:00 AM | 6 | 3x3 | Permit Number 43698 | 6009401.249919999 | 2117056.5968 | 37.793564133816794 | -122.411421918689 | (37.7935641338168, -122.411421918689) | |
| 60392 | 60392 | 244923 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1318 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999810.5322 | 2108837.5844 | 37.7704542495024 | -122.444015641705 | (37.7704542495024, -122.444015641705) | |||
| 60831 | 60831 | 247567 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 320 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6008730.40268 | 2095427.8255 | 37.7341388611064 | -122.412213751984 | (37.7341388611064, -122.412213751984) | |||
| 62833 | 62833 | 197084 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.76337 | 2102245.03022 | 37.753177803814 | -122.39285105782801 | (37.753177803814, -122.392851057828) | |||
| 65322 | 65322 | 73401 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1733 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 6 | 6006559.8799 | 2116866.9427 | 37.7928836135597 | -122.421239831973 | (37.7928836135597, -122.421239831973) | ||
| 66105 | 66105 | 98309 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 401X Newhall St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6 | 3x3 | 6016081.14502 | 2097910.9401599998 | 37.741366715992896 | -122.386972815546 | (37.7413667159929, -122.386972815546) | |||
| 69784 | 69784 | 213949 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 223 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994439.2720800005 | 2091407.20179 | 37.722286941382706 | -122.46133096657199 | (37.7222869413827, -122.461330966572) | |||
| 69823 | 69823 | 213978 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 250 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994758.88079 | 2090253.13715 | 37.7191365451831 | -122.460142594324 | (37.7191365451831, -122.460142594324) | |||
| 70015 | 70015 | 39981 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 45 Bay View St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 6 | Permit Number 41239 | 6014242.19126 | 2094737.80253 | 37.7325519363025 | -122.39310935121999 | (37.7325519363025, -122.39310935122) | |
| 70433 | 70433 | 213934 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2434 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991403.06474 | 2098824.0005 | 37.7424763930825 | -122.472366729935 | (37.7424763930825, -122.472366729935) | |||
| 70520 | 70520 | 213932 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 23 Hill Point Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996332.4383 | 2106648.48476 | 37.7642445254929 | -122.455888036625 | (37.7642445254929, -122.455888036625) | |||
| 70907 | 70907 | 197139 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012870.02823 | 2094155.1374099997 | 37.730875736712704 | -122.39781242511101 | (37.7308757367127, -122.397812425111) | |||
| 71421 | 71421 | 213970 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995027.09423 | 2091143.79671 | 37.721597507607996 | -122.45927995292699 | (37.721597507608, -122.459279952927) | |||
| 73273 | 73273 | 197136 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015282.23394 | 2096844.32451 | 37.7383937389821 | -122.38966071648998 | (37.7383937389821, -122.38966071649) | |||
| 74086 | 74086 | 239242 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010651.99768 | 2101656.70763 | 37.751349662874105 | -122.406008821959 | (37.7513496628741, -122.406008821959) | |||
| 74169 | 74169 | 136203 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1349 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004849.1859800005 | 2120525.70738 | 37.8028330549672 | -122.42741968339399 | (37.8028330549672, -122.427419683394) | |||
| 74866 | 74866 | 240196 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004000.46579 | 2096134.03404 | 37.735811408553296 | -122.42861695621 | (37.7358114085533, -122.42861695621) | |||
| 74919 | 74919 | 136206 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5998023.60869 | 2115735.83366 | 37.7892929467667 | -122.450694020137 | (37.7892929467667, -122.450694020137) | |||
| 75524 | 75524 | 120438 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 123 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5988956.31634 | 2114501.1697400003 | 37.7853797200377 | -122.48197492857099 | (37.7853797200377, -122.481974928571) | |||
| 76365 | 76365 | 213967 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994931.65056 | 2091213.50095 | 37.72178341096 | -122.45961491981701 | (37.72178341096, -122.459614919817) | |||
| 76626 | 76626 | 239338 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 678 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009998.15173 | 2100483.7669 | 37.7480924353179 | -122.408187190397 | (37.7480924353179, -122.408187190397) | |||
| 76745 | 76745 | 197102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014466.67746 | 2102042.06403 | 37.752620386043205 | -122.392844072804 | (37.7526203860432, -122.392844072804) |
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");