trees
11,761 rows where qSpecies_id = 17 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194363 | 265042 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x010 | Permit Number 787936 | |||||||||||
194359 | 262298 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 1 | Side Yard : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x10 | Permit Number 787936 | 5991616 | 2101838 | 37.7507643799851 | -122.471850083311 | (37.7507643799851, -122.471850083311) | 1 | 8 | 4 | 29491 | 12 | |
194349 | 265045 | Section 806 (d) 5 | Tree(s) :: 17 | 1250 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194270 | 264977 | Significant Tree 6 | Tree(s) :: 17 | 188 Yerba Buena Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787864 | 5994639 | 2096200 | 37.7354582929988 | -122.460987765625 | (37.7354582929988, -122.460987765625) | 9 | 8 | 4 | 59 | 40 | |
194241 | 87028 | Permitted Site 7 | Tree(s) :: 17 | 460 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 775764 | 5993816 | 2101815 | 37.7508282780146 | -122.464240679792 | (37.7508282780146, -122.464240679792) | 1 | 8 | 4 | 29491 | 12 | ||
194229 | 98736 | Undocumented 4 | Tree(s) :: 17 | 89 Paradise Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 6000827.4 | 2096045.9 | 37.7353893278652 | -122.439581147409 | (37.7353893278652, -122.439581147409) | 2 | 7 | 5 | 63 | 7 | ||||||
194203 | 59390 | Permitted Site 7 | Tree(s) :: 17 | 522 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1980 12:00:00 AM | Permit Number 18744 | 6003369.07429125 | 2095960.92272246 | 37.7353003315172 | -122.430787573509 | (37.7353003315172, -122.430787573509) | 2 | 7 | 5 | 63 | 7 | |||
194111 | 59032 | Permitted Site 7 | Tree(s) :: 17 | 985 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1990 12:00:00 AM | Permit Number 29367 | 6008032.28329812 | 2102204.43473858 | 37.7527067292395 | -122.415106889811 | (37.7527067292395, -122.415106889811) | 2 | 4 | 7 | 28859 | 19 | |||
194096 | 64428 | Permitted Site 7 | Tree(s) :: 17 | 174 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1990 12:00:00 AM | Permit Number 29387 | 6002660.36402635 | 2104886.09913536 | 37.7597665896018 | -122.433875586505 | (37.7597665896018, -122.433875586505) | 2 | 4 | 5 | 28862 | 3 | |||
194075 | 53425 | Permitted Site 7 | Tree(s) :: 17 | 22 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1969 12:00:00 AM | Permit Number 6325 | 5998576.48514196 | 2106929.88862027 | 37.7651457271594 | -122.448146813934 | (37.7651457271594, -122.448146813934) | 15 | 5 | 11 | 29492 | 9 | |||
194066 | 58863 | Permitted Site 7 | Tree(s) :: 17 | 331 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1986 12:00:00 AM | Permit Number 23564 | 6007756.09682215 | 2097566.29894188 | 37.7399559215766 | -122.415733611191 | (37.7399559215766, -122.415733611191) | 2 | 7 | 7 | 28859 | 2 | |||
194065 | 92027 | Permitted Site 7 | Tree(s) :: 17 | 80 Crown Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 52172 | 5998680.9 | 2104321.8 | 37.7579905367617 | -122.447597912788 | (37.7579905367617, -122.447597912788) | 15 | 5 | 5 | 28862 | 12 | ||
194044 | 115634 | Undocumented 4 | Tree(s) :: 17 | 844 43RD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982626 | 2109989 | 37.7726204302856 | -122.503541302768 | (37.7726204302856, -122.503541302768) | 11 | 6 | 2 | 55 | 26 | ||||
194013 | 53275 | Permitted Site 7 | Tree(s) :: 17 | 70 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1969 12:00:00 AM | Permit Number 6165 | 6004072.62968681 | 2102650.60497511 | 37.7537084925961 | -122.428831883911 | (37.7537084925961, -122.428831883911) | 2 | 4 | 5 | 28862 | 22 | |||
194003 | 56702 | Permitted Site 7 | Tree(s) :: 17 | 1654 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5983167.42823227 | 2103871.72196183 | 37.7558559430954 | -122.501215923743 | (37.7558559430954, -122.501215923743) | 1 | 8 | 3 | 56 | 35 | |||||
193966 | 57757 | Permitted Site 7 | Tree(s) :: 17 | 6 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1977 12:00:00 AM | Permit Number 16680 | 5996239.23883493 | 2095895.46247941 | 37.73471405973 | -122.455433167904 | (37.73471405973, -122.455433167904) | 9 | 7 | 4 | 59 | 40 | |||
193949 | 45203 | Permitted Site 7 | Tree(s) :: 17 | 1960 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2001 12:00:00 AM | Permit Number 44047 | 5993860.26347806 | 2102157.70521953 | 37.7517718101952 | -122.464112489667 | (37.7517718101952, -122.464112489667) | 1 | 8 | 4 | 29491 | 12 | |||
193938 | 56966 | Permitted Site 7 | Tree(s) :: 17 | 425 Dellbrook Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1974 12:00:00 AM | Permit Number 14218 | 5996998.57044522 | 2102801.79522801 | 37.7537206962491 | -122.45330635517 | (37.7537206962491, -122.45330635517) | 1 | 5 | 4 | 63 | 38 | |||
193902 | 54773 | Permitted Site 7 | Tree(s) :: 17 | 1447 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1972 12:00:00 AM | Permit Number 10622 | 5994255.46908651 | 2105668.26375413 | 37.7614336708029 | -122.463000504273 | (37.7614336708029, -122.463000504273) | 1 | 5 | 11 | 56 | 12 | |||
193894 | 107703 | Undocumented 4 | Tree(s) :: 17 | 41 Hill St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773950 | 6006079.45841 | 2103417.96835 | 37.7559288760699 | -122.421946314733 | (37.7559288760699, -122.421946314733) | 2 | 4 | 5 | 28859 | 19 | ||
193892 | 96142 | DPW Maintained 1 | Tree(s) :: 17 | 1468X Innes Ave | 2 | Median : Yard | Tree | DPW 1 | 12 | 6016228.8 | 2096740.9 | 37.738162198215 | -122.386380713289 | (37.738162198215, -122.386380713289) | 10 | 3 | 8 | 58 | 1 | ||||
193885 | 59393 | Permitted Site 7 | Tree(s) :: 17 | 562 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1980 12:00:00 AM | Permit Number 18747 | 6003134.98309305 | 2095777.70539718 | 37.7347839928279 | -122.4315838364 | (37.7347839928279, -122.4315838364) | 2 | 7 | 5 | 63 | 7 | |||
193873 | 104514 | Permitted Site 7 | Tree(s) :: 17 | 951X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 769348 | 6003136.88102 | 2102566.33372 | 37.7534240963555 | -122.432061893742 | (37.7534240963555, -122.432061893742) | 2 | 4 | 5 | 28862 | 22 | ||
193839 | 91054 | Permitted Site 7 | Tree(s) :: 17 | 750 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2008 12:00:00 AM | 3x3 | Permit Number 51965 | 6012124 | 2113544 | 37.7840717096161 | -122.401753911211 | (37.7840717096161, -122.401753911211) | 12 | 2 | 9 | 28853 | 6 | ||
193832 | 100062 | Undocumented 4 | Tree(s) :: 17 | 430X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 3x3 | Permit Number 768595 | 6011459 | 2112320 | 37.7806737592872 | -122.403968419194 | (37.7806737592872, -122.403968419194) | 14 | 2 | 9 | 28853 | 34 | ||
193822 | 57502 | Permitted Site 7 | Tree(s) :: 17 | 645 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1976 12:00:00 AM | Permit Number 16354 | 6002231.27065409 | 2102052.31128719 | 37.7519613287465 | -122.435156919426 | (37.7519613287465, -122.435156919426) | 2 | 4 | 5 | 28862 | 22 | |||
193817 | 111176 | Undocumented 4 | Tree(s) :: 17 | 650 28TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775967 | 6001692 | 2099453 | 37.7447935997954 | -122.436835733404 | (37.7447935997954, -122.436835733404) | 2 | 7 | 5 | 63 | 22 | |
193811 | 53999 | Permitted Site 7 | Tree(s) :: 17 | 14 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1972 12:00:00 AM | Permit Number 9717 | 6010652.24723851 | 2089463.80706867 | 37.7178705599695 | -122.405149476877 | (37.7178705599695, -122.405149476877) | 10 | 7 | 8 | 309 | 39 | |||
193810 | 59427 | Permitted Site 7 | Tree(s) :: 17 | 3030 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | Permit Number 18789 | 6002847.01894889 | 2096073.28659013 | 37.7355792650376 | -122.432600533347 | (37.7355792650376, -122.432600533347) | 2 | 7 | 5 | 63 | 7 | |||
193793 | 102659 | DPW Maintained 1 | Tree(s) :: 17 | 2700 45th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2013 12:00:00 AM | 0 | 3x3 | Permit Number 769687 | 5982502.5 | 2096638.9 | 37.7359575501703 | -122.502979993418 | (37.7359575501703, -122.502979993418) | 1 | 8 | 3 | 29491 | 35 | |
193792 | 61487 | Permitted Site 7 | Tree(s) :: 17 | 450 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/1984 12:00:00 AM | Permit Number 21432 | 6009986.55325494 | 2115111.49204318 | 37.7882561568332 | -122.409259387993 | (37.7882561568332, -122.409259387993) | 5 | 1 | 10 | 28852 | 21 | |||
193761 | 59554 | Permitted Site 7 | Tree(s) :: 17 | 114 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1981 12:00:00 AM | Permit Number 18940 | 5989933.62004717 | 2114608.14551697 | 37.7857302354003 | -122.478601614646 | (37.7857302354003, -122.478601614646) | 11 | 6 | 2 | 55 | 26 | |||
193749 | 35853 | Permitted Site 7 | Tree(s) :: 17 | 500 Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778923 | 6001729.76297614 | 2090780.38588209 | 37.7209827425077 | -122.436084672938 | (37.7209827425077, -122.436084672938) | 9 | 7 | 6 | 28861 | 5 | |
193743 | 211099 | Significant Tree 6 | Tree(s) :: 17 | 501 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/18/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781418 | 5993137.63738 | 2096084.35497 | 37.7350542531473 | -122.466170096172 | (37.7350542531473, -122.466170096172) | 1 | 8 | 4 | 59 | 40 | |
193732 | 61830 | Permitted Site 7 | Tree(s) :: 17 | 21 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1985 12:00:00 AM | Permit Number 21867 | 6000368.03189985 | 2101553.31084355 | 37.7504852137468 | -122.441564443283 | (37.7504852137468, -122.441564443283) | 2 | 4 | 5 | 28862 | 22 | |||
193726 | 55505 | Permitted Site 7 | Tree(s) :: 17 | 877 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2012 12:00:00 AM | Permit Number 769029 | 6001316.38571339 | 2101284.99848129 | 37.7498024771894 | -122.438265751867 | (37.7498024771894, -122.438265751867) | 2 | 4 | 5 | 28862 | 22 | |||
193718 | 51972 | Permitted Site 7 | Tree(s) :: 17 | 31REVISED Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2006 12:00:00 AM | Permit Number 48193 | 6000867.64488524 | 2106169.34308213 | 37.7631881671737 | -122.440167724833 | (37.7631881671737, -122.440167724833) | 15 | 5 | 5 | 28862 | 3 | |||
193683 | 54798 | Permitted Site 7 | Tree(s) :: 17 | 448 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | Permit Number 10649 | 6012425.51934153 | 2086571.65769638 | 37.710028268909 | -122.398817155488 | (37.710028268909, -122.398817155488) | 10 | 3 | 8 | 309 | 1 | |||
193672 | 50972 | Permitted Site 7 | Tree(s) :: 17 | 683 REVISED Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2004 12:00:00 AM | Permit Number 47463 | 6012417.01604771 | 2110263.6615562 | 37.775081003703 | -122.40050967291 | (37.775081003703, -122.40050967291) | 14 | 2 | 9 | 28856 | 20 | |||
193614 | 93010 | Permitted Site 7 | Tree(s) :: 17 | 1520 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2010 12:00:00 AM | 3x3 | Permit Number 53136 | 6015407.2 | 2095381.5 | 37.7343840488548 | -122.389126529878 | (37.7343840488548, -122.389126529878) | 10 | 3 | 8 | 58 | 1 | ||
193558 | 66280 | Permitted Site 7 | Tree(s) :: 17 | 828 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1990 12:00:00 AM | Permit Number 29391 | 5998695.58119662 | 2107319.16022296 | 37.7662213763467 | -122.447762917426 | (37.7662213763467, -122.447762917426) | 15 | 5 | 11 | 29492 | 9 | |||
193556 | 54459 | Permitted Site 7 | Tree(s) :: 17 | 4231 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1972 12:00:00 AM | Permit Number 10250 | 6002400.47694314 | 2100599.86959771 | 37.7479828746195 | -122.434467942065 | (37.7479828746195, -122.434467942065) | 2 | 4 | 5 | 63 | 22 | |||
193531 | 223052 | DPW Maintained 1 | Tree(s) :: 17 | 50 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780696 | 6001430.01657 | 2107860.72722 | 37.7678642922401 | -122.438343854404 | (37.7678642922401, -122.438343854404) | 15 | 5 | 5 | 29492 | 3 | |
193525 | 99685 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
193514 | 66728 | Permitted Site 7 | Tree(s) :: 17 | 615 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/1991 12:00:00 AM | Permit Number 29971 | 5992676.53220067 | 2105893.65059977 | 37.7619614475114 | -122.468477741786 | (37.7619614475114, -122.468477741786) | 1 | 8 | 4 | 56 | 12 | |||
193511 | 247342 | DPW Maintained 1 | Tree(s) :: 17 | 415 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998861.9742 | 2109259.5681 | 37.7715587533736 | -122.447327071467 | (37.7715587533736, -122.447327071467) | 15 | 5 | 11 | 29492 | 9 | |||
193503 | 53508 | Permitted Site 7 | Tree(s) :: 17 | 238 Ralston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1969 12:00:00 AM | Permit Number 6418 | 5992226.59125592 | 2089458.03207637 | 37.7168074014067 | -122.468837842897 | (37.7168074014067, -122.468837842897) | 9 | 8 | 6 | 64 | 24 | |||
193496 | 53294 | Permitted Site 7 | Tree(s) :: 17 | 4107 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1969 12:00:00 AM | Permit Number 6184 | 6002448.65163308 | 2102356.36648783 | 37.7528085336342 | -122.434426922819 | (37.7528085336342, -122.434426922819) | 2 | 4 | 5 | 28862 | 22 | |||
193448 | 63318 | Permitted Site 7 | Tree(s) :: 17 | 416 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/1987 12:00:00 AM | Permit Number 23885 | 6009423.56378257 | 2100207.92948709 | 37.7473028565921 | -122.410154631402 | (37.7473028565921, -122.410154631402) | 2 | 7 | 7 | 28859 | 2 | |||
193406 | 53495 | Permitted Site 7 | Tree(s) :: 17 | 2623 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | Permit Number 6405 | 5997607.19251822 | 2089135.57838222 | 37.7162314069443 | -122.450216607006 | (37.7162314069443, -122.450216607006) | 9 | 8 | 6 | 28861 | 24 | |||
193393 | 257908 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
193386 | 59620 | Permitted Site 7 | Tree(s) :: 17 | 1250 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1981 12:00:00 AM | Permit Number 19027 | 6009405.43377303 | 2110084.0575777 | 37.7744194420762 | -122.410914751831 | (37.7744194420762, -122.410914751831) | 8 | 2 | 9 | 28853 | 34 | |||
193379 | 107543 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | |||
193371 | 53577 | Permitted Site 7 | Tree(s) :: 17 | 111 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1970 12:00:00 AM | Permit Number 6499 | 5993935.90496102 | 2114787.85768464 | 37.786455233332 | -122.464768010941 | (37.786455233332, -122.464768010941) | 11 | 6 | 2 | 54 | 11 | |||
193367 | 54645 | Permitted Site 7 | Tree(s) :: 17 | 226 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | Permit Number 10469 | 6012457.12435292 | 2087517.55535362 | 37.7126272777184 | -122.398774261117 | (37.7126272777184, -122.398774261117) | 10 | 3 | 8 | 309 | 1 | |||
193358 | 187690 | DPW Maintained 1 | Tree(s) :: 17 | 876 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779712 | 6008536 | 2103448 | 37.7561495727301 | -122.413452882223 | (37.7561495727301, -122.413452882223) | 2 | 4 | 7 | 28859 | 19 | |
193321 | 38757 | Permitted Site 7 | Tree(s) :: 17 | 133 Shipley St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40630 | 6012231.96307802 | 2112402.8191024 | 37.780944316304 | -122.401300174029 | (37.780944316304, -122.401300174029) | 6 | 2 | 9 | 28856 | 34 | |||
193304 | 107084 | Undocumented 4 | Tree(s) :: 17 | 54 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 9x3 | Permit Number 773533 | 6005346 | 2103401 | 37.7558408924527 | -122.424481650335 | (37.7558408924527, -122.424481650335) | 2 | 4 | 5 | 28859 | 19 | ||
193270 | 116150 | Undocumented 4 | Tree(s) :: 17 | 3701 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | 8 | 4 | 5 | 28862 | 3 | |||||
193243 | 58673 | Permitted Site 7 | Tree(s) :: 17 | 3047 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1979 12:00:00 AM | Permit Number 17898 | 6002426.77097995 | 2118639.5726731 | 37.7975169191582 | -122.435667449043 | (37.7975169191582, -122.435667449043) | 13 | 9 | 1 | 57 | 17 | |||
193194 | 183442 | DPW Maintained 1 | Tree(s) :: 17 | 2444 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5989549.5958 | 2098742.2388 | 37.7421444494188 | -122.478769424176 | (37.7421444494188, -122.478769424176) | 1 | 8 | 3 | 29491 | 35 | |||
193186 | 65042 | Permitted Site 7 | Tree(s) :: 17 | 126 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1989 12:00:00 AM | Permit Number 26095 | 6001953.47349551 | 2108404.32399906 | 37.7693866343552 | -122.436572194268 | (37.7693866343552, -122.436572194268) | 15 | 5 | 5 | 29492 | 9 | |||
193167 | 96143 | DPW Maintained 1 | Tree(s) :: 17 | 1470X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016219.9 | 2096747.5 | 37.738179827823 | -122.386411945382 | (37.738179827823, -122.386411945382) | 10 | 3 | 8 | 58 | 1 | ||||
193164 | 100593 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
193147 | 55399 | Permitted Site 7 | Tree(s) :: 17 | 1457 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1972 12:00:00 AM | Permit Number 11336 | 5993329.33887881 | 2105571.36200051 | 37.7611142135138 | -122.466196535166 | (37.7611142135138, -122.466196535166) | 1 | 8 | 4 | 56 | 12 | |||
193078 | 54723 | Permitted Site 7 | Tree(s) :: 17 | 1223 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1972 12:00:00 AM | Permit Number 10566 | 5993894.6099279 | 2107160.81468116 | 37.7655110328883 | -122.464356924547 | (37.7655110328883, -122.464356924547) | 11 | 5 | 11 | 56 | 12 | |||
193053 | 109782 | Permitted Site 7 | Tree(s) :: 17 | 2790 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999719.6 | 2117793.3 | 37.7950391408052 | -122.444974077317 | (37.7950391408052, -122.444974077317) | 13 | 9 | 1 | 57 | 17 | |||||
193051 | 66758 | Permitted Site 7 | Tree(s) :: 17 | 871 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1991 12:00:00 AM | Permit Number 30011 | 5981675.71173469 | 2109818.0130109 | 37.7720950354815 | -122.506815707649 | (37.7720950354815, -122.506815707649) | 11 | 6 | 2 | 55 | 26 | |||
193044 | 58651 | Permitted Site 7 | Tree(s) :: 17 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | Permit Number 17873 | 5997221.67741456 | 2107052.01041896 | 37.7654035002744 | -122.452841555618 | (37.7654035002744, -122.452841555618) | 15 | 5 | 11 | 29492 | 12 | |||
193030 | 100615 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
193026 | 59591 | Permitted Site 7 | Tree(s) :: 17 | 1948 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | Permit Number 18988 | 6003257.88590708 | 2114521.18887394 | 37.7862560629284 | -122.432497259997 | (37.7862560629284, -122.432497259997) | 13 | 9 | 11 | 29490 | 27 | |||
192974 | 51209 | Permitted Site 7 | Tree(s) :: 17 | 111 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47578 | 6014394.74626942 | 2116530.73461445 | 37.7923990500381 | -122.394107054187 | (37.7923990500381, -122.394107054187) | 12 | 2 | 9 | 28855 | 6 | |||
192950 | 183680 | DPW Maintained 1 | Tree(s) :: 17 | 1315 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982728.5996 | 2106143.6537 | 37.7620682453033 | -122.502901690129 | (37.7620682453033, -122.502901690129) | 1 | 8 | 3 | 56 | 35 | |||
192932 | 62106 | Permitted Site 7 | Tree(s) :: 17 | 365 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 771025 | 6006789.50292325 | 2101662.047395 | 37.7511475388363 | -122.419366180864 | (37.7511475388363, -122.419366180864) | 2 | 4 | 7 | 28859 | 19 | ||
192926 | 67309 | Permitted Site 7 | Tree(s) :: 17 | 739 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1992 12:00:00 AM | Permit Number 30790 | 5990657.42987956 | 2110352.67076953 | 37.7740878755404 | -122.475786592124 | (37.7740878755404, -122.475786592124) | 11 | 6 | 2 | 55 | 26 | |||
192916 | 96224 | Undocumented 4 | Tree(s) :: 17 | 185 Chilton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6001587.1 | 2095138.7 | 37.732941575251 | -122.436889661497 | (37.732941575251, -122.436889661497) | 9 | 7 | 5 | 63 | 40 | ||||
192903 | 62701 | Permitted Site 7 | Tree(s) :: 17 | 2233 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1986 12:00:00 AM | Permit Number 23041 | 6007540.4 | 2120108.6 | 37.8018396242478 | -122.418077092851 | (37.8018396242478, -122.418077092851) | 5 | 1 | 1 | 28858 | 32 | |||
192895 | 37194 | DPW Maintained 1 | Tree(s) :: 17 | 1730 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 4 | Permit Number 39761 | 5986910.8577 | 2103468.9464 | 37.7549691463418 | -122.488240502595 | (37.7549691463418, -122.488240502595) | 1 | 8 | 3 | 56 | 35 | |
192894 | 106283 | Permitted Site 7 | Tree(s) :: 17 | 98 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 772597 | 6005778.8 | 2103496.8 | 37.7561283684884 | -122.422991694326 | (37.7561283684884, -122.422991694326) | 2 | 4 | 5 | 28859 | 19 | |||
192861 | 49261 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
192830 | 54032 | Permitted Site 7 | Tree(s) :: 17 | 66 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1972 12:00:00 AM | Permit Number 9753 | 5998878.1050637 | 2100036.15651635 | 37.7462344787497 | -122.446607558642 | (37.7462344787497, -122.446607558642) | 2 | 7 | 5 | 63 | 22 | |||
192829 | 64479 | Permitted Site 7 | Tree(s) :: 17 | 1135 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1988 12:00:00 AM | Permit Number 25352 | 6017346.79859016 | 2093380.57453278 | 37.7289972322989 | -122.382281478103 | (37.7289972322989, -122.382281478103) | 10 | 3 | 8 | 58 | 1 | |||
192821 | 106675 | Permitted Site 7 | Tree(s) :: 17 | 890 Shotwell St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2014 12:00:00 AM | Permit Number 772825 | 6007942.2 | 2102747.9 | 37.7541938987735 | -122.41545688704 | (37.7541938987735, -122.41545688704) | 2 | 4 | 7 | 28859 | 19 | ||||
192816 | 18520 | Permitted Site 7 | Tree(s) :: 17 | 1711 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773876 | 6009572.06002 | 2119547.78845 | 37.800413913902 | -122.411006939511 | (37.800413913902, -122.411006939511) | 3 | 1 | 10 | 308 | 4 | |
192809 | 33899 | Permitted Site 7 | Tree(s) :: 17 | 1325 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1997 12:00:00 AM | Permit Number 37873 | 6005861.22115721 | 2101251.17549659 | 37.7499670527707 | -122.422547089097 | (37.7499670527707, -122.422547089097) | 2 | 4 | 5 | 28859 | 19 | |||
192806 | 57458 | Permitted Site 7 | Tree(s) :: 17 | 530 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/1990 12:00:00 AM | Permit Number 29297 | 6000138.78606419 | 2095380.13429741 | 37.7335220745281 | -122.441914165902 | (37.7335220745281, -122.441914165902) | 9 | 7 | 5 | 63 | 40 | |||
192792 | 67464 | Permitted Site 7 | Tree(s) :: 17 | 25 McLea Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1992 12:00:00 AM | Permit Number 30975 | 6010100.70437024 | 2109236.59738013 | 37.7721314748941 | -122.408449878297 | (37.7721314748941, -122.408449878297) | 14 | 2 | 9 | 28853 | 34 | |||
192780 | 39539 | Permitted Site 7 | Tree(s) :: 17 | 1700 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 769956 | 6012296.15591625 | 2106582.61675328 | 37.764966945494 | -122.40066910779 | (37.764966945494, -122.40066910779) | 14 | 3 | 8 | 28856 | 20 | ||
192770 | 60412 | Permitted Site 7 | Tree(s) :: 17 | 1450 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | Permit Number 19993 | 6016065.79409578 | 2094051.12037844 | 37.7307675796769 | -122.38675679006 | (37.7307675796769, -122.38675679006) | 10 | 3 | 8 | 58 | 1 | |||
192769 | 59567 | Permitted Site 7 | Tree(s) :: 17 | 608 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2014 12:00:00 AM | Permit Number 772960 | 6007418.57761455 | 2096180.65339733 | 37.7361322649602 | -122.416802473046 | (37.7361322649602, -122.416802473046) | 2 | 7 | 7 | 28859 | 2 | ||
192756 | 94447 | Significant Tree 6 | Tree(s) :: 17 | 1103 Gough St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/06/2010 12:00:00 AM | 3x3 | Permit Number 53668 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | 7 | 9 | 11 | 28858 | 41 | ||
192750 | 57107 | Permitted Site 7 | Tree(s) :: 17 | 205 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | Permit Number 14377 | 6004796 | 2102401 | 37.7530640514382 | -122.426312535113 | (37.7530640514382, -122.426312535113) | 2 | 4 | 5 | 28862 | 22 | |||
192738 | 53956 | Permitted Site 7 | Tree(s) :: 17 | 190 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1972 12:00:00 AM | Permit Number 9671 | 6009508.96553833 | 2095063.67854365 | 37.7331826476158 | -122.409496312348 | (37.7331826476158, -122.409496312348) | 10 | 3 | 7 | 309 | 28 | |||
192721 | 51603 | Permitted Site 7 | Tree(s) :: 17 | 695 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47897 | 6001209.07232262 | 2089632.02688618 | 37.7178000113756 | -122.437802336098 | (37.7178000113756, -122.437802336098) | 9 | 7 | 6 | 28861 | 5 | |||
192709 | 58560 | Permitted Site 7 | Tree(s) :: 17 | 449 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1979 12:00:00 AM | Permit Number 17749 | 5997633.49327598 | 2107442.54002485 | 37.766499385175 | -122.451445356574 | (37.766499385175, -122.451445356574) | 15 | 5 | 11 | 29492 | 9 | |||
192656 | 30884 | Permitted Site 7 | Tree(s) :: 17 | 349 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34716 | 6003360.10916992 | 2104453.79206106 | 37.7586192616734 | -122.431424653099 | (37.7586192616734, -122.431424653099) | 2 | 4 | 5 | 28862 | 3 | |||
192655 | 50731 | Permitted Site 7 | Tree(s) :: 17 | 536 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | Permit Number 47281 | 5999178.13094439 | 2114844.77796308 | 37.7869123595924 | -122.446635388579 | (37.7869123595924, -122.446635388579) | 15 | 6 | 1 | 29490 | 31 | |||
192649 | 57143 | Permitted Site 7 | Tree(s) :: 17 | 538 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | Permit Number 14418 | 6001484.14131278 | 2090657.2756981 | 37.7206307521658 | -122.436924903548 | (37.7206307521658, -122.436924903548) | 9 | 7 | 6 | 28861 | 5 | |||
192635 | 58684 | Permitted Site 7 | Tree(s) :: 17 | 124 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1979 12:00:00 AM | Permit Number 17912 | 6000660.21752032 | 2087780.09105919 | 37.7126837858301 | -122.439566791149 | (37.7126837858301, -122.439566791149) | 9 | 7 | 6 | 28861 | 5 | |||
192626 | 32250 | Permitted Site 7 | Tree(s) :: 17 | 1601 Mission St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/1995 12:00:00 AM | Permit Number 35559 | 6007188.44453353 | 2109602.50556833 | 37.7729726509951 | -122.41854960025 | (37.7729726509951, -122.41854960025) | 8 | 2 | 9 | 28853 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );