trees
443 rows where qSpecies_id = 32 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9107 | 264723 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 335 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782646 | 6008658.96802 | 2100212.34216 | 37.7472720863526 | -122.412798868954 | (37.7472720863526, -122.412798868954) | 2 | 7 | 7 | 28859 | 2 | |
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 | |||
10598 | 91743 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2708 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008911.299202 | 2102677.621362 | 37.7540553520509 | -122.412100523216 | (37.7540553520509, -122.412100523216) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
10960 | 166315 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008872.21502 | 2103120.32489 | 37.7552687230844 | -122.412266973836 | (37.7552687230844, -122.412266973836) | 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 | |||
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 | |||
12003 | 166317 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008865.69274 | 2103234.56357 | 37.755582030708 | -122.412297603862 | (37.755582030708, -122.412297603862) | 2 | 4 | 7 | 28859 | 19 | |
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 | |||
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 | |||
16166 | 166316 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008870.16891 | 2103155.64589 | 37.7553655917605 | -122.412276546247 | (37.7553655917605, -122.412276546247) | 2 | 4 | 7 | 28859 | 19 | |
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 | |||
17099 | 96505 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 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 | |||
18610 | 259660 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008872.21502 | 2103120.32489 | 37.7552687230844 | -122.412266973836 | (37.7552687230844, -122.412266973836) | 2 | 4 | 7 | 28859 | 19 | |
21524 | 96504 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 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 | |||
21910 | 96514 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2525 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | 6008931.78407 | 2103601.217 | 37.7565924865992 | -122.412094949605 | (37.7565924865992, -122.412094949605) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 | |||
23903 | 107340 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 300X EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773835 | 6006696 | 2098030 | 37.7411694904711 | -122.419431881915 | (37.7411694904711, -122.419431881915) | 2 | 7 | 7 | 28859 | 2 | |
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 | |||
26635 | 26526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 3x3 | 6009007 | 2102243 | 37.7528673485866 | -122.411738857609 | (37.7528673485866, -122.411738857609) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
30388 | 91747 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.412262362741 | (37.7557803438331, -122.412262362741) | 2 | 4 | 7 | 28859 | 19 | ||
30722 | 91760 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2190X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008735.241541 | 2105700.534049 | 37.7623457027108 | -122.412923089625 | (37.7623457027108, -122.412923089625) | 8 | 4 | 7 | 28859 | 19 | ||
31941 | 91751 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2660 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008895.550687 | 2102970.363593 | 37.7548582726151 | -122.412175673836 | (37.7548582726151, -122.412175673836) | 2 | 4 | 7 | 28859 | 19 | ||
32774 | 233361 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 28 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | 6005734.12152 | 2106385.89097 | 37.7640586131313 | -122.423351580335 | (37.7640586131313, -122.423351580335) | 8 | 4 | 5 | 28859 | 19 | ||
33577 | 38310 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2003 12:00:00 AM | Permit Number 47228 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
34340 | 45171 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 47 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44018 | 6010456.17942581 | 2099626.75633158 | 37.7457649076199 | -122.406542957313 | (37.7457649076199, -122.406542957313) | 2 | 7 | 7 | 28859 | 2 | ||
34806 | 91741 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2844 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008953.436672 | 2101893.072239 | 37.7519035204675 | -122.411899364623 | (37.7519035204675, -122.411899364623) | 2 | 4 | 7 | 28859 | 19 | |||
34823 | 108597 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
34960 | 115370 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 481 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 773523 | 6007887 | 2096619.6 | 37.7373638523191 | -122.415214003631 | (37.7373638523191, -122.415214003631) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
37442 | 87929 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||
40487 | 96154 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 482 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767788 | 6008200 | 2096596 | 37.7373166375453 | -122.414130144574 | (37.7373166375453, -122.414130144574) | 2 | 7 | 7 | 28859 | 2 | |
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 | |||
41209 | 91753 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2500X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/07/2007 12:00:00 AM | 5 | 3x3 | 6008845.834759 | 2103888.876448 | 37.7573775113883 | -122.412412526543 | (37.7573775113883, -122.412412526543) | 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 | |||
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 | |||
44113 | 96509 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
48429 | 94030 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2576 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2010 12:00:00 AM | 3x3 | Permit Number 53444 | 6008873.8 | 2103464.7 | 37.756214388248 | -122.412285831464 | (37.756214388248, -122.412285831464) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
50919 | 108598 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
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 | |||
54744 | 108430 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3025 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772569 | 6008074.01196 | 2103843.74387 | 37.7572102444691 | -122.415078608854 | (37.7572102444691, -122.415078608854) | 2 | 4 | 7 | 28859 | 19 |
55022 | 96512 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
55923 | 91746 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.412262362741 | (37.7557803438331, -122.412262362741) | 2 | 4 | 7 | 28859 | 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 | |||
60569 | 66609 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 28- 30 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | Permit Number 773746 | 6005799.80596486 | 2106395.73703004 | 37.7640893550041 | -122.423125096713 | (37.7640893550041, -122.423125096713) | 8 | 4 | 5 | 28859 | 19 | |
61050 | 38300 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 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 | |||
63347 | 91750 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008893.124476 | 2103015.18846 | 37.7549812154524 | -122.412187232232 | (37.7549812154524, -122.412187232232) | 2 | 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 | |||
65099 | 28133 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 400X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/2018 12:00:00 AM | 3 | 6x9 | Permit Number 778832 | 6006730.12639 | 2098017.46298 | 37.7411369886855 | -122.419312995691 | (37.7411369886855, -122.419312995691) | 2 | 7 | 7 | 28859 | 2 | |
65592 | 38311 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | Permit Number 47228 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 | |||
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 | |||
73749 | 233470 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008786.34502 | 2104633.52501 | 37.7594188083449 | -122.412670907051 | (37.7594188083449, -122.412670907051) | 2 | 4 | 7 | 28859 | 19 | |||
75504 | 233412 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2685 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008988 | 2102801 | 37.7543984253045 | -122.411843990089 | (37.7543984253045, -122.411843990089) | 2 | 4 | 7 | 28859 | 19 | |||
75897 | 96511 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
76805 | 91758 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008737.740026 | 2105649.554962 | 37.7622058660826 | -122.412910843759 | (37.7622058660826, -122.412910843759) | 2 | 4 | 7 | 28859 | 19 | ||
77655 | 40289 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3698X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41436 | 6005153.62196948 | 2101950.32896523 | 37.7518468217067 | -122.42504374449 | (37.7518468217067, -122.42504374449) | 2 | 4 | 5 | 28859 | 19 |
78670 | 233379 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 397 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007387.94989 | 2096274.13101 | 37.7363872111847 | -122.41691498673 | (37.7363872111847, -122.41691498673) | 2 | 7 | 7 | 28859 | 2 | |||
79575 | 233467 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008792.16391 | 2104566.15897 | 37.7592341631379 | -122.412646020091 | (37.7592341631379, -122.412646020091) | 2 | 4 | 7 | 28859 | 19 | |||
79956 | 233364 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 200 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006470.82119 | 2104891.78129 | 37.7599976884594 | -122.420697473213 | (37.7599976884594, -122.420697473213) | 2 | 4 | 7 | 28859 | 19 | |||
80099 | 233453 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2840 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008939.52264 | 2101917.23039 | 37.7519690727134 | -122.411949188506 | (37.7519690727134, -122.411949188506) | 2 | 4 | 7 | 28859 | 19 | |||
81331 | 233407 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2959 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009039.77718 | 2101237.37153 | 37.7501079563364 | -122.411554463491 | (37.7501079563364, -122.411554463491) | 2 | 4 | 7 | 28859 | 19 | |||
81445 | 233420 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2475 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008882.84351 | 2104050.40662 | 37.75782311337 | -122.412295951823 | (37.75782311337, -122.412295951823) | 2 | 4 | 7 | 28859 | 19 | |||
81818 | 96502 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
84140 | 233377 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 514 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007431.42413 | 2096297.49525 | 37.7364538095851 | -122.416766332396 | (37.7364538095851, -122.416766332396) | 2 | 7 | 7 | 28859 | 2 | |||
86913 | 233475 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008784.35145 | 2104752.62578 | 37.7597457200079 | -122.412686221592 | (37.7597457200079, -122.412686221592) | 2 | 4 | 7 | 28859 | 19 | |||
88213 | 96513 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
88990 | 91818 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2475 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6008876.426107 | 2104060.19764 | 37.757849637178 | -122.41231883798 | (37.757849637178, -122.41231883798) | 2 | 4 | 7 | 28859 | 19 | ||
89268 | 233371 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009946.29944 | 2104530.48554 | 37.7592009197153 | -122.408651928554 | (37.7592009197153, -122.408651928554) | 2 | 4 | 7 | 28859 | 19 | |||
91272 | 91757 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008781.413784 | 2104958.401867 | 37.7603105692892 | -122.412710929059 | (37.7603105692892, -122.412710929059) | 2 | 4 | 7 | 28859 | 19 | ||
93220 | 87932 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
93433 | 233446 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 180 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006684.57542 | 2102745.85147 | 37.7541175063307 | -122.419805927624 | (37.7541175063307, -122.419805927624) | 2 | 4 | 7 | 28859 | 19 | |||
93667 | 233434 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 20 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006113.31148 | 2102315.53922 | 37.7529037696113 | -122.421750938181 | (37.7529037696113, -122.421750938181) | 2 | 4 | 5 | 28859 | 19 | |||
93946 | 91761 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2190X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008735.241541 | 2105700.534049 | 37.7623457027108 | -122.412923089625 | (37.7623457027108, -122.412923089625) | 8 | 4 | 7 | 28859 | 19 | ||
94761 | 87930 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
95271 | 233433 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2807 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007897.90504 | 2106755.67526 | 37.7651958382412 | -122.415893853325 | (37.7651958382412, -122.415893853325) | 8 | 4 | 7 | 28859 | 19 | |||
96556 | 76323 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2111 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1994 12:00:00 AM | 3 | 3x3 | 6008755.93357293 | 2106237.29701545 | 37.7638206919277 | -122.412889475083 | (37.7638206919277, -122.412889475083) | 8 | 4 | 7 | 28859 | 19 |
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) );