trees
5,599 rows where qSpecies_id = 38 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 878 | 126969 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2701 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 5999145.58694 | 2118075.75757 | 37.795781916869 | -122.44698057642 | (37.795781916869, -122.44698057642) | 11 | 1 | 57 | 30 | ||||
| 10998 | 100001 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501X 01st St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Address is 100 1st Street | ||||||||||||||
| 143076 | 126968 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2701 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999144.26463 | 2118089.3771 | 37.7958192369226 | -122.446986132408 | (37.7958192369226, -122.446986132408) | 11 | 1 | 57 | 30 | ||||
| 286 | 18512 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 626 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6010135.39241 | 2115955.1821 | 37.7905810646201 | -122.408803973339 | (37.7905810646201, -122.408803973339) | 5 | 1 | 10 | 28857 | 21 | |||
| 913 | 128077 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009569.08364 | 2121877.54409 | 37.8068106763465 | -122.411181901328 | (37.8068106763465, -122.411181901328) | 3 | 1 | 10 | 308 | 23 | |||
| 1089 | 60912 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 149 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/1993 12:00:00 AM | 8 | 3x3 | Permit Number 32000 | 6012148.61414 | 2119800.05377 | 37.8012507194169 | -122.402108723944 | (37.8012507194169, -122.402108723944) | 3 | 1 | 10 | 28860 | 6 |
| 1097 | 73684 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1050 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007850.01602 | 2119957.29186 | 37.8014415915259 | -122.416994947282 | (37.8014415915259, -122.416994947282) | 5 | 1 | 10 | 308 | 32 | |||
| 1172 | 128195 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 149 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009814.56122 | 2122259.17064 | 37.8078722909471 | -122.410359337331 | (37.8078722909471, -122.410359337331) | 3 | 1 | 10 | 308 | 23 | |||
| 1323 | 128710 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011603.69347 | 2118016.75724 | 37.7963237889749 | -122.403868840184 | (37.7963237889749, -122.403868840184) | 3 | 1 | 10 | 28860 | 4 | |||
| 1402 | 128081 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009658.72737 | 2121889.09987 | 37.8068474325394 | -122.410872486877 | (37.8068474325394, -122.410872486877) | 3 | 1 | 10 | 308 | 23 | |||
| 1548 | 128066 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 262 North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009084.93005 | 2121810.40932 | 37.8065991773678 | -122.412852667211 | (37.8065991773678, -122.412852667211) | 3 | 1 | 10 | 308 | 23 | |||
| 1666 | 128592 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013155.79734 | 2117635.08876 | 37.7953624065092 | -122.398471405135 | (37.7953624065092, -122.398471405135) | 3 | 1 | 10 | 28860 | 6 | |||
| 1807 | 128108 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 102 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009837.41929 | 2121966.51853 | 37.8070700228254 | -122.410259554851 | (37.8070700228254, -122.410259554851) | 3 | 1 | 10 | 308 | 23 | |||
| 1848 | 128781 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 163 Maiden Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010952.71288 | 2115032.74516 | 37.7880940182581 | -122.405911070134 | (37.7880940182581, -122.405911070134) | 5 | 1 | 10 | 28857 | 6 | |||
| 2044 | 128391 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 295 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012104.01807 | 2116050.9072 | 37.7909539720909 | -122.401999334911 | (37.7909539720909, -122.401999334911) | 4 | 1 | 10 | 28854 | 6 | |||
| 2150 | 128068 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2005 12:00:00 AM | 13 | Width 4ft | Permit Number 48272 | 6009359.15547 | 2121848.2589 | 37.8067184913163 | -122.411906331309 | (37.8067184913163, -122.411906331309) | 3 | 1 | 10 | 308 | 23 | |
| 2178 | 56928 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 990 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 22 | Permit Number 14172 | 6008190.72994 | 2120000.83835 | 37.8015803191331 | -122.415819006365 | (37.8015803191331, -122.415819006365) | 5 | 1 | 10 | 308 | 32 | ||
| 2324 | 68584 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1335 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 15 | Permit Number 32481 | 6008309.92013 | 2116907.08816 | 37.793092348579 | -122.415187431374 | (37.793092348579, -122.415187431374) | 5 | 1 | 10 | 28858 | 21 | |
| 2531 | 128379 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 27 Waverly Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 782186 | 6010751.08445 | 2117044.71701 | 37.793607132226 | -122.406750521634 | (37.793607132226, -122.406750521634) | 3 | 1 | 10 | 28857 | 4 | ||
| 2647 | 127707 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1425 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6008864.13435 | 2117782.3752 | 37.7955268025682 | -122.413331737877 | (37.7955268025682, -122.413331737877) | 5 | 1 | 10 | 308 | 21 | |||
| 2696 | 37548 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 952 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 13 | Permit Number 39988 | 6008033.82968 | 2115183.28467 | 37.7883436871616 | -122.416020592081 | (37.7883436871616, -122.416020592081) | 13 | 1 | 10 | 28858 | 21 | |
| 2755 | 127908 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 894 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6007564.93188 | 2120607.69354 | 37.8032113898512 | -122.41802760281 | (37.8032113898512, -122.41802760281) | 5 | 1 | 1 | 308 | 32 | |||
| 2798 | 119275 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 350 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6012236.75747 | 2118139.41245 | 37.7966959176338 | -122.40168691852 | (37.7966959176338, -122.40168691852) | 3 | 1 | 10 | 28860 | 4 | ||
| 2847 | 128308 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1150 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012007.52553 | 2119595.1365 | 37.8006801903879 | -122.402582537171 | (37.8006801903879, -122.402582537171) | 3 | 1 | 10 | 28860 | 6 | |||
| 3164 | 249333 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 840 Post St | 4 | : | Tree | Private 2 | 15 | Width 4ft | 6008047.50765 | 2114838.3401 | 37.7873973224712 | -122.415948831592 | (37.7873973224712, -122.415948831592) | 13 | 1 | 10 | 28858 | 21 | |||
| 3384 | 112797 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 741 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009912.30354 | 2118803.0369 | 37.7983880829054 | -122.409776957039 | (37.7983880829054, -122.409776957039) | 3 | 1 | 10 | 308 | 4 | |||
| 3413 | 128074 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2019 12:00:00 AM | 3 | Width 4ft | 6009478.77374 | 2121864.7268 | 37.8067704181858 | -122.411493531709 | (37.8067704181858, -122.411493531709) | 3 | 1 | 10 | 308 | 23 | ||
| 3481 | 128267 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2 Lombard St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6011926.44398 | 2120867.47841 | 37.8041692046961 | -122.402952654037 | (37.8041692046961, -122.402952654037) | 3 | 1 | 10 | 28860 | 6 | |||
| 3761 | 58790 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 350 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/13/1979 12:00:00 AM | 5 | Permit Number 18035 | 6012539.98809 | 2116868.26339 | 37.793222561422 | -122.400548327356 | (37.793222561422, -122.400548327356) | 4 | 1 | 10 | 28854 | 6 | |
| 3931 | 128405 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 251 Sutter St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6011177.50321 | 2115572.36471 | 37.7895882544408 | -122.405171343593 | (37.7895882544408, -122.405171343593) | 5 | 1 | 10 | 28857 | 6 | |||
| 4608 | 128323 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 149 Union St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6012158.21016 | 2119822.6074 | 37.8013131818191 | -122.402077103775 | (37.8013131818191, -122.402077103775) | 3 | 1 | 10 | 28860 | 6 | ||||
| 5232 | 127794 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2229 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6008462.92143 | 2120654.02887 | 37.8033891147652 | -122.414923354455 | (37.8033891147652, -122.414923354455) | 5 | 1 | 10 | 308 | 32 | |||
| 5367 | 128547 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 530 California St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6011621.44747 | 2116740.16032 | 37.792819551831 | -122.40371753735 | (37.792819551831, -122.40371753735) | 4 | 1 | 10 | 28854 | 6 | |||
| 5396 | 128492 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 201 Montgomery St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6011956.55611 | 2116131.94021 | 37.7911682382735 | -122.402515250798 | (37.7911682382735, -122.402515250798) | 4 | 1 | 10 | 28854 | 6 | |||
| 5571 | 127724 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 6 Leroy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6008350.29303 | 2116463.97857 | 37.7918779472632 | -122.415016360531 | (37.7918779472632, -122.415016360531) | 5 | 1 | 10 | 28858 | 21 | |||
| 5769 | 127718 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1377 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008134.11977 | 2116552.38078 | 37.7921085280447 | -122.415770585055 | (37.7921085280447, -122.415770585055) | 5 | 1 | 10 | 28858 | 21 | |||
| 5930 | 128735 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 545 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011426.2676 | 2118320.12222 | 37.7971468422023 | -122.404504139281 | (37.7971468422023, -122.404504139281) | 3 | 1 | 10 | 308 | 4 | |||
| 5961 | 128358 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1335 Battery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6012159.58757 | 2120622.92627 | 37.803510739994 | -122.402128634953 | (37.803510739994, -122.402128634953) | 3 | 1 | 10 | 28860 | 6 | |||
| 6024 | 128476 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 109 Front St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 5ft | 6013054.34541 | 2116659.14888 | 37.7926770542453 | -122.398753923573 | (37.7926770542453, -122.398753923573) | 4 | 1 | 10 | 28860 | 6 | |||
| 6026 | 128070 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6009396.36006 | 2121851.96105 | 37.8067307436876 | -122.41177783889 | (37.8067307436876, -122.41177783889) | 3 | 1 | 10 | 308 | 23 | |||
| 6064 | 128753 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 145 Geary St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010888.72367 | 2114838.04786 | 37.7875558468704 | -122.406118740704 | (37.7875558468704, -122.406118740704) | 5 | 1 | 10 | 28857 | 6 | |||
| 6165 | 128151 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 580 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007611.87437 | 2121662.99743 | 37.806111628806 | -122.417940009725 | (37.806111628806, -122.417940009725) | 5 | 1 | 10 | 308 | 23 | |||
| 6261 | 128069 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009374.1078 | 2121849.01591 | 37.8067214087259 | -122.411854639205 | (37.8067214087259, -122.411854639205) | 3 | 1 | 10 | 308 | 23 | |||
| 6281 | 128011 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 590 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008173.68388 | 2121395.11526 | 37.8054076943845 | -122.415976787008 | (37.8054076943845, -122.415976787008) | 5 | 1 | 10 | 308 | 23 | |||
| 6462 | 48434 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1190 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45810 | 6009120.00947 | 2116723.6961 | 37.7926342914851 | -122.412371495743 | (37.7926342914851, -122.412371495743) | 3 | 1 | 10 | 28857 | 21 |
| 6504 | 64373 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 376 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 9 | Permit Number 25212 | 6011164.54643 | 2119369.06968 | 37.8000123673464 | -122.405483677229 | (37.8000123673464, -122.405483677229) | 3 | 1 | 10 | 308 | 23 | |
| 6661 | 128698 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012762.04961 | 2117890.12021 | 37.7960407192648 | -122.399851762841 | (37.7960407192648, -122.399851762841) | 3 | 1 | 10 | 28860 | 6 | |||
| 7290 | 103105 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010638.43235 | 2115205.50204 | 37.7885507857476 | -122.407010612771 | (37.7885507857476, -122.407010612771) | 5 | 1 | 10 | 28852 | 6 | |||
| 8017 | 249355 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 625 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008323.0201 | 2114666.64303 | 37.7869413697974 | -122.414983455249 | (37.7869413697974, -122.414983455249) | 13 | 1 | 9 | 28858 | 36 | |||
| 8051 | 127739 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1301 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008381.5529 | 2116915.61445 | 37.7931197850904 | -122.41494018075 | (37.7931197850904, -122.41494018075) | 5 | 1 | 10 | 28858 | 21 | |||
| 8253 | 11057 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1630 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007426.31744 | 2117960.00612 | 37.7959337026338 | -122.418319444503 | (37.7959337026338, -122.418319444503) | 5 | 1 | 10 | 28858 | 32 | |||
| 8393 | 127867 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2044 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6007226.91182 | 2119423.24121 | 37.7999401526838 | -122.419113268885 | (37.7999401526838, -122.419113268885) | 5 | 1 | 1 | 28858 | 32 | |||
| 8631 | 128082 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009683.35171 | 2121893.27188 | 37.8068602685411 | -122.41078756392 | (37.8068602685411, -122.41078756392) | 3 | 1 | 10 | 308 | 23 | |||
| 8793 | 128179 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 211 Beach St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009178.96771 | 2122171.51863 | 37.8075959706319 | -122.412552773896 | (37.8075959706319, -122.412552773896) | 3 | 1 | 10 | 308 | 23 | |||
| 8948 | 128780 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 116 Maiden Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6011134.63349 | 2115083.13634 | 37.7882425530045 | -122.405285203167 | (37.7882425530045, -122.405285203167) | 5 | 1 | 10 | 28857 | 6 | |||
| 8976 | 128727 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 150 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011307.13002 | 2118182.76086 | 37.7967630223487 | -122.404906710889 | (37.7967630223487, -122.404906710889) | 3 | 1 | 10 | 308 | 4 | |||
| 9057 | 64002 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1022 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | 19 | Permit Number 24749 | 6007961.58195 | 2119970.38672 | 37.8014838218701 | -122.416609806295 | (37.8014838218701, -122.416609806295) | 5 | 1 | 10 | 308 | 32 | |
| 9065 | 128399 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 316 Sutter St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 6010737.08277 | 2115568.6338 | 37.7895533787223 | -122.406694896775 | (37.7895533787223, -122.406694896775) | 5 | 1 | 10 | 28857 | 6 | |||
| 9480 | 128144 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 580 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007778.14218 | 2121686.09097 | 37.8061843938561 | -122.417366248573 | (37.8061843938561, -122.417366248573) | 5 | 1 | 10 | 308 | 23 | |||
| 9582 | 127979 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 160 Bay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009886.24296 | 2121622.25615 | 37.8061275009418 | -122.410066269842 | (37.8061275009418, -122.410066269842) | 3 | 1 | 10 | 308 | 23 | |||
| 9781 | 113450 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 21X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008324.74095 | 2116562.67984 | 37.7921475208351 | -122.415111760598 | (37.7921475208351, -122.415111760598) | 5 | 1 | 10 | 28858 | 21 | |||
| 9788 | 128384 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 109 Trenton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010084.71998 | 2117858.53397 | 37.7958043693257 | -122.40911365939 | (37.7958043693257, -122.40911365939) | 3 | 1 | 10 | 308 | 4 | |||
| 10171 | 128630 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012042.35717 | 2118440.81507 | 37.7975126468404 | -122.402380794936 | (37.7975126468404, -122.402380794936) | 3 | 1 | 10 | 308 | 23 | |||
| 10190 | 128389 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 295 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012038.5922 | 2116040.80306 | 37.79092257676 | -122.402224996381 | (37.79092257676, -122.402224996381) | 4 | 1 | 10 | 28854 | 6 | |||
| 10355 | 128113 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2300 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009769.6912 | 2122058.41551 | 37.8073185522658 | -122.410500436454 | (37.8073185522658, -122.410500436454) | 3 | 1 | 10 | 308 | 23 | |||
| 10654 | 128380 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 15 Waverly Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010746 | 2116993 | 37.7934648453026 | -122.406764467868 | (37.7934648453026, -122.406764467868) | 3 | 1 | 10 | 28857 | 4 | |||
| 10669 | 113451 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 21X Leroy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008325.83409 | 2116548.49106 | 37.7921086233576 | -122.415106973525 | (37.7921086233576, -122.415106973525) | 5 | 1 | 10 | 28858 | 21 | |||
| 11011 | 249339 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 839 Post St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6008120.77004 | 2114802.70738 | 37.7873036023197 | -122.415692834155 | (37.7873036023197, -122.415692834155) | 13 | 1 | 9 | 28858 | 36 | |||
| 11132 | 19204 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 630 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012243.07343 | 2117875.47251 | 37.7959715542054 | -122.401646502996 | (37.7959715542054, -122.401646502996) | 3 | 1 | 10 | 28860 | 4 | |||
| 11298 | 127916 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1175 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1990 12:00:00 AM | 13 | Width 4ft | 6007863.00532 | 2121226.60678 | 37.8049275409425 | -122.417039987112 | (37.8049275409425, -122.417039987112) | 5 | 1 | 1 | 308 | 32 | ||
| 11377 | 66090 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1024 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 16 | Permit Number 29134 | 6007982.68967 | 2119627.22736 | 37.8005427793916 | -122.416512442105 | (37.8005427793916, -122.416512442105) | 5 | 1 | 1 | 308 | 32 | |
| 11991 | 54423 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 735 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 15 | Permit Number 10197 | 6011692.51449 | 2118000.35932 | 37.796283725966 | -122.403560344851 | (37.796283725966, -122.403560344851) | 3 | 1 | 10 | 28860 | 4 | ||
| 11995 | 127689 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1020 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009869.61301 | 2116828.44156 | 37.7929639334768 | -122.409785225409 | (37.7929639334768, -122.409785225409) | 3 | 1 | 10 | 28857 | 21 | |||
| 12004 | 72032 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1050 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6007830.36811 | 2119954.20617 | 37.8014320137479 | -122.417062719267 | (37.8014320137479, -122.417062719267) | 5 | 1 | 10 | 308 | 32 | |||
| 12010 | 128071 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009416.46616 | 2121854.31268 | 37.8067383285777 | -122.411708423825 | (37.8067383285777, -122.411708423825) | 3 | 1 | 10 | 308 | 23 | |||
| 12350 | 62535 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1250 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/1986 12:00:00 AM | 16 | Permit Number 22718 | 6007046.83163 | 2118802.59844 | 37.798225881165 | -122.419692354914 | (37.798225881165, -122.419692354914) | 5 | 1 | 10 | 28858 | 32 | |
| 12460 | 106116 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 615 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008342 | 2114560 | 37.7866496204263 | -122.414910238271 | (37.7866496204263, -122.414910238271) | 13 | 1 | 9 | 28858 | 36 | |||
| 12667 | 128102 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2201 Grant Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010206.19487 | 2122052.60554 | 37.8073270607527 | -122.408989401833 | (37.8073270607527, -122.408989401833) | 3 | 1 | 10 | 308 | 23 | |||
| 12693 | 72442 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 640 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009698.8624 | 2115604.67168 | 37.7895941872619 | -122.410289589507 | (37.7895941872619, -122.410289589507) | 5 | 1 | 10 | 28857 | 21 | |||
| 12804 | 128534 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 California St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6012182.93636 | 2116816.58192 | 37.7930607374112 | -122.40178012248 | (37.7930607374112, -122.40178012248) | 4 | 1 | 10 | 28854 | 6 | |||
| 13328 | 11025 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1432 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2019 12:49:00 PM | 3 | 3X3 | 6007519.86638 | 2117318.51464 | 37.7941775919798 | -122.417950249398 | (37.7941775919798, -122.417950249398) | 5 | 1 | 10 | 28858 | 32 | ||
| 13331 | 116006 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 901x Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 5x4 | 6012340.70136 | 2119306.19591 | 37.7999054244574 | -122.401409287026 | (37.7999054244574, -122.401409287026) | 3 | 1 | 10 | 28860 | 6 | |||
| 13585 | 11032 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6007492.86428 | 2117507.22815 | 37.794694232707 | -122.418057064576 | (37.794694232707, -122.418057064576) | 5 | 1 | 10 | 28858 | 32 | |||
| 13815 | 127886 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1041 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007944.67087 | 2119227.24756 | 37.7994423968049 | -122.416615652791 | (37.7994423968049, -122.416615652791) | 5 | 1 | 10 | 308 | 32 | |||
| 14047 | 128080 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009637.33282 | 2121886.34956 | 37.8068386812172 | -122.410946332908 | (37.8068386812172, -122.410946332908) | 3 | 1 | 10 | 308 | 23 | |||
| 14255 | 128145 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 580 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007754.46725 | 2121683.60014 | 37.8061762226282 | -122.41744800324 | (37.8061762226282, -122.41744800324) | 5 | 1 | 10 | 308 | 23 | |||
| 14405 | 11035 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1516 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6007484.17478 | 2117558.36602 | 37.7948341555154 | -122.418090758582 | (37.7948341555154, -122.418090758582) | 5 | 1 | 10 | 28858 | 32 | |||
| 14467 | 121481 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 974 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6007930.82264 | 2115167.72637 | 37.7882951759371 | -122.416375878271 | (37.7882951759371, -122.416375878271) | 13 | 1 | 10 | 28858 | 21 | |||
| 14567 | 128480 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Pine St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6012292.28897 | 2116471.0493 | 37.7921180887322 | -122.401377460022 | (37.7921180887322, -122.401377460022) | 4 | 1 | 10 | 28854 | 6 | |||
| 14745 | 128030 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2601 Jones St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007872.77059 | 2121403.52137 | 37.8054138529431 | -122.41701873613 | (37.8054138529431, -122.41701873613) | 5 | 1 | 10 | 308 | 23 | |||
| 14817 | 104471 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 717 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2013 12:00:00 AM | 15 | Permit Number 767241 | 6012439.90278 | 2118592.87775 | 37.797952358665 | -122.401015863303 | (37.797952358665, -122.401015863303) | 3 | 1 | 10 | 28860 | 6 | ||
| 15053 | 128006 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 444 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008599.60953 | 2121451.88752 | 37.8055875138213 | -122.414506829842 | (37.8055875138213, -122.414506829842) | 3 | 1 | 10 | 308 | 23 | |||
| 15151 | 128556 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 505 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012249 | 2117377 | 37.7946031984867 | -122.401590943664 | (37.7946031984867, -122.401590943664) | 3 | 1 | 10 | 28860 | 4 | |||
| 15447 | 128076 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/2015 12:00:00 AM | 7 | Width 4ft | 6009546.7837 | 2121872.26218 | 37.8067949229139 | -122.411258701628 | (37.8067949229139, -122.411258701628) | 3 | 1 | 10 | 308 | 23 | ||
| 15584 | 128196 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 149 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009829.55437 | 2122260.48779 | 37.8078767479704 | -122.410307542669 | (37.8078767479704, -122.410307542669) | 3 | 1 | 10 | 308 | 23 | |||
| 15656 | 30489 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 947 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1956 12:00:00 AM | 16 | Permit Number 149 | 6008994.77228 | 2115613.22786 | 37.7895781874332 | -122.41272628189 | (37.7895781874332, -122.41272628189) | 5 | 1 | 10 | 28858 | 21 | ||
| 15742 | 128051 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 451 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008583.62119 | 2121741.55075 | 37.8063819578114 | -122.414582670576 | (37.8063819578114, -122.414582670576) | 3 | 1 | 10 | 308 | 23 | |||
| 15883 | 127489 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1000 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | Width 4ft | 6007666.04374 | 2115128.71351 | 37.7881731631139 | -122.41728920634 | (37.7881731631139, -122.41728920634) | 13 | 1 | 10 | 28858 | 21 | ||
| 15939 | 128288 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 101 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011508.83416 | 2120753.62103 | 37.8038332521574 | -122.404389812943 | (37.8038332521574, -122.404389812943) | 3 | 1 | 10 | 28860 | 6 | |||
| 15973 | 73076 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1308 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6008053.57424 | 2116951.24629 | 37.7931991862554 | -122.416077534465 | (37.7931991862554, -122.416077534465) | 5 | 1 | 10 | 28858 | 21 |
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) );