trees
443 rows where qSpecies_id = 32 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1087 | 233496 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 60 Yukon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000227.44313 | 2104506.90628 | 37.7585870568739 | -122.442262614226 | (37.7585870568739, -122.442262614226) | 2 | 4 | 5 | 28862 | 3 | |||
2706 | 211314 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1950 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993864.84081 | 2102208.58731 | 37.7519117832189 | -122.464100354143 | (37.7519117832189, -122.464100354143) | 1 | 8 | 4 | 29491 | 12 | |||
2889 | 211318 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 355 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997726.4515 | 2093787.92348 | 37.7290124835257 | -122.450139532341 | (37.7290124835257, -122.450139532341) | 9 | 7 | 4 | 28861 | 40 | |||
3069 | 233426 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008801.72689 | 2105503.58115 | 37.7618086469759 | -122.412679216788 | (37.7618086469759, -122.412679216788) | 8 | 4 | 7 | 28859 | 19 | |||
4937 | 132212 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2654 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000265.26964 | 2118199.18789 | 37.7961847294893 | -122.443115149071 | (37.7961847294893, -122.443115149071) | 13 | 9 | 1 | 57 | 17 | |||
5052 | 139847 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 829 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005684.1962 | 2112380.729 | 37.7805161769301 | -122.423950581978 | (37.7805161769301, -122.423950581978) | 7 | 9 | 11 | 28852 | 41 | |||
6112 | 233465 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2460 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008820.36078 | 2104131.22912 | 37.7580415272211 | -122.41251775699 | (37.7580415272211, -122.41251775699) | 2 | 4 | 7 | 28859 | 19 | |||
6458 | 211310 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1645 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993991.2178 | 2104316.50873 | 37.7577068768914 | -122.46381631408 | (37.7577068768914, -122.46381631408) | 1 | 5 | 4 | 56 | 12 | |||
7122 | 194543 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012559.7859 | 2107618.88108 | 37.7678269955571 | -122.399830043335 | (37.7678269955571, -122.399830043335) | 14 | 3 | 8 | 28856 | 20 | |||
8498 | 233506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008710.79759 | 2107246.55273 | 37.7665893413473 | -122.413116956406 | (37.7665893413473, -122.413116956406) | 8 | 4 | 7 | 28853 | 19 | |||
8831 | 233416 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2601 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008962 | 2103248 | 37.7556243278629 | -122.411965491523 | (37.7556243278629, -122.411965491523) | 2 | 4 | 7 | 28859 | 19 | |||
10307 | 233401 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3025 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008031.26632 | 2103842.02923 | 37.7572031342345 | -122.415226318935 | (37.7572031342345, -122.415226318935) | 2 | 4 | 7 | 28859 | 19 | |||
10382 | 70244 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 322 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6005809.1541 | 2110870.1551 | 37.7763755628652 | -122.423410874448 | (37.7763755628652, -122.423410874448) | 7 | 9 | 11 | 28852 | 10 | |||
10542 | 233492 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 416 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001776.45872 | 2103391.52743 | 37.7556126580189 | -122.436825582043 | (37.7556126580189, -122.436825582043) | 2 | 4 | 5 | 28862 | 22 | |||
10685 | 233450 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3050 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009002.96054 | 2100768.18815 | 37.7488176180461 | -122.411648631477 | (37.7488176180461, -122.411648631477) | 2 | 4 | 7 | 28859 | 19 | |||
10817 | 233461 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6008869.1508 | 2103187.08693 | 37.7554518646255 | -122.41228228931 | (37.7554518646255, -122.41228228931) | 2 | 4 | 7 | 28859 | 19 | |||
11175 | 233468 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008789.90434 | 2104591.00964 | 37.7593022705969 | -122.412655591576 | (37.7593022705969, -122.412655591576) | 2 | 4 | 7 | 28859 | 19 | |||
11621 | 171168 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 61 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004706.69577 | 2093156.0367 | 37.7276744353238 | -122.425963318556 | (37.7276744353238, -122.425963318556) | 9 | 7 | 6 | 28861 | 5 | |||
11691 | 233464 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2905 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008837.85782 | 2103822.74046 | 37.7571954693154 | -122.412435439344 | (37.7571954693154, -122.412435439344) | 2 | 4 | 7 | 28859 | 19 | |||
12121 | 11883 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 400X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017703.73127 | 2096843.30561 | 37.7385249167977 | -122.381288201801 | (37.7385249167977, -122.381288201801) | 10 | 3 | 8 | 58 | 1 | |||
13057 | 73861 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 322 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6005837.5808 | 2110875.7018 | 37.7763923971267 | -122.423312932793 | (37.7763923971267, -122.423312932793) | 7 | 9 | 11 | 28852 | 10 | |||
13269 | 211313 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992606.24128 | 2099598.30232 | 37.7446719916245 | -122.468262856359 | (37.7446719916245, -122.468262856359) | 1 | 8 | 4 | 29491 | 40 | |||
14913 | 233381 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 399x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008152.13666 | 2096545.8865 | 37.7371763483116 | -122.414292086129 | (37.7371763483116, -122.414292086129) | 2 | 7 | 7 | 28859 | 2 | |||
14931 | 132217 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999261.04653 | 2118404.81755 | 37.7966920235835 | -122.446604753326 | (37.7966920235835, -122.446604753326) | 13 | 9 | 1 | 57 | 17 | |||
15232 | 233458 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008875.8887 | 2103056.30656 | 37.7550931493426 | -122.412249744651 | (37.7550931493426, -122.412249744651) | 2 | 4 | 7 | 28859 | 19 | |||
15538 | 233362 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 154 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006411.92043 | 2106982.43417 | 37.7657348109283 | -122.421049627935 | (37.7657348109283, -122.421049627935) | 8 | 4 | 7 | 28853 | 19 | |||
15836 | 199688 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015592.0163 | 2092881.2495 | 37.7275291054366 | -122.388313110838 | (37.7275291054366, -122.388313110838) | 10 | 3 | 8 | 58 | 1 | |||
16103 | 247814 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 532 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003126.49354 | 2098351.09832 | 37.7418494576778 | -122.431796869036 | (37.7418494576778, -122.431796869036) | 2 | 7 | 5 | 63 | 22 | |||
16610 | 211317 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 45 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993928.12229 | 2102221.55917 | 37.7519510476114 | -122.463882461023 | (37.7519510476114, -122.463882461023) | 1 | 8 | 4 | 29491 | 12 | |||
16867 | 233369 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3698 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005236.6856 | 2101975.24545 | 37.7519199283811 | -122.424758271091 | (37.7519199283811, -122.424758271091) | 2 | 4 | 5 | 28859 | 19 | |||
17190 | 233382 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 399x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008169.60603 | 2096545.72694 | 37.7371768914874 | -122.414231675074 | (37.7371768914874, -122.414231675074) | 2 | 7 | 7 | 28859 | 2 | |||
17779 | 233482 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008616.65718 | 2107731.28246 | 37.7679150113072 | -122.413476857889 | (37.7679150113072, -122.413476857889) | 8 | 4 | 7 | 28853 | 19 | |||
18592 | 111041 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004870.73043 | 2118877.40927 | 37.7983084704282 | -122.427227648441 | (37.7983084704282, -122.427227648441) | 13 | 9 | 1 | 57 | 17 | |||
19586 | 194533 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200 Alameda St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010348.85424 | 2107885.73513 | 37.7684362115906 | -122.40749624758 | (37.7684362115906, -122.40749624758) | 8 | 4 | 8 | 28853 | 19 | |||
21704 | 233429 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2101 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008762.87625 | 2106190.29183 | 37.7636920162083 | -122.412862138879 | (37.7636920162083, -122.412862138879) | 8 | 4 | 7 | 28859 | 19 | |||
21926 | 194544 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012545.36949 | 2107606.50724 | 37.7677922160651 | -122.399879039311 | (37.7677922160651, -122.399879039311) | 14 | 3 | 8 | 28856 | 20 | |||
22493 | 233394 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007790.53489 | 2106496.52663 | 37.7644782394947 | -122.416246865994 | (37.7644782394947, -122.416246865994) | 8 | 4 | 7 | 28859 | 19 | |||
22785 | 233411 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2709 Harrison St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 6008945.30625 | 2102700.68655 | 37.754120591896 | -122.411984548072 | (37.754120591896, -122.411984548072) | 2 | 4 | 7 | 28859 | 19 | |||
23623 | 233402 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3025 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008058.99429 | 2103844.13337 | 37.7572104700033 | -122.415130573511 | (37.7572104700033, -122.415130573511) | 2 | 4 | 7 | 28859 | 19 | |||
23719 | 132215 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999237.1134 | 2118402.93591 | 37.7966854900001 | -122.446687431602 | (37.7966854900001, -122.446687431602) | 13 | 9 | 1 | 57 | 17 | |||
23779 | 233442 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 95 Montezuma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007954.1776 | 2099786.14211 | 37.7460622517822 | -122.415205824295 | (37.7460622517822, -122.415205824295) | 2 | 7 | 7 | 28859 | 2 | |||
25550 | 211315 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1950 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993849.45223 | 2102159.58974 | 37.7517763614982 | -122.464150012924 | (37.7517763614982, -122.464150012924) | 1 | 8 | 4 | 29491 | 12 | |||
26016 | 233380 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 397 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007405.88509 | 2096272.27203 | 37.7363831156735 | -122.416852845398 | (37.7363831156735, -122.416852845398) | 2 | 7 | 7 | 28859 | 2 | |||
26684 | 194530 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 616 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6012360.41946 | 2105070.75065 | 37.7608192812075 | -122.400340636111 | (37.7608192812075, -122.400340636111) | 10 | 3 | 8 | 28856 | 29 | |||
26805 | 139841 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 855 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005489.2243 | 2112352.6717 | 37.7804281291994 | -122.424623086227 | (37.7804281291994, -122.424623086227) | 7 | 9 | 11 | 28852 | 41 | |||
28365 | 233483 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008612.51284 | 2107745.14575 | 37.7679528439771 | -122.413492173322 | (37.7679528439771, -122.413492173322) | 8 | 4 | 7 | 28853 | 19 | |||
28716 | 233494 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 885 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003128.49899 | 2103230.63077 | 37.7552476232057 | -122.432138316435 | (37.7552476232057, -122.432138316435) | 2 | 4 | 5 | 28862 | 22 | |||
28926 | 233410 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2727 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008964.10696 | 2102573.01039 | 37.7537710766793 | -122.41191050868 | (37.7537710766793, -122.41191050868) | 2 | 4 | 7 | 28859 | 19 | |||
30724 | 200624 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1382 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6016324.8756 | 2094912.2277 | 37.7331463494491 | -122.385921096754 | (37.7331463494491, -122.385921096754) | 10 | 3 | 8 | 58 | 1 | |||
35068 | 233485 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008609.33505 | 2107860.39921 | 37.7682691247363 | -122.413511317219 | (37.7682691247363, -122.413511317219) | 8 | 4 | 7 | 28853 | 19 | |||
36402 | 16950 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 630 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003955.1515 | 2110112.5344 | 37.7741905079368 | -122.429770337641 | (37.7741905079368, -122.429770337641) | 7 | 9 | 11 | 29492 | 10 | |||
37190 | 233448 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3250 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008442.79349 | 2104490.88845 | 37.7590078730361 | -122.41384899104 | (37.7590078730361, -122.41384899104) | 2 | 4 | 7 | 28859 | 19 | |||
37811 | 111042 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004867.45543 | 2118890.27835 | 37.7983436204214 | -122.42723989811 | (37.7983436204214, -122.42723989811) | 13 | 9 | 1 | 57 | 17 | |||
38583 | 233395 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007786.02518 | 2106562.96746 | 37.7646604169782 | -122.416267170006 | (37.7646604169782, -122.416267170006) | 8 | 4 | 7 | 28859 | 19 | |||
40590 | 199686 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015608.757 | 2092907.6605 | 37.7276025523971 | -122.388257080086 | (37.7276025523971, -122.388257080086) | 10 | 3 | 8 | 58 | 1 | |||
40647 | 233409 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6009007 | 2102243 | 37.7528673485866 | -122.411738857609 | (37.7528673485866, -122.411738857609) | 2 | 4 | 7 | 28859 | 19 | |||
41355 | 233444 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 550 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008943.54887 | 2105635.82599 | 37.7621797198454 | -122.412198056097 | (37.7621797198454, -122.412198056097) | 8 | 4 | 7 | 28859 | 19 | |||
42619 | 233498 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 101 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000562.67168 | 2104881.27171 | 37.7596340727711 | -122.441130104275 | (37.7596340727711, -122.441130104275) | 2 | 4 | 5 | 28862 | 3 | |||
42988 | 233501 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 6 Park Hill Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6001141.15752 | 2107828.11381 | 37.7677583098187 | -122.439340644067 | (37.7677583098187, -122.439340644067) | 15 | 5 | 5 | 29492 | 3 | |||
43147 | 233413 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2633 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008936.00153 | 2103092.78204 | 37.7551966757093 | -122.412044433915 | (37.7551966757093, -122.412044433915) | 2 | 4 | 7 | 28859 | 19 | |||
43234 | 233495 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 450 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003394.34799 | 2103331.88494 | 37.7555407122568 | -122.431226159276 | (37.7555407122568, -122.431226159276) | 2 | 4 | 5 | 28862 | 22 | |||
43559 | 194534 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 25 Lucy St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6014175.87087 | 2093939.45878 | 37.7303561623911 | -122.39328279268 | (37.7303561623911, -122.39328279268) | 10 | 3 | 8 | 58 | 1 | |||
45195 | 233474 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008786.04636 | 2104727.23574 | 37.7596760998778 | -122.412678564777 | (37.7596760998778, -122.412678564777) | 2 | 4 | 7 | 28859 | 19 | |||
45880 | 233471 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008785.30458 | 2104663.86276 | 37.7595020504945 | -122.412676650118 | (37.7595020504945, -122.412676650118) | 2 | 4 | 7 | 28859 | 19 | |||
46793 | 233443 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 550 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008940.03801 | 2105662.09914 | 37.7622516628983 | -122.412212055847 | (37.7622516628983, -122.412212055847) | 8 | 4 | 7 | 28859 | 19 | |||
46820 | 233418 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2593 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008919.41987 | 2103390.65129 | 37.7560136270404 | -122.412122828715 | (37.7560136270404, -122.412122828715) | 2 | 4 | 7 | 28859 | 19 | |||
47154 | 233360 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 40 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005303.62865 | 2105767.86216 | 37.7623373467104 | -122.42479655971 | (37.7623373467104, -122.42479655971) | 8 | 4 | 5 | 28859 | 19 | |||
49344 | 139946 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005060.605 | 2112352.3265 | 37.7804029654412 | -122.426105857766 | (37.7804029654412, -122.426105857766) | 7 | 9 | 11 | 28852 | 41 | |||
49515 | 233400 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2807 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009350.24678 | 2103328.60933 | 37.7558674377406 | -122.410628499003 | (37.7558674377406, -122.410628499003) | 2 | 4 | 7 | 28859 | 19 | |||
51549 | 123985 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 15 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993608.31847 | 2115347.64983 | 37.7879733773019 | -122.465942059673 | (37.7879733773019, -122.465942059673) | 11 | 6 | 1 | 54 | 11 | |||
52158 | 194535 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 360 Ritch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014325.43113 | 2111634.88834 | 37.7789523278141 | -122.394004006676 | (37.7789523278141, -122.394004006676) | 6 | 2 | 9 | 28856 | 34 | |||
52767 | 233370 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3698 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005218.25871 | 2101973.53157 | 37.7519141816957 | -122.424821872029 | (37.7519141816957, -122.424821872029) | 2 | 4 | 5 | 28859 | 19 | |||
53615 | 233359 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 93 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6004257.74689 | 2109007.55308 | 37.7711736292001 | -122.428644822623 | (37.7711736292001, -122.428644822623) | 7 | 9 | 11 | 29492 | 10 | |||
55259 | 178358 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 54 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004690.16722 | 2093211.84688 | 37.7278267435864 | -122.426024429306 | (37.7278267435864, -122.426024429306) | 9 | 7 | 6 | 28861 | 5 | |||
55423 | 233455 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2774 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008918.08813 | 2102304.0986 | 37.7530301234427 | -122.412050650042 | (37.7530301234427, -122.412050650042) | 2 | 4 | 7 | 28859 | 19 | |||
55832 | 233480 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1962 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008658.08091 | 2107023.31074 | 37.7659734109827 | -122.413283506344 | (37.7659734109827, -122.413283506344) | 8 | 4 | 7 | 28853 | 19 | |||
56947 | 233457 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008877.75301 | 2103039.18027 | 37.7550462290268 | -122.41224208692 | (37.7550462290268, -122.41224208692) | 2 | 4 | 7 | 28859 | 19 | |||
58069 | 233430 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2801 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008012.33322 | 2106763.12966 | 37.7652227387558 | -122.415498600376 | (37.7652227387558, -122.415498600376) | 8 | 4 | 7 | 28859 | 19 | |||
59287 | 233440 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 228 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008985.91579 | 2097299.41691 | 37.7392921796829 | -122.411462541085 | (37.7392921796829, -122.411462541085) | 10 | 7 | 7 | 28859 | 2 | |||
59459 | 26520 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2859 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1X1 | 6009005.00104 | 2101862.3389 | 37.7518220263649 | -122.411718875733 | (37.7518220263649, -122.411718875733) | 2 | 4 | 7 | 28859 | 19 | |||
59976 | 233441 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 33 Montezuma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007530.9568 | 2099766.89279 | 37.7459856034546 | -122.416667906996 | (37.7459856034546, -122.416667906996) | 2 | 7 | 7 | 28859 | 2 | |||
60057 | 233427 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6008800.67771 | 2105544.67026 | 37.761921409371 | -122.412685750365 | (37.761921409371, -122.412685750365) | 8 | 4 | 7 | 28859 | 19 | |||
61641 | 233466 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008796.08336 | 2104541.2747 | 37.7591660565788 | -122.412630705568 | (37.7591660565788, -122.412630705568) | 2 | 4 | 7 | 28859 | 19 | |||
62514 | 233432 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2805 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007955.9785 | 2106758.25417 | 37.7652061840354 | -122.415693173211 | (37.7652061840354, -122.415693173211) | 8 | 4 | 7 | 28859 | 19 | |||
63965 | 233374 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3101 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009080.92209 | 2100478.86061 | 37.7480275618365 | -122.411358602837 | (37.7480275618365, -122.411358602837) | 2 | 7 | 7 | 28859 | 2 | |||
65548 | 233507 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008711.02427 | 2107230.56462 | 37.7665454544263 | -122.413115041722 | (37.7665454544263, -122.413115041722) | 8 | 4 | 7 | 28853 | 19 | |||
66612 | 233437 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4221 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002351.48314 | 2100601.8225 | 37.7479854555773 | -122.434637500016 | (37.7479854555773, -122.434637500016) | 2 | 4 | 5 | 63 | 22 | |||
67414 | 139945 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005081.184 | 2112356.1174 | 37.7804145374079 | -122.426034935273 | (37.7804145374079, -122.426034935273) | 7 | 9 | 11 | 28852 | 41 | |||
67618 | 233375 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1489 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003970.51891 | 2099621.7541 | 37.7453861945158 | -122.428969076773 | (37.7453861945158, -122.428969076773) | 2 | 7 | 5 | 63 | 22 | |||
67852 | 233388 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008673.84119 | 2107870.27122 | 37.7682998527796 | -122.413288894184 | (37.7682998527796, -122.413288894184) | 8 | 4 | 7 | 28853 | 19 | |||
68145 | 194540 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012505.10498 | 2107346.22269 | 37.7670752882293 | -122.400000029601 | (37.7670752882293, -122.400000029601) | 14 | 3 | 8 | 28856 | 20 | |||
69068 | 233454 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2816 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008939.13168 | 2102033.55386 | 37.7522884489586 | -122.411958759988 | (37.7522884489586, -122.411958759988) | 2 | 4 | 7 | 28859 | 19 | |||
69127 | 120436 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 235 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5988981.18981 | 2113759.01569 | 37.7833434210971 | -122.481834493116 | (37.7833434210971, -122.481834493116) | 11 | 6 | 2 | 55 | 26 | |||
69295 | 233424 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2339 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008842.98925 | 2104818.80994 | 37.7599307375328 | -122.412488100069 | (37.7599307375328, -122.412488100069) | 2 | 4 | 7 | 28859 | 19 | |||
69752 | 132213 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000167.6867 | 2118186.05064 | 37.7961430935947 | -122.443451860639 | (37.7961430935947, -122.443451860639) | 13 | 9 | 1 | 57 | 17 | |||
69826 | 233366 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2964 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009652.81284 | 2101635.24983 | 37.7512348095611 | -122.409462618807 | (37.7512348095611, -122.409462618807) | 2 | 4 | 7 | 28859 | 19 | |||
69990 | 233487 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008673.30569 | 2107876.17641 | 37.768316036993 | -122.41329116408 | (37.768316036993, -122.41329116408) | 8 | 4 | 7 | 28853 | 19 | |||
72362 | 139831 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 925 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005175.7373 | 2112309.654 | 37.7802923037704 | -122.42570452289 | (37.7802923037704, -122.42570452289) | 7 | 9 | 11 | 28852 | 41 | |||
73030 | 194539 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012519.55617 | 2107331.82323 | 37.767036556231 | -122.399949033536 | (37.767036556231, -122.399949033536) | 14 | 3 | 8 | 28856 | 20 | |||
73390 | 14514 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 507 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5999077.3967 | 2111056.5759 | 37.7765051848822 | -122.446711235239 | (37.7765051848822, -122.446711235239) | 15 | 5 | 2 | 29492 | 16 |
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) );