81 rows where qSpecies_id = 136

View and edit SQL

Suggested facets: PlotSize

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)
746 110743 Section 806 (d) 5 Cercis occidentalis :: Western Redbud 136 2300x Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010565.19201 2106016.80838 37.7633166706365 -122.406616231274 (37.7633166706365, -122.406616231274) 8 4 8 28859 19
1139 189986 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 32 Sidewalk: Property side : Yard Tree Private 2     2     6012583.96536 2096233.71501 37.7365671439547 -122.398947230147 (37.7365671439547, -122.398947230147) 10 3 8 58 1
9812 225131 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2 Mirabel Ave 5 Sidewalk: Property side : Yard Tree Private 2     3     6007282.16876 2099771.17309 37.7459833605478 -122.417528488069 (37.7459833605478, -122.417528488069) 2 7 7 28859 2
15551 189991 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1427x Innes Ave 18 Median : Yard Tree DPW 1     20     6016204.83732 2096710.6252 37.7380777432808 -122.386461454743 (37.7380777432808, -122.386461454743) 10 3 8 58 1
16893 201267 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 200 Kalmanovitz St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 2ft   6013091.83169 2092838.18677 37.7272720093758 -122.396953309066 (37.7272720093758, -122.396953309066) 10 3 8 58 1
17898 62498 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 35 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1986 12:00:00 AM 1   Permit Number 22670 6000912.98222 2092877.24517 37.7266938037715 -122.439058237157 (37.7266938037715, -122.439058237157) 9 7 6 28861 25
24059 189976 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 602 Arthur Ave 44 Front Yard : Yard Tree Private 2     5 Width 7ft   6015959.75486 2099808.68587 37.7465708129981 -122.387524907554 (37.7465708129981, -122.387524907554) 10 3 8 58 1
25794 53216 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 828 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1956 12:00:00 AM 1   Permit Number 41 6013034.72184 2103183.73982 37.7556755404181 -122.397876136701 (37.7556755404181, -122.397876136701) 10 3 8 28856 29
28385 189981 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 23 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012438.4082 2096335.74445 37.7368391834845 -122.399457647549 (37.7368391834845, -122.399457647549) 10 3 8 58 1
29946 202323 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 145 Orsi Cir 1 : Tree Private 2     4 Width 2ft   6012916.63794 2093046.14755 37.7278332735801 -122.397573536383 (37.7278332735801, -122.397573536383) 10 3 8 58 1
31238 247887 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 360 Mayflower St 2 Side Yard : Yard Tree Private 2     3     6009991.26305 2098380.13852 37.7423159459174 -122.408062678348 (37.7423159459174, -122.408062678348) 10 7 7 28859 2
32371 201249 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 75 Orsi Cir 4 Sidewalk: Curb side : Yard Tree Private 2     5 Width 2ft   6012867.89314 2093249.63424 37.7283892920331 -122.397756316395 (37.7283892920331, -122.397756316395) 10 3 8 58 1
33005 175844 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 301 Naglee Ave 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5997777.82989 2088418.93682 37.7142734378322 -122.44957519515 (37.7142734378322, -122.44957519515) 9 7 6 28861 25
34202 189990 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1427x Innes Ave 16 Median : Yard Tree DPW 1     17     6016227.39671 2096690.18473 37.7380228666701 -122.386382030231 (37.7380228666701, -122.386382030231) 10 3 8 58 1
34203 120900 Undocumented 4 Cercis occidentalis :: Western Redbud 136 250 States St 2 Sidewalk: Property side : Yard Tree Private 2     1     6000595 2106681 37.7645775245529 -122.441147421326 (37.7645775245529, -122.441147421326) 15 5 5 28862 3
36120 91327 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 59 Mars St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM   3x3 Permit Number 53986 5999595 2105446 37.7611295104392 -122.44451737368 (37.7611295104392, -122.44451737368) 15 5 5 28862 3
38443 202302 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 142 Orsi Cir 1 : Tree Private 2     5 Width 2ft   6012862.67742 2093038.03739 37.7278079999277 -122.397759511686 (37.7278079999277, -122.397759511686) 10 3 8 58 1
42054 50640 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 2700 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2003 12:00:00 AM     Permit Number 47227 6008685.113393 2106855.73545108 37.7655148056516 -122.41317815543 (37.7655148056516, -122.41317815543) 8 4 7 28853 19
43048 98285 Section 143 10 Cercis occidentalis :: Western Redbud 136 300 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
47257 189985 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 27 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012486.98266 2096301.35622 37.7367474679233 -122.399287289877 (37.7367474679233, -122.399287289877) 10 3 8 58 1
48006 225135 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 59 Mars St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5999584.53512 2105480.60868 37.7612239401606 -122.444556054542 (37.7612239401606, -122.444556054542) 15 5 5 28862 3
50922 102069 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 50X Coleridge St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/2012 12:00:00 AM   3x3 Permit Number 52614 6006867.4 2099433.7 37.7450333885382 -122.418938774663 (37.7450333885382, -122.418938774663) 2 7 7 28859 2
51396 29642 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1500X La Salle Ave 1 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015978.2614 2095831.5089 37.7356513227308 -122.387183545032 (37.7356513227308, -122.387183545032) 10 3 8 58 1
54018 98287 Section 143 10 Cercis occidentalis :: Western Redbud 136 300 Mangels Ave 3 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
54581 98286 Section 143 10 Cercis occidentalis :: Western Redbud 136 300 Mangels Ave 2 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
54951 202317 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 171 Orsi Cir 1 : Tree Private 2     6 Width 2ft   6013014.6223 2092973.46989 37.7276391711032 -122.397229705795 (37.7276391711032, -122.397229705795) 10 3 8 58 1
55498 189988 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 34 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012609.72443 2096214.32079 37.736515326817 -122.398856808712 (37.736515326817, -122.398856808712) 10 3 8 58 1
57643 202297 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 128 Orsi Cir 1 : Tree Private 2     6 Width 2ft   6012789.45196 2093091.80408 37.7279515541956 -122.398016425535 (37.7279515541956, -122.398016425535) 10 3 8 58 1
58709 225129 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 501 Alabama St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6009000.51877 2105809.55198 37.7626599281265 -122.412013295782 (37.7626599281265, -122.412013295782) 8 4 7 28859 19
59141 189979 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 19 Sidewalk: Property side : Yard Tree Private 2     2     6012352.1202 2096398.07339 37.7370055157936 -122.399760360254 (37.7370055157936, -122.399760360254) 10 3 8 58 1
68204 57154 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 126 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52577 6005655.77070518 2096371.4417798 37.7365568174943 -122.422910777968 (37.7365568174943, -122.422910777968) 2 7 7 28859 2
68624 16367 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1300X Montgomery St 10 Median : Cutout Tree DPW 1     4 8   6011500.9168661 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012) 3 1 10 308 23
71270 201269 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 200 Kalmanovitz St 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 2ft   6013069.13486 2092810.94141 37.7271959357375 -122.397029862935 (37.7271959357375, -122.397029862935) 10 3 8 58 1
78028 202318 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 165 Orsi Cir 1 : Tree Private 2     4 Width 2ft   6013007.15783 2092979.14399 37.7276543354547 -122.397255908459 (37.7276543354547, -122.397255908459) 10 3 8 58 1
78562 94870 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 2451X Griffith St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53940 6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
83972 225132 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1201 San Jose Ave 19 Front Yard : Yard Tree Private 2     1     6004294.72641 2095912.63929 37.7352201573845 -122.427583813236 (37.7352201573845, -122.427583813236) 2 7 5 28861 2
84137 189977 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 602 Arthur Ave 51 Front Yard : Yard Tree Private 2     8 Width 10ft   6015891.27687 2099767.95939 37.746455193446 -122.387758858101 (37.746455193446, -122.387758858101) 10 3 8 58 1
91110 202324 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 139 Orsi Cir 1 : Tree Private 2     5 Width 2ft   6012910.81057 2093050.49966 37.7278448990995 -122.397593986976 (37.7278448990995, -122.397593986976) 10 3 8 58 1
95143 247889 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 360 Mayflower St 4 Side Yard : Yard Tree Private 2     4     6010002.07047 2098377.09452 37.7423081928588 -122.408025094795 (37.7423081928588, -122.408025094795) 10 7 7 28859 2
100340 201253 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 75 Orsi Cir 8 Sidewalk: Curb side : Yard Tree Private 2     3 Width 2ft   6012901.23159 2093261.84433 37.7284246749358 -122.397641919057 (37.7284246749358, -122.397641919057) 10 3 8 58 1
100962 4280 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 4266 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/16/2000 12:00:00 AM 3 2X2   6002159.0177297 2100348.7319505 37.7472796005587 -122.435284935821 (37.7472796005587, -122.435284935821) 2 4 5 63 22
106783 31570 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 257 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 1   Permit Number 35110 5996974.3553 2112656.5835 37.7807780278075 -122.454101804264 (37.7807780278075, -122.454101804264) 11 6 2 54 16
107249 122377 Undocumented 4 Cercis occidentalis :: Western Redbud 136 195x Ogden Ave 4 Sidewalk: Property side : Cutout Tree Private 2           6007788 2096166 37.7361128018191 -122.415524188543 (37.7361128018191, -122.415524188543) 2 7 7 28859 2
111137 225130 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 501 Alabama St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6009000.12546 2105825.81959 37.7627045731891 -122.412015805783 (37.7627045731891, -122.412015805783) 8 4 7 28859 19
112269 189973 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 496 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6010621.01427 2106044.46414 37.7633957300645 -122.406425108235 (37.7633957300645, -122.406425108235) 8 4 8 28859 19
113005 225133 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1201 San Jose Ave 27 Front Yard : Yard Tree Private 2     1     6004362.40178 2095984.78807 37.7354220893496 -122.427354972676 (37.7354220893496, -122.427354972676) 2 7 5 28861 2
123185 141061 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 257 PARKER AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5996977.4011 2112639.324 37.7807308124141 -122.454090020502 (37.7807308124141, -122.454090020502) 11 6 2 54 16
125274 202319 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 159 Orsi Cir 1 : Tree Private 2     4 Width 2ft   6012982.5618 2092996.94727 37.7277018502531 -122.397342185804 (37.7277018502531, -122.397342185804) 10 3 8 58 1
126499 225134 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1201 San Jose Ave 31 Front Yard : Yard Tree Private 2     1     6004381.17131 2095999.66533 37.7354640004668 -122.427291138793 (37.7354640004668, -122.427291138793) 2 7 5 28861 2
128263 100322 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1630 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2013 12:00:00 AM 1   Permit Number 770770 6006281.05167 2117644.72718 37.7950034915744 -122.422259877984 (37.7950034915744, -122.422259877984) 13 9 10 28858 32
129400 206023 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 238 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5999152.99249 2094098.71035 37.7299473620575 -122.445230225021 (37.7299473620575, -122.445230225021) 9 7 4 28861 40
137917 65018 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 1150 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2015 12:00:00 AM 3   Permit Number 774753 5997380.8966451 2106284.83958568 37.7633061668534 -122.452235495348 (37.7633061668534, -122.452235495348) 15 5 11 29492 9
139438 189983 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 25 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012461.23167 2096321.12771 37.7368003210833 -122.399377710436 (37.7368003210833, -122.399377710436) 10 3 8 58 1
140816 189978 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 14 Sidewalk: Property side : Yard Tree Private 2     2     6012318.55478 2096424.98623 37.7370775415837 -122.399878300962 (37.7370775415837, -122.399878300962) 10 3 8 58 1
143547 100323 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1630 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2013 12:00:00 AM 2   Permit Number 770770 6006270.05987 2117642.28458 37.7949961647956 -122.422297737665 (37.7949961647956, -122.422297737665) 13 9 10 28858 32
150348 16361 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1306X Montgomery St 11 Median : Cutout Tree DPW 1     18 8   6011454.0998 2119899.17668 37.8014840979794 -122.404519042839 (37.8014840979794, -122.404519042839) 3 1 10 308 23
151113 184394 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2050 45th Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5982331.3515 2101153.7956 37.7483441473859 -122.503906004952 (37.7483441473859, -122.503906004952) 1 8 3 29491 35
151727 189984 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 26 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012475.97844 2096310.07171 37.7367707855307 -122.399325948156 (37.7367707855307, -122.399325948156) 10 3 8 58 1
154448 200036 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1500x Quesada Ave 1 Median : Cutout Tree DPW 1     1 Width 0ft   6015497.9987 2094442.9756 37.7318120829921 -122.388747110264 (37.7318120829921, -122.388747110264) 10 3 8 58 1
155089 102071 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 50X Coleridge St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/2012 12:00:00 AM   3x3 Permit Number 52614 6006867.4 2099433.7 37.7450333885382 -122.418938774663 (37.7450333885382, -122.418938774663) 2 7 7 28859 2
157608 247888 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 360 Mayflower St 3 Side Yard : Yard Tree Private 2     2     6009996.89336 2098378.14108 37.7423107766219 -122.408043069531 (37.7423107766219, -122.408043069531) 10 7 7 28859 2
158905 37150 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 114 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/2015 12:00:00 AM 3   Permit Number 39730 6005776.47053016 2100252.57781759 37.7472203506201 -122.422769203011 (37.7472203506201, -122.422769203011) 2 7 5 28859 22
161337 189975 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 875 Vermont St 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 10ft   6011318.53536 2104285.62381 37.7586053436847 -122.403888820412 (37.7586053436847, -122.403888820412) 10 3 8 28856 29
164121 201268 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 200 Kalmanovitz St 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 2ft   6013087.7822 2092834.49936 37.7272616590859 -122.396967049805 (37.7272616590859, -122.396967049805) 10 3 8 58 1
167303 120899 Undocumented 4 Cercis occidentalis :: Western Redbud 136 250 States St 1 Sidewalk: Property side : Yard Tree Private 2     1 3x3   6000812 2106669 37.7645569336095 -122.440396017927 (37.7645569336095, -122.440396017927) 15 5 5 28862 3
171927 202311 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 192 Orsi Cir 1 : Tree Private 2     4 Width 2ft   6013079.04829 2092877.72524 37.7273798623663 -122.39700027256 (37.7273798623663, -122.39700027256) 10 3 8 58 1
172311 100321 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1630 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2013 12:00:00 AM 2   Permit Number 770770 6006322.03546 2117650.55613 37.7950218080653 -122.422118482097 (37.7950218080653, -122.422118482097) 13 9 10 28858 32
172952 122376 Undocumented 4 Cercis occidentalis :: Western Redbud 136 195x Ogden Ave 3 Sidewalk: Property side : Cutout Tree Private 2           6007788 2096166 37.7361128018191 -122.415524188543 (37.7361128018191, -122.415524188543) 2 7 7 28859 2
174704 189989 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1427x Innes Ave 7 Median : Yard Tree DPW 1     4     6016321.76004 2096621.1016 37.7378384013117 -122.386050952014 (37.7378384013117, -122.386050952014) 10 3 8 58 1
177475 189974 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 875 Vermont St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6011341.45696 2104259.23548 37.7585341677446 -122.40380768987 (37.7585341677446, -122.40380768987) 10 3 8 28856 29
180919 189982 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 24 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012448.34075 2096330.25882 37.7368246747079 -122.399422921133 (37.7368246747079, -122.399422921133) 10 3 8 58 1
183170 189980 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 21 Sidewalk: Property side : Yard Tree Private 2     2     6012366.85539 2096386.45127 37.7369744253178 -122.399708597978 (37.7369744253178, -122.399708597978) 10 3 8 58 1
184408 92853 Significant Tree 6 Cercis occidentalis :: Western Redbud 136 3794 16th St 2 Front Yard : Yard Tree Private 2   12/14/2009 12:00:00 AM     Permit Number 53072 6001901 2106436 37.7639791186972 -122.436612788339 (37.7639791186972, -122.436612788339) 15 5 5 28862 3
185676 202298 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 132 Orsi Cir 1 : Tree Private 2     7 Width 2ft   6012798.01394 2093085.55544 37.7279348735704 -122.397986388177 (37.7279348735704, -122.397986388177) 10 3 8 58 1
187477 249864 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 233 Greenwich St 5 Front Yard : Yard Tree Private 2     6 Width 0ft   6011739.56844 2120436.06323 37.8029742071481 -122.403568982846 (37.8029742071481, -122.403568982846) 3 1 10 308 23
190761 49658 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 3630 Divisadero St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 1   Permit Number 46510 6000258.18089 2120685.13581 37.8030100766084 -122.443318322984 (37.8030100766084, -122.443318322984) 13 9 1 57 17
190928 27348 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 95X Nido Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   5999200.4791331 2112280.3747819 37.7798724518028 -122.446373519186 (37.7798724518028, -122.446373519186) 15 5 1 54 16
190965 202310 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 188 Orsi Cir 1 : Tree Private 2     5 Width 2ft   6013055.73834 2092895.13423 37.727426366308 -122.397082075775 (37.727426366308, -122.397082075775) 10 3 8 58 1
191110 45389 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 1630 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2013 12:00:00 AM 1   Permit Number 770770 6006335.45521 2117651.61484 37.7950254719105 -122.422072122943 (37.7950254719105, -122.422072122943) 13 9 10 28858 32
193130 189987 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 33 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012597.96632 2096223.24019 37.736539162453 -122.398898087577 (37.736539162453, -122.398898087577) 10 3 8 58 1
193598 32394 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 215 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 3   Permit Number 36935 6005700.60494 2096155.70406 37.7359669795973 -122.422740439745 (37.7359669795973, -122.422740439745) 2 7 7 28859 2

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