194,517 rows sorted by qSpecies_id

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);