trees

92 rows where Zip Codes = 28859 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

Zip Codes ✖

  • 28859 · 92 ✖
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)
21022 69205 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2860 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33254 6008952.43931379 2101803.50283851 37.7516575269948 -122.411896484829 (37.7516575269948, -122.411896484829) 2 4 7 28859 19
23336 63134 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 27 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23649 6007447.90223159 2099378.78534919 37.7449152757931 -122.416927606356 (37.7449152757931, -122.416927606356) 2 7 7 28859 2
33290 63461 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 45 Powers Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1987 12:00:00 AM     Permit Number 24052 6006867.21716204 2099801.68707108 37.7460437878528 -122.418965501899 (37.7460437878528, -122.418965501899) 2 7 7 28859 2
35130 63135 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 25 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23650 6007455.65629161 2099393.17627053 37.7449552262088 -122.416901813576 (37.7449552262088, -122.416901813576) 2 7 7 28859 2
56987 63133 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 28 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23648 6007400.02445462 2099399.55358264 37.7449696074565 -122.417094630618 (37.7449696074565, -122.417094630618) 2 7 7 28859 2
62771 62339 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 67 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/1994 12:00:00 AM     Permit Number 22481 6004929.22923105 2096213.38801269 37.7360818148322 -122.425411499586 (37.7360818148322, -122.425411499586) 2 7 5 28859 2
74836 66622 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 867 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/15/1991 12:00:00 AM     Permit Number 29826 6010209.78585513 2104179.32451342 37.7582514640983 -122.407715901057 (37.7582514640983, -122.407715901057) 10 4 7 28859 19
101142 65305 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3629 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM     Permit Number 28122 6005455.44263685 2104863.06150764 37.7598615508482 -122.424207139046 (37.7598615508482, -122.424207139046) 2 4 5 28859 19
126786 248223 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 70 Fair Ave 5 Side Yard : Yard Tree Private 2     18     6007150.20605 2099339.87769 37.744791694087 -122.417954229812 (37.744791694087, -122.417954229812) 2 7 7 28859 2
129447 63292 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3075 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23858 6009183.06965006 2100534.27317896 37.7481854410784 -122.411009292537 (37.7481854410784, -122.411009292537) 2 4 7 28859 2
129894 69204 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2850 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33252 6008949.31851966 2101859.27420808 37.7518104876034 -122.411911217702 (37.7518104876034, -122.411911217702) 2 4 7 28859 19
132571 63129 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 34 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23643 6007144.61352889 2099320.79872129 37.7447389927671 -122.417972215495 (37.7447389927671, -122.417972215495) 2 7 7 28859 2
144794 32372 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 90 Leese St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/2018 12:00:00 AM 3   Permit Number 782452 6005529.07574 2096212.96171 37.7361145169719 -122.423337554504 (37.7361145169719, -122.423337554504) 2 7 7 28859 2
150990 64607 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/1988 12:00:00 AM 20   Permit Number 25510 6008240.6573587 2104159.54552526 37.7580867271242 -122.414524628823 (37.7580867271242, -122.414524628823) 2 4 7 28859 19
167156 69206 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2864 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33255 6008953.68763074 2101781.1943032 37.7515963427841 -122.411890591701 (37.7515963427841, -122.411890591701) 2 4 7 28859 19
185506 63233 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 200x ESMERALDA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1987 12:00:00 AM     Permit Number 23781 6007093 2098828 37.7433829729046 -122.41811575542 (37.7433829729046, -122.41811575542) 2 7 7 28859 2
121688 4845 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 202 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/1992 12:00:00 AM 24 3X3   6006694.31051 2097440.2331 37.7395500270059 -122.41939589432 (37.7395500270059, -122.41939589432) 2 7 7 28859 2
154695 4846 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 210 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/1992 12:00:00 AM 15 3X3   6006713.9746 2097429.76412 37.7395223890352 -122.419327161814 (37.7395223890352, -122.419327161814) 2 7 7 28859 2
754 34739 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM   3x3 Permit Number 38389 6007302.61875581 2103939.58827334 37.7574300317864 -122.417753185833 (37.7574300317864, -122.417753185833) 2 4 7 28859 19
3681 106711 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3990 FOLSOM ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008366.1 2096547.2 37.7371919715517 -122.413552407719 (37.7371919715517, -122.413552407719) 2 7 7 28859 2
60245 108910 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 129 Ellert St 1 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773054 6007361.2 2097016.9 37.7384251864379 -122.417060086005 (37.7384251864379, -122.417060086005) 2 7 7 28859 2
61694 26511 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2850 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008945.12722 2101866.39993 37.7518298180943 -122.411926215341 (37.7518298180943, -122.411926215341) 2 4 7 28859 19
67823 103022 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 40X Coleridge St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/15/2013 12:00:00 AM 3 3x3 Permit Number 770067 6006901 2099544.2 37.7453386886112 -122.418830426928 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
76448 108926 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 36 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772355 6007347.4 2099299.8 37.7446927459132 -122.417269529335 (37.7446927459132, -122.417269529335) 2 7 7 28859 2
93872 102475 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 38389 6007298 2103932 37.7574089362149 -122.417768621509 (37.7574089362149, -122.417768621509) 2 4 7 28859 19
130795 81299 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 109 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM 12 3x3 Permit Number 50541 6006708.25661782 2103139.88479614 37.7552007652727 -122.419751988993 (37.7552007652727, -122.419751988993) 2 4 7 28859 19
17657 221821 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 3x5   6007305.19909 2096505.34711 37.7370174246124 -122.417217471014 (37.7370174246124, -122.417217471014) 2 7 7 28859 2
92787 114424 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 724 MOULTRIE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 4x2   6007601 2096031 37.735731608506 -122.416161167234 (37.735731608506, -122.416161167234) 2 7 7 28859 2
142834 33539 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 253 BOCANA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2015 12:00:00 AM   4x4 Permit Number 775951 6007035 2097463 37.7396317225537 -122.418219548801 (37.7396317225537, -122.418219548801) 2 7 7 28859 2
58635 63004 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1986 12:00:00 AM 20 4x6 Permit Number 23414 6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
132523 115548 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   20 4x6   6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
69147 33484 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 300 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM 30 6x6 Permit Number 37610 6006227.43678663 2098258.25526822 37.741769825751 -122.421068211473 (37.741769825751, -122.421068211473) 2 7 7 28859 2
162352 4572 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 233 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM 1 6x6 Permit Number 775065 6006398.09865 2098473.12689 37.742369434016 -122.420493366683 (37.742369434016, -122.420493366683) 2 7 7 28859 2
1806 221820 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 2ft   6007294.28583 2096507.5919 37.7370229743371 -122.417255362169 (37.7370229743371, -122.417255362169) 2 7 7 28859 2
2752 221825 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008302.15962 2096532.14097 37.7371470321954 -122.41377241466 (37.7371470321954, -122.41377241466) 2 7 7 28859 2
12895 221826 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008314.44854 2096531.09899 37.7371448612571 -122.413729852457 (37.7371448612571, -122.413729852457) 2 7 7 28859 2
19306 221827 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008328.718 2096529.81834 37.7371421461853 -122.413680425731 (37.7371421461853, -122.413680425731) 2 7 7 28859 2
32001 221822 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 129 Ellert St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6007356.42456 2097004.67982 37.7383913638823 -122.417075731561 (37.7383913638823, -122.417075731561) 2 7 7 28859 2
3673 221872 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 619 Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007332.3833 2097776.98457 37.740510589287 -122.417213566178 (37.740510589287, -122.417213566178) 2 7 7 28859 2
4442 221873 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 253 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007019.01293 2097474.10434 37.7396613127072 -122.418275612445 (37.7396613127072, -122.418275612445) 2 7 7 28859 2
6832 221870 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 530 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6008584.18129 2096552.27767 37.7372181568784 -122.412798757353 (37.7372181568784, -122.412798757353) 10 7 7 28859 2
10474 221869 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 673 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007432.02888 2095820.07599 37.7351429550833 -122.416730429683 (37.7351429550833, -122.416730429683) 2 7 7 28859 2
32667 221878 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 18 Coleridge St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6006985.0649 2099647.22119 37.7456262946341 -122.41854704763 (37.7456262946341, -122.41854704763) 2 7 7 28859 2
41894 221832 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 573 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007293.28891 2103997.59658 37.7575887842104 -122.417789563935 (37.7575887842104, -122.417789563935) 2 4 7 28859 19
42770 221831 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 569 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007292.05586 2104018.90213 37.7576472149557 -122.417795338504 (37.7576472149557, -122.417795338504) 2 4 7 28859 19
47768 221885 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 100 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008227.02437 2099369.61702 37.7449338966774 -122.414232888254 (37.7449338966774, -122.414232888254) 2 7 7 28859 2
48444 221887 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4107 Ogden Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008432.72367 2096048.99248 37.7358277429522 -122.41328683742 (37.7358277429522, -122.41328683742) 10 7 7 28859 2
49629 221833 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 577 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007293.94274 2103980.62531 37.7575422218038 -122.417786099775 (37.7575422218038, -122.417786099775) 2 4 7 28859 19
53011 221889 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 190 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006689.37303 2102664.80303 37.7538952362014 -122.419783585756 (37.7538952362014, -122.419783585756) 2 4 7 28859 19
53970 221876 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 24 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 3ft   6006954.78098 2099597.50642 37.7454880840995 -122.418648240225 (37.7454880840995, -122.418648240225) 2 7 7 28859 2
64032 221815 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3734 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008428.67762 2097499.17078 37.7398093887782 -122.413403351802 (37.7398093887782, -122.413403351802) 2 7 7 28859 2
64776 221819 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 68 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006048.67396 2097610.71259 37.7399817402673 -122.421640334157 (37.7399817402673, -122.421640334157) 2 7 7 28859 2
65100 221877 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 22 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006964.5888 2099612.44373 37.7455296507747 -122.418615385312 (37.7455296507747, -122.418615385312) 2 7 7 28859 2
70357 221879 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 43 Powers Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6006986.90322 2099718.335 37.745821660643 -122.418545732803 (37.745821660643, -122.418545732803) 2 7 7 28859 2
79681 221871 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 619 Eugenia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007314.53376 2097779.75076 37.7405171804218 -122.417275479073 (37.7405171804218, -122.417275479073) 2 7 7 28859 2
79694 221813 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 810 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007573.94838 2095674.48731 37.7347511816054 -122.416229453325 (37.7347511816054, -122.416229453325) 2 7 7 28859 2
88122 248073 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 440 Holladay Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6010194.15796 2098463.12553 37.7425551682987 -122.407366975408 (37.7425551682987, -122.407366975408) 10 7 7 28859 2
88668 221892 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3272 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007901.84296 2101535.98387 37.7508639830901 -122.415510655785 (37.7508639830901, -122.415510655785) 2 4 7 28859 19
95633 221883 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 34 Prospect Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007121.00835 2099271.28888 37.7446017212974 -122.418050328662 (37.7446017212974, -122.418050328662) 2 7 7 28859 2
99508 221835 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 585 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007295.48201 2103941.69106 37.7574354039359 -122.41777801665 (37.7574354039359, -122.41777801665) 2 4 7 28859 19
103566 248075 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 407 Holladay Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010292.79484 2098665.98806 37.743117705012 -122.407040212138 (37.743117705012, -122.407040212138) 10 7 7 28859 2
104584 221882 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 36 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007355.35831 2099292.63872 37.7446735303753 -122.417241503608 (37.7446735303753, -122.417241503608) 2 7 7 28859 2
109510 221880 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 47 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6007035.70082 2099744.20537 37.7458954419332 -122.418378831241 (37.7458954419332, -122.418378831241) 2 7 7 28859 2
120305 221888 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 192 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006128.60788 2102045.32396 37.7521626832758 -122.421678849418 (37.7521626832758, -122.421678849418) 2 4 5 28859 19
130543 221890 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 190 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006689.76882 2102684.09428 37.7539482278401 -122.419783585763 (37.7539482278401, -122.419783585763) 2 4 7 28859 19
145041 221874 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 371 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 3ft   6006129.02794 2097974.50861 37.7409851732348 -122.421388331502 (37.7409851732348, -122.421388331502) 2 7 7 28859 2
148843 221818 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 36 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007500.06769 2099881.60431 37.7462988382332 -122.416782843047 (37.7462988382332, -122.416782843047) 2 7 7 28859 2
152125 221834 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6007293.84054 2103959.34746 37.7574837919732 -122.417784945026 (37.7574837919732, -122.417784945026) 2 4 7 28859 19
152526 221816 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 27 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6007421.73456 2099361.81155 37.7448671975643 -122.417016887145 (37.7448671975643, -122.417016887145) 2 7 7 28859 2
154673 221886 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 121 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6006322.71195 2097511.22057 37.7397240062552 -122.420685761336 (37.7397240062552, -122.420685761336) 2 7 7 28859 2
155422 221812 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 724 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007603.04648 2096007.03362 37.7356659171455 -122.416152394917 (37.7356659171455, -122.416152394917) 2 7 7 28859 2
157705 221881 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6007048.87361 2099774.96937 37.7459806544792 -122.418335462324 (37.7459806544792, -122.418335462324) 2 7 7 28859 2
162952 221836 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 585 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007298.30885 2103900.40234 37.7573221936904 -122.417765313729 (37.7573221936904, -122.417765313729) 2 4 7 28859 19
168785 221814 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 78 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007954.65071 2098276.18605 37.7419162746098 -122.415097327373 (37.7419162746098, -122.415097327373) 2 7 7 28859 2
180514 221817 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 25 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6007435.65723 2099387.93304 37.7449397045122 -122.416970595441 (37.7449397045122, -122.416970595441) 2 7 7 28859 2
183922 221794 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 63 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009581.16571 2099887.27047 37.7464312301328 -122.409587024721 (37.7464312301328, -122.409587024721) 2 7 7 28859 2
188123 248074 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 440 Holladay Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6010189.61639 2098448.43347 37.742514572897 -122.407381643363 (37.742514572897, -122.407381643363) 10 7 7 28859 2
578 221823 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 199X Ogden Ave 6 Sidewalk: Curb side : Pot Tree Private 2     13 Width 4ft   6007760.27568 2096148.55485 37.7360633428545 -122.415618808282 (37.7360633428545, -122.415618808282) 2 7 7 28859 2
10220 221824 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 199X Ogden Ave 10 Sidewalk: Curb side : Pot Tree Private 2     10 Width 4ft   6007730.82531 2096150.27006 37.7360663969372 -122.415720751814 (37.7360663969372, -122.415720751814) 2 7 7 28859 2
15498 221829 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6008243.92561 2104140.04763 37.7580333739666 -122.414511946088 (37.7580333739666, -122.414511946088) 2 4 7 28859 19
20666 221837 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 109 Bartlett St 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   6006703.42014 2103074.38684 37.7550206505078 -122.419764067776 (37.7550206505078, -122.419764067776) 2 4 7 28859 19
71384 221875 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 319 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 4ft   6006211.14692 2098216.1896 37.7416534045787 -122.421121550328 (37.7416534045787, -122.421121550328) 2 7 7 28859 2
87625 221792 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2818 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009842.62719 2102814.79283 37.7544842057885 -122.408889429605 (37.7544842057885, -122.408889429605) 2 4 7 28859 19
91243 221828 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1070 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6008613.25764 2102303.67809 37.7530118609308 -122.413104786776 (37.7530118609308, -122.413104786776) 2 4 7 28859 19
153194 221788 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 67 Richland Ave 1 : Tree Private 2     20 Width 4ft   6005032.77253 2096203.58298 37.7360607419969 -122.425052810752 (37.7360607419969, -122.425052810752) 2 7 5 28859 2
179502 221830 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6008241.38226 2104159.63616 37.7580870167112 -122.414522128209 (37.7580870167112, -122.414522128209) 2 4 7 28859 19
91117 221789 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3456 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6005341.04131 2103147.38287 37.7551442389361 -122.424480760089 (37.7551442389361, -122.424480760089) 2 4 5 28859 19
100205 221884 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 230 Esmeralda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6007166.67292 2098807.97162 37.7433321258706 -122.417859593245 (37.7433321258706, -122.417859593245) 2 7 7 28859 2
101047 221790 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3456 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 5ft   6005327.10837 2103145.45598 37.7551381613168 -122.424528807253 (37.7551381613168, -122.424528807253) 2 4 5 28859 19
159038 221793 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 26 Norwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6009169.37019 2099491.8572 37.745322428991 -122.410983048655 (37.745322428991, -122.410983048655) 2 7 7 28859 2
98506 221791 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 867 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/15/1991 12:00:00 AM 30 Width 6ft Permit Number 29826 6010196.62735 2104192.74111 37.7582875664398 -122.407762355146 (37.7582875664398, -122.407762355146) 10 4 7 28859 19
129007 221787 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 124 27th St 1 Sidewalk: Curb side : Yard Tree Private 2     21 Width 8ft   6005680.59891 2100245.58826 37.7471957491868 -122.423100223394 (37.7471957491868, -122.423100223394) 2 7 5 28859 22

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