trees
161 rows where qSpecies_id = 96 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141993 | 223011 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1201 San Jose Ave | 40 | Front Yard : Yard | Tree | Private 2 | 14 | 6004395.88546 | 2096037.52109 | 37.7355687759817 | -122.427242962114 | (37.7355687759817, -122.427242962114) | 2 | 7 | 5 | 28861 | 2 | ||||
| 60015 | 222980 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 San Jose Ave | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6004766.24957 | 2096663.35836 | 37.737308122382 | -122.426007008515 | (37.737308122382, -122.426007008515) | 2 | 7 | 5 | 63 | 7 | ||||
| 145896 | 222981 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1101 San Jose Ave | 65 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005028.12161 | 2096593.96399 | 37.7371323777521 | -122.425096658989 | (37.7371323777521, -122.425096658989) | 2 | 7 | 5 | 28859 | 2 | |||
| 92809 | 223012 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1101 San Jose Ave | 55 | Front Yard : Yard | Tree | Private 2 | 3 | 6005036.06332 | 2096630.93294 | 37.7372343347918 | -122.425071830505 | (37.7372343347918, -122.425071830505) | 2 | 7 | 5 | 28859 | 2 | ||||
| 120735 | 222982 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1101 San Jose Ave | 67 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6005045.20057 | 2096625.52578 | 37.7372200041006 | -122.425039854206 | (37.7372200041006, -122.425039854206) | 2 | 7 | 5 | 28859 | 2 | |||
| 59932 | 222978 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 749 Dolores St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 6005048.47497 | 2104094.54483 | 37.7577283976651 | -122.425559946538 | (37.7577283976651, -122.425559946538) | 2 | 4 | 5 | 28859 | 19 | |||
| 25308 | 176072 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 653 Peru Ave | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6005100.84385 | 2092592.61654 | 37.7261496752474 | -122.424560681043 | (37.7261496752474, -122.424560681043) | 9 | 7 | 6 | 28861 | 5 | ||||
| 70341 | 223006 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1001 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 14 | 6005181.63876 | 2096892.75966 | 37.7379614744429 | -122.424587128296 | (37.7379614744429, -122.424587128296) | 2 | 7 | 5 | 28859 | 2 | ||||
| 84078 | 222979 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1001 San Jose Ave | 23 | Front Yard : Yard | Tree | Private 2 | 15 | 6005237.0546 | 2097014.53451 | 37.7382989702268 | -122.424404187313 | (37.7382989702268, -122.424404187313) | 2 | 7 | 5 | 28859 | 2 | ||||
| 101689 | 223013 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 400 Prospect Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6006209.38075 | 2097598.06666 | 37.7399560781032 | -122.421083777917 | (37.7399560781032, -122.421083777917) | 2 | 7 | 7 | 28859 | 2 | ||||
| 151568 | 126358 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 2700 Larkin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006530.21172 | 2120848.51447 | 37.803814332215 | -122.421625403593 | (37.803814332215, -122.421625403593) | 5 | 9 | 1 | 28858 | 32 | |||
| 71395 | 126365 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1151 Lombard St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6006751.38188 | 2120096.64647 | 37.8017623625961 | -122.42080661943 | (37.8017623625961, -122.42080661943) | 5 | 1 | 1 | 28858 | 32 | ||||
| 70399 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 96 | 930 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6007386.5238 | 2120591.43483 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | 5 | 1 | 1 | 28858 | 32 | |||
| 28938 | 126364 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6007584.0296 | 2119571.97409 | 37.8003686400458 | -122.417888052307 | (37.8003686400458, -122.417888052307) | 5 | 1 | 1 | 28858 | 32 | |||
| 48886 | 126363 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6007594.76747 | 2119573.62389 | 37.8003737742816 | -122.417851011923 | (37.8003737742816, -122.417851011923) | 5 | 1 | 1 | 28858 | 32 | |||
| 35470 | 126362 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6007597.96218 | 2119573.74544 | 37.8003742878151 | -122.417839965548 | (37.8003742878151, -122.417839965548) | 5 | 1 | 1 | 28858 | 32 | |||
| 114113 | 126361 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6007604.93039 | 2119574.72474 | 37.8003773688712 | -122.417815922163 | (37.8003773688712, -122.417815922163) | 5 | 1 | 1 | 28858 | 32 | |||
| 191212 | 126360 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6007607.19826 | 2119575.42635 | 37.8003794229421 | -122.41780812417 | (37.8003794229421, -122.41780812417) | 5 | 1 | 1 | 28858 | 32 | |||
| 20410 | 126359 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6007620.5753 | 2119577.58313 | 37.8003860977102 | -122.417761987128 | (37.8003860977102, -122.417761987128) | 5 | 1 | 1 | 28858 | 32 | |||
| 63499 | 122489 | Undocumented 4 | Cotoneaster SPP :: Cotoneaster 96 | 69x Bonview St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
| 188863 | 222983 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 90 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007949.21318 | 2098212.09839 | 37.7417399985009 | -122.415111593326 | (37.7417399985009, -122.415111593326) | 2 | 7 | 7 | 28859 | 2 | |||
| 96964 | 126366 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 99 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 56 | 6008010.57204 | 2119080.43937 | 37.7990430042822 | -122.416377206564 | (37.7990430042822, -122.416377206564) | 5 | 1 | 10 | 308 | 32 | ||||
| 174251 | 126357 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 53 Priest St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6008293.62277 | 2117215.49565 | 37.79393824372 | -122.41526566339 | (37.79393824372, -122.41526566339) | 5 | 1 | 10 | 28858 | 21 | |||
| 62670 | 126368 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 12 MacOndray Ln | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6008550.57003 | 2119171.07932 | 37.799322230301 | -122.414515043334 | (37.799322230301, -122.414515043334) | 5 | 1 | 10 | 308 | 32 | ||||
| 93688 | 126367 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 12 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6008558.64868 | 2119172.9159 | 37.7993277269402 | -122.414487218323 | (37.7993277269402, -122.414487218323) | 5 | 1 | 10 | 308 | 32 | ||||
| 165925 | 108733 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 12X MacOndray Ln | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6008571.72163 | 2119174.99094 | 37.7993341588901 | -122.41444212811 | (37.7993341588901, -122.41444212811) | 5 | 1 | 10 | 308 | 32 | ||||
| 128445 | 246631 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 3320 Harrison St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6009034.5576 | 2099266.31462 | 37.7446955781356 | -122.411433278945 | (37.7446955781356, -122.411433278945) | 2 | 7 | 7 | 28859 | 2 | ||||
| 129392 | 187578 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 211 Elliot St | 1 | Side Yard : Yard | Tree | Private 2 | 38 | 6009088.83114 | 2088896.19011 | 37.7162244747635 | -122.410513477532 | (37.7162244747635, -122.410513477532) | 9 | 7 | 8 | 309 | 39 | ||||
| 184063 | 176070 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 34 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6009191.21918 | 2089961.56598 | 37.7191555154919 | -122.410234749751 | (37.7191555154919, -122.410234749751) | 9 | 3 | 8 | 309 | 18 | |||
| 60282 | 246768 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 99 Waltham St | 1 | Side Yard : Yard | Tree | Private 2 | 13 | 6009274.77295 | 2098916.84453 | 37.7437494805599 | -122.410577984112 | (37.7437494805599, -122.410577984112) | 2 | 7 | 7 | 28859 | 2 | ||||
| 189006 | 246769 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 99 Waltham St | 2 | Side Yard : Yard | Tree | Private 2 | 13 | 6009290.58304 | 2098917.85967 | 37.7437531542765 | -122.410523388038 | (37.7437531542765, -122.410523388038) | 2 | 7 | 7 | 28859 | 2 | ||||
| 149617 | 176069 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 27 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6009294.57289 | 2089991.02465 | 37.7192421957421 | -122.409879572386 | (37.7192421957421, -122.409879572386) | 9 | 3 | 8 | 309 | 18 | |||
| 159085 | 176068 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 14 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6009458.20535 | 2090043.50806 | 37.7193954735114 | -122.409317656201 | (37.7193954735114, -122.409317656201) | 9 | 3 | 8 | 309 | 18 | |||
| 121991 | 247635 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 351 Bradford St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6009489.54624 | 2096539.61504 | 37.7372341639148 | -122.409667589601 | (37.7372341639148, -122.409667589601) | 10 | 7 | 7 | 28859 | 2 | ||||
| 67912 | 176067 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6009780.98423 | 2090145.56651 | 37.719693784023 | -122.408209118574 | (37.719693784023, -122.408209118574) | 9 | 3 | 8 | 309 | 18 | |||
| 151500 | 247902 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 377 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 13 | 6009819.79405 | 2098407.16553 | 37.7423805541222 | -122.408657474665 | (37.7423805541222, -122.408657474665) | 10 | 7 | 7 | 28859 | 2 | ||||
| 102644 | 256153 | Undocumented 4 | Cotoneaster SPP :: Cotoneaster 96 | 80X Peralta Ave | 2 | Median : Cutout | Tree | Private 2 | 3x3 | 6010428 | 2100359 | 37.747773912222 | -122.406691992098 | (37.747773912222, -122.406691992098) | 2 | 7 | 7 | 28859 | 2 | ||||
| 105606 | 176066 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6010525.86554 | 2090356.25733 | 37.7203139789786 | -122.40564914889 | (37.7203139789786, -122.40564914889) | 10 | 7 | 8 | 309 | 28 | |||
| 46352 | 176065 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 300x Mansell St | 13 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6010824.42328 | 2090455.49566 | 37.7206031577782 | -122.404624109729 | (37.7206031577782, -122.404624109729) | 10 | 7 | 7 | 309 | 28 | |||
| 95292 | 176064 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Mansell St | 18 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6011103.67645 | 2090538.55711 | 37.7208468308864 | -122.403664655405 | (37.7208468308864, -122.403664655405) | 10 | 7 | 7 | 309 | 28 | |||
| 48088 | 249827 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 339 Greenwich St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6011143.97494 | 2120350.69369 | 37.8027065167616 | -122.405624039843 | (37.8027065167616, -122.405624039843) | 3 | 1 | 10 | 308 | 23 | |||
| 82608 | 113503 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Mansell St | 9 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011155.5498 | 2090556.69361 | 37.7208995275826 | -122.403486619313 | (37.7208995275826, -122.403486619313) | 10 | 7 | 7 | 309 | 28 | |||
| 115956 | 249832 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 339 Greenwich St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011163.78015 | 2120353.28367 | 37.802714735662 | -122.405555685946 | (37.802714735662, -122.405555685946) | 3 | 1 | 10 | 308 | 23 | |||
| 10292 | 249831 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 339 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011175.54294 | 2120361.59598 | 37.802738216951 | -122.40551556629 | (37.802738216951, -122.40551556629) | 3 | 1 | 10 | 308 | 23 | |||
| 122853 | 113495 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 29 | 3x3 | 6011252.2338 | 2090588.80879 | 37.7209931092197 | -122.403154667852 | (37.7209931092197, -122.403154667852) | 10 | 3 | 7 | 309 | 28 | |||
| 79562 | 190920 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 895 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6011337.392 | 2104186.31719 | 37.7583337232325 | -122.403816617445 | (37.7583337232325, -122.403816617445) | 10 | 3 | 8 | 28856 | 29 | ||||
| 108052 | 190921 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 875 Vermont St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6011349.18047 | 2104266.91512 | 37.7585556858022 | -122.403781518727 | (37.7585556858022, -122.403781518727) | 10 | 3 | 8 | 28856 | 29 | |||
| 141205 | 176071 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1x Tioga Ave | 1 | Median : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6011377.48313 | 2088627.04086 | 37.7156134870441 | -122.402583833071 | (37.7156134870441, -122.402583833071) | 9 | 7 | 8 | 309 | 39 | |||
| 17076 | 126371 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 37 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6011427.3089 | 2120158.66 | 37.8021950785935 | -122.404630029046 | (37.8021950785935, -122.404630029046) | 3 | 1 | 10 | 308 | 23 | |||
| 52277 | 126370 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 31 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6011433.37611 | 2120083.33032 | 37.801988580771 | -122.404603727506 | (37.801988580771, -122.404603727506) | 3 | 1 | 10 | 308 | 23 | |||
| 192482 | 126369 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 30 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6011435.17205 | 2120070.79941 | 37.8019542743222 | -122.404596630044 | (37.8019542743222, -122.404596630044) | 3 | 1 | 10 | 308 | 23 | |||
| 3273 | 190919 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 999 Kansas St | 5 | Side Yard : Yard | Tree | Private 2 | 20 | 6011651.17755 | 2103795.8209 | 37.7572790316179 | -122.40270394113 | (37.7572790316179, -122.40270394113) | 10 | 3 | 8 | 28856 | 29 | ||||
| 97051 | 190914 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 8 | Median : Yard | Tree | DPW 1 | 12 | 6012455.86408 | 2103644.27268 | 37.7569078085518 | -122.399910360878 | (37.7569078085518, -122.399910360878) | 10 | 3 | 8 | 28856 | 29 | ||||
| 177603 | 190916 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 61 | Median : Yard | Tree | DPW 1 | 12 | 6012503.64813 | 2102901.04205 | 37.7548697235729 | -122.399692921016 | (37.7548697235729, -122.399692921016) | 10 | 3 | 8 | 28856 | 29 | ||||
| 127398 | 190915 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 48 | Median : Yard | Tree | DPW 1 | 10 | 6012505.66859 | 2103014.14021 | 37.7551803790787 | -122.399693874288 | (37.7551803790787, -122.399693874288) | 10 | 3 | 8 | 28856 | 29 | ||||
| 68061 | 190918 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 70 | Median : Yard | Tree | DPW 1 | 21 | 6012519.44645 | 2102822.43937 | 37.7546547784053 | -122.399632767143 | (37.7546547784053, -122.399632767143) | 10 | 3 | 8 | 28856 | 29 | ||||
| 91353 | 190917 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 68 | Median : Yard | Tree | DPW 1 | 8 | 6012519.74637 | 2102837.21301 | 37.7546953603194 | -122.399632767155 | (37.7546953603194, -122.399632767155) | 10 | 3 | 8 | 28856 | 29 | ||||
| 40608 | 190911 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1980 Revere Ave | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6013087.19308 | 2095914.17172 | 37.7357177729638 | -122.397184944736 | (37.7357177729638, -122.397184944736) | 10 | 3 | 8 | 58 | 1 | ||||
| 21176 | 190910 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1802 Shoup Ave | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 6013180.92489 | 2093690.47467 | 37.7296171768863 | -122.396705035035 | (37.7296171768863, -122.396705035035) | 10 | 3 | 8 | 58 | 1 | ||||
| 176244 | 190912 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 649 Delancey St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6015785.04565 | 2113121.03731 | 37.7831139729835 | -122.389058364068 | (37.7831139729835, -122.389058364068) | 6 | 2 | 9 | 28856 | 6 | |||
| 90916 | 190913 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 10x Cashmere St | 4 | Median : Yard | Tree | DPW 1 | 16 | 6017428.5626 | 2095806.26069 | 37.7356622038522 | -122.38216748876 | (37.7356622038522, -122.38216748876) | 10 | 3 | 8 | 58 | 1 |
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) );