trees

11,761 rows where qSpecies_id = 17 sorted by SiteOrder descending

✎ View and edit SQL

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)
4397 44679 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
7996 45026 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
11315 48289 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
13496 45859 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1008 48288 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
10442 45860 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
12840 45025 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
16497 44678 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
10915 48287 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
13485 45024 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
13500 45861 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
18065 44701 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
5544 48286 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
15686 45023 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
18086 45862 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
19213 44683 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2775 45022 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
9780 45872 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
11907 48285 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
19195 44685 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
4748 45021 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
10300 48270 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
10839 44710 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
13968 45864 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
514 45011 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3563 44709 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
14612 48283 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
18690 45856 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4171 48297 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
12587 45866 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
15096 45020 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
17050 44708 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2632 48281 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
10879 44707 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
16425 45867 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
16835 45029 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
8605 48280 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
8878 45868 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
9779 44706 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
11495 45018 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
139 106382 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 9 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
542 35050 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
2764 262058 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 9 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
5954 48227 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
7589 45884 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
7609 34915 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
10047 53124 Permitted Site 7 Tree(s) :: 17 601@ NOE ST Duboce Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2006 12:00:00 AM     Permit Number 49066 6002808.44176413 2108284.12633652 37.7691051487822 -122.433606309272 (37.7691051487822, -122.433606309272) 15 5 5 28862 3
11015 44836 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
12172 44551 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
13868 212497 DPW Maintained 1 Tree(s) :: 17 51 Sotelo Ave 9 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft Permit Number 784592 5993879 2101255 37.7492942917049 -122.463982175947 (37.7492942917049, -122.463982175947) 1 8 4 29491 40
14631 36650 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
17054 45804 Permitted Site 7 Tree(s) :: 17 880 Clipper Ter 9 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2001 12:00:00 AM     Permit Number 44433 5999675.79411068 2100284.35240189 37.7469614974882 -122.443867085897 (37.7469614974882, -122.443867085897) 2 4 5 63 22
18426 48475 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
20829 93919 Permitted Site 7 Tree(s) :: 17 280 Portola Dr 9 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2010 12:00:00 AM   3x3 Permit Number 53386 5999488 2100471 37.7474632730192 -122.444529871348 (37.7474632730192, -122.444529871348) 2 5 5 63 38
26537 102408 Undocumented 4 Tree(s) :: 17 95X Harriet St 9 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010704.6 2111649.2 37.7787897224959 -122.406530981243 (37.7787897224959, -122.406530981243) 14 2 9 28853 34
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
32053 100346 Permitted Site 7 Tree(s) :: 17 1190 Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2012 12:00:00 AM   3x3 Permit Number 767726 6008690.2 2111553.5 37.7784140515871 -122.413492835489 (37.7784140515871, -122.413492835489) 8 2 9 28853 34
32578 188751 DPW Maintained 1 Tree(s) :: 17 150 Executive Park Blvd 9 Sidewalk: Curb side : Cutout Tree Private 2   11/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780488 6014156.58166 2086969.04913 37.7112157302901 -122.392862006193 (37.7112157302901, -122.392862006193) 10 3 8 58 1
32800 117172 Undocumented 4 Tree(s) :: 17 299x ALMA ST 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
35030 51171 Permitted Site 7 Tree(s) :: 17 2550& VICENTE 24th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2004 12:00:00 AM     Permit Number 47565 5988957.29016327 2097975.36056036 37.7400043920325 -122.480761277613 (37.7400043920325, -122.480761277613) 1 8 3 29491 35
38316 107558 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
39248 100138 Undocumented 4 Tree(s) :: 17 155 05th St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769024 6011029.6 2112857.4 37.7821253339557 -122.405491786923 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
39604 116148 Undocumented 4 Tree(s) :: 17 3800X 20th St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6004661.9257 2104258.88373 37.7581577845713 -122.426908497787 (37.7581577845713, -122.426908497787) 2 4 5 28862 3
42477 100616 Permitted Site 7 Tree(s) :: 17 401X Clementina St 9 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
50658 9541 DPW Maintained 1 Tree(s) :: 17 1100X Golden Gate Ave 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5   01/02/2014 12:00:00 AM 3 3X3 Permit Number 771276 6003998.856 2112198.1457 37.7799195567604 -122.429767943463 (37.7799195567604, -122.429767943463) 7 9 11 29490 41
55912 40105 Permitted Site 7 Tree(s) :: 17 181 03rd St 9 Sidewalk: Curb side : Cutout Tree Private 2   03/26/1999 12:00:00 AM     Permit Number 41329 6012438.29389482 2113988.56342743 37.7853099112578 -122.40069780277 (37.7853099112578, -122.40069780277) 12 2 9 28855 6
64104 49278 Permitted Site 7 Tree(s) :: 17 1X Main St 9 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
66836 46213 Permitted Site 7 Tree(s) :: 17 1888 Lombard St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2002 12:00:00 AM     Permit Number 44530 6003335.27744655 2119677.01043482 37.8004170150887 -122.432597920925 (37.8004170150887, -122.432597920925) 13 9 1 57 17
67595 124740 DPW Maintained 1 Tree(s) :: 17 999 Brannan St 9 Sidewalk: Curb side : Cutout Tree Private 2           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328) 14 2 9 28853 34
70050 100639 Permitted Site 7 Tree(s) :: 17 401X Clementina St 9 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
80152 51206 Permitted Site 7 Tree(s) :: 17 111 Mission St 9 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
80911 106072 Permitted Site 7 Tree(s) :: 17 2500 Arelious Walker Dr 9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772788 6016510.6 2089868.7 37.7193080887588 -122.384927739753 (37.7193080887588, -122.384927739753) 10 3 8 58 1
87353 84871 Permitted Site 7 Tree(s) :: 17 1800 Van Ness Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2007 12:00:00 AM     Permit No. 49260 6006192 2116736.3 37.7925041547793 -122.422503429039 (37.7925041547793, -122.422503429039) 13 9 10 28858 32
87807 113732 Significant Tree 6 Tree(s) :: 17 1580 Valencia St 9 Front Yard : Yard Tree Private 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
91967 52676 DPW Maintained 1 Tree(s) :: 17 3535 REVISED Balboa St 9 Sidewalk: Curb side : Cutout Tree Private 2   04/26/2006 12:00:00 AM     Permit Number 48754 5984646.54140382 2111058.397504 37.7756752724431 -122.496631075141 (37.7756752724431, -122.496631075141) 11 6 2 55 26
92535 107891 Permitted Site 7 Tree(s) :: 17 941 Washington St 9 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
93709 52752 Permitted Site 7 Tree(s) :: 17 888 Howard St 9 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2006 12:00:00 AM 3 3x3 Permit Number 48794 6011250.93887813 2112724.08658297 37.7817716600744 -122.404716662237 (37.7817716600744, -122.404716662237) 12 2 9 28853 34
95075 101547 Permitted Site 7 Tree(s) :: 17 1X Main St 9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
97644 84763 Permitted Site 7 Tree(s) :: 17 185 Berry St 9 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
97790 93895 Permitted Site 7 Tree(s) :: 17 425 Folsom St 9 Sidewalk: Curb side : Pot Tree Private 2       3x3   6014407 2114805 37.787661263759 -122.393943797302 (37.787661263759, -122.393943797302) 6 2 9 28855 6
98264 107548 DPW Maintained 1 Tree(s) :: 17 198X Jennings St 9 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
98319 44292 Permitted Site 7 Tree(s) :: 17 3100 Cesar Chavez St 9 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2001 12:00:00 AM     Permit Number 43707 6009038.4659618 2100609.39227768 37.7483835914924 -122.411514635828 (37.7483835914924, -122.411514635828) 2 4 7 28859 19
99360 99687 DPW Maintained 1 Tree(s) :: 17 165 Grattan St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
101620 97514 Permitted Site 7 Tree(s) :: 17 20X 10th St 9 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2011 12:00:00 AM   3x3 Permit Number 768079 6007672 2110712 37.7760462700595 -122.416955543158 (37.7760462700595, -122.416955543158) 8 2 9 28853 34
104369 242819 DPW Maintained 1 Tree(s) :: 17 173 Addison St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002620.3556 2097408.25534 37.7392319251012 -122.433479564443 (37.7392319251012, -122.433479564443) 2 7 5 63 7
105938 40902 Permitted Site 7 Tree(s) :: 17 720 Howard St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/23/1999 12:00:00 AM     Permit Number 41793 6012338.0511994 2113764.09224404 37.7846879743619 -122.401028836502 (37.7846879743619, -122.401028836502) 12 2 9 28853 6
108209 99567 Undocumented 4 Tree(s) :: 17 650X Brunswick St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
110912 45613 Permitted Site 7 Tree(s) :: 17 1100 Fillmore St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2001 12:00:00 AM     Permit Number 44335 6003389.50485138 2112095.5826587 37.7796034198271 -122.431868633724 (37.7796034198271, -122.431868633724) 15 9 11 29490 41
115283 173742 DPW Maintained 1 Tree(s) :: 17 2500X Lyon St 9 Median : Yard Tree Private 2   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
120994 48526 Permitted Site 7 Tree(s) :: 17 1(REVISED) Church St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.429132262601 (37.7703294028669, -122.429132262601) 7 9 5 29492 10
124007 89337 Permitted Site 7 Tree(s) :: 17 3575 Geary Blvd 9 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2008 12:00:00 AM   3x3 Permit Number 51928 5995866 2112798.7 37.7811046257834 -122.457946406003 (37.7811046257834, -122.457946406003) 11 6 2 54 16
124304 92740 Permitted Site 7 Tree(s) :: 17 1150 Pierce St 9 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2009 12:00:00 AM   3x3 Permit Number 52926 6002360 2112465 37.7805593321564 -122.43545656304 (37.7805593321564, -122.43545656304) 15 5 11 29490 41
127251 173824 DPW Maintained 1 Tree(s) :: 17 1200 04th St 9 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021 2109379 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666) 14 3 9 310 20
127741 93588 Permitted Site 7 Tree(s) :: 17 15 West Point Rd 9 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
132288 97076 DPW Maintained 1 Tree(s) :: 17 1551 Newcomb Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 4x4   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
135167 34031 Permitted Site 7 Tree(s) :: 17 2730 16th St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37954 6008501.61322181 2106845.55424255 37.7654765469809 -122.413812123028 (37.7654765469809, -122.413812123028) 8 4 7 28853 19
135338 39784 Permitted Site 7 Tree(s) :: 17 50 San Jose Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   01/19/1999 12:00:00 AM     Permit Number 41142 6006177.81610853 2102875.29261487 37.7544443606741 -122.421567620452 (37.7544443606741, -122.421567620452) 2 4 5 28859 19
140962 93083 Permitted Site 7 Tree(s) :: 17 1230 Twin Peaks Blvd 9 Sidewalk: Property side : Yard Tree Private 2   02/01/2010 12:00:00 AM     Permit Number 53156 5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748) 2 5 4 63 38
142915 100594 Permitted Site 7 Tree(s) :: 17 401x Clementina St 9 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
154093 101723 Permitted Site 7 Tree(s) :: 17 560 Wisconsin St 9 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2012 12:00:00 AM     Permit Number 769391 6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);