trees
7,322 rows where qSpecies_id = 1 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 264847 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 109 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010522 | 2093730 | 37.729577358437 | -122.405900044893 | (37.729577358437, -122.405900044893) | 10 | 3 | 7 | 309 | 28 | |||
| 4 | 264831 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | 6011678 | 2088870 | 37.7162973770842 | -122.401562170369 | (37.7162973770842, -122.401562170369) | 10 | 7 | 8 | 309 | 39 | ||
| 41 | 159866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001590.27181 | 2091627.71254 | 37.7233013847479 | -122.436627471279 | (37.7233013847479, -122.436627471279) | 9 | 7 | 6 | 28861 | 25 | ||
| 44 | 159867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001543.73914 | 2091652.70256 | 37.7233673572035 | -122.436790113668 | (37.7233673572035, -122.436790113668) | 9 | 7 | 6 | 28861 | 25 | ||
| 48 | 159865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001621.37029 | 2091612.17517 | 37.7232604898693 | -122.436518858358 | (37.7232604898693, -122.436518858358) | 9 | 7 | 6 | 28861 | 25 | ||
| 49 | 261834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20x Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001536 | 2091749 | 37.7236313283612 | -122.436823756643 | (37.7236313283612, -122.436823756643) | 9 | 7 | 6 | 28861 | 25 | ||
| 52 | 264970 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014048 | 2089990 | 37.7195046364539 | -122.393448574201 | (37.7195046364539, -122.393448574201) | 10 | 3 | 8 | 58 | 1 | ||||
| 200 | 10663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.7756317694487 | -122.432267067771 | (37.7756317694487, -122.432267067771) | 15 | 9 | 11 | 29492 | 10 | ||
| 310 | 218546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 5 | : | Tree | Private 2 | 7 | Width 3ft | 5991216.07157 | 2094485.7269 | 37.730553771324 | -122.472697049151 | (37.730553771324, -122.472697049151) | 9 | 8 | 4 | 64 | 40 | |||
| 411 | 247779 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 30th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004930.81683 | 2098452.72536 | 37.7422306182373 | -122.42556533529 | (37.7422306182373, -122.42556533529) | 2 | 7 | 5 | 63 | 22 | |||
| 585 | 75271 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015975.8041 | 2106880.05369 | 37.7659881814233 | -122.387962771269 | (37.7659881814233, -122.387962771269) | 14 | 3 | 9 | 310 | 20 | ||
| 616 | 243196 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006254.26009 | 2108909.80844 | 37.771018033881 | -122.421731852741 | (37.771018033881, -122.421731852741) | 8 | 2 | 9 | 28853 | 19 | |||
| 617 | 241734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 161 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004159.0543 | 2107968.96381 | 37.7683163292566 | -122.428912146976 | (37.7683163292566, -122.428912146976) | 7 | 9 | 5 | 28862 | 3 | |||
| 672 | 218447 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 468 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5997663.70622 | 2094120.17429 | 37.7299211747216 | -122.450380387859 | (37.7299211747216, -122.450380387859) | 9 | 7 | 4 | 28861 | 40 | |||
| 725 | 183610 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1954 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986022.0269 | 2101933.6639 | 37.7507017829524 | -122.491201304809 | (37.7507017829524, -122.491201304809) | 1 | 8 | 3 | 29491 | 35 | |||
| 733 | 218511 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 318 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43359 | 5996829.51445 | 2089654.64111 | 37.7176120972009 | -122.45294206803 | (37.7176120972009, -122.45294206803) | 9 | 8 | 6 | 28861 | 24 | |
| 759 | 181983 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2478 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986456.7133 | 2098393.9658 | 37.7410081118776 | -122.489437895882 | (37.7410081118776, -122.489437895882) | 1 | 8 | 3 | 29491 | 35 | |||
| 762 | 161390 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 467 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6002831.42521 | 2091188.97801 | 37.7221671723558 | -122.432305723439 | (37.7221671723558, -122.432305723439) | 9 | 7 | 6 | 28861 | 5 | ||
| 764 | 163220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Farallones St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | Width 0ft | 5996567.29942 | 2088361.68289 | 37.714046904924 | -122.453755106407 | (37.714046904924, -122.453755106407) | 9 | 8 | 6 | 28861 | 24 | ||
| 811 | 160771 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 667 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6003251.82484 | 2089320.66382 | 37.7170610223232 | -122.430719246496 | (37.7170610223232, -122.430719246496) | 9 | 7 | 6 | 28861 | 5 | ||
| 812 | 210575 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 222 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 778918 | 5996813.55952 | 2094844.51305 | 37.7318613433091 | -122.453371704763 | (37.7318613433091, -122.453371704763) | 9 | 7 | 4 | 59 | 40 | |
| 827 | 258419 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1838 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 05:59:00 PM | 3 | 3x3 | 5990003 | 2106579 | 37.7636884395526 | -122.477774444731 | (37.7636884395526, -122.477774444731) | 1 | 8 | 3 | 56 | 35 | ||
| 828 | 120806 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 447 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | 5x6 | 5989655.6717 | 2112300.70253 | 37.7793785014336 | -122.479394354392 | (37.7793785014336, -122.479394354392) | 11 | 6 | 2 | 55 | 26 | ||
| 840 | 1046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2009X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 12 | 4X4 | 6000674.20134 | 2090359.18139 | 37.7197661846273 | -122.439703245137 | (37.7197661846273, -122.439703245137) | 9 | 7 | 6 | 28861 | 25 | ||
| 897 | 136834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2189 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003723.70254 | 2116916.18398 | 37.7928585158644 | -122.43105665684 | (37.7928585158644, -122.43105665684) | 13 | 9 | 1 | 29490 | 27 | |||
| 916 | 247786 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 310 30th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004309 | 2098427 | 37.7421248276758 | -122.427713553768 | (37.7421248276758, -122.427713553768) | 2 | 7 | 5 | 63 | 22 | |||
| 976 | 258329 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 105 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998052 | 2087327 | 37.7112909098977 | -122.448548966881 | (37.7112909098977, -122.448548966881) | 9 | 7 | 6 | 28861 | 25 | ||||
| 1041 | 109054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011721.75389 | 2111961.27607 | 37.7797034631784 | -122.403034183007 | (37.7797034631784, -122.403034183007) | 14 | 2 | 9 | 28856 | 34 | |||
| 1046 | 84218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 666 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51573 | 5994122.60618 | 2110981.10556 | 37.7760136809116 | -122.463845662192 | (37.7760136809116, -122.463845662192) | 11 | 6 | 2 | 54 | 11 | |
| 1065 | 180355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 San Jose Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999392.39561 | 2091826.25637 | 37.7237213933189 | -122.444239347485 | (37.7237213933189, -122.444239347485) | 9 | 7 | 6 | 28861 | 25 | |||
| 1073 | 108979 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3298 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2017 12:00:00 AM | 3 | 3x3 | 6001360.79576 | 2119668.58087 | 37.800281699894 | -122.43942979746 | (37.800281699894, -122.43942979746) | 13 | 9 | 1 | 57 | 17 | ||
| 1080 | 169338 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1029 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2019 12:00:00 AM | 3 | Width 4ft | 6006781.41851 | 2114264.09095 | 37.7857493130165 | -122.420288474132 | (37.7857493130165, -122.420288474132) | 13 | 9 | 9 | 28858 | 36 | ||
| 1112 | 8732 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3210 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1996 12:00:00 AM | 6 | 3X3 | 5997102.31429 | 2113088.26659 | 37.7819706522719 | -122.453690315182 | (37.7819706522719, -122.453690315182) | 11 | 6 | 1 | 54 | 31 | ||
| 1117 | 119284 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 651 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2019 12:00:00 AM | 3 | 3x3 | 5987187 | 2111505 | 37.7770500309996 | -122.487875935939 | (37.7770500309996, -122.487875935939) | 11 | 6 | 2 | 55 | 26 | ||
| 1125 | 101207 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 1221 | 154034 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1670 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 6014842.11456 | 2097062.95564 | 37.7389696405262 | -122.391197725313 | (37.7389696405262, -122.391197725313) | 10 | 3 | 8 | 58 | 1 | |||
| 1222 | 16326 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 789X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1993 12:00:00 AM | 3 | 3X3 | 5996873.6825 | 2094683.9462 | 37.7314239112697 | -122.45315226118 | (37.7314239112697, -122.45315226118) | 9 | 7 | 4 | 59 | 40 | ||
| 1229 | 264907 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 1231 | 15974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2016 12:00:00 AM | 3 | 3X3 | 5996593.31856 | 2086313.84227 | 37.7084254991124 | -122.453517403906 | (37.7084254991124, -122.453517403906) | 9 | 7 | 6 | 28861 | 5 | ||
| 1247 | 214916 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 13 | Width 2ft | Permit Number 32246 | 5993222.12997 | 2093186.27538 | 37.7271017173463 | -122.465667493867 | (37.7271017173463, -122.465667493867) | 9 | 8 | 4 | 59 | 40 | |
| 1253 | 86079 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2321 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987612.7621 | 2099475.5619 | 37.7440453083682 | -122.485520107247 | (37.7440453083682, -122.485520107247) | 1 | 8 | 3 | 29491 | 35 | ||
| 1267 | 244161 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 441 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004421.3191 | 2109776.7375 | 37.7732948782123 | -122.428133844936 | (37.7732948782123, -122.428133844936) | 7 | 9 | 11 | 28852 | 10 | |||
| 1291 | 122854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996671.62099 | 2087298.1542 | 37.7111326815096 | -122.453317797602 | (37.7111326815096, -122.453317797602) | 9 | 7 | 6 | 28861 | 25 | ||
| 1345 | 143782 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 454 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | 3 | Width 3ft | 5985339.75062 | 2112824.82274 | 37.7805659588822 | -122.494363364799 | (37.7805659588822, -122.494363364799) | 11 | 6 | 2 | 55 | 26 | ||
| 1358 | 109891 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013218 | 2106201 | 37.7639704813344 | -122.397453893083 | (37.7639704813344, -122.397453893083) | 14 | 3 | 8 | 28856 | 29 | ||||
| 1478 | 242990 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x2.5 | 6006256.26412 | 2108953.61059 | 37.7711384171253 | -122.421728032423 | (37.7711384171253, -122.421728032423) | 8 | 2 | 9 | 28853 | 19 | |||
| 1499 | 262277 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996515 | 2091798 | 37.7234792274288 | -122.454183919247 | (37.7234792274288, -122.454183919247) | 9 | 8 | 4 | 28861 | 24 | ||||
| 1551 | 260493 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2019 12:00:00 AM | 3 | 3x3 | 6006327 | 2116970 | 37.7931534514646 | -122.422052933674 | (37.7931534514646, -122.422052933674) | 13 | 9 | 10 | 28858 | 32 | ||
| 1604 | 15896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5635 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5998509.62683 | 2087220.10589 | 37.7110235586697 | -122.446959612304 | (37.7110235586697, -122.446959612304) | 9 | 7 | 6 | 28861 | 5 | ||
| 1636 | 199812 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1450 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015205.5584 | 2091901.4217 | 37.7248172716421 | -122.389580707536 | (37.7248172716421, -122.389580707536) | 10 | 3 | 8 | 58 | 1 | |||
| 1687 | 241878 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 701 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007932 | 2097222 | 37.739020439369 | -122.415101044746 | (37.739020439369, -122.415101044746) | 2 | 7 | 7 | 28859 | 2 | |||
| 1721 | 86502 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987758.3934 | 2105633.7162 | 37.7609624268951 | -122.48546837117 | (37.7609624268951, -122.48546837117) | 1 | 8 | 3 | 56 | 35 | ||
| 1737 | 121771 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501x Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6016276.86465 | 2101451.8833 | 37.7511002511867 | -122.386542923434 | (37.7511002511867, -122.386542923434) | 10 | 3 | 8 | 58 | 1 | |||
| 1768 | 166879 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004296.66973 | 2101583.94341 | 37.7507923673753 | -122.427981098658 | (37.7507923673753, -122.427981098658) | 2 | 4 | 5 | 28862 | 22 | |||
| 1788 | 262276 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996515 | 2091798 | 37.7234792274288 | -122.454183919247 | (37.7234792274288, -122.454183919247) | 9 | 8 | 4 | 28861 | 24 | ||||
| 1834 | 241942 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 759x San Jose Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005779.29325 | 2098911.20923 | 37.7435374168158 | -122.422664135861 | (37.7435374168158, -122.422664135861) | 2 | 7 | 7 | 28859 | 2 | |||
| 1854 | 241885 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 118 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007147.65495 | 2096997.64072 | 37.7383602895823 | -122.417797058006 | (37.7383602895823, -122.417797058006) | 2 | 7 | 7 | 28859 | 2 | |||
| 1867 | 241893 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1305 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008569.76439 | 2097675.06736 | 37.7403002828328 | -122.412927964755 | (37.7403002828328, -122.412927964755) | 10 | 7 | 7 | 28859 | 2 | |||
| 1916 | 123041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 584 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5991932.61991 | 2111495.58679 | 37.7772998616253 | -122.471458826729 | (37.7772998616253, -122.471458826729) | 11 | 6 | 2 | 54 | 11 | |||
| 1973 | 247787 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 310 30th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004309 | 2098427 | 37.7421248276758 | -122.427713553768 | (37.7421248276758, -122.427713553768) | 2 | 7 | 5 | 63 | 22 | |||
| 1999 | 18283 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/1994 12:00:00 AM | 6 | 4X4 | 6002545.1088 | 2114076.0503 | 37.7849933804768 | -122.434931434249 | (37.7849933804768, -122.434931434249) | 13 | 6 | 11 | 29490 | 13 | ||
| 2007 | 188784 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015979.83831 | 2106803.95395 | 37.7657794514949 | -122.387943506912 | (37.7657794514949, -122.387943506912) | 14 | 3 | 9 | 310 | 20 | |||
| 2168 | 254831 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
| 2181 | 144909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 626 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 3ft | 5990056.22711 | 2111077.42304 | 37.7760429715406 | -122.477919227901 | (37.7760429715406, -122.477919227901) | 11 | 6 | 2 | 55 | 26 | ||
| 2195 | 258431 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2450 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 05:45:00 PM | 3 | 3x3 | 5988181.8432 | 2106487.3051 | 37.7633308106608 | -122.484066458576 | (37.7633308106608, -122.484066458576) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 |
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) );