trees
5,723 rows where qSpecies_id = 14 sorted by qCaretaker_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25594 | 27028 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1380X Silver Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:29:00 AM | 3 | 3X3 | 6009629.1666 | 2094382.20254 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | 10 | 3 | 7 | 309 | 28 | ||
| 26070 | 11738 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2000 12:00:00 AM | 3 | 2x2 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | ||
| 26155 | 89461 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3600 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987467.79955 | 2111896.0729 | 37.7781401823381 | -122.486933301933 | (37.7781401823381, -122.486933301933) | 11 | 6 | 2 | 55 | 26 | ||
| 26274 | 29195 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3001X Ortega St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984739.8904244 | 2102235.9389756 | 37.7514567493278 | -122.495657268978 | (37.7514567493278, -122.495657268978) | 1 | 8 | 3 | 29491 | 35 | ||
| 26316 | 11736 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/2014 12:00:00 AM | 3 | 3x3 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | ||
| 26429 | 29174 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3311 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3x3 | 5983780.4899722 | 2102201.743436 | 37.7513066285159 | -122.49897241277 | (37.7513066285159, -122.49897241277) | 1 | 8 | 3 | 29491 | 35 | ||
| 26839 | 11701 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 700X Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.41051 | 2092816.87452 | 37.7259758228212 | -122.47231844174 | (37.7259758228212, -122.47231844174) | 9 | 8 | 4 | 64 | 40 | ||
| 26868 | 11227 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1050X Ingalls St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/1998 12:00:00 AM | 12 | 3X4 | 6018085.6618829 | 2094069.8743192 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | 10 | 3 | 8 | 58 | 1 | ||
| 27056 | 86358 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2467 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988579.1256 | 2098528.4885 | 37.7415011492289 | -122.482109310709 | (37.7415011492289, -122.482109310709) | 1 | 8 | 3 | 29491 | 35 | ||
| 27120 | 89751 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1037X Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995503.784329 | 2112134.227086 | 37.7792593428601 | -122.459151353267 | (37.7792593428601, -122.459151353267) | 11 | 6 | 2 | 54 | 11 | ||
| 27169 | 86245 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2306 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988589.4098 | 2099609.5524 | 37.744470064859 | -122.48215293338 | (37.744470064859, -122.48215293338) | 1 | 8 | 3 | 29491 | 35 | ||
| 27462 | 11629 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | 3 | 4x4 | 5991384.172 | 2094246.342 | 37.7299062097499 | -122.472098464699 | (37.7299062097499, -122.472098464699) | 9 | 8 | 4 | 64 | 40 | ||
| 27581 | 86012 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1642 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987499.1098 | 2104097.2319 | 37.7567285504541 | -122.486252307696 | (37.7567285504541, -122.486252307696) | 1 | 8 | 3 | 56 | 35 | ||
| 27662 | 90595 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2500 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5987810.19746 | 2110547.65595 | 37.7744577651299 | -122.48564985195 | (37.7744577651299, -122.48564985195) | 11 | 6 | 2 | 55 | 26 | ||
| 27840 | 86345 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2375 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x10 | 5988557.6358 | 2099173.0128 | 37.7432695938537 | -122.482230823598 | (37.7432695938537, -122.482230823598) | 1 | 8 | 3 | 29491 | 35 | ||
| 27893 | 86341 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2339 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 9x6 | 5988548.8369 | 2099394.3407 | 37.7438767902403 | -122.48227745989 | (37.7438767902403, -122.48227745989) | 1 | 8 | 3 | 29491 | 35 | ||
| 27903 | 29192 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3109 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984182.3495 | 2102207.3027 | 37.7513454565716 | -122.497583168809 | (37.7513454565716, -122.497583168809) | 1 | 8 | 3 | 29491 | 35 | ||
| 28164 | 86552 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1807 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.5941 | 2102964.5337 | 37.7536362092428 | -122.485116198466 | (37.7536362092428, -122.485116198466) | 1 | 8 | 3 | 56 | 35 | ||
| 28204 | 90625 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2950 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2008 12:00:00 AM | 3 | 3x3 | 5986402.48936 | 2110496.09502 | 37.7742340708752 | -122.490515521877 | (37.7742340708752, -122.490515521877) | 11 | 6 | 2 | 55 | 26 | ||
| 28417 | 4761 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 15 Commer Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2000 12:00:00 AM | 20 | 3X3 | 6016484.3529507 | 2094703.932641 | 37.7325832370534 | -122.385355225727 | (37.7325832370534, -122.385355225727) | 10 | 3 | 8 | 58 | 1 | ||
| 28423 | 30123 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400X Brotherhood Way | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 5993855.385701 | 2087505.212074 | 37.7115393894105 | -122.463066335527 | (37.7115393894105, -122.463066335527) | 9 | 8 | 6 | 64 | 24 | |||
| 28484 | 11338 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1279 Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2000 12:00:00 AM | 3 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.382092440811 | (37.7305663998171, -122.382092440811) | 10 | 3 | 8 | 58 | 1 | ||
| 28807 | 89626 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3645X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987384.941021 | 2111843.870932 | 37.7779920191565 | -122.487216100745 | (37.7779920191565, -122.487216100745) | 11 | 6 | 2 | 55 | 26 | |
| 29802 | 90611 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2800X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2008 12:00:00 AM | 3 | 3x3 | 5986889.77184 | 2110515.55946 | 37.7743159644127 | -122.48883137746 | (37.7743159644127, -122.48883137746) | 11 | 6 | 2 | 55 | 26 | ||
| 30266 | 102965 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 30269 | 86340 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2335 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 9x6 | 5988548.8369 | 2099418.3686 | 37.743942764529 | -122.482279219959 | (37.743942764529, -122.482279219959) | 1 | 8 | 3 | 29491 | 35 | ||
| 31162 | 86039 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1293 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 6 | 3x3 | 5987376.838413 | 2106492.645795 | 37.763298574504 | -122.486851062994 | (37.763298574504, -122.486851062994) | 1 | 8 | 3 | 56 | 35 | ||
| 31178 | 87594 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991401.185357 | 2095410.335482 | 37.7331032279342 | -122.472124459161 | (37.7331032279342, -122.472124459161) | 1 | 8 | 4 | 64 | 40 | ||
| 31322 | 87605 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 700X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991325.238472 | 2093085.954883 | 37.7267166661233 | -122.472217650571 | (37.7267166661233, -122.472217650571) | 9 | 8 | 4 | 64 | 40 | ||
| 31534 | 90600 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2626 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5987485.847424 | 2110526.216966 | 37.7743799956733 | -122.486770251531 | (37.7743799956733, -122.486770251531) | 11 | 6 | 2 | 55 | 26 | |
| 31639 | 11705 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 700X Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991287.29739 | 2092772.28865 | 37.7258532209449 | -122.472325954706 | (37.7258532209449, -122.472325954706) | 9 | 8 | 4 | 64 | 40 | ||
| 31659 | 102511 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1700X Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.435126576612 | (37.782944132882, -122.435126576612) | 15 | 5 | 11 | 29490 | 41 | ||
| 31681 | 89732 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1345X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5994539.740767 | 2112100.080469 | 37.7791101165057 | -122.462483877301 | (37.7791101165057, -122.462483877301) | 11 | 6 | 2 | 54 | 11 | ||
| 31812 | 86147 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1350 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2007 12:00:00 AM | 8 | 3x3 | 5988673.7063 | 2106118.8136 | 37.7623476572695 | -122.482338285023 | (37.7623476572695, -122.482338285023) | 1 | 8 | 3 | 56 | 35 | ||
| 32087 | 86468 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1830 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 10 | 3x3 | 5987859.0288 | 2102813.3889 | 37.753224435288 | -122.484913407703 | (37.753224435288, -122.484913407703) | 1 | 8 | 3 | 56 | 35 | ||
| 32194 | 25424 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 355X Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1997 12:00:00 AM | 3 | 3X3 | 6010860.4127952 | 2090398.0121797 | 37.7204473313138 | -122.404495660393 | (37.7204473313138, -122.404495660393) | 10 | 7 | 8 | 309 | 28 | ||
| 32379 | 12844 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2334 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/22/2004 12:00:00 AM | 12 | 3X3 | 5988170.1967 | 2114688.12911 | 37.7858473064355 | -122.484708351946 | (37.7858473064355, -122.484708351946) | 11 | 6 | 1 | 55 | 33 | ||
| 32684 | 86015 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1600X 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987488.648908 | 2104374.518026 | 37.7574892930565 | -122.486308841123 | (37.7574892930565, -122.486308841123) | 1 | 8 | 3 | 56 | 35 | ||
| 32859 | 86037 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1215 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987357.4179 | 2106982.0087 | 37.7646410979346 | -122.486954171559 | (37.7646410979346, -122.486954171559) | 1 | 8 | 3 | 56 | 35 | ||
| 32935 | 89743 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1125 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995161.46404 | 2112116.24997 | 37.779190296955 | -122.460334269929 | (37.779190296955, -122.460334269929) | 11 | 6 | 2 | 54 | 11 | ||
| 33006 | 204967 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 15 | 5995373.3226 | 2092827.47447 | 37.7262403835647 | -122.45820493933 | (37.7262403835647, -122.45820493933) | 9 | 7 | 4 | 28861 | 40 | ||||
| 33784 | 86342 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2347 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988550.1905 | 2099342.5621 | 37.743734698567 | -122.482268986695 | (37.743734698567, -122.482268986695) | 1 | 8 | 3 | 29491 | 35 | ||
| 33961 | 89386 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1400X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 5994285.00866 | 2112141.29705 | 37.7792086137323 | -122.463368084535 | (37.7792086137323, -122.463368084535) | 11 | 6 | 2 | 54 | 11 | ||
| 34034 | 86470 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1822 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987859.0288 | 2102867.5421 | 37.7533731253955 | -122.484917380259 | (37.7533731253955, -122.484917380259) | 1 | 8 | 3 | 56 | 35 | ||
| 34427 | 86042 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1311 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987382.8738 | 2106304.4567 | 37.7627822108774 | -122.486816368637 | (37.7627822108774, -122.486816368637) | 1 | 8 | 3 | 56 | 35 | ||
| 34567 | 102960 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 34767 | 86481 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1738 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987831.7029 | 2103459.302005 | 37.7549963468497 | -122.485055291033 | (37.7549963468497, -122.485055291033) | 1 | 8 | 3 | 56 | 35 | ||
| 35290 | 16742 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1735X O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6003067.52418 | 2113392.76277 | 37.7831468931994 | -122.433075208633 | (37.7831468931994, -122.433075208633) | 15 | 9 | 11 | 29490 | 41 | |||
| 35473 | 24443 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1900 03rd St | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6015653.1254 | 2106493.05188 | 37.7649076765652 | -122.389051837691 | (37.7649076765652, -122.389051837691) | 14 | 3 | 9 | 310 | 29 | ||
| 35807 | 89390 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1500X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 5994012.82903 | 2112131.44437 | 37.779165876205 | -122.464308943157 | (37.779165876205, -122.464308943157) | 11 | 6 | 2 | 54 | 11 | ||
| 36762 | 86365 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2527 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988592.98 | 2098098.1742 | 37.7403204245752 | -122.482029891514 | (37.7403204245752, -122.482029891514) | 1 | 8 | 3 | 29491 | 35 | ||
| 36849 | 89617 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3849X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5986666.78033 | 2111812.28793 | 37.7778633974782 | -122.489698116951 | (37.7778633974782, -122.489698116951) | 11 | 6 | 2 | 55 | 26 | ||
| 37744 | 11234 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1100X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/1998 12:00:00 AM | 8 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.379993586815 | (37.7307473625426, -122.379993586815) | 10 | 3 | 8 | 58 | 1 | ||
| 37921 | 89445 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3116 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988942.51462 | 2111949.08896 | 37.7783716209534 | -122.481835672616 | (37.7783716209534, -122.481835672616) | 11 | 6 | 2 | 55 | 26 | ||
| 37927 | 86167 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1379 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988635.288 | 2105938.085 | 37.7618491908278 | -122.482457914966 | (37.7618491908278, -122.482457914966) | 1 | 8 | 3 | 56 | 35 | ||
| 38001 | 86013 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1600X 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987488.648908 | 2104374.518026 | 37.7574892930565 | -122.486308841123 | (37.7574892930565, -122.486308841123) | 1 | 8 | 3 | 56 | 35 | ||
| 38212 | 86551 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1801X 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987806.717124 | 2103025.494361 | 37.7538037727045 | -122.485109870887 | (37.7538037727045, -122.485109870887) | 1 | 8 | 3 | 56 | 35 | ||
| 38266 | 90820 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3043 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5986143.91202 | 2110430.47401 | 37.7740387875121 | -122.491405144174 | (37.7740387875121, -122.491405144174) | 11 | 6 | 2 | 55 | 26 | ||
| 38857 | 86356 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2451 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988574.7261 | 2098626.6308 | 37.7417703663751 | -122.482131710751 | (37.7417703663751, -122.482131710751) | 1 | 8 | 3 | 29491 | 35 | ||
| 39075 | 87601 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991375.547 | 2094142.843 | 37.7296215282961 | -122.472120740905 | (37.7296215282961, -122.472120740905) | 9 | 8 | 4 | 64 | 40 | ||
| 39457 | 89452 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3242 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988517.51394 | 2111934.05216 | 37.778305609302 | -122.483304788204 | (37.778305609302, -122.483304788204) | 11 | 6 | 2 | 55 | 26 | ||
| 40250 | 86336 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2315 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988542.5761 | 2099546.1228 | 37.7442931797412 | -122.482310226394 | (37.7442931797412, -122.482310226394) | 1 | 8 | 3 | 29491 | 35 | ||
| 40611 | 86047 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1355 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987391.692465 | 2106060.87529 | 37.7621139173709 | -122.486767980838 | (37.7621139173709, -122.486767980838) | 1 | 8 | 3 | 56 | 35 | ||
| 41034 | 102966 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 41344 | 254527 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4016 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/06/2015 01:17:00 PM | 3x3 | 5982022 | 2105615 | 37.7605751592951 | -122.505306319772 | (37.7605751592951, -122.505306319772) | 1 | 8 | 3 | 56 | 35 | ||
| 41543 | 25348 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 30X Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/1996 12:00:00 AM | 12 | 3X3 | 5997206.49294 | 2091471.76417 | 37.7226230889599 | -122.451770042704 | (37.7226230889599, -122.451770042704) | 9 | 8 | 6 | 28861 | 24 | ||
| 41704 | 21877 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1900 03rd St | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015647.43596 | 2106591.54612 | 37.7651778050355 | -122.389078393773 | (37.7651778050355, -122.389078393773) | 14 | 3 | 9 | 310 | 29 | ||
| 41974 | 87622 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 800X Junipero Serra Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991263.805475 | 2092171.02552 | 37.7242009421806 | -122.472363351561 | (37.7242009421806, -122.472363351561) | 9 | 8 | 4 | 64 | 40 | ||
| 42487 | 86557 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1839 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 5 | 3x3 | 5987812.6165 | 2102765.0103 | 37.7530888972888 | -122.485070359602 | (37.7530888972888, -122.485070359602) | 1 | 8 | 3 | 56 | 35 | ||
| 42761 | 112202 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2000X Turk Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3x3 | 6000205.46291 | 2111993.09916 | 37.779141013771 | -122.442876210646 | (37.779141013771, -122.442876210646) | 15 | 5 | 1 | 29490 | 16 | |||
| 43019 | 89741 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1201X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5994926.80564 | 2112109.53669 | 37.779158362908 | -122.461145557317 | (37.779158362908, -122.461145557317) | 11 | 6 | 2 | 54 | 11 | ||
| 43185 | 89388 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1440X Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 5994240.208002 | 2112129.496082 | 37.7791736302604 | -122.463522210626 | (37.7791736302604, -122.463522210626) | 11 | 6 | 2 | 54 | 11 | ||
| 43386 | 89753 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1003 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995610.27232 | 2112137.998919 | 37.7792758206049 | -122.458783242743 | (37.7792758206049, -122.458783242743) | 11 | 6 | 2 | 54 | 11 | ||
| 43520 | 188192 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 860x Jamestown Ave | 7 | Median : Cutout | Tree | DPW 1 | 2 | Width 5ft | 6014712.46202 | 2089164.16636 | 37.7172739556962 | -122.391094061367 | (37.7172739556962, -122.391094061367) | 10 | 3 | 8 | 58 | 1 | |||
| 43682 | 86235 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2390 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988605.4776 | 2099097.5817 | 37.7430652625376 | -122.48205987634 | (37.7430652625376, -122.48205987634) | 1 | 8 | 3 | 29491 | 35 | ||
| 43783 | 28813 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1199X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6008563.737 | 2093993.84748 | 37.7301921129709 | -122.412688629658 | (37.7301921129709, -122.412688629658) | 9 | 3 | 7 | 309 | 28 | |||
| 43844 | 29189 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3109 Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984268.6471 | 2102206.6258 | 37.7513486560907 | -122.497284696389 | (37.7513486560907, -122.497284696389) | 1 | 8 | 3 | 29491 | 35 | ||
| 44138 | 29623 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900X Junipero Serra Blvd | 32 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991172.61835 | 2090822.9081 | 37.7204940673378 | -122.472580327015 | (37.7204940673378, -122.472580327015) | 9 | 8 | 4 | 64 | 40 | ||
| 44474 | 86228 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2458 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/06/2015 09:49:00 AM | 3 | 3x3 | 5988622.1052 | 2098596.1728 | 37.7416894923046 | -122.481965660758 | (37.7416894923046, -122.481965660758) | 1 | 8 | 3 | 29491 | 35 | ||
| 44686 | 90827 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2951X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2008 12:00:00 AM | 3 | 3x3 | 5986417.41505 | 2110440.24517 | 37.7740815947575 | -122.490459782312 | (37.7740815947575, -122.490459782312) | 11 | 6 | 2 | 55 | 26 | ||
| 44764 | 255383 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 10 Niagara Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/10/2018 05:26:00 AM | 3 | 3x3 | 6000028 | 2088914 | 37.7157612418296 | -122.44183326031 | (37.7157612418296, -122.44183326031) | 9 | 7 | 6 | 28861 | 25 | ||
| 44875 | 29216 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2002X 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5983557.6109598 | 2101506.6699283 | 37.7493850732351 | -122.499691774232 | (37.7493850732351, -122.499691774232) | 1 | 8 | 3 | 29491 | 35 | ||
| 45055 | 87609 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 800X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/2014 12:00:00 AM | 3 | 3x3 | 5991263.805475 | 2092171.02552 | 37.7242009421806 | -122.472363351561 | (37.7242009421806, -122.472363351561) | 9 | 8 | 4 | 64 | 40 | ||
| 45090 | 86077 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2245 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987598.92021 | 2100009.161621 | 37.7455096249566 | -122.485607121223 | (37.7455096249566, -122.485607121223) | 1 | 8 | 3 | 29491 | 35 | ||
| 45431 | 86179 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1567 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988681.1149 | 2104657.7064 | 37.7583362836656 | -122.482205611481 | (37.7583362836656, -122.482205611481) | 1 | 8 | 3 | 56 | 35 | ||
| 45545 | 89616 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3849X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5986643.56639 | 2111811.7622 | 37.7778605985985 | -122.489778382317 | (37.7778605985985, -122.489778382317) | 11 | 6 | 2 | 55 | 26 | ||
| 45549 | 30101 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 499X Brotherhood Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 5992721.81053 | 2087817.32427 | 37.7123310107736 | -122.467006913451 | (37.7123310107736, -122.467006913451) | 9 | 8 | 4 | 64 | 24 | |||
| 45654 | 29240 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3002X Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984158.6336731 | 2100904.0697568 | 37.7477657476636 | -122.497568970545 | (37.7477657476636, -122.497568970545) | 1 | 8 | 3 | 29491 | 35 | ||
| 45969 | 90615 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2826 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2008 12:00:00 AM | 3 | 3x3 | 5986813.55235 | 2110512.41998 | 37.7743028958473 | -122.489094800326 | (37.7743028958473, -122.489094800326) | 11 | 6 | 2 | 55 | 26 | ||
| 46255 | 86017 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1554 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987479.1031 | 2104708.0563 | 37.7584045419397 | -122.48636634081 | (37.7584045419397, -122.48636634081) | 1 | 8 | 3 | 56 | 35 | ||
| 46261 | 86031 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1330 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987427.8702 | 2106214.9477 | 37.7625390669723 | -122.486654171196 | (37.7625390669723, -122.486654171196) | 1 | 8 | 3 | 56 | 35 | ||
| 46391 | 87610 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 800X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/2014 12:00:00 AM | 3 | 3x3 | 5991263.805475 | 2092171.02552 | 37.7242009421806 | -122.472363351561 | (37.7242009421806, -122.472363351561) | 9 | 8 | 4 | 64 | 40 | ||
| 46498 | 29171 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3311 Ortega St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3x3 | 5983780.4899722 | 2102201.743436 | 37.7513066285159 | -122.49897241277 | (37.7513066285159, -122.49897241277) | 1 | 8 | 3 | 29491 | 35 | ||
| 46577 | 86562 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2207 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987900.988811 | 2100267.110901 | 37.746235480683 | -122.484581545679 | (37.746235480683, -122.484581545679) | 1 | 8 | 3 | 29491 | 35 | ||
| 46886 | 2120 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1100X Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||
| 47612 | 86360 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2499X 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988588.442516 | 2098328.661442 | 37.7409530183477 | -122.482062460919 | (37.7409530183477, -122.482062460919) | 1 | 8 | 3 | 29491 | 35 | ||
| 47924 | 6547 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1225X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/2011 12:00:00 AM | 3 | 4x4 | 6017625.4418446 | 2096995.6120179 | 37.7389387975003 | -122.381569480835 | (37.7389387975003, -122.381569480835) | 10 | 3 | 8 | 58 | 1 | ||
| 48005 | 255271 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 132 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007025.23745 | 2098691.33145 | 37.7430038973908 | -122.418340373368 | (37.7430038973908, -122.418340373368) | 2 | 7 | 7 | 28859 | 2 | ||||
| 48100 | 86046 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1375 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987395.4534 | 2105935.2927 | 37.7617693213048 | -122.486745751332 | (37.7617693213048, -122.486745751332) | 1 | 8 | 3 | 56 | 35 | ||
| 48205 | 19328 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 233 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2001 12:00:00 AM | 3 | 3x3 | 5993347.44444 | 2089823.33825 | 37.71787513632 | -122.46499015148 | (37.71787513632, -122.46499015148) | 9 | 8 | 6 | 64 | 24 |
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) );