trees
1,813 rows where qSpecies_id = 149 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
16306 | 260886 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 709 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985981.28564 | 2111059.97075 | 37.7757577023633 | -122.492014045289 | (37.7757577023633, -122.492014045289) | 11 | 6 | 2 | 55 | 26 | |||
18741 | 260851 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 625 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985649.08401 | 2111623.73701 | 37.7772862197699 | -122.493204739608 | (37.7772862197699, -122.493204739608) | 11 | 6 | 2 | 55 | 26 | |||
30726 | 108878 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 275 Staples Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773301 | 5998271.57935 | 2093779.45417 | 37.7290204086136 | -122.44825438236 | (37.7290204086136, -122.44825438236) | 9 | 7 | 4 | 28861 | 40 | |
52324 | 108872 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1317 Grove St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773401 | 6001507.20104 | 2110761.06824 | 37.7758322953641 | -122.438284688432 | (37.7758322953641, -122.438284688432) | 15 | 5 | 11 | 29492 | 10 | |
73141 | 108517 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1474 17th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773664 | 5990869.49269 | 2105368.92693 | 37.7604161511877 | -122.474689222748 | (37.7604161511877, -122.474689222748) | 1 | 8 | 4 | 56 | 12 | |
78582 | 108889 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 534 Mangels Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773372 | 5997888.03427 | 2095280.4903 | 37.7331199631343 | -122.449688444288 | (37.7331199631343, -122.449688444288) | 9 | 7 | 4 | 59 | 40 | |
92882 | 110101 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1348 Douglass St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 774671 | 6001379 | 2099692 | 37.7454320431231 | -122.437935141467 | (37.7454320431231, -122.437935141467) | 2 | 4 | 5 | 63 | 22 | |||
102096 | 96678 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 829 Corbett Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768058 | 5999957 | 2102610 | 37.753363199287 | -122.443061697185 | (37.753363199287, -122.443061697185) | 2 | 5 | 5 | 63 | 38 | ||||
106698 | 108596 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 36 Bronte St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | Permit Number 770949 | 6009339.44395 | 2097251.26276 | 37.7391797819084 | -122.410236794344 | (37.7391797819084, -122.410236794344) | 10 | 7 | 7 | 28859 | 2 | ||
132197 | 254482 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2681 Bush St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769832 | 6000689.85975 | 2114465.22073 | 37.7859564297948 | -122.441377922226 | (37.7859564297948, -122.441377922226) | 15 | 6 | 1 | 29490 | 27 | |
136188 | 108473 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1608 Anza St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773791 | 5993717.35879 | 2112110.81995 | 37.7790922117302 | -122.465329589105 | (37.7790922117302, -122.465329589105) | 11 | 6 | 2 | 54 | 11 | |||
137686 | 254480 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2662 Bush St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769828 | 6000767.68495 | 2114516.43107 | 37.7861014733556 | -122.441112344441 | (37.7861014733556, -122.441112344441) | 13 | 6 | 1 | 29490 | 27 | |
137885 | 87296 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 710 Silliman St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2008 12:00:00 AM | 3x3 | Permit Number 50309 | 6008719 | 2093721 | 37.7294516452602 | -122.412132587507 | (37.7294516452602, -122.412132587507) | 9 | 3 | 7 | 309 | 28 | |||
143172 | 94552 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 626 Clayton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 52551 | 5998519 | 2108536 | 37.7695524156732 | -122.448461315859 | (37.7695524156732, -122.448461315859) | 15 | 5 | 11 | 29492 | 9 | ||
145888 | 108660 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1462 Blake St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771207 | 5997897.61897 | 2112846.03551 | 37.781351110743 | -122.45092146754 | (37.781351110743, -122.45092146754) | 15 | 6 | 2 | 54 | 16 | |
177126 | 254689 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1496 28th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781575 | 5987463.72865 | 2105107.87415 | 37.7595014365191 | -122.486448866203 | (37.7595014365191, -122.486448866203) | 1 | 8 | 3 | 56 | 35 | |
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 | ||||
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 | |||
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 | ||
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 | |||||||||||||
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 | |
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 | |||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |
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 | |
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 | |||||||||||||
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 | |||
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 | ||
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 | |||
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 | ||
11894 | 10016 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 236 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:59:00 AM | 3 | 3x3 | 6005434.04749 | 2107587.52272 | 37.7673410675527 | -122.42447492707 | (37.7673410675527, -122.42447492707) | 8 | 4 | 5 | 28853 | 19 | ||
12079 | 70402 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 212 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6006462.64225 | 2092921.27798 | 37.7271289209396 | -122.419876323835 | (37.7271289209396, -122.419876323835) | 9 | 7 | 7 | 309 | 5 | |||
12260 | 261771 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1226 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2020 12:00:00 AM | 3 | 6009218.99272 | 2102008.59221 | 37.7522356073302 | -122.410989189307 | (37.7522356073302, -122.410989189307) | 2 | 4 | 7 | 28859 | 19 | |||
12737 | 65281 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 443 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 3 | Permit Number 28088 | 6011045.68858 | 2112172.30893 | 37.7802451338574 | -122.405387865261 | (37.7802451338574, -122.405387865261) | 14 | 2 | 9 | 28853 | 34 | |
12751 | 68581 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1526 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | 0 | Permit Number 775949 | 5985927.704093 | 2104831.6030171 | 37.7586532178591 | -122.491740786234 | (37.7586532178591, -122.491740786234) | 1 | 8 | 3 | 56 | 35 | ||
12901 | 123712 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 417 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994293.79243 | 2111404.14299 | 37.7771850921392 | -122.463284192691 | (37.7771850921392, -122.463284192691) | 11 | 6 | 2 | 54 | 11 | |||
12916 | 70149 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 754 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989468.1167 | 2110177.57013 | 37.7735380729812 | -122.479887770247 | (37.7735380729812, -122.479887770247) | 11 | 6 | 2 | 55 | 26 | |||
12924 | 72281 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 730 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982929.24288 | 2110803.7534 | 37.7748753302021 | -122.502552686167 | (37.7748753302021, -122.502552686167) | 11 | 6 | 2 | 55 | 26 | |||
13140 | 107930 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1800X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993080.40868 | 2112098.8542 | 37.7790226034666 | -122.467532169341 | (37.7790226034666, -122.467532169341) | 11 | 6 | 2 | 54 | 11 | |
13286 | 12121 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1400X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 6016540.00349 | 2094984.34395 | 37.7333562692663 | -122.385182357979 | (37.7333562692663, -122.385182357979) | 10 | 3 | 8 | 58 | 1 | |||
13369 | 47379 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4453 Manzanita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45296 | |||||||||||||
13464 | 50030 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1424 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46762 | 6006666.5422022 | 2093098.6917368 | 37.7276275455992 | -122.419184021867 | (37.7276275455992, -122.419184021867) | 9 | 7 | 7 | 309 | 5 | ||
13522 | 253158 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 700 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 07:47:00 AM | 3 | 3x3 | 6004446 | 2092174 | 37.7249632430066 | -122.426794641082 | (37.7249632430066, -122.426794641082) | 9 | 7 | 6 | 28861 | 5 | ||
13701 | 112515 | Section 806 (d) 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2646 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6000218.93903 | 2118886.71439 | 37.7980698532985 | -122.443324869154 | (37.7980698532985, -122.443324869154) | 13 | 9 | 1 | 57 | 17 |
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) );