trees
5,599 rows where qSpecies_id = 38 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10998 | 100001 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501X 01st St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Address is 100 1st Street | ||||||||||||||
142737 | 176477 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 37 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002111.84755 | 2087511.46436 | 37.7120287084207 | -122.434530308936 | (37.7120287084207, -122.434530308936) | 9 | 7 | 6 | 28861 | 5 | |||
122000 | 104507 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99x DICHIERA CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5998517 | 2087907 | 37.7129100350962 | -122.446983527065 | (37.7129100350962, -122.446983527065) | 9 | 7 | 6 | 28861 | 25 | |||
78240 | 30866 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 8 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | 13 | Permit Number 34703 | 6011319.26825 | 2088660.76535 | 37.7157028373837 | -122.402787421618 | (37.7157028373837, -122.402787421618) | 9 | 7 | 8 | 309 | 39 | ||
44796 | 176450 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 306 Niagara Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5998817.22962 | 2090113.06189 | 37.718984525607 | -122.446104420884 | (37.718984525607, -122.446104420884) | 9 | 7 | 6 | 28861 | 25 | |||
119595 | 202078 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Gould St | 7 | Front Yard : Yard | Tree | Private 2 | 15 | 6012742.601 | 2090834.07314 | 37.7217496747035 | -122.398020073164 | (37.7217496747035, -122.398020073164) | 10 | 3 | 8 | 58 | 1 | ||||
66449 | 17225 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1880X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/1990 12:00:00 AM | 20 | 3X3 | 6001020.11667 | 2091172.22125 | 37.7220182913915 | -122.438565764807 | (37.7220182913915, -122.438565764807) | 9 | 7 | 6 | 28861 | 25 | ||
112861 | 176475 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 631 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 53 | Width 3ft | 6009778.33855 | 2091470.03307 | 37.7233303456119 | -122.408311632282 | (37.7233303456119, -122.408311632282) | 10 | 3 | 7 | 309 | 28 | |||
119404 | 176458 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 457 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007542.94981 | 2091608.68611 | 37.7235856271608 | -122.416048786743 | (37.7235856271608, -122.416048786743) | 9 | 3 | 7 | 309 | 28 | |||
117155 | 176455 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1535 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007043.36789 | 2091721.13814 | 37.7238662947792 | -122.417783724651 | (37.7238662947792, -122.417783724651) | 9 | 7 | 7 | 309 | 28 | |||
145678 | 176459 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 413 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007513.47384 | 2091725.2307 | 37.7239039763787 | -122.416158930301 | (37.7239039763787, -122.416158930301) | 9 | 3 | 7 | 309 | 28 | |||
13975 | 34940 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 448 Amherst St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1997 12:00:00 AM | 6 | Permit Number 38537 | 6007767.30311 | 2091743.17418 | 37.7239675143844 | -122.415282750512 | (37.7239675143844, -122.415282750512) | 9 | 3 | 7 | 309 | 28 | |
3124 | 176457 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 432 Amherst St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007753.63778 | 2091789.49647 | 37.7240939374796 | -122.415333267232 | (37.7240939374796, -122.415333267232) | 9 | 3 | 7 | 309 | 28 | |||
142533 | 176456 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 418 Amherst St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6007734.27889 | 2091838.55881 | 37.7242275641336 | -122.415403659872 | (37.7242275641336, -122.415403659872) | 9 | 3 | 7 | 309 | 28 | |||
179602 | 176447 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 843 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6001152.60647 | 2092059.5558 | 37.7244622467113 | -122.438171314947 | (37.7244622467113, -122.438171314947) | 9 | 7 | 6 | 28861 | 25 | |||
166142 | 176448 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 843 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6001153.28465 | 2092061.45027 | 37.724467487066 | -122.438169106224 | (37.724467487066, -122.438169106224) | 9 | 7 | 6 | 28861 | 25 | |||
144456 | 176454 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1609 Burrows St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6006663.80662 | 2092086.99786 | 37.7248494992863 | -122.419121747688 | (37.7248494992863, -122.419121747688) | 9 | 7 | 7 | 309 | 28 | |||
32775 | 176449 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 817 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001220.52796 | 2092231.19277 | 37.7249373855418 | -122.437948808285 | (37.7249373855418, -122.437948808285) | 9 | 7 | 6 | 28861 | 25 | |||
12792 | 62132 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 145 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/1985 12:00:00 AM | 11 | Permit Number 22246 | 6001265.02575 | 2092251.26554 | 37.724995031173 | -122.437796421771 | (37.724995031173, -122.437796421771) | 9 | 7 | 6 | 28861 | 25 | |
48259 | 176436 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 463 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009577.49826 | 2092143.36094 | 37.725167914146 | -122.40905338952 | (37.725167914146, -122.40905338952) | 10 | 3 | 7 | 309 | 28 | |||
16639 | 62134 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 215 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/1985 12:00:00 AM | 11 | Permit Number 22242 | 6001128.88331 | 2092317.53271 | 37.7251692433568 | -122.438271795315 | (37.7251692433568, -122.438271795315) | 9 | 7 | 6 | 28861 | 25 | |
138551 | 176437 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 463 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009568.70458 | 2092164.81949 | 37.7252263421948 | -122.409085301949 | (37.7252263421948, -122.409085301949) | 10 | 3 | 7 | 309 | 28 | |||
136798 | 176438 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 457 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009565.15013 | 2092176.99711 | 37.7252595802582 | -122.409098448262 | (37.7252595802582, -122.409098448262) | 10 | 3 | 7 | 309 | 28 | |||
137005 | 176439 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 457 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009562.30593 | 2092184.91678 | 37.725281166673 | -122.409108838997 | (37.725281166673, -122.409108838997) | 10 | 3 | 7 | 309 | 28 | |||
50242 | 176440 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 451 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009554.85724 | 2092203.72244 | 37.7253323857764 | -122.409135914884 | (37.7253323857764, -122.409135914884) | 10 | 3 | 7 | 309 | 28 | |||
49226 | 176441 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 451 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009551.98522 | 2092218.43921 | 37.725372634037 | -122.409146881221 | (37.725372634037, -122.409146881221) | 10 | 3 | 7 | 309 | 28 | |||
187476 | 176442 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 439 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009537.48644 | 2092260.08015 | 37.7254861590383 | -122.409199939444 | (37.7254861590383, -122.409199939444) | 10 | 3 | 7 | 309 | 28 | |||
167921 | 176443 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 439 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6009532.53015 | 2092277.47605 | 37.7255336468499 | -122.409218299982 | (37.7255336468499, -122.409218299982) | 10 | 3 | 7 | 309 | 28 | |||
65761 | 176444 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 427 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 6009521.33765 | 2092315.76215 | 37.7256381453679 | -122.409259692199 | (37.7256381453679, -122.409259692199) | 10 | 3 | 7 | 309 | 28 | |||
110107 | 96561 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 421 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6009510.75375 | 2092344.78253 | 37.7257172362504 | -122.409298327061 | (37.7257172362504, -122.409298327061) | 10 | 3 | 7 | 309 | 28 | |||
24885 | 96562 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 421 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6009504.65574 | 2092358.16495 | 37.7257536399061 | -122.409320351472 | (37.7257536399061, -122.409320351472) | 10 | 3 | 7 | 309 | 28 | |||
148944 | 67288 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 78 Valmar Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | 10 | Permit Number 30764 | 6005282.20957 | 2092652.12514 | 37.7263233136635 | -122.423937939201 | (37.7263233136635, -122.423937939201) | 9 | 7 | 6 | 28861 | 5 | |
47506 | 68261 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 331 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 4 | Permit Number 32067 | 6009662.93548 | 2092873.24927 | 37.72717681975 | -122.408809511343 | (37.72717681975, -122.408809511343) | 10 | 3 | 7 | 309 | 28 | |
114210 | 218912 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 67 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993729.09341 | 2093249.40843 | 37.7273042941543 | -122.463919522093 | (37.7273042941543, -122.463919522093) | 9 | 8 | 4 | 59 | 40 | |||
113963 | 190149 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2399 Lane St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6013956.81212 | 2092846.62136 | 37.7273432797633 | -122.393963643334 | (37.7273432797633, -122.393963643334) | 10 | 3 | 8 | 58 | 1 | ||||
83273 | 176453 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 140 Madison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005488.1147 | 2093033.7267 | 37.7273827303155 | -122.423253248458 | (37.7273827303155, -122.423253248458) | 9 | 7 | 6 | 28861 | 5 | |||
69624 | 190150 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2399 Lane St | 3 | Side Yard : Yard | Tree | Private 2 | 11 | 6013973.08997 | 2092870.41979 | 37.7274095301006 | -122.393909035588 | (37.7274095301006, -122.393909035588) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
98219 | 218916 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 544 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 5996794.9301 | 2093643.75668 | 37.7285632856446 | -122.453349451027 | (37.7285632856446, -122.453349451027) | 9 | 7 | 4 | 28861 | 40 | |||
74973 | 176452 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 302 Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004691.53481 | 2093582.22817 | 37.7288438057946 | -122.426046057105 | (37.7288438057946, -122.426046057105) | 9 | 7 | 6 | 28861 | 5 | |||
105465 | 218944 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 135 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996130.94498 | 2093909.94735 | 37.7292560999702 | -122.455664103608 | (37.7292560999702, -122.455664103608) | 9 | 7 | 4 | 28861 | 40 | |||
59730 | 63627 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 67 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1987 12:00:00 AM | 4 | Permit Number 24270 | 6007827.91665 | 2093727.62728 | 37.7294198035797 | -122.415213626819 | (37.7294198035797, -122.415213626819) | 9 | 3 | 7 | 309 | 28 | ||
163436 | 60868 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 37 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/1983 12:00:00 AM | 11 | Permit Number 20650 | 6001292.56041 | 2093871.74936 | 37.7294460754672 | -122.437817248275 | (37.7294460754672, -122.437817248275) | 9 | 7 | 6 | 28861 | 25 | ||
92426 | 176445 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 37 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001283.54641 | 2093883.1202 | 37.7294767846155 | -122.43784922458 | (37.7294767846155, -122.43784922458) | 9 | 7 | 6 | 28861 | 25 | |||
121012 | 52949 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 31 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 14 | Permit Number 48936 | 6001265.83557 | 2093905.19731 | 37.7295363961645 | -122.437912033237 | (37.7295363961645, -122.437912033237) | 9 | 7 | 6 | 28861 | 25 | |
127518 | 176461 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 University St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 2ft | 6007804.4952 | 2093798.51871 | 37.7296131398345 | -122.415299613696 | (37.7296131398345, -122.415299613696) | 9 | 3 | 7 | 309 | 28 | |||
119620 | 176462 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 49 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007792.32037 | 2093837.33535 | 37.7297190376839 | -122.41534445031 | (37.7297190376839, -122.41534445031) | 9 | 3 | 7 | 309 | 28 | |||
61772 | 176460 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 44 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007750.30868 | 2093850.57918 | 37.7297530410657 | -122.41549062699 | (37.7297530410657, -122.41549062699) | 9 | 3 | 7 | 309 | 28 | |||
19997 | 176476 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 718 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007131.88508 | 2094081.13811 | 37.7303513258298 | -122.417644925979 | (37.7303513258298, -122.417644925979) | 9 | 3 | 7 | 309 | 28 | |||
71482 | 176446 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 43 Gorham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002168.44276 | 2094346.29605 | 37.7307988392865 | -122.434823165056 | (37.7307988392865, -122.434823165056) | 9 | 7 | 5 | 28861 | 25 | |||
35801 | 218961 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 387 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999533.62345 | 2094950.56733 | 37.7323080815474 | -122.443975525052 | (37.7323080815474, -122.443975525052) | 9 | 7 | 4 | 63 | 40 | |||
122923 | 176466 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 254 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009274.61582 | 2094752.09996 | 37.7323139856024 | -122.410284534429 | (37.7323139856024, -122.410284534429) | 10 | 3 | 7 | 309 | 28 | |||
120390 | 176467 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 131 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010016.33557 | 2094749.89634 | 37.7323494845239 | -122.407720071722 | (37.7323494845239, -122.407720071722) | 10 | 3 | 7 | 309 | 28 | |||
151676 | 176465 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 217 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009430.63613 | 2094763.19448 | 37.7323531933507 | -122.409745916959 | (37.7323531933507, -122.409745916959) | 10 | 3 | 7 | 309 | 28 | |||
25039 | 111177 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 211 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009453.85079 | 2094770.82472 | 37.7323754452754 | -122.409666196537 | (37.7323754452754, -122.409666196537) | 10 | 3 | 7 | 309 | 28 | |||
22640 | 218960 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 374 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5999594.52291 | 2094990.63523 | 37.7324215723769 | -122.443767859899 | (37.7324215723769, -122.443767859899) | 9 | 7 | 4 | 63 | 40 | ||||
158093 | 176468 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 118 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010056.11528 | 2094810.26888 | 37.7325174814929 | -122.407586798503 | (37.7325174814929, -122.407586798503) | 10 | 3 | 7 | 309 | 28 | |||
46281 | 176464 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Gaven St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6008910.66348 | 2094859.09259 | 37.7325873561203 | -122.411550362571 | (37.7325873561203, -122.411550362571) | 9 | 3 | 7 | 309 | 28 | |||
176420 | 176463 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Gaven St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 4ft | 6008926.06204 | 2094862.35921 | 37.7325971892913 | -122.41149735652 | (37.7325971892913, -122.41149735652) | 9 | 3 | 7 | 309 | 28 | |||
164205 | 176469 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 167 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009736.65298 | 2094872.31447 | 37.7326699579377 | -122.408695636491 | (37.7326699579377, -122.408695636491) | 10 | 3 | 7 | 309 | 28 | |||
138607 | 176472 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 178 Sweeny St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 4ft | 6009645.31366 | 2094885.75982 | 37.7327017597604 | -122.409012368727 | (37.7327017597604, -122.409012368727) | 10 | 3 | 7 | 309 | 28 | |||
39894 | 176471 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 138 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009867.29954 | 2094965.95551 | 37.7329343927939 | -122.40825055931 | (37.7329343927939, -122.40825055931) | 10 | 3 | 7 | 309 | 28 | |||
64218 | 176474 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009301.38379 | 2094985.21532 | 37.732955570929 | -122.410208443664 | (37.732955570929, -122.410208443664) | 10 | 3 | 7 | 309 | 28 | |||
5867 | 176470 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 130 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009916.73377 | 2094983.66925 | 37.7329857989392 | -122.408080900424 | (37.7329857989392, -122.408080900424) | 10 | 3 | 7 | 309 | 28 | |||
16477 | 224849 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 779889 | 6003244.13534 | 2095137.54828 | 37.7330324530887 | -122.431160782146 | (37.7330324530887, -122.431160782146) | 9 | 7 | 5 | 28861 | 25 | ||
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 | |||
123847 | 224850 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 319 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6003637.59911 | 2095225.12175 | 37.7332951990002 | -122.429806718825 | (37.7332951990002, -122.429806718825) | 9 | 7 | 5 | 28861 | 25 | |||
42796 | 54543 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 147 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 9 | Permit Number 10338 | 6009783.43308 | 2095111.41047 | 37.7333290845542 | -122.408550765616 | (37.7333290845542, -122.408550765616) | 10 | 3 | 7 | 309 | 28 | ||
151274 | 224906 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 410 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003435.91528 | 2095250.54652 | 37.7333535865804 | -122.430505808591 | (37.7333535865804, -122.430505808591) | 2 | 7 | 5 | 28861 | 25 | |||
155754 | 176473 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 146 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009765.77583 | 2095153.6821 | 37.7334441645219 | -122.408614792855 | (37.7334441645219, -122.408614792855) | 10 | 3 | 7 | 309 | 28 | |||
106743 | 2016 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 598 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 772999 | 6002387.1334523 | 2095371.0933821 | 37.7336251126369 | -122.434140349269 | (37.7336251126369, -122.434140349269) | 2 | 7 | 5 | 63 | 7 | ||
146815 | 4953 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 598 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 772999 | 6002387.1334523 | 2095371.0933821 | 37.7336251126369 | -122.434140349269 | (37.7336251126369, -122.434140349269) | 2 | 7 | 5 | 63 | 7 | ||
104085 | 218958 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 806 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999461.39114 | 2095552.35302 | 37.7339563230119 | -122.444268477415 | (37.7339563230119, -122.444268477415) | 9 | 7 | 4 | 63 | 40 | |||
28995 | 224886 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2830 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6002399.50987 | 2095496.07417 | 37.7339689836782 | -122.434106491738 | (37.7339689836782, -122.434106491738) | 2 | 7 | 5 | 63 | 7 | |||
60877 | 224907 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 24 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003963.26139 | 2095488.34762 | 37.734036394155 | -122.428699572438 | (37.734036394155, -122.428699572438) | 2 | 7 | 5 | 28861 | 25 | |||
91985 | 224908 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 22 Cuvier St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003958.12248 | 2095520.70767 | 37.7341249567003 | -122.428719645307 | (37.7341249567003, -122.428719645307) | 2 | 7 | 5 | 28861 | 25 | |||
176255 | 224909 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 22 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003953.55531 | 2095536.32016 | 37.734167566584 | -122.428736548047 | (37.734167566584, -122.428736548047) | 2 | 7 | 5 | 28861 | 25 | |||
58571 | 224910 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 14 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003951.88648 | 2095603.60095 | 37.7343522099779 | -122.428747112408 | (37.7343522099779, -122.428747112408) | 2 | 7 | 5 | 28861 | 25 | |||
142576 | 218959 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 113 Stillings Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6000075.97071 | 2095686.01548 | 37.7343583730463 | -122.44215328547 | (37.7343583730463, -122.44215328547) | 9 | 7 | 4 | 63 | 40 | |||
179851 | 224880 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2016 12:00:00 AM | 15 | Width 3ft | Permit Number 779045 | 6002530.35822 | 2095666.13206 | 37.7344433490686 | -122.433666259201 | (37.7344433490686, -122.433666259201) | 2 | 7 | 5 | 63 | 7 | |
178590 | 225334 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 536 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003396.7885 | 2095656.62848 | 37.734466378904 | -122.430670048187 | (37.734466378904, -122.430670048187) | 2 | 7 | 5 | 63 | 7 | |||
26032 | 30564 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 633 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 9 | Permit Number 34542 | 6002889.41967 | 2095678.38488 | 37.7344973596725 | -122.432425741574 | (37.7344973596725, -122.432425741574) | 2 | 7 | 5 | 63 | 7 | ||
132068 | 224881 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 631 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002911.10799 | 2095680.36201 | 37.7345040182354 | -122.432350899088 | (37.7345040182354, -122.432350899088) | 2 | 7 | 5 | 63 | 7 | |||
63882 | 4311 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 704 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002439.77272 | 2095706.35497 | 37.7345486515816 | -122.433982316925 | (37.7345486515816, -122.433982316925) | 2 | 7 | 5 | 63 | 7 | |||
42361 | 224879 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 670 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 2x2 | 6002563.91545 | 2095705.58789 | 37.7345535897736 | -122.433553059737 | (37.7345535897736, -122.433553059737) | 2 | 7 | 5 | 63 | 7 | |||
163906 | 224878 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 660 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6002621.84248 | 2095706.54676 | 37.7345595091169 | -122.433352855352 | (37.7345595091169, -122.433352855352) | 2 | 7 | 5 | 63 | 7 | |||
139294 | 224877 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 654 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6002658.40723 | 2095708.21632 | 37.7345661676825 | -122.433226558173 | (37.7345661676825, -122.433226558173) | 2 | 7 | 5 | 63 | 7 | |||
27700 | 224876 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 630 Chenery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002697.41175 | 2095710.10509 | 37.7345735664086 | -122.433091841534 | (37.7345735664086, -122.433091841534) | 2 | 7 | 5 | 63 | 7 | |||
173873 | 224874 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 630 Chenery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6002734.23578 | 2095711.23062 | 37.734578745619 | -122.432964609036 | (37.734578745619, -122.432964609036) | 2 | 7 | 5 | 63 | 7 | |||
37029 | 224875 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 630 Chenery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6002716.38989 | 2095711.86883 | 37.7345794857458 | -122.433026353782 | (37.7345794857458, -122.433026353782) | 2 | 7 | 5 | 63 | 7 | |||
98504 | 224873 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 630 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6002752.39129 | 2095712.47226 | 37.7345831846595 | -122.432901928087 | (37.7345831846595, -122.432901928087) | 2 | 7 | 5 | 63 | 7 | |||
39188 | 224872 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 630 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 1ft | 6002774.43666 | 2095713.13572 | 37.734586256738 | -122.432825757301 | (37.734586256738, -122.432825757301) | 2 | 7 | 5 | 63 | 7 | |||
102211 | 190151 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 43 Bridgeview Dr | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6013910.41512 | 2095496.08824 | 37.7346155971136 | -122.394309462337 | (37.7346155971136, -122.394309462337) | 10 | 3 | 8 | 58 | 1 | |||
130535 | 105165 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1600X OAKDALE AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 16 | 3x3 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
82363 | 225337 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3121 Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002904.9845 | 2095758.97313 | 37.7347195191986 | -122.432377682707 | (37.7347195191986, -122.432377682707) | 2 | 7 | 5 | 63 | 7 | |||
17885 | 218952 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 9 Burlwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996293.67263 | 2095955.2526 | 37.7348813521796 | -122.455249292243 | (37.7348813521796, -122.455249292243) | 9 | 7 | 4 | 59 | 40 | |||
117366 | 225338 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3045 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002897.89077 | 2095961.40859 | 37.7352749584633 | -122.432416662015 | (37.7352749584633, -122.432416662015) | 2 | 7 | 5 | 63 | 7 | |||
185274 | 225336 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3030 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | 15 | Width 2ft | Permit Number 18789 | 6002856.92306 | 2096000.60547 | 37.7353802609748 | -122.432561101209 | (37.7353802609748, -122.432561101209) | 2 | 7 | 5 | 63 | 7 | |
108532 | 5118 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2721 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4X4 | 6002423.4063 | 2096112.93814 | 37.7356641067988 | -122.434067955786 | (37.7356641067988, -122.434067955786) | 2 | 7 | 5 | 63 | 7 | |||
56451 | 218913 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 265 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5994999.9662 | 2096306.69492 | 37.7357720155706 | -122.459747504157 | (37.7357720155706, -122.459747504157) | 9 | 7 | 4 | 59 | 40 |
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) );