7,322 rows where qSpecies_id = 1 sorted by PermitNotes

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)
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
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
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
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
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
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
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
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
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
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
4112 255223 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1051 Silver Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
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
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
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
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
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
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
4886 141434 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 511 HAYES ST 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6005350.2266 2110949.2548 37.7765668387099 -122.425004063889 (37.7765668387099, -122.425004063889) 7 9 11 28852 10
4920 12041 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1250X La Salle Ave 23 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6017218.4556902 2094518.641349 37.7321150500381 -122.382804339533 (37.7321150500381, -122.382804339533) 10 3 8 58 1
4928 251750 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 125 South Hill Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2017 08:46:00 AM 3 3x3   6003144 2086928 37.71048518025 -122.430921281744 (37.71048518025, -122.430921281744) 9 7 6 28861 5
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
4962 71085 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 336 Allison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000237.45691 2087069.9768 37.7107099003031 -122.440977070243 (37.7107099003031, -122.440977070243) 9 7 6 28861 5
4987 84397 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2101 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6012443.22283 2099122.96445 37.7444925687938 -122.399636638738 (37.7444925687938, -122.399636638738) 10 3 8 58 1
4994 260596 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3116x Jennings St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/20/2020 12:00:00 AM 3 4x6   6013747 2090444 37.7207345013838 -122.394520802284 (37.7207345013838, -122.394520802284) 10 3 8 58 1
5003 246147 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1504 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5998476.2094 2108299.706 37.7689011658077 -122.448592305739 (37.7689011658077, -122.448592305739) 15 5 11 29492 9
5020 183923 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2290 24th Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5988873.2152 2100272.077 37.7463056861858 -122.481220108991 (37.7463056861858, -122.481220108991) 1 8 3 29491 35
5055 89478 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4120 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/26/2008 12:00:00 AM 3 3x3   5985848.51867 2111837.86338 37.7778858121287 -122.492530613758 (37.7778858121287, -122.492530613758) 11 6 2 55 26
5072 26211 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 800X San Jose Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005561.1813783 2098469.3096841 37.7423117528593 -122.423386905565 (37.7423117528593, -122.423386905565) 2 7 5 28859 22
5077 254635 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 5330 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2018 02:21:00 PM 3 3x3   5999632 2088389 37.7142971380253 -122.443164330284 (37.7142971380253, -122.443164330284) 9 7 6 28861 25
5090 72166 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2164 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5999887.26115 2120921.40259 37.8036376433293 -122.444618885675 (37.8036376433293, -122.444618885675) 13 9 1 57 17
5119 254683 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1985 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2018 02:28:00 PM 3 3x3   5999858 2092352 37.7251915169836 -122.442667568748 (37.7251915169836, -122.442667568748) 9 7 6 28861 25
5139 19520 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 127 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 4X4   6000564 2112525 37.7806219117946 -122.44167407009 (37.7806219117946, -122.44167407009) 15 5 1 29490 16
5190 19521 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 130X Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000722.7955642 2112514.8377136 37.7806030550121 -122.441123992492 (37.7806030550121, -122.441123992492) 15 5 1 29490 41
5200 163651 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 260 Sagamore St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2019 05:56:00 AM 3 4x6   5994434.35916 2087472.87678 37.7114839386972 -122.461062922717 (37.7114839386972, -122.461062922717) 9 8 6 28861 24
5201 261538 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 667 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 3ft   5981910 2111209 37.7759280729172 -122.506108454702 (37.7759280729172, -122.506108454702) 11 6 2 55 26
5210 240637 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 10 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 3x3   6005372.47745 2108674.6931 37.7703226996495 -122.424765239935 (37.7703226996495, -122.424765239935) 8 2 5 28853 19
5247 17055 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1285 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1991 12:00:00 AM 12 3X3   6000835.008 2109621.9255 37.772666241387 -122.440528248313 (37.772666241387, -122.440528248313) 15 5 11 29492 9
5291 95249 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 483 22nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989019.4 2112018.5 37.778566675209 -122.4815747855 (37.778566675209, -122.4815747855) 11 6 2 55 26
5298 16892 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 311 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/05/2011 12:00:00 AM 6 3X3   6005385.8444 2110257.3545 37.7746690605587 -122.424831616025 (37.7746690605587, -122.424831616025) 7 9 11 28852 10
5314 71429 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2029 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6009865.7372 2121062.537 37.8045895022466 -122.410097693334 (37.8045895022466, -122.410097693334) 3 1 10 308 23
5335 26050 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 142 Broad St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2007 12:00:00 AM 3 3X3   5995479.9938 2088097.6075 37.7132594193894 -122.457494129816 (37.7132594193894, -122.457494129816) 9 8 6 28861 24
5339 146869 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 751 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:08:00 PM 3 Width 3ft   5983200.60356 2110688.67997 37.774575313945 -122.501605492811 (37.774575313945, -122.501605492811) 11 6 2 55 26
5395 214900 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 69 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992595.17834 2098673.73573 37.7421327279347 -122.468233863115 (37.7421327279347, -122.468233863115) 1 8 4 59 40
5402 259405 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1140 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3     6013491.54198 2090383.23631 37.7205534514179 -122.395399593578 (37.7205534514179, -122.395399593578) 10 3 8 58 1
5441 147494 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 503 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2019 12:00:00 AM 3 4x6   5989673.74283 2111853.74948 37.7781523421991 -122.479299133273 (37.7781523421991, -122.479299133273) 11 6 2 55 26
5465 198179 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 227 07th St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6010077.86899 2111204.28564 37.7775330096684 -122.408667704448 (37.7775330096684, -122.408667704448) 14 2 9 28853 34
5481 112239 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2400X Alemany Blvd 4 Median : Cutout Tree DPW 1   10/27/2015 07:41:00 AM 3     5999153.8915 2088963.97845 37.7158486246797 -122.444858161098 (37.7158486246797, -122.444858161098) 9 7 6 28861 25
5493 264903 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
5497 200583 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 6 Las Villas Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6016440.4137 2094932.3213 37.7332079157453 -122.385523046608 (37.7332079157453, -122.385523046608) 10 3 8 58 1
5551 74240 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 8 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015971.85212 2106927.76687 37.7661189725478 -122.387979770277 (37.7661189725478, -122.387979770277) 14 3 9 310 20
5559 232424 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3590 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6004483.72015 2103686.16481 37.7565751556437 -122.427484009182 (37.7565751556437, -122.427484009182) 2 4 5 28862 3
5609 83165 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1903 Keith St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6015168.2313 2093359.9647 37.7288200702379 -122.389811574581 (37.7288200702379, -122.389811574581) 10 3 8 58 1
5613 73412 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 147 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6009997.41366 2093830.92817 37.7298251334141 -122.407720715656 (37.7298251334141, -122.407720715656) 10 3 7 309 28
5634 243287 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 239 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007091.10109 2107897.19538 37.7682847927477 -122.418765362556 (37.7682847927477, -122.418765362556) 8 4 7 28853 19

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