trees
7,322 rows where qSpecies_id = 1 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );