trees
194,517 rows sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2227 | 28919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009994.1526974 | 2111207.6693813 | 37.7775376115192 | -122.408957547154 | (37.7775376115192, -122.408957547154) | 8 | 2 | 9 | 28853 | 34 | ||
2232 | 26076 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 269 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994312.4294 | 2088054.8516 | 37.7130748868127 | -122.461526506385 | (37.7130748868127, -122.461526506385) | 9 | 8 | 6 | 28861 | 24 | ||
2259 | 124122 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4500 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/1996 12:00:00 AM | 7 | Width 3ft | 5992964.88575 | 2112821.48622 | 37.7810000844067 | -122.467984383057 | (37.7810000844067, -122.467984383057) | 11 | 6 | 2 | 54 | 11 | ||
2270 | 139543 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000646.9933 | 2113045.3455 | 37.7820553756462 | -122.441424306243 | (37.7820553756462, -122.441424306243) | 15 | 5 | 1 | 29490 | 41 | |||
2284 | 122861 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996437.5077 | 2087153.60444 | 37.7107223595138 | -122.454116512475 | (37.7107223595138, -122.454116512475) | 9 | 7 | 6 | 28861 | 25 | ||
2334 | 15528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2792 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2018 12:00:00 AM | 3 | 3X3 | 6007034.2153 | 2102142.536 | 37.7524806306406 | -122.418554005951 | (37.7524806306406, -122.418554005951) | 2 | 4 | 7 | 28859 | 19 | ||
2354 | 65134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 608 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | 8 | Permit Number 27109 | 5984138.754 | 2111678.31461 | 37.7773476222303 | -122.498433409341 | (37.7773476222303, -122.498433409341) | 11 | 6 | 2 | 55 | 26 | |
2368 | 232423 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004499.74747 | 2103689.91865 | 37.7565863692953 | -122.427428848357 | (37.7565863692953, -122.427428848357) | 2 | 4 | 5 | 28862 | 3 | |||
2372 | 254866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2828 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x6 | 5996346 | 2087845 | 37.7126155239422 | -122.454482695042 | (37.7126155239422, -122.454482695042) | 9 | 8 | 6 | 28861 | 24 | ||
2475 | 259866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
2476 | 61679 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 11 | Permit Number 21676 | 6013741.75867 | 2093626.49588 | 37.729472702598 | -122.394761681005 | (37.729472702598, -122.394761681005) | 10 | 3 | 8 | 58 | 1 | |
2477 | 26317 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2045 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1997 12:00:00 AM | 3 | 3X3 | 5999556.95115 | 2091956.24005 | 37.7240876853785 | -122.443679842351 | (37.7240876853785, -122.443679842351) | 9 | 7 | 6 | 28861 | 25 | ||
2533 | 198095 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1218 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011929.10622 | 2102668.35998 | 37.7541987852492 | -122.401663505566 | (37.7541987852492, -122.401663505566) | 10 | 3 | 8 | 28856 | 29 | |||
2574 | 216200 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1650 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 784456 | 5992806.74011 | 2104217.97153 | 37.7573679916535 | -122.467905522425 | (37.7573679916535, -122.467905522425) | 1 | 8 | 4 | 56 | 12 | |
2576 | 241978 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007949.4317 | 2096517.7297 | 37.7370876472613 | -122.414990939375 | (37.7370876472613, -122.414990939375) | 2 | 7 | 7 | 28859 | 2 | |||
2622 | 65282 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 445 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28089 | 6011007.15755 | 2112137.38618 | 37.7801470897487 | -122.405518702235 | (37.7801470897487, -122.405518702235) | 14 | 2 | 9 | 28853 | 34 | |
2642 | 241718 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009951.86526 | 2100053.1098 | 37.7469073537049 | -122.40831687712 | (37.7469073537049, -122.40831687712) | 2 | 7 | 7 | 28859 | 2 | |||
2643 | 112356 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009373.44227 | 2114078.66133 | 37.7853858834919 | -122.411307667026 | (37.7853858834919, -122.411307667026) | 14 | 10 | 9 | 28852 | 36 | |||
2673 | 218475 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200 Capitol Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995091.16057 | 2091998.49619 | 37.7239479909859 | -122.459120352046 | (37.7239479909859, -122.459120352046) | 9 | 8 | 4 | 28861 | 24 | |||
2686 | 42160 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 583 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 6 | Permit Number 42455 | 5988424.33679 | 2112023.8597 | 37.7785467725028 | -122.483633704561 | (37.7785467725028, -122.483633704561) | 11 | 6 | 2 | 55 | 26 | |
2704 | 214942 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 40 San Andreas Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993797.90543 | 2095609.88239 | 37.7337895410509 | -122.463852902986 | (37.7337895410509, -122.463852902986) | 9 | 8 | 4 | 59 | 40 | |||
2729 | 171547 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 332 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6006051.63014 | 2092221.41299 | 37.725184080371 | -122.421247513879 | (37.725184080371, -122.421247513879) | 9 | 7 | 7 | 309 | 5 | |||
2801 | 57909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 900 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/1977 12:00:00 AM | 3 | Permit Number 16867 | 6009529.40724 | 2116088.3946 | 37.790912873091 | -122.410910067748 | (37.790912873091, -122.410910067748) | 5 | 1 | 10 | 28857 | 21 | |
2815 | 62472 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 139 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 9 | Permit Number 22643 | 6001469.26063 | 2093519.40721 | 37.7284886706995 | -122.43718116229 | (37.7284886706995, -122.43718116229) | 9 | 7 | 6 | 28861 | 25 | |
2866 | 241596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 699x Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007776 | 2095716 | 37.7348765256695 | -122.415533827638 | (37.7348765256695, -122.415533827638) | 2 | 7 | 7 | 28859 | 2 | |||
2872 | 47238 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | Permit Number 45189 | 6014641.0147 | 2090577.1277 | 37.7211497042731 | -122.39143974641 | (37.7211497042731, -122.39143974641) | 10 | 3 | 8 | 58 | 1 |
2879 | 261758 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007215 | 2095432 | 37.7340651744382 | -122.417453284567 | (37.7340651744382, -122.417453284567) | 2 | 7 | 7 | 28859 | 2 | ||||
2906 | 121776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501x Illinois St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6016268.76318 | 2101583.58756 | 37.7514614351207 | -122.386580122093 | (37.7514614351207, -122.386580122093) | 10 | 3 | 8 | 58 | 1 | |||
2913 | 264905 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
2937 | 104069 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1340 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2013 12:00:00 AM | 3x3 | Permit Number 770297 | 6007143.4 | 2107674.1 | 37.7676751698972 | -122.418568643249 | (37.7676751698972, -122.418568643249) | 8 | 4 | 7 | 28853 | 19 | ||
2949 | 261537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 612 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981957 | 2111327 | 37.7762548329233 | -122.505954622938 | (37.7762548329233, -122.505954622938) | 11 | 6 | 2 | 55 | 26 | ||
3012 | 15898 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5647X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5998341.15292 | 2087120.08013 | 37.7107392839911 | -122.447534700696 | (37.7107392839911, -122.447534700696) | 9 | 7 | 6 | 28861 | 5 | ||
3015 | 217584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Randolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5993971.4029 | 2088542.2845 | 37.7143936266554 | -122.462740537778 | (37.7143936266554, -122.462740537778) | 9 | 8 | 6 | 64 | 24 | |||
3132 | 241639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Guerrero St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6005424.1713 | 2107755.72538 | 37.7678023541299 | -122.424521053307 | (37.7678023541299, -122.424521053307) | 8 | 4 | 5 | 28853 | 19 | |||
3199 | 218700 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2290 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992022.37081 | 2099856.7917 | 37.745347997612 | -122.470300568125 | (37.745347997612, -122.470300568125) | 1 | 8 | 4 | 29491 | 40 | |||
3285 | 184909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1990 41st Ave | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2019 12:00:00 AM | 3 | Width 0ft | 5983540.025 | 2101883.0946 | 37.75041759921 | -122.4997804049 | (37.75041759921, -122.4997804049) | 1 | 8 | 3 | 29491 | 35 | ||
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 | |||||
3390 | 241891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1499X Eugenia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008741.28282 | 2097661.66652 | 37.7402731134138 | -122.412333973335 | (37.7402731134138, -122.412333973335) | 10 | 7 | 7 | 28859 | 2 | |||
3393 | 144166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 656 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 11:23:00 AM | 0 | Width 4ft | 5983220.66267 | 2111338.89957 | 37.7763618063903 | -122.50158421846 | (37.7763618063903, -122.50158421846) | 11 | 6 | 2 | 55 | 26 | ||
3406 | 26232 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 705X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1997 12:00:00 AM | 8 | 3X3 | 6005809.35017 | 2099009.02543 | 37.7438076936648 | -122.422567155652 | (37.7438076936648, -122.422567155652) | 2 | 7 | 7 | 28859 | 2 | ||
3418 | 241507 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5235 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2016 07:34:00 AM | 1 | Width 2ft | 6001160.66626 | 2099296.94355 | 37.7443348933555 | -122.438661800724 | (37.7443348933555, -122.438661800724) | 2 | 7 | 5 | 63 | 22 | ||
3422 | 136854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 685 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008467.44267 | 2114497.67483 | 37.7864855385225 | -122.414471823731 | (37.7864855385225, -122.414471823731) | 5 | 1 | 9 | 28852 | 36 | |||
3423 | 71632 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 623 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5984096.43813 | 2111562.96127 | 37.7770284137687 | -122.498571268398 | (37.7770284137687, -122.498571268398) | 11 | 6 | 2 | 55 | 26 | |||
3447 | 197 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002246.85388 | 2106423.49653 | 37.7639644352284 | -122.435415689679 | (37.7639644352284, -122.435415689679) | 15 | 5 | 5 | 28862 | 3 | |||
3459 | 84116 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1325 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50709 | 6008644.30779 | 2087548.3519 | 37.712498659051 | -122.411954776917 | (37.712498659051, -122.411954776917) | 9 | 7 | 8 | 309 | 39 | |
3494 | 75703 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1154 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011133.22449 | 2118927.94274 | 37.7987993887319 | -122.405560977554 | (37.7987993887319, -122.405560977554) | 3 | 1 | 10 | 308 | 23 | |||
3521 | 1361 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/29/2016 12:00:00 AM | 3 | 3X3 | 5999192.9019 | 2100038.70061 | 37.7462594407353 | -122.445519216737 | (37.7462594407353, -122.445519216737) | 2 | 7 | 5 | 63 | 22 | ||
3540 | 198190 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3308 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6013400.76782 | 2089956.39224 | 37.7193763737002 | -122.395683481624 | (37.7193763737002, -122.395683481624) | 10 | 3 | 8 | 58 | 1 | |||
3555 | 89502 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4524 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984585.23275 | 2111791.9106 | 37.7776856960653 | -122.49689730367 | (37.7776856960653, -122.49689730367) | 11 | 6 | 2 | 55 | 26 | ||
3557 | 44729 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 3 | Permit Number 43848 | 5989582.3113 | 2101095.9623 | 37.7486090577263 | -122.478828414076 | (37.7486090577263, -122.478828414076) | 1 | 8 | 3 | 29491 | 35 | |
3579 | 119169 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 720 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 5980759.87673 | 2110793.19365 | 37.7747186206505 | -122.510056058609 | (37.7747186206505, -122.510056058609) | 11 | 6 | 2 | 55 | 26 | |||
3591 | 82389 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1638 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6002181.7362 | 2112286.2654 | 37.7800584461593 | -122.436060467665 | (37.7800584461593, -122.436060467665) | 15 | 5 | 11 | 29490 | 41 | |||
3593 | 89474 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4100 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985926.00184 | 2111839.74307 | 37.7778955032139 | -122.492262714551 | (37.7778955032139, -122.492262714551) | 11 | 6 | 2 | 55 | 26 | ||
3618 | 122859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:46:00 PM | 3 | 3x3 | 5996503.07173 | 2087192.19332 | 37.7108320750073 | -122.453892694613 | (37.7108320750073, -122.453892694613) | 9 | 7 | 6 | 28861 | 25 | ||
3641 | 180394 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010059.9605 | 2093475.56512 | 37.7288528826511 | -122.407479439226 | (37.7288528826511, -122.407479439226) | 10 | 3 | 7 | 309 | 28 | |||
3648 | 262535 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/05/2019 12:00:00 AM | 3x3 | 6001472.85598 | 2090996.66296 | 37.7215619917613 | -122.43698819828 | (37.7215619917613, -122.43698819828) | 9 | 7 | 6 | 28861 | 5 | ||
3718 | 85909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2234 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988258.4084 | 2100094.7734 | 37.745783095491 | -122.483333016616 | (37.745783095491, -122.483333016616) | 1 | 8 | 3 | 29491 | 35 | ||
3728 | 264799 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 698 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009708 | 2091117 | 37.7223570514359 | -122.408529889307 | (37.7223570514359, -122.408529889307) | 10 | 3 | 7 | 309 | 28 | ||||
3747 | 36212 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2006 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
3818 | 241714 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 203 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009414.51061 | 2099152.92422 | 37.7444055368928 | -122.410111466171 | (37.7444055368928, -122.410111466171) | 2 | 7 | 7 | 28859 | 2 | |||
3824 | 252901 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 598 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | ||||
3843 | 25432 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2436 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/1998 12:00:00 AM | 3 | 3X3 | 6010891.05193 | 2086887.18096 | 37.7108090136865 | -122.404142791654 | (37.7108090136865, -122.404142791654) | 9 | 7 | 8 | 309 | 39 | ||
3957 | 101709 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95X Milton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003767.7 | 2095277.7 | 37.7334469335284 | -122.429360672359 | (37.7334469335284, -122.429360672359) | 2 | 7 | 5 | 28861 | 25 | ||||
3960 | 28454 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5993123.43173 | 2093088.843 | 37.7268284984876 | -122.466001612774 | (37.7268284984876, -122.466001612774) | 9 | 8 | 4 | 59 | 40 | ||
3964 | 37244 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2550 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 4 | Permit Number 39799 | 5986061.104 | 2102337.4318 | 37.7518127029083 | -122.491095885429 | (37.7518127029083, -122.491095885429) | 1 | 8 | 3 | 56 | 35 | |
3968 | 73735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 350 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002380.79151 | 2091565.74366 | 37.7231761244664 | -122.433890370255 | (37.7231761244664, -122.433890370255) | 9 | 7 | 6 | 28861 | 5 | |||
4009 | 54330 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1257 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2012 12:00:00 AM | Permit Number 769330 | 5994831.50805386 | 2106979.48216267 | 37.7650671008227 | -122.461103283683 | (37.7650671008227, -122.461103283683) | 15 | 5 | 11 | 56 | 12 | |||
4039 | 101850 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001X Rhode Island St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 2 | 3x3 | Permit Number 774983 | 6011937.4679 | 2103668.00433 | 37.7569440557359 | -122.401704847401 | (37.7569440557359, -122.401704847401) | 10 | 3 | 8 | 28856 | 29 | |
4077 | 102546 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015961.34604 | 2107137.76144 | 37.7666949900978 | -122.388030764508 | (37.7666949900978, -122.388030764508) | 14 | 3 | 9 | 310 | 20 | ||
4098 | 242321 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006210.72103 | 2102654.46682 | 37.7538398793324 | -122.421438144967 | (37.7538398793324, -122.421438144967) | 2 | 4 | 5 | 28859 | 19 | |
4112 | 255223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
4130 | 92248 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1475 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52695 | 5985867.8936 | 2105206.8448 | 37.759680032266 | -122.491975261997 | (37.759680032266, -122.491975261997) | 1 | 8 | 3 | 56 | 35 | |
4152 | 37192 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1998 12:00:00 AM | 4 | Permit Number 39759 | 5986844.2604 | 2103759.2633 | 37.7557623917813 | -122.488492147727 | (37.7557623917813, -122.488492147727) | 1 | 8 | 3 | 56 | 35 | |
4232 | 264908 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
4287 | 85892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2450 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988312.1108 | 2098619.8624 | 37.7417365040241 | -122.483039240723 | (37.7417365040241, -122.483039240723) | 1 | 8 | 3 | 29491 | 35 | ||
4314 | 261587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2700x San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5997075 | 2088509 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | 9 | 8 | 6 | 28861 | 24 | ||||
4328 | 36209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
4334 | 136909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6009830.0684 | 2121639.18274 | 37.8061708284786 | -122.410261867902 | (37.8061708284786, -122.410261867902) | 3 | 1 | 10 | 308 | 23 | |||
4362 | 72167 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2157 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5999876.34149 | 2120874.18187 | 37.8035073648317 | -122.444653277524 | (37.8035073648317, -122.444653277524) | 13 | 9 | 1 | 57 | 17 | |||
4368 | 262109 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 340 Oak St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6005374.8248 | 2110307.1287 | 37.7748051060186 | -122.424873276976 | (37.7748051060186, -122.424873276976) | 7 | 9 | 11 | 28852 | 10 | ||||
4386 | 24695 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7001 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2016 12:40:00 PM | 3 | 3X3 | 5985279 | 2112414 | 37.7794344025529 | -122.494543232684 | (37.7794344025529, -122.494543232684) | 11 | 6 | 2 | 55 | 26 | ||
4422 | 183782 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2295 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2020 12:00:00 AM | 3 | 5x5 | 5986367.7435 | 2099662.7006 | 37.7444865241588 | -122.489838803613 | (37.7444865241588, -122.489838803613) | 1 | 8 | 3 | 29491 | 35 | ||
4454 | 128029 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | Width 4ft | 6007868.73718 | 2121431.95 | 37.8054916838703 | -122.417034709883 | (37.8054916838703, -122.417034709883) | 5 | 1 | 10 | 308 | 23 | ||
4458 | 37157 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 88 29th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39737 | 6005841.01788139 | 2099087.47125623 | 37.7440248746354 | -122.422463228878 | (37.7440248746354, -122.422463228878) | 2 | 7 | 5 | 28859 | 2 | |||
4461 | 241779 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6003106.73216 | 2098596.88668 | 37.7425232153888 | -122.431882743495 | (37.7425232153888, -122.431882743495) | 2 | 7 | 5 | 63 | 22 | |||
4464 | 241896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008351.5522 | 2097694.26148 | 37.7403407343459 | -122.413683815267 | (37.7403407343459, -122.413683815267) | 2 | 7 | 7 | 28859 | 2 | |||
4529 | 160228 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 960 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001238.61931 | 2088721.92434 | 37.7153027532862 | -122.437635063623 | (37.7153027532862, -122.437635063623) | 9 | 7 | 6 | 28861 | 5 | ||
4534 | 17065 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1345 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/1991 12:00:00 AM | 6 | 3X3 | 6000565.7799 | 2109579.8794 | 37.7725354591824 | -122.441456517022 | (37.7725354591824, -122.441456517022) | 15 | 5 | 11 | 29492 | 9 | ||
4538 | 78935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2131 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5986022.5823 | 2100717.4644 | 37.7473624613212 | -122.491109891303 | (37.7473624613212, -122.491109891303) | 1 | 8 | 3 | 29491 | 35 | |||
4605 | 85901 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2282 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988268.6501 | 2099782.4008 | 37.7449259990071 | -122.483274709024 | (37.7449259990071, -122.483274709024) | 1 | 8 | 3 | 29491 | 35 | ||
4620 | 115387 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x8 | 5992895.1 | 2098893.2 | 37.7427526388588 | -122.467212790357 | (37.7427526388588, -122.467212790357) | 1 | 8 | 4 | 59 | 40 | |||
4652 | 35361 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 969 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 4 | Permit Number 38823 | 6011919.41112 | 2103909.48398 | 37.7576060979734 | -122.401784268334 | (37.7576060979734, -122.401784268334) | 10 | 3 | 8 | 28856 | 29 | |
4695 | 241522 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4281 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000663.46972 | 2102849.2053 | 37.7540602545824 | -122.440635739769 | (37.7540602545824, -122.440635739769) | 2 | 4 | 5 | 28862 | 22 | |||
4706 | 71655 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 551 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010904.1531 | 2118940.5182 | 37.7988211063956 | -122.406354529449 | (37.7988211063956, -122.406354529449) | 3 | 1 | 10 | 308 | 23 | |||
4712 | 39418 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
4714 | 138839 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 680 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004061.0808 | 2111069.2221 | 37.7768233350725 | -122.429472148942 | (37.7768233350725, -122.429472148942) | 7 | 9 | 11 | 28852 | 10 | |||
4733 | 70369 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1454 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983117.2046 | 2105238.7271 | 37.7596064047755 | -122.50149073173 | (37.7596064047755, -122.50149073173) | 1 | 8 | 3 | 56 | 35 | |||
4767 | 40166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3031 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1999 12:00:00 AM | 8 | 6x6 | Permit Number 41359 | 6004240.20521 | 2119600.37832 | 37.8002578795473 | -122.429461041019 | (37.8002578795473, -122.429461041019) | 13 | 9 | 1 | 57 | 17 |
4837 | 115185 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2300X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | 9 | 7 | 6 | 28861 | 25 | ||||
4843 | 260426 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6009322.86982 | 2092462.23119 | 37.726029197201 | -122.409956117368 | (37.726029197201, -122.409956117368) | 9 | 3 | 7 | 309 | 28 |
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) );