trees
6,344 rows where qSpecies_id = 19 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26227 | 43874 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 542 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2000 12:00:00 AM | Permit Number 43489 | 6002849.6258444 | 2102722.51775961 | 37.7538366507186 | -122.43306644016 | (37.7538366507186, -122.43306644016) | 2 | 4 | 5 | 28862 | 22 | |||
26455 | 45561 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 299X WALNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3x3 | Permit Number 44307 | 5998535 | 2115724 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | 13 | 6 | 1 | 54 | 31 | |
26849 | 50700 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 401 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2004 12:00:00 AM | Permit Number 47263 | 5994270 | 2113428 | 37.7827406888872 | -122.463513409886 | (37.7827406888872, -122.463513409886) | 11 | 6 | 2 | 54 | 11 | |||
27205 | 40405 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 45 Montecito Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1999 12:00:00 AM | Permit Number 41508 | 5996687.37190018 | 2094527.09346306 | 37.7309825514443 | -122.453785045841 | (37.7309825514443, -122.453785045841) | 9 | 7 | 4 | 28861 | 40 | |||
27656 | 59382 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 476 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19658 | 6003601.47411303 | 2096143.32697895 | 37.7358143364909 | -122.429997089324 | (37.7358143364909, -122.429997089324) | 2 | 7 | 5 | 63 | 7 | ||
27694 | 107312 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 601 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6001063.17022 | 2110781.56878 | 37.7758633196923 | -122.439822170731 | (37.7758633196923, -122.439822170731) | 15 | 5 | 11 | 29492 | 10 | ||
27704 | 45159 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 730 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2001 12:00:00 AM | Permit Number 44012 | 6009270.50155005 | 2104836.1684408 | 37.7600023827166 | -122.411010762795 | (37.7600023827166, -122.411010762795) | 2 | 4 | 7 | 28859 | 19 | |||
27724 | 30430 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 418 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 83 | 6010919.16231667 | 2119684.73214888 | 37.8008653758927 | -122.406355057963 | (37.8008653758927, -122.406355057963) | 3 | 1 | 10 | 308 | 23 | |||
28517 | 94060 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1401X 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993648 | 2105942 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | 1 | 8 | 11 | 56 | 12 | ||||
28846 | 68756 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4108 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32678 | 6002338.56977178 | 2104742.21735486 | 37.7593532587281 | -122.434978222469 | (37.7593532587281, -122.434978222469) | 2 | 4 | 5 | 28862 | 3 | ||
29741 | 48723 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 285 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45984 | 5994715.98123116 | 2090468.92851584 | 37.7197265891744 | -122.460306507178 | (37.7197265891744, -122.460306507178) | 9 | 8 | 6 | 28861 | 24 | ||
30018 | 60117 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 14 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19642 | 6004839.88177356 | 2098293.71651362 | 37.7417888775719 | -122.425868444921 | (37.7417888775719, -122.425868444921) | 2 | 7 | 5 | 63 | 7 | ||
30101 | 35372 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 681 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 3x6 | Permit Number 38831 | 6011634.06161784 | 2091593.09075052 | 37.7237719784077 | -122.401905355277 | (37.7237719784077, -122.401905355277) | 10 | 3 | 7 | 309 | 28 | |
30777 | 67775 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31408 | 6003124.05257267 | 2108779.41932212 | 37.7704830045429 | -122.43255001344 | (37.7704830045429, -122.43255001344) | 15 | 5 | 5 | 29492 | 9 | ||
31076 | 69469 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1569 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | Permit Number 33585 | 5991106.49879759 | 2104699.95810887 | 37.7585930707153 | -122.473820732038 | (37.7585930707153, -122.473820732038) | 1 | 8 | 4 | 56 | 12 | ||
31237 | 66691 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 350 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | Permit Number 29919 | 6008314.85711082 | 2113143.31425185 | 37.7827582184104 | -122.414903841616 | (37.7827582184104, -122.414903841616) | 7 | 10 | 9 | 28852 | 36 | ||
31305 | 39632 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 931 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41027 | 5997187.89015647 | 2107294.29840033 | 37.7660668249931 | -122.452975907923 | (37.7660668249931, -122.452975907923) | 15 | 5 | 11 | 29492 | 12 | ||
31459 | 44117 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3101 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43623 | 6009015.63351347 | 2100966.56489763 | 37.7493630273468 | -122.411618822527 | (37.7493630273468, -122.411618822527) | 2 | 4 | 7 | 28859 | 19 | |||
31515 | 69415 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 144 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33520 | 6001498.01524641 | 2087340.50878812 | 37.7115244375894 | -122.436639656352 | (37.7115244375894, -122.436639656352) | 9 | 7 | 6 | 28861 | 5 | ||
31666 | 36722 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 70 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39506 | 6005607.11849934 | 2108616.17043727 | 37.7701752601998 | -122.423949453818 | (37.7701752601998, -122.423949453818) | 8 | 2 | 5 | 28853 | 19 | ||
31963 | 33498 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37606 | 6006683.58482984 | 2099106.89574168 | 37.7441257054073 | -122.419551194294 | (37.7441257054073, -122.419551194294) | 2 | 7 | 7 | 28859 | 2 | |||
32159 | 60131 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 568 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19661 | 6003100.360251 | 2095761.63487373 | 37.7347379043363 | -122.431702392408 | (37.7347379043363, -122.431702392408) | 2 | 7 | 5 | 63 | 7 | ||
32247 | 60631 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 506 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20257 | 6003462.71077549 | 2096034.20965645 | 37.735506865485 | -122.430469065238 | (37.735506865485, -122.430469065238) | 2 | 7 | 5 | 63 | 7 | ||
32317 | 113228 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1150 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | 13 | 9 | 10 | 28858 | 21 | ||||
32401 | 46894 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1445 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 44949 | 5992707.32410369 | 2105628.35090548 | 37.7612347828689 | -122.468351943903 | (37.7612347828689, -122.468351943903) | 1 | 8 | 4 | 56 | 12 | ||
32446 | 64127 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 647 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24898 | 6002406.23818147 | 2098844.72039568 | 37.7431639736769 | -122.434322556442 | (37.7431639736769, -122.434322556442) | 2 | 7 | 5 | 63 | 7 | ||
32457 | 56591 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 521 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1988 12:00:00 AM | 3x3 | Permit Number 25102 | 6003281.28786158 | 2096142.65442587 | 37.7357943512286 | -122.431104050323 | (37.7357943512286, -122.431104050323) | 2 | 7 | 5 | 63 | 7 | ||
32502 | 30327 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 414 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/1956 12:00:00 AM | Permit Number 18 | 6013759.67199369 | 2105160.54223846 | 37.7611437571862 | -122.395507498425 | (37.7611437571862, -122.395507498425) | 10 | 3 | 8 | 28856 | 29 | |||
32989 | 50828 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 79 Kempton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47347 | 5992329.33717846 | 2087607.86910297 | 37.7117332358721 | -122.468348178801 | (37.7117332358721, -122.468348178801) | 9 | 8 | 4 | 64 | 24 | |||
33239 | 97279 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 194@ Lake St 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2011 12:00:00 AM | Permit Number 768130 | 5987198.3 | 2114675.7 | 37.7857565298487 | -122.488069885717 | (37.7857565298487, -122.488069885717) | 11 | 6 | 1 | 55 | 33 | |||
33403 | 121563 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 102 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x15 | 6000873 | 2109380 | 37.7720041379507 | -122.440379476736 | (37.7720041379507, -122.440379476736) | 15 | 5 | 11 | 29492 | 9 | ||||
33586 | 44130 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2720 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2000 12:00:00 AM | Permit Number 43632 | 6001631.4637394 | 2117748.66833933 | 37.7950255235944 | -122.438355557287 | (37.7950255235944, -122.438355557287) | 13 | 9 | 1 | 57 | 27 | |||
34313 | 255645 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1122 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6010085.7211 | 2110745.2484 | 37.7762730405804 | -122.408608151117 | (37.7762730405804, -122.408608151117) | 8 | 2 | 9 | 28853 | 34 | ||||
34720 | 30801 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 199 Burnside Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1995 12:00:00 AM | Permit Number 34666 | 6001085.22188443 | 2095491.07454236 | 37.7338805765559 | -122.438650020361 | (37.7338805765559, -122.438650020361) | 9 | 7 | 5 | 63 | 40 | |||
35083 | 34288 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2700 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38078 | 5987152.40290337 | 2114633.58792494 | 37.7856382245586 | -122.488225578837 | (37.7856382245586, -122.488225578837) | 11 | 6 | 1 | 55 | 33 | |||
35146 | 49917 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 320@ 20th ST San Carlos St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | Permit Number 46678 | 6006688.86644184 | 2104241.79447872 | 37.7582252623817 | -122.419897234256 | (37.7582252623817, -122.419897234256) | 2 | 4 | 7 | 28859 | 19 | ||
35237 | 116382 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2501 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | DPW for City Agency | 3x3 | 6011435.88896489 | 2101815.42613948 | 37.7518292809831 | -122.403309184671 | (37.7518292809831, -122.403309184671) | 10 | 4 | 8 | 28859 | 19 | |||
35444 | 40329 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1045 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/1999 12:00:00 AM | Permit Number 41464 | 6009812.61819083 | 2112153.76384169 | 37.7801251935626 | -122.409652332288 | (37.7801251935626, -122.409652332288) | 14 | 2 | 9 | 28853 | 34 | |||
36065 | 40327 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1045 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/1999 12:00:00 AM | Permit Number 41464 | 6009812.61819083 | 2112153.76384169 | 37.7801251935626 | -122.409652332288 | (37.7801251935626, -122.409652332288) | 14 | 2 | 9 | 28853 | 34 | |||
36177 | 35387 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 598 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38841 | 6011210.92934518 | 2105577.19516612 | 37.7621456977868 | -122.404351880979 | (37.7621456977868, -122.404351880979) | 8 | 3 | 8 | 28856 | 29 | ||
36337 | 34755 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 930 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/2010 12:00:00 AM | 3x3 | 6007964.37275398 | 2102502.67346206 | 37.7535218086 | -122.415362848727 | (37.7535218086, -122.415362848727) | 2 | 4 | 7 | 28859 | 19 | ||
36341 | 67555 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1324 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31104 | 6001511.87530009 | 2110460.33363228 | 37.7750068195041 | -122.438246969878 | (37.7750068195041, -122.438246969878) | 15 | 5 | 11 | 29492 | 10 | ||
36711 | 49918 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 320@ 20th ST San Carlos St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | Permit Number 46678 | 6006688.86644184 | 2104241.79447872 | 37.7582252623817 | -122.419897234256 | (37.7582252623817, -122.419897234256) | 2 | 4 | 7 | 28859 | 19 | ||
37912 | 110359 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1850 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||||
37997 | 68749 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4017 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32670 | 6002873.64078286 | 2105304.39868681 | 37.7609272400591 | -122.433167856284 | (37.7609272400591, -122.433167856284) | 2 | 4 | 5 | 28862 | 3 | ||
38065 | 33115 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2673 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37352 | 6000168.9096663 | 2118482.62323386 | 37.7969574731593 | -122.443468942917 | (37.7969574731593, -122.443468942917) | 13 | 9 | 1 | 57 | 17 | ||
38081 | 108922 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 857 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x12 | 5999156 | 2107174 | 37.7658491072629 | -122.446159980933 | (37.7658491072629, -122.446159980933) | 15 | 5 | 11 | 29492 | 9 | ||||
38190 | 98526 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 428 11th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030 | 2108561 | 37.7702164230423 | -122.412105792177 | (37.7702164230423, -122.412105792177) | 8 | 2 | 9 | 28853 | 19 | ||
38395 | 59782 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 29 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | Permit Number 24369 | 6007036.97760826 | 2100065.29510753 | 37.7467771538937 | -122.418397179184 | (37.7467771538937, -122.418397179184) | 2 | 7 | 7 | 28859 | 2 | ||
38434 | 104322 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 90X Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 | ||||
38806 | 32873 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1239 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37219 | 5995137.1937239 | 2107104.76872667 | 37.7654286915292 | -122.460055076616 | (37.7654286915292, -122.460055076616) | 15 | 5 | 11 | 56 | 12 | ||
39089 | 49000 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 436 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/2002 12:00:00 AM | Permit Number 46187 | 6001787.89953179 | 2103298.38965715 | 37.7553575743302 | -122.436779349279 | (37.7553575743302, -122.436779349279) | 2 | 4 | 5 | 28862 | 22 | ||
39161 | 59883 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 362 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1984 12:00:00 AM | Permit Number 21326 | 6003554.62619384 | 2106174.72293036 | 37.7633555478542 | -122.430874741116 | (37.7633555478542, -122.430874741116) | 15 | 4 | 5 | 28862 | 3 | ||
39429 | 51493 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3380 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2005 12:00:00 AM | Permit Number 47805 | 6006511.75408119 | 2102633.6754024 | 37.7537997593029 | -122.420395625489 | (37.7537997593029, -122.420395625489) | 2 | 4 | 7 | 28859 | 19 | |||
39495 | 104245 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 42 Belvedere St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2013 12:00:00 AM | 3x3 | Permit Number 769673 | 5998257.6 | 2108324 | 37.7689553686247 | -122.449350208019 | (37.7689553686247, -122.449350208019) | 15 | 5 | 11 | 29492 | 9 | ||
39545 | 101317 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 273 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
39817 | 61481 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 269 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1992 12:00:00 AM | Permit Number 21426 | 6003576.49784427 | 2106719.93000804 | 37.7648537942292 | -122.430838005187 | (37.7648537942292, -122.430838005187) | 8 | 4 | 5 | 28862 | 3 | ||
40053 | 104874 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 890X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769944 | 6007654.60199 | 2097738.03982 | 37.7404217779739 | -122.416096698799 | (37.7404217779739, -122.416096698799) | 2 | 7 | 7 | 28859 | 2 | |||
40546 | 65241 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1055 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50990 | 6009207.81332518 | 2103021.34341787 | 37.7550157681098 | -122.411099379217 | (37.7550157681098, -122.411099379217) | 2 | 4 | 7 | 28859 | 19 | ||
40717 | 34287 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2700 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 47000 | 5987152.40290337 | 2114633.58792494 | 37.7856382245586 | -122.488225578837 | (37.7856382245586, -122.488225578837) | 11 | 6 | 1 | 55 | 33 | ||
40760 | 60688 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2758 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52228 | 6009644.49323713 | 2103392.38741296 | 37.7560590506914 | -122.409615395974 | (37.7560590506914, -122.409615395974) | 2 | 4 | 7 | 28859 | 19 | ||
40937 | 31429 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4253 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1995 12:00:00 AM | Permit Number 35008 | 6001338.01744955 | 2103327.9645449 | 37.7554132015605 | -122.438337292756 | (37.7554132015605, -122.438337292756) | 2 | 4 | 5 | 28862 | 22 | |||
41087 | 47710 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 35 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45505 | 6002613.96578563 | 2096324.44810828 | 37.7362556776497 | -122.433424228715 | (37.7362556776497, -122.433424228715) | 2 | 7 | 5 | 63 | 7 | ||
41518 | 39336 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 38 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45380 | 6007303.38841626 | 2106987.20131055 | 37.7657981130525 | -122.417966562524 | (37.7657981130525, -122.417966562524) | 8 | 4 | 7 | 28853 | 19 | ||
41532 | 93097 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 204 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | Permit Number 769007 | 5999086 | 2107671 | 37.767209746334 | -122.446437853494 | (37.767209746334, -122.446437853494) | 15 | 5 | 11 | 29492 | 9 | |||
42277 | 68717 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3906 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32633 | 6002903.511036 | 2105942.15376651 | 37.7626800559393 | -122.433110116369 | (37.7626800559393, -122.433110116369) | 15 | 4 | 5 | 28862 | 3 | ||
42335 | 33865 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1290 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1997 12:00:00 AM | Permit Number 37860 | 6010566.25284757 | 2101826.27931329 | 37.7518104732572 | -122.406317285521 | (37.7518104732572, -122.406317285521) | 10 | 4 | 7 | 28859 | 19 | |||
42402 | 40232 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3750 Mission St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | Permit Number 41412 | 6005244.44626478 | 2096435.85175558 | 37.7367104548817 | -122.42433748337 | (37.7367104548817, -122.42433748337) | 2 | 7 | 5 | 28859 | 2 | |||
42848 | 34235 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1997 12:00:00 AM | Permit Number 38048 | 6016895.91787464 | 2103845.69851644 | 37.7577074184489 | -122.384568876102 | (37.7577074184489, -122.384568876102) | 10 | 3 | 8 | 28856 | 29 | ||||
42873 | 45832 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 680 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44447 | 6012169.50994414 | 2114476.97613275 | 37.7866359833773 | -122.401662060279 | (37.7866359833773, -122.401662060279) | 12 | 2 | 9 | 28855 | 6 | |||
42977 | 50408 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 98 Delano Ave | 2 | 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 | ||
43593 | 46455 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1150 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2002 12:00:00 AM | Permit Number 44665 | 6009950.82359138 | 2110605.15598123 | 37.7758808235719 | -122.409064913537 | (37.7758808235719, -122.409064913537) | 8 | 2 | 9 | 28853 | 34 | |||
43798 | 39786 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 50 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41452 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.421567620452 | (37.7544443606741, -122.421567620452) | 2 | 4 | 5 | 28859 | 19 | ||
43811 | 67924 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 114 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31637 | 6003732.77751346 | 2095160.51472993 | 37.7331231920536 | -122.429473055103 | (37.7331231920536, -122.429473055103) | 9 | 7 | 5 | 28861 | 25 | ||
44253 | 255644 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1122 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6010085.7211 | 2110745.2484 | 37.7762730405804 | -122.408608151117 | (37.7762730405804, -122.408608151117) | 8 | 2 | 9 | 28853 | 34 | ||||
44308 | 34284 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2700 Lake St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38078 | 5987152.40290337 | 2114633.58792494 | 37.7856382245586 | -122.488225578837 | (37.7856382245586, -122.488225578837) | 11 | 6 | 1 | 55 | 33 | |||
44909 | 39893 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
44936 | 53663 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1347 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1995 12:00:00 AM | Permit Number 18593 | 6006742.77162231 | 2115546.43032117 | 37.789268123315 | -122.420513239236 | (37.789268123315, -122.420513239236) | 13 | 9 | 10 | 28858 | 21 | ||
45223 | 60754 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1326 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1983 12:00:00 AM | Permit Number 20420 | 6009245.12435038 | 2101426.54577047 | 37.7506389030081 | -122.410857717488 | (37.7506389030081, -122.410857717488) | 2 | 4 | 7 | 28859 | 19 | ||
45374 | 112650 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3100X 26TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008747 | 2100981 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | 2 | 4 | 7 | 28859 | 19 | ||||
45666 | 57072 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 944 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2002 12:00:00 AM | Permit Number 14339 | 6015225.6126558 | 2104191.58831349 | 37.7585646470388 | -122.390369693575 | (37.7585646470388, -122.390369693575) | 10 | 3 | 8 | 28856 | 29 | ||
45867 | 107185 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Florence St | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 773363 | 6008515.42073 | 2118375.20615 | 37.7971349853662 | -122.41458032272 | (37.7971349853662, -122.41458032272) | 5 | 1 | 10 | 308 | 21 | ||||
46069 | 51762 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 137 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2005 12:00:00 AM | Permit Number 48029 | 6004669.43811399 | 2097526.56698943 | 37.7396728258328 | -122.426403174041 | (37.7396728258328, -122.426403174041) | 2 | 7 | 5 | 63 | 7 | |||
46219 | 52045 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2440 Pacific Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2005 12:00:00 AM | Permit Number 48253 | 6002464.00104599 | 2117114.1670353 | 37.7933306654682 | -122.435429447426 | (37.7933306654682, -122.435429447426) | 13 | 9 | 1 | 29490 | 27 | |||
46457 | 46114 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | Permit Number 44473 | 5998803.64501261 | 2106479.79215495 | 37.7639228586403 | -122.447328728164 | (37.7639228586403, -122.447328728164) | 15 | 5 | 11 | 29492 | 9 | |||
46534 | 44026 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 585 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2000 12:00:00 AM | Permit Number 43566 | 6010135.95582319 | 2119871.63651456 | 37.8013347258726 | -122.409078489637 | (37.8013347258726, -122.409078489637) | 3 | 1 | 10 | 308 | 23 | |||
46956 | 40233 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3750 Mission St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | Permit Number 41412 | 6005244.44626478 | 2096435.85175558 | 37.7367104548817 | -122.42433748337 | (37.7367104548817, -122.42433748337) | 2 | 7 | 5 | 28859 | 2 | |||
46974 | 86712 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3806 22nd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2007 12:00:00 AM | Permit Number 49698 | 6003066 | 2103019 | 37.7546629917484 | -122.432339342326 | (37.7546629917484, -122.432339342326) | 2 | 4 | 5 | 28862 | 22 | ||||
47036 | 41556 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3730 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49796 | 6005646.33181181 | 2100832.68503271 | 37.7488058486983 | -122.423260443581 | (37.7488058486983, -122.423260443581) | 2 | 4 | 5 | 28859 | 19 | ||
47960 | 44070 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 21 Willard North St | 1 | 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 | |||
48306 | 67175 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30620 | 6006812.19875407 | 2099499.78244661 | 37.7452117275578 | -122.419134337627 | (37.7452117275578, -122.419134337627) | 2 | 7 | 7 | 28859 | 2 | ||
48535 | 51792 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1329 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1983 12:00:00 AM | Permit Number 48041 | 6009297.66372475 | 2101418.21266178 | 37.750618968004 | -122.410675442871 | (37.750618968004, -122.410675442871) | 2 | 4 | 7 | 28859 | 19 | ||
48674 | 93096 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 204 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2010 12:00:00 AM | 3x3 | Permit Number 53157 | 5999086 | 2107671 | 37.767209746334 | -122.446437853494 | (37.767209746334, -122.446437853494) | 15 | 5 | 11 | 29492 | 9 | ||
48938 | 102827 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2001X Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
49172 | 34280 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2700 Lake St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38078 | 5987152.40290337 | 2114633.58792494 | 37.7856382245586 | -122.488225578837 | (37.7856382245586, -122.488225578837) | 11 | 6 | 1 | 55 | 33 | |||
49222 | 105835 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2205 Pacific Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/28/2014 12:00:00 AM | Permit Number 772662 | 6003508.7 | 2117188.3 | 37.7935934914571 | -122.431820013768 | (37.7935934914571, -122.431820013768) | 13 | 9 | 1 | 29490 | 27 | |||
49443 | 48396 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4431 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/2002 12:00:00 AM | Permit Number 45778 | 6001335.20759715 | 2104634.62927153 | 37.759000826272 | -122.438440622703 | (37.759000826272, -122.438440622703) | 2 | 4 | 5 | 28862 | 3 | ||
49561 | 45155 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1715 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2001 12:00:00 AM | Permit Number 44008 | 6009342.43384914 | 2099476.98722268 | 37.7452913024869 | -122.410383570921 | (37.7452913024869, -122.410383570921) | 2 | 7 | 7 | 28859 | 2 | ||
50078 | 35386 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 598 Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38841 | 6011210.92934518 | 2105577.19516612 | 37.7621456977868 | -122.404351880979 | (37.7621456977868, -122.404351880979) | 8 | 3 | 8 | 28856 | 29 | ||
50244 | 38386 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1516 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2004 12:00:00 AM | Permit Number 40445 | 5999708.447805 | 2107273.92637961 | 37.7661550136859 | -122.444256367831 | (37.7661550136859, -122.444256367831) | 15 | 5 | 5 | 29492 | 9 |
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) );