Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4451 | 4451 | 216718 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.45912417326299 | (37.7196152839906, -122.459124173263) | ||
| 31529 | 31529 | 52954 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 975 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48941 | 6000767.51384 | 2091342.1163299999 | 37.7224704120511 | -122.43945112037399 | (37.7224704120511, -122.439451120374) | |
| 119242 | 119242 | 87861 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 96 Caselli Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50803 | 6000485.4 | 2104954.1 | 37.7598296396585 | -122.441402573572 | (37.7598296396585, -122.441402573572) | ||
| 47585 | 47585 | 176883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011048.63475 | 2088252.8219299999 | 37.7145675926038 | -122.40369417294501 | (37.7145675926038, -122.403694172945) | ||||
| 172938 | 172938 | 176884 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.40364648639601 | (37.7145850034576, -122.403646486396) | ||||
| 20660 | 20660 | 88463 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) |
| 94653 | 94653 | 88465 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 955X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) |
| 42969 | 42969 | 95722 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 79989 | 79989 | 95720 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 97343 | 97343 | 95721 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 124038 | 124038 | 95719 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 125716 | 125716 | 95718 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 63496 | 63496 | 227556 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Seward St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | |||
| 4096 | 4096 | 181028 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.4676599998 | 37.715132307492794 | -122.44007027934201 | (37.7151323074928, -122.440070279342) | ||
| 4113 | 4113 | 181027 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:23:00 PM | 3 | Width 4ft | 6000546.58685 | 2088667.2481099998 | 37.7151132526545 | -122.440023107188 | (37.7151132526545, -122.440023107188) | ||
| 70838 | 70838 | 69919 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 95 Mercedes Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.728618246103295 | -122.470591251084 | (37.7286182461033, -122.470591251084) | ||
| 83196 | 83196 | 71841 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 95 Mercedes Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.728618246103295 | -122.470591251084 | (37.7286182461033, -122.470591251084) | ||
| 50407 | 50407 | 52070 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 939 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009656.25559 | 2117750.5131099997 | 37.7954837583147 | -122.410588599703 | (37.7954837583147, -122.410588599703) | ||
| 147945 | 147945 | 52071 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 939 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009677.58908 | 2117754.14875 | 37.7954949369081 | -122.41051503874701 | (37.7954949369081, -122.410515038747) | ||
| 38399 | 38399 | 129386 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 929 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009490.7484 | 2116033.66261 | 37.7907604245028 | -122.411039958651 | (37.7907604245028, -122.411039958651) | |||
| 74310 | 74310 | 129384 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008749.2926 | 2112454.6236099997 | 37.7808916402666 | -122.41335215429399 | (37.7808916402666, -122.413352154294) | |||
| 172851 | 172851 | 129382 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008704.563080001 | 2112447.63135 | 37.7808699297471 | -122.41350640150401 | (37.7808699297471, -122.413506401504) | |||
| 183197 | 183197 | 129383 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008721.10925 | 2112450.3341200002 | 37.7808782799549 | -122.413449351208 | (37.7808782799549, -122.413449351208) | |||
| 179963 | 179963 | 227566 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 Clover Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6000468.027480001 | 2104951.63177 | 37.7598218728073 | -122.44146247932301 | (37.7598218728073, -122.441462479323) | |||
| 153028 | 153028 | 129390 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 902 Vallejo St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009192.86484 | 2118752.75452 | 37.798209676283 | -122.41226288822399 | (37.798209676283, -122.412262888224) | |||
| 49701 | 49701 | 191228 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 901 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015254.00871 | 2096807.9147599998 | 37.7382922001146 | -122.38975576401 | (37.7382922001146, -122.38975576401) | |||
| 137533 | 137533 | 191229 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 901 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015272.35005 | 2096832.51763 | 37.7383607716336 | -122.389694066038 | (37.7383607716336, -122.389694066038) | |||
| 12688 | 12688 | 27048 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 896 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6007189.55023 | 2093517.44233 | 37.7288067843062 | -122.417405636178 | (37.7288067843062, -122.417405636178) | ||
| 11119 | 11119 | 27314 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 884 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3 | 3X3 | 6007123.27309 | 2093533.58449 | 37.728847377904394 | -122.41763590486799 | (37.7288473779044, -122.417635904868) | ||
| 36351 | 36351 | 119164 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981372.52859 | 2109725.62562 | 37.7718235084184 | -122.507857566702 | (37.7718235084184, -122.507857566702) | |||
| 4276 | 4276 | 180842 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 87 Laura St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:54:00 PM | 3 | Width 2ft | 5997291.8877 | 2087045.22216 | 37.710473721248 | -122.45115578601299 | (37.710473721248, -122.451155786013) | ||
| 113043 | 113043 | 115237 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775536 | 5982900.6 | 2109891.1 | 37.772367765473795 | -122.502584200594 | (37.7723677654738, -122.502584200594) | |||
| 175819 | 175819 | 117934 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982916.92515 | 2109877.9656700003 | 37.7723326617078 | -122.502526759002 | (37.7723326617078, -122.502526759002) | |||
| 47498 | 47498 | 119083 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) | |||
| 113001 | 113001 | 115239 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775147 | 5981970.6 | 2109880.3 | 37.7722834181785 | -122.505800301349 | (37.7722834181785, -122.505800301349) | |||
| 176002 | 176002 | 95742 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 86 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767488 | 6004830.443109999 | 2091416.58174 | 37.7229052675357 | -122.42541178684799 | (37.7229052675357, -122.425411786848) |
| 37420 | 37420 | 207024 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997067.34432 | 2090557.5942799998 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | |||
| 38084 | 38084 | 207023 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997061.0236599995 | 2090546.31892 | 37.7200737008175 | -122.452206152789 | (37.7200737008175, -122.452206152789) | |||
| 60679 | 60679 | 207022 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997053.5846 | 2090532.92812 | 37.720036506659206 | -122.452230901246 | (37.7200365066592, -122.452230901246) | |||
| 161119 | 161119 | 207025 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997075.91635 | 2090573.81293 | 37.72015004606371 | -122.45215665681299 | (37.7201500460637, -122.452156656813) | |||
| 61434 | 61434 | 227118 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005870.45988 | 2099040.93392 | 37.743898754514106 | -122.42235811905701 | (37.7438987545141, -122.422358119057) | |||
| 57528 | 57528 | 227572 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 841 Church St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004362.062530001 | 2104151.54801 | 37.7578461063327 | -122.42793790601499 | (37.7578461063327, -122.427937906015) | |||
| 98150 | 98150 | 43741 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
| 103046 | 103046 | 43742 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
| 112382 | 112382 | 43739 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
| 114348 | 114348 | 43740 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
| 44951 | 44951 | 227560 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000737.03493 | 2104555.7602 | 37.758750228049294 | -122.44050372379101 | (37.7587502280493, -122.440503723791) | |||
| 55628 | 55628 | 227559 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000741.2761699995 | 2104538.3206 | 37.758702584674204 | -122.44048780488001 | (37.7587025846742, -122.44048780488) | |||
| 133941 | 133941 | 227561 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6000738.66154 | 2104570.78605 | 37.7587915779822 | -122.44049917592 | (37.7587915779822, -122.44049917592) | |||
| 13068 | 13068 | 109689 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.7354700002 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) |
| 137158 | 137158 | 207029 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 835 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991723.94975 | 2089189.17612 | 37.7160401362134 | -122.47055564102301 | (37.7160401362134, -122.470555641023) | |||
| 178180 | 178180 | 207030 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 835 Sargent St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991738.49074 | 2089190.01168 | 37.716043271265704 | -122.470505441771 | (37.7160432712657, -122.470505441771) | |||
| 144924 | 144924 | 114895 | Private 5 | Lagunaria patersonii :: Primrose Tree 48 | 820 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | Permit Number 775427 | 5986664.4 | 2110325.3 | 37.7737804103986 | -122.489596975753 | (37.7737804103986, -122.489596975753) | |||
| 41920 | 41920 | 227112 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 82 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007863.71848 | 2099963.32211 | 37.7465436642568 | -122.41553116305 | (37.7465436642568, -122.41553116305) | |||
| 164734 | 164734 | 120000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 818 30th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5986676.70436 | 2110336.5469299997 | 37.7738120096448 | -122.489555240793 | (37.7738120096448, -122.489555240793) | |||
| 153496 | 153496 | 227150 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 808 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008185.203290001 | 2095640.9266099997 | 37.7346933830922 | -122.41411375505301 | (37.7346933830922, -122.414113755053) | |||
| 110202 | 110202 | 84332 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51851 | 5986981.94009984 | 2110441.32651783 | 37.7741175201244 | -122.488507097746 | (37.7741175201244, -122.488507097746) | ||
| 130069 | 130069 | 84554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 4 | 5986976.65331 | 2110412.96099 | 37.7740393278808 | -122.488523300237 | (37.7740393278808, -122.488523300237) | ||
| 143316 | 143316 | 102935 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 801X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.757774211767796 | -122.427824502367 | (37.7577742117678, -122.427824502367) | |||
| 11575 | 11575 | 27064 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 801 Silver Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2009 12:00:00 AM | 1 | 4 | 6007054.44286 | 2093598.3683099998 | 37.7290213868102 | -122.41787844665899 | (37.7290213868102, -122.417878446659) | ||
| 28351 | 28351 | 248531 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997658.267999999 | 2107761.8815 | 37.767377634072794 | -122.451382700243 | (37.7673776340728, -122.451382700243) | |||
| 78971 | 78971 | 51607 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) |
| 121418 | 121418 | 27081 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 799X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 126643 | 126643 | 27080 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 799X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 74077 | 74077 | 227120 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 799 Duncan St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6001486.2339699995 | 2099669.55813 | 37.7453765205103 | -122.43756273743 | (37.7453765205103, -122.43756273743) | |||
| 173018 | 173018 | 227119 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 799 Duncan St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6001473.16561 | 2099668.76787 | 37.7453736076231 | -122.437607869022 | (37.7453736076231, -122.437607869022) | |||
| 88126 | 88126 | 92664 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 791 San Bruno Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.759644317200106 | -122.404916188138 | (37.7596443172001, -122.404916188138) | |||
| 108202 | 108202 | 92665 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 791 San Bruno Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.759644317200106 | -122.404916188138 | (37.7596443172001, -122.404916188138) | |||
| 125423 | 125423 | 92663 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 791 San Bruno Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.759644317200106 | -122.404916188138 | (37.7596443172001, -122.404916188138) | |||
| 70932 | 70932 | 119542 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 791 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986618.95807 | 2110548.82595 | 37.7743914964818 | -122.48977060648899 | (37.7743914964818, -122.489770606489) | |||
| 167057 | 167057 | 227121 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 791 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001433.87774 | 2099966.59062 | 37.746189124520896 | -122.437765046244 | (37.7461891245209, -122.437765046244) | |||
| 13061 | 13061 | 27046 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 790 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 6 | 3X3 | 6006496.082169999 | 2093583.10222 | 37.728948030017904 | -122.419807663316 | (37.7289480300179, -122.419807663316) | ||
| 24713 | 24713 | 71549 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772812 | 6008431.05429 | 2114892.38013 | 37.7875672592553 | -122.41462566084101 | (37.7875672592553, -122.414625660841) |
| 41903 | 41903 | 73594 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2014 12:00:00 AM | 3 | Permit Number 772812 | 6008453.79298 | 2114896.74793 | 37.787580529660794 | -122.41454729843399 | (37.7875805296608, -122.414547298434) | |
| 118027 | 118027 | 79726 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50955 | 6008416.19534554 | 2114892.53002417 | 37.7875668360064 | -122.414677080613 | (37.7875668360064, -122.414677080613) | ||
| 74626 | 74626 | 227547 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 780 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001390.11593 | 2102052.79607 | 37.7519148588942 | -122.43806578220502 | (37.7519148588942, -122.438065782205) | |||
| 11808 | 11808 | 27083 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 773 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006444.73415 | 2093622.02758 | 37.729052017734794 | -122.419987938702 | (37.7290520177348, -122.419987938702) | ||
| 136694 | 136694 | 227083 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 770 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6008514.3452699995 | 2104071.33726 | 37.75785989922729 | -122.41357185686 | (37.7578598992273, -122.41357185686) | |||
| 162634 | 162634 | 95938 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 770 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767634 | 5986967.37973 | 2110670.26469 | 37.774745270265605 | -122.48857429400101 | (37.7747452702656, -122.488574294001) |
| 137003 | 137003 | 227579 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 77 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004499.29505 | 2107353.29779 | 37.7666451110058 | -122.427691415339 | (37.7666451110058, -122.427691415339) | |||
| 157288 | 157288 | 227587 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 77 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006751.41341 | 2109490.52204 | 37.7726405574578 | -122.42005339854201 | (37.7726405574578, -122.420053398542) | |||
| 33440 | 33440 | 176906 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 769 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006512.6379 | 2093630.87617 | 37.7290801395131 | -122.419753817278 | (37.7290801395131, -122.419753817278) | |||
| 169335 | 169335 | 176907 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 769 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006492.037819999 | 2093629.408 | 37.7290749477448 | -122.419824929392 | (37.7290749477448, -122.419824929392) | |||
| 95419 | 95419 | 117055 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 762 34th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2016 12:00:00 AM | 3 | Permit Number 778404 | 5985439.6 | 2110687.7 | 37.7747038750392 | -122.49386040463101 | (37.7747038750392, -122.493860404631) | |||
| 177664 | 177664 | 118188 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 762 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985415.78787 | 2110692.34221 | 37.7747152280145 | -122.49394311659901 | (37.7747152280145, -122.493943116599) | |||
| 159581 | 159581 | 52456 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 757 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2013 12:00:00 AM | 1 | Permit Number 770898 | 5992550.20906 | 2110320.92766 | 37.774110273254706 | -122.46923688790599 | (37.7741102732547, -122.469236887906) | |
| 179813 | 179813 | 137671 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 756 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000049.6788 | 2111547.4906 | 37.7779086039439 | -122.443383113797 | (37.7779086039439, -122.443383113797) | |||
| 129668 | 129668 | 207044 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 755 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998014.32968 | 2095894.50831 | 37.7348131350024 | -122.44929603208 | (37.7348131350024, -122.44929603208) | |||
| 11394 | 11394 | 27044 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 750 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1999 12:00:00 AM | 3 | 3X3 | 6006334.59281 | 2093563.7909400002 | 37.7288859066417 | -122.42036457476001 | (37.7288859066417, -122.42036457476) | ||
| 180870 | 180870 | 227099 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010635.77556 | 2100089.10311 | 37.7470444571367 | -122.40595450111401 | (37.7470444571367, -122.405954501114) | |||
| 139293 | 139293 | 38921 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.718159804985795 | -122.460857119734 | (37.7181598049858, -122.460857119734) | ||
| 59456 | 59456 | 106431 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 747 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008848.75367 | 2110684.34026 | 37.7760364460542 | -122.412882870049 | (37.7760364460542, -122.412882870049) | |||
| 74076 | 74076 | 120009 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 746 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5986962.570590001 | 2110820.51914 | 37.775157546008 | -122.48860197556101 | (37.775157546008, -122.488601975561) | |||
| 134834 | 134834 | 84816 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 736 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53031 | 6008319.9304599995 | 2115035.61847 | 37.7879543130824 | -122.415020270782 | (37.7879543130824, -122.415020270782) | |
| 56440 | 56440 | 117883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 734 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5982620.39521 | 2110769.29715 | 37.7747625699566 | -122.503618485147 | (37.7747625699566, -122.503618485147) | |||
| 56847 | 56847 | 71337 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 734 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 4 | 5982620.59121 | 2110750.54443 | 37.7747110919712 | -122.503616418137 | (37.7747110919712, -122.503616418137) | ||
| 10740 | 10740 | 27042 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 730 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6006159.1890199995 | 2093550.7367900002 | 37.7288401770086 | -122.420970032554 | (37.7288401770086, -122.420970032554) | ||
| 158616 | 158616 | 129380 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 730 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008321.927730001 | 2115014.63424 | 37.7878968077251 | -122.415011874722 | (37.7878968077251, -122.415011874722) | |||
| 11861 | 11861 | 117431 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 730 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776696 | 6004211.115780001 | 2091567.32576 | 37.7232841663055 | -122.42756340763901 | (37.7232841663055, -122.427563407639) | ||
| 109287 | 109287 | 50035 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 73 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46766 | 6007848.45417861 | 2093691.5625558 | 37.7293219318135 | -122.41514007459801 | (37.7293219318135, -122.415140074598) |
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");