trees
417 rows where Supervisor Districts = 11 and qSpecies_id = 53 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193656 | 16998 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002629.22495 | 2109872.04506 | 37.7734550115897 | -122.434339751705 | (37.7734550115897, -122.434339751705) | 15 | 5 | 11 | 29492 | 9 | |||
193625 | 255507 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | ||||
193568 | 26953 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002643.91242 | 2114436.71459 | 37.7859892824562 | -122.43461540376 | (37.7859892824562, -122.43461540376) | 13 | 9 | 11 | 29490 | 27 | |||
192852 | 16949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 625 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003989.24409 | 2110039.43116 | 37.7739917148646 | -122.429647190447 | (37.7739917148646, -122.429647190447) | 7 | 9 | 11 | 29492 | 10 | |||
192777 | 48866 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 129 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | Permit Number 46075 | 6006370.62112219 | 2110394.65908683 | 37.7751016387897 | -122.421434823029 | (37.7751016387897, -122.421434823029) | 7 | 9 | 11 | 28852 | 10 | |||
192243 | 94600 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1709 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997540 | 2108126 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | 15 | 5 | 11 | 29492 | 9 | |||||
191412 | 2431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 490X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004657.78302 | 2110211.29448 | 37.7745014417711 | -122.427346845616 | (37.7745014417711, -122.427346845616) | 7 | 9 | 11 | 28852 | 10 | |||
191157 | 16897 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 385 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005198.99692 | 2110159.80887 | 37.7743906686767 | -122.425471016021 | (37.7743906686767, -122.425471016021) | 7 | 9 | 11 | 28852 | 10 | |||
191064 | 21654 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1698 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004474.7477956 | 2114689.3781886 | 37.7867867977452 | -122.428299224496 | (37.7867867977452, -122.428299224496) | 13 | 9 | 11 | 28858 | 27 | |||
190628 | 7233 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1045 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003367.24511 | 2111893.72513 | 37.7790479074603 | -122.431931222001 | (37.7790479074603, -122.431931222001) | 15 | 9 | 11 | 29490 | 41 | |||
190566 | 21751 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1787X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002537.7996519 | 2114344.6571005 | 37.7857304915222 | -122.434975938446 | (37.7857304915222, -122.434975938446) | 13 | 9 | 11 | 29490 | 13 | |||
189695 | 21726 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1942 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003284.347 | 2114523.85502 | 37.7862648839776 | -122.432405902047 | (37.7862648839776, -122.432405902047) | 13 | 9 | 11 | 29490 | 27 | |||
188563 | 10618 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 350 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006025.52151 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | 7 | 9 | 11 | 28852 | 10 | |||
188552 | 17045 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
188273 | 2450 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1805X Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6003959.520066 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | 13 | 9 | 11 | 29490 | 13 | |||
188066 | 9689 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 332 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006025.5202 | 2110969.11106 | 37.7766594813407 | -122.422669436188 | (37.7766594813407, -122.422669436188) | 7 | 9 | 11 | 28852 | 10 | |||
187860 | 22712 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
187443 | 22718 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
186128 | 21645 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1657 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1990 12:00:00 AM | 18 | 4X4 | 6004676.7022509 | 2114666.9735246 | 37.7867367053745 | -122.427598912468 | (37.7867367053745, -122.427598912468) | 13 | 9 | 11 | 28858 | 13 | ||
184850 | 2719 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2185X Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003092.7695 | 2114646.14799 | 37.786589804405 | -122.433077450713 | (37.786589804405, -122.433077450713) | 13 | 9 | 11 | 29490 | 27 | |||
184217 | 113003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
183127 | 7232 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1045 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003365.392 | 2111902.08022 | 37.7790707434033 | -122.431938229416 | (37.7790707434033, -122.431938229416) | 15 | 9 | 11 | 29490 | 41 | |||
183075 | 17003 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | 15 | 5 | 11 | 29492 | 9 | |||
182974 | 16988 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 879 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002804.94816 | 2109899.79468 | 37.773541177823 | -122.433733884114 | (37.773541177823, -122.433733884114) | 15 | 5 | 11 | 29492 | 9 | |||
182795 | 26424 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005277.15037 | 2111634.16402 | 37.7784433040001 | -122.425305605903 | (37.7784433040001, -122.425305605903) | 7 | 9 | 11 | 28852 | 10 | |||
182329 | 21698 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1890 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6003576.7245218 | 2114564.5327129 | 37.7863931493079 | -122.431397256992 | (37.7863931493079, -122.431397256992) | 13 | 9 | 11 | 29490 | 27 | |||
181893 | 7246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1700 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6003087.664 | 2114207.65389 | 37.7853855210138 | -122.433063773672 | (37.7853855210138, -122.433063773672) | 13 | 9 | 11 | 29490 | 13 | |||
181818 | 13305 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1377X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | 15 | 5 | 11 | 29492 | 9 | |||
181230 | 7271 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1761 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003011.13827 | 2114398.62455 | 37.7859055370085 | -122.433342180608 | (37.7859055370085, -122.433342180608) | 13 | 9 | 11 | 29490 | 13 | |||
180211 | 18159 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 6005423.15 | 2114537.67279 | 37.7864238707484 | -122.425007174907 | (37.7864238707484, -122.425007174907) | 13 | 9 | 11 | 28858 | 13 | |||
180149 | 112971 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601x COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5997795 | 2108483 | 37.7693654697431 | -122.450961770246 | (37.7693654697431, -122.450961770246) | 15 | 5 | 11 | 29492 | 9 | |||
178705 | 59665 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 993 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 12 | 2x2 | Permit Number 19087 | 6002914.43276984 | 2111641.44659541 | 37.7783295332017 | -122.433479648258 | (37.7783295332017, -122.433479648258) | 15 | 9 | 11 | 29492 | 41 | |
177966 | 106938 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1607 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5997889 | 2108175 | 37.7685251613651 | -122.450614421545 | (37.7685251613651, -122.450614421545) | 15 | 5 | 11 | 29492 | 9 | ||||
177601 | 17085 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1585 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999415.39608 | 2109426.2103 | 37.7720479186519 | -122.445424745443 | (37.7720479186519, -122.445424745443) | 15 | 5 | 11 | 29492 | 9 | |||
177482 | 255340 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1881 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6003626.50122 | 2114526.01983 | 37.7862902235864 | -122.431222292272 | (37.7862902235864, -122.431222292272) | 13 | 9 | 11 | 29490 | 13 | |||||
176974 | 113008 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
176749 | 6380 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
176167 | 16388 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 238 Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006262.13214 | 2114058.51032 | 37.7851555645201 | -122.422070450769 | (37.7851555645201, -122.422070450769) | 13 | 9 | 11 | 28858 | 41 | |||
175601 | 7197 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003395.68163 | 2111577.87165 | 37.7781822644093 | -122.431810290332 | (37.7781822644093, -122.431810290332) | 15 | 9 | 11 | 29492 | 41 | |||
174828 | 21667 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1773 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004123.7222039 | 2114590.0968475 | 37.7864943276059 | -122.429506607504 | (37.7864943276059, -122.429506607504) | 13 | 9 | 11 | 29490 | 13 | |||
174162 | 16730 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 19X Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003888.91549 | 2113509.70556 | 37.7835145469728 | -122.430241873385 | (37.7835145469728, -122.430241873385) | 7 | 9 | 11 | 29490 | 41 | |||
174129 | 16872 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 259 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6005773.57352 | 2110239.8238 | 37.7746428175577 | -122.423489134945 | (37.7746428175577, -122.423489134945) | 7 | 9 | 11 | 28852 | 10 | |||
173558 | 113006 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
173262 | 16934 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 534 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004202.21217 | 2110156.57626 | 37.7743254232669 | -122.428918851232 | (37.7743254232669, -122.428918851232) | 7 | 9 | 11 | 28852 | 10 | |||
173238 | 113007 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
172889 | 7892 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1187 Franklin St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006000.38049 | 2113895.86172 | 37.7846942050769 | -122.422964467171 | (37.7846942050769, -122.422964467171) | 13 | 9 | 11 | 28858 | 41 | |||
172861 | 117048 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2183 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6002170 | 2114323 | 37.7856501363162 | -122.436246868292 | (37.7856501363162, -122.436246868292) | 13 | 6 | 11 | 29490 | 13 | |||
172277 | 10647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 913 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6003471.55966 | 2110689.4075 | 37.775747062973 | -122.431484357932 | (37.775747062973, -122.431484357932) | 15 | 9 | 11 | 29492 | 10 | ||
172169 | 117345 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 395 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006014 | 2111158 | 37.7771774746178 | -122.422722714586 | (37.7771774746178, -122.422722714586) | 7 | 9 | 11 | 28852 | 10 | ||||
171101 | 17693 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1095X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6002343.2153394 | 2112268.6379219 | 37.7800192180629 | -122.435500577793 | (37.7800192180629, -122.435500577793) | 15 | 5 | 11 | 29490 | 41 | |||
170574 | 114952 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005348 | 2111368 | 37.7777164851071 | -122.42504156742 | (37.7777164851071, -122.42504156742) | 7 | 9 | 11 | 28852 | 10 | ||||
170119 | 103480 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | Permit Number 31998 | 5994182.5 | 2107061.8 | 37.765255754741 | -122.463353999562 | (37.765255754741, -122.463353999562) | 11 | 5 | 11 | 56 | 12 | ||
169890 | 21652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1697 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004490.7268551 | 2114641.118768 | 37.7866551936091 | -122.428240500008 | (37.7866551936091, -122.428240500008) | 13 | 9 | 11 | 28858 | 13 | |||
169006 | 17011 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1001 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002208.6674 | 2109818.85859 | 37.7732850945599 | -122.43579071263 | (37.7732850945599, -122.43579071263) | 15 | 5 | 11 | 29492 | 9 | |||
168743 | 7855 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 915 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006074.49976 | 2113274.48833 | 37.7829922485484 | -122.422663866925 | (37.7829922485484, -122.422663866925) | 7 | 9 | 11 | 28858 | 41 | |||
168672 | 9974 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 812X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003525.87553 | 2111110.58272 | 37.7769065842705 | -122.431326537326 | (37.7769065842705, -122.431326537326) | 7 | 9 | 11 | 29492 | 10 | |||
168453 | 17019 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1053 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001967.47701 | 2109780.334 | 37.7731656122234 | -122.436622263598 | (37.7731656122234, -122.436622263598) | 15 | 5 | 11 | 29492 | 9 | |||
166398 | 9620 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1165X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1990 12:00:00 AM | 50 | 3X3 | 6002862.99505 | 2112096.1743 | 37.779575183286 | -122.433690098242 | (37.779575183286, -122.433690098242) | 15 | 9 | 11 | 29490 | 41 | ||
166324 | 8202 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1323 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001450.33053 | 2111015.64115 | 37.7765280537514 | -122.438499661404 | (37.7765280537514, -122.438499661404) | 15 | 5 | 11 | 29492 | 10 | |||
165652 | 21672 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1781 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004087.4531427 | 2114585.0546301 | 37.7864784293602 | -122.429631729681 | (37.7864784293602, -122.429631729681) | 13 | 9 | 11 | 29490 | 13 | |||
165112 | 116511 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500x Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||||
164782 | 26423 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005252.46633 | 2111627.39845 | 37.7784233328254 | -122.425390515771 | (37.7784233328254, -122.425390515771) | 7 | 9 | 11 | 28852 | 10 | |||
164124 | 57410 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 109 Wilmot St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/1976 12:00:00 AM | 15 | Permit Number 770100 | 6002753.5601 | 2114939.9175 | 37.7873771736852 | -122.434272041026 | (37.7873771736852, -122.434272041026) | 13 | 9 | 11 | 29490 | 27 | ||
163968 | 16919 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 13x6 | 6004493.27484 | 2110185.04209 | 37.7744200538695 | -122.427914040239 | (37.7744200538695, -122.427914040239) | 7 | 9 | 11 | 28852 | 10 | |||
163768 | 9696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6005964.80411 | 2111186.62637 | 37.7772532999259 | -122.422894934036 | (37.7772532999259, -122.422894934036) | 7 | 9 | 11 | 28852 | 10 | |||
163074 | 110027 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1101X WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003707 | 2112516 | 37.7807757743573 | -122.430800292528 | (37.7807757743573, -122.430800292528) | 15 | 9 | 11 | 29490 | 41 | ||||
162862 | 58508 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | 3x3 | Permit Number 17683 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||
162853 | 105343 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2500X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999969.06573 | 2113691.86409 | 37.7837919048286 | -122.443816082596 | (37.7837919048286, -122.443816082596) | 15 | 6 | 11 | 29490 | 31 | |||||
162574 | 113000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
162520 | 10628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 805 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 6 | 3X4 | 6003942.23141 | 2110755.32974 | 37.775954734286 | -122.429860889744 | (37.775954734286, -122.429860889744) | 7 | 9 | 11 | 29492 | 10 | ||
161897 | 253634 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830 Oak St | 1 | Sidewalk: Property side : Cutout | tree | DPW 1 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.432999691851 | (37.7737452502421, -122.432999691851) | 15 | 5 | 11 | 29492 | 10 | |||||
161493 | 6285 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1480 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6003867.05631 | 2113210.81806 | 37.7826926384963 | -122.43029616652 | (37.7826926384963, -122.43029616652) | 7 | 9 | 11 | 29490 | 41 | |||
160258 | 6989 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 848 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15x3.5 | 6003368.38608 | 2110385.91832 | 37.7749079085756 | -122.431819586637 | (37.7749079085756, -122.431819586637) | 15 | 9 | 11 | 29492 | 10 | |||
159266 | 7227 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1025 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003385.45092 | 2111827.8386 | 37.7788680315263 | -122.431863535021 | (37.7788680315263, -122.431863535021) | 15 | 9 | 11 | 29490 | 41 | |||
158763 | 111774 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 215 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5998260 | 2109886 | 37.7732443583423 | -122.449454468346 | (37.7732443583423, -122.449454468346) | 15 | 5 | 11 | 29492 | 16 | |||
158220 | 9662 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6006086.53311 | 2110106.07673 | 37.7742932396102 | -122.422397038566 | (37.7742932396102, -122.422397038566) | 7 | 9 | 11 | 28852 | 10 | |||
156870 | 21690 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1881 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003627.3299403 | 2114521.0871369 | 37.7862767266181 | -122.431219072895 | (37.7862767266181, -122.431219072895) | 13 | 9 | 11 | 29490 | 13 | |||
156516 | 13310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 300X Lyon St | 3 | Median : Cutout | Tree | DPW 1 | 6 | 100 | 6000275.5456666 | 2109923.7813264 | 37.7734631881999 | -122.442485158742 | (37.7734631881999, -122.442485158742) | 15 | 5 | 11 | 29492 | 16 | |||
156343 | 113279 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5995790.34429445 | 2107089.36315796 | 37.7654239364323 | -122.457794878244 | (37.7654239364323, -122.457794878244) | 15 | 5 | 11 | 56 | 12 | ||||
156320 | 6133 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 900X ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006542 | 2113585 | 37.7838712020833 | -122.421068560353 | (37.7838712020833, -122.421068560353) | 7 | 9 | 11 | 28858 | 41 | |||
156308 | 7284 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1840 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6003030.41064 | 2114610.94925 | 37.7864896201648 | -122.433290680867 | (37.7864896201648, -122.433290680867) | 13 | 9 | 11 | 29490 | 27 | |||
156157 | 59335 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 201 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1980 12:00:00 AM | 4x4 | Permit Number 18682 | 6003287.79827449 | 2108952.35112135 | 37.7709671172915 | -122.431995967048 | (37.7709671172915, -122.431995967048) | 15 | 9 | 11 | 29492 | 9 | ||
155915 | 6134 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 900X Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006541.37151 | 2113590.32225 | 37.7838857802496 | -122.421071112727 | (37.7838857802496, -122.421071112727) | 7 | 9 | 11 | 28858 | 41 | |||
155645 | 110676 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1898 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001594 | 2114879 | 37.7871440264162 | -122.438279504546 | (37.7871440264162, -122.438279504546) | 13 | 6 | 11 | 29490 | 27 | ||||
155542 | 54199 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | 4x4 | Permit Number 9937 | 5995656.55399656 | 2107084.69972772 | 37.7654034448102 | -122.458257287589 | (37.7654034448102, -122.458257287589) | 15 | 5 | 11 | 56 | 12 | ||
155245 | 7236 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1065 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003355.08756 | 2111967.13899 | 37.7792487944095 | -122.431978523544 | (37.7792487944095, -122.431978523544) | 15 | 9 | 11 | 29490 | 41 | |||
155152 | 26943 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x6 | 6002846.96094 | 2114462.84733 | 37.7860725610737 | -122.43391478048 | (37.7860725610737, -122.43391478048) | 13 | 9 | 11 | 29490 | 27 | |||
154378 | 26949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002710.37506 | 2114446.07693 | 37.7860187618492 | -122.434386130989 | (37.7860187618492, -122.434386130989) | 13 | 9 | 11 | 29490 | 27 | |||
153860 | 94059 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1401X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5993648 | 2105942 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | 1 | 8 | 11 | 56 | 12 | |||
153353 | 7273 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002991.82699 | 2114526.90059 | 37.7862566549301 | -122.433418162207 | (37.7862566549301, -122.433418162207) | 13 | 9 | 11 | 29490 | 27 | |||
152847 | 120532 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||||
151746 | 10712 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 17X Hollis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003917.66999 | 2113282.5787 | 37.7828925420276 | -122.430126185708 | (37.7828925420276, -122.430126185708) | 7 | 9 | 11 | 29490 | 41 | |||
151645 | 116113 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002265 | 2109203 | 37.7715972993524 | -122.435551784305 | (37.7715972993524, -122.435551784305) | 15 | 5 | 11 | 29492 | 9 | ||||
151636 | 20239 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1757X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002551.4219946 | 2114246.4002369 | 37.7854614766008 | -122.434921779618 | (37.7854614766008, -122.434921779618) | 13 | 9 | 11 | 29490 | 13 | |||
151430 | 115906 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
150893 | 17691 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1095X Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6002343.2153394 | 2112268.6379219 | 37.7800192180629 | -122.435500577793 | (37.7800192180629, -122.435500577793) | 15 | 5 | 11 | 29490 | 41 | |||
149790 | 22717 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
148808 | 102824 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
148675 | 7262 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1727 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003024.60166 | 2114236.6744 | 37.7854616266825 | -122.433284024643 | (37.7854616266825, -122.433284024643) | 13 | 9 | 11 | 29490 | 13 | |||
148453 | 52589 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2006 12:00:00 AM | Permit Number 774039 | 5997878.20498734 | 2108284.16023065 | 37.7688242695831 | -122.450659631577 | (37.7688242695831, -122.450659631577) | 15 | 5 | 11 | 29492 | 9 |
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) );