trees
1,813 rows where qSpecies_id = 149
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 868 | 62378 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1985 12:00:00 AM | 24 | Permit Number 22527 | 5986003.03353 | 2111613.32749 | 37.7772783336166 | -122.491979564694 | (37.7772783336166, -122.491979564694) | 11 | 6 | 2 | 55 | 26 | |
| 894 | 260859 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 739 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985675.22385 | 2110852.85567 | 37.7751711283725 | -122.493057514378 | (37.7751711283725, -122.493057514378) | 11 | 6 | 2 | 55 | 26 | |||
| 1145 | 180443 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 599 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008502.54989 | 2091553.3243 | 37.7234875219066 | -122.412727694727 | (37.7234875219066, -122.412727694727) | 9 | 3 | 7 | 309 | 28 | |||
| 1670 | 79959 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1719 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014649.30917 | 2095031.35513 | 37.7333805797332 | -122.39172235292 | (37.7333805797332, -122.39172235292) | 10 | 3 | 8 | 58 | 1 | |||
| 1706 | 124216 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 107 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5996487.33444 | 2112259.12921 | 37.7796587851836 | -122.455757897014 | (37.7796587851836, -122.455757897014) | 11 | 6 | 2 | 54 | 16 | |||
| 1812 | 52955 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 516 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48942 | 5993282.16384919 | 2090617.22186434 | 37.7200511847077 | -122.465273429637 | (37.7200511847077, -122.465273429637) | 9 | 8 | 6 | 64 | 24 | ||
| 1921 | 70333 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 143 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009984.51803 | 2093871.67123 | 37.7299362833339 | -122.407768169286 | (37.7299362833339, -122.407768169286) | 10 | 3 | 7 | 309 | 28 | |||
| 2092 | 262061 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 2160 | 29663 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2200X Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5991214.62649 | 2094785.74836 | 37.7313774711782 | -122.472723912001 | (37.7313774711782, -122.472723912001) | 1 | 8 | 4 | 64 | 40 | |||
| 2268 | 48916 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 77 Connecticut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | 5 | Permit Number 46108 | 6013166.41174 | 2106720.77544 | 37.7653947970535 | -122.397668781803 | (37.7653947970535, -122.397668781803) | 14 | 3 | 8 | 28856 | 20 | ||
| 2555 | 43786 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 354 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43416 | 5989368.92132 | 2112957.36095 | 37.7811648425807 | -122.480434412156 | (37.7811648425807, -122.480434412156) | 11 | 6 | 2 | 55 | 26 | |
| 2592 | 6305 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1797X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | 9 | 3X3 | 6002532.11938 | 2112833.28187 | 37.7815803152054 | -122.434887466275 | (37.7815803152054, -122.434887466275) | 15 | 5 | 11 | 29490 | 41 | ||
| 2603 | 50904 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2094 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47411 | 5991019.11429888 | 2101160.98347731 | 37.7488709142667 | -122.473864759666 | (37.7488709142667, -122.473864759666) | 1 | 8 | 4 | 29491 | 12 | ||
| 2606 | 242331 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 206 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004526.0717 | 2099598.82102 | 37.7453546561933 | -122.427046431465 | (37.7453546561933, -122.427046431465) | 2 | 7 | 5 | 63 | 22 | |||
| 2969 | 47721 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2325 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001839.98608 | 2118371.66878 | 37.7967479784971 | -122.437678679828 | (37.7967479784971, -122.437678679828) | 13 | 9 | 1 | 57 | 17 | |
| 3156 | 115362 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101X Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6012895.14842 | 2106528.52357 | 37.7648518070998 | -122.398593533074 | (37.7648518070998, -122.398593533074) | 14 | 3 | 8 | 28856 | 29 | |||
| 3214 | 70482 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 935 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005101.62772 | 2092066.92628 | 37.7247062894408 | -122.424520594648 | (37.7247062894408, -122.424520594648) | 9 | 7 | 6 | 28861 | 5 | |||
| 3376 | 25308 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 279X Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2011 12:00:00 AM | 3 | 3x3 | 6000039.97311 | 2091577.86047 | 37.7230762793257 | -122.441982968035 | (37.7230762793257, -122.441982968035) | 9 | 7 | 6 | 28861 | 25 | ||
| 3493 | 90355 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 745 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993230.15342 | 2111367.69142 | 37.7770236721988 | -122.466960976467 | (37.7770236721988, -122.466960976467) | 11 | 6 | 2 | 54 | 11 | ||
| 3607 | 262063 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 3687 | 68254 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 3835 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32056 | 6000569.04912 | 2121537.58273 | 37.8053683895105 | -122.442303792382 | (37.8053683895105, -122.442303792382) | 13 | 9 | 1 | 57 | 17 | |
| 3707 | 51415 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 7121 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47739 | |||||||||||||
| 3815 | 33282 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1250 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 4 | Permit Number 37445 | 6008545.83527 | 2116894.20233 | 37.793070222573 | -122.414370236296 | (37.793070222573, -122.414370236296) | 5 | 1 | 10 | 28857 | 21 | |
| 4172 | 44480 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 295 Harvard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43790 | 6006326.11018523 | 2092518.45956429 | 37.7260151764118 | -122.420319736223 | (37.7260151764118, -122.420319736223) | 9 | 7 | 7 | 309 | 5 | ||
| 4214 | 70336 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 324 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009735.9866 | 2094035.87413 | 37.7303732333298 | -122.408638954927 | (37.7303732333298, -122.408638954927) | 10 | 3 | 7 | 309 | 28 | |||
| 4299 | 74119 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 164 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014130.8006 | 2112451.57445 | 37.7811839433263 | -122.394734525092 | (37.7811839433263, -122.394734525092) | 6 | 2 | 9 | 28856 | 6 | |||
| 4398 | 149806 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1095 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2020 12:00:00 AM | 3 | Width 4 | 6015039.51636 | 2103405.11411 | 37.7563948325734 | -122.390958336561 | (37.7563948325734, -122.390958336561) | 10 | 3 | 8 | 28856 | 29 | ||
| 4410 | 44473 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 258 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 6 | Permit Number 43787 | 6006246.79793 | 2092607.35071 | 37.7262547826049 | -122.420600221446 | (37.7262547826049, -122.420600221446) | 9 | 7 | 7 | 309 | 5 | |
| 4447 | 32582 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1495 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 5 | Permit Number 37056 | 5985870.4662 | 2105123.0518 | 37.7594501102368 | -122.49196019557 | (37.7594501102368, -122.49196019557) | 1 | 8 | 3 | 56 | 35 | |
| 4483 | 262070 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 10 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 4510 | 262317 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1508 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013158 | 2096333 | 37.7368717300177 | -122.396969492274 | (37.7368717300177, -122.396969492274) | 10 | 3 | 8 | 58 | 1 | ||||
| 4520 | 80637 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 706 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011239.20103 | 2105002.70461 | 37.7605698551303 | -122.404213664555 | (37.7605698551303, -122.404213664555) | 10 | 3 | 8 | 28856 | 29 | |||
| 4636 | 260858 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 730 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985713.16819 | 2110906.59773 | 37.7753209078179 | -122.492930217758 | (37.7753209078179, -122.492930217758) | 11 | 6 | 2 | 55 | 26 | |||
| 4659 | 262488 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 609 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008980.84457 | 2093750.19118 | 37.7295464865785 | -122.411229423312 | (37.7295464865785, -122.411229423312) | 9 | 3 | 7 | 309 | 28 | ||||
| 4807 | 90317 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2201 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988709.47334 | 2111203.76821 | 37.7763116232267 | -122.482587210366 | (37.7763116232267, -122.482587210366) | 11 | 6 | 2 | 55 | 26 | ||
| 4863 | 78532 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 501 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010074.13409 | 2092167.4028 | 37.7252617368386 | -122.407338256469 | (37.7252617368386, -122.407338256469) | 10 | 3 | 7 | 309 | 28 | |||
| 4895 | 117122 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2550 34TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2016 12:00:00 AM | 3 | 3x3 | 5985875 | 2097864 | 37.7395189911199 | -122.491410221624 | (37.7395189911199, -122.491410221624) | 1 | 8 | 3 | 29491 | 35 | ||
| 5066 | 262068 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 5145 | 55623 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 801 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 5 | 2x2 | Permit Number 32605 | 5992996.77479 | 2113442.83474 | 37.7827079796527 | -122.467919271364 | (37.7827079796527, -122.467919271364) | 11 | 6 | 2 | 54 | 11 |
| 5282 | 10014 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 224 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:44:00 AM | 3 | 2x3 | 6005430.43675 | 2107671.80391 | 37.7675722796594 | -122.424493411759 | (37.7675722796594, -122.424493411759) | 8 | 4 | 5 | 28853 | 19 | ||
| 5565 | 91066 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 20 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2008 12:00:00 AM | 3x3 | Permit Number 51973 | 5992794.6 | 2093140.2 | 37.7269505362801 | -122.467142098378 | (37.7269505362801, -122.467142098378) | 9 | 8 | 4 | 59 | 40 | ||
| 5851 | 242898 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1050 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009967.25969 | 2103043.92706 | 37.7551203376501 | -122.408474577742 | (37.7551203376501, -122.408474577742) | 2 | 4 | 7 | 28859 | 19 | |||
| 5907 | 70407 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 231 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6006535.83698 | 2092862.23217 | 37.7269709172726 | -122.419619102459 | (37.7269709172726, -122.419619102459) | 9 | 7 | 7 | 309 | 5 | |||
| 6059 | 94720 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 24 Blake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 53854 | 5997798.497 | 2113560.5927 | 37.7833074222878 | -122.451315930077 | (37.7833074222878, -122.451315930077) | 15 | 6 | 1 | 54 | 31 |
| 6205 | 70404 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 218 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6006477.26442 | 2092881.04144 | 37.7270192639056 | -122.419822921186 | (37.7270192639056, -122.419822921186) | 9 | 7 | 7 | 309 | 5 | |||
| 6561 | 45242 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 604 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44093 | 6008555.70872799 | 2091212.30248413 | 37.7225541315384 | -122.412519838952 | (37.7225541315384, -122.412519838952) | 9 | 3 | 7 | 309 | 18 | ||
| 6744 | 259097 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 801 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
| 6850 | 53974 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 985 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/1972 12:00:00 AM | 4 | Permit Number 9690 | 6009227.86007 | 2115996.16493 | 37.7906427194462 | -122.411946891629 | (37.7906427194462, -122.411946891629) | 5 | 1 | 10 | 28857 | 21 | |
| 6865 | 10095 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 727 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2015 12:00:00 AM | 3 | 2X2 | 6005664.236 | 2104708.85405 | 37.759449920391 | -122.423474060781 | (37.759449920391, -122.423474060781) | 2 | 4 | 5 | 28859 | 19 | ||
| 7065 | 198271 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Pennsylvania Ave | 17 | Front Yard : Yard | Tree | Private 2 | 1 | 6014323.67834 | 2106481.09805 | 37.7648010700346 | -122.393649256519 | (37.7648010700346, -122.393649256519) | 14 | 3 | 8 | 310 | 29 | ||||
| 7186 | 262074 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 14 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 7232 | 262073 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 13 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 7432 | 40564 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 223 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 41608 | 6003273.4207217 | 2109055.89818285 | 37.7712506170222 | -122.432053094849 | (37.7712506170222, -122.432053094849) | 15 | 9 | 11 | 29492 | 9 | ||
| 7652 | 180469 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 599 University St | 37 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008151.81482 | 2092695.50031 | 37.7266040019517 | -122.414020889251 | (37.7266040019517, -122.414020889251) | 9 | 3 | 7 | 309 | 28 | |||
| 7671 | 82808 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 637 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5992833.07706 | 2111118.80762 | 37.7763173780733 | -122.468316464164 | (37.7763173780733, -122.468316464164) | 11 | 6 | 2 | 54 | 11 | |||
| 7705 | 106005 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 59 Reddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6013632.51665 | 2093922.487 | 37.7302793593954 | -122.395160068985 | (37.7302793593954, -122.395160068985) | 10 | 3 | 8 | 58 | 1 | ||
| 7840 | 74171 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 466 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6011049.67315 | 2111947.37062 | 37.7796277285636 | -122.405358235294 | (37.7796277285636, -122.405358235294) | 14 | 2 | 9 | 28853 | 34 | |||
| 7854 | 70573 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 862 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5982961.78283 | 2109923.12422 | 37.772459289826 | -122.502374937437 | (37.772459289826, -122.502374937437) | 11 | 6 | 2 | 55 | 26 | |||
| 7941 | 47968 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 487 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2002 12:00:00 AM | Permit Number 45698 | 5998723.98262042 | 2097661.13122407 | 37.7397044270458 | -122.446969612962 | (37.7397044270458, -122.446969612962) | 9 | 7 | 4 | 59 | 40 | |||
| 8020 | 95515 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | 11 | 6 | 2 | 55 | 26 | |||
| 8058 | 117668 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4826 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5983640.52001 | 2111755.82857 | 37.7775312233534 | -122.500162667158 | (37.7775312233534, -122.500162667158) | 11 | 6 | 2 | 55 | 26 | |||
| 8124 | 21894 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2068 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/1999 12:00:00 AM | 3 | 2X3 | 6015677.89854 | 2105976.47682 | 37.7634906462863 | -122.388930084758 | (37.7634906462863, -122.388930084758) | 14 | 3 | 8 | 28856 | 29 | ||
| 8175 | 96922 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 3208 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767943 | 6001392.66231 | 2119445.87754 | 37.799672028811 | -122.43930355514 | (37.799672028811, -122.43930355514) | 13 | 9 | 1 | 57 | 17 | |
| 8445 | 180433 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 25 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6003815.49396 | 2093259.77079 | 37.7279088588998 | -122.429051608444 | (37.7279088588998, -122.429051608444) | 9 | 7 | 6 | 28861 | 5 | |||
| 8450 | 79034 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 10 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 2.5x4 | 6010138.62156 | 2111398.24518 | 37.7780689795412 | -122.408471225064 | (37.7780689795412, -122.408471225064) | 14 | 2 | 9 | 28853 | 34 | |||
| 8451 | 45718 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1784 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2001 12:00:00 AM | Permit Number 44388 | 6014427.08068492 | 2096662.22075279 | 37.7378462639335 | -122.392604707928 | (37.7378462639335, -122.392604707928) | 10 | 3 | 8 | 58 | 1 | |||
| 8500 | 42868 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2649 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 0 | Permit Number 42791 | 5986726.28385176 | 2097377.23824555 | 37.7382321808059 | -122.4884311274 | (37.7382321808059, -122.4884311274) | 1 | 8 | 3 | 29491 | 35 | |
| 8649 | 198312 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 81 Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014325.56305 | 2114147.83058 | 37.7858523015842 | -122.394179529164 | (37.7858523015842, -122.394179529164) | 6 | 2 | 9 | 28855 | 6 | |||
| 8695 | 81965 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 838 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49958 | 5985125.36626 | 2110132.785 | 37.7731618468332 | -122.494906462717 | (37.7731618468332, -122.494906462717) | 11 | 6 | 2 | 55 | 26 | |
| 8766 | 36304 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 98 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1998 12:00:00 AM | Permit Number 39288 | 5990632.40828813 | 2094456.10044746 | 37.7304386209332 | -122.474712677246 | (37.7304386209332, -122.474712677246) | 9 | 8 | 4 | 64 | 40 | ||
| 8849 | 180406 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 23 Gorham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002284.81507 | 2094188.81681 | 37.7303730435723 | -122.43440959294 | (37.7303730435723, -122.43440959294) | 9 | 7 | 5 | 28861 | 25 | |||
| 9122 | 114471 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2351 Powell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009306.05236 | 2121599.38823 | 37.806032175519 | -122.412072506246 | (37.806032175519, -122.412072506246) | 3 | 1 | 10 | 308 | 23 | |||
| 9144 | 254818 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2699 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997230 | 2088538 | 37.7145690020879 | -122.451477282388 | (37.7145690020879, -122.451477282388) | 9 | 8 | 6 | 28861 | 24 | ||||
| 9282 | 52188 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 76 Camona Av | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2005 12:00:00 AM | Permit Number 48379 | |||||||||||||
| 9363 | 262072 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 12 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 9571 | 72258 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 230 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6002786.80425 | 2092214.20259 | 37.7249796797621 | -122.432533160192 | (37.7249796797621, -122.432533160192) | 9 | 7 | 6 | 28861 | 5 | |||
| 9621 | 52101 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 617 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48293 | 5997803.4253965 | 2097997.84613294 | 37.7405763287339 | -122.45017675612 | (37.7405763287339, -122.45017675612) | 9 | 7 | 4 | 59 | 40 | ||
| 9644 | 92948 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 3754 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2014 12:00:00 AM | 1 | Permit Number 771810 | 5996901.84639 | 2115031.16705 | 37.7872938464806 | -122.454524237197 | (37.7872938464806, -122.454524237197) | 11 | 6 | 1 | 54 | 31 | ||
| 9771 | 8890 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4300 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/1996 12:00:00 AM | 3 | 3X3 | 5993676.36815 | 2112846.77323 | 37.7811105766569 | -122.465524870362 | (37.7811105766569, -122.465524870362) | 11 | 6 | 2 | 54 | 11 | ||
| 9833 | 262515 | Section 806 (d) 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1951 34th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 779100 | 5985670.12137 | 2101944.25665 | 37.7507102998335 | -122.49241898675 | (37.7507102998335, -122.49241898675) | 1 | 8 | 3 | 29491 | 35 | |
| 9978 | 100882 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 91 Welsh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013366.22546 | 2111763.75465 | 37.7792528084154 | -122.397331345366 | (37.7792528084154, -122.397331345366) | 6 | 2 | 9 | 28856 | 34 | |||
| 10179 | 120186 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 172 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5987746.67951 | 2114854.71533 | 37.7862800304413 | -122.48618581827 | (37.7862800304413, -122.48618581827) | 11 | 6 | 1 | 55 | 33 | |||
| 10287 | 114729 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1930 35TH AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 12/03/2015 12:00:00 AM | 4x4 | 5985421 | 2102058 | 37.7510080399178 | -122.493288836187 | (37.7510080399178, -122.493288836187) | 1 | 8 | 3 | 29491 | 35 | |||
| 10363 | 10190 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1160 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2015 09:38:00 AM | 3 | 3x3 | 6005734.23383 | 2102203.68607 | 37.7525752625596 | -122.42305391193 | (37.7525752625596, -122.42305391193) | 2 | 4 | 5 | 28859 | 19 | ||
| 10471 | 93394 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 3077 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996268.61185 | 2111428.40102 | 37.7773652699243 | -122.456454460594 | (37.7773652699243, -122.456454460594) | 11 | 6 | 2 | 54 | 16 | ||
| 10477 | 111395 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2142 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2015 12:00:00 AM | 3 | 3x3 | 5985780.6 | 2100633.8 | 37.7471186003164 | -122.491940478624 | (37.7471186003164, -122.491940478624) | 1 | 8 | 3 | 29491 | 35 | ||
| 10870 | 27147 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1745 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6011162.37541 | 2095219.41257 | 37.7337027663166 | -122.403790951032 | (37.7337027663166, -122.403790951032) | 10 | 3 | 8 | 58 | 1 | |||
| 10891 | 253432 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 501X Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/25/2017 04:09:00 PM | 3 | 3x3 | 6002703 | 2090930 | 37.721448793681 | -122.432731166998 | (37.721448793681, -122.432731166998) | 9 | 7 | 6 | 28861 | 5 | ||
| 10965 | 22743 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1575 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2001 12:00:00 AM | 6 | 3x3 | 6002621.38954 | 2112212.2211 | 37.7798801065849 | -122.434534214215 | (37.7798801065849, -122.434534214215) | 15 | 5 | 11 | 29490 | 41 | ||
| 11030 | 70481 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 934 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6005107.91916 | 2092023.60961 | 37.7245877066523 | -122.424495766183 | (37.7245877066523, -122.424495766183) | 9 | 7 | 6 | 28861 | 5 | |||
| 11166 | 50127 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 83 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46849 | 5993092.89908961 | 2098512.16138225 | 37.7417178192078 | -122.466501174224 | (37.7417178192078, -122.466501174224) | 1 | 8 | 4 | 59 | 40 | ||
| 11232 | 74369 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 535 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 8x4 | 6009942.57894 | 2111988.44029 | 37.7796785357608 | -122.409191067621 | (37.7796785357608, -122.409191067621) | 14 | 2 | 9 | 28853 | 34 | ||
| 11235 | 70562 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 164 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6014127.69322 | 2112419.53716 | 37.7810958034577 | -122.394743030892 | (37.7810958034577, -122.394743030892) | 6 | 2 | 9 | 28856 | 6 | |||
| 11441 | 50511 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 758 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | Permit Number 47146 | 6002437.29594714 | 2089127.99525636 | 37.7164858160818 | -122.433520918153 | (37.7164858160818, -122.433520918153) | 9 | 7 | 6 | 28861 | 5 | ||
| 11457 | 180432 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 245 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000158.15201 | 2091623.21289 | 37.7232075404877 | -122.44157770136 | (37.7232075404877, -122.44157770136) | 9 | 7 | 6 | 28861 | 25 | |||
| 11579 | 50042 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 301-399 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46772 | 6008166.14565124 | 2092655.50179392 | 37.7264949794548 | -122.413968519598 | (37.7264949794548, -122.413968519598) | 9 | 3 | 7 | 309 | 28 | ||
| 11601 | 95514 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | 11 | 6 | 2 | 55 | 26 | ||
| 11777 | 259096 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 801 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
| 11812 | 241417 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 110 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 785523 | 6004524.68295 | 2095964.43408 | 37.7353753785744 | -122.426792456628 | (37.7353753785744, -122.426792456628) | 2 | 7 | 5 | 28861 | 2 | |
| 11843 | 25286 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2232X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1996 12:00:00 AM | 6 | 2X3 | 5992636.99947 | 2093738.93892 | 37.7285854269889 | -122.467730442067 | (37.7285854269889, -122.467730442067) | 9 | 8 | 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) );