trees
5,599 rows where qSpecies_id = 38 sorted by qCaretaker_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||||
| 6294 | 5744 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1759 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6x6 | 6005374.75018 | 2098167.61874 | 37.7414728539803 | -122.424010079215 | (37.7414728539803, -122.424010079215) | 2 | 7 | 5 | 28859 | 7 | |||
| 6941 | 7350 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2239 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002792.88059 | 2116041.24067 | 37.7904033576739 | -122.434214763813 | (37.7904033576739, -122.434214763813) | 13 | 9 | 1 | 29490 | 27 | |||
| 7342 | 26844 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | Permit Number 775213 | 6006969.72882 | 2110998.7322 | 37.7767940394414 | -122.419405236481 | (37.7767940394414, -122.419405236481) | 7 | 9 | 9 | 28852 | 36 | ||
| 7810 | 192162 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | Width 5ft | Permit Number 779453 | 6007414.0762 | 2109937.75552 | 37.7739058675964 | -122.417792878858 | (37.7739058675964, -122.417792878858) | 8 | 2 | 9 | 28853 | 19 | ||
| 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 | |||
| 9310 | 5671 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1421 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6005267.30914 | 2100058.51794 | 37.7466587657846 | -122.424516044105 | (37.7466587657846, -122.424516044105) | 2 | 7 | 5 | 28859 | 22 | |||
| 10227 | 189669 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 5ft | 6015848.0451 | 2104085.46802 | 37.7583077705949 | -122.388209616279 | (37.7583077705949, -122.388209616279) | 10 | 3 | 8 | 28856 | 29 | |||
| 10515 | 7366 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2360 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002774.54957 | 2116438.38146 | 37.7914927640347 | -122.434306592692 | (37.7914927640347, -122.434306592692) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | |||
| 11696 | 189660 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2573 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 4ft | 6015900.45488 | 2103484.96239 | 37.7566618134199 | -122.387986454936 | (37.7566618134199, -122.387986454936) | 10 | 3 | 8 | 28856 | 29 | |||
| 11786 | 4500 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1740 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004605.06487 | 2098773.28135 | 37.743092380112 | -122.426714507892 | (37.743092380112, -122.426714507892) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||
| 14778 | 18836 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2055 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004953.14987 | 2116100.26294 | 37.7906877916676 | -122.426744576702 | (37.7906877916676, -122.426744576702) | 13 | 9 | 1 | 28858 | 27 | |||
| 15009 | 12639 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 916 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 6x7 | 5992597.52584 | 2114847.07961 | 37.7865405872228 | -122.469402738454 | (37.7865405872228, -122.469402738454) | 11 | 6 | 1 | 54 | 11 | |||
| 16790 | 18335 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 315 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010354.70669 | 2106796.76065 | 37.7654464639991 | -122.407399223297 | (37.7654464639991, -122.407399223297) | 8 | 4 | 8 | 28853 | 19 | |||
| 17935 | 9914 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1900 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 126 | 3X3 | 6005235.69262 | 2116267.9294 | 37.7911641319684 | -122.425778932349 | (37.7911641319684, -122.425778932349) | 13 | 9 | 1 | 28858 | 27 | |||
| 18686 | 15429 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2015 12:00:00 AM | 15 | 4X4 | 6006871.98757 | 2105962.63928 | 37.7629606169132 | -122.419385998784 | (37.7629606169132, -122.419385998784) | 8 | 4 | 7 | 28859 | 19 | ||
| 18743 | 23497 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2525 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6005737.90239 | 2119081.40662 | 37.7989175974325 | -122.424241484673 | (37.7989175974325, -122.424241484673) | 13 | 9 | 1 | 57 | 17 | |||
| 18959 | 5496 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 750 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004967.46439 | 2103919.59639 | 37.7572434526456 | -122.425827662124 | (37.7572434526456, -122.425827662124) | 2 | 4 | 5 | 28862 | 3 | |||
| 19153 | 5691 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1545 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005346 | 2099395 | 37.7448413407379 | -122.424196757704 | (37.7448413407379, -122.424196757704) | 2 | 7 | 5 | 28859 | 22 | |||
| 19329 | 5668 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1410 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 6005180.48328 | 2100097.67272 | 37.7467613721366 | -122.42481906436 | (37.7467613721366, -122.42481906436) | 2 | 7 | 5 | 63 | 22 | |||
| 20679 | 18342 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 440 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6010303.69434 | 2106365.669 | 37.7642599290786 | -122.407545267797 | (37.7642599290786, -122.407545267797) | 8 | 4 | 8 | 28859 | 19 | |||
| 21170 | 11037 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1523 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007436.11305 | 2117588.78298 | 37.7949149677025 | -122.418259216898 | (37.7949149677025, -122.418259216898) | 5 | 1 | 10 | 28858 | 32 | |||
| 21723 | 226556 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 301 Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 6ft | 6004916.06592 | 2106558.95552 | 37.7644876032441 | -122.426193318382 | (37.7644876032441, -122.426193318382) | 8 | 4 | 5 | 28859 | 19 | |||
| 22328 | 18347 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 450 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010310.24011 | 2106203.39594 | 37.7638147305016 | -122.407511186202 | (37.7638147305016, -122.407511186202) | 8 | 4 | 8 | 28859 | 19 | |||
| 22342 | 23393 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1525 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6006200.49958 | 2115768.09459 | 37.7898461836045 | -122.422405194958 | (37.7898461836045, -122.422405194958) | 13 | 9 | 1 | 28858 | 41 | |||
| 22552 | 11442 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2200X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6005100.87554 | 2117226.15448 | 37.7937875569128 | -122.426313648558 | (37.7937875569128, -122.426313648558) | 13 | 9 | 1 | 28858 | 27 | |||
| 23037 | 247033 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 550x Valley St | 11 | Median : Yard | Tree | DPW 1 | 8 | 6002285.13208 | 2099166.02387 | 37.7440393230544 | -122.434764280156 | (37.7440393230544, -122.434764280156) | 2 | 7 | 5 | 63 | 22 | ||||
| 23290 | 11021 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1407 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007490.12051 | 2117192.20597 | 37.7938291055709 | -122.41804421508 | (37.7938291055709, -122.41804421508) | 5 | 1 | 10 | 28858 | 32 | |||
| 23914 | 8332 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1115 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6006224.34418 | 2114188.56599 | 37.785510534017 | -122.422210428763 | (37.785510534017, -122.422210428763) | 13 | 9 | 11 | 28858 | 41 | ||||
| 24172 | 9915 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1900 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6005229.57224 | 2116308.1912 | 37.7912743348887 | -122.42580297572 | (37.7912743348887, -122.42580297572) | 13 | 9 | 1 | 28858 | 27 | |||
| 25173 | 5666 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1386 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4x4 | 6005171.18394 | 2100267.5671 | 37.747227337869 | -122.424863305591 | (37.747227337869, -122.424863305591) | 2 | 7 | 5 | 63 | 22 | |||
| 26373 | 18941 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2782 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | Replace with P. Undulatum | 6001522.42549 | 2115673.82967 | 37.7893223527794 | -122.438584108286 | (37.7893223527794, -122.438584108286) | 13 | 6 | 1 | 29490 | 27 | ||
| 27274 | 11089 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1900 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2007 12:00:00 AM | 70 | 3X3 | 6007306.35542 | 2118856.39008 | 37.7983881953143 | -122.418798140138 | (37.7983881953143, -122.418798140138) | 5 | 1 | 10 | 28858 | 32 | ||
| 27512 | 5365 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 240 Dolores St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6004803.09071 | 2106888.71484 | 37.7653866572999 | -122.426607552398 | (37.7653866572999, -122.426607552398) | 8 | 4 | 5 | 28862 | 3 | |||
| 28455 | 4170 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3792 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/04/1980 12:00:00 AM | 60 | 3X3 | 6005296.89649 | 2100516.85549 | 37.7479189264148 | -122.42444632955 | (37.7479189264148, -122.42444632955) | 2 | 4 | 5 | 28859 | 19 | ||
| 28483 | 7930 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1355 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005883.49372 | 2114761.44957 | 37.7870642990196 | -122.423430414002 | (37.7870642990196, -122.423430414002) | 13 | 9 | 1 | 28858 | 41 | |||
| 29198 | 4240 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4023 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003709.8954 | 2100384.1668 | 37.7474648470367 | -122.429924644222 | (37.7474648470367, -122.429924644222) | 2 | 4 | 5 | 63 | 22 | |||
| 29236 | 5745 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1764 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X6 | 6005291.38109 | 2098122.5242 | 37.7413443273726 | -122.424295134606 | (37.7413443273726, -122.424295134606) | 2 | 7 | 5 | 63 | 7 | |||
| 29306 | 18354 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010402.26226 | 2106030.70072 | 37.7633456989776 | -122.407180733903 | (37.7633456989776, -122.407180733903) | 8 | 4 | 8 | 28859 | 19 | |||
| 29798 | 5646 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1297 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 37 | 3X3 | 6005225.48444 | 2100822.82631 | 37.7487550189501 | -122.424715032585 | (37.7487550189501, -122.424715032585) | 2 | 4 | 5 | 28859 | 19 | |||
| 30467 | 127441 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2101 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | 6005937.76794 | 2117668.55868 | 37.7950495575331 | -122.423449386982 | (37.7950495575331, -122.423449386982) | 13 | 9 | 1 | 28858 | 27 | |||
| 31203 | 23527 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2750 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005732.6493 | 2119830.06962 | 37.8009729386143 | -122.424312938499 | (37.8009729386143, -122.424312938499) | 13 | 9 | 1 | 28858 | 32 | |||
| 31273 | 11019 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1401 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007491.51177 | 2117162.78636 | 37.793748404921 | -122.418037314589 | (37.793748404921, -122.418037314589) | 5 | 1 | 10 | 28858 | 32 | |||
| 31531 | 18337 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 333 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010361.5425 | 2106726.15165 | 37.7652529703592 | -122.407370601478 | (37.7652529703592, -122.407370601478) | 8 | 4 | 8 | 28853 | 19 | |||
| 31955 | 5497 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 750 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6004967.58 | 2103908.86443 | 37.7572139917372 | -122.425826498419 | (37.7572139917372, -122.425826498419) | 2 | 4 | 5 | 28862 | 3 | |||
| 32218 | 23535 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2750 Van Ness Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005732.6393 | 2119914.78395 | 37.8012055419589 | -122.424319001733 | (37.8012055419589, -122.424319001733) | 13 | 9 | 1 | 28858 | 32 | |||
| 33196 | 5520 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 861 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 6X6 | 6005083.64012 | 2103377.03639 | 37.7557602745442 | -122.425387271322 | (37.7557602745442, -122.425387271322) | 2 | 4 | 5 | 28859 | 19 | |||
| 33393 | 18333 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 301 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010356.19775 | 2106841.91004 | 37.7655705173982 | -122.407397249285 | (37.7655705173982, -122.407397249285) | 8 | 4 | 8 | 28853 | 19 | |||
| 33484 | 5621 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1200 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/1997 12:00:00 AM | 12 | 3X3 | 6005112.05023 | 2101292.89014 | 37.7500392984813 | -122.425140730281 | (37.7500392984813, -122.425140730281) | 2 | 4 | 5 | 28862 | 22 | ||
| 33579 | 5623 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1206 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6005115.22639 | 2101256.47124 | 37.7499394800206 | -122.425127155905 | (37.7499394800206, -122.425127155905) | 2 | 4 | 5 | 28862 | 22 | |||
| 33764 | 5347 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 199 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004867.38316 | 2107258.6385 | 37.7664060136476 | -122.426411520896 | (37.7664060136476, -122.426411520896) | 8 | 4 | 5 | 28862 | 19 | |||
| 34214 | 4486 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1579 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004612.83847 | 2099652.68979 | 37.7455074734878 | -122.426750241536 | (37.7455074734878, -122.426750241536) | 2 | 7 | 5 | 63 | 22 | |||
| 34344 | 7889 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1187 Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005995.91896 | 2113921.74849 | 37.7847650320158 | -122.422981743131 | (37.7847650320158, -122.422981743131) | 13 | 9 | 11 | 28858 | 41 | |||
| 34689 | 251592 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1999X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6007220 | 2119146 | 37.799178528828 | -122.419117510386 | (37.799178528828, -122.419117510386) | 5 | 1 | 10 | 28858 | 32 | |||
| 35231 | 5673 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1427 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6005269.65277 | 2100030.15773 | 37.7465810274965 | -122.424505923113 | (37.7465810274965, -122.424505923113) | 2 | 7 | 5 | 28859 | 22 | |||
| 35358 | 5517 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 848 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 5x5 | 6004997.88514 | 2103403.44708 | 37.7558279467221 | -122.425685719428 | (37.7558279467221, -122.425685719428) | 2 | 4 | 5 | 28862 | 22 | |||
| 35539 | 137576 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1095 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6002354.5808 | 2112241.3971 | 37.7799450671147 | -122.435459310364 | (37.7799450671147, -122.435459310364) | 15 | 5 | 11 | 29490 | 41 | |||
| 36072 | 11107 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2016 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007247.08519 | 2119278.65713 | 37.799544297197 | -122.419033200434 | (37.799544297197, -122.419033200434) | 5 | 1 | 1 | 28858 | 32 | |||
| 36400 | 5543 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 913 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 5X5 | 6005108.77841 | 2103002.69982 | 37.7547338540067 | -122.425273698619 | (37.7547338540067, -122.425273698619) | 2 | 4 | 5 | 28859 | 19 | |||
| 36775 | 18299 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010303.43585 | 2107908.18204 | 37.7684953033331 | -122.407654929356 | (37.7684953033331, -122.407654929356) | 8 | 4 | 8 | 28853 | 19 | |||
| 37075 | 18301 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 66 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x8 | 6010214.22645 | 2107929.32419 | 37.768548360654 | -122.407964989486 | (37.768548360654, -122.407964989486) | 8 | 4 | 8 | 28853 | 19 | |||
| 37210 | 15030 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 900 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015814.84309 | 2096523.32446 | 37.7375418570556 | -122.387796805884 | (37.7375418570556, -122.387796805884) | 10 | 3 | 8 | 58 | 1 | |||
| 38139 | 18988 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2939 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000733.58986 | 2115514.6365 | 37.7888403449574 | -122.441301953043 | (37.7888403449574, -122.441301953043) | 13 | 6 | 1 | 29490 | 27 | |||
| 38202 | 5734 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1725 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 6005365.37115 | 2098326.96084 | 37.7419098417621 | -122.424053837524 | (37.7419098417621, -122.424053837524) | 2 | 7 | 5 | 28859 | 7 | |||
| 38411 | 5407 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 389 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6004934.31167 | 2106099.66089 | 37.7632275208513 | -122.426097511793 | (37.7632275208513, -122.426097511793) | 8 | 4 | 5 | 28859 | 19 | |||
| 38917 | 18900 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2590 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002437.15117 | 2115800.33038 | 37.7897216832563 | -122.435428321554 | (37.7897216832563, -122.435428321554) | 13 | 9 | 1 | 29490 | 27 | |||
| 38968 | 23530 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2750 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005733.88187 | 2119852.14358 | 37.8010336176693 | -122.424310244146 | (37.8010336176693, -122.424310244146) | 13 | 9 | 1 | 28858 | 32 | |||
| 39123 | 7931 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1355 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x4 | 6005884.64786 | 2114736.13414 | 37.7869948542636 | -122.42342462055 | (37.7869948542636, -122.42342462055) | 13 | 9 | 1 | 28858 | 41 | |||
| 39585 | 5620 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1198 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6005107.41501 | 2101411.03621 | 37.7503634384294 | -122.425165164842 | (37.7503634384294, -122.425165164842) | 2 | 4 | 5 | 28862 | 22 | |||
| 39921 | 9863 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1400X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6005484.31896 | 2114507.898 | 37.7863455716288 | -122.424793426501 | (37.7863455716288, -122.424793426501) | 13 | 9 | 1 | 28858 | 41 | |||
| 40768 | 9864 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1400X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3X3 | 6005479.12327 | 2114533.19407 | 37.7864147348969 | -122.424813202561 | (37.7864147348969, -122.424813202561) | 13 | 9 | 1 | 28858 | 41 | |||
| 41629 | 18515 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 634 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6010129.36296 | 2116007.85487 | 37.790725353638 | -122.408828552704 | (37.790725353638, -122.408828552704) | 5 | 1 | 10 | 28857 | 21 | |||
| 42730 | 7888 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1187 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005995.08562 | 2113950.47576 | 37.7848438629952 | -122.42298666871 | (37.7848438629952, -122.42298666871) | 13 | 9 | 11 | 28858 | 41 | |||
| 43245 | 11116 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2054 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007222.73261 | 2119440.06089 | 37.7999860999421 | -122.419128924277 | (37.7999860999421, -122.419128924277) | 5 | 1 | 1 | 28858 | 32 | |||
| 43373 | 18355 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 530 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010321.43167 | 2105923.74376 | 37.7630474954578 | -122.407452760863 | (37.7630474954578, -122.407452760863) | 8 | 4 | 8 | 28859 | 19 | |||
| 43660 | 127861 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1898 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6007317.93078 | 2118761.71757 | 37.7981289000733 | -122.418751368192 | (37.7981289000733, -122.418751368192) | 5 | 1 | 10 | 28858 | 32 | |||
| 43927 | 5500 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 760 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004969.04783 | 2103882.01013 | 37.7571403390842 | -122.425819510661 | (37.7571403390842, -122.425819510661) | 2 | 4 | 5 | 28862 | 3 | |||
| 44225 | 18839 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2055 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005013.40971 | 2116109.26217 | 37.7907159080697 | -122.426536721815 | (37.7907159080697, -122.426536721815) | 13 | 9 | 1 | 28858 | 27 | |||
| 44492 | 7890 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1187 Franklin St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006000.00879 | 2113898.80959 | 37.7847022782275 | -122.42296596272 | (37.7847022782275, -122.42296596272) | 13 | 9 | 11 | 28858 | 41 | |||
| 44626 | 9872 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1450X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6005450.68863 | 2114725.08205 | 37.7869400055262 | -122.424925236517 | (37.7869400055262, -122.424925236517) | 13 | 9 | 1 | 28858 | 41 | |||
| 45165 | 11127 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2124 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6007196.70195 | 2119630.59252 | 37.8005077858571 | -122.419232523471 | (37.8005077858571, -122.419232523471) | 5 | 1 | 1 | 28858 | 32 | |||
| 45553 | 11106 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2000 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007250.57138 | 2119242.43914 | 37.7994450480158 | -122.419018566659 | (37.7994450480158, -122.419018566659) | 5 | 1 | 1 | 28858 | 32 | |||
| 46082 | 189666 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2585 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 5ft | 6015923.45326 | 2103178.08659 | 37.7558204715491 | -122.387885505106 | (37.7558204715491, -122.387885505106) | 10 | 3 | 8 | 28856 | 29 | |||
| 46311 | 11102 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1987 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007225.03995 | 2119093.74122 | 37.7990353231697 | -122.419096361621 | (37.7990353231697, -122.419096361621) | 5 | 1 | 10 | 28858 | 32 | |||
| 46439 | 4454 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1401 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004556.83257 | 2100694.42254 | 37.7483646646087 | -122.427018083911 | (37.7483646646087, -122.427018083911) | 2 | 4 | 5 | 63 | 22 | |||
| 47441 | 18359 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 530 Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010330.56094 | 2105773.09746 | 37.7626343658127 | -122.407410564659 | (37.7626343658127, -122.407410564659) | 8 | 4 | 8 | 28859 | 19 | |||
| 47449 | 7869 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1000 Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6006093.62914 | 2113643.3001 | 37.7840059943141 | -122.422623903791 | (37.7840059943141, -122.422623903791) | 7 | 9 | 11 | 28858 | 41 | |||
| 47722 | 11124 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2115 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/14/2002 12:00:00 AM | 3 | 3X3 | 6007136.72657 | 2119705.75668 | 37.8007107898386 | -122.419445398399 | (37.8007107898386, -122.419445398399) | 5 | 1 | 1 | 28858 | 32 | ||
| 47786 | 4481 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1545 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004601.24999 | 2099921.13488 | 37.746243906725 | -122.426809426834 | (37.746243906725, -122.426809426834) | 2 | 7 | 5 | 63 | 22 | |||
| 47869 | 5681 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1475 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005285.89878 | 2099762.93917 | 37.7458482239295 | -122.424430742501 | (37.7458482239295, -122.424430742501) | 2 | 7 | 5 | 28859 | 22 | |||
| 48514 | 9903 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1800 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005280.32834 | 2115938.07678 | 37.7902609617121 | -122.425601007782 | (37.7902609617121, -122.425601007782) | 13 | 9 | 1 | 28858 | 27 | |||
| 48529 | 11040 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1529 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6007430.95213 | 2117616.83056 | 37.7949916888776 | -122.418279064023 | (37.7949916888776, -122.418279064023) | 5 | 1 | 10 | 28858 | 32 | |||
| 49062 | 15032 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 900 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015793.96455 | 2096498.22382 | 37.7374717791904 | -122.387867242574 | (37.7374717791904, -122.387867242574) | 10 | 3 | 8 | 58 | 1 | |||
| 49281 | 7866 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1000 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6006104.07556 | 2113580.8996 | 37.7838352472299 | -122.422583327268 | (37.7838352472299, -122.422583327268) | 7 | 9 | 11 | 28858 | 41 | |||
| 49626 | 85478 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1745 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6007333.51995 | 2118328.0568 | 37.7969390538357 | -122.418666655647 | (37.7969390538357, -122.418666655647) | 5 | 1 | 10 | 28858 | 32 | |||
| 49780 | 127128 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2301 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 4ft | 6002768.97397 | 2116209.3008 | 37.7908634508312 | -122.434309499277 | (37.7908634508312, -122.434309499277) | 13 | 9 | 1 | 29490 | 27 | |||
| 49920 | 189668 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2585 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 5ft | 6015920.29776 | 2103253.32542 | 37.7560268866495 | -122.387901667748 | (37.7560268866495, -122.387901667748) | 10 | 3 | 8 | 28856 | 29 |
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) );