trees
4,014 rows where qSpecies_id = 40 sorted by YCoord 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69397 | 135936 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Spruce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997050.12682 | 2116069.05064 | 37.7901521005919 | -122.454086209825 | (37.7901521005919, -122.454086209825) | 11 | 6 | 1 | 54 | 31 | |||
| 160773 | 72310 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3560 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52568 | 5997222.81760297 | 2116058.54886417 | 37.7901331661187 | -122.453487957873 | (37.7901331661187, -122.453487957873) | 11 | 6 | 1 | 54 | 31 | |
| 148181 | 135951 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3566 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997226.42135 | 2116056.02078 | 37.7901264312514 | -122.453475306653 | (37.7901264312514, -122.453475306653) | 11 | 6 | 1 | 54 | 31 | |||
| 167709 | 64286 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2137 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1988 12:00:00 AM | 3 | Permit Number 25090 | 6003796.62217 | 2115819.36952 | 37.7898510741089 | -122.430726046274 | (37.7898510741089, -122.430726046274) | 13 | 9 | 1 | 29490 | 27 | ||
| 146944 | 135954 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2993 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000463.47531 | 2115807.7741 | 37.789629833704 | -122.442257560964 | (37.789629833704, -122.442257560964) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 |
| 187218 | 34878 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3009 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1997 12:00:00 AM | 10 | Permit Number 38491 | 6000242.0296 | 2115774.84436 | 37.7895267938762 | -122.443021372241 | (37.7895267938762, -122.443021372241) | 13 | 6 | 1 | 29490 | 27 | ||
| 83744 | 135955 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3035 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6000215.87492 | 2115769.86788 | 37.7895116385051 | -122.443111506798 | (37.7895116385051, -122.443111506798) | 13 | 6 | 1 | 29490 | 27 | |||
| 158140 | 94877 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3043 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2010 12:00:00 AM | 12 | 3x3 | 6000192.74031 | 2115767.95632 | 37.7895050707416 | -122.443191412453 | (37.7895050707416, -122.443191412453) | 13 | 6 | 1 | 29490 | 27 | ||
| 183204 | 135956 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3168 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5999589.99296 | 2115734.38967 | 37.789378518158 | -122.445274431176 | (37.789378518158, -122.445274431176) | 13 | 6 | 1 | 29490 | 27 | |||
| 192165 | 106875 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2014 12:00:00 AM | 9 | 3x3 | Permit Number 772880 | 5999376.01262 | 2115702.70086 | 37.7892792923525 | -122.446012495778 | (37.7892792923525, -122.446012495778) | 13 | 6 | 1 | 29490 | 31 | |
| 124069 | 88367 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772880 | 5999340.32482 | 2115698.11509 | 37.7892646630799 | -122.446135640871 | (37.7892646630799, -122.446135640871) | 13 | 6 | 1 | 29490 | 31 | |
| 191250 | 135953 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2104 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000948.49534 | 2115676.42691 | 37.7892968192312 | -122.440570020904 | (37.7892968192312, -122.440570020904) | 13 | 6 | 1 | 29490 | 27 | |||
| 180572 | 88280 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3261 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778851 | 5999200.48769 | 2115630.53591 | 37.7890711217748 | -122.446614594592 | (37.7890711217748, -122.446614594592) | 13 | 6 | 1 | 29490 | 31 | |
| 54255 | 18943 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2799X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769995 | 6001475.92192 | 2115618.2324 | 37.7891670515542 | -122.438741019305 | (37.7891670515542, -122.438741019305) | 13 | 6 | 1 | 29490 | 27 | |
| 85537 | 135952 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2870 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001073.9556 | 2115610.46068 | 37.7891228364056 | -122.440131212004 | (37.7891228364056, -122.440131212004) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | |||
| 154376 | 18953 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2857 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2000 12:00:00 AM | 3 | 3X3 | 6001142.52027 | 2115568.9795 | 37.7890128430163 | -122.439891012071 | (37.7890128430163, -122.439891012071) | 13 | 6 | 1 | 29490 | 27 | ||
| 117467 | 33992 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2034 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2013 12:00:00 AM | 3 | Permit Number 769995 | 6001444.58 | 2115566.6422 | 37.7890236150982 | -122.438845759727 | (37.7890236150982, -122.438845759727) | 13 | 6 | 1 | 29490 | 27 | ||
| 32418 | 18982 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2920 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000616.67404 | 2115546.70514 | 37.7889217363036 | -122.441708766757 | (37.7889217363036, -122.441708766757) | 13 | 6 | 1 | 29490 | 27 | |||
| 96342 | 98094 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 80X Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006870.3 | 2115541.9 | 37.7892628702193 | -122.420071683756 | (37.7892628702193, -122.420071683756) | 13 | 9 | 10 | 28858 | 21 | |||
| 165286 | 98093 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 80X Frank Norris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006870.3 | 2115541.9 | 37.7892628702193 | -122.420071683756 | (37.7892628702193, -122.420071683756) | 13 | 9 | 10 | 28858 | 21 | |||
| 177359 | 98092 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 80X Frank Norris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006870.3 | 2115541.9 | 37.7892628702193 | -122.420071683756 | (37.7892628702193, -122.420071683756) | 13 | 9 | 10 | 28858 | 21 | |||
| 119335 | 103764 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007013.605 | 2115541.6847 | 37.7892703521256 | -122.419575849271 | (37.7892703521256, -122.419575849271) | 13 | 9 | 10 | 28858 | 21 | ||
| 147227 | 103763 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Frank Norris St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007013.605 | 2115541.6847 | 37.7892703521256 | -122.419575849271 | (37.7892703521256, -122.419575849271) | 13 | 9 | 10 | 28858 | 21 | ||
| 186298 | 103762 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Frank Norris St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007013.605 | 2115541.6847 | 37.7892703521256 | -122.419575849271 | (37.7892703521256, -122.419575849271) | 13 | 9 | 10 | 28858 | 21 | ||
| 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 |
| 79193 | 103760 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100X Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006758.9 | 2115521.2 | 37.7891997559918 | -122.420455645258 | (37.7891997559918, -122.420455645258) | 13 | 9 | 10 | 28858 | 21 | ||
| 124856 | 103876 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 106X Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.01893 | 2115511.31786 | 37.7891702054911 | -122.420603306998 | (37.7891702054911, -122.420603306998) | 13 | 9 | 10 | 28858 | 21 | ||
| 94442 | 103875 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 106X Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006702.4202 | 2115509.69435 | 37.7891649813311 | -122.42065024171 | (37.7891649813311, -122.42065024171) | 13 | 9 | 10 | 28858 | 21 | ||
| 113233 | 103761 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 106X Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.57502 | 2115508.13748 | 37.7891597571573 | -122.420708413481 | (37.7891597571573, -122.420708413481) | 13 | 9 | 10 | 28858 | 21 | ||
| 20779 | 103766 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101X Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006706.11036 | 2115484.69473 | 37.7890965465282 | -122.420635698799 | (37.7890965465282, -122.420635698799) | 13 | 9 | 10 | 28858 | 21 | ||
| 28084 | 103765 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101X Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006551.29204 | 2115477.084 | 37.7890669227742 | -122.42117081077 | (37.7890669227742, -122.42117081077) | 13 | 9 | 10 | 28858 | 21 | ||
| 64587 | 123988 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993914.45172 | 2115450.72048 | 37.7882740365456 | -122.464890390305 | (37.7882740365456, -122.464890390305) | 11 | 6 | 1 | 54 | 11 | |||
| 131806 | 250521 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.5238 | 2115445.0256 | 37.7878972888638 | -122.486440754852 | (37.7878972888638, -122.486440754852) | 11 | 6 | 1 | 55 | 33 | |||
| 22562 | 135932 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3595 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997654.80988 | 2115415.55496 | 37.7883924295159 | -122.451946898042 | (37.7883924295159, -122.451946898042) | 11 | 6 | 1 | 54 | 31 | |||
| 190010 | 45578 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 325 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 6 | Permit Number 44318 | 5998557.11063 | 2115405.08726 | 37.7884153280452 | -122.448824341269 | (37.7884153280452, -122.448824341269) | 13 | 6 | 1 | 54 | 31 | |
| 54488 | 250523 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.92853 | 2115397.50584 | 37.7877668368263 | -122.48643586434 | (37.7877668368263, -122.48643586434) | 11 | 6 | 1 | 55 | 33 | |||
| 37177 | 250524 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.45058 | 2115374.99193 | 37.7877049922276 | -122.486435864334 | (37.7877049922276, -122.486435864334) | 11 | 6 | 1 | 55 | 33 | |||
| 141913 | 135940 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 310 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5997632.68283 | 2115371.58358 | 37.7882704283935 | -122.452020280013 | (37.7882704283935, -122.452020280013) | 11 | 6 | 1 | 54 | 31 | |||
| 83822 | 114854 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1416x Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006727.45782 | 2115352.7364 | 37.788735424647 | -122.420552468331 | (37.788735424647, -122.420552468331) | 13 | 9 | 10 | 28858 | 21 | |||
| 151170 | 114855 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1416x Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006703.84741 | 2115349.3843 | 37.7887248899861 | -122.420633919045 | (37.7887248899861, -122.420633919045) | 13 | 9 | 10 | 28858 | 21 | |||
| 27930 | 45570 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 310 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44312 | 5997638.34099 | 2115343.48265 | 37.788193594804 | -122.451998675622 | (37.788193594804, -122.451998675622) | 11 | 6 | 1 | 54 | 31 | |
| 131162 | 98034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1817 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768344 | 5999961.07212 | 2115342.88884 | 37.7883247339384 | -122.443962403049 | (37.7883247339384, -122.443962403049) | 13 | 6 | 1 | 29490 | 27 | |
| 15012 | 114856 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1416x Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 3 | 3x3 | 6006677.76742 | 2115342.38606 | 37.7887042046809 | -122.420723655192 | (37.7887042046809, -122.420723655192) | 13 | 9 | 10 | 28858 | 21 | ||
| 146532 | 45569 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 310 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 4 | Permit Number 44312 | 5997642.12042 | 2115315.11009 | 37.7881159077753 | -122.451983551718 | (37.7881159077753, -122.451983551718) | 11 | 6 | 1 | 54 | 31 | |
| 18199 | 254500 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1715 Octavia St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769839 | 6004851.87126 | 2115244.61878 | 37.7883326812086 | -122.427034026756 | (37.7883326812086, -122.427034026756) | 13 | 9 | 11 | 28858 | 27 | |
| 32901 | 52649 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46@ LAKE 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2006 12:00:00 AM | 4 | Permit Number 48733 | 5993970.1832 | 2115226.91418 | 37.7876627388076 | -122.4646813119 | (37.7876627388076, -122.4646813119) | 11 | 6 | 1 | 54 | 11 | ||
| 23842 | 103777 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 72117 | 103776 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 81435 | 103790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 123507 | 103789 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 128134 | 103778 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 189169 | 103788 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 120483 | 135980 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.58425 | 2115187.77482 | 37.7882922360442 | -122.419941763898 | (37.7882922360442, -122.419941763898) | 13 | 9 | 10 | 28858 | 21 | ||
| 130957 | 135982 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006867.71438 | 2115184.16614 | 37.7882804756098 | -122.420055232261 | (37.7882804756098, -122.420055232261) | 13 | 9 | 10 | 28858 | 21 | ||
| 125611 | 135981 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006885.98637 | 2115183.79121 | 37.7882804756017 | -122.419991987453 | (37.7882804756017, -122.419991987453) | 13 | 9 | 10 | 28858 | 21 | ||
| 191438 | 47481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1809 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 7 | Permit Number 45377 | 5999494.32332 | 2115164.49026 | 37.7878082622913 | -122.445564438253 | (37.7878082622913, -122.445564438253) | 13 | 6 | 1 | 29490 | 31 | |
| 23030 | 135979 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.7882275541095 | -122.419939904112 | (37.7882275541095, -122.419939904112) | 13 | 9 | 10 | 28858 | 21 | ||
| 60351 | 135978 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.7882128537759 | -122.420019889812 | (37.7882128537759, -122.420019889812) | 13 | 9 | 10 | 28858 | 21 | ||
| 9328 | 47482 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1809 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45377 | 5999495.90716 | 2115146.40334 | 37.7877586907628 | -122.445557657368 | (37.7877586907628, -122.445557657368) | 13 | 6 | 1 | 29490 | 31 | |
| 63425 | 103785 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 103X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006767.43674 | 2115144.46398 | 37.7881658129506 | -122.420399357843 | (37.7881658129506, -122.420399357843) | 13 | 9 | 10 | 28858 | 21 | ||
| 68044 | 103784 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 103X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006741.56415 | 2115141.24736 | 37.7881555229055 | -122.420488644345 | (37.7881555229055, -122.420488644345) | 13 | 9 | 10 | 28858 | 21 | ||
| 70712 | 107827 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90x FERN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006921 | 2115099 | 37.7880496324193 | -122.419864826729 | (37.7880496324193, -122.419864826729) | 13 | 9 | 10 | 28858 | 21 | |||
| 166696 | 135942 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 420 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998162.58841 | 2115059.8609 | 37.7874448588433 | -122.450164425556 | (37.7874448588433, -122.450164425556) | 13 | 6 | 1 | 54 | 31 | |||
| 135205 | 123972 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 75 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993617.67519 | 2115041.45387 | 37.7871331868608 | -122.46588743043 | (37.7871331868608, -122.46588743043) | 11 | 6 | 1 | 54 | 11 | |||
| 37141 | 120704 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 21st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5989296.74954 | 2115035.23836 | 37.7868659147395 | -122.480836260043 | (37.7868659147395, -122.480836260043) | 11 | 6 | 1 | 55 | 33 | |||
| 738 | 55617 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 411 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | 6 | Permit Number 20476 | 5998121.25588 | 2115028.99118 | 37.7873577334097 | -122.45030520092 | (37.7873577334097, -122.45030520092) | 11 | 6 | 1 | 54 | 31 | |
| 175868 | 68292 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 1 | Permit Number 32101 | 5991174.54811 | 2115022.52462 | 37.7869399743547 | -122.474338648581 | (37.7869399743547, -122.474338648581) | 11 | 6 | 1 | 54 | 33 | |
| 143085 | 120705 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5989295.69695 | 2115021.44108 | 37.78682797013 | -122.480838891203 | (37.78682797013, -122.480838891203) | 11 | 6 | 1 | 55 | 33 | |||
| 87380 | 135941 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 411 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998124.31484 | 2115011.10892 | 37.7873088085116 | -122.45029332809 | (37.7873088085116, -122.45029332809) | 11 | 6 | 1 | 54 | 31 | |||
| 38213 | 120706 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5989297.54688 | 2115010.04334 | 37.7867967826872 | -122.480831656181 | (37.7867967826872, -122.480831656181) | 11 | 6 | 1 | 55 | 33 | |||
| 3941 | 92078 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1151 Sutter St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2009 12:00:00 AM | 3x3 | Permit Number 52192 | 6007083 | 2115004 | 37.7877979108835 | -122.419297592258 | (37.7877979108835, -122.419297592258) | 13 | 9 | 10 | 28858 | 21 | |||
| 58762 | 45577 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3866 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44317 | 5996397.21092 | 2114961.83643 | 37.7870745279007 | -122.456265143944 | (37.7870745279007, -122.456265143944) | 11 | 6 | 1 | 54 | 31 | |
| 18589 | 72450 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3880 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5996319.64273 | 2114949.87112 | 37.7870372213321 | -122.456532645474 | (37.7870372213321, -122.456532645474) | 11 | 6 | 1 | 54 | 31 | |||
| 152505 | 12571 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 340 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/1993 12:00:00 AM | 3 | 2X2 | 5994414.30523 | 2114928.25799 | 37.7868683042504 | -122.463123069231 | (37.7868683042504, -122.463123069231) | 11 | 6 | 1 | 54 | 11 | ||
| 113935 | 253424 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993083 | 2114893 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | 11 | 6 | 1 | 54 | 11 | ||||
| 177908 | 117091 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2X 09TH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 3x3 | 5993083 | 2114893 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | 11 | 6 | 1 | 54 | 11 | |||
| 171595 | 120701 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 70 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 5988982.8407 | 2114887.49266 | 37.7864419959893 | -122.481911472455 | (37.7864419959893, -122.481911472455) | 11 | 6 | 1 | 55 | 33 | |||
| 54032 | 250328 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 161 27th Ave | 3 | : | Tree | Private 2 | 4 | Width 3ft | 5987394.32135 | 2114885.37066 | 37.7863436587784 | -122.487407123146 | (37.7863436587784, -122.487407123146) | 11 | 6 | 1 | 55 | 33 | |||
| 6937 | 68735 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3968 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 3 | Permit Number 32653 | 5995812.60766 | 2114880.06908 | 37.7868164408107 | -122.458281808143 | (37.7868164408107, -122.458281808143) | 11 | 6 | 1 | 54 | 31 | ||
| 143692 | 2712 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2168 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1997 12:00:00 AM | 6 | 3X3 | 6003139.43848 | 2114860.32817 | 37.7871805360094 | -122.432931294777 | (37.7871805360094, -122.432931294777) | 13 | 9 | 11 | 29490 | 27 | ||
| 89069 | 103803 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007001.17193 | 2114849.48816 | 37.7873690504995 | -122.419569735969 | (37.7873690504995, -122.419569735969) | 13 | 9 | 10 | 28858 | 21 | ||
| 146672 | 103804 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006974.73956 | 2114845.21209 | 37.7873558205593 | -122.419660883156 | (37.7873558205593, -122.419660883156) | 13 | 9 | 10 | 28858 | 21 | ||
| 100395 | 103805 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006953.73656 | 2114843.50125 | 37.7873499398897 | -122.41973342787 | (37.7873499398897, -122.41973342787) | 13 | 9 | 10 | 28858 | 21 | ||
| 60607 | 103806 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006930.58351 | 2114841.83487 | 37.7873440601297 | -122.419813414468 | (37.7873440601297, -122.419813414468) | 13 | 9 | 10 | 28858 | 21 | ||
| 61746 | 103815 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Hemlock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006959.84507 | 2114826.77891 | 37.7873043685578 | -122.419711106691 | (37.7873043685578, -122.419711106691) | 13 | 9 | 10 | 28858 | 21 | ||
| 188159 | 103814 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Hemlock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006931.25215 | 2114822.01169 | 37.7872896682178 | -122.41980969397 | (37.7872896682178, -122.41980969397) | 13 | 9 | 10 | 28858 | 21 | ||
| 153324 | 250677 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 735 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5986302.66224 | 2114812.53014 | 37.7860799361791 | -122.49117856955 | (37.7860799361791, -122.49117856955) | 11 | 6 | 1 | 55 | 33 | |||
| 103826 | 250676 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 735 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5986293.29726 | 2114811.88275 | 37.786077611448 | -122.49121092176 | (37.786077611448, -122.49121092176) | 11 | 6 | 1 | 55 | 33 | |||
| 186218 | 122246 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 47 Lake St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990773.91586 | 2114787.49655 | 37.7862714344835 | -122.475707561575 | (37.7862714344835, -122.475707561575) | 11 | 6 | 1 | 54 | 33 | |||
| 34552 | 36940 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 115 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 11 | Permit Number 39579 | 5994867.05226 | 2114773.19638 | 37.7864686172836 | -122.461545434289 | (37.7864686172836, -122.461545434289) | 11 | 6 | 1 | 54 | 11 | |
| 133103 | 12424 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1701X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2015 12:00:00 AM | 2 | 4X4 | 6004421.35326 | 2114759.55434 | 37.7869764624576 | -122.428488960967 | (37.7869764624576, -122.428488960967) | 13 | 9 | 11 | 29490 | 27 | ||
| 102209 | 12753 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1730 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2000 12:00:00 AM | 12 | 3X3 | 5990048.72352 | 2114754.53717 | 37.7861388679375 | -122.478214101082 | (37.7861388679375, -122.478214101082) | 11 | 6 | 1 | 55 | 33 | ||
| 50320 | 28085 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.7868542683748 | -122.434200102392 | (37.7868542683748, -122.434200102392) | 13 | 9 | 11 | 29490 | 27 | |||
| 11117 | 12763 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1806 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 5989830.30372 | 2114748.73304 | 37.7861102501687 | -122.478969342589 | (37.7861102501687, -122.478969342589) | 11 | 6 | 1 | 55 | 33 | |||
| 99004 | 250882 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 154 29th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5986822.39512 | 2114740.35297 | 37.7859121118945 | -122.489375148247 | (37.7859121118945, -122.489375148247) | 11 | 6 | 1 | 55 | 33 | |||
| 58326 | 68685 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50137 | 5992080.71456 | 2114734.20286 | 37.7862007790713 | -122.47118253461 | (37.7862007790713, -122.47118253461) | 11 | 6 | 2 | 54 | 11 | |
| 136751 | 250881 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 154 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5986823.25063 | 2114733.91146 | 37.7858944753023 | -122.489371714655 | (37.7858944753023, -122.489371714655) | 11 | 6 | 1 | 55 | 33 | |||
| 48521 | 87154 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50137 | 5992080.87589 | 2114715.15142 | 37.7861484784179 | -122.47118058794 | (37.7861484784179, -122.47118058794) | 11 | 6 | 2 | 54 | 11 |
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) );