trees
81 rows where qSpecies_id = 136
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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) );