trees
74 rows where qSpecies_id = 165
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1054 | 72037 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 534 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010993.0833 | 2118650.7238 | 37.7980303757469 | -122.406026374045 | (37.7980303757469, -122.406026374045) | 3 | 1 | 10 | 308 | 23 | |||
| 1290 | 125914 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006770.3381 | 2117989.04828 | 37.7959764977783 | -122.420591325329 | (37.7959764977783, -122.420591325329) | 13 | 9 | 10 | 28858 | 32 | |||
| 13957 | 125908 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006659.65002 | 2117982.23073 | 37.7959515397918 | -122.420973843868 | (37.7959515397918, -122.420973843868) | 13 | 9 | 10 | 28858 | 32 | |||
| 15410 | 125931 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 251 Broadway | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6012329.26329 | 2118775.25448 | 37.7984469489314 | -122.401411533519 | (37.7984469489314, -122.401411533519) | 3 | 1 | 10 | 28860 | 6 | |||
| 19943 | 125920 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1376 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006349.33021 | 2119047.1504 | 37.7988580434315 | -122.422123304265 | (37.7988580434315, -122.422123304265) | 13 | 9 | 1 | 28858 | 32 | |||
| 22449 | 188387 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012693.86322 | 2107331.16353 | 37.7670444612605 | -122.399346082175 | (37.7670444612605, -122.399346082175) | 14 | 3 | 8 | 28856 | 20 | |||
| 23850 | 188380 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012838.02479 | 2107469.00844 | 37.7674309862677 | -122.398857121681 | (37.7674309862677, -122.398857121681) | 14 | 3 | 8 | 28856 | 20 | |||
| 32180 | 188381 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012815.66036 | 2107449.59896 | 37.7673764460054 | -122.39893311528 | (37.7673764460054, -122.39893311528) | 14 | 3 | 8 | 28856 | 20 | |||
| 33491 | 125928 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 251 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012276.19333 | 2118767.35464 | 37.7984222967127 | -122.40159461752 | (37.7984222967127, -122.40159461752) | 3 | 1 | 10 | 28860 | 6 | |||
| 33536 | 188374 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 475 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013821.87003 | 2111598.12216 | 37.7788233767445 | -122.3957434619 | (37.7788233767445, -122.3957434619) | 6 | 2 | 9 | 28856 | 34 | |||
| 38930 | 188385 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012733.66843 | 2107369.50646 | 37.7671519608071 | -122.399211093014 | (37.7671519608071, -122.399211093014) | 14 | 3 | 8 | 28856 | 20 | |||
| 42826 | 125909 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006677.52314 | 2117984.18012 | 37.7959578997932 | -122.4209121378 | (37.7959578997932, -122.4209121378) | 13 | 9 | 10 | 28858 | 32 | |||
| 51727 | 188368 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 236 Texas St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013709.67094 | 2105953.26455 | 37.7633176176352 | -122.395735977728 | (37.7633176176352, -122.395735977728) | 14 | 3 | 8 | 28856 | 29 | |||
| 52045 | 125910 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006696.335 | 2117986.05162 | 37.7959640988078 | -122.420847177963 | (37.7959640988078, -122.420847177963) | 13 | 9 | 10 | 28858 | 32 | |||
| 55280 | 125929 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 251 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6012293.81074 | 2118770.30436 | 37.798431378969 | -122.401533862924 | (37.798431378969, -122.401533862924) | 3 | 1 | 10 | 28860 | 6 | |||
| 56356 | 188372 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 475 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6013770.62402 | 2111547.17427 | 37.7786806345488 | -122.395917172236 | (37.7786806345488, -122.395917172236) | 6 | 2 | 9 | 28856 | 34 | |||
| 60186 | 125921 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 248 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012303.22418 | 2118837.65459 | 37.7986168317528 | -122.401506025282 | (37.7986168317528, -122.401506025282) | 3 | 1 | 10 | 28860 | 6 | |||
| 61545 | 188373 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 475 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6013797.63065 | 2111569.97668 | 37.7787447472234 | -122.39582534337 | (37.7787447472234, -122.39582534337) | 6 | 2 | 9 | 28856 | 34 | |||
| 61593 | 122835 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 62268 | 122829 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 62692 | 125916 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006803.69739 | 2117989.96064 | 37.7959808828736 | -122.420475960314 | (37.7959808828736, -122.420475960314) | 13 | 9 | 10 | 28858 | 32 | |||
| 64867 | 142942 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 530 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6011035.2352 | 2118656.8924 | 37.7980496706883 | -122.405880950311 | (37.7980496706883, -122.405880950311) | 3 | 1 | 10 | 308 | 23 | |||
| 66607 | 125924 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 251 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012205.28794 | 2118757.45492 | 37.7983911576927 | -122.401839277161 | (37.7983911576927, -122.401839277161) | 3 | 1 | 10 | 28860 | 6 | |||
| 68618 | 41357 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 145 Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2000 12:00:00 AM | 7 | Permit Number 42007 | 6003035.73339 | 2119763.23013 | 37.8006367603272 | -122.433640627612 | (37.8006367603272, -122.433640627612) | 13 | 9 | 1 | 57 | 17 | ||
| 71871 | 104174 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1266 Washington St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/27/2013 12:00:00 AM | 2 | Permit Number 769966 | 6008660.71895 | 2117323.02559 | 37.7942541188741 | -122.414003080877 | (37.7942541188741, -122.414003080877) | 5 | 1 | 10 | 28857 | 21 | ||
| 73529 | 188382 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012796.79264 | 2107431.55801 | 37.7673258582224 | -122.398997110128 | (37.7673258582224, -122.398997110128) | 14 | 3 | 8 | 28856 | 20 | |||
| 76893 | 188383 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012774.39868 | 2107410.70967 | 37.7672673654354 | -122.39907310465 | (37.7672673654354, -122.39907310465) | 14 | 3 | 8 | 28856 | 20 | |||
| 78632 | 104172 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1266 Washington St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/27/2013 12:00:00 AM | 2 | Permit Number 769966 | 6008673.1204 | 2117324.35161 | 37.7942584563068 | -122.413960264165 | (37.7942584563068, -122.413960264165) | 5 | 1 | 10 | 28857 | 21 | ||
| 83622 | 125915 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006787.55943 | 2117990.13988 | 37.7959804655711 | -122.420531813612 | (37.7959804655711, -122.420531813612) | 13 | 9 | 10 | 28858 | 32 | |||
| 87983 | 188378 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012877.85295 | 2107508.50271 | 37.767541647848 | -122.398722132537 | (37.767541647848, -122.398722132537) | 14 | 3 | 8 | 28856 | 20 | |||
| 90441 | 188384 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012754.12767 | 2107390.09436 | 37.7672096307557 | -122.399141772392 | (37.7672096307557, -122.399141772392) | 14 | 3 | 8 | 28856 | 20 | |||
| 91133 | 188377 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 475 Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013936.90466 | 2111707.693 | 37.7791306319187 | -122.395353186716 | (37.7791306319187, -122.395353186716) | 6 | 2 | 9 | 28856 | 34 | |||
| 94010 | 122832 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 97302 | 188375 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 475 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013870.81551 | 2111644.71049 | 37.7789540203558 | -122.395577403888 | (37.7789540203558, -122.395577403888) | 6 | 2 | 9 | 28856 | 34 | |||
| 99048 | 122830 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 100424 | 104173 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1266 Washington St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/27/2013 12:00:00 AM | 2 | Permit Number 769966 | 6008666.76417 | 2117323.84982 | 37.7942567215292 | -122.413982221999 | (37.7942567215292, -122.413982221999) | 5 | 1 | 10 | 28857 | 21 | ||
| 101193 | 122827 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 103620 | 188371 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 227 Connecticut St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 6013205.05645 | 2105990.16551 | 37.7633908557151 | -122.397483873981 | (37.7633908557151, -122.397483873981) | 14 | 3 | 8 | 28856 | 29 | |||
| 104700 | 125918 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1376 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006386.86184 | 2119052.59014 | 37.7988750963777 | -122.421993818967 | (37.7988750963777, -122.421993818967) | 13 | 9 | 1 | 28858 | 32 | |||
| 110294 | 204698 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1945 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993754.14919 | 2102286.08803 | 37.7521182001029 | -122.464488765067 | (37.7521182001029, -122.464488765067) | 1 | 8 | 4 | 29491 | 12 | |||
| 114391 | 188386 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012716.23952 | 2107351.14847 | 37.7671005825382 | -122.399270088563 | (37.7671005825382, -122.399270088563) | 14 | 3 | 8 | 28856 | 20 | |||
| 114584 | 188390 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 248 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010733.16033 | 2111734.10609 | 37.779024452547 | -122.406438163709 | (37.779024452547, -122.406438163709) | 14 | 2 | 9 | 28853 | 34 | |||
| 114607 | 125919 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1376 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006369.25772 | 2119050.19129 | 37.798867516882 | -122.422054564589 | (37.798867516882, -122.422054564589) | 13 | 9 | 1 | 28858 | 32 | |||
| 117884 | 125907 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006644.7585 | 2117981.33145 | 37.7959482311701 | -122.421025307596 | (37.7959482311701, -122.421025307596) | 13 | 9 | 10 | 28858 | 32 | |||
| 118403 | 101798 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 600X Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6x6 | 6012357.6476 | 2105099.72644 | 37.7608986877458 | -122.400352258064 | (37.7608986877458, -122.400352258064) | 10 | 3 | 8 | 28856 | 29 | |||
| 120245 | 125922 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 248 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012285.01589 | 2118835.9366 | 37.7986110985748 | -122.401568911293 | (37.7986110985748, -122.401568911293) | 3 | 1 | 10 | 28860 | 6 | |||
| 126264 | 122831 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 130001 | 188376 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 475 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013901.71511 | 2111674.04237 | 37.7790362777336 | -122.395472564503 | (37.7790362777336, -122.395472564503) | 6 | 2 | 9 | 28856 | 34 | |||
| 132792 | 125926 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 251 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012239.55484 | 2118762.42869 | 37.7984067267457 | -122.401721052286 | (37.7984067267457, -122.401721052286) | 3 | 1 | 10 | 28860 | 6 | |||
| 135654 | 89304 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 536 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51908 | 6010977.9189 | 2118648.9247 | 37.7980245876995 | -122.406078720701 | (37.7980245876995, -122.406078720701) | 3 | 1 | 10 | 308 | 23 | |
| 136469 | 125912 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006736.44851 | 2117987.48621 | 37.7959702987412 | -122.420708479127 | (37.7959702987412, -122.420708479127) | 13 | 9 | 10 | 28858 | 32 | |||
| 138289 | 188379 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012856.33782 | 2107488.21259 | 37.7674847369547 | -122.398795126902 | (37.7674847369547, -122.398795126902) | 14 | 3 | 8 | 28856 | 20 | |||
| 144234 | 188389 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012654.91324 | 2107292.22717 | 37.7669353798003 | -122.399478071155 | (37.7669353798003, -122.399478071155) | 14 | 3 | 8 | 28856 | 20 | |||
| 147501 | 188392 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1172 Key Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6012412.13674 | 2090491.60305 | 37.7207909101503 | -122.399138381943 | (37.7207909101503, -122.399138381943) | 10 | 3 | 8 | 58 | 1 | ||||
| 153729 | 125925 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 251 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012221.71463 | 2118760.19231 | 37.7983995906195 | -122.401782627968 | (37.7983995906195, -122.401782627968) | 3 | 1 | 10 | 28860 | 6 | |||
| 156314 | 125927 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 251 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012257.17226 | 2118765.37838 | 37.7984158089854 | -122.401660297682 | (37.7984158089854, -122.401660297682) | 3 | 1 | 10 | 28860 | 6 | |||
| 161497 | 39585 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 860 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2015 12:00:00 AM | 1 | Permit Number 40996 | 6011833.87 | 2104371.56164 | 37.7588700869985 | -122.402112591039 | (37.7588700869985, -122.402112591039) | 10 | 3 | 8 | 28856 | 29 | |
| 163186 | 188369 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 467 Texas St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013826.93076 | 2104919.88069 | 37.7604866939148 | -122.395258018646 | (37.7604866939148, -122.395258018646) | 10 | 3 | 8 | 28856 | 29 | |||
| 167349 | 188388 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 190 Irwin St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012674.11663 | 2107312.56439 | 37.7669922916006 | -122.399413077158 | (37.7669922916006, -122.399413077158) | 14 | 3 | 8 | 28856 | 20 | |||
| 167626 | 122828 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 167761 | 28500 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 270 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6010858.04605 | 2111602.35548 | 37.7786696817102 | -122.405996847495 | (37.7786696817102, -122.405996847495) | 14 | 2 | 9 | 28853 | 34 | |||
| 168451 | 188370 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 412 Connecticut St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013195.07017 | 2105113.9405 | 37.7609843787595 | -122.397456959072 | (37.7609843787595, -122.397456959072) | 10 | 3 | 8 | 28856 | 29 | |||
| 172136 | 188366 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 211 Texas St | 1 | : | Tree | Private 2 | 21 | Width 3ft | 6013759.09778 | 2106092.28997 | 37.763702100305 | -122.395574766173 | (37.763702100305, -122.395574766173) | 14 | 3 | 8 | 28856 | 29 | |||
| 177420 | 125917 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006819.23263 | 2117991.32629 | 37.7959855080659 | -122.420422302258 | (37.7959855080659, -122.420422302258) | 13 | 9 | 10 | 28858 | 32 | |||
| 182142 | 188391 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 615 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6009680.87329 | 2111478.30722 | 37.7782631656511 | -122.410060400886 | (37.7782631656511, -122.410060400886) | 8 | 2 | 9 | 28853 | 34 | |||
| 182333 | 122834 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 183803 | 125923 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 248 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012266.96123 | 2118833.17133 | 37.7986024983571 | -122.401631192034 | (37.7986024983571, -122.401631192034) | 3 | 1 | 10 | 28860 | 6 | |||
| 186457 | 142941 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 506 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6011048.3435 | 2118659.4626 | 37.7980574609154 | -122.405835772705 | (37.7980574609154, -122.405835772705) | 3 | 1 | 10 | 308 | 23 | |||
| 187322 | 125913 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006753.61977 | 2117988.9997 | 37.7959754221755 | -122.420649170638 | (37.7959754221755, -122.420649170638) | 13 | 9 | 10 | 28858 | 32 | |||
| 188218 | 125911 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006720.82388 | 2117986.36219 | 37.7959663318359 | -122.420762463624 | (37.7959663318359, -122.420762463624) | 13 | 9 | 10 | 28858 | 32 | |||
| 189172 | 122833 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 192575 | 204697 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1935 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993752.62389 | 2102311.14457 | 37.752186911019 | -122.464495858899 | (37.752186911019, -122.464495858899) | 1 | 8 | 4 | 29491 | 12 | |||
| 193100 | 125930 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 251 Broadway | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012311.41375 | 2118772.5456 | 37.7984385150748 | -122.401473108324 | (37.7984385150748, -122.401473108324) | 3 | 1 | 10 | 28860 | 6 | |||
| 193413 | 188367 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 212 Texas St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013704.70501 | 2106043.59868 | 37.7635653790542 | -122.39575948333 | (37.7635653790542, -122.39575948333) | 14 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );