trees
4,014 rows where qSpecies_id = 40 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6813 | 256911 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
105181 | 178971 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 509 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010024.16897 | 2086365.71669 | 37.7093287026266 | -122.407102219496 | (37.7093287026266, -122.407102219496) | 9 | 7 | 8 | 309 | 39 | |||
184571 | 179035 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 178 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 772137 | 6010379.06325 | 2086412.15144 | 37.7094760574448 | -122.405878910409 | (37.7094760574448, -122.405878910409) | 9 | 7 | 8 | 309 | 39 | |
122842 | 31023 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 330 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34788 | 6002794.80361 | 2086503.38224 | 37.7092994800486 | -122.43209787574 | (37.7092994800486, -122.43209787574) | 9 | 7 | 6 | 28861 | 5 | |
174366 | 31022 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 330 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 8 | Permit Number 34788 | 6002783.56511 | 2086520.12567 | 37.7093448166924 | -122.43213791266 | (37.7093448166924, -122.43213791266) | 9 | 7 | 6 | 28861 | 5 | |
186213 | 109055 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 320 Hanover St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772693 | 5999569.6 | 2086544.4 | 37.7092287229218 | -122.443247602414 | (37.7092287229218, -122.443247602414) | 9 | 7 | 6 | 28861 | 5 | |
130405 | 31021 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 317 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 7 | Permit Number 34787 | 6002776.11429 | 2086581.19162 | 37.7095120680942 | -122.432168021935 | (37.7095120680942, -122.432168021935) | 9 | 7 | 6 | 28861 | 5 | |
40488 | 179162 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 171 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002093.74544 | 2086607.8879 | 37.7095466578231 | -122.434528308849 | (37.7095466578231, -122.434528308849) | 9 | 7 | 6 | 28861 | 5 | |||
123056 | 179163 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 171 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002120.7512 | 2086617.73419 | 37.7095752265844 | -122.43443567596 | (37.7095752265844, -122.43443567596) | 9 | 7 | 6 | 28861 | 5 | |||
69041 | 44741 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 271 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 3 | Permit Number 43859 | 5992054.55445 | 2086618.70048 | 37.7090013413078 | -122.469225944836 | (37.7090013413078, -122.469225944836) | 9 | 8 | 4 | 64 | 24 | |
153268 | 179161 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 233 Naylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6002647.79999 | 2086739.65434 | 37.7099398962889 | -122.432622809119 | (37.7099398962889, -122.432622809119) | 9 | 7 | 6 | 28861 | 5 | |||
114390 | 178972 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 856 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781438 | 6009124.92679 | 2086754.63916 | 37.7103462396574 | -122.410237598787 | (37.7103462396574, -122.410237598787) | 9 | 7 | 8 | 309 | 39 | |
55343 | 179153 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 412 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 8ft | 6001969.08964 | 2086773.82028 | 37.7099951946836 | -122.434970999229 | (37.7099951946836, -122.434970999229) | 9 | 7 | 6 | 28861 | 5 | |||
180233 | 109051 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 32 De Long St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772570 | 5995048.30925 | 2086814.92441 | 37.7097126663738 | -122.45889335865 | (37.7097126663738, -122.45889335865) | 9 | 8 | 6 | 28861 | 25 |
150615 | 57927 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 559 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 3 | Permit Number 16885 | 5999203.25613 | 2086855.58023 | 37.7100622571339 | -122.444536089569 | (37.7100622571339, -122.444536089569) | 9 | 7 | 6 | 28861 | 5 | ||
91881 | 84197 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 551 Sawyer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50697 | 6007614.52495 | 2086883.32703 | 37.7106148095844 | -122.41546698201 | (37.7106148095844, -122.41546698201) | 9 | 7 | 8 | 309 | 39 | |
90151 | 108899 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 16 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772775 | 6000547.04329 | 2086890.00633 | 37.7102333694046 | -122.43989417722 | (37.7102333694046, -122.43989417722) | 9 | 7 | 6 | 28861 | 5 |
61096 | 179036 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 551 Sawyer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007618.72078 | 2086894.99872 | 37.7106470934606 | -122.415453306029 | (37.7106470934606, -122.415453306029) | 9 | 7 | 8 | 309 | 39 | |||
50426 | 178970 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1029 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008583.66239 | 2086910.82676 | 37.7107447436356 | -122.412119359132 | (37.7107447436356, -122.412119359132) | 9 | 7 | 8 | 309 | 39 | |||
41071 | 178969 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1029 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008570.63643 | 2086915.27252 | 37.710756219889 | -122.412164693966 | (37.710756219889, -122.412164693966) | 9 | 7 | 8 | 309 | 39 | |||
88047 | 178968 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1029 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008554.00356 | 2086922.92709 | 37.710776304465 | -122.412222721805 | (37.710776304465, -122.412222721805) | 9 | 7 | 8 | 309 | 39 | |||
51918 | 84222 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1099 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.7107908725318 | -122.412283117187 | (37.7107908725318, -122.412283117187) | 9 | 7 | 8 | 309 | 39 | ||
84241 | 84211 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1099 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.7107908725318 | -122.412283117187 | (37.7107908725318, -122.412283117187) | 9 | 7 | 8 | 309 | 39 | ||
171735 | 84223 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1099 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.7107908725318 | -122.412283117187 | (37.7107908725318, -122.412283117187) | 9 | 7 | 8 | 309 | 39 | ||
28068 | 178967 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 505 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5999517.95201 | 2086983.49864 | 37.7104314441356 | -122.443457625269 | (37.7104314441356, -122.443457625269) | 9 | 7 | 6 | 28861 | 5 | |||
190502 | 37342 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 507 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 15 | Permit Number 39850 | 5999504.92576 | 2086983.76919 | 37.7104314441222 | -122.443502666028 | (37.7104314441222, -122.443502666028) | 9 | 7 | 6 | 28861 | 5 | |
194103 | 109076 | Property Tree 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 772744 | 6001554.7 | 2087011.6 | 37.7106245477128 | -122.436420213894 | (37.7106245477128, -122.436420213894) | 9 | 7 | 6 | 28861 | 5 | ||
49051 | 69397 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2015 12:00:00 AM | 3 | Permit Number 772744 | 6001523.93675849 | 2087030.79827901 | 37.7106755138649 | -122.436527911504 | (37.7106755138649, -122.436527911504) | 9 | 7 | 6 | 28861 | 5 | |
114270 | 31058 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 32 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 6 | Permit Number 34809 | 6002732.75221 | 2087097.44922 | 37.7109271405403 | -122.432354735598 | (37.7109271405403, -122.432354735598) | 9 | 7 | 6 | 28861 | 5 | |
184269 | 31057 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 32 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 5 | Permit Number 34809 | 6002747.27797 | 2087115.57732 | 37.7109777400017 | -122.43230582505 | (37.7109777400017, -122.43230582505) | 9 | 7 | 6 | 28861 | 5 | |
105221 | 178979 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 190 Rae Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5997616.63139 | 2087136.84676 | 37.7107438892848 | -122.450040007061 | (37.7107438892848, -122.450040007061) | 9 | 7 | 6 | 28861 | 25 | |||
19987 | 109057 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 825 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772770 | 5997289.53523 | 2087142.99435 | 37.7107420465867 | -122.451170962984 | (37.7107420465867, -122.451170962984) | 9 | 7 | 6 | 28861 | 25 |
73369 | 178978 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 190 Rae Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5997625.81626 | 2087145.61951 | 37.7107685028255 | -122.450008894089 | (37.7107685028255, -122.450008894089) | 9 | 7 | 6 | 28861 | 25 | |||
109316 | 178977 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 190 Rae Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 5997636.8287 | 2087155.69902 | 37.7107968089962 | -122.449971558745 | (37.7107968089962, -122.449971558745) | 9 | 7 | 6 | 28861 | 25 | |||
153903 | 69395 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1075 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 4 | Permit Number 33499 | 6002066.46838 | 2087158.9447 | 37.7110581906667 | -122.434661960708 | (37.7110581906667, -122.434661960708) | 9 | 7 | 6 | 28861 | 5 | |
171704 | 179021 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5642 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5998317.81093 | 2087173.37189 | 37.7108842770725 | -122.447619209286 | (37.7108842770725, -122.447619209286) | 9 | 7 | 6 | 28861 | 25 | |||
17266 | 178980 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 38 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998273.42881 | 2087174.03892 | 37.7108835719974 | -122.447772651587 | (37.7108835719974, -122.447772651587) | 9 | 7 | 6 | 28861 | 25 | |||
162470 | 109069 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1065 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772763 | 6002105.57012 | 2087176.80573 | 37.7111094529054 | -122.434528092094 | (37.7111094529054, -122.434528092094) | 9 | 7 | 6 | 28861 | 5 |
80615 | 99888 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
97482 | 99892 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
118066 | 99890 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
140023 | 99887 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
182794 | 99891 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
192701 | 99889 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
176378 | 178981 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 38 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998261.9451 | 2087183.38329 | 37.7109085731488 | -122.447813014086 | (37.7109085731488, -122.447813014086) | 9 | 7 | 6 | 28861 | 25 | |||
65700 | 179020 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5642 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5998346.4551 | 2087191.26802 | 37.7109350527871 | -122.447521496121 | (37.7109350527871, -122.447521496121) | 9 | 7 | 6 | 28861 | 25 | |||
2810 | 178982 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 38 Whipple Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998252.81183 | 2087192.10261 | 37.7109319923872 | -122.447845208002 | (37.7109319923872, -122.447845208002) | 9 | 7 | 6 | 28861 | 25 | |||
53530 | 178983 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 38 Whipple Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998242.85384 | 2087202.59008 | 37.7109602194148 | -122.447880379569 | (37.7109602194148, -122.447880379569) | 9 | 7 | 6 | 28861 | 25 | |||
180965 | 51976 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 163 Rae Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2005 12:00:00 AM | Permit Number 48195 | 5997753.64161846 | 2087210.79293758 | 37.7109547676767 | -122.449571795733 | (37.7109547676767, -122.449571795733) | 9 | 7 | 6 | 28861 | 25 | |||
120095 | 95016 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010516.6 | 2087234.5 | 37.7117417518759 | -122.405461434977 | (37.7117417518759, -122.405461434977) | 9 | 7 | 8 | 309 | 39 | |||
181121 | 69417 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 149 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 7 | Permit Number 33522 | 6001453.45984 | 2087297.44526 | 37.7114036625088 | -122.436790570551 | (37.7114036625088, -122.436790570551) | 9 | 7 | 6 | 28861 | 5 | |
117218 | 179159 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 113 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001727.04807 | 2087313.14686 | 37.7114623208022 | -122.435846103423 | (37.7114623208022, -122.435846103423) | 9 | 7 | 6 | 28861 | 5 | |||
160903 | 179160 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 113 Seville St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001754.98626 | 2087320.62379 | 37.7114844378149 | -122.435750076526 | (37.7114844378149, -122.435750076526) | 9 | 7 | 6 | 28861 | 5 | |||
138253 | 69416 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 148 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 2 | Permit Number 33521 | 6001460.48124 | 2087339.32549 | 37.7115190554232 | -122.436769298869 | (37.7115190554232, -122.436769298869) | 9 | 7 | 6 | 28861 | 5 | |
147674 | 179158 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 148 Seville St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001439.08808 | 2087342.21986 | 37.7115257868681 | -122.436843446185 | (37.7115257868681, -122.436843446185) | 9 | 7 | 6 | 28861 | 5 | |||
23854 | 86960 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 208 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49928 | 5993493.7535 | 2087361.9529 | 37.7111251955331 | -122.464305827668 | (37.7111251955331, -122.464305827668) | 9 | 8 | 4 | 64 | 24 | |
132760 | 37340 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 131 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 10 | Permit Number 39848 | 6000626.60293 | 2087367.00998 | 37.7115476439893 | -122.439653377918 | (37.7115476439893, -122.439653377918) | 9 | 7 | 6 | 28861 | 5 | |
59928 | 69413 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 73 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 4 | Permit Number 33518 | 6001961.1999 | 2087395.46496 | 37.711701646594 | -122.43504269857 | (37.711701646594, -122.43504269857) | 9 | 7 | 6 | 28861 | 5 | |
55464 | 86961 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 212 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49929 | 5993495.99209 | 2087406.23034 | 37.7112468999028 | -122.464301303157 | (37.7112468999028, -122.464301303157) | 9 | 8 | 4 | 64 | 24 | |
99972 | 65739 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 130 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1990 12:00:00 AM | 12 | Permit Number 28675 | 5999799.15568 | 2087425.51821 | 37.7116611636025 | -122.442517443427 | (37.7116611636025, -122.442517443427) | 9 | 7 | 6 | 28861 | 5 | |
65703 | 95006 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 195 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2013 12:00:00 AM | 3 | 3x3 | 6009968.4 | 2087457.4 | 37.7123231225616 | -122.407371876718 | (37.7123231225616, -122.407371876718) | 9 | 7 | 8 | 309 | 39 | ||
2473 | 88167 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 189 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 51184 | 6010014.6058 | 2087504.2072 | 37.7124542316575 | -122.407215472312 | (37.7124542316575, -122.407215472312) | 9 | 7 | 8 | 309 | 39 | |
157837 | 179155 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1219 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001609.50582 | 2087555.82392 | 37.7121219807101 | -122.436269715579 | (37.7121219807101, -122.436269715579) | 9 | 7 | 6 | 28861 | 5 | |||
127811 | 179156 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1219 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001622.38743 | 2087558.00892 | 37.7121287121383 | -122.436225349332 | (37.7121287121383, -122.436225349332) | 9 | 7 | 6 | 28861 | 5 | |||
30819 | 179157 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1219 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001634.55542 | 2087559.68334 | 37.7121340010651 | -122.436183413036 | (37.7121340010651, -122.436183413036) | 9 | 7 | 6 | 28861 | 5 | |||
56894 | 44392 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1201X ATHENS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492 | 2087581 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | 9 | 7 | 6 | 28861 | 5 | |||
112553 | 44394 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1201X ATHENS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492 | 2087581 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | 9 | 7 | 6 | 28861 | 5 | |||
168072 | 44393 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1201X ATHENS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492 | 2087581 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | 9 | 7 | 6 | 28861 | 5 | |||
69638 | 48506 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 45 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 5 | Permit Number 45843 | 6001715.61599 | 2087735.00145 | 37.7126199910876 | -122.43591578109 | (37.7126199910876, -122.43591578109) | 9 | 7 | 6 | 28861 | 5 | ||
146129 | 213304 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 252 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994495.39623 | 2087783.34428 | 37.7123399215102 | -122.460874450904 | (37.7123399215102, -122.460874450904) | 9 | 8 | 6 | 28861 | 24 | |||
190897 | 49743 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 114 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 8 | Permit Number 46542 | 6010621.23603 | 2087831.01483 | 37.7133855110935 | -122.405141759495 | (37.7133855110935, -122.405141759495) | 9 | 7 | 8 | 309 | 39 | |
111226 | 179154 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 374 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001871.82658 | 2087846.75593 | 37.712935716983 | -122.435383858181 | (37.712935716983, -122.435383858181) | 9 | 7 | 6 | 28861 | 5 | |||
119437 | 179029 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 226 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009880.60922 | 2087872.96636 | 37.7134592690157 | -122.407704592601 | (37.7134592690157, -122.407704592601) | 9 | 7 | 8 | 309 | 39 | |||
54909 | 49745 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 34@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 4 | Permit Number 46544 | 6008556.33506 | 2087877.23988 | 37.7133967814171 | -122.412282069889 | (37.7133967814171, -122.412282069889) | 9 | 7 | 8 | 309 | 39 | |
70587 | 213305 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 223 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995012.40881 | 2087891.7837 | 37.7126674060525 | -122.459095358975 | (37.7126674060525, -122.459095358975) | 9 | 8 | 6 | 28861 | 24 | |||
5538 | 178975 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 60 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998617.79966 | 2087941.66603 | 37.7130109785485 | -122.44663762445 | (37.7130109785485, -122.44663762445) | 9 | 7 | 6 | 28861 | 25 | |||
57134 | 55259 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1972 12:00:00 AM | 8 | Permit Number 11181 | 6008604.18987 | 2088002.78931 | 37.7137441994136 | -122.412125533875 | (37.7137441994136, -122.412125533875) | 9 | 7 | 8 | 309 | 39 | ||
91652 | 31006 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 75 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 8 | Permit Number 34780 | 6000669.33593 | 2088075.86611 | 37.7134964370899 | -122.439556465166 | (37.7134964370899, -122.439556465166) | 9 | 7 | 6 | 28861 | 5 | |
97062 | 178976 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 221 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 5998101.98654 | 2088087.6608 | 37.7133823688881 | -122.448430945451 | (37.7133823688881, -122.448430945451) | 9 | 7 | 6 | 28861 | 25 | |||
101048 | 213357 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 Ralston St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992244.95419 | 2088111.94244 | 37.7131124256698 | -122.468676481533 | (37.7131124256698, -122.468676481533) | 9 | 8 | 6 | 64 | 24 | |||
50832 | 178974 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 126 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5998851.51754 | 2088138.53591 | 37.7135648862728 | -122.445843970916 | (37.7135648862728, -122.445843970916) | 9 | 7 | 6 | 28861 | 25 | |||
155603 | 179016 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 70 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6000604.90599 | 2088146.70208 | 37.7136872696207 | -122.439784232863 | (37.7136872696207, -122.439784232863) | 9 | 7 | 6 | 28861 | 5 | |||
194485 | 181039 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 55 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 4ft | 6000909.27168 | 2088176.54977 | 37.7137865448937 | -122.438734374192 | (37.7137865448937, -122.438734374192) | 9 | 7 | 6 | 28861 | 5 | ||
136312 | 41410 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 531 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | 5 | Permit Number 42023 | 6007957.48629 | 2088255.06014 | 37.7144005749922 | -122.414378624292 | (37.7144005749922, -122.414378624292) | 9 | 7 | 8 | 309 | 39 | ||
100942 | 179028 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 535 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007927.50802 | 2088265.22189 | 37.7144267929389 | -122.41448296003 | (37.7144267929389, -122.41448296003) | 9 | 7 | 8 | 309 | 39 | |||
123356 | 49698 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 87@ TUCKER Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50825 | 6011117.29096 | 2088288.9421 | 37.7146706063491 | -122.403459407649 | (37.7146706063491, -122.403459407649) | 10 | 7 | 8 | 309 | 39 | |
140140 | 49699 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 87@ TUCKER Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50825 | 6011128.67682 | 2088300.86402 | 37.7147039774881 | -122.403420891467 | (37.7147039774881, -122.403420891467) | 10 | 7 | 8 | 309 | 39 | |
64309 | 179034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 88 Alpha St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6011090.19294 | 2088313.27178 | 37.7147358971229 | -122.403554780747 | (37.7147358971229, -122.403554780747) | 9 | 7 | 8 | 309 | 39 | |||
44806 | 179033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 88 Alpha St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6011104.28456 | 2088327.78048 | 37.7147765222032 | -122.40350709418 | (37.7147765222032, -122.40350709418) | 9 | 7 | 8 | 309 | 39 | |||
148524 | 48689 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 455 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | 2 | Permit Number 45968 | 6008469.24313 | 2088342.73235 | 37.714670039767 | -122.412615977341 | (37.714670039767, -122.412615977341) | 9 | 7 | 8 | 309 | 39 | ||
183342 | 179032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 33 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010961.71988 | 2088492.90138 | 37.7152219465056 | -122.404011472662 | (37.7152219465056, -122.404011472662) | 9 | 7 | 8 | 309 | 39 | |||
123650 | 86870 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 602 Randolph St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443 | 2088555 | 37.7143403939216 | -122.468024182233 | (37.7143403939216, -122.468024182233) | 9 | 8 | 6 | 64 | 24 | ||
151710 | 86869 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 602 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443 | 2088555 | 37.7143403939216 | -122.468024182233 | (37.7143403939216, -122.468024182233) | 9 | 8 | 6 | 64 | 24 | ||
187026 | 86868 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 602 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443 | 2088555 | 37.7143403939216 | -122.468024182233 | (37.7143403939216, -122.468024182233) | 9 | 8 | 6 | 64 | 24 | ||
78426 | 179017 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 27 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000125.72789 | 2088561.86941 | 37.714799938735 | -122.441470215282 | (37.714799938735, -122.441470215282) | 9 | 7 | 6 | 28861 | 5 | |||
156838 | 179018 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 27 Pope St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000118.27452 | 2088586.12335 | 37.7148661099687 | -122.441497716551 | (37.7148661099687, -122.441497716551) | 9 | 7 | 6 | 28861 | 5 | |||
73858 | 179019 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 27 Pope St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000109.84085 | 2088611.05825 | 37.7149340951081 | -122.441528655027 | (37.7149340951081, -122.441528655027) | 9 | 7 | 6 | 28861 | 5 | |||
59491 | 213344 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 117 Vernon St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 5992432.58541 | 2088617.02757 | 37.7145101052228 | -122.468064688059 | (37.7145101052228, -122.468064688059) | 9 | 8 | 6 | 64 | 24 | |||
93157 | 213343 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 117 Vernon St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992434.92339 | 2088648.0359 | 37.7145953816368 | -122.468058861341 | (37.7145953816368, -122.468058861341) | 9 | 8 | 6 | 64 | 24 | |||
75745 | 28262 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3624 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2003 12:00:00 AM | 12 | 3x3 | 6012194.48746 | 2088681.14992 | 37.7158076389797 | -122.399763675165 | (37.7158076389797, -122.399763675165) | 10 | 7 | 8 | 309 | 39 |
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) );