trees
5,599 rows where qSpecies_id = 38 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194491 | 226546 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 53 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005228 | 2105709 | 37.7621714532816 | -122.425053942898 | (37.7621714532816, -122.425053942898) | 8 | 4 | 5 | 28859 | 19 | |||
| 194041 | 189694 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 135 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6014025.31878 | 2106375.11367 | 37.764493476707 | -122.394673790286 | (37.764493476707, -122.394673790286) | 14 | 3 | 8 | 28856 | 29 | |||
| 194030 | 225450 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4655 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000188.4302 | 2105162.38752 | 37.7603846235606 | -122.442444597441 | (37.7603846235606, -122.442444597441) | 2 | 4 | 5 | 28862 | 3 | |||
| 194017 | 63348 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3006 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1987 12:00:00 AM | 23 | Permit Number 23923 | 6000305.98274 | 2115831.15811 | 37.7896850628532 | -122.442804147299 | (37.7896850628532, -122.442804147299) | 13 | 6 | 1 | 29490 | 27 | ||
| 194002 | 127201 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2210 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5999364.79655 | 2116438.82859 | 37.7912998648598 | -122.446104272498 | (37.7912998648598, -122.446104272498) | 13 | 6 | 1 | 29490 | 27 | |||
| 193995 | 127629 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 11 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008224.12562 | 2111892.42462 | 37.7793184769176 | -122.415129163391 | (37.7793184769176, -122.415129163391) | 7 | 10 | 9 | 28852 | 36 | |||
| 193989 | 128154 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200 Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008962.56758 | 2122188.36917 | 37.8076300909227 | -122.413302872331 | (37.8076300909227, -122.413302872331) | 3 | 1 | 10 | 308 | 23 | |||
| 193956 | 190301 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 250 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6014105.6984 | 2115295.72685 | 37.7889919364847 | -122.395020634494 | (37.7889919364847, -122.395020634494) | 6 | 2 | 9 | 28855 | 6 | |||
| 193838 | 124353 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 944 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992588.76079 | 2111400.81961 | 37.7770775924802 | -122.469182144559 | (37.7770775924802, -122.469182144559) | 11 | 6 | 2 | 54 | 11 | |||
| 193802 | 68946 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 763 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 11 | Permit Number 32935 | 5989112.30351 | 2110126.59265 | 37.7733774247171 | -122.481114833001 | (37.7733774247171, -122.481114833001) | 11 | 6 | 2 | 55 | 26 | |
| 193798 | 120076 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 139 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987696.52329 | 2115044.25708 | 37.786797534515 | -122.486373264348 | (37.786797534515, -122.486373264348) | 11 | 6 | 1 | 55 | 33 | |||
| 193781 | 189663 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1177 Indiana St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 4ft | 6015055.47575 | 2103171.59722 | 37.7557545305733 | -122.390886823368 | (37.7557545305733, -122.390886823368) | 10 | 3 | 8 | 28856 | 29 | |||
| 193771 | 111874 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2101 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010193.52203 | 2106874.28761 | 37.7656503124352 | -122.407962194393 | (37.7656503124352, -122.407962194393) | 8 | 4 | 8 | 28853 | 19 | |||
| 193720 | 127461 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 640 Sutter St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009485.61853 | 2115389.16428 | 37.7889905002694 | -122.411012165973 | (37.7889905002694, -122.411012165973) | 5 | 1 | 10 | 28857 | 21 | |||
| 193679 | 101838 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3815-3817 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003483 | 2105926 | 37.762668556024 | -122.431104719068 | (37.762668556024, -122.431104719068) | 15 | 4 | 5 | 28862 | 3 | |||||
| 193659 | 55098 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2636 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 17 | Permit Number 10996 | 5999209.50883 | 2119443.11122 | 37.7995399561535 | -122.446857835114 | (37.7995399561535, -122.446857835114) | 13 | 9 | 1 | 57 | 17 | ||
| 193650 | 190176 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 20 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014042.69587 | 2116920.12511 | 37.7934486518725 | -122.395352457345 | (37.7934486518725, -122.395352457345) | 12 | 2 | 9 | 28855 | 6 | |||
| 193641 | 226542 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1301 Potrero Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6010638.49947 | 2101723.23315 | 37.7515315723365 | -122.40606018675 | (37.7515315723365, -122.40606018675) | 10 | 4 | 8 | 28859 | 19 | |||
| 193548 | 127752 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1033 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008599.68492 | 2116159.43674 | 37.7910557609695 | -122.414131906064 | (37.7910557609695, -122.414131906064) | 5 | 1 | 10 | 28858 | 21 | |||
| 193533 | 189712 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 500 Wisconsin St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 6012644.68977 | 2104989.85234 | 37.7606130001075 | -122.399351785657 | (37.7606130001075, -122.399351785657) | 10 | 3 | 8 | 28856 | 29 | |||
| 193491 | 5510 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 811 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6X5 | 6005073.33558 | 2103604.24932 | 37.7563835658713 | -122.425439076749 | (37.7563835658713, -122.425439076749) | 2 | 4 | 5 | 28859 | 19 | |||
| 193403 | 128034 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1198 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6007780.32969 | 2121388.1783 | 37.8053665243059 | -122.417337553004 | (37.8053665243059, -122.417337553004) | 5 | 1 | 10 | 308 | 23 | |||
| 193390 | 127605 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 91 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007017.09322 | 2114140.64244 | 37.7854236307263 | -122.4194643435 | (37.7854236307263, -122.4194643435) | 13 | 9 | 9 | 28858 | 36 | |||
| 193383 | 127039 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2170 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6000427.34776 | 2120305.09631 | 37.8019762348628 | -122.442705614899 | (37.8019762348628, -122.442705614899) | 13 | 9 | 1 | 57 | 17 | |||
| 193345 | 224839 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 13 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6005053.69678 | 2101632.56928 | 37.750968682163 | -122.425366689421 | (37.750968682163, -122.425366689421) | 2 | 4 | 5 | 28862 | 22 | |||
| 193315 | 127228 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2701 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000043.49229 | 2117775.1022 | 37.7950076545368 | -122.44385205714 | (37.7950076545368, -122.44385205714) | 13 | 9 | 1 | 57 | 27 | |||
| 193281 | 255776 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 281 Geary St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | Width 4ft | 6010453.10569 | 2114773.50548 | 37.7873542539382 | -122.407621346845 | (37.7873542539382, -122.407621346845) | 5 | 1 | 10 | 28852 | 6 | ||||
| 193256 | 128000 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2445 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008809.46269 | 2121658.5666 | 37.8061667896209 | -122.413795229572 | (37.8061667896209, -122.413795229572) | 3 | 1 | 10 | 308 | 23 | |||
| 193241 | 107702 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2708 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 774015 | 5999903.41146 | 2118843.95794 | 37.7979344576772 | -122.444413608215 | (37.7979344576772, -122.444413608215) | 13 | 9 | 1 | 57 | 17 | ||
| 193180 | 127069 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3252 Pierce St | 9 | : | Tree | Private 2 | 9 | Width 3ft | 6001380.49031 | 2119587.4899 | 37.8000601663034 | -122.439355830906 | (37.8000601663034, -122.439355830906) | 13 | 9 | 1 | 57 | 17 | |||
| 193106 | 11097 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1930 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007278.45191 | 2119022.53652 | 37.7988428206086 | -122.418906485047 | (37.7988428206086, -122.418906485047) | 5 | 1 | 10 | 28858 | 32 | |||
| 193088 | 127708 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1423 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008869.00929 | 2117756.9989 | 37.79545739919 | -122.413313074261 | (37.79545739919, -122.413313074261) | 5 | 1 | 10 | 308 | 21 | |||
| 193066 | 84822 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 843 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2007 12:00:00 AM | 6 | Permit No. 49293 | 6011663.91592 | 2118255.45586 | 37.7969825621465 | -122.403677260299 | (37.7969825621465, -122.403677260299) | 3 | 1 | 10 | 308 | 4 | ||
| 193017 | 16389 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 238 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006251.97502 | 2114055.0165 | 37.7851453984752 | -122.422105343005 | (37.7851453984752, -122.422105343005) | 13 | 9 | 11 | 28858 | 41 | |||
| 192937 | 112196 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 325 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 6011775.52702 | 2112050.94015 | 37.7799526626161 | -122.402854465186 | (37.7799526626161, -122.402854465186) | 6 | 2 | 9 | 28856 | 34 | ||||
| 192917 | 116984 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1946 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5999962.55028 | 2115671.17728 | 37.7892262125735 | -122.44398088592 | (37.7892262125735, -122.44398088592) | 13 | 6 | 1 | 29490 | 27 | |||
| 192876 | 190273 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 215 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013715.30364 | 2115281.57086 | 37.7889313509552 | -122.396370365805 | (37.7889313509552, -122.396370365805) | 12 | 2 | 9 | 28855 | 6 | |||
| 192850 | 117339 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 372 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 5x5 | 6006074.72787 | 2111092.91986 | 37.77700220641 | -122.422508011759 | (37.77700220641, -122.422508011759) | 7 | 9 | 11 | 28852 | 10 | |||
| 192787 | 225456 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3687 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002389.36899 | 2106450.1305 | 37.7640456583921 | -122.434924677857 | (37.7640456583921, -122.434924677857) | 15 | 5 | 5 | 28862 | 3 | |||
| 192695 | 127342 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2100 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004073.57554 | 2117011.46762 | 37.7931399595966 | -122.429852879225 | (37.7931399595966, -122.429852879225) | 13 | 9 | 1 | 29490 | 27 | |||
| 192689 | 189805 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2301 Alameda St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010182.35255 | 2107832.16681 | 37.7682798042076 | -122.408068386371 | (37.7682798042076, -122.408068386371) | 8 | 4 | 8 | 28853 | 19 | |||
| 192671 | 65391 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2526 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/1989 12:00:00 AM | 10 | Permit Number 28233 | 6000728.61763 | 2118262.89695 | 37.7963860661294 | -122.441516449422 | (37.7963860661294, -122.441516449422) | 13 | 9 | 1 | 57 | 17 | ||
| 192659 | 127450 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 653 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009646.94829 | 2115652.6262 | 37.7897229486103 | -122.410472595231 | (37.7897229486103, -122.410472595231) | 5 | 1 | 10 | 28857 | 21 | |||
| 192639 | 67944 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 755 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 13 | Permit Number 31658 | 5989111.58697 | 2110178.85549 | 37.7735208823708 | -122.481121139176 | (37.7735208823708, -122.481121139176) | 11 | 6 | 2 | 55 | 26 | |
| 192619 | 42247 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 565 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 6 | Permit Number 42494 | 6009939.10598 | 2111727.36867 | 37.7789615000051 | -122.409184654573 | (37.7789615000051, -122.409184654573) | 14 | 2 | 9 | 28853 | 34 | |
| 192593 | 128432 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 315 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6011879.89076 | 2116678.01469 | 37.7926633485817 | -122.402818933841 | (37.7926633485817, -122.402818933841) | 4 | 1 | 10 | 28854 | 6 | |||
| 192564 | 64481 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 424 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1988 12:00:00 AM | 17 | Permit Number 25355 | 6014254.66485 | 2112974.61889 | 37.7826269900883 | -122.394342645496 | (37.7826269900883, -122.394342645496) | 6 | 2 | 9 | 28856 | 6 | ||
| 192446 | 189761 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2221 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011808.20116 | 2101339.45032 | 37.7505431418758 | -122.401988213004 | (37.7505431418758, -122.401988213004) | 10 | 3 | 8 | 28856 | 1 | |||
| 192436 | 128202 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012466.36374 | 2119845.72411 | 37.8013938491992 | -122.401012374832 | (37.8013938491992, -122.401012374832) | 3 | 1 | 10 | 28860 | 6 | |||
| 192430 | 19207 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 630 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012222.627 | 2118025.44923 | 37.7963822134098 | -122.401727798999 | (37.7963822134098, -122.401727798999) | 3 | 1 | 10 | 28860 | 4 | |||
| 192404 | 119927 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3618 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5987430.85621 | 2111895.98827 | 37.7781377959569 | -122.487061094459 | (37.7781377959569, -122.487061094459) | 11 | 6 | 2 | 55 | 26 | |||
| 192396 | 127487 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 811 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007766.86858 | 2115168.94295 | 37.788289295259 | -122.41694322007 | (37.788289295259, -122.41694322007) | 13 | 1 | 10 | 28858 | 21 | |||
| 192348 | 192069 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 15th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011186.3676 | 2107464.93063 | 37.7673276208966 | -122.404569722336 | (37.7673276208966, -122.404569722336) | 8 | 2 | 8 | 28853 | 20 | |||
| 192302 | 127504 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 281 Geary St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010412.84164 | 2114771.87381 | 37.7873475198242 | -122.407760537619 | (37.7873475198242, -122.407760537619) | 5 | 1 | 10 | 28852 | 6 | |||
| 192288 | 127515 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 335 Powell St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010244.58304 | 2114855.01998 | 37.7875663986225 | -122.408348546747 | (37.7875663986225, -122.408348546747) | 5 | 1 | 10 | 28852 | 36 | |||
| 192220 | 127690 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 751 Powell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 5ft | 6010018.43014 | 2116421.07594 | 37.7918537447071 | -122.409241548384 | (37.7918537447071, -122.409241548384) | 5 | 1 | 10 | 28857 | 21 | |||
| 192199 | 23392 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1525 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6006199.96721 | 2115782.74327 | 37.7898863752061 | -122.422408078183 | (37.7898863752061, -122.422408078183) | 13 | 9 | 1 | 28858 | 41 | |||
| 192152 | 224800 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 112 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005087.96789 | 2099627.4927 | 37.7454651397064 | -122.425105524505 | (37.7454651397064, -122.425105524505) | 2 | 7 | 5 | 63 | 22 | |||
| 192148 | 127603 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 7 Ada Ct | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008101.77795 | 2114166.01166 | 37.7855543229052 | -122.415713443917 | (37.7855543229052, -122.415713443917) | 13 | 10 | 9 | 28858 | 36 | |||
| 192085 | 127860 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1898 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 6ft | 6007322.60643 | 2118731.77235 | 37.798046941256 | -122.418733064272 | (37.798046941256, -122.418733064272) | 5 | 1 | 10 | 28858 | 32 | |||
| 192045 | 128785 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 159 Maiden Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6011134.89541 | 2115059.37486 | 37.7881773242683 | -122.405282623008 | (37.7881773242683, -122.405282623008) | 5 | 1 | 10 | 28857 | 6 | |||
| 192042 | 190295 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200 Spear St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014925.69453 | 2115995.23175 | 37.7909581791127 | -122.392232475358 | (37.7909581791127, -122.392232475358) | 6 | 2 | 9 | 28855 | 6 | |||
| 192008 | 128317 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 199 Union St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6012075.22601 | 2119800.93909 | 37.8012490538605 | -122.402362742861 | (37.8012490538605, -122.402362742861) | 3 | 1 | 10 | 28860 | 6 | ||||
| 191990 | 127087 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1400 Jefferson St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6002472.473 | 2121628.13466 | 37.8057253214215 | -122.435723237152 | (37.8057253214215, -122.435723237152) | 13 | 9 | 1 | 57 | 17 | |||
| 191982 | 127503 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 281 Geary St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010396.37791 | 2114769.7566 | 37.7873407848018 | -122.407817349602 | (37.7873407848018, -122.407817349602) | 5 | 1 | 10 | 28852 | 6 | |||
| 191958 | 128126 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 544 North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007909.88685 | 2121704.37316 | 37.8062420035271 | -122.416911618789 | (37.8062420035271, -122.416911618789) | 5 | 1 | 10 | 308 | 23 | |||
| 191903 | 126913 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 Maple St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5996751.76506 | 2114774.43591 | 37.7865803225681 | -122.455024925759 | (37.7865803225681, -122.455024925759) | 11 | 6 | 1 | 54 | 31 | |||
| 191813 | 104053 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2465 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6002918.10064 | 2116474.72915 | 37.7916007123503 | -122.433812507839 | (37.7916007123503, -122.433812507839) | 13 | 9 | 1 | 29490 | 27 | ||||
| 191734 | 127918 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2357 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6007985.31426 | 2120592.40966 | 37.8031930751628 | -122.416571769498 | (37.8031930751628, -122.416571769498) | 5 | 1 | 1 | 308 | 32 | |||
| 191673 | 128117 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2300 Stockton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009760.33787 | 2122129.71279 | 37.8075137923806 | -122.410537843773 | (37.8075137923806, -122.410537843773) | 3 | 1 | 10 | 308 | 23 | |||
| 191626 | 190341 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 101 Howard St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6014814.94374 | 2116051.97196 | 37.7911078245033 | -122.392619642478 | (37.7911078245033, -122.392619642478) | 6 | 2 | 9 | 28855 | 6 | |||
| 191614 | 126772 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2828 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5999364.86166 | 2118767.33647 | 37.7976933332465 | -122.44627162196 | (37.7976933332465, -122.44627162196) | 13 | 9 | 1 | 57 | 17 | |||
| 191596 | 128326 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 149 Union St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012193.5058 | 2119805.81438 | 37.801269042182 | -122.401953783358 | (37.801269042182, -122.401953783358) | 3 | 1 | 10 | 28860 | 6 | |||
| 191579 | 224957 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 124 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6004310.22061 | 2101047.59532 | 37.7493204469801 | -122.427896024581 | (37.7493204469801, -122.427896024581) | 2 | 4 | 5 | 28862 | 22 | |||
| 191533 | 224975 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3817 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003474.96834 | 2105929.48831 | 37.7626776789577 | -122.431132746685 | (37.7626776789577, -122.431132746685) | 15 | 4 | 5 | 28862 | 3 | |||
| 191525 | 127096 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1550 Bay St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003346.89879 | 2120714.49093 | 37.8032663249393 | -122.432631856298 | (37.8032663249393, -122.432631856298) | 13 | 9 | 1 | 57 | 17 | |||
| 191520 | 247220 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 898 Duboce Ave | 4 | : | Tree | Private 2 | 17 | Width 3ft | 6001660.99493 | 2108696.8913 | 37.7701733267561 | -122.437604817625 | (37.7701733267561, -122.437604817625) | 15 | 5 | 5 | 29492 | 9 | |||
| 191518 | 128519 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 131 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013423.03303 | 2117285.99148 | 37.7944187514889 | -122.397522223793 | (37.7944187514889, -122.397522223793) | 3 | 1 | 10 | 28860 | 6 | |||
| 191488 | 65969 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 960 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 11 | Permit Number 28993 | 6007235.97107 | 2120561.38544 | 37.8030657194716 | -122.419162697418 | (37.8030657194716, -122.419162697418) | 5 | 1 | 1 | 28858 | 32 | ||
| 191356 | 4238 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4019 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003737.20071 | 2100388.64531 | 37.7474786902894 | -122.429830543661 | (37.7474786902894, -122.429830543661) | 2 | 4 | 5 | 63 | 22 | |||
| 191352 | 99180 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 350 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008539.94575 | 2122132.39014 | 37.807452650197 | -122.414761495367 | (37.807452650197, -122.414761495367) | 3 | 1 | 10 | 308 | 23 | |||
| 191351 | 128544 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 530 California St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6011688.45461 | 2116749.36363 | 37.7928485648657 | -122.403486336041 | (37.7928485648657, -122.403486336041) | 4 | 1 | 10 | 28854 | 6 | |||
| 191296 | 127693 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 751 Powell St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 6010029.21707 | 2116335.71472 | 37.7916199677494 | -122.409198199232 | (37.7916199677494, -122.409198199232) | 5 | 1 | 10 | 28857 | 21 | |||
| 191272 | 108573 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 730 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6010371.59698 | 2116204.37275 | 37.7912785095549 | -122.408004296158 | (37.7912785095549, -122.408004296158) | 5 | 1 | 10 | 28857 | 21 | |||
| 191232 | 218946 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 15 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 3ft | 5995278.15169 | 2100133.50673 | 37.7462954873605 | -122.459062719878 | (37.7462954873605, -122.459062719878) | 1 | 8 | 4 | 59 | 40 | |||
| 191180 | 127231 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2417 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000752.62158 | 2116656.00453 | 37.7919753285389 | -122.441318034725 | (37.7919753285389, -122.441318034725) | 13 | 6 | 1 | 29490 | 27 | |||
| 191175 | 224905 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 426 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003200.72037 | 2095197.12224 | 37.7331935693215 | -122.431315130093 | (37.7331935693215, -122.431315130093) | 2 | 7 | 5 | 28861 | 25 | |||
| 191160 | 128472 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 111 Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6013037.58365 | 2116796.15514 | 37.7930523071764 | -122.398821540008 | (37.7930523071764, -122.398821540008) | 4 | 1 | 10 | 28860 | 6 | |||
| 191155 | 190136 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 78 Dorman Ave | 1 | : | Tree | Private 2 | 4 | 6011218.70135 | 2097332.49038 | 37.7395079765181 | -122.403744847972 | (37.7395079765181, -122.403744847972) | 10 | 3 | 8 | 58 | 1 | ||||
| 191114 | 127526 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 535 Post St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6009680.02816 | 2115011.25309 | 37.7879637469644 | -122.410312837863 | (37.7879637469644, -122.410312837863) | 5 | 1 | 10 | 28852 | 36 | |||
| 191032 | 127021 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2825 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999429.21732 | 2118381.68026 | 37.7966380993167 | -122.446021181451 | (37.7966380993167, -122.446021181451) | 13 | 9 | 1 | 57 | 17 | |||
| 191031 | 192164 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | Width 5ft | Permit Number 779453 | 6007314.84465 | 2109842.28548 | 37.7736381448041 | -122.418129368272 | (37.7736381448041, -122.418129368272) | 8 | 2 | 9 | 28853 | 19 | ||
| 190942 | 128658 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6013064.64697 | 2118875.86345 | 37.7987642000757 | -122.398873927287 | (37.7987642000757, -122.398873927287) | 3 | 1 | 10 | 28860 | 6 | |||
| 190923 | 190289 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014862.08015 | 2116059.42107 | 37.7911308957228 | -122.392457072044 | (37.7911308957228, -122.392457072044) | 6 | 2 | 9 | 28855 | 6 | |||
| 190920 | 98535 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1805X Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x6 | Permit Number 779899 | 5999990.233 | 2115142.7171 | 37.7877767779168 | -122.443847124338 | (37.7877767779168, -122.443847124338) | 13 | 6 | 1 | 29490 | 27 | ||
| 190883 | 224937 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1145 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6003219.89495 | 2101585.52774 | 37.7507357406785 | -122.431704792847 | (37.7507357406785, -122.431704792847) | 2 | 4 | 5 | 28862 | 22 | |||
| 190869 | 176451 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 26 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004464.43685 | 2093359.77432 | 37.7282201592217 | -122.426815314696 | (37.7282201592217, -122.426815314696) | 9 | 7 | 6 | 28861 | 5 | |||
| 190835 | 64352 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2861 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 22 | Permit Number 25188 | 6002930.40848 | 2118499.38272 | 37.7971605874513 | -122.433914705894 | (37.7971605874513, -122.433914705894) | 13 | 9 | 1 | 57 | 17 | ||
| 190780 | 127294 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2753 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002585.68226 | 2117512.73305 | 37.7944319346497 | -122.435036941128 | (37.7944319346497, -122.435036941128) | 13 | 9 | 1 | 29490 | 27 | |||
| 190589 | 15265 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1517 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007548.55895 | 2109980.53522 | 37.7740308976381 | -122.417330711836 | (37.7740308976381, -122.417330711836) | 8 | 2 | 9 | 28853 | 19 |
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) );