190 rows where Zip Codes = 28859 and qSpecies_id = 53 sorted by qAddress

View and edit SQL

Zip Codes

  • 28859 · 90
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)
159897 617 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3141X 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6008071.59955 2102085.94599 37.7523835952977 -122.414962541065 (37.7523835952977, -122.414962541065) 2 4 7 28859 19
21841 111225 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 8 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
56413 111223 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
61037 111219 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
110191 111226 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
135014 111218 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
142406 111224 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
188189 111222 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
121432 624 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3157 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6007970.52254 2102065.21548 37.752320993709 -122.415310615518 (37.752320993709, -122.415310615518) 2 4 7 28859 19
79982 628 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3166 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     21 3x3   6007874.17365 2102144.23632 37.7525325514911 -122.41564940087 (37.7525325514911, -122.41564940087) 2 4 7 28859 19
161467 632 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3179 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007841.79281 2102038.51474 37.7522404437102 -122.415753894425 (37.7522404437102, -122.415753894425) 2 4 7 28859 19
179971 634 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3194 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 3X3   6007781.42285 2102140.57786 37.7525172919755 -122.415969890792 (37.7525172919755, -122.415969890792) 2 4 7 28859 19
85308 631 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3195 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007841.79281 2102038.51474 37.7522404437102 -122.415753894425 (37.7522404437102, -122.415753894425) 2 4 7 28859 19
138766 635 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3198 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6007763.62302 2102126.97717 37.7524789468036 -122.416030482711 (37.7524789468036, -122.416030482711) 2 4 7 28859 19
20430 647 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3244X 24th St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007408.30918 2102098.45375 37.7523806444342 -122.417257199664 (37.7523806444342, -122.417257199664) 2 4 7 28859 19
37666 646 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3244X 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007408.30918 2102098.45375 37.7523806444342 -122.417257199664 (37.7523806444342, -122.417257199664) 2 4 7 28859 19
79861 649 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3244X 24th St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007408.30918 2102098.45375 37.7523806444342 -122.417257199664 (37.7523806444342, -122.417257199664) 2 4 7 28859 19
86183 645 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3244X 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007408.30918 2102098.45375 37.7523806444342 -122.417257199664 (37.7523806444342, -122.417257199664) 2 4 7 28859 19
119249 648 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3244X 24th St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007408.30918 2102098.45375 37.7523806444342 -122.417257199664 (37.7523806444342, -122.417257199664) 2 4 7 28859 19
99827 109850 Undocumented 4 Ficus nitida :: Laurel Fig 53 3250x 22ND ST 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6006518 2103190 37.7553276504831 -122.420413510616 (37.7553276504831, -122.420413510616) 2 4 7 28859 19
156055 653 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3255X 24th St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     3 4x4   6007260.4251 2102038.7621 37.7522084236972 -122.417764377532 (37.7522084236972, -122.417764377532) 2 4 7 28859 19
73104 5386 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 325X Dolores St 4 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
93022 5387 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 325X Dolores St 5 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
43367 116602 Undocumented 4 Ficus nitida :: Laurel Fig 53 3260x 16TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 9x9   6005124 2106632 37.764699916645 -122.425479329399 (37.764699916645, -122.425479329399) 8 4 5 28859 19
165318 93031 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3265 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 5.5x9   6005231 2106625 37.7646867413409 -122.425108746155 (37.7646867413409, -122.425108746155) 8 4 5 28859 19
188704 57306 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3265 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1992 12:00:00 AM   5.5x9 Permit Number 30983 6005094.29272651 2106604.42467206 37.7646225228273 -122.425580116407 (37.7646225228273, -122.425580116407) 8 4 5 28859 19
114328 50197 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3279@ DOLORES 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/2003 12:00:00 AM     Permit Number 46903 6005006.02996154 2106599.52754391 37.7646040888867 -122.425885045341 (37.7646040888867, -122.425885045341) 8 4 5 28859 19
19799 661 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3290X 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6007123.820387 2102082.126741 37.7523198047665 -122.418239853186 (37.7523198047665, -122.418239853186) 2 4 7 28859 19
138528 662 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3290X 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6007123.820387 2102082.126741 37.7523198047665 -122.418239853186 (37.7523198047665, -122.418239853186) 2 4 7 28859 19
40407 668 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3297X 24th St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6007079.62061 2102029.84762 37.7521737701718 -122.418388996947 (37.7521737701718, -122.418388996947) 2 4 7 28859 19
51940 665 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3297X 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6007079.62061 2102029.84762 37.7521737701718 -122.418388996947 (37.7521737701718, -122.418388996947) 2 4 7 28859 19
121805 669 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3297X 24th St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6007079.62061 2102029.84762 37.7521737701718 -122.418388996947 (37.7521737701718, -122.418388996947) 2 4 7 28859 19
32730 5389 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330X Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6004827.24095 2106401.30238 37.7640497043733 -122.426489313449 (37.7640497043733, -122.426489313449) 8 4 5 28859 3
87381 5388 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330X Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6004825.95108 2106424.13775 37.7641123319355 -122.426495400824 (37.7641123319355, -122.426495400824) 8 4 5 28859 3
123770 5390 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 330X Dolores St 3 Sidewalk: Curb side : Cutout Tree DPW 1     90 4X4   6004823.7091277 2106419.4754114 37.7640994035261 -122.426502823086 (37.7640994035261, -122.426502823086) 8 4 5 28859 3
62161 109596 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3332 21ST ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6006085.3 2103802.1 37.7569839418566 -122.421953398845 (37.7569839418566, -122.421953398845) 2 4 5 28859 19
55414 61158 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3347 20TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1983 12:00:00 AM 12 5x5 Permit Number 21016 6007930.5 2104397.2 37.758721842404 -122.415614115387 (37.758721842404, -122.415614115387) 2 4 7 28859 19
10859 102456 Undocumented 4 Ficus nitida :: Laurel Fig 53 3365 20th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007790 2104415 37.7587628183764 -122.416101290754 (37.7587628183764, -122.416101290754) 2 4 7 28859 19
64858 102457 Undocumented 4 Ficus nitida :: Laurel Fig 53 3365 20th St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007790 2104415 37.7587628183764 -122.416101290754 (37.7587628183764, -122.416101290754) 2 4 7 28859 19
119605 102455 Undocumented 4 Ficus nitida :: Laurel Fig 53 3365 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007790 2104415 37.7587628183764 -122.416101290754 (37.7587628183764, -122.416101290754) 2 4 7 28859 19
133761 102454 Undocumented 4 Ficus nitida :: Laurel Fig 53 3365 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007790 2104415 37.7587628183764 -122.416101290754 (37.7587628183764, -122.416101290754) 2 4 7 28859 19
44100 115215 Undocumented 4 Ficus nitida :: Laurel Fig 53 3395x 21ST ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2016 12:00:00 AM 3 9x5 Permit Number 779049 6005778 2103691 37.7566615513452 -122.423008263345 (37.7566615513452, -122.423008263345) 2 4 5 28859 19
155548 115216 Undocumented 4 Ficus nitida :: Laurel Fig 53 3395x 21ST ST 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2016 12:00:00 AM 3 3x3   6005778 2103691 37.7566615513452 -122.423008263345 (37.7566615513452, -122.423008263345) 2 4 5 28859 19
93776 110724 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
95408 110726 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
95901 110725 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
115099 110727 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
123934 110723 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
43227 110731 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
54160 110730 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
125549 110733 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
190351 110732 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
60087 86905 Permitted Site 7 Ficus nitida :: Laurel Fig 53 36 Camp St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2007 12:00:00 AM   3x3 Permit Number 49869 6005775 2106383 37.7640529822515 -122.423209987967 (37.7640529822515, -122.423209987967) 8 4 5 28859 19
120502 57735 Permitted Site 7 Ficus nitida :: Laurel Fig 53 364 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/1993 12:00:00 AM 16   Permit Number 31982 6005454.9599493 2101588.78174199 37.7508711140338 -122.423975967283 (37.7508711140338, -122.423975967283) 2 4 5 28859 19
168783 96335 Undocumented 4 Ficus nitida :: Laurel Fig 53 3705 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 28622 6005781 2101380 37.7503162492489 -122.422833652647 (37.7503162492489, -122.422833652647) 2 4 5 28859 19
20606 15650 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3718 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6005292.79028 2096596.92241 37.7371554485093 -122.42418178869 (37.7371554485093, -122.42418178869) 2 7 5 28859 2
141296 15649 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3718 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6005292.79028 2096596.92241 37.7371554485093 -122.42418178869 (37.7371554485093, -122.42418178869) 2 7 5 28859 2
171840 69122 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3744 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/1994 12:00:00 AM 22 5x9 Permit Number 33140 6005352.36529805 2104323.23161765 37.7583734841408 -122.424525234112 (37.7583734841408, -122.424525234112) 2 4 5 28859 19
93614 109925 Undocumented 4 Ficus nitida :: Laurel Fig 53 375 FAIR OAKS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6005525.2 2101540.6 37.7507427833765 -122.423729644924 (37.7507427833765, -122.423729644924) 2 4 5 28859 19
139295 59013 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3755 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1980 12:00:00 AM 20   Permit Number 18304 6005291.98683548 2104267.80164023 37.7582178764875 -122.424730106513 (37.7582178764875, -122.424730106513) 2 4 5 28859 19
90745 18351 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 469 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   6010382.7073264 2106125.7302845 37.7636055342277 -122.407255067708 (37.7636055342277, -122.407255067708) 8 4 8 28859 19
24579 96732 Undocumented 4 Ficus nitida :: Laurel Fig 53 514 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3.5   6007319.4 2106562.9 37.7646339820142 -122.417881101898 (37.7646339820142, -122.417881101898) 8 4 7 28859 19
79996 96733 Undocumented 4 Ficus nitida :: Laurel Fig 53 514 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3.5   6007319.4 2106562.9 37.7646339820142 -122.417881101898 (37.7646339820142, -122.417881101898) 8 4 7 28859 19
44451 96734 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19
78654 96735 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19
130738 96736 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19
50489 18364 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 598 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6010361.2141646 2105516.7578044 37.7619322307219 -122.407286474232 (37.7619322307219, -122.407286474232) 8 4 8 28859 19
131086 18365 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 598 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6010361.2141646 2105516.7578044 37.7619322307219 -122.407286474232 (37.7619322307219, -122.407286474232) 8 4 8 28859 19
73677 18366 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6010418.5901612 2105518.9759028 37.7619415321313 -122.407088188566 (37.7619415321313, -122.407088188566) 8 4 8 28859 19
51092 109603 Undocumented 4 Ficus nitida :: Laurel Fig 53 602 SHOTWELL ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007851.6 2104381.9 37.758675396701 -122.415885905109 (37.758675396701, -122.415885905109) 2 4 7 28859 19
97918 102451 Undocumented 4 Ficus nitida :: Laurel Fig 53 602 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007851.6 2104381.9 37.758675396701 -122.415885905109 (37.758675396701, -122.415885905109) 2 4 7 28859 19
32305 173934 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 4 Sidewalk: Curb side : Cutout Tree Private 2       9x9   6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
78273 45427 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM   9x9 Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
132675 45428 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM     Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
145968 45426 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM   9x9 Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
163969 18370 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 635 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     25 4x4   6010438.67568 2105328.38433 37.7614193346753 -122.407005286068 (37.7614193346753, -122.407005286068) 10 4 8 28859 19
177096 51793 Permitted Site 7 Ficus nitida :: Laurel Fig 53 65 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2005 12:00:00 AM     Permit Number 48042 6005279.64463313 2105087.60921781 37.7604681781651 -122.42483111417 (37.7604681781651, -122.42483111417) 2 4 5 28859 19
127066 96913 Undocumented 4 Ficus nitida :: Laurel Fig 53 65X Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005919.1 2102263.8 37.7527507518094 -122.422418882903 (37.7527507518094, -122.422418882903) 2 4 5 28859 19
51820 12942 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 725X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     16 6   6005046.7981655 2104134.69405 37.7578385432445 -122.425568603003 (37.7578385432445, -122.425568603003) 2 4 5 28859 19
154248 18380 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 756 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010387.2722525 2104782.2318449 37.7599168463595 -122.407144570806 (37.7599168463595, -122.407144570806) 10 4 8 28859 19
129417 18412 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 799X Potrero Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6010481.3464666 2104567.7087473 37.7593330783471 -122.406804093165 (37.7593330783471, -122.406804093165) 10 4 8 28859 19
53550 18383 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 804 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     28 3x3   6010399.792436 2104541.9824298 37.7592578761131 -122.407084334673 (37.7592578761131, -122.407084334673) 10 4 7 28859 19
142871 18385 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 812 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 16x5   6010402.1602537 2104496.7929466 37.759133928444 -122.407072960308 (37.759133928444, -122.407072960308) 10 4 7 28859 19
158510 18390 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 866 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6010418.2672605 2104189.3928818 37.7582907781506 -122.406995587546 (37.7582907781506, -122.406995587546) 10 4 7 28859 19
97770 18392 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 886 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6010424.2598856 2104075.0244367 37.7579770833513 -122.406966801395 (37.7579770833513, -122.406966801395) 10 4 7 28859 19
186502 18393 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 886 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6010424.2598856 2104075.0244367 37.7579770833513 -122.406966801395 (37.7579770833513, -122.406966801395) 10 4 7 28859 19
18243 96948 Undocumented 4 Ficus nitida :: Laurel Fig 53 900X Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 6x6   6007359.7 2102053.2 37.7522536530624 -122.417422091759 (37.7522536530624, -122.417422091759) 2 4 7 28859 19
41221 96947 Undocumented 4 Ficus nitida :: Laurel Fig 53 900X Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 6x6   6007389 2101516 37.750780272338 -122.417282702809 (37.750780272338, -122.417282702809) 2 4 7 28859 19
81588 113833 Significant Tree 6 Ficus nitida :: Laurel Fig 53 932 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30     6007966 2102301 37.7529681504442 -122.415342945464 (37.7529681504442, -122.415342945464) 2 4 7 28859 19
162339 10147 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 940 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 2x3   6005660.7422371 2103489.3240903 37.7561011788947 -122.423399446987 (37.7561011788947, -122.423399446987) 2 4 5 28859 19

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