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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16148 | 255011 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6009525.60238 | 2121869.50761 | 37.806786171612 | -122.411331809333 | (37.806786171612, -122.411331809333) | 3 | 1 | 10 | 308 | 23 | ||||
16457 | 128095 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2201 Grant Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010183.25462 | 2122212.57297 | 37.8077650063215 | -122.4090800868 | (37.8077650063215, -122.4090800868) | 3 | 1 | 10 | 308 | 23 | |||
16586 | 128376 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 737 Pine St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6010409.07251 | 2116157.67498 | 37.7911523868246 | -122.407871336803 | (37.7911523868246, -122.407871336803) | 5 | 1 | 10 | 28857 | 21 | |||
16938 | 128083 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009715.0017 | 2121896.66309 | 37.8068713545053 | -122.410678271985 | (37.8068713545053, -122.410678271985) | 3 | 1 | 10 | 308 | 23 | |||
17015 | 128215 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1073 Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012642.5381 | 2119643.26949 | 37.800847783557 | -122.400388500743 | (37.800847783557, -122.400388500743) | 3 | 1 | 10 | 28860 | 6 | |||
17027 | 128284 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1701 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011235.87378 | 2121347.94939 | 37.8054498743769 | -122.405376293687 | (37.8054498743769, -122.405376293687) | 3 | 1 | 10 | 308 | 23 | |||
17597 | 255778 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 281 Geary St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2018 12:00:00 AM | 3 | Width 4ft | 6010453.10569 | 2114773.50548 | 37.7873542539382 | -122.407621346845 | (37.7873542539382, -122.407621346845) | 5 | 1 | 10 | 28852 | 6 | ||
17607 | 128073 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009455.6728 | 2121862.0115 | 37.8067616668876 | -122.411573285385 | (37.8067616668876, -122.411573285385) | 3 | 1 | 10 | 308 | 23 | |||
17895 | 128132 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2600 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007860.12277 | 2121829.76573 | 37.8065835003791 | -122.417092726973 | (37.8065835003791, -122.417092726973) | 5 | 1 | 10 | 308 | 23 | |||
17937 | 66603 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1225 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 7 | Permit Number 29798 | 6008039.621 | 2115833.32115 | 37.790128854013 | -122.416046607673 | (37.790128854013, -122.416046607673) | 13 | 1 | 10 | 28858 | 21 | |
18083 | 128072 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009436.58528 | 2121857.30143 | 37.806747663529 | -122.411639008733 | (37.806747663529, -122.411639008733) | 3 | 1 | 10 | 308 | 23 | |||
18264 | 128172 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 211 Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008992.41136 | 2122145.2973 | 37.80751350191 | -122.413196542783 | (37.80751350191, -122.413196542783) | 3 | 1 | 10 | 308 | 23 | |||
18520 | 127917 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2357 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6007984.65596 | 2120608.29341 | 37.8032366509171 | -122.416575173411 | (37.8032366509171, -122.416575173411) | 5 | 1 | 1 | 308 | 32 | |||
18548 | 128058 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2615 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008303.85065 | 2121803.98955 | 37.8065376772268 | -122.415555292742 | (37.8065376772268, -122.415555292742) | 5 | 1 | 10 | 308 | 23 | |||
18561 | 128739 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6011591.37219 | 2118340.96654 | 37.7972133012131 | -122.403934300929 | (37.7972133012131, -122.403934300929) | 3 | 1 | 10 | 308 | 4 | |||
18678 | 128079 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/2015 12:00:00 AM | 13 | Width 4ft | 6009619.79049 | 2121884.15798 | 37.8068316799992 | -122.411006886985 | (37.8068316799992, -122.411006886985) | 3 | 1 | 10 | 308 | 23 | ||
18998 | 128251 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 40 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6013196.09483 | 2118964.28561 | 37.7990143096206 | -122.398425279818 | (37.7990143096206, -122.398425279818) | 3 | 1 | 10 | 28860 | 6 | |||
19726 | 128500 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 233 Pine St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6012641.59188 | 2116463.62131 | 37.7921171759089 | -122.400168337697 | (37.7921171759089, -122.400168337697) | 4 | 1 | 10 | 28854 | 6 | |||
20203 | 128149 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 580 North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007659.25914 | 2121669.67904 | 37.8061326414825 | -122.417776500385 | (37.8061326414825, -122.417776500385) | 5 | 1 | 10 | 308 | 23 | |||
20267 | 128613 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 50 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6013782.36429 | 2118074.90802 | 37.7966049314193 | -122.396334206783 | (37.7966049314193, -122.396334206783) | 3 | 1 | 10 | 28860 | 6 | |||
20287 | 128494 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 369 Pine St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6012086.37369 | 2116397.02316 | 37.7919033396242 | -122.40208472734 | (37.7919033396242, -122.40208472734) | 4 | 1 | 10 | 28854 | 6 | |||
20530 | 93479 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 113X Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 1.5x3 | Tree 4 on Leroy | 6008317.25099 | 2116630.80353 | 37.792334150853 | -122.415142500331 | (37.792334150853, -122.415142500331) | 5 | 1 | 10 | 28858 | 21 | ||
20603 | 127714 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1255 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008937.90701 | 2117277.04325 | 37.7941434267417 | -122.413040722668 | (37.7941434267417, -122.413040722668) | 5 | 1 | 10 | 28857 | 21 | |||
20893 | 128240 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1050 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012332.77903 | 2119745.98947 | 37.8011125493603 | -122.40146762695 | (37.8011125493603, -122.40146762695) | 3 | 1 | 10 | 28860 | 6 | |||
21106 | 128163 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2802 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007818.97512 | 2122158.67 | 37.8074842730556 | -122.417258448614 | (37.8074842730556, -122.417258448614) | 5 | 1 | 10 | 308 | 23 | |||
21159 | 48871 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 535 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | 12 | 3x3 | Permit Number 46080 | 6011476.38501 | 2118326.98884 | 37.797168496982 | -122.404331203243 | (37.797168496982, -122.404331203243) | 3 | 1 | 10 | 308 | 4 | |
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 | |||
21227 | 128297 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1445 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011798.72736 | 2120726.21758 | 37.8037742044892 | -122.403384685668 | (37.8037742044892, -122.403384685668) | 3 | 1 | 10 | 28860 | 6 | |||
21236 | 128249 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 40 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6013230.32013 | 2118971.72942 | 37.7990366550722 | -122.398307370585 | (37.7990366550722, -122.398307370585) | 3 | 1 | 10 | 28860 | 6 | |||
21674 | 112696 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6010197.93258 | 2122016.89458 | 37.8072285445333 | -122.409015474098 | (37.8072285445333, -122.409015474098) | 3 | 1 | 10 | 308 | 23 | |||
21888 | 127758 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1005 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008623.20133 | 2116011.5553 | 37.7906510354728 | -122.4140400736 | (37.7906510354728, -122.4140400736) | 5 | 1 | 10 | 28858 | 21 | |||
21939 | 128415 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 555 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011478.27052 | 2116657.13994 | 37.7925835984915 | -122.404207093202 | (37.7925835984915, -122.404207093202) | 4 | 1 | 10 | 28854 | 6 | |||
22072 | 128239 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1000 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6012346.02917 | 2119632.64296 | 37.8008020665329 | -122.401413805224 | (37.8008020665329, -122.401413805224) | 3 | 1 | 10 | 28860 | 6 | |||
22200 | 128551 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 580 California St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6011511.00883 | 2116724.70141 | 37.7927709353884 | -122.404098573787 | (37.7927709353884, -122.404098573787) | 4 | 1 | 10 | 28854 | 6 | |||
22248 | 127998 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2445 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008801.60078 | 2121712.94158 | 37.8063156481148 | -122.413826285851 | (37.8063156481148, -122.413826285851) | 3 | 1 | 10 | 308 | 23 | |||
22659 | 53616 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 580 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1986 12:00:00 AM | 8 | Permit Number 23021 | 6011569.0599 | 2116730.65971 | 37.7927905387988 | -122.403898132903 | (37.7927905387988, -122.403898132903) | 4 | 1 | 10 | 28854 | 6 | ||
22750 | 113458 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 14 Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008346.99172 | 2116484.00265 | 37.7919327429628 | -122.415029201053 | (37.7919327429628, -122.415029201053) | 5 | 1 | 10 | 28858 | 21 | |||
22755 | 128713 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 555 Jackson St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6011289.01038 | 2117973.50016 | 37.7961874301503 | -122.404954668136 | (37.7961874301503, -122.404954668136) | 3 | 1 | 10 | 28857 | 4 | |||
23010 | 127943 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 101 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012601.19681 | 2119174.02118 | 37.7995570351977 | -122.400498579547 | (37.7995570351977, -122.400498579547) | 3 | 1 | 10 | 28860 | 6 | ||
23083 | 113950 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1416 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6009767.57864 | 2118598.02538 | 37.7978170601548 | -122.410263269057 | (37.7978170601548, -122.410263269057) | 3 | 1 | 10 | 308 | 4 | |||
23136 | 112697 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010180.49666 | 2122013.17318 | 37.807217349764 | -122.409075552403 | (37.807217349764, -122.409075552403) | 3 | 1 | 10 | 308 | 23 | |||
23167 | 11044 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1550 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3x3 | 6007464.94523 | 2117711.8455 | 37.795254489665 | -122.418168182118 | (37.795254489665, -122.418168182118) | 5 | 1 | 10 | 28858 | 32 | |||
23227 | 128622 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 218 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012788.30553 | 2118217.83281 | 37.7969420036353 | -122.399783934202 | (37.7969420036353, -122.399783934202) | 3 | 1 | 10 | 28860 | 6 | |||
23249 | 128737 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 535 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6011489.30967 | 2118331.34924 | 37.7971811918121 | -122.40428678752 | (37.7971811918121, -122.40428678752) | 3 | 1 | 10 | 308 | 4 | |||
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 | |||
23400 | 127728 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 50 Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6008337.80395 | 2116548.86512 | 37.7921103230909 | -122.415065584015 | (37.7921103230909, -122.415065584015) | 5 | 1 | 10 | 28858 | 21 | |||
23545 | 58731 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1050 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/1981 12:00:00 AM | 15 | Permit Number 19424 | 6012335.49363 | 2119717.01394 | 37.8010331410233 | -122.401456195674 | (37.8010331410233, -122.401456195674) | 3 | 1 | 10 | 28860 | 6 | ||
24107 | 128314 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1150 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011984.40166 | 2119726.28847 | 37.8010390109056 | -122.402671784073 | (37.8010390109056, -122.402671784073) | 3 | 1 | 10 | 28860 | 6 | |||
24549 | 128574 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 201 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012708.35093 | 2117826.92537 | 37.7958642075089 | -122.400033131824 | (37.7958642075089, -122.400033131824) | 3 | 1 | 10 | 28860 | 6 | |||
24651 | 128467 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 339 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012650.63962 | 2116819.58835 | 37.7930950816316 | -122.40016204337 | (37.7930950816316, -122.40016204337) | 4 | 1 | 10 | 28854 | 6 | |||
25155 | 128263 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2 Lombard St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6012051.14949 | 2120876.60895 | 37.8042012376618 | -122.402521741194 | (37.8042012376618, -122.402521741194) | 3 | 1 | 10 | 28860 | 6 | |||
25275 | 128324 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 149 Union St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012167.10136 | 2119825.45961 | 37.8013215095468 | -122.402046536739 | (37.8013215095468, -122.402046536739) | 3 | 1 | 10 | 28860 | 6 | ||||
25397 | 128625 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 218 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012718.96955 | 2118206.80786 | 37.7969078662509 | -122.400023080099 | (37.7969078662509, -122.400023080099) | 3 | 1 | 10 | 28860 | 6 | |||
25605 | 127983 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 240 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6009710.13286 | 2121599.23274 | 37.806054412145 | -122.410674103647 | (37.806054412145, -122.410674103647) | 3 | 1 | 10 | 308 | 23 | |||
25661 | 128775 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 34 Maiden Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 6011432.60647 | 2115120.86654 | 37.7883628058523 | -122.404256917436 | (37.7883628058523, -122.404256917436) | 5 | 1 | 10 | 28857 | 6 | |||
25841 | 128774 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 25 Maiden Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6011584.77672 | 2115124.15017 | 37.7883803237385 | -122.403730661161 | (37.7883803237385, -122.403730661161) | 5 | 1 | 10 | 28857 | 6 | |||
25922 | 128482 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Pine St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6012259.81227 | 2116468.66713 | 37.7921097358123 | -122.401489663026 | (37.7921097358123, -122.401489663026) | 4 | 1 | 10 | 28854 | 6 | |||
25937 | 127703 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1520 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008863.24129 | 2118118.5693 | 37.7964498586313 | -122.413358615027 | (37.7964498586313, -122.413358615027) | 3 | 1 | 10 | 308 | 21 | |||
25957 | 93476 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 113X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Tree 1 on Leroy. | 6008309.35619 | 2116677.55783 | 37.7924620830088 | -122.415173127645 | (37.7924620830088, -122.415173127645) | 5 | 1 | 10 | 28858 | 21 | ||
26042 | 128656 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013029.0227 | 2118872.45132 | 37.7987528461303 | -122.398996959964 | (37.7987528461303, -122.398996959964) | 3 | 1 | 10 | 28860 | 6 | |||
26150 | 128611 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 50 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6013816.82419 | 2118081.68623 | 37.7966254602636 | -122.3962154423 | (37.7966254602636, -122.3962154423) | 3 | 1 | 10 | 28860 | 6 | |||
26173 | 127483 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 952 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007980.9662 | 2115174.73021 | 37.7883172264026 | -122.416202885554 | (37.7883172264026, -122.416202885554) | 13 | 1 | 10 | 28858 | 21 | |||
26432 | 128672 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6013392.30755 | 2117975.00239 | 37.796308901584 | -122.397676888287 | (37.796308901584, -122.397676888287) | 3 | 1 | 10 | 28860 | 6 | |||
26588 | 127872 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1089 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006645.59841 | 2120434.4244 | 37.8026838520455 | -122.421196678795 | (37.8026838520455, -122.421196678795) | 5 | 1 | 1 | 28858 | 32 | |||
26784 | 128407 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 251 Sutter St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6011232.13001 | 2115582.12886 | 37.7896181182298 | -122.404983027342 | (37.7896181182298, -122.404983027342) | 5 | 1 | 10 | 28857 | 6 | |||
26833 | 115986 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 499 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6011754.92826 | 2118036.38994 | 37.7963861434716 | -122.403346915027 | (37.7963861434716, -122.403346915027) | 3 | 1 | 10 | 28860 | 4 | |||
26930 | 112710 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6009944.98971 | 2121981.12086 | 37.8071161463469 | -122.40988831469 | (37.8071161463469, -122.40988831469) | 3 | 1 | 10 | 308 | 23 | |||
27025 | 128036 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 685 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007800.18546 | 2121634.45508 | 37.8060438549941 | -122.417286302424 | (37.8060438549941, -122.417286302424) | 5 | 1 | 10 | 308 | 23 | |||
27078 | 128717 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 533 Jackson St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6011384.22669 | 2117985.27597 | 37.7962250856765 | -122.404626027992 | (37.7962250856765, -122.404626027992) | 3 | 1 | 10 | 28857 | 4 | |||
27198 | 127743 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1330 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008038.01816 | 2117067.68966 | 37.7935180363805 | -122.416139610169 | (37.7935180363805, -122.416139610169) | 5 | 1 | 10 | 28858 | 21 | |||
27230 | 61903 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1005 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1985 12:00:00 AM | 13 | Permit Number 21947 | 6008617.2267 | 2116046.34412 | 37.7907462215147 | -122.414063207745 | (37.7907462215147, -122.414063207745) | 5 | 1 | 10 | 28858 | 21 | ||
27264 | 128357 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1335 Battery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012155.65738 | 2120650.71533 | 37.8035868226221 | -122.402144190498 | (37.8035868226221, -122.402144190498) | 3 | 1 | 10 | 28860 | 6 | |||
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 | ||
27430 | 127682 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 623 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6010107.38825 | 2115849.13375 | 37.7902883127935 | -122.40889338122 | (37.7902883127935, -122.40889338122) | 5 | 1 | 10 | 28857 | 21 | |||
27546 | 128471 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 111 Front St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6013035.57318 | 2116816.15959 | 37.7931071226516 | -122.398829900993 | (37.7931071226516, -122.398829900993) | 4 | 1 | 10 | 28860 | 6 | |||
27788 | 128189 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 151 Beach St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009528.34804 | 2122220.78416 | 37.8077508429053 | -122.411347139176 | (37.8077508429053, -122.411347139176) | 3 | 1 | 10 | 308 | 23 | |||
27800 | 100681 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 California St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | 6012316.03692 | 2116830.75541 | 37.793107081281 | -122.401320580594 | (37.793107081281, -122.401320580594) | 4 | 1 | 10 | 28854 | 6 | ||||
27862 | 127692 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 751 Powell St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6010024.77623 | 2116366.99581 | 37.7917056092738 | -122.40921577291 | (37.7917056092738, -122.40921577291) | 5 | 1 | 10 | 28857 | 21 | |||
27881 | 107424 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1632 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6x9 | 6008808.04116 | 2118494.63119 | 37.7974793323623 | -122.413576231161 | (37.7974793323623, -122.413576231161) | 3 | 1 | 10 | 308 | 21 | |||
27883 | 249337 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 851 Post St | 3 | : | Tree | Private 2 | 12 | Width 3ft | 6008084.28411 | 2114798.49621 | 37.787289988396 | -122.415818769842 | (37.787289988396, -122.415818769842) | 13 | 1 | 9 | 28858 | 36 | |||
27898 | 128493 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 201 Montgomery St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6011961.6023 | 2116106.47919 | 37.791098610068 | -122.402495999902 | (37.791098610068, -122.402495999902) | 4 | 1 | 10 | 28854 | 6 | |||
28065 | 53260 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 440 Merchant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | 5 | Permit Number 6150 | 6012416.7635 | 2117668.92538 | 37.7954141157334 | -122.401030978214 | (37.7954141157334, -122.401030978214) | 3 | 1 | 10 | 28860 | 4 | ||
28081 | 128439 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 465 California St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6012038.72301 | 2116739.36453 | 37.7928406679022 | -122.402273680281 | (37.7928406679022, -122.402273680281) | 4 | 1 | 10 | 28854 | 6 | |||
28086 | 128045 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 681 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008278.49061 | 2121698.88203 | 37.8062476530568 | -122.415635609416 | (37.8062476530568, -122.415635609416) | 5 | 1 | 10 | 308 | 23 | |||
28144 | 127841 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2728 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006912.36807 | 2121678.45588 | 37.8061146811113 | -122.420361869618 | (37.8061146811113, -122.420361869618) | 5 | 1 | 1 | 28858 | 32 | |||
28503 | 127474 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 828 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 4ft | 6008755.95902 | 2115393.20151 | 37.7889606418706 | -122.41353698565 | (37.7889606418706, -122.41353698565) | 5 | 1 | 10 | 28858 | 21 | |||
28760 | 127525 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 535 Post St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6009652.45173 | 2115007.72817 | 37.7879525225236 | -122.410407998744 | (37.7879525225236, -122.410407998744) | 5 | 1 | 10 | 28852 | 36 | |||
28768 | 57196 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1974 12:00:00 AM | 15 | Permit Number 14477 | 6012440.56108 | 2119841.07989 | 37.8013796579148 | -122.401101337565 | (37.8013796579148, -122.401101337565) | 3 | 1 | 10 | 28860 | 6 | ||
28875 | 128742 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 415 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011959.52444 | 2118067.18774 | 37.7964821316861 | -122.402641131589 | (37.7964821316861, -122.402641131589) | 3 | 1 | 10 | 28860 | 4 | |||
28976 | 128334 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 190 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012094.33594 | 2120534.29884 | 37.8032637483763 | -122.402348207117 | (37.8032637483763, -122.402348207117) | 3 | 1 | 10 | 28860 | 6 | |||
29232 | 249347 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 825 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008271.46114 | 2114824.52265 | 37.7873719714978 | -122.415173017931 | (37.7873719714978, -122.415173017931) | 13 | 1 | 9 | 28858 | 36 | |||
29276 | 112698 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6010162.10827 | 2122010.9389 | 37.8072101848662 | -122.409139031937 | (37.8072101848662, -122.409139031937) | 3 | 1 | 10 | 308 | 23 | |||
29329 | 127835 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1287 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006899.96767 | 2118737.41598 | 37.7980386324459 | -122.42019592043 | (37.7980386324459, -122.42019592043) | 5 | 1 | 10 | 28858 | 32 | |||
29436 | 128417 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 555 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6011520.89022 | 2116664.10295 | 37.792605098606 | -122.40406011698 | (37.792605098606, -122.40406011698) | 4 | 1 | 10 | 28854 | 6 | |||
29513 | 67875 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1075 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1993 12:00:00 AM | 15 | Permit Number 31562 | 6012616.87453 | 2119838.22314 | 37.8013816481112 | -122.400491009969 | (37.8013816481112, -122.400491009969) | 3 | 1 | 10 | 28860 | 6 | ||
29527 | 128624 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 218 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012748.53011 | 2118213.31212 | 37.7969273734664 | -122.399921249892 | (37.7969273734664, -122.399921249892) | 3 | 1 | 10 | 28860 | 6 | |||
29633 | 84823 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 843 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2007 12:00:00 AM | 9 | Permit No. 49293 | 6011667.05773 | 2118221.94084 | 37.7968907134816 | -122.403664029475 | (37.7968907134816, -122.403664029475) | 3 | 1 | 10 | 308 | 4 | ||
29729 | 128158 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 328 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008698.81378 | 2122153.20188 | 37.8075187188778 | -122.414213167929 | (37.8075187188778, -122.414213167929) | 3 | 1 | 10 | 308 | 23 | |||
29858 | 127816 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1009 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008187.06074 | 2118913.96163 | 37.7985958209075 | -122.415754700319 | (37.7985958209075, -122.415754700319) | 5 | 1 | 10 | 28858 | 21 | |||
30112 | 128282 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6011187.65635 | 2121403.39656 | 37.8055994226472 | -122.405547065062 | (37.8055994226472, -122.405547065062) | 3 | 1 | 10 | 308 | 23 |
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) );