trees
575 rows where qSpecies_id = 123 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 157671 | 91653 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1199 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007683.015377 | 2102689.848948 | 37.7540199323813 | -122.416349102661 | (37.7540199323813, -122.416349102661) | 2 | 4 | 7 | 28859 | 19 | ||
| 157100 | 122016 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1633 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5990486.56458 | 2110588.66917 | 37.7747259547528 | -122.476394881461 | (37.7747259547528, -122.476394881461) | 11 | 6 | 2 | 55 | 26 | |||
| 155950 | 90585 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988755.94443 | 2110581.0496 | 37.7746045146176 | -122.482380818852 | (37.7746045146176, -122.482380818852) | 11 | 6 | 2 | 55 | 26 | ||
| 155593 | 87995 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 120 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51032 | 6009094.1 | 2112956.3 | 37.7822884772374 | -122.412194758861 | (37.7822884772374, -122.412194758861) | 14 | 10 | 9 | 28852 | 36 | ||
| 155550 | 91589 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 442 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007397.135958 | 2107116.333394 | 37.7661579552478 | -122.417651462281 | (37.7661579552478, -122.417651462281) | 8 | 4 | 7 | 28853 | 19 | |||
| 155023 | 80092 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004273.51915 | 2119103.69822 | 37.7988960100912 | -122.429310324527 | (37.7988960100912, -122.429310324527) | 13 | 9 | 1 | 57 | 17 | |
| 153876 | 241326 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 395 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | Width 3ft | 6007429.44982 | 2107410.61084 | 37.7669677904545 | -122.417560553376 | (37.7669677904545, -122.417560553376) | 8 | 4 | 7 | 28853 | 19 | ||
| 153861 | 120915 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 499X South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6007431 | 2106864 | 37.7654670122947 | -122.41751644763 | (37.7654670122947, -122.41751644763) | 8 | 4 | 7 | 28853 | 19 | |||
| 153745 | 83991 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 62 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | 15 | 5 | 11 | 29492 | 12 | ||
| 153411 | 241275 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1400 Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010636.10474 | 2101276.89456 | 37.750305890826 | -122.406037027383 | (37.750305890826, -122.406037027383) | 10 | 4 | 7 | 28859 | 19 | |||
| 153220 | 241354 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6009719.71418 | 2105928.26145 | 37.7630262022081 | -122.409534224627 | (37.7630262022081, -122.409534224627) | 8 | 4 | 8 | 28859 | 19 | |||
| 152881 | 84199 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 152731 | 213852 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1386 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991160.08427 | 2105986.1579 | 37.7621277372307 | -122.473729238831 | (37.7621277372307, -122.473729238831) | 1 | 8 | 11 | 56 | 12 | |||
| 152443 | 91602 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 754 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007474 | 2105260 | 37.7610652207705 | -122.417254045994 | (37.7610652207705, -122.417254045994) | 2 | 4 | 7 | 28859 | 19 | ||
| 151959 | 81505 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49730 | 5996533.25550088 | 2090072.07142613 | 37.7187412808671 | -122.453996225339 | (37.7187412808671, -122.453996225339) | 9 | 8 | 6 | 28861 | 24 | ||
| 151905 | 22278 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
| 151093 | 241311 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 550 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007420.66445 | 2106451.36867 | 37.7643334414537 | -122.417522949121 | (37.7643334414537, -122.417522949121) | 8 | 4 | 7 | 28859 | 19 | |||
| 150853 | 34256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 156 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 4 | Permit Number 39596 | 5993995.61311 | 2114522.39441 | 37.78572978571 | -122.46454215478 | (37.78572978571, -122.46454215478) | 11 | 6 | 1 | 54 | 11 | |
| 150797 | 88158 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 353 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51181 | 6011830.6 | 2112533.5 | 37.7812807348582 | -122.402697887639 | (37.7812807348582, -122.402697887639) | 6 | 2 | 9 | 28853 | 34 | ||
| 149994 | 91642 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007742.379122 | 2101613.996265 | 37.7510692229497 | -122.41606762223 | (37.7510692229497, -122.41606762223) | 2 | 4 | 7 | 28859 | 19 | |||
| 149728 | 91698 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 143 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.7713934987847 | -122.417934514554 | (37.7713934987847, -122.417934514554) | 8 | 2 | 9 | 28853 | 19 | ||
| 149240 | 196980 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 320 Missouri St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013452.78538 | 2105563.26016 | 37.7622324578928 | -122.396597126255 | (37.7622324578928, -122.396597126255) | 10 | 3 | 8 | 28856 | 29 | |||
| 149145 | 197006 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6015876.10983 | 2114035.38454 | 37.7856296114719 | -122.388807169036 | (37.7856296114719, -122.388807169036) | 6 | 2 | 9 | 28856 | 6 | |||
| 149067 | 95289 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4400 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015280 | 2096693 | 37.737978108932 | -122.389657874388 | (37.737978108932, -122.389657874388) | 10 | 3 | 8 | 58 | 1 | ||||
| 148991 | 22243 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4434 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | ||
| 148837 | 90580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989065.94752 | 2110592.46721 | 37.7746538923373 | -122.481309305666 | (37.7746538923373, -122.481309305666) | 11 | 6 | 2 | 55 | 26 | ||
| 148723 | 22242 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4430 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1995 12:00:00 AM | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | ||
| 148664 | 91605 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 814 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007520.10207 | 2104907.355044 | 37.7600995328259 | -122.417069610712 | (37.7600995328259, -122.417069610712) | 2 | 4 | 7 | 28859 | 19 | ||
| 148421 | 196998 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 13 | : | Tree | Private 2 | 5 | Width 4ft | 6013702.50003 | 2100126.86267 | 37.7473191766464 | -122.395352595851 | (37.7473191766464, -122.395352595851) | 10 | 3 | 8 | 58 | 1 | |||
| 148392 | 95290 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4416 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | |||
| 148213 | 136179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2400 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001333.81043 | 2119043.17386 | 37.7985629614603 | -122.439478320365 | (37.7985629614603, -122.439478320365) | 13 | 9 | 1 | 57 | 17 | |||
| 147966 | 90873 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2015 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989357.49508 | 2110545.80132 | 37.7745427066681 | -122.480297379549 | (37.7745427066681, -122.480297379549) | 11 | 6 | 2 | 55 | 26 | ||
| 147702 | 38904 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40717 | 6010047.86641 | 2116623.85793 | 37.7924121841197 | -122.409154013767 | (37.7924121841197, -122.409154013767) | 3 | 1 | 10 | 28857 | 4 | |
| 147564 | 196965 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015917.99613 | 2105847.416 | 37.763149578419 | -122.38809064947 | (37.763149578419, -122.38809064947) | 14 | 3 | 8 | 28856 | 29 | |||
| 147178 | 90863 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988677.47069 | 2110522.18301 | 37.7744383181626 | -122.482647957161 | (37.7744383181626, -122.482647957161) | 11 | 6 | 2 | 55 | 26 | ||
| 146984 | 91609 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 976 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007571.644451 | 2103976.864237 | 37.7575475186204 | -122.416825426207 | (37.7575475186204, -122.416825426207) | 2 | 4 | 7 | 28859 | 19 | ||
| 146824 | 32353 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2180 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 8 | Permit Number 36907 | 6009556.94604 | 2104659.06953 | 37.759532167893 | -122.410007582777 | (37.759532167893, -122.410007582777) | 2 | 4 | 7 | 28859 | 19 | |
| 146439 | 136181 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999405.90686 | 2119644.67772 | 37.8001046215781 | -122.446192737013 | (37.8001046215781, -122.446192737013) | 13 | 9 | 1 | 57 | 17 | |||
| 146245 | 196984 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
| 146243 | 88019 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 926 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51046 | 6007429 | 2114473 | 37.7863593952456 | -122.418062835651 | (37.7863593952456, -122.418062835651) | 13 | 9 | 9 | 28858 | 36 | ||
| 145915 | 62429 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4475 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50961 | 5999555.98449793 | 2105708.06247977 | 37.7618468426508 | -122.444671147653 | (37.7618468426508, -122.444671147653) | 15 | 5 | 5 | 28862 | 3 | ||
| 145828 | 84205 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 145660 | 91669 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 765 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007543.215311 | 2105213.393874 | 37.7609411449227 | -122.417011357225 | (37.7609411449227, -122.417011357225) | 2 | 4 | 7 | 28859 | 19 | |||
| 144829 | 241322 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 442 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007381.66806 | 2107115.42092 | 37.7661545793962 | -122.417704898167 | (37.7661545793962, -122.417704898167) | 8 | 4 | 7 | 28853 | 19 | |||
| 144571 | 91703 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
| 144340 | 43686 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 162 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43330 | 5993378.79836 | 2114426.59889 | 37.785431180637 | -122.46666917492 | (37.785431180637, -122.46666917492) | 11 | 6 | 2 | 54 | 11 | |
| 144328 | 88018 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3926 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51046 | 6004957.7 | 2095821.3 | 37.7350068377073 | -122.425285172259 | (37.7350068377073, -122.425285172259) | 2 | 7 | 5 | 28861 | 2 | |||
| 144038 | 38888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 316 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998132.12011 | 2115294.26521 | 37.7880867274765 | -122.45028674235 | (37.7880867274765, -122.45028674235) | 13 | 6 | 1 | 54 | 31 | |
| 143795 | 247599 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Tompkins Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 6009183.00439 | 2096409.33052 | 37.7368592482464 | -122.410718251366 | (37.7368592482464, -122.410718251366) | 10 | 7 | 7 | 28859 | 2 | |||
| 143430 | 91578 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 160 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2013 01:03:00 PM | 4 | 3x3 | 6007300.496664 | 2108846.846012 | 37.7709040967706 | -122.418108415168 | (37.7709040967706, -122.418108415168) | 8 | 2 | 9 | 28853 | 19 | ||
| 143335 | 87451 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 345 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2007 12:00:00 AM | 3 | 3x3 | 6005911.17036 | 2110956.31285 | 37.7766178884522 | -122.423064096477 | (37.7766178884522, -122.423064096477) | 7 | 9 | 11 | 28852 | 10 | ||
| 143289 | 241382 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2169 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008151.18943 | 2105840.29781 | 37.762696660032 | -122.414953006889 | (37.762696660032, -122.414953006889) | 8 | 4 | 7 | 28859 | 19 | |||
| 143264 | 31983 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 252 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | 3x3 | Permit Number 35383 | 5994950.72464 | 2113855.38064 | 37.7839533587811 | -122.461189396885 | (37.7839533587811, -122.461189396885) | 11 | 6 | 2 | 54 | 11 |
| 143144 | 91583 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 280 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 6007340.222146 | 2108038.912892 | 37.7686879390349 | -122.417913721993 | (37.7686879390349, -122.417913721993) | 8 | 4 | 7 | 28853 | 19 | |||
| 142984 | 31525 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1330 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 12 | 4x4 | Permit Number 35080 | 6011118.50482 | 2102111.69571 | 37.7526250409161 | -122.404427600678 | (37.7526250409161, -122.404427600678) | 10 | 4 | 8 | 28859 | 19 |
| 142722 | 111741 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 498x 11th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5992530.71883 | 2112167.74428 | 37.7791800053719 | -122.469438767189 | (37.7791800053719, -122.469438767189) | 11 | 6 | 2 | 54 | 11 | |||
| 142131 | 91614 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1140 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007588 | 2102997 | 37.7548579556474 | -122.416699447347 | (37.7548579556474, -122.416699447347) | 2 | 4 | 7 | 28859 | 19 | |||
| 141990 | 196989 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
| 141497 | 90865 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988736.61915 | 2110526.67364 | 37.7744540891609 | -122.482443682946 | (37.7744540891609, -122.482443682946) | 11 | 6 | 2 | 55 | 26 | ||
| 141436 | 247600 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Tompkins Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6009197.59612 | 2096407.47189 | 37.7368549629719 | -122.410667669902 | (37.7368549629719, -122.410667669902) | 10 | 7 | 7 | 28859 | 2 | |||
| 141067 | 241375 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004575.52977 | 2101893.77166 | 37.7516588560771 | -122.427038840268 | (37.7516588560771, -122.427038840268) | 2 | 4 | 5 | 28862 | 22 | |||
| 140091 | 88138 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 181 Marietta Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51166 | 5998804 | 2097893 | 37.7403456543781 | -122.446709627058 | (37.7403456543781, -122.446709627058) | 9 | 7 | 4 | 59 | 40 | |||
| 140031 | 241328 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 373 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007423.72887 | 2107548.58471 | 37.7673463124187 | -122.417590121285 | (37.7673463124187, -122.417590121285) | 8 | 4 | 7 | 28853 | 19 | |||
| 139882 | 91608 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 918 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007553.688973 | 2104300.922411 | 37.758436297925 | -122.416910482813 | (37.758436297925, -122.416910482813) | 2 | 4 | 7 | 28859 | 19 | |||
| 139468 | 91692 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 263 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007399.273892 | 2108147.255986 | 37.7689887468538 | -122.417717146452 | (37.7689887468538, -122.417717146452) | 8 | 4 | 7 | 28853 | 19 | |||
| 139206 | 196967 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015888.58147 | 2105846.04273 | 37.7631441779792 | -122.388192289968 | (37.7631441779792, -122.388192289968) | 14 | 3 | 8 | 28856 | 29 | |||
| 139041 | 241316 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 270 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007332.32989 | 2108125.54734 | 37.7689253726442 | -122.41794716295 | (37.7689253726442, -122.41794716295) | 8 | 4 | 7 | 28853 | 19 | |||
| 138245 | 46563 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 550 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 5 | Permit Number 44698 | 6007428.13103163 | 2106459.60978175 | 37.7643564897484 | -122.41749770835 | (37.7643564897484, -122.41749770835) | 8 | 4 | 7 | 28859 | 19 | ||
| 137048 | 241309 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007486.87936 | 2106417.71309 | 37.7642447566068 | -122.417291544578 | (37.7642447566068, -122.417291544578) | 8 | 4 | 7 | 28859 | 19 | |||
| 137034 | 241359 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 707 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 8ft | 6008539.21153 | 2104376.13627 | 37.7586982040894 | -122.413507415061 | (37.7586982040894, -122.413507415061) | 2 | 4 | 7 | 28859 | 19 | |||
| 136903 | 37712 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 720 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 4 | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | |
| 136593 | 91668 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.7605112945984 | -122.416970234051 | (37.7605112945984, -122.416970234051) | 2 | 4 | 7 | 28859 | 19 | ||
| 136365 | 22239 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4445 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1995 12:00:00 AM | 3 | 3X3 | 6015309.22014 | 2096468.43632 | 37.7373631231169 | -122.389541166269 | (37.7373631231169, -122.389541166269) | 10 | 3 | 8 | 58 | 1 | ||
| 135948 | 84422 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3324-3330 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50579 | 6007386.65215888 | 2105022.29149516 | 37.7604076136969 | -122.417539297454 | (37.7604076136969, -122.417539297454) | 2 | 4 | 7 | 28859 | 19 | ||
| 135886 | 241369 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2877 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 7ft | 6009515.68514 | 2102750.48038 | 37.7542892993236 | -122.410015545387 | (37.7542892993236, -122.410015545387) | 2 | 4 | 7 | 28859 | 19 | |||
| 135561 | 91626 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1450 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007725.085674 | 2101207.507592 | 37.749952124518 | -122.416098640357 | (37.749952124518, -122.416098640357) | 2 | 4 | 7 | 28859 | 19 | |||
| 135225 | 197004 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6015943.64363 | 2113959.00175 | 37.7854236244348 | -122.388568185881 | (37.7854236244348, -122.388568185881) | 6 | 2 | 9 | 28856 | 6 | |||
| 135185 | 241339 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2707 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009729.78186 | 2105457.4669 | 37.761734071584 | -122.409466175622 | (37.761734071584, -122.409466175622) | 2 | 4 | 8 | 28859 | 19 | |||
| 134611 | 241336 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 11 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007215.53058 | 2099620.48751 | 37.7455658619754 | -122.417748235597 | (37.7455658619754, -122.417748235597) | 2 | 7 | 7 | 28859 | 2 | |||
| 134217 | 91699 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 143 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.7713934987847 | -122.417934514554 | (37.7713934987847, -122.417934514554) | 8 | 2 | 9 | 28853 | 19 | ||
| 133896 | 87939 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4489 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50962 | 5999451 | 2105708 | 37.7618406796867 | -122.445034241655 | (37.7618406796867, -122.445034241655) | 15 | 5 | 5 | 28862 | 3 | ||
| 133771 | 91586 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 356 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007369.299728 | 2107603.325202 | 37.7674935541002 | -122.417782265097 | (37.7674935541002, -122.417782265097) | 8 | 4 | 7 | 28853 | 19 | |||
| 133550 | 241356 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3041 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6009354.55363 | 2100986.01535 | 37.749435439707 | -122.410448197535 | (37.749435439707, -122.410448197535) | 2 | 4 | 7 | 28859 | 19 | |||
| 132977 | 101633 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
| 132824 | 88009 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 360 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51038 | 6008030 | 2113635 | 37.7840922583142 | -122.415924158968 | (37.7840922583142, -122.415924158968) | 7 | 10 | 9 | 28858 | 36 | ||
| 132731 | 26278 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1828 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/1998 12:00:00 AM | 3 | 6000476.90225 | 2093497.19967 | 37.7283712336437 | -122.440610195428 | (37.7283712336437, -122.440610195428) | 9 | 7 | 6 | 28861 | 25 | |||
| 132385 | 44257 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 122 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2001 12:00:00 AM | 9 | Permit Number 43690 | 5993988.26127 | 2114691.75826 | 37.7861943888941 | -122.464579892109 | (37.7861943888941, -122.464579892109) | 11 | 6 | 1 | 54 | 11 | ||
| 132267 | 91658 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1073 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007642.630657 | 2103418.725072 | 37.7560189888407 | -122.416540390694 | (37.7560189888407, -122.416540390694) | 2 | 4 | 7 | 28859 | 19 | |||
| 131374 | 82729 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 49 Samoset St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.408332701789 | (37.744466098795, -122.408332701789) | 2 | 7 | 7 | 28859 | 2 | ||
| 131142 | 241308 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007488.17208 | 2106401.00941 | 37.7641989649233 | -122.417285889641 | (37.7641989649233, -122.417285889641) | 8 | 4 | 7 | 28859 | 19 | |||
| 130878 | 123179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 771 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992862.96444 | 2110216.56004 | 37.7738417753505 | -122.468147428182 | (37.7738417753505, -122.468147428182) | 11 | 6 | 2 | 54 | 11 | |||
| 129945 | 91693 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 253 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007399.603267 | 2108201.969765 | 37.7691389965346 | -122.417719885805 | (37.7691389965346, -122.417719885805) | 8 | 4 | 7 | 28853 | 19 | |||
| 129554 | 120951 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 741 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6007568 | 2105341 | 37.7612929159977 | -122.416934678899 | (37.7612929159977, -122.416934678899) | 2 | 4 | 7 | 28859 | 19 | |||
| 128961 | 91690 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 315 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007395.800334 | 2107840.638089 | 37.7681466508094 | -122.417707425394 | (37.7681466508094, -122.417707425394) | 8 | 4 | 7 | 28853 | 19 | |||
| 128361 | 91689 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 335 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007402.197577 | 2107728.718925 | 37.7678397070843 | -122.417677364286 | (37.7678397070843, -122.417677364286) | 8 | 4 | 7 | 28853 | 19 | |||
| 128004 | 90862 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2233 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988638.67322 | 2110518.90236 | 37.7744270531648 | -122.4827819229 | (37.7744270531648, -122.4827819229) | 11 | 6 | 2 | 55 | 26 | ||
| 126071 | 241306 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 635 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007512.51553 | 2105948.57414 | 37.7629580524843 | -122.417169630685 | (37.7629580524843, -122.417169630685) | 8 | 4 | 7 | 28859 | 19 | |||
| 125579 | 62067 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 240 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50979 | 6009906.39574025 | 2087592.17070432 | 37.7126897048858 | -122.40759567922 | (37.7126897048858, -122.40759567922) | 9 | 7 | 8 | 309 | 39 | ||
| 125523 | 104460 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
| 125452 | 196979 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1551 20th St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.397014079838 | (37.7599198521353, -122.397014079838) | 10 | 3 | 8 | 28856 | 29 |
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) );