trees
7,322 rows where qSpecies_id = 1 sorted by PlantDate descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10409 | 256902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 35267 | 256901 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 46403 | 256899 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 78259 | 256898 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 137019 | 256903 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 158583 | 256900 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 4039 | 101850 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001X Rhode Island St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 2 | 3x3 | Permit Number 774983 | 6011937.4679 | 2103668.00433 | 37.7569440557359 | -122.401704847401 | (37.7569440557359, -122.401704847401) | 10 | 3 | 8 | 28856 | 29 | |
| 2232 | 26076 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 269 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994312.4294 | 2088054.8516 | 37.7130748868127 | -122.461526506385 | (37.7130748868127, -122.461526506385) | 9 | 8 | 6 | 28861 | 24 | ||
| 10001 | 26085 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 137 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5995511.0035 | 2088041.696 | 37.7131076806722 | -122.457382907838 | (37.7131076806722, -122.457382907838) | 9 | 8 | 6 | 28861 | 24 | ||
| 18897 | 26095 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 15 | 3X3 | 5996463.56143 | 2088032.82115 | 37.7131379789998 | -122.454089924914 | (37.7131379789998, -122.454089924914) | 9 | 8 | 6 | 28861 | 24 | ||
| 26655 | 26073 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 285 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 8 | 3x3 | 5994159.2599 | 2088057.6707 | 37.7130738098987 | -122.462056111894 | (37.7130738098987, -122.462056111894) | 9 | 8 | 6 | 28861 | 24 | ||
| 64906 | 26342 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2630 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 6 | 3X3 | 5997363.52119 | 2088889.57468 | 37.7155419900373 | -122.451041118862 | (37.7155419900373, -122.451041118862) | 9 | 8 | 6 | 28861 | 24 | ||
| 66049 | 26033 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 32 Broad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 4 | 3X3 | 5996445.70952 | 2088085.75569 | 37.7132823012984 | -122.454155447727 | (37.7132823012984, -122.454155447727) | 9 | 8 | 6 | 28861 | 24 | ||
| 92590 | 26084 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 11 | 3X3 | 5995430.1902 | 2088042.6356 | 37.713105618543 | -122.457662291956 | (37.713105618543, -122.457662291956) | 9 | 8 | 6 | 28861 | 24 | ||
| 97905 | 26089 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 69 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5996119.07081 | 2088037.05628 | 37.7131298482426 | -122.455280899808 | (37.7131298482426, -122.455280899808) | 9 | 8 | 6 | 28861 | 24 | ||
| 124355 | 26034 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 32 Broad St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 10 | 3X3 | 5996410.41215 | 2088086.49287 | 37.7132823013076 | -122.454277500129 | (37.7132823013076, -122.454277500129) | 9 | 8 | 6 | 28861 | 24 | ||
| 130526 | 26074 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 281 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994215.6413 | 2088057.2008 | 37.7130757656446 | -122.461861206268 | (37.7130757656446, -122.461861206268) | 9 | 8 | 6 | 28861 | 24 | ||
| 131529 | 26082 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 205 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 8 | 3X3 | 5994939.7251 | 2088047.0152 | 37.7130894565529 | -122.459357809835 | (37.7130894565529, -122.459357809835) | 9 | 8 | 6 | 28861 | 24 | ||
| 154694 | 26081 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 219 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994828.0078 | 2088047.6499 | 37.7130847754132 | -122.459743985621 | (37.7130847754132, -122.459743985621) | 9 | 8 | 6 | 28861 | 24 | ||
| 161379 | 26079 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 233 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 9 | 3X3 | 5994695.0262 | 2088049.5542 | 37.7130823559233 | -122.460203749322 | (37.7130823559233, -122.460203749322) | 9 | 8 | 6 | 28861 | 24 | ||
| 174848 | 26072 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 287 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994124.0216 | 2088057.6707 | 37.7130717810019 | -122.46217790636 | (37.7130717810019, -122.46217790636) | 9 | 8 | 6 | 28861 | 24 | ||
| 178394 | 26080 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 225 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 6 | 3X3 | 5994777.2272 | 2088048.9194 | 37.7130853407984 | -122.459919591104 | (37.7130853407984, -122.459919591104) | 9 | 8 | 6 | 28861 | 24 | ||
| 187642 | 26090 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 10 | 3X3 | 5996152.88986 | 2088036.71972 | 37.7131308644675 | -122.455163986131 | (37.7131308644675, -122.455163986131) | 9 | 8 | 6 | 28861 | 24 | ||
| 46365 | 12564 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 6 | 3X3 | 5994519.02156 | 2114835.96421 | 37.7866209222593 | -122.462754079731 | (37.7866209222593, -122.462754079731) | 11 | 6 | 1 | 54 | 11 | ||
| 87808 | 39610 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 263 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41012 | 5996951.50653264 | 2106998.54134507 | 37.7652412023396 | -122.453772147788 | (37.7652412023396, -122.453772147788) | 15 | 5 | 11 | 29492 | 12 | ||
| 139971 | 35017 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38592 | 6001951.42049088 | 2120655.30141734 | 37.803024569063 | -122.43745670493 | (37.803024569063, -122.43745670493) | 13 | 9 | 1 | 57 | 17 | |||
| 92596 | 68942 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 483 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 8 | Permit Number 32930 | 5989044.93963 | 2112006.04505 | 37.7785339624062 | -122.481485522792 | (37.7785339624062, -122.481485522792) | 11 | 6 | 2 | 55 | 26 | |
| 24013 | 67828 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 710 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 3x3 | Permit Number 31489 | 5999080 | 2108181 | 37.768609734872 | -122.446495301803 | (37.768609734872, -122.446495301803) | 15 | 5 | 11 | 29492 | 9 | ||
| 79685 | 51846 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Permit Number 48071 | 6010119.81915 | 2114194.4742 | 37.785745710337 | -122.40873358881 | (37.785745710337, -122.40873358881) | 14 | 10 | 10 | 28852 | 36 | ||
| 108494 | 51845 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Permit Number 48071 | 6010129.68999 | 2114173.2637 | 37.7856880242154 | -122.408697941478 | (37.7856880242154, -122.408697941478) | 14 | 10 | 10 | 28852 | 36 | ||
| 134241 | 51844 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Permit Number 48071 | 6010139.87184 | 2114143.25233 | 37.7856061904094 | -122.408660597109 | (37.7856061904094, -122.408660597109) | 14 | 10 | 10 | 28852 | 36 | ||
| 15819 | 151746 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008502.96204 | 2106251.6003 | 37.763845762487 | -122.413765441348 | (37.763845762487, -122.413765441348) | 8 | 4 | 7 | 28859 | 19 | |
| 27220 | 159357 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998577.13551 | 2087591.01668 | 37.7120458522191 | -122.446752958004 | (37.7120458522191, -122.446752958004) | 9 | 7 | 6 | 28861 | 25 | |
| 74821 | 36044 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
| 124014 | 108228 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 390x TREAT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008492 | 2106262 | 37.763873702058 | -122.413804091523 | (37.763873702058, -122.413804091523) | 8 | 4 | 7 | 28859 | 19 | |
| 177206 | 36045 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
| 123614 | 11975 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 02:52:00 PM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.7316151284675 | -122.381940767084 | (37.7316151284675, -122.381940767084) | 10 | 3 | 8 | 58 | 1 | ||
| 30337 | 95112 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54040 | 6001677.19032 | 2093316.95797 | 37.7279446087442 | -122.436447856 | (37.7279446087442, -122.436447856) | 9 | 7 | 6 | 28861 | 25 |
| 113651 | 95107 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 140 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54036 | 6003089.39769 | 2094398.8785 | 37.7309954634676 | -122.431643031908 | (37.7309954634676, -122.431643031908) | 9 | 7 | 5 | 28861 | 25 |
| 8074 | 86491 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1610 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.6185 | 2104298.7956 | 37.7572997330502 | -122.485214007697 | (37.7572997330502, -122.485214007697) | 1 | 8 | 3 | 56 | 35 | ||
| 33162 | 86484 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1698 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987824.3728 | 2103790.6728 | 37.7559057744919 | -122.48510495178 | (37.7559057744919, -122.48510495178) | 1 | 8 | 3 | 56 | 35 | ||
| 39979 | 86489 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1642 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987810.0594 | 2104111.2911 | 37.7567852717409 | -122.485177975352 | (37.7567852717409, -122.485177975352) | 1 | 8 | 3 | 56 | 35 | ||
| 47107 | 86487 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1654 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987812.2064 | 2104044.7342 | 37.7566026495976 | -122.48516566702 | (37.7566026495976, -122.48516566702) | 1 | 8 | 3 | 56 | 35 | ||
| 117661 | 86488 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1646 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987812.9221 | 2104078.3705 | 37.7566950474544 | -122.485165659807 | (37.7566950474544, -122.485165659807) | 1 | 8 | 3 | 56 | 35 | ||
| 33287 | 52500 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 819 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | Permit Number 48609 | 6001190.9923 | 2092170.0943 | 37.7247679433807 | -122.438046534945 | (37.7247679433807, -122.438046534945) | 9 | 7 | 6 | 28861 | 25 | |
| 94089 | 52502 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 143 Del Monte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 4 | Permit Number 48611 | 5999302.61821 | 2088650.18481 | 37.7149955053203 | -122.444321557211 | (37.7149955053203, -122.444321557211) | 9 | 7 | 6 | 28861 | 25 | |
| 171485 | 52501 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 936 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 7 | Permit Number 48610 | 6000813.2364 | 2091503.87069 | 37.7229171547994 | -122.439304656784 | (37.7229171547994, -122.439304656784) | 9 | 7 | 6 | 28861 | 25 | |
| 148358 | 39509 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 958 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40961 | 6003748.2922704 | 2102673.97071857 | 37.7537542867453 | -122.429955182043 | (37.7537542867453, -122.429955182043) | 2 | 4 | 5 | 28862 | 22 | ||
| 63077 | 68857 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 251 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | 3x3 | Permit Number 32820 | 5999751.54816623 | 2094339.78804149 | 37.7306434531378 | -122.443178260697 | (37.7306434531378, -122.443178260697) | 9 | 7 | 4 | 63 | 40 | |
| 125062 | 12085 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1261X La Salle Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 3 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457 | -122.383068698568 | (37.732064349457, -122.383068698568) | 10 | 3 | 8 | 58 | 1 | ||
| 151094 | 6006 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1700X Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 3 | 4X4 | 6002299.53279 | 2112652.56753 | 37.781070910956 | -122.435679170736 | (37.781070910956, -122.435679170736) | 15 | 5 | 11 | 29490 | 41 | ||
| 106121 | 28990 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009604.59837 | 2108763.74502 | 37.7708053370391 | -122.410132567872 | (37.7708053370391, -122.410132567872) | 8 | 2 | 9 | 28853 | 34 | ||
| 33194 | 9214 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6300 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1996 12:00:00 AM | 3 | 3X3 | 5987447.6845 | 2112618.5625 | 37.7801227615519 | -122.487055961377 | (37.7801227615519, -122.487055961377) | 11 | 6 | 2 | 55 | 26 | ||
| 90301 | 15925 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5732 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 5997636.25268 | 2086801.42761 | 37.709824027618 | -122.449948033398 | (37.709824027618, -122.449948033398) | 9 | 7 | 6 | 28861 | 25 | ||
| 157102 | 15863 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5388 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 5999497.02422 | 2088213.75749 | 37.713808264409 | -122.443618276575 | (37.713808264409, -122.443618276575) | 9 | 7 | 6 | 28861 | 25 | ||
| 11708 | 86525 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1427 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987718.830744 | 2105574.527974 | 37.7607976071546 | -122.4856008555 | (37.7607976071546, -122.4856008555) | 1 | 8 | 3 | 56 | 35 | ||
| 23371 | 86529 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1495 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987733.4428 | 2105147.1779 | 37.7596250718264 | -122.485518957406 | (37.7596250718264, -122.485518957406) | 1 | 8 | 3 | 56 | 35 | ||
| 59896 | 86522 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1391 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987709.9444 | 2105829.3334 | 37.7614967154267 | -122.485650289777 | (37.7614967154267, -122.485650289777) | 1 | 8 | 3 | 56 | 35 | ||
| 83595 | 86526 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1451 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987724.225255 | 2105417.723091 | 37.7603673780759 | -122.485570690712 | (37.7603673780759, -122.485570690712) | 1 | 8 | 3 | 56 | 35 | ||
| 93640 | 86535 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1643 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987768.9123 | 2104094.2703 | 37.7567361402251 | -122.485319026462 | (37.7567361402251, -122.485319026462) | 1 | 8 | 3 | 56 | 35 | ||
| 109778 | 86521 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1375 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987704.6222 | 2105926.5837 | 37.761763428032 | -122.485675834421 | (37.761763428032, -122.485675834421) | 1 | 8 | 3 | 56 | 35 | ||
| 115583 | 86518 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1303 27th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987692.0426 | 2106311.7142 | 37.7628201578769 | -122.485747609042 | (37.7628201578769, -122.485747609042) | 1 | 8 | 3 | 56 | 35 | ||
| 125544 | 86528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1475 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987729.619764 | 2105260.918233 | 37.7599371490259 | -122.485540526282 | (37.7599371490259, -122.485540526282) | 1 | 8 | 3 | 56 | 35 | ||
| 131517 | 86493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1554 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987789.9439 | 2104700.6553 | 37.7584023340366 | -122.485290785915 | (37.7584023340366, -122.485290785915) | 1 | 8 | 3 | 56 | 35 | ||
| 135451 | 86531 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1539 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987744.6674 | 2104801.6568 | 37.7586770189507 | -122.485454781918 | (37.7586770189507, -122.485454781918) | 1 | 8 | 3 | 56 | 35 | ||
| 138278 | 86536 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1647 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987770.083674 | 2104084.735454 | 37.7567100283633 | -122.485314275845 | (37.7567100283633, -122.485314275845) | 1 | 8 | 3 | 56 | 35 | ||
| 143763 | 86533 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1567 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987750.3269 | 2104641.0122 | 37.7582362622963 | -122.485423420637 | (37.7582362622963, -122.485423420637) | 1 | 8 | 3 | 56 | 35 | ||
| 146549 | 86534 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1583 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987753.3744 | 2104537.834 | 37.7579531405489 | -122.485405309896 | (37.7579531405489, -122.485405309896) | 1 | 8 | 3 | 56 | 35 | ||
| 149195 | 86537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1651 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987769.5046 | 2104046.2923 | 37.7566044401478 | -122.485313457671 | (37.7566044401478, -122.485313457671) | 1 | 8 | 3 | 56 | 35 | ||
| 152009 | 86532 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1543 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987744.6674 | 2104775.5357 | 37.7586052975172 | -122.485452865076 | (37.7586052975172, -122.485452865076) | 1 | 8 | 3 | 56 | 35 | ||
| 156834 | 86524 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1419 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987718.0565 | 2105606.2705 | 37.7608847183469 | -122.485605862836 | (37.7608847183469, -122.485605862836) | 1 | 8 | 3 | 56 | 35 | ||
| 157573 | 86527 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987723.8783 | 2105392.1104 | 37.7602970324025 | -122.485570010965 | (37.7602970324025, -122.485570010965) | 1 | 8 | 3 | 56 | 35 | ||
| 157812 | 86523 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1403 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987713.0664 | 2105703.5781 | 37.7611516076704 | -122.485630262739 | (37.7611516076704, -122.485630262739) | 1 | 8 | 3 | 56 | 35 | ||
| 166255 | 86530 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1531 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987742.4906 | 2104849.1101 | 37.7588071859765 | -122.485465792475 | (37.7588071859765, -122.485465792475) | 1 | 8 | 3 | 56 | 35 | ||
| 174919 | 86492 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1590 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987797.7802 | 2104476.8848 | 37.7577883775501 | -122.485247265684 | (37.7577883775501, -122.485247265684) | 1 | 8 | 3 | 56 | 35 | ||
| 177375 | 86520 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1371 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987705.5899 | 2105968.1933 | 37.761877732989 | -122.48567554148 | (37.761877732989, -122.48567554148) | 1 | 8 | 3 | 56 | 35 | ||
| 178368 | 86517 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1303 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987692.0426 | 2106327.1968 | 37.7628626688502 | -122.485748745433 | (37.7628626688502, -122.485748745433) | 1 | 8 | 3 | 56 | 35 | ||
| 12435 | 9194 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6146 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/26/1996 12:00:00 AM | 3 | 4X4 | 5987891.5499 | 2112634.8281 | 37.780193292982 | -122.485521642506 | (37.780193292982, -122.485521642506) | 11 | 6 | 2 | 55 | 26 | ||
| 60563 | 26356 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2799 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/25/2000 12:00:00 AM | 3 | 3x3 | 5996673.0809324 | 2088043.0997611 | 37.7131782135078 | -122.453366500278 | (37.7131782135078, -122.453366500278) | 9 | 8 | 6 | 28861 | 24 | ||
| 147653 | 26357 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2799 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/25/2000 12:00:00 AM | 3 | 3x3 | 5996673.0809324 | 2088043.0997611 | 37.7131782135078 | -122.453366500278 | (37.7131782135078, -122.453366500278) | 9 | 8 | 6 | 28861 | 24 | ||
| 7279 | 12251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 512 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2014 12:00:00 AM | 3 | 3X3 | 6005037.9059 | 2110678.2828 | 37.77580516874 | -122.426065177531 | (37.77580516874, -122.426065177531) | 7 | 9 | 11 | 28852 | 10 | ||
| 33569 | 108551 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61-79X Santa Ysabel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 48937 | 108550 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61-79X Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 85875 | 108546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 174 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773708 | 6002822.5324 | 2094312.87706 | 37.7307441928912 | -122.432559488737 | (37.7307441928912, -122.432559488737) | 9 | 7 | 5 | 28861 | 25 |
| 86981 | 108552 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61-79X Santa Ysabel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 100768 | 57548 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150-152 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773714 | 6000424.90401 | 2091350.80794 | 37.722474772884 | -122.440636064423 | (37.722474772884, -122.440636064423) | 9 | 7 | 6 | 28861 | 25 | ||
| 154042 | 108549 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61-79X Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 35725 | 87097 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1158 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50054 | 6006999.78295 | 2115043.86261 | 37.7879026767179 | -122.419588337541 | (37.7879026767179, -122.419588337541) | 13 | 9 | 10 | 28858 | 21 | |
| 57775 | 87098 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1158 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50054 | 6007039 | 2115043 | 37.7879025171415 | -122.419452592213 | (37.7879025171415, -122.419452592213) | 13 | 9 | 10 | 28858 | 21 | ||
| 97726 | 87099 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1158 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50054 | 6007039 | 2115043 | 37.7879025171415 | -122.419452592213 | (37.7879025171415, -122.419452592213) | 13 | 9 | 10 | 28858 | 21 | ||
| 135884 | 87096 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1158 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50054 | 6007029.4066 | 2115046.46734 | 37.7879114972613 | -122.41948602978 | (37.7879114972613, -122.41948602978) | 13 | 9 | 10 | 28858 | 21 | |
| 148013 | 65466 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 390 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2015 12:00:00 AM | Permit Number 772421 | 5994212.59410655 | 2092453.3482292 | 37.7251463580423 | -122.462190365676 | (37.7251463580423, -122.462190365676) | 9 | 8 | 4 | 28861 | 24 | ||
| 76474 | 108500 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 133 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773778 | 5993020.3424 | 2114605.60013 | 37.7859019761698 | -122.467922339348 | (37.7859019761698, -122.467922339348) | 11 | 6 | 2 | 54 | 11 | |
| 128087 | 108514 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1630 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773662 | 5991178.20693 | 2104273.2686 | 37.7574256471732 | -122.473541611476 | (37.7574256471732, -122.473541611476) | 1 | 8 | 4 | 56 | 12 |
| 159437 | 69477 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1630 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | Permit Number 773662 | 5991184.07819473 | 2104274.50290472 | 37.7574293762585 | -122.473521396538 | (37.7574293762585, -122.473521396538) | 1 | 8 | 4 | 56 | 12 | |
| 114125 | 15858 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5360 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2009 12:00:00 AM | 3 | 3X3 | 5999561.44324 | 2088284.73015 | 37.7140068131504 | -122.443400716192 | (37.7140068131504, -122.443400716192) | 9 | 7 | 6 | 28861 | 25 | ||
| 106946 | 12780 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1908 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1991 12:00:00 AM | 20 | 3X3 | 5989502.50585 | 2114734.73885 | 37.7860527853316 | -122.480102398429 | (37.7860527853316, -122.480102398429) | 11 | 6 | 1 | 55 | 33 | ||
| 3418 | 241507 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5235 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2016 07:34:00 AM | 1 | Width 2ft | 6001160.66626 | 2099296.94355 | 37.7443348933555 | -122.438661800724 | (37.7443348933555, -122.438661800724) | 2 | 7 | 5 | 63 | 22 | ||
| 133208 | 52445 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 755 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 6 | Permit Number 48557 | 5992862.06428 | 2110321.19403 | 37.7741290201827 | -122.468158154981 | (37.7741290201827, -122.468158154981) | 11 | 6 | 2 | 54 | 11 | |
| 180055 | 26051 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 144 Broad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | 9 | 3X3 | 5995427.3711 | 2088097.1376 | 37.713255106322 | -122.457675976804 | (37.713255106322, -122.457675976804) | 9 | 8 | 6 | 28861 | 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) );