trees
60 rows where Police Districts = 9 and qSpecies_id = 59
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15414 | 96980 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
| 16015 | 220524 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.7702967937804 | -122.431683217203 | (37.7702967937804, -122.431683217203) | 15 | 9 | 11 | 29492 | 10 | |
| 19788 | 246559 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 6 | Width 7ft | 6005723.21879 | 2109372.62983 | 37.7722588698898 | -122.423601653893 | (37.7722588698898, -122.423601653893) | 7 | 9 | 11 | 28852 | 10 | |||
| 24737 | 246562 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | 7 | 9 | 11 | 28852 | 10 | |||
| 26372 | 246564 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005706.72335 | 2109459.01828 | 37.7724951406584 | -122.423664856449 | (37.7724951406584, -122.423664856449) | 7 | 9 | 11 | 28852 | 10 | |||
| 32481 | 246567 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 11 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6005696.09569 | 2109523.68249 | 37.7726720930872 | -122.423706217176 | (37.7726720930872, -122.423706217176) | 7 | 9 | 11 | 28852 | 10 | |||
| 34981 | 244429 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005659.2973 | 2109696.7034 | 37.7731450894818 | -122.4238458121 | (37.7731450894818, -122.4238458121) | 7 | 9 | 11 | 28852 | 10 | |||
| 37565 | 125723 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Width 4ft | 6003539.04242 | 2117994.60754 | 37.7958091249389 | -122.431772623315 | (37.7958091249389, -122.431772623315) | 13 | 9 | 1 | 57 | 17 | |||
| 37967 | 246565 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 9 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6005706.10974 | 2109468.40026 | 37.7725208666788 | -122.423667646169 | (37.7725208666788, -122.423667646169) | 7 | 9 | 11 | 28852 | 10 | |||
| 39892 | 244430 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005657.927 | 2109705.6102 | 37.7731694680478 | -122.423851185605 | (37.7731694680478, -122.423851185605) | 7 | 9 | 11 | 28852 | 10 | |||
| 44966 | 244263 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005610.4338 | 2110073.0988 | 37.7741758216851 | -122.424041609468 | (37.7741758216851, -122.424041609468) | 7 | 9 | 11 | 28852 | 10 | |||
| 46467 | 244336 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005628.4661 | 2109884.4314 | 37.7736588046762 | -122.423965813403 | (37.7736588046762, -122.423965813403) | 7 | 9 | 11 | 28852 | 10 | |||
| 47415 | 125722 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 43 | Width 4ft | 6003540.89789 | 2117978.17849 | 37.7957641201722 | -122.431765029446 | (37.7957641201722, -122.431765029446) | 13 | 9 | 1 | 57 | 17 | |||
| 49152 | 125724 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 4ft | 6003536.06003 | 2118009.60299 | 37.7958501295278 | -122.431784014136 | (37.7958501295278, -122.431784014136) | 13 | 9 | 1 | 57 | 17 | |||
| 59524 | 244335 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005630.5215 | 2109874.8395 | 37.7736325836766 | -122.42395802123 | (37.7736325836766, -122.42395802123) | 7 | 9 | 11 | 28852 | 10 | |||
| 59791 | 96983 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Permit Number 25529 | 6003522.34271 | 2118089.29041 | 37.796068153086 | -122.431837171257 | (37.796068153086, -122.431837171257) | 13 | 9 | 1 | 57 | 17 | |||
| 61977 | 244407 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005584.4651 | 2110232.73 | 37.774612664125 | -122.424142794808 | (37.774612664125, -122.424142794808) | 7 | 9 | 11 | 28852 | 10 | |||
| 67742 | 246560 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 7ft | 6005720.56075 | 2109380.70244 | 37.772280885298 | -122.423611422347 | (37.772280885298, -122.423611422347) | 7 | 9 | 11 | 28852 | 10 | |||
| 74255 | 96979 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
| 77096 | 244403 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005596.6857 | 2110150.2412 | 37.7743868598384 | -122.424094653801 | (37.7743868598384, -122.424094653801) | 7 | 9 | 11 | 28852 | 10 | |||
| 78015 | 135666 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 42 | Width 9ft | 6000472.49775 | 2118651.89467 | 37.7974395562567 | -122.442430617479 | (37.7974395562567, -122.442430617479) | 13 | 9 | 1 | 57 | 17 | |||
| 80487 | 246571 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 15 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6005693.03742 | 2109551.27371 | 37.7727476792916 | -122.423718758221 | (37.7727476792916, -122.423718758221) | 7 | 9 | 11 | 28852 | 10 | |||
| 81955 | 246558 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 2 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6005725.55596 | 2109365.49138 | 37.7722394013476 | -122.423593061791 | (37.7722394013476, -122.423593061791) | 7 | 9 | 11 | 28852 | 10 | |||
| 83892 | 244431 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005656.5567 | 2109717.2576 | 37.7732013716398 | -122.423856754026 | (37.7732013716398, -122.423856754026) | 7 | 9 | 11 | 28852 | 10 | |||
| 84264 | 246561 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 5 | Median : Yard | Tree | DPW 1 | 8 | Width 7ft | 6005718.25772 | 2109387.68034 | 37.7722999149342 | -122.423619884948 | (37.7722999149342, -122.423619884948) | 7 | 9 | 11 | 28852 | 10 | |||
| 85065 | 244266 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005600.5046 | 2110125.0362 | 37.7743178686238 | -122.424079650665 | (37.7743178686238, -122.424079650665) | 7 | 9 | 11 | 28852 | 10 | |||
| 91372 | 96982 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Permit Number 25529 | 6003530.13563 | 2118059.26209 | 37.7959861448054 | -122.431808061115 | (37.7959861448054, -122.431808061115) | 13 | 9 | 1 | 57 | 17 | |||
| 92490 | 244339 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 16 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6005625.7255 | 2109918.6883 | 37.7737527111209 | -122.423977730108 | (37.7737527111209, -122.423977730108) | 7 | 9 | 11 | 28852 | 10 | |||
| 98854 | 244404 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005594.3943 | 2110164.7531 | 37.7744265766299 | -122.424103612435 | (37.7744265766299, -122.424103612435) | 7 | 9 | 11 | 28852 | 10 | |||
| 100001 | 244261 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005613.489 | 2110034.9096 | 37.7740711358709 | -122.424028324662 | (37.7740711358709, -122.424028324662) | 7 | 9 | 11 | 28852 | 10 | |||
| 100151 | 246569 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 13 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005694.60842 | 2109539.50826 | 37.772715462883 | -122.423712487254 | (37.772715462883, -122.423712487254) | 7 | 9 | 11 | 28852 | 10 | |||
| 101044 | 244406 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005586.7565 | 2110217.4543 | 37.7745708501281 | -122.424133781799 | (37.7745708501281, -122.424133781799) | 7 | 9 | 11 | 28852 | 10 | |||
| 112727 | 244265 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005602.0322 | 2110112.8157 | 37.7742844003359 | -122.42407349717 | (37.7742844003359, -122.42407349717) | 7 | 9 | 11 | 28852 | 10 | |||
| 115890 | 246568 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6005695.27816 | 2109533.51475 | 37.7726990439551 | -122.423709744321 | (37.7726990439551, -122.423709744321) | 7 | 9 | 11 | 28852 | 10 | |||
| 116865 | 244408 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005581.41 | 2110245.7143 | 37.7746481433715 | -122.424154286626 | (37.7746481433715, -122.424154286626) | 7 | 9 | 11 | 28852 | 10 | |||
| 117263 | 244433 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005647.6499 | 2109776.1795 | 37.7733626541324 | -122.423891754495 | (37.7733626541324, -122.423891754495) | 7 | 9 | 11 | 28852 | 10 | |||
| 121894 | 244337 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005627.7809 | 2109896.0788 | 37.7736907469384 | -122.423969012041 | (37.7736907469384, -122.423969012041) | 7 | 9 | 11 | 28852 | 10 | |||
| 122485 | 244334 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005631.2066 | 2109866.6178 | 37.7736100475528 | -122.423955066597 | (37.7736100475528, -122.423955066597) | 7 | 9 | 11 | 28852 | 10 | |||
| 123430 | 96984 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
| 124424 | 244402 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005599.7408 | 2110138.7844 | 37.7743555747298 | -122.424083270702 | (37.7743555747298, -122.424083270702) | 7 | 9 | 11 | 28852 | 10 | |||
| 125575 | 244428 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005659.9824 | 2109685.0561 | 37.7731131474821 | -122.423842613892 | (37.7731131474821, -122.423842613892) | 7 | 9 | 11 | 28852 | 10 | |||
| 127892 | 244264 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005607.3787 | 2110087.6108 | 37.7742154956389 | -122.424053209833 | (37.7742154956389, -122.424053209833) | 7 | 9 | 11 | 28852 | 10 | |||
| 131182 | 244434 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005644.2243 | 2109791.2526 | 37.7734038478353 | -122.423904676174 | (37.7734038478353, -122.423904676174) | 7 | 9 | 11 | 28852 | 10 | |||
| 136053 | 244405 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005589.0478 | 2110200.651 | 37.7745248417047 | -122.424124660487 | (37.7745248417047, -122.424124660487) | 7 | 9 | 11 | 28852 | 10 | |||
| 142683 | 246566 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 10 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005705.41603 | 2109475.54193 | 37.772540436826 | -122.423670553651 | (37.772540436826, -122.423670553651) | 7 | 9 | 11 | 28852 | 10 | |||
| 147228 | 244262 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005612.7252 | 2110055.5318 | 37.7741277163216 | -122.424032433594 | (37.7741277163216, -122.424032433594) | 7 | 9 | 11 | 28852 | 10 | |||
| 148891 | 246563 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 14 | Width 7ft | 6005707.64026 | 2109451.46523 | 37.7724744535597 | -122.423661147645 | (37.7724744535597, -122.423661147645) | 7 | 9 | 11 | 28852 | 10 | |||
| 148940 | 244260 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005614.2528 | 2110021.9252 | 37.7740355269714 | -122.424024758994 | (37.7740355269714, -122.424024758994) | 7 | 9 | 11 | 28852 | 10 | |||
| 150696 | 244432 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6005649.0202 | 2109761.1065 | 37.7733213446724 | -122.423885942412 | (37.7733213446724, -122.423885942412) | 7 | 9 | 11 | 28852 | 10 | |||
| 153224 | 244332 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005642.1688 | 2109804.2702 | 37.7734394749788 | -122.423912712296 | (37.7734394749788, -122.423912712296) | 7 | 9 | 11 | 28852 | 10 | |||
| 156312 | 104131 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 6003522.94878 | 2118100.93382 | 37.7961001572485 | -122.431835905912 | (37.7961001572485, -122.431835905912) | 13 | 9 | 1 | 57 | 17 | ||||
| 165695 | 246570 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 14 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005693.82305 | 2109545.39115 | 37.7727315715478 | -122.423715622299 | (37.7727315715478, -122.423715622299) | 7 | 9 | 11 | 28852 | 10 | |||
| 166467 | 125725 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 4ft | 6003533.81623 | 2118024.94741 | 37.7958921341649 | -122.431792874238 | (37.7958921341649, -122.431792874238) | 13 | 9 | 1 | 57 | 17 | |||
| 168738 | 244338 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 15 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6005626.4106 | 2109908.4113 | 37.7737245316409 | -122.42397462928 | (37.7737245316409, -122.42397462928) | 7 | 9 | 11 | 28852 | 10 | |||
| 171267 | 96981 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
| 178442 | 244333 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005640.1134 | 2109813.177 | 37.773463814863 | -122.423920455707 | (37.773463814863, -122.423920455707) | 7 | 9 | 11 | 28852 | 10 | |||
| 178785 | 246557 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 1 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6005728.07536 | 2109359.17359 | 37.7722221964256 | -122.4235838977 | (37.7722221964256, -122.4235838977) | 7 | 9 | 11 | 28852 | 10 | |||
| 184838 | 244427 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005661.3527 | 2109672.0384 | 37.7730774813758 | -122.423836948028 | (37.7730774813758, -122.423836948028) | 7 | 9 | 11 | 28852 | 10 | |||
| 187717 | 96978 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
| 187951 | 244409 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 15 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6005580.6462 | 2110260.99 | 37.7746900436181 | -122.424158015373 | (37.7746900436181, -122.424158015373) | 7 | 9 | 11 | 28852 | 10 |
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) );