trees
11,761 rows where qSpecies_id = 17 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130549 | 88570 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 61 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
137939 | 31646 | Permitted Site 7 | Tree(s) :: 17 | 4500 Ulloa St | 2 | Front Yard : Cutout | Tree | Private 2 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | 1 | 8 | 3 | 29491 | 35 | ||
141035 | 88568 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 59 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
145466 | 88567 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 39 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
156782 | 12711 | Significant Tree 6 | Tree(s) :: 17 | 1449 Lake St | 3 | Front Yard : Cutout | Tree | DPW 1 | 06/01/2000 12:00:00 AM | 3 | 5990998.3321714 | 2114735.5234974 | 37.7861417388427 | -122.474927352046 | (37.7861417388427, -122.474927352046) | 11 | 6 | 2 | 54 | 26 | |||
160669 | 115566 | DPW Maintained 1 | Tree(s) :: 17 | 2026 36TH AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777529 | 5985134 | 2101392 | 37.7491625951009 | -122.494232212151 | (37.7491625951009, -122.494232212151) | 1 | 8 | 3 | 29491 | 35 | |
162713 | 96182 | DPW Maintained 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout | Landscaping | Private 2 | 04/04/2011 12:00:00 AM | Permit Number 767813 | 6007366 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | 8 | 4 | 7 | 28853 | 19 | ||||
166780 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338 | 2118225 | 37.7962597494046 | -122.442865342513 | (37.7962597494046, -122.442865342513) | 13 | 9 | 1 | 57 | 17 | |
172048 | 110788 | Section 143 10 | Tree(s) :: 17 | 850x SANCHEZ ST | 2 | Front Yard : Cutout | Tree | Private 2 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717 | 2103349 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | 2 | 4 | 5 | 28862 | 22 | |
177345 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout | Tree | Private 2 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497 | 2117826 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | 13 | 9 | 1 | 29490 | 27 | |
188643 | 122687 | Significant Tree 6 | Tree(s) :: 17 | 1462 Funston Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 01/04/2017 12:00:00 AM | 3 | 3x8 | Permit Number 779171 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | 1 | 8 | 4 | 56 | 12 | |
29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
115 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000333 | 2099683 | 37.7453477932295 | -122.441551386161 | (37.7453477932295, -122.441551386161) | 2 | 7 | 5 | 63 | 22 | ||||
180 | 110904 | Significant Tree 6 | Tree(s) :: 17 | 203 CORBETT AVE | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6000094 | 2105620 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | 15 | 5 | 5 | 28862 | 3 | |||
273 | 117070 | Private 9 | Tree(s) :: 17 | 6 JOY ST | 3 | Front Yard : Yard | Tree | Private 2 | 6010444 | 2098901 | 37.7437714571602 | -122.406533939617 | (37.7437714571602, -122.406533939617) | 2 | 7 | 7 | 28859 | 2 | |||||
419 | 78519 | Significant Tree 6 | Tree(s) :: 17 | 12 Sumner St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 3x3 | 6009421 | 2110873 | 37.7765865656959 | -122.410916638665 | (37.7765865656959, -122.410916638665) | 8 | 2 | 9 | 28853 | 34 | |||
2201 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | ||
2478 | 110785 | Permitted Site 7 | Tree(s) :: 17 | 2 Edna St | 2 | Front Yard : Yard | Tree | Private 2 | 05/06/2015 12:00:00 AM | 3 | 5998788.4 | 2092979.9 | 37.7268545527586 | -122.446410203741 | (37.7268545527586, -122.446410203741) | 9 | 7 | 4 | 28861 | 40 | |||
3313 | 262482 | Significant Tree 6 | Tree(s) :: 17 | 45 Delta St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010254 | 2089941 | 37.7191585615903 | -122.406559656354 | (37.7191585615903, -122.406559656354) | 10 | 7 | 8 | 309 | 39 | ||||
3436 | 103654 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
3669 | 103667 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
4535 | 106245 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 566 De Haro St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Permit Number 770844 | 6012026 | 2105714 | 37.7625668468002 | -122.401542461625 | (37.7625668468002, -122.401542461625) | 8 | 3 | 8 | 28856 | 29 | |||
4934 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
5702 | 121171 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 2 | 7 | 5 | 63 | 7 | ||||
6238 | 103666 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
6834 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
7411 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
8218 | 100711 | Significant Tree 6 | Tree(s) :: 17 | 966-968 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | 09/27/2012 12:00:00 AM | 14 | Permit Number 769148 | 6005605.8 | 2103343.5 | 37.7556976788024 | -122.423579088745 | (37.7556976788024, -122.423579088745) | 2 | 4 | 5 | 28859 | 19 | ||
8509 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
9495 | 261033 | Significant Tree 6 | Tree(s) :: 17 | 551 Los Palmos Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784596 | 5996615 | 2095626 | 37.7339957349096 | -122.454114584985 | (37.7339957349096, -122.454114584985) | 9 | 7 | 4 | 59 | 40 | |
9889 | 116075 | Significant Tree 6 | Tree(s) :: 17 | 88 MONTCALM ST | 1 | Front Yard : Yard | Tree | Private 2 | 6010492 | 2099980 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | 2 | 7 | 7 | 28859 | 2 | |||||
10379 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard | Tree | Private 2 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177 | 2107098 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | 15 | 5 | 5 | 29492 | 3 | |||
10910 | 120918 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 2 | Front Yard : Yard | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305 | 2100249 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | 2 | 7 | 7 | 28859 | 2 | |
10947 | 94850 | Significant Tree 6 | Tree(s) :: 17 | 1107 Bowdoin St | 1 | Front Yard : Yard | Tree | Private 2 | 11/17/2010 12:00:00 AM | Permit Number 53929 | 6009593 | 2091048 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | 10 | 3 | 7 | 309 | 28 | |||
12225 | 102131 | Significant Tree 6 | Tree(s) :: 17 | 850 Treat Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/24/2012 12:00:00 AM | Permit Number 769452 | 6008548.2 | 2103592.2 | 37.7565461982029 | -122.413420887965 | (37.7565461982029, -122.413420887965) | 2 | 4 | 7 | 28859 | 19 | |||
12923 | 237906 | Significant Tree 6 | Tree(s) :: 17 | 3937 21st St | 3 | Front Yard : Yard | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785171 | 6002245.41508 | 2103514.00804 | 37.7559756019151 | -122.43521254633 | (37.7559756019151, -122.43521254633) | 2 | 4 | 5 | 28862 | 22 | |
14456 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
14665 | 256768 | DPW Maintained 1 | Tree(s) :: 17 | 900 Brotherhood Way | 7 | Front Yard : Yard | Tree | DPW 1 | 09/25/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782397 | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | |
15258 | 103665 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
15509 | 258701 | Significant Tree 6 | Tree(s) :: 17 | 206 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783089 | 5996625 | 2105876 | 37.7621402663071 | -122.454820337862 | (37.7621402663071, -122.454820337862) | 15 | 5 | 11 | 29492 | 12 | |
15657 | 259657 | Significant Tree 6 | Tree(s) :: 17 | 132 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995545 | 2087474 | 37.7115508726991 | -122.457224363425 | (37.7115508726991, -122.457224363425) | 9 | 8 | 6 | 28861 | 24 | ||||
16355 | 103663 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
17429 | 103965 | Significant Tree 6 | Tree(s) :: 17 | 141 Marview Way | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2013 12:00:00 AM | Permit Number 770303 | 5998318.6 | 2103174 | 37.7548182509721 | -122.448768222318 | (37.7548182509721, -122.448768222318) | 1 | 5 | 4 | 63 | 38 | |||
17986 | 93585 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 6 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
18064 | 103664 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
18674 | 103662 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
18988 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
20184 | 108109 | Significant Tree 6 | Tree(s) :: 17 | 952 CAPP ST | 1 | Front Yard : Yard | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774355 | 6007364.7 | 2101732.3 | 37.7513728159016 | -122.417382061559 | (37.7513728159016, -122.417382061559) | 2 | 4 | 7 | 28859 | 19 | |
20207 | 105239 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 6 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
20461 | 104283 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 5 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
20715 | 99276 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 2 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
21010 | 258626 | Undocumented 4 | Tree(s) :: 17 | 43 Carver St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009465 | 2098515 | 37.7426567664404 | -122.40989186085 | (37.7426567664404, -122.40989186085) | 10 | 7 | 7 | 28859 | 2 | ||||
25337 | 106567 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 1 | Front Yard : Yard | Tree | Private 2 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.7434933850228 | -122.383634554004 | (37.7434933850228, -122.383634554004) | 10 | 3 | 8 | 58 | 1 | |||
25451 | 105226 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | 7 | 9 | 11 | 29490 | 41 | |||
25518 | 252857 | DPW Maintained 1 | Tree(s) :: 17 | 124 Persia Ave | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 780172 | 6002102 | 2091308 | 37.7224525933916 | -122.43483567372 | (37.7224525933916, -122.43483567372) | 9 | 7 | 6 | 28861 | 5 | |||
27545 | 115090 | Significant Tree 6 | Tree(s) :: 17 | 121 Topaz Way | 1 | Front Yard : Yard | Tree | Private 2 | 01/11/2016 12:00:00 AM | Permit Number 776934 | 6001846.4 | 2098050 | 37.7409500647868 | -122.436201464472 | (37.7409500647868, -122.436201464472) | 2 | 7 | 5 | 63 | 7 | |||
27763 | 105240 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 10 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
28531 | 173636 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
29114 | 103653 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
29712 | 253406 | DPW Maintained 1 | Tree(s) :: 17 | 1555 Evans Ave | 9 | Front Yard : Yard | Tree | Private 2 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916 | 2098279 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | 10 | 3 | 8 | 58 | 1 | |
30075 | 100070 | Property Tree 8 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 777990 | 5990400 | 2090718 | 37.7201612636948 | -122.475243338807 | (37.7201612636948, -122.475243338807) | 1 | 8 | 4 | 64 | 40 | ||||
30460 | 104285 | Significant Tree 6 | Tree(s) :: 17 | 71X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
32197 | 93580 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
32209 | 93594 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 15 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
32555 | 121168 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 2 | 7 | 5 | 63 | 7 | ||||
32725 | 106972 | Significant Tree 6 | Tree(s) :: 17 | 464 46TH AVE | 3 | Front Yard : Yard | Tree | Private 2 | 08/07/2014 12:00:00 AM | Permit Number 773827 | 5981646.2 | 2112608 | 37.7797537818913 | -122.507124798545 | (37.7797537818913, -122.507124798545) | 11 | 6 | 2 | 55 | 26 | |||
34585 | 104280 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 2 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
34663 | 103470 | Undocumented 4 | Tree(s) :: 17 | 1190X Vermont St | 1 | Front Yard : Yard | Tree | Private 2 | 05/03/2013 12:00:00 AM | 24 | Permit Number 770173 | 6011370.8 | 2102820.9 | 37.7545864559266 | -122.403605009348 | (37.7545864559266, -122.403605009348) | 10 | 4 | 8 | 28859 | 19 | ||
35186 | 100579 | Significant Tree 6 | Tree(s) :: 17 | 35 Lloyd St | 2 | Front Yard : Yard | Tree | Private 2 | 6002279.7 | 2108550 | 37.7698051576272 | -122.435454215606 | (37.7698051576272, -122.435454215606) | 15 | 5 | 5 | 29492 | 9 | |||||
35919 | 93595 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 16 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
35924 | 89310 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399 | 2109002 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | 15 | 5 | 11 | 29492 | 9 | |
36007 | 107047 | Significant Tree 6 | Tree(s) :: 17 | 1933 15TH ST | Front Yard : Yard | Tree | Private 2 | 6004592.7 | 2107127.1 | 37.7660293092823 | -122.427352228532 | (37.7660293092823, -122.427352228532) | 8 | 4 | 5 | 28862 | 3 | ||||||
36574 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
37718 | 110162 | Undocumented 4 | Tree(s) :: 17 | 123x GARCES DR | 2 | Front Yard : Yard | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 777996 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||
37736 | 101041 | Significant Tree 6 | Tree(s) :: 17 | 3750 18th St | 1 | Front Yard : Yard | Tree | SFUSD 4 | 03/15/2012 12:00:00 AM | 30 | Permit Number 769376 | 6005230 | 2105481 | 37.7615455321967 | -122.425030802687 | (37.7615455321967, -122.425030802687) | 8 | 4 | 5 | 28859 | 19 | ||
38032 | 110839 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6000252 | 2111948 | 37.7790198360362 | -122.442711981138 | (37.7790198360362, -122.442711981138) | 15 | 5 | 11 | 29490 | 16 | ||||
38818 | 105964 | Significant Tree 6 | Tree(s) :: 17 | 360 MISSOURI ST | 1 | Front Yard : Yard | Tree | Private 2 | 6013401.8 | 2105413.2 | 37.7618175880082 | -122.396762946114 | (37.7618175880082, -122.396762946114) | 10 | 3 | 8 | 28856 | 29 | |||||
40220 | 107562 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
42517 | 93597 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 18 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
43379 | 93610 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 31 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
43892 | 99623 | Significant Tree 6 | Tree(s) :: 17 | 380 Connecticut St | 1 | Front Yard : Yard | Tree | Private 2 | 05/23/2012 12:00:00 AM | Permit Number 768850 | 6013171.4 | 2105301.7 | 37.7614986071193 | -122.397551993257 | (37.7614986071193, -122.397551993257) | 10 | 3 | 8 | 28856 | 29 | |||
44736 | 93606 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 27 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
45319 | 113360 | Permitted Site 7 | Tree(s) :: 17 | 821 HEAD ST | 1 | Front Yard : Yard | Tree | Private 2 | 10/08/2015 12:00:00 AM | 25 | 3x3 | Permit Number 776477 | 5993783 | 2091497 | 37.7224957130636 | -122.463606040268 | (37.7224957130636, -122.463606040268) | 9 | 8 | 4 | 59 | 40 | |
45348 | 93222 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788 | 2100441 | 37.7470540096767 | -122.464237765204 | (37.7470540096767, -122.464237765204) | 1 | 8 | 4 | 29491 | 40 | |||
46702 | 107564 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 8 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
46883 | 106970 | Undocumented 4 | Tree(s) :: 17 | 30 Piedmont St | Front Yard : Yard | Tree | Private 2 | 07/11/2014 12:00:00 AM | Permit Number 772781 | 5999571.08265 | 2107127.27884 | 37.7657445183673 | -122.444720943629 | (37.7657445183673, -122.444720943629) | 15 | 5 | 5 | 29492 | 9 | ||||
46944 | 102226 | Undocumented 4 | Tree(s) :: 17 | 3088 Market St | 1 | Front Yard : Yard | Tree | Private 2 | 01/28/2013 12:00:00 AM | 60 | Permit Number 769557 | 5999953.3 | 2105403.7 | 37.7610338030554 | -122.443275133554 | (37.7610338030554, -122.443275133554) | 15 | 5 | 5 | 28862 | 3 | ||
47226 | 94411 | Permitted Site 7 | Tree(s) :: 17 | 905 California St | 1 | Front Yard : Yard | Tree | Private 2 | 07/27/2010 12:00:00 AM | 9 | Permit Number 53651 | 6010018 | 2116471 | 37.7919908000075 | -122.409246561226 | (37.7919908000075, -122.409246561226) | 5 | 1 | 10 | 28857 | 21 | ||
47902 | 92013 | Permitted Site 7 | Tree(s) :: 17 | 360 04th St | 7 | Front Yard : Yard | Tree | Private 2 | 06/02/2009 12:00:00 AM | Permit Number 52163 | 6012527 | 2112512 | 37.7812605579477 | -122.400287160132 | (37.7812605579477, -122.400287160132) | 6 | 2 | 9 | 28856 | 34 | |||
48640 | 104279 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
49406 | 106153 | Undocumented 4 | Tree(s) :: 17 | 735 TERESITA BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 07/25/2014 12:00:00 AM | 40 | Permit Number 772792 | 5998960.9 | 2095994 | 37.7351404140963 | -122.446030577249 | (37.7351404140963, -122.446030577249) | 9 | 7 | 4 | 63 | 40 | ||
49649 | 105844 | Significant Tree 6 | Tree(s) :: 17 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 03/03/2014 12:00:00 AM | Permit Number 771052 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 | ||||
49914 | 93587 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 8 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
51060 | 106568 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 5 | Front Yard : Yard | Tree | Private 2 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.7434933850228 | -122.383634554004 | (37.7434933850228, -122.383634554004) | 10 | 3 | 8 | 58 | 1 | |||
51128 | 93601 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 22 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
52128 | 112811 | Significant Tree 6 | Tree(s) :: 17 | 2023 43rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5982877.4 | 2101339.2 | 37.7488853101021 | -122.502031530859 | (37.7488853101021, -122.502031530859) | 1 | 8 | 3 | 29491 | 35 | |||||
52336 | 253398 | DPW Maintained 1 | Tree(s) :: 17 | 1555 Evans Ave | 1 | Front Yard : Yard | Tree | Private 2 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916 | 2098279 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | 10 | 3 | 8 | 58 | 1 | |
52993 | 107410 | Undocumented 4 | Tree(s) :: 17 | 195 VILLA TER | 1 | Front Yard : Yard | Tree | Private 2 | 5999179.7 | 2104111.6 | 37.7574418733594 | -122.445857739815 | (37.7574418733594, -122.445857739815) | 2 | 5 | 5 | 28862 | 3 | |||||
54038 | 104639 | Permitted Site 7 | Tree(s) :: 17 | 217 Montcalm St | 3 | Front Yard : Yard | Tree | Private 2 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 |
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) );