trees
6,344 rows where qSpecies_id = 19 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
191120 | 130575 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2401 Bay St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5999256.14977 | 2120225.4124 | 37.8016906092881 | -122.446752761038 | (37.8016906092881, -122.446752761038) | 13 | 9 | 1 | 57 | 17 | |||
191113 | 117175 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1035 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5999075 | 2106504 | 37.7640048293756 | -122.446391937786 | (37.7640048293756, -122.446391937786) | 15 | 5 | 11 | 29492 | 9 | ||||
191084 | 192838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 8 | : | Tree | Private 2 | 7 | Width 2ft | 6013017.88889 | 2113387.4499 | 37.7836917019659 | -122.398650368427 | (37.7836917019659, -122.398650368427) | 6 | 2 | 9 | 28856 | 6 | |||
191068 | 229297 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500 Dolores St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6004930.83028 | 2104593.54639 | 37.7590918903965 | -122.426002332056 | (37.7590918903965, -122.426002332056) | 2 | 4 | 5 | 28862 | 3 | |||
191058 | 84880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2088 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 6 | 5x7 | Permit No. 49312 | 6000434.10618 | 2115755.2391 | 37.7894839124033 | -122.442355401774 | (37.7894839124033, -122.442355401774) | 13 | 6 | 1 | 29490 | 27 | |
191052 | 108300 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2898 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000965.8204 | 2115920.74629 | 37.7899686433832 | -122.440527608864 | (37.7899686433832, -122.440527608864) | 13 | 6 | 1 | 29490 | 27 | ||
191036 | 5422 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 449 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6004954.35151 | 2105767.40358 | 37.7623163538365 | -122.426004547074 | (37.7623163538365, -122.426004547074) | 8 | 4 | 5 | 28859 | 19 | |||
190971 | 2382 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2600 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 6009734.66332 | 2102078.76769 | 37.7524571968444 | -122.409210863504 | (37.7524571968444, -122.409210863504) | 2 | 4 | 7 | 28859 | 19 | ||||
190966 | 192845 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 360 03rd St | 3 | : | Tree | Private 2 | 15 | Width 4ft | 6013219.84622 | 2113076.83244 | 37.7828500678048 | -122.397929871179 | (37.7828500678048, -122.397929871179) | 6 | 2 | 9 | 28856 | 34 | |||
190915 | 230095 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Coleridge St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006912.30071 | 2099509.05924 | 37.7452428362851 | -122.418788859132 | (37.7452428362851, -122.418788859132) | 2 | 7 | 7 | 28859 | 2 | |||
190913 | 3946 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 135 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6002249.64494 | 2107455.34948 | 37.7667978095999 | -122.435479856305 | (37.7667978095999, -122.435479856305) | 15 | 5 | 5 | 28862 | 3 | ||
190885 | 250914 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 298 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5987158.51725 | 2114000.60813 | 37.7839006000702 | -122.488157895178 | (37.7839006000702, -122.488157895178) | 11 | 6 | 1 | 55 | 33 | |||
190878 | 229363 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1043 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6008641.36222 | 2102472.66286 | 37.75347743274 | -122.413019542736 | (37.75347743274, -122.413019542736) | 2 | 4 | 7 | 28859 | 19 | |||
190806 | 88836 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2320 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51717 | 6001484.7641 | 2114274.4335 | 37.7854778284517 | -122.438614101125 | (37.7854778284517, -122.438614101125) | 15 | 6 | 1 | 29490 | 27 | |
190805 | 42975 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 132 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 7 | Permit Number 42860 | 6008212.4836 | 2093362.59684 | 37.7284391135696 | -122.413858326906 | (37.7284391135696, -122.413858326906) | 9 | 3 | 7 | 309 | 28 | |
190800 | 130818 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2205 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6003521.30137 | 2117210.30876 | 37.7936546361966 | -122.431777984168 | (37.7936546361966, -122.431777984168) | 13 | 9 | 1 | 29490 | 27 | |||
190742 | 68343 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 470 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 7 | Permit Number 32162 | 5991273.13481 | 2112218.31642 | 37.779246105726 | -122.473792913936 | (37.779246105726, -122.473792913936) | 11 | 6 | 2 | 54 | 26 | |
190739 | 3957 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 182 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002210.99422 | 2107171.51565 | 37.76601627626 | -122.435593234753 | (37.76601627626, -122.435593234753) | 15 | 5 | 5 | 28862 | 3 | |||
190682 | 208689 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 455 Vernon St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 5992461.84626 | 2090851.0446 | 37.7206458639025 | -122.468125963363 | (37.7206458639025, -122.468125963363) | 9 | 8 | 6 | 64 | 24 | |||
190669 | 3962 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 203 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002276.7897 | 2106972.99762 | 37.7654749311385 | -122.435351460124 | (37.7654749311385, -122.435351460124) | 15 | 5 | 5 | 28862 | 3 | |||
190657 | 96468 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | |||
190648 | 230468 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 540 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008933.29081 | 2105777.62352 | 37.7625684877753 | -122.412243557314 | (37.7625684877753, -122.412243557314) | 8 | 4 | 7 | 28859 | 19 | |||
190562 | 208619 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 135 Merced Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994542.76741 | 2099437.16108 | 37.744341194902 | -122.46155509559 | (37.744341194902, -122.46155509559) | 1 | 8 | 4 | 59 | 40 | |||
190530 | 104618 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 8 | 4x4 | Permit Number 770959 | 6012200.3 | 2112763.2826 | 37.7819322989016 | -122.401435053146 | (37.7819322989016, -122.401435053146) | 6 | 2 | 9 | 28853 | 34 | |
190471 | 192836 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 6 | : | Tree | Private 2 | 1 | Width 2ft | 6013033.55536 | 2113370.04018 | 37.7836447717261 | -122.398594945913 | (37.7836447717261, -122.398594945913) | 6 | 2 | 9 | 28856 | 6 | |||
190410 | 59250 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 953 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | Permit Number 24728 | 6007802.94479498 | 2120245.22364991 | 37.8022295318465 | -122.417178249777 | (37.8022295318465, -122.417178249777) | 5 | 1 | 10 | 308 | 32 | ||
190401 | 130906 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1268 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008596.97398 | 2117309.00533 | 37.7942120423072 | -122.414222653978 | (37.7942120423072, -122.414222653978) | 5 | 1 | 10 | 28857 | 21 | |||
190384 | 111138 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 307 05TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6011748 | 2112130 | 37.780168205546 | -122.402955256196 | (37.780168205546, -122.402955256196) | 6 | 2 | 9 | 28856 | 34 | |||
190356 | 8205 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1374 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2006 12:00:00 AM | 30 | 3X3 | 6001195.167 | 2111111.9943 | 37.7767780974284 | -122.439389251666 | (37.7767780974284, -122.439389251666) | 15 | 5 | 11 | 29492 | 41 | ||
190349 | 229573 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 78 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998459.52843 | 2105399.88096 | 37.7609380240846 | -122.448441143753 | (37.7609380240846, -122.448441143753) | 15 | 5 | 11 | 29492 | 12 | |||
190329 | 230725 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 117 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001739.50059 | 2105073.60787 | 37.7602291433731 | -122.437073818322 | (37.7602291433731, -122.437073818322) | 2 | 4 | 5 | 28862 | 3 | |||
190289 | 43100 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 536 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | Permit Number 42931 | 6008426.54178738 | 2114301.85272744 | 37.7859455606353 | -122.414599468607 | (37.7859455606353, -122.414599468607) | 5 | 10 | 9 | 28852 | 36 | |||
190287 | 29041 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 101X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6007638.7414429 | 2110099.0108592 | 37.7743612770066 | -122.417027150583 | (37.7743612770066, -122.417027150583) | 8 | 2 | 9 | 28853 | 34 | ||
190267 | 39690 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 14 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | 10 | Permit Number 41075 | 6013904.8298 | 2094710.73126 | 37.7324588573871 | -122.394273805116 | (37.7324588573871, -122.394273805116) | 10 | 3 | 8 | 58 | 1 | |
190249 | 130480 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1995 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003479.53367 | 2118948.91628 | 37.7984260369817 | -122.432046715079 | (37.7984260369817, -122.432046715079) | 13 | 9 | 1 | 57 | 17 | |||
190225 | 120666 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 330 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5994992 | 2113343 | 37.7825488745609 | -122.461009450506 | (37.7825488745609, -122.461009450506) | 11 | 6 | 2 | 54 | 11 | |||
190224 | 177385 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6003320.19386 | 2092049.3117 | 37.7245571593633 | -122.430677531439 | (37.7245571593633, -122.430677531439) | 9 | 7 | 6 | 28861 | 5 | |||
190211 | 85730 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1035 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2007 12:00:00 AM | 3 | 3x3 | 6010276.98508 | 2111710.15053 | 37.7789331461767 | -122.408014575435 | (37.7789331461767, -122.408014575435) | 14 | 2 | 9 | 28853 | 34 | ||
190182 | 92994 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | ||||
190166 | 52628 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 360 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48713 | 6009124.86690346 | 2109176.12595104 | 37.7719107379563 | -122.411821119634 | (37.7719107379563, -122.411821119634) | 8 | 2 | 9 | 28853 | 34 | |
190156 | 32964 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 536 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 14 | Permit Number 37279 | 6014065.25521 | 2104623.75469 | 37.7596868476837 | -122.394413022855 | (37.7596868476837, -122.394413022855) | 10 | 3 | 8 | 28856 | 29 | |
190082 | 44071 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 21 Willard North St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2000 12:00:00 AM | Permit Number 43594 | 5996093.99693327 | 2111662.09556838 | 37.7779969073901 | -122.45707541518 | (37.7779969073901, -122.45707541518) | 11 | 6 | 2 | 54 | 16 | |||
190057 | 177341 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1705 San Jose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6001521.22619 | 2094156.72479 | 37.7302415527858 | -122.437047124623 | (37.7302415527858, -122.437047124623) | 9 | 7 | 6 | 28861 | 25 | |||
190050 | 29046 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 238 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008237.00675 | 2109391.66947 | 37.7724527205492 | -122.414907559637 | (37.7724527205492, -122.414907559637) | 8 | 2 | 9 | 28853 | 19 | ||
190047 | 38151 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 302 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1998 12:00:00 AM | 8 | Permit Number 40300 | 6009958.14196 | 2093623.92788 | 37.7292545558341 | -122.407841892103 | (37.7292545558341, -122.407841892103) | 10 | 3 | 7 | 309 | 28 | |
190007 | 229937 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1323 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003275.47241 | 2100558.32846 | 37.7479184425857 | -122.431439280598 | (37.7479184425857, -122.431439280598) | 2 | 4 | 5 | 63 | 22 | |||
189989 | 208784 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1650 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991890.37075 | 2096391.66049 | 37.7358259964812 | -122.470504676449 | (37.7358259964812, -122.470504676449) | 1 | 8 | 4 | 59 | 40 | |||
189973 | 230005 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 246 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997011.04231 | 2107056.56719 | 37.7654039395536 | -122.453570418946 | (37.7654039395536, -122.453570418946) | 15 | 5 | 11 | 29492 | 12 | |||
189906 | 182075 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2485 30th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5987032.7072 | 2098323.5741 | 37.7408484433506 | -122.487441176332 | (37.7408484433506, -122.487441176332) | 1 | 8 | 3 | 29491 | 35 | |||
189881 | 230847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 132 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002638.74806 | 2107402.94496 | 37.7666760108038 | -122.434130268006 | (37.7666760108038, -122.434130268006) | 15 | 5 | 5 | 28862 | 3 | |||
189871 | 193213 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013099.43478 | 2110909.53382 | 37.7768924558624 | -122.398194343803 | (37.7768924558624, -122.398194343803) | 6 | 2 | 9 | 28856 | 34 | |||
189864 | 193119 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 652 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012339.55473 | 2114646.29289 | 37.7871103748854 | -122.401085644395 | (37.7871103748854, -122.401085644395) | 12 | 2 | 9 | 28855 | 6 | |||
189851 | 143466 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 799 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010697.6034 | 2116549.7111 | 37.7922449727572 | -122.406900666963 | (37.7922449727572, -122.406900666963) | 5 | 1 | 10 | 28857 | 6 | |||
189778 | 229408 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1001 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6009986.58763 | 2103323.08102 | 37.7558879144013 | -122.408427425389 | (37.7558879144013, -122.408427425389) | 2 | 4 | 7 | 28859 | 19 | |||
189775 | 229686 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1295 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009272.31922 | 2101680.2636 | 37.7513370804609 | -122.410781591507 | (37.7513370804609, -122.410781591507) | 2 | 4 | 7 | 28859 | 19 | |||
189727 | 104625 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 250 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 3x3 | Permit Number 770961 | 6012050.5 | 2112960.1 | 37.7824643544146 | -122.401967135301 | (37.7824643544146, -122.401967135301) | 6 | 2 | 9 | 28853 | 34 | ||
189696 | 230587 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 522 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6002946.08131 | 2102722.72173 | 37.7538426816164 | -122.432732889729 | (37.7538426816164, -122.432732889729) | 2 | 4 | 5 | 28862 | 22 | |||
189649 | 130663 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2011 Baker St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5999893.01513 | 2115808.24422 | 37.7895985957458 | -122.444231321925 | (37.7895985957458, -122.444231321925) | 13 | 6 | 1 | 29490 | 27 | |||
189605 | 18384 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 808 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/1998 12:00:00 AM | 12 | 3x3 | 6010406.7535 | 2104457.73607 | 37.7590269440689 | -122.407054321624 | (37.7590269440689, -122.407054321624) | 10 | 4 | 7 | 28859 | 19 | ||
189545 | 9307 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 240X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2011 12:00:00 AM | 3 | 3x100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | 10 | 3 | 7 | 309 | 28 | ||
189543 | 63698 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1710 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1987 12:00:00 AM | Permit Number 24356 | 5993130.87256387 | 2103823.29693757 | 37.756303029686 | -122.466755864515 | (37.756303029686, -122.466755864515) | 1 | 8 | 4 | 56 | 12 | ||
189538 | 208665 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 477 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5997593.37993 | 2094080.44537 | 37.729808063373 | -122.450620649818 | (37.729808063373, -122.450620649818) | 9 | 7 | 4 | 28861 | 40 | ||||
189485 | 130729 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2615 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000139.17643 | 2117547.79676 | 37.7943889911137 | -122.443504640944 | (37.7943889911137, -122.443504640944) | 13 | 9 | 1 | 57 | 27 | |||
189479 | 43210 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 350 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/10/2018 12:00:00 AM | 3 | Permit Number 43001 | 6008795.91385 | 2094346.17458 | 37.7311725561519 | -122.411910848613 | (37.7311725561519, -122.411910848613) | 9 | 3 | 7 | 309 | 28 | |
189411 | 193209 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 590 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014183.14156 | 2112068.51416 | 37.7801350568378 | -122.394526618905 | (37.7801350568378, -122.394526618905) | 6 | 2 | 9 | 28856 | 34 | |||
189362 | 50407 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 98 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47060 | 6000474.19064274 | 2092822.35654564 | 37.7265181152989 | -122.440571186628 | (37.7265181152989, -122.440571186628) | 9 | 7 | 6 | 28861 | 25 | ||
189310 | 229897 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4366 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001530.96132 | 2100600.62753 | 37.7479355593796 | -122.437474739665 | (37.7479355593796, -122.437474739665) | 2 | 4 | 5 | 28862 | 22 | |||
189308 | 229550 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4080 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003365.21147 | 2100701.22804 | 37.7483158970715 | -122.431139165155 | (37.7483158970715, -122.431139165155) | 2 | 4 | 5 | 28862 | 22 | |||
189299 | 39624 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1515 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41022 | 5997835.74069097 | 2105526.1019034 | 37.7612489103603 | -122.450607641875 | (37.7612489103603, -122.450607641875) | 15 | 5 | 11 | 29492 | 12 | ||
189277 | 130447 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2701 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000087.81666 | 2117900.2968 | 37.7953539339819 | -122.44370768716 | (37.7953539339819, -122.44370768716) | 13 | 9 | 1 | 57 | 17 | |||
189271 | 30571 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 175 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1996 12:00:00 AM | 7 | Permit Number 37782 | 6003466.02638 | 2108789.48044 | 37.7705300167765 | -122.431367842974 | (37.7705300167765, -122.431367842974) | 15 | 9 | 11 | 29492 | 10 | |
189269 | 85711 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1142 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009562.66342 | 2111118.44012 | 37.7772684291392 | -122.410443916749 | (37.7772684291392, -122.410443916749) | 8 | 2 | 9 | 28853 | 34 | ||
189218 | 120743 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5989700.72166 | 2112353.32994 | 37.7795256181794 | -122.479242360349 | (37.7795256181794, -122.479242360349) | 11 | 6 | 2 | 55 | 26 | ||
189208 | 246196 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1351 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999513.8532 | 2108070.6158 | 37.7683314187618 | -122.444986707887 | (37.7683314187618, -122.444986707887) | 15 | 5 | 11 | 29492 | 9 | |||
189189 | 230461 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1332 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009253.10704 | 2101351.76557 | 37.7504340208338 | -122.410824831799 | (37.7504340208338, -122.410824831799) | 2 | 4 | 7 | 28859 | 19 | |||
189185 | 47552 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1325 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45416 | 6003917.77272835 | 2100563.40753757 | 37.7479687706781 | -122.429218596883 | (37.7479687706781, -122.429218596883) | 2 | 4 | 5 | 63 | 22 | ||
189152 | 229967 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 280 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004447.45507 | 2096798.26385 | 37.7376605199117 | -122.42711883497 | (37.7376605199117, -122.42711883497) | 2 | 7 | 5 | 63 | 7 | |||
189141 | 230748 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001143.2435 | 2104566.47986 | 37.7588027835435 | -122.439099639258 | (37.7588027835435, -122.439099639258) | 2 | 4 | 5 | 28862 | 3 | |||
189106 | 59163 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1519 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1980 12:00:00 AM | 10 | Permit Number 18473 | 6001880.8838 | 2111502.0449 | 37.7778880779687 | -122.437045088532 | (37.7778880779687, -122.437045088532) | 15 | 5 | 11 | 29492 | 41 | ||
189097 | 59258 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1234 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1980 12:00:00 AM | 3 | Permit Number 18590 | 6006843.45483 | 2115207.15 | 37.7883422167705 | -122.420140798257 | (37.7883422167705, -122.420140798257) | 13 | 9 | 10 | 28858 | 21 | ||
189068 | 208566 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1855 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993734.35362 | 2102863.04387 | 37.7537012317273 | -122.46459911097 | (37.7537012317273, -122.46459911097) | 1 | 8 | 4 | 56 | 12 | |||
189061 | 142903 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 597 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010114.0317 | 2119873.8768 | 37.801339648942 | -122.409154515318 | (37.801339648942, -122.409154515318) | 3 | 1 | 10 | 308 | 23 | |||
189044 | 35330 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2106 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 6 | Permit Number 38796 | 6011446.024 | 2105599.62431 | 37.76222041776 | -122.40354035201 | (37.76222041776, -122.40354035201) | 8 | 3 | 8 | 28856 | 29 | |
188960 | 29792 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1985X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6013589.41889 | 2100022.1973941 | 37.7470254980848 | -122.395736292585 | (37.7470254980848, -122.395736292585) | 10 | 3 | 8 | 58 | 1 | ||
188932 | 32400 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1189 Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36940 | 6010592.54456264 | 2102320.6833304 | 37.7531694681908 | -122.406261195425 | (37.7531694681908, -122.406261195425) | 10 | 4 | 8 | 28859 | 19 | |||
188881 | 88370 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1647 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51351 | 6001238.8669 | 2111411.7366 | 37.7776036008977 | -122.439259570507 | (37.7776036008977, -122.439259570507) | 15 | 5 | 11 | 29492 | 41 | |
188835 | 32105 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 181 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 6 | Permit Number 35477 | 6004531.31838 | 2106727.42232 | 37.7649284185337 | -122.42753605836 | (37.7649284185337, -122.42753605836) | 8 | 4 | 5 | 28862 | 3 | |
188832 | 182238 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1434 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985902.0724 | 2105446.0958 | 37.7603389470657 | -122.491874670134 | (37.7603389470657, -122.491874670134) | 1 | 8 | 3 | 56 | 35 | |||
188784 | 67215 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 407 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | Permit Number 30671 | 6007913.92809109 | 2096961.42580939 | 37.7383039443164 | -122.415145089526 | (37.7383039443164, -122.415145089526) | 2 | 7 | 7 | 28859 | 2 | ||
188761 | 182838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1817 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5987499.4352 | 2102890.001 | 37.7534138403674 | -122.486162562895 | (37.7534138403674, -122.486162562895) | 1 | 8 | 3 | 56 | 35 | |||
188747 | 246187 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1338 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999546.2559 | 2108141.4778 | 37.7685278372511 | -122.444879724871 | (37.7685278372511, -122.444879724871) | 15 | 5 | 11 | 29492 | 9 | |||
188657 | 193048 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 9 | : | Tree | Private 2 | 4 | Width 4ft | 6013846.45257 | 2099906.37378 | 37.7467217659913 | -122.394839375251 | (37.7467217659913, -122.394839375251) | 10 | 3 | 8 | 58 | 1 | |||
188655 | 229597 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1001 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998810.79476 | 2106435.70161 | 37.7638022056215 | -122.447300825876 | (37.7638022056215, -122.447300825876) | 15 | 5 | 11 | 29492 | 9 | |||
188605 | 229945 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4398 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000683.93592 | 2102305.36299 | 37.7525681606153 | -122.440525959505 | (37.7525681606153, -122.440525959505) | 2 | 4 | 5 | 28862 | 22 | |||
188594 | 81966 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 123 Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50669 | 5996084.0729 | 2115728.02008 | 37.7891602817008 | -122.457403977129 | (37.7891602817008, -122.457403977129) | 11 | 6 | 1 | 54 | 31 | |
188556 | 177335 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009682.00524 | 2090045.89023 | 37.7194145508166 | -122.408544227551 | (37.7194145508166, -122.408544227551) | 9 | 3 | 8 | 309 | 18 | |||
188550 | 250685 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5985976.51799 | 2115006.13452 | 37.7865924562168 | -122.492321186983 | (37.7865924562168, -122.492321186983) | 11 | 6 | 1 | 55 | 33 | |||
188541 | 130604 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 95 Cervantes Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001502.46752 | 2120981.00729 | 37.8038933367603 | -122.439033669467 | (37.8038933367603, -122.439033669467) | 13 | 9 | 1 | 57 | 17 | |||
188478 | 208709 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 240 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993476.3027 | 2104633.46167 | 37.7585474615051 | -122.465620113994 | (37.7585474615051, -122.465620113994) | 1 | 8 | 4 | 56 | 12 | |||
188477 | 22499 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6400 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6013113.36636 | 2090284.89866 | 37.7202623949849 | -122.396699945652 | (37.7202623949849, -122.396699945652) | 10 | 3 | 8 | 58 | 1 |
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) );