Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24382 | 24382 | 96110 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 714 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767765 | 5982615.54512 | 2110891.71154 | 37.7750983990599 | -122.503644329704 | (37.7750983990599, -122.503644329704) |
25321 | 25321 | 227575 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001460.70601 | 2108045.90078 | 37.7683744785129 | -122.43825097062 | (37.7683744785129, -122.43825097062) | |||
25567 | 25567 | 227123 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002011.92527 | 2100876.5046200003 | 37.748720385135705 | -122.43583132576201 | (37.7487203851357, -122.435831325762) | |||
25776 | 25776 | 227129 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 291 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001319.20971 | 2096463.3667400002 | 37.7365635736601 | -122.43791067344401 | (37.7365635736601, -122.437910673444) | |||
26976 | 26976 | 82736 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3219 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767127 | 5984285.2795 | 2103578.3364 | 37.755115968323395 | -122.49732843264 | (37.7551159683234, -122.49732843264) |
31319 | 31319 | 176877 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.709910397621705 | -122.396487432357 | (37.7099103976217, -122.396487432357) | |||
32349 | 32349 | 184697 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1616 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982844.3503 | 2104136.3629 | 37.7565635951525 | -122.502352798468 | (37.7565635951525, -122.502352798468) | |||
33050 | 33050 | 95911 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1845 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767612 | 5989071.1412 | 2105102.6181 | 37.7595805696676 | -122.480889318141 | (37.7595805696676, -122.480889318141) |
33343 | 33343 | 227094 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 35 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6009153.630890001 | 2095762.56962 | 37.7350817355269 | -122.410774146024 | (37.7350817355269, -122.410774146024) | ||||
35674 | 35674 | 227569 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 287 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002739.75043 | 2104260.6213 | 37.7580536824469 | -122.43355632787201 | (37.7580536824469, -122.433556327872) | |||
36879 | 36879 | 69182 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1371 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50160 | 5982122.5039 | 2105769.199 | 37.7610044592096 | -122.50497015556499 | (37.7610044592096, -122.504970155565) | |
37145 | 37145 | 176886 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 119 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002169.33644 | 2093633.7193099998 | 37.7288423165165 | -122.434769138285 | (37.7288423165165, -122.434769138285) | |||
38736 | 38736 | 100491 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3978 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770312 | 5995766.62837 | 2114872.73446 | 37.786793659691895 | -122.45844035359801 | (37.7867936596919, -122.458440353598) | |
39635 | 39635 | 207026 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 229 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994724.722630001 | 2088692.2453700001 | 37.71484874224021 | -122.460147642199 | (37.7148487422402, -122.460147642199) | |||
41197 | 41197 | 227088 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6009533.30641 | 2096029.17809 | 37.7358350661275 | -122.409480276115 | (37.7358350661275, -122.409480276115) | |||
42710 | 42710 | 227127 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000615.36032 | 2102512.03507 | 37.7531317270504 | -122.44077792887501 | (37.7531317270504, -122.440777928875) | |||
43413 | 43413 | 251006 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 348 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5981660.38525 | 2112713.01394 | 37.780042954548705 | -122.50708351880199 | (37.7800429545487, -122.507083518802) | |||
47267 | 47267 | 47826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4350 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 2 | Permit Number 45588 | 5982100.44481 | 2110341.3807200002 | 37.773557052971704 | -122.50538534555099 | (37.7735570529717, -122.505385345551) | |
48057 | 48057 | 227570 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 287 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002738.3349 | 2104276.75984 | 37.7580979146911 | -122.43356237671101 | (37.7580979146911, -122.433562376711) | |||
48341 | 48341 | 41809 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 2 | Permit Number 42201 | 5999967.3577 | 2112168.7485 | 37.779609724261896 | -122.443712533479 | (37.7796097242619, -122.443712533479) | |
48823 | 48823 | 39959 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 492 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 2 | Permit Number 43327 | 5993771.39961 | 2112170.75464 | 37.7792598926327 | -122.465146995833 | (37.7792598926327, -122.465146995833) | |
49688 | 49688 | 119982 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5987459.3505 | 2114288.69945 | 37.7847091625278 | -122.487138302864 | (37.7847091625278, -122.487138302864) | |||
50222 | 50222 | 113489 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 40 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x10 | 5995526.6518 | 2115672.85646 | 37.7889767847188 | -122.45932857543 | (37.7889767847188, -122.45932857543) | |||
50907 | 50907 | 207039 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 270 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994635.03268 | 2100302.9111 | 37.7467236374953 | -122.461298810415 | (37.7467236374953, -122.461298810415) | |||
52837 | 52837 | 207008 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 451 Hearst Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998589.10288 | 2094366.3057 | 37.730649912467 | -122.447198902106 | (37.730649912467, -122.447198902106) | |||
53235 | 53235 | 191238 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6014118.19632 | 2095356.58877 | 37.734244107869294 | -122.393581327137 | (37.7342441078693, -122.393581327137) | |||
58411 | 58411 | 248399 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998223.6499 | 2108104.3812 | 37.768350409277396 | -122.449451812394 | (37.7683504092774, -122.449451812394) | |||
58669 | 58669 | 118593 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5982449.24993 | 2112557.22359 | 37.7796616287576 | -122.504342981812 | (37.7796616287576, -122.504342981812) | |||
59266 | 59266 | 207018 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 466 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5997114.73821 | 2093838.00202 | 37.7291149630685 | -122.452257872798 | (37.7291149630685, -122.452257872798) | |||
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) | |||
60843 | 60843 | 227110 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008268.06848 | 2099378.0671099997 | 37.7449594041621 | -122.41409156248001 | (37.7449594041621, -122.41409156248) | |||
63459 | 63459 | 184208 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1474 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983740.5189 | 2105133.2538 | 37.759353393050105 | -122.49932723943 | (37.7593533930501, -122.49932723943) | |||
67482 | 67482 | 92392 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2506 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52796 | 5986151.5297 | 2098152.0694 | 37.7403261082431 | -122.49047530282301 | (37.7403261082431, -122.490475302823) |
72063 | 72063 | 176879 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 140 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010956.3364 | 2092967.7781599998 | 37.7275087379234 | -122.404344863032 | (37.7275087379234, -122.404344863032) | |||
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) | |||
76473 | 76473 | 227105 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 436 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5998543.730830001 | 2106633.91182 | 37.7643311769734 | -122.448238788212 | (37.7643311769734, -122.448238788212) | |||
130789 | 130789 | 176890 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 18 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003663.21456 | 2093989.9827 | 37.7299052360341 | -122.429630099158 | (37.7299052360341, -122.429630099158) | |||
131908 | 131908 | 227583 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002133.89525 | 2108814.30402 | 37.7705225892763 | -122.435977464701 | (37.7705225892763, -122.435977464701) | |||
132512 | 132512 | 68546 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 707 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767769 | 5982568.02637 | 2110928.64305 | 37.775197008277296 | -122.503811440592 | (37.7751970082773, -122.503811440592) |
132639 | 132639 | 183523 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2542 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986781.4828 | 2097933.2945 | 37.7397621847049 | -122.488281131206 | (37.7397621847049, -122.488281131206) | |||
133327 | 133327 | 43975 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4527 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2000 12:00:00 AM | 2 | Permit Number 43537 | 5981491.7088 | 2110943.54345 | 37.7751745750496 | -122.50753570575 | (37.7751745750496, -122.50753570575) | ||
134721 | 134721 | 227548 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 290 Jersey St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6003268.76291 | 2101573.30364 | 37.7507049460775 | -122.43153493071199 | (37.7507049460775, -122.431534930712) | |||
134809 | 134809 | 227089 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6009456.29094 | 2095946.4902299999 | 37.735603707435395 | -122.409740715285 | (37.7356037074354, -122.409740715285) | |||
135797 | 135797 | 51532 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3155 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 2 | Permit Number 47834 | 5999712.30266 | 2115373.4309400003 | 37.78839440084 | -122.44482529806001 | (37.78839440084, -122.44482529806) | ||
135940 | 135940 | 176875 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012929.76757 | 2086570.3757 | 37.710052832254796 | -122.39707427417801 | (37.7100528322548, -122.397074274178) | |||
136757 | 136757 | 176881 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3303 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011991.79808 | 2090250.44255 | 37.7201052985 | -122.400574440964 | (37.7201052985, -122.400574440964) | |||
137843 | 137843 | 227576 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 31 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001461.4908300005 | 2108058.43392 | 37.768408936048004 | -122.438249153978 | (37.768408936048, -122.438249153978) | |||
146826 | 146826 | 176876 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013031.567530001 | 2086536.06642 | 37.7099642921874 | -122.396720027609 | (37.7099642921874, -122.396720027609) | |||
147287 | 147287 | 207017 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5997128.211759999 | 2093837.95674 | 37.7291156105912 | -122.452211290622 | (37.7291156105912, -122.452211290622) | |||
153714 | 153714 | 118592 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5982471.06333 | 2112548.68274 | 37.779639461018796 | -122.504266888216 | (37.7796394610188, -122.504266888216) | |||
154067 | 154067 | 176880 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3333 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012013.01229 | 2090122.1042900002 | 37.719754090752204 | -122.40049209994801 | (37.7197540907522, -122.400492099948) | |||
157761 | 157761 | 116545 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 3x3 | 6001537.057630001 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | |||
159779 | 159779 | 227135 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 11 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5999460.85655 | 2100362.14837 | 37.7471628438967 | -122.444615908893 | (37.7471628438967, -122.444615908893) | |||
160494 | 160494 | 227106 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 436 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5998542.97606 | 2106650.29925 | 37.7643761295797 | -122.448242578852 | (37.7643761295797, -122.448242578852) | |||
160817 | 160817 | 176903 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 290 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005283.95555 | 2093790.15237 | 37.729448184373105 | -122.424012796049 | (37.7294481843731, -122.424012796049) | |||
161381 | 161381 | 245893 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1001 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001728.4463 | 2109399.5631 | 37.772106523732 | -122.437421829009 | (37.772106523732, -122.437421829009) | |||
162362 | 162362 | 96799 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 438 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 2 | Permit Number 769004 | 5983479.2923099995 | 2112857.21489 | 37.780545845051705 | -122.500801866987 | (37.7805458450517, -122.500801866987) | ||
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) |
164615 | 164615 | 250999 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 206 Point Lobos Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5982160.80138 | 2112648.7463599998 | 37.7798959540729 | -122.505347618625 | (37.7798959540729, -122.505347618625) | |||
165309 | 165309 | 118692 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4549 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5981428.283009999 | 2110941.30275 | 37.7751646862289 | -122.507754939589 | (37.7751646862289, -122.507754939589) | |||
166221 | 166221 | 120804 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 689 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989715.19561 | 2110680.27165 | 37.774932704327 | -122.47906987573299 | (37.774932704327, -122.479069875733) | |||
168844 | 168844 | 92401 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1215 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52801 | 5985169.7 | 2106911.6 | 37.764319978357896 | -122.494515603708 | (37.7643199783579, -122.494515603708) |
169835 | 169835 | 227154 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 211 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006179.62036 | 2101927.37044 | 37.751841686457894 | -122.42149406392001 | (37.7518416864579, -122.42149406392) | |||
172020 | 172020 | 184126 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1643 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986219.0266 | 2104040.7857 | 37.756498872957394 | -122.490675089245 | (37.7564988729574, -122.490675089245) | |||
173618 | 173618 | 207031 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1528 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992776.06817 | 2105054.20165 | 37.7596622898883 | -122.46807242402599 | (37.7596622898883, -122.468072424026) | |||
179043 | 179043 | 201807 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 273 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 6ft | 6020893.117219999 | 2092989.08595 | 37.728117517799795 | -122.36999438334298 | (37.7281175177998, -122.369994383343) | |||
179922 | 179922 | 227114 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1168 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008645.7783699995 | 2101760.1601299997 | 37.7515213083843 | -122.412953897625 | (37.7515213083843, -122.412953897625) | |||
183647 | 183647 | 80237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985295.5529 | 2103816.7715 | 37.7558298048279 | -122.49385223473601 | (37.7558298048279, -122.493852234736) | |||
184902 | 184902 | 95429 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1437 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767294 | 5988962.2823 | 2105532.8441 | 37.760755525792 | -122.48129730761801 | (37.760755525792, -122.481297307618) |
185857 | 185857 | 227155 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3460 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007164.41586 | 2104418.82 | 37.758738113297795 | -122.418265124561 | (37.7587381132978, -122.418265124561) |
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");