trees
7,322 rows where qSpecies_id = 1 sorted by SiteOrder
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
927 | 260891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 839 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985392.72943 | 2110161.55054 | 37.7732564760791 | -122.493983752439 | (37.7732564760791, -122.493983752439) | 11 | 6 | 2 | 55 | 26 | |||
1030 | 260915 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Waller St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5999454.48308 | 2108393.47297 | 37.7692145145226 | -122.445215277932 | (37.7692145145226, -122.445215277932) | 15 | 5 | 11 | 29492 | 9 | |||
3289 | 262310 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356 20th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2016 12:00:00 AM | 5989914.31197 | 2106134.19071 | 37.7624619657204 | -122.478048663847 | (37.7624619657204, -122.478048663847) | 1 | 8 | 3 | 56 | 35 | |||||
4943 | 260913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 482 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997348.59542 | 2107447.85511 | 37.7664976608583 | -122.452431145559 | (37.7664976608583, -122.452431145559) | 15 | 5 | 11 | 29492 | 9 | |||
7475 | 260914 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1165 Oak St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 6001427.67727 | 2109710.45692 | 37.7729430567741 | -122.438484490103 | (37.7729430567741, -122.438484490103) | 15 | 5 | 11 | 29492 | 9 | |||
8909 | 259799 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1345 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011890.92519 | 2088681.18109 | 37.7157907972077 | -122.400812935252 | (37.7157907972077, -122.400812935252) | 10 | 7 | 8 | 309 | 39 | |||
9674 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
10126 | 88578 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Cabrillo St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51517 | 5990110.26399 | 2110629.43192 | 37.7748160474001 | -122.477699547866 | (37.7748160474001, -122.477699547866) | 11 | 6 | 2 | 55 | 26 | ||
10409 | 256902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
10744 | 260918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 469 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997465.89984 | 2107424.38822 | 37.7664399466471 | -122.452023719463 | (37.7664399466471, -122.452023719463) | 15 | 5 | 11 | 29492 | 9 | |||
14781 | 256563 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2504 Bush St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2019 12:00:00 AM | 3 | 3x3 | 6001466 | 2114633 | 37.7864612926293 | -122.438704721697 | (37.7864612926293, -122.438704721697) | 13 | 6 | 1 | 29490 | 27 | |||
16174 | 107381 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 MOSS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | 14 | 2 | 9 | 28853 | 34 | ||||||
18563 | 259805 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1249 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011760.82557 | 2089103.97372 | 37.71694444304 | -122.401292315923 | (37.71694444304, -122.401292315923) | 10 | 7 | 8 | 309 | 39 | |||
18906 | 258110 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 639 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x5 | 6009897.96561 | 2091634.59657 | 37.723788900764 | -122.407909701204 | (37.723788900764, -122.407909701204) | 10 | 3 | 7 | 309 | 28 | ||||
20053 | 88130 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 822 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51154 | 6001234 | 2099702 | 37.7454512540188 | -122.438437243524 | (37.7454512540188, -122.438437243524) | 2 | 4 | 5 | 63 | 22 | |||
21713 | 88316 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 447 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51307 | 6003165.8 | 2091093 | 37.7219225920035 | -122.431143024225 | (37.7219225920035, -122.431143024225) | 9 | 7 | 6 | 28861 | 5 | |||
23278 | 88325 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 346 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51314 | 6002623 | 2091442 | 37.7228500939634 | -122.433044266804 | (37.7228500939634, -122.433044266804) | 9 | 7 | 6 | 28861 | 5 | |||
23696 | 108446 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 672 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.53978 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | 11 | 6 | 2 | 54 | 11 | |||
23904 | 88195 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 443 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51199 | 6011062 | 2112189 | 37.7802918756168 | -122.405332612017 | (37.7802918756168, -122.405332612017) | 14 | 2 | 9 | 28853 | 34 | |||
24253 | 86716 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 396 Capp St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49702 | 6007196 | 2105003 | 37.7603439142388 | -122.418197308773 | (37.7603439142388, -122.418197308773) | 2 | 4 | 7 | 28859 | 19 | ||||
25244 | 107382 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 MOSS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | 14 | 2 | 9 | 28853 | 34 | ||||||
26545 | 88331 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 635 Madrid St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51319 | 6002224 | 2090226 | 37.7194885890815 | -122.434336629443 | (37.7194885890815, -122.434336629443) | 9 | 7 | 6 | 28861 | 5 | |||
28128 | 86714 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 858 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49701 | 6001009 | 2099689 | 37.745402758221 | -122.439214324332 | (37.745402758221, -122.439214324332) | 2 | 4 | 5 | 63 | 22 | ||||
32071 | 86715 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 868 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49700 | 6001011.7 | 2099706.8 | 37.7454517864355 | -122.439206263756 | (37.7454517864355, -122.439206263756) | 2 | 4 | 5 | 63 | 22 | ||||
35267 | 256901 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
36980 | 105047 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 278 Capitol Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995102.4 | 2087946.7 | 37.7128233663074 | -122.458788296392 | (37.7128233663074, -122.458788296392) | 9 | 8 | 6 | 28861 | 24 | |||||
38477 | 94887 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1570 Underwood Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53953 | 6014750 | 2093656.9 | 37.7296121929682 | -122.391278188352 | (37.7296121929682, -122.391278188352) | 10 | 3 | 8 | 58 | 1 | ||
40296 | 89346 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 110 Hoffman Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51930 | 6000570.6 | 2102426.2 | 37.75289349552 | -122.440926561392 | (37.75289349552, -122.440926561392) | 2 | 4 | 5 | 28862 | 22 | ||||
42526 | 88341 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 51 Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51327 | 6004823 | 2090807 | 37.7212310687473 | -122.425394157088 | (37.7212310687473, -122.425394157088) | 9 | 7 | 6 | 28861 | 5 | |||
46403 | 256899 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
47294 | 254847 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 124 Corbett Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779287 | 6000581.14651 | 2105634.12075 | 37.7617022635467 | -122.441120222786 | (37.7617022635467, -122.441120222786) | 15 | 5 | 5 | 28862 | 3 | |
50227 | 89042 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Taylor St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51781 | 6009231 | 2115470 | 37.7891981742353 | -122.411898830301 | (37.7891981742353, -122.411898830301) | 5 | 1 | 10 | 28857 | 21 | |||
52170 | 117347 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1149 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | 2 | 4 | 5 | 28862 | 22 | ||||||
53132 | 88406 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1716 Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51383 | 6007055 | 2117126 | 37.7936228211286 | -122.419545076389 | (37.7936228211286, -122.419545076389) | 5 | 9 | 10 | 28858 | 32 | |||
55837 | 94871 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1578 Innes Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53941 | 6015653.4 | 2097175.2 | 37.7393228299093 | -122.388400481487 | (37.7393228299093, -122.388400481487) | 10 | 3 | 8 | 58 | 1 | ||
62085 | 88196 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 451 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51200 | 6011010 | 2112139 | 37.7801516798572 | -122.405508982546 | (37.7801516798572, -122.405508982546) | 14 | 2 | 9 | 28853 | 34 | |||
64114 | 89345 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 110 Hoffman Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51930 | 6000570.6 | 2102426.2 | 37.75289349552 | -122.440926561392 | (37.75289349552, -122.440926561392) | 2 | 4 | 5 | 28862 | 22 | ||||
65019 | 88089 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1870 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51092 | 5984476.8 | 2102440.2 | 37.7520021836437 | -122.496582125316 | (37.7520021836437, -122.496582125316) | 1 | 8 | 3 | 56 | 35 | |||
67712 | 88194 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 415 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51198 | 6011246 | 2112365 | 37.7807854162198 | -122.404708461336 | (37.7807854162198, -122.404708461336) | 14 | 2 | 9 | 28853 | 34 | |||
70896 | 88198 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 468 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51202 | 6010823.8 | 2112095.6 | 37.7800221004896 | -122.406150077984 | (37.7800221004896, -122.406150077984) | 14 | 2 | 9 | 28853 | 34 | |||
72944 | 88128 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 814 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51153 | 6001284 | 2099705 | 37.7454623352517 | -122.438264566721 | (37.7454623352517, -122.438264566721) | 2 | 4 | 5 | 63 | 22 | |||
76126 | 106373 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 189 College Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/23/2014 12:00:00 AM | 3X3 | Permit Number 771157 | 6004972.1 | 2095958.7 | 37.7353849208155 | -122.425245160296 | (37.7353849208155, -122.425245160296) | 2 | 7 | 5 | 28861 | 2 | |||
76474 | 108500 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 133 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773778 | 5993020.3424 | 2114605.60013 | 37.7859019761698 | -122.467922339348 | (37.7859019761698, -122.467922339348) | 11 | 6 | 2 | 54 | 11 | |
78259 | 256898 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
78563 | 253155 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 546 Ellington Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:02:00 AM | 3 | 3x3 | 5997941 | 2087090 | 37.7106338144896 | -122.44891554829 | (37.7106338144896, -122.44891554829) | 9 | 7 | 6 | 28861 | 25 | |||
81370 | 256662 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Broadway | : | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | Permit Number 782593 | 6007370.8774 | 2118134.97157 | 37.7964109931986 | -122.418523691035 | (37.7964109931986, -122.418523691035) | 5 | 1 | 10 | 28858 | 32 | ||
84245 | 87769 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1000 Chenery St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50473 | 6000787 | 2096209 | 37.7358348629687 | -122.439732514448 | (37.7358348629687, -122.439732514448) | 2 | 7 | 5 | 63 | 7 | |||
90552 | 255307 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 106 Drake St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 03/13/1995 12:00:00 AM | 3x3 | Permit Number 34781 | 6001467.59688 | 2086758.78717 | 37.709925429543 | -122.436703176018 | (37.709925429543, -122.436703176018) | 9 | 7 | 6 | 28861 | 5 | ||
99042 | 86717 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 396 Capp St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49702 | 6007196 | 2105003 | 37.7603439142388 | -122.418197308773 | (37.7603439142388, -122.418197308773) | 2 | 4 | 7 | 28859 | 19 | ||||
100664 | 87774 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 89 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 50479 | 6002385.3 | 2096237.8 | 37.7360047860148 | -122.434208627308 | (37.7360047860148, -122.434208627308) | 2 | 7 | 5 | 63 | 7 | ||
101521 | 88603 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3317 Washington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51548 | 5998920 | 2115920 | 37.7898498881276 | -122.447605887375 | (37.7898498881276, -122.447605887375) | 13 | 6 | 1 | 54 | 31 | |||
103547 | 94130 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Massasoit St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53496 | 6010073 | 2099348 | 37.7449780589808 | -122.407848289369 | (37.7449780589808, -122.407848289369) | 2 | 7 | 7 | 28859 | 2 | |||
103823 | 88097 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1883 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51100 | 5983774.4 | 2102354.2 | 37.751724874757 | -122.499004735194 | (37.751724874757, -122.499004735194) | 1 | 8 | 3 | 56 | 35 | |||
104592 | 254765 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 180 Howth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781608 | 5997468.16885 | 2090909.73421 | 37.7210948695788 | -122.450824986799 | (37.7210948695788, -122.450824986799) | 9 | 8 | 6 | 28861 | 24 | |
105263 | 88343 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1118 Russia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51328 | 6004013.1 | 2089324 | 37.7171132835762 | -122.428088120605 | (37.7171132835762, -122.428088120605) | 9 | 7 | 6 | 28861 | 5 | |||
105284 | 88197 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 452 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51201 | 6010979 | 2112145 | 37.7801664210421 | -122.405616648952 | (37.7801664210421, -122.405616648952) | 14 | 2 | 9 | 28853 | 34 | |||
106314 | 88404 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51381 | 6007655 | 2116328 | 37.7914654879488 | -122.417412441264 | (37.7914654879488, -122.417412441264) | 5 | 1 | 10 | 28858 | 21 | |||
108993 | 88574 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 508 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51514 | 5990337.58297 | 2111891.03116 | 37.778293240831 | -122.477005418758 | (37.778293240831, -122.477005418758) | 11 | 6 | 2 | 55 | 26 | ||
109103 | 86742 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 146 28th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2007 12:00:00 AM | Permit Number 49709 | 6004940 | 2099613 | 37.7454169862193 | -122.42561614309 | (37.7454169862193, -122.42561614309) | 2 | 7 | 5 | 63 | 22 | ||||
110772 | 88584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 686 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51527 | 5988498.88719 | 2111336.23629 | 37.7766630901688 | -122.483325390193 | (37.7766630901688, -122.483325390193) | 11 | 6 | 2 | 55 | 26 | ||
116932 | 88250 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4901 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51236 | 5997843 | 2105622 | 37.7615126378881 | -122.450589449092 | (37.7615126378881, -122.450589449092) | 15 | 5 | 11 | 29492 | 12 | |||
119036 | 89328 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 376 16th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52512 | 5990923.61484 | 2112893.52496 | 37.7810797921954 | -122.475051338659 | (37.7810797921954, -122.475051338659) | 11 | 6 | 2 | 54 | 26 | ||
119138 | 88405 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1140 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51382 | 6007541.2 | 2118862 | 37.7984168187982 | -122.417985902037 | (37.7984168187982, -122.417985902037) | 5 | 1 | 10 | 28858 | 32 | |||
121278 | 88579 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 767 19th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51519 | 5990042.42754 | 2110151.2798 | 37.7734992361062 | -122.477899243352 | (37.7734992361062, -122.477899243352) | 11 | 6 | 2 | 55 | 26 | ||
121391 | 88199 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 480 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51207 | 6010751.4 | 2112033.7 | 37.7798480877104 | -122.406396180597 | (37.7798480877104, -122.406396180597) | 14 | 2 | 9 | 28853 | 34 | |||
122116 | 88279 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3104 Buchanan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51271 | 6003396 | 2118973 | 37.7984874284796 | -122.432337488027 | (37.7984874284796, -122.432337488027) | 13 | 9 | 1 | 57 | 17 | |||
123592 | 93488 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1606 Guerrero St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53237 | 6005836 | 2099575 | 37.745363234828 | -122.422515215131 | (37.745363234828, -122.422515215131) | 2 | 7 | 5 | 28859 | 22 | |||
126622 | 88600 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1681 Noe St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51544 | 6003389 | 2098448 | 37.7421304044314 | -122.430896121876 | (37.7421304044314, -122.430896121876) | 2 | 7 | 5 | 63 | 22 | |||
127435 | 88333 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 443 Naples St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51321 | 6003357 | 2091009 | 37.7217027796011 | -122.430476104013 | (37.7217027796011, -122.430476104013) | 9 | 7 | 6 | 28861 | 5 | |||
133441 | 87780 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 731 Cayuga Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50512 | 6001494.8 | 2092776.9 | 37.7264513669203 | -122.437039734194 | (37.7264513669203, -122.437039734194) | 9 | 7 | 6 | 28861 | 25 | |||
137019 | 256903 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
137697 | 88493 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1771 Quint St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51435 | 6012552 | 2095619 | 37.7348774836514 | -122.399014615643 | (37.7348774836514, -122.399014615643) | 10 | 3 | 8 | 58 | 1 | |||
138092 | 88311 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Athens St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51302 | 6005208 | 2092949 | 37.7271342768906 | -122.42421558283 | (37.7271342768906, -122.42421558283) | 9 | 7 | 6 | 28861 | 5 | |||
138500 | 87779 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 658 Cayuga Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50510 | 6001646.6 | 2093292.7 | 37.7278762635986 | -122.4365518718 | (37.7278762635986, -122.4365518718) | 9 | 7 | 6 | 28861 | 25 | |||
140216 | 88125 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51131 | 6002546 | 2096093 | 37.7356163180793 | -122.433642678051 | (37.7356163180793, -122.433642678051) | 2 | 7 | 5 | 63 | 7 | |||
140893 | 87778 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 428 Cayuga Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50509 | 6002088.1 | 2093915.1 | 37.729610311417 | -122.435070094369 | (37.729610311417, -122.435070094369) | 9 | 7 | 6 | 28861 | 25 | |||
144574 | 88374 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 39 14th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51352 | 5991453.97729 | 2114946.07033 | 37.7867462367263 | -122.473366318389 | (37.7867462367263, -122.473366318389) | 11 | 6 | 1 | 54 | 33 | ||
149360 | 88502 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 81 Topeka Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51440 | 6012361 | 2095362.9 | 37.7341636411904 | -122.399656997878 | (37.7341636411904, -122.399656997878) | 10 | 3 | 8 | 58 | 1 | |||
153832 | 89294 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 227 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2008 12:00:00 AM | 3x3 | Permit Number 51900 | 6010130.2 | 2111260.4 | 37.7776900173559 | -122.408490632427 | (37.7776900173559, -122.408490632427) | 14 | 2 | 9 | 28853 | 34 | |||
155189 | 88344 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1127 Russia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51329 | 6004077 | 2089373.5 | 37.7172528149217 | -122.427870773903 | (37.7172528149217, -122.427870773903) | 9 | 7 | 6 | 28861 | 5 | |||
156012 | 88334 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 470 Naples St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51322 | 6003225 | 2090876 | 37.7213301126481 | -122.430922905786 | (37.7213301126481, -122.430922905786) | 9 | 7 | 6 | 28861 | 5 | |||
158583 | 256900 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
159231 | 88437 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 424 Garfield St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51401 | 5992930 | 2090509 | 37.7197337184937 | -122.46648286823 | (37.7197337184937, -122.46648286823) | 9 | 8 | 6 | 64 | 24 | |||
162331 | 97175 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
163146 | 88963 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 680 27th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51728 | 5987564.38128 | 2111326.55276 | 37.7765820711416 | -122.486557367772 | (37.7765820711416, -122.486557367772) | 11 | 6 | 2 | 55 | 26 | ||
163320 | 256661 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Broadway | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782593 | 6007370.8774 | 2118134.97157 | 37.7964109931986 | -122.418523691035 | (37.7964109931986, -122.418523691035) | 5 | 1 | 10 | 28858 | 32 | |
163346 | 88375 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 365 14th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51353 | 5991523.32351 | 2112975.72447 | 37.7813402274639 | -122.472982663209 | (37.7813402274639, -122.472982663209) | 11 | 6 | 2 | 54 | 26 | ||
168599 | 88237 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 294 Parker Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51226 | 5997108.3 | 2112520.1 | 37.780410959581 | -122.453628569099 | (37.780410959581, -122.453628569099) | 11 | 6 | 2 | 54 | 16 | |||
170498 | 106300 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 28th St | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772857 | 6001494.5 | 2099363.3 | 37.7445360779925 | -122.437512227288 | (37.7445360779925, -122.437512227288) | 2 | 7 | 5 | 63 | 22 | |||||
171941 | 86718 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 396 Capp St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49702 | 6007196 | 2105003 | 37.7603439142388 | -122.418197308773 | (37.7603439142388, -122.418197308773) | 2 | 4 | 7 | 28859 | 19 | ||||
176689 | 256667 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1674 Washington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782599 | 6006687.27852 | 2117040.19177 | 37.79336649376 | -122.420811331011 | (37.79336649376, -122.420811331011) | 13 | 9 | 10 | 28858 | 32 | |
178021 | 88558 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 422 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51503 | 5990315.69001 | 2112483.17966 | 37.7799178466375 | -122.477124436548 | (37.7799178466375, -122.477124436548) | 11 | 6 | 2 | 55 | 26 | ||
178648 | 88328 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 691 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51316 | 6001466.3 | 2089490.7 | 37.7174265827267 | -122.436903104291 | (37.7174265827267, -122.436903104291) | 9 | 7 | 6 | 28861 | 5 | |||
178714 | 88105 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1509 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51109 | 5981537.1 | 2104800.5 | 37.7583102301918 | -122.506922920506 | (37.7583102301918, -122.506922920506) | 1 | 8 | 3 | 56 | 35 | |||
180707 | 88587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 819 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51530 | 5988484.50647 | 2110381.54672 | 37.7740409418314 | -122.483305137644 | (37.7740409418314, -122.483305137644) | 11 | 6 | 2 | 55 | 26 | ||
183761 | 88129 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 814 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51153 | 6001284 | 2099705 | 37.7454623352517 | -122.438264566721 | (37.7454623352517, -122.438264566721) | 2 | 4 | 5 | 63 | 22 | |||
183776 | 88342 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1118 Russia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51328 | 6004013.1 | 2089324 | 37.7171132835762 | -122.428088120605 | (37.7171132835762, -122.428088120605) | 9 | 7 | 6 | 28861 | 5 | |||
184166 | 115674 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1433 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774098 | 5981190.2 | 2105303.4 | 37.7596706142775 | -122.508159957785 | (37.7596706142775, -122.508159957785) | 1 | 8 | 3 | 56 | 35 | ||
185069 | 88590 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 879 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51534 | 5988496.55616 | 2110024.26731 | 37.7730606531011 | -122.483237261836 | (37.7730606531011, -122.483237261836) | 11 | 6 | 2 | 55 | 26 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );