trees
4,014 rows where qSpecies_id = 40 sorted by Police Districts
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 | |||||||||||
| 1598 | 135994 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009269.53041 | 2117367.69461 | 37.7944109435695 | -122.411899674537 | (37.7944109435695, -122.411899674537) | 3 | 1 | 10 | 28857 | 21 | |||
| 4080 | 136012 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006953.33762 | 2120481.80968 | 37.802831303989 | -122.420135108266 | (37.802831303989, -122.420135108266) | 5 | 1 | 1 | 28858 | 32 | |||
| 4116 | 262380 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008843.96123 | 2117672.51917 | 37.7952240323069 | -122.413393767718 | (37.7952240323069, -122.413393767718) | 5 | 1 | 10 | 308 | 21 | ||||
| 8095 | 67626 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1334 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 7 | Permit Number 31212 | 6007155.75192 | 2118470.9352 | 37.7973213520513 | -122.419291917399 | (37.7973213520513, -122.419291917399) | 5 | 1 | 10 | 28858 | 32 | |
| 8166 | 135996 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009314.46183 | 2117374.97438 | 37.7944334526921 | -122.411744720456 | (37.7944334526921, -122.411744720456) | 3 | 1 | 10 | 28857 | 21 | |||
| 9300 | 34481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 839 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 9 | Permit Number 38208 | 6008950.87239 | 2119364.89119 | 37.7998768700862 | -122.413143564642 | (37.7998768700862, -122.413143564642) | 3 | 1 | 10 | 308 | 32 | |
| 10833 | 135992 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009196.7187 | 2117357.70571 | 37.7943794313202 | -122.412150906452 | (37.7943794313202, -122.412150906452) | 3 | 1 | 10 | 28857 | 21 | |||
| 11139 | 57395 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1415 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1994 12:00:00 AM | 4 | Permit Number 33423 | 6007958.46126 | 2117300.9237 | 37.7941539658926 | -122.416431412305 | (37.7941539658926, -122.416431412305) | 5 | 1 | 10 | 28858 | 32 | ||
| 13277 | 135995 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009287.1824 | 2117369.66466 | 37.7944173431466 | -122.411838735572 | (37.7944173431466, -122.411838735572) | 3 | 1 | 10 | 28857 | 21 | |||
| 13292 | 136017 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 290 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011553.12596 | 2119421.08108 | 37.8001768973966 | -122.404142699051 | (37.8001768973966, -122.404142699051) | 3 | 1 | 10 | 308 | 23 | |||
| 14535 | 119254 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008843.96123 | 2117672.51917 | 37.7952240323069 | -122.413393767718 | (37.7952240323069, -122.413393767718) | 5 | 1 | 10 | 308 | 21 | |||
| 16183 | 135997 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009336.40364 | 2117377.1493 | 37.7944406553528 | -122.411668952587 | (37.7944406553528, -122.411668952587) | 3 | 1 | 10 | 28857 | 21 | |||
| 16209 | 262261 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 290 Green St | : | Tree | Private 2 | FUF | 06/18/2020 12:00:00 AM | 3 | Permit Number 785454 | 6011550.34746 | 2119418.71162 | 37.8001702361868 | -122.404152146942 | (37.8001702361868, -122.404152146942) | 3 | 1 | 10 | 308 | 23 | ||
| 17111 | 71253 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1436 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6007270.15279 | 2117448.61656 | 37.7945207624857 | -122.418823519012 | (37.7945207624857, -122.418823519012) | 5 | 1 | 10 | 28858 | 32 | ||
| 18789 | 71443 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 924 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012090.03782 | 2119001.59006 | 37.7990550614973 | -122.402255254071 | (37.7990550614973, -122.402255254071) | 3 | 1 | 10 | 28860 | 6 | |||
| 19149 | 65479 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1051 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/1989 12:00:00 AM | 10 | 3x3 | Permit Number 28361 | 6008468.49788 | 2115537.43749 | 37.7893405334878 | -122.414541776599 | (37.7893405334878, -122.414541776599) | 5 | 1 | 10 | 28858 | 21 |
| 19515 | 135993 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009221.31733 | 2117360.97425 | 37.794389786122 | -122.412066023053 | (37.794389786122, -122.412066023053) | 3 | 1 | 10 | 28857 | 21 | |||
| 24604 | 13087 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | ||
| 26102 | 136002 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009478.99985 | 2116817.49063 | 37.7929119670677 | -122.411135999022 | (37.7929119670677, -122.411135999022) | 3 | 1 | 10 | 28857 | 21 | |||
| 29561 | 88415 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009399.28346 | 2116763.19844 | 37.7927584231235 | -122.411407985496 | (37.7927584231235, -122.411407985496) | 3 | 1 | 10 | 28857 | 21 | |
| 30319 | 136006 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1237x Robert C Levy Tunl | 10 | Median : Yard | Tree | DPW 1 | 3 | 6007669.82361 | 2118117.13537 | 37.7963788445653 | -122.417488005977 | (37.7963788445653, -122.417488005977) | 5 | 1 | 10 | 28858 | 32 | ||||
| 30472 | 100032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | ||
| 32309 | 88409 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | 3 | 1 | 10 | 28857 | 21 | |
| 33557 | 135998 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009470.07385 | 2116888.98279 | 37.7931077665596 | -122.411171935935 | (37.7931077665596, -122.411171935935) | 3 | 1 | 10 | 28857 | 21 | |||
| 35235 | 88414 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009411.74152 | 2116765.8223 | 37.7927663263429 | -122.41136506535 | (37.7927663263429, -122.41136506535) | 3 | 1 | 10 | 28857 | 21 | |
| 37392 | 96373 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1315 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008912.46348 | 2117456.9297 | 37.7946359224745 | -122.413141486295 | (37.7946359224745, -122.413141486295) | 5 | 1 | 10 | 28857 | 21 | |
| 42087 | 88407 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | 3 | 1 | 10 | 28857 | 21 | |
| 44977 | 14411 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2001X Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/2001 12:00:00 AM | 6 | 3X3 | 6009024.63169 | 2120105.21371 | 37.8019137522347 | -122.412940701134 | (37.8019137522347, -122.412940701134) | 3 | 1 | 10 | 308 | 32 | ||
| 45422 | 66088 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2229 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 12 | Permit Number 29132 | 6007569.63634 | 2120087.67012 | 37.8017838015514 | -122.417974436664 | (37.8017838015514, -122.417974436664) | 5 | 1 | 1 | 28858 | 32 | |
| 45463 | 34485 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 851 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 8 | Permit Number 38211 | 6008882.96668 | 2119355.1714 | 37.7998463695797 | -122.413377856913 | (37.7998463695797, -122.413377856913) | 3 | 1 | 10 | 308 | 32 | |
| 46209 | 136011 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1761 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007318.32314 | 2118399.04204 | 37.7971331059516 | -122.418724276998 | (37.7971331059516, -122.418724276998) | 5 | 1 | 10 | 28858 | 32 | |||
| 50563 | 88416 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 50857 | 26729 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | |||
| 53312 | 96033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767672 | 6008167.44383 | 2115805.7111 | 37.7900602294563 | -122.415602393833 | (37.7900602294563, -122.415602393833) | 13 | 1 | 10 | 28858 | 21 |
| 58470 | 136000 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009476.57256 | 2116845.84647 | 37.7929896891793 | -122.411146401493 | (37.7929896891793, -122.411146401493) | 3 | 1 | 10 | 28857 | 21 | |||
| 58554 | 87738 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 10 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | 5 | 1 | 1 | 28858 | 32 | ||
| 67796 | 33273 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1121 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37442 | 6009382.25638 | 2117052.96271 | 37.7935530901583 | -122.411487381259 | (37.7935530901583, -122.411487381259) | 3 | 1 | 10 | 28857 | 21 | |
| 68471 | 249941 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 331 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011275.70767 | 2120025.2952 | 37.8018204174494 | -122.405145248872 | (37.8018204174494, -122.405145248872) | 3 | 1 | 10 | 308 | 23 | |||
| 68503 | 136007 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 851 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008899.0755 | 2119356.39222 | 37.7998506260751 | -122.413322200567 | (37.7998506260751, -122.413322200567) | 3 | 1 | 10 | 308 | 32 | |||
| 71695 | 100034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 72492 | 136004 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1027 Broadway | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 19 | Width 3ft | 6008655.55584 | 2118272.73317 | 37.7968614918226 | -122.41408816573 | (37.7968614918226, -122.41408816573) | 5 | 1 | 10 | 308 | 21 | |||
| 73001 | 98796 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950@Washington Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768771 | 6010177.18626 | 2117200.01626 | 37.7940014192822 | -122.408747227007 | (37.7940014192822, -122.408747227007) | 3 | 1 | 10 | 28857 | 4 | |
| 73417 | 136013 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006984.71597 | 2120484.67695 | 37.8028409447119 | -122.420026726469 | (37.8028409447119, -122.420026726469) | 5 | 1 | 1 | 28858 | 32 | |||
| 73681 | 113953 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1665 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009606.74508 | 2119405.96484 | 37.8000264462311 | -122.41087689265 | (37.8000264462311, -122.41087689265) | 3 | 1 | 10 | 308 | 4 | |||
| 76800 | 135991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1040 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008482.86494 | 2115597.67171 | 37.7895067291082 | -122.414496332055 | (37.7895067291082, -122.414496332055) | 5 | 1 | 10 | 28858 | 21 | |||
| 78840 | 136001 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009476.76834 | 2116835.36375 | 37.7929609171614 | -122.411144983273 | (37.7929609171614, -122.411144983273) | 3 | 1 | 10 | 28857 | 21 | |||
| 79124 | 34480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 771 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 18 | Permit Number 38207 | 6009276.26447 | 2119410.9605 | 37.8000216267413 | -122.412020839304 | (37.8000216267413, -122.412020839304) | 3 | 1 | 10 | 308 | 4 | |
| 83992 | 136008 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 979 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008203.73321 | 2119954.656 | 37.8014542449694 | -122.415770737051 | (37.8014542449694, -122.415770737051) | 5 | 1 | 10 | 308 | 32 | |||
| 84092 | 34483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 845 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 8 | Permit Number 38210 | 6008918.61834 | 2119360.64227 | 37.7998633928514 | -122.413254875509 | (37.7998633928514, -122.413254875509) | 3 | 1 | 10 | 308 | 32 | |
| 87213 | 100031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | 3 | 1 | 10 | 28857 | 21 | |
| 91852 | 88421 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 93231 | 249855 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 241 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011547.42399 | 2120404.90985 | 37.8028779329365 | -122.404231712119 | (37.8028779329365, -122.404231712119) | 3 | 1 | 10 | 308 | 23 | |||
| 93839 | 51935 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 329 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | Permit Number 48161 | 6009200.27838208 | 2121477.92859384 | 37.805692742557 | -122.412429964781 | (37.805692742557, -122.412429964781) | 3 | 1 | 10 | 308 | 23 | |||
| 97160 | 136010 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1761 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007314.88578 | 2118424.776 | 37.7972035714369 | -122.418737997073 | (37.7972035714369, -122.418737997073) | 5 | 1 | 10 | 28858 | 32 | |||
| 100186 | 135999 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009475.36486 | 2116853.62807 | 37.7930109878303 | -122.411151130141 | (37.7930109878303, -122.411151130141) | 3 | 1 | 10 | 28857 | 21 | |||
| 103353 | 88413 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51386 | 6009439.10659 | 2116768.27237 | 37.7927745884158 | -122.411270553799 | (37.7927745884158, -122.411270553799) | 3 | 1 | 10 | 28857 | 21 | |
| 104181 | 98790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950x CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
| 105885 | 88412 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009452.7788 | 2116769.6537 | 37.7927791479928 | -122.411223344786 | (37.7927791479928, -122.411223344786) | 3 | 1 | 10 | 28857 | 21 | |
| 116891 | 34484 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 845 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 6 | Permit Number 38210 | 6008932.65781 | 2119362.16351 | 37.7998683579931 | -122.413206401149 | (37.7998683579931, -122.413206401149) | 3 | 1 | 10 | 308 | 32 | |
| 130066 | 136003 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009481.94772 | 2116801.23595 | 37.7928675009884 | -122.411124650506 | (37.7928675009884, -122.411124650506) | 3 | 1 | 10 | 28857 | 21 | |||
| 133111 | 11071 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1769 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6007332 | 2118349 | 37.7969964730533 | -122.418673401001 | (37.7969964730533, -122.418673401001) | 5 | 1 | 10 | 28858 | 32 | |||
| 133521 | 93018 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 963 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2010 12:00:00 AM | 3x3 | Permit Number 53140 | 6006134 | 2121397 | 37.805297983444 | -122.423035527254 | (37.805297983444, -122.423035527254) | 5 | 1 | 1 | 28858 | 32 | ||
| 134505 | 38505 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1123 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1998 12:00:00 AM | 9 | Permit Number 40496 | 6008719.38643 | 2117949.78915 | 37.7959783521792 | -122.413844440467 | (37.7959783521792, -122.413844440467) | 5 | 1 | 10 | 308 | 21 | ||
| 137212 | 88418 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 139985 | 250003 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 232 Filbert St | 1 | Side Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011516.94138 | 2120107.55399 | 37.8020597630161 | -122.404316256511 | (37.8020597630161, -122.404316256511) | 3 | 1 | 10 | 308 | 23 | |||
| 140300 | 136005 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1237x Robert C Levy Tunl | 9 | Median : Yard | Tree | DPW 1 | 3 | 6007661.46268 | 2118150.4985 | 37.7964699809712 | -122.417519302367 | (37.7964699809712, -122.417519302367) | 5 | 1 | 10 | 28858 | 32 | ||||
| 141662 | 34478 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 755 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 16 | Permit Number 38205 | 6009336.13836 | 2119417.92641 | 37.8000441124981 | -122.411814144501 | (37.8000441124981, -122.411814144501) | 3 | 1 | 10 | 308 | 4 | |
| 143173 | 42840 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1828 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 5 | Permit Number 42772 | 6008289.65137 | 2118753.27916 | 37.7981603934451 | -122.415388321908 | (37.7981603934451, -122.415388321908) | 5 | 1 | 10 | 308 | 21 | |
| 143356 | 100035 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 143911 | 88451 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 06/07/2008 12:00:00 AM | 3 | 5x12 | 6005480.84439 | 2121378.35155 | 37.8052099010884 | -122.425294529632 | (37.8052099010884, -122.425294529632) | 5 | 1 | 1 | 28858 | 32 | ||
| 144336 | 249940 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 331 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011278.90186 | 2120029.10977 | 37.8018310698943 | -122.405134464188 | (37.8018310698943, -122.405134464188) | 3 | 1 | 10 | 308 | 23 | |||
| 148491 | 136019 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 11 Greenwich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6012283.42018 | 2120515.08235 | 37.8032215378072 | -122.401692519489 | (37.8032215378072, -122.401692519489) | 3 | 1 | 10 | 28860 | 6 | ||||
| 151278 | 100037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 153077 | 88417 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 153256 | 100033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 153659 | 26727 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | |||
| 153934 | 66515 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1173 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1991 12:00:00 AM | 7 | Permit Number 29681 | 6007962.75323 | 2118537.74133 | 37.7975502016423 | -122.41650421331 | (37.7975502016423, -122.41650421331) | 5 | 1 | 10 | 28858 | 21 | ||
| 154688 | 136009 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1173 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007981.41109 | 2118539.47865 | 37.797556021142 | -122.416439775085 | (37.797556021142, -122.416439775085) | 5 | 1 | 10 | 28858 | 21 | |||
| 156455 | 88419 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 158921 | 13086 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | |||
| 159616 | 136016 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 290 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011568.90675 | 2119422.06779 | 37.8001804883964 | -122.40408816056 | (37.8001804883964, -122.40408816056) | 3 | 1 | 10 | 308 | 23 | |||
| 168862 | 14410 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2001X Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/2001 12:00:00 AM | 6 | 3X3 | 6009024.63169 | 2120105.21371 | 37.8019137522347 | -122.412940701134 | (37.8019137522347, -122.412940701134) | 3 | 1 | 10 | 308 | 32 | ||
| 171289 | 136015 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Havens St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6007560.5835 | 2119380.86157 | 37.7998425735334 | -122.417955630044 | (37.7998425735334, -122.417955630044) | 5 | 1 | 1 | 28858 | 32 | |||
| 173193 | 26728 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | |||
| 173420 | 136018 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 11 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6012250.39299 | 2120519.5939 | 37.8032320823636 | -122.401807129095 | (37.8032320823636, -122.401807129095) | 3 | 1 | 10 | 28860 | 6 | ||||
| 176507 | 136014 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6007575.68988 | 2119392.22094 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) | 5 | 1 | 1 | 28858 | 32 | |||
| 177201 | 96374 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1315 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008916.21068 | 2117429.19629 | 37.7945599836999 | -122.413126558466 | (37.7945599836999, -122.413126558466) | 5 | 1 | 10 | 28857 | 21 | |
| 178352 | 100036 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 180788 | 88408 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.7942872436256 | -122.411401815264 | (37.7942872436256, -122.411401815264) | 3 | 1 | 10 | 28857 | 21 | |
| 181937 | 87739 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 11 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005433.61853 | 2121623.41722 | 37.8058801199389 | -122.425475412067 | (37.8058801199389, -122.425475412067) | 13 | 1 | 1 | 28858 | 17 | ||
| 191235 | 88420 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 192256 | 35253 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2250 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 16 | Permit Number 38739 | 6008088.43141 | 2120207.50426 | 37.8021420203875 | -122.416187651964 | (37.8021420203875, -122.416187651964) | 5 | 1 | 10 | 308 | 32 | |
| 193704 | 88452 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/07/2008 12:00:00 AM | 4 | 5x12 | 6005470.42698 | 2121378.16696 | 37.8052088057127 | -122.425330567252 | (37.8052088057127, -122.425330567252) | 5 | 1 | 1 | 28858 | 17 | ||
| 127618 | 29119 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 509 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008381.9659 | 2113792.89597 | 37.7845455839642 | -122.414717657915 | (37.7845455839642, -122.414717657915) | 7 | 10 | 9 | 28858 | 36 | ||
| 1029 | 65280 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 435 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28085 | 6011091.92612 | 2112217.73363 | 37.7803724445696 | -122.405231107147 | (37.7803724445696, -122.405231107147) | 14 | 2 | 9 | 28853 | 34 | |
| 3725 | 73662 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 828 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011416.18719 | 2109390.39573 | 37.7726273509159 | -122.403910314231 | (37.7726273509159, -122.403910314231) | 14 | 2 | 9 | 28853 | 34 | |||
| 6764 | 95833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 520 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767565 | 6010212.70231 | 2112022.42286 | 37.7797869733249 | -122.408258986859 | (37.7797869733249, -122.408258986859) | 14 | 2 | 9 | 28853 | 34 |
| 7876 | 196488 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014277.71699 | 2112657.65169 | 37.7817579518025 | -122.394240695653 | (37.7817579518025, -122.394240695653) | 6 | 2 | 9 | 28856 | 6 | |||
| 9518 | 65278 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 415 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28081 | 6011215.3927 | 2112332.46737 | 37.7806943784819 | -122.40481205634 | (37.7806943784819, -122.40481205634) | 14 | 2 | 9 | 28853 | 34 |
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) );