trees
93 rows where qSpecies_id = 224 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10128 | 256113 | Section 806 (d) 5 | Magnolia spp :: Magnolia 224 | 356 Willard North St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2018 12:00:00 AM | 3 | |||||||||||||
17608 | 20404 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 262X Sunset Blvd | 49 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
7179 | 260247 | Property Tree 8 | Magnolia spp :: Magnolia 224 | 568 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998297.39121 | 2088148.96817 | 37.7135618752392 | -122.447759972312 | (37.7135618752392, -122.447759972312) | 9 | 7 | 6 | 28861 | 25 | |||||
11394 | 260246 | Private 9 | Magnolia spp :: Magnolia 224 | 568 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784595 | 5998297.39121 | 2088148.96817 | 37.7135618752392 | -122.447759972312 | (37.7135618752392, -122.447759972312) | 9 | 7 | 6 | 28861 | 25 | |
118005 | 19337 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 420 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/12/2014 12:00:00 AM | 3 | 3x3 | 5992930.1579343 | 2089870.1086696 | 37.7179794867167 | -122.466435911921 | (37.7179794867167, -122.466435911921) | 9 | 8 | 6 | 64 | 24 | ||
55130 | 104947 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 532 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
174124 | 67897 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 463 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | 3x3 | Permit Number 31599 | 5997692.14982092 | 2094077.11475557 | 37.7298045712917 | -122.450278952768 | (37.7298045712917, -122.450278952768) | 9 | 7 | 4 | 28861 | 40 | |
77753 | 208861 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 263 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998987.83707 | 2094055.2995 | 37.7298187374412 | -122.445798064124 | (37.7298187374412, -122.445798064124) | 9 | 7 | 4 | 28861 | 40 | ||||
6656 | 258684 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 222 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/06/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782190 | 5990522.43491 | 2094710.12159 | 37.7311297256611 | -122.475111403646 | (37.7311297256611, -122.475111403646) | 1 | 8 | 4 | 64 | 35 | |
8278 | 258683 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 222 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/06/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782190 | 5990522.43491 | 2094710.12159 | 37.7311297256611 | -122.475111403646 | (37.7311297256611, -122.475111403646) | 1 | 8 | 4 | 64 | 35 | |
76095 | 106244 | Significant Tree 6 | Magnolia spp :: Magnolia 224 | 735 MANGELS AVE | 1 | Front Yard : Yard | Tree | Private 2 | 06/02/2014 12:00:00 AM | 14 | Permit Number 772876 | 5996640.8 | 2095225.8 | 37.7328983615352 | -122.453996493912 | (37.7328983615352, -122.453996493912) | 9 | 7 | 4 | 59 | 40 | ||
77669 | 208862 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 639 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5997188.97266 | 2095238.55048 | 37.7329647871987 | -122.452102249635 | (37.7329647871987, -122.452102249635) | 9 | 7 | 4 | 59 | 40 | ||||
17162 | 230428 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 436 Murray St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006457.38895 | 2096010.6224 | 37.7356112869209 | -122.42011363695 | (37.7356112869209, -122.42011363695) | 2 | 7 | 7 | 28859 | 2 | |||
61499 | 6716 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 1200X Fairfax Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/2015 11:25:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
96411 | 6713 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 1200X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/2015 11:14:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
179322 | 62900 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 42 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/1986 12:00:00 AM | 1 | Permit Number 23274 | 6001400.58144689 | 2097305.17262336 | 37.7388796034552 | -122.437689607497 | (37.7388796034552, -122.437689607497) | 2 | 7 | 5 | 63 | 7 | ||
100230 | 79058 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 84 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2011 12:00:00 AM | Permit Number 54829 | 6001112.32299105 | 2097379.40258298 | 37.7390670270865 | -122.438691586574 | (37.7390670270865, -122.438691586574) | 2 | 7 | 5 | 63 | 7 | |||
80127 | 6779 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 1355 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/17/2011 12:00:00 AM | 3 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | ||
69163 | 33522 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 174 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2009 12:00:00 AM | 3x3 | Permit Number 52072 | 6007260.41005057 | 2098019.68890663 | 37.7411729520807 | -122.417479618781 | (37.7411729520807, -122.417479618781) | 2 | 7 | 7 | 28859 | 2 | ||
6077 | 230988 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 44 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2018 12:00:00 AM | 3 | 3x6 | Permit Number 778706 | 6007424.10799 | 2099038.48568 | 37.7439795505181 | -122.416985775987 | (37.7439795505181, -122.416985775987) | 2 | 7 | 7 | 28859 | 2 | |
85331 | 67833 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 469 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 3x3 | Permit Number 31495 | 6002871.84745267 | 2099449.75945792 | 37.7448516873624 | -122.432755816877 | (37.7448516873624, -122.432755816877) | 2 | 7 | 5 | 63 | 22 | ||
138947 | 230426 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 230 Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 1 | 6007649.02399 | 2099489.86888 | 37.7452315974648 | -122.416240028469 | (37.7452315974648, -122.416240028469) | 2 | 7 | 7 | 28859 | 2 | ||||
68392 | 230427 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 230 Coso Ave | 1 | Side Yard : Yard | Tree | Private 2 | 1 | 6007601.41363 | 2099515.46986 | 37.7452992147794 | -122.416406470502 | (37.7452992147794, -122.416406470502) | 2 | 7 | 7 | 28859 | 2 | ||||
54088 | 117373 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 2219 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778546 | 5983853.5 | 2100037.4 | 37.7453682200001 | -122.498560081441 | (37.7453682200001, -122.498560081441) | 1 | 8 | 3 | 29491 | 35 | ||
81356 | 52263 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 40 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48428 | 6005651.79801021 | 2099662.26802464 | 37.7455924596089 | -122.423158358307 | (37.7455924596089, -122.423158358307) | 2 | 7 | 5 | 28859 | 22 | ||
54455 | 110680 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 162 DUNCAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005508 | 2099957 | 37.7463936103079 | -122.423676542195 | (37.7463936103079, -122.423676542195) | 2 | 7 | 5 | 28859 | 22 | ||||
65405 | 104718 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 100x PRECITA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007128 | 2100007 | 37.7466222122015 | -122.418078299823 | (37.7466222122015, -122.418078299823) | 2 | 7 | 7 | 28859 | 2 | |||||
65688 | 59775 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 100x PRECITA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1981 12:00:00 AM | 8 | 9x7 | Permit Number 19223 | 6007128 | 2100007 | 37.7466222122015 | -122.418078299823 | (37.7466222122015, -122.418078299823) | 2 | 7 | 7 | 28859 | 2 | |
91658 | 106372 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 260 MAGELLAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5994684.4 | 2100364.8 | 37.7468964099217 | -122.461132589625 | (37.7468964099217, -122.461132589625) | 1 | 8 | 4 | 29491 | 40 | ||||
47827 | 86711 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 3714 Cesar Chavez St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2007 12:00:00 AM | 6 | Permit Number 49697 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||
34834 | 96516 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 3119 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 58566 | 6009076 | 2100510 | 37.7481127876266 | -122.411377822838 | (37.7481127876266, -122.411377822838) | 2 | 7 | 7 | 28859 | 2 | |||
155311 | 96515 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 3119 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 58566 | 6009076 | 2100510 | 37.7481127876266 | -122.411377822838 | (37.7481127876266, -122.411377822838) | 2 | 7 | 7 | 28859 | 2 | |||
156384 | 5627 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 1215 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6 | 6005207.4348277 | 2101278.8703511 | 37.7500061913108 | -122.424809887589 | (37.7500061913108, -122.424809887589) | 2 | 4 | 5 | 28859 | 19 | |||
178575 | 96914 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 4396X 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | 3x3 | Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. | 6000641.3 | 2102303.1 | 37.7525595190983 | -122.440673239158 | (37.7525595190983, -122.440673239158) | 2 | 4 | 5 | 28862 | 22 | |
170048 | 53927 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 616-618 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1972 12:00:00 AM | Permit Number 9640 | 6001839.32774762 | 2102295.7359044 | 37.752607450257 | -122.436529733585 | (37.752607450257, -122.436529733585) | 2 | 4 | 5 | 28862 | 22 | |||
70600 | 85257 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 689 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49556 | 6001247 | 2102379 | 37.7528023963993 | -122.438584066967 | (37.7528023963993, -122.438584066967) | 2 | 4 | 5 | 28862 | 22 | |||
107038 | 84073 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 3936 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50418 | 6003544.24731161 | 2102468.85848111 | 37.7531795392658 | -122.43064618026 | (37.7531795392658, -122.43064618026) | 2 | 4 | 5 | 28862 | 22 | ||
13728 | 96416 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 2749 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 10x10 | 6008995.5323 | 2102438.8768 | 37.7534045389876 | -122.411792354923 | (37.7534045389876, -122.411792354923) | 2 | 4 | 7 | 28859 | 19 | |||
2452 | 193439 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 1301 Minnesota St | 10 | Front Yard : Yard | Tree | Private 2 | 1 | 6015387.42836 | 2102311.75717 | 37.7534120052793 | -122.38967876317 | (37.7534120052793, -122.38967876317) | 10 | 3 | 8 | 28856 | 29 | ||||
168477 | 112552 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 51 VICKSBURG ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6004133 | 2102760 | 37.7540122823763 | -122.42863090726 | (37.7540122823763, -122.42863090726) | 2 | 4 | 5 | 28862 | 22 | ||||
35244 | 104763 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 51 VICKSBURG ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2014 12:00:00 AM | 15 | 4x4 | Permit Number 772738 | 6004133.6 | 2102760.4 | 37.7540134146385 | -122.428628860828 | (37.7540134146385, -122.428628860828) | 2 | 4 | 5 | 28862 | 22 | |
43347 | 53478 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 51 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2014 12:00:00 AM | 15 | 4x4 | Permit Number 772738 | 6004118.50395547 | 2102762.60365408 | 37.7540186110043 | -122.428681223641 | (37.7540186110043, -122.428681223641) | 2 | 4 | 5 | 28862 | 22 | |
160215 | 115761 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 924 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003074 | 2102857 | 37.7542186318325 | -122.432300106993 | (37.7542186318325, -122.432300106993) | 2 | 4 | 5 | 28862 | 22 | |||
127423 | 230429 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 2649 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010278.55114 | 2103378.64577 | 37.7560568286752 | -122.407421632625 | (37.7560568286752, -122.407421632625) | 10 | 4 | 7 | 28859 | 19 | |||
6434 | 230789 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 3933 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 767282 | 6004098.889 | 2104204.25697 | 37.757975940552 | -122.428851827645 | (37.757975940552, -122.428851827645) | 2 | 4 | 5 | 28862 | 3 | |
117256 | 37939 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 730 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40183 | 6015727.50058131 | 2103973.29458622 | 37.7579930864217 | -122.388618685659 | (37.7579930864217, -122.388618685659) | 10 | 3 | 8 | 28856 | 29 | |||
38700 | 104467 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 857 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769287 | 6009159.4 | 2104178.6 | 37.7581906182499 | -122.411348556636 | (37.7581906182499, -122.411348556636) | 2 | 4 | 7 | 28859 | 19 | |
12849 | 94786 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 1X CASELLI AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2010 12:00:00 AM | 3x3 | Permit Number 53882 | 6000842 | 2104917 | 37.7597480805722 | -122.440166611531 | (37.7597480805722, -122.440166611531) | 2 | 4 | 5 | 28862 | 3 | ||
97224 | 94785 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 1X CASELLI AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2010 12:00:00 AM | 3x3 | Permit Number 53882 | 6000842 | 2104917 | 37.7597480805722 | -122.440166611531 | (37.7597480805722, -122.440166611531) | 2 | 4 | 5 | 28862 | 3 | ||
155991 | 94784 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 1X CASELLI AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2010 12:00:00 AM | 3x3 | Permit Number 53882 | 6000842 | 2104917 | 37.7597480805722 | -122.440166611531 | (37.7597480805722, -122.440166611531) | 2 | 4 | 5 | 28862 | 3 | ||
163852 | 57435 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 4328 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1976 12:00:00 AM | 24 | 6x6 | Permit Number 16277 | 6001615.3752968 | 2105287.59579624 | 37.7608096458957 | -122.437518432693 | (37.7608096458957, -122.437518432693) | 15 | 4 | 5 | 28862 | 3 | |
132772 | 57433 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 4316 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1976 12:00:00 AM | 20 | 6x6 | Permit Number 16275 | 6001651.18541617 | 2105289.61210405 | 37.7608172180801 | -122.437394726023 | (37.7608172180801, -122.437394726023) | 15 | 4 | 5 | 28862 | 3 | |
91213 | 57434 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 4324 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1976 12:00:00 AM | 20 | 9x6 | Permit Number 16276 | 6001563 | 2105306 | 37.7608572014532 | -122.437700893331 | (37.7608572014532, -122.437700893331) | 15 | 4 | 5 | 28862 | 3 | |
153574 | 100151 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 4047 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 5x5 | Permit Number 776452 | 6002690 | 2105300 | 37.7609047432887 | -122.433802674054 | (37.7609047432887, -122.433802674054) | 2 | 4 | 5 | 28862 | 3 | ||
37133 | 5427 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 460X Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004889.2026724 | 2105697.5669462 | 37.7621209168257 | -122.426224900449 | (37.7621209168257, -122.426224900449) | 8 | 4 | 5 | 28862 | 3 | |||
125697 | 101408 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 395X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2012 12:00:00 AM | 3x3 | Permit Number 768634 | 6007839 | 2105646.7 | 37.7621475376843 | -122.416019051105 | (37.7621475376843, -122.416019051105) | 8 | 4 | 7 | 28859 | 19 | |
143871 | 101409 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 395X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2012 12:00:00 AM | 3x3 | Permit Number 768634 | 6007839 | 2105646.7 | 37.7621475376843 | -122.416019051105 | (37.7621475376843, -122.416019051105) | 8 | 4 | 7 | 28859 | 19 | |
193629 | 101407 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 395X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2012 12:00:00 AM | 3x3 | Permit Number 768634 | 6007839 | 2105646.7 | 37.7621475376843 | -122.416019051105 | (37.7621475376843, -122.416019051105) | 8 | 4 | 7 | 28859 | 19 | |
116846 | 208860 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 1359 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991111.19274 | 2106147.12197 | 37.762566869885 | -122.473910078106 | (37.762566869885, -122.473910078106) | 1 | 8 | 11 | 56 | 12 | |||
165128 | 51939 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 61 Pond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | 8 | 5x2 | Permit Number 48164 | 6003201.44301211 | 2106166.49517673 | 37.763312938971 | -122.432095698187 | (37.763312938971, -122.432095698187) | 15 | 4 | 5 | 28862 | 3 | |
37117 | 117330 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 1144 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778490 | 5998226.1 | 2106298.1 | 37.7633909587408 | -122.449313182994 | (37.7633909587408, -122.449313182994) | 15 | 5 | 11 | 29492 | 9 | ||
2351 | 213378 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 1222 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784692 | 5993325.39992 | 2107141.02877 | 37.7654238793266 | -122.466324239095 | (37.7654238793266, -122.466324239095) | 11 | 8 | 11 | 56 | 12 | |
75824 | 106270 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 49 MISSOURI ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013498.7 | 2106906.8 | 37.7659240772205 | -122.39653250625 | (37.7659240772205, -122.39653250625) | 14 | 3 | 8 | 28856 | 20 | |||
139210 | 81687 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 210 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2017 12:00:00 AM | 3 | Permit Number 777040 | 5999000.68344445 | 2107685.40393875 | 37.7672444226119 | -122.446733986311 | (37.7672444226119, -122.446733986311) | 15 | 5 | 11 | 29492 | 9 | ||
163265 | 87372 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 67 Belcher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2008 12:00:00 AM | 3x3 | Permit Number 50351 | 6003819 | 2107947 | 37.7682367684387 | -122.430086795172 | (37.7682367684387, -122.430086795172) | 7 | 9 | 5 | 28862 | 3 | ||
168295 | 87371 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 67 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2008 12:00:00 AM | 3x3 | Permit Number 50351 | 6003819 | 2107947 | 37.7682367684387 | -122.430086795172 | (37.7682367684387, -122.430086795172) | 7 | 9 | 5 | 28862 | 3 | ||
78431 | 110449 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 28 BELCHER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775444 | 6003746 | 2108157 | 37.7688092427031 | -122.430354279635 | (37.7688092427031, -122.430354279635) | 7 | 9 | 5 | 28862 | 3 | |||
110759 | 110448 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 28 BELCHER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775444 | 6003746 | 2108157 | 37.7688092427031 | -122.430354279635 | (37.7688092427031, -122.430354279635) | 7 | 9 | 5 | 28862 | 3 | |||
44997 | 62672 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 48 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | 3 | Permit Number 23004 | 6002888.71912125 | 2108707.39458203 | 37.7702718941008 | -122.433358884898 | (37.7702718941008, -122.433358884898) | 15 | 5 | 5 | 29492 | 9 | |
134459 | 245120 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 129 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 6000774.8471 | 2109422.9959 | 37.7721166047697 | -122.44072207891 | (37.7721166047697, -122.44072207891) | 15 | 5 | 11 | 29492 | 9 | |||
136425 | 245119 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 129 Baker St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6000771.8557 | 2109441.6092 | 37.7721675418639 | -122.44073376176 | (37.7721675418639, -122.44073376176) | 15 | 5 | 11 | 29492 | 9 | |||
12570 | 75375 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 242 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5997883.096 | 2109628.0405 | 37.77251450021 | -122.450739621122 | (37.77251450021, -122.450739621122) | 15 | 5 | 11 | 29492 | 16 | |||
68971 | 140178 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 246 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997876.1972 | 2109680.9307 | 37.7726593281832 | -122.450767298801 | (37.7726593281832, -122.450767298801) | 15 | 5 | 11 | 29492 | 16 | |||
56846 | 140179 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 246 COLE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997872.7479 | 2109697.411 | 37.7727043813962 | -122.450780418722 | (37.7727043813962, -122.450780418722) | 15 | 5 | 11 | 29492 | 16 | |||
14980 | 75220 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 246 Cole St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5997870.8316 | 2109714.2746 | 37.772750574805 | -122.450788263508 | (37.772750574805, -122.450788263508) | 15 | 5 | 11 | 29492 | 16 | |||
8126 | 28056 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 33 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6005944.78414 | 2109618.42708 | 37.7729462740038 | -122.42285271058 | (37.7729462740038, -122.42285271058) | 7 | 9 | 11 | 28852 | 10 | |||
152005 | 28057 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 33 Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6005944.78414 | 2109618.42708 | 37.7729462740038 | -122.42285271058 | (37.7729462740038, -122.42285271058) | 7 | 9 | 11 | 28852 | 10 | |||
86556 | 244383 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 251 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005771.1844 | 2110310.2456 | 37.7748360439411 | -122.423502407009 | (37.7748360439411, -122.423502407009) | 7 | 9 | 11 | 28852 | 10 | |||
29831 | 85245 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 1307 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49546 | 6001610 | 2110428 | 37.7749236198612 | -122.437905219532 | (37.7749236198612, -122.437905219532) | 15 | 5 | 11 | 29492 | 10 | |||
118673 | 67230 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 519 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | 5 | Permit Number 30689 | 5984068.99923 | 2112275.3941 | 37.7789829387423 | -122.498718829258 | (37.7789829387423, -122.498718829258) | 11 | 6 | 2 | 55 | 26 | |
144043 | 139532 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 2103 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779818 | 6001200.3588 | 2113145.5057 | 37.7823618989571 | -122.439517100245 | (37.7823618989571, -122.439517100245) | 15 | 5 | 11 | 29490 | 41 | |
126113 | 85065 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 168 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2007 12:00:00 AM | Permit Number 49431 | 5992213.6 | 2114351.2 | 37.7851568443713 | -122.470694882766 | (37.7851568443713, -122.470694882766) | 11 | 6 | 2 | 54 | 11 | |||
130012 | 12534 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 129 LAKE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5995062 | 2114816 | 37.7865973635143 | -122.46087407189 | (37.7865973635143, -122.46087407189) | 11 | 6 | 1 | 54 | 11 | |||
133612 | 12528 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 100 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2008 12:00:00 AM | 3 | 3X3 | 5995135.72177 | 2114954.21759 | 37.7869811132671 | -122.4606290341 | (37.7869811132671, -122.4606290341) | 11 | 6 | 1 | 54 | 11 | ||
69703 | 21552 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 1405 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005864.0928275 | 2114832.0476095 | 37.7872570487118 | -122.423502557849 | (37.7872570487118, -122.423502557849) | 13 | 9 | 1 | 28858 | 41 | |||
178484 | 85208 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 3099 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2007 12:00:00 AM | Permit Number 49530 | 5999545 | 2115014 | 37.7873979483893 | -122.445378282275 | (37.7873979483893, -122.445378282275) | 13 | 6 | 1 | 29490 | 31 | |||
61403 | 111037 | Significant Tree 6 | Magnolia spp :: Magnolia 224 | 3991-3997 Washington St | 2 | Front Yard : Yard | Tree | Private 2 | 5995610.3 | 2115419.4 | 37.7882856707006 | -122.459020806409 | (37.7882856707006, -122.459020806409) | 11 | 6 | 1 | 54 | 31 | |||||
147948 | 111036 | Significant Tree 6 | Magnolia spp :: Magnolia 224 | 3991-3997 Washington St | 1 | Front Yard : Yard | Tree | Private 2 | 5995610.3 | 2115419.4 | 37.7882856707006 | -122.459020806409 | (37.7882856707006, -122.459020806409) | 11 | 6 | 1 | 54 | 31 | |||||
17989 | 250142 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 2550x Lyon St | 10 | Median : Yard | Tree | DPW 1 | 1 | 5999229.6006 | 2117622.80882 | 37.7945430395703 | -122.446657269218 | (37.7945430395703, -122.446657269218) | 13 | 9 | 1 | 57 | 27 | ||||
46982 | 86872 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 2160 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2007 12:00:00 AM | 3x3 | Permit Number 49804 | 6002705 | 2118187 | 37.796290071465 | -122.434672325351 | (37.796290071465, -122.434672325351) | 13 | 9 | 1 | 57 | 17 | |||
76679 | 86873 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 2160 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2007 12:00:00 AM | 3x3 | Permit Number 49804 | 6002705 | 2118187 | 37.796290071465 | -122.434672325351 | (37.796290071465, -122.434672325351) | 13 | 9 | 1 | 57 | 17 | |||
132141 | 131013 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 2531 Filbert St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6000837.80329 | 2118568.05574 | 37.797230171598 | -122.441160549934 | (37.797230171598, -122.441160549934) | 13 | 9 | 1 | 57 | 17 | |||
149155 | 87384 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 152 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50364 | 6002625 | 2119034 | 37.7986111712331 | -122.435009748717 | (37.7986111712331, -122.435009748717) | 13 | 9 | 1 | 57 | 17 |
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) );