trees
443 rows where qSpecies_id = 32 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
33947 | 91831 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1817X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008669.779404 | 2108251.243793 | 37.7693456867114 | -122.41332988852 | (37.7693456867114, -122.41332988852) | 8 | 4 | 7 | 28853 | 19 | ||
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 |
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 | |||
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 | |||
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 | |||
42115 | 91833 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1817X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2012 12:00:00 AM | 3 | 3x3 | 6008674.032707 | 2108297.585738 | 37.7694731696871 | -122.413318454137 | (37.7694731696871, -122.413318454137) | 8 | 4 | 7 | 28853 | 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 | |||
42962 | 91834 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1717X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008671 | 2108256 | 37.7693588146768 | -122.413326002916 | (37.7693588146768, -122.413326002916) | 8 | 4 | 7 | 28853 | 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 | |||
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 | |||
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 |
51086 | 91763 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008630.425108 | 2107902.838951 | 37.7683868385711 | -122.41344137031 | (37.7683868385711, -122.41344137031) | 8 | 4 | 7 | 28853 | 19 | ||
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 | |||
55733 | 39080 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2280X Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
78766 | 233383 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008607.04739 | 2107902.88148 | 37.7683856427104 | -122.413522234974 | (37.7683856427104, -122.413522234974) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
81814 | 194532 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010402.10466 | 2107886.85819 | 37.7684422757183 | -122.407312137446 | (37.7684422757183, -122.407312137446) | 8 | 4 | 8 | 28853 | 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 | ||
82544 | 91762 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008660.813755 | 2107281.610975 | 37.7666827970273 | -122.413292321769 | (37.7666827970273, -122.413292321769) | 8 | 4 | 7 | 28853 | 19 | |||
84326 | 233436 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 73 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000375.83482 | 2101284.56019 | 37.7497477337837 | -122.441518177039 | (37.7497477337837, -122.441518177039) | 2 | 4 | 5 | 28862 | 22 | |||
86394 | 81256 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 885 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50448 | 6003133.58124947 | 2103094.76960314 | 37.7548748688717 | -122.432111038861 | (37.7548748688717, -122.432111038861) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
93471 | 233385 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1818 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008614.2246 | 2107803.41147 | 37.768112924207 | -122.413490373789 | (37.768112924207, -122.413490373789) | 8 | 4 | 7 | 28853 | 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 | ||
96920 | 63999 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 595 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778275 | 6001356.36107438 | 2100834.50333121 | 37.7485677985315 | -122.438095249236 | (37.7485677985315, -122.438095249236) | 2 | 4 | 5 | 28862 | 22 | |
97136 | 233479 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2180 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008744.74823 | 2105468.88661 | 37.7617101855999 | -122.41287383096 | (37.7617101855999, -122.41287383096) | 2 | 4 | 7 | 28859 | 19 | |||
97210 | 91832 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1817X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2012 12:00:00 AM | 3 | 3x3 | 6008669.779404 | 2108251.243793 | 37.7693456867114 | -122.41332988852 | (37.7693456867114, -122.41332988852) | 8 | 4 | 7 | 28853 | 19 | ||
98646 | 233497 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 60 Yukon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000229.80091 | 2104520.72602 | 37.7586251368655 | -122.442255452052 | (37.7586251368655, -122.442255452052) | 2 | 4 | 5 | 28862 | 3 | |||
101577 | 233486 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008669.96247 | 2107902.14816 | 37.7683871616767 | -122.413304564874 | (37.7683871616767, -122.413304564874) | 8 | 4 | 7 | 28853 | 19 | |||
101767 | 233405 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2989 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009047.23113 | 2101093.61607 | 37.7497136539827 | -122.411518531957 | (37.7497136539827, -122.411518531957) | 2 | 4 | 7 | 28859 | 19 | |||
101913 | 26527 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2011 12:00:00 AM | 3 | 3x3 | 6009007.86561 | 2102243.77418 | 37.7528695228702 | -122.411735918856 | (37.7528695228702, -122.411735918856) | 2 | 4 | 7 | 28859 | 19 | ||
102670 | 98213 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
103294 | 91752 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2660 Harrison St | 2 | 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 | ||
104215 | 233392 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007791.82881 | 2106445.05823 | 37.7643369919914 | -122.416238745127 | (37.7643369919914, -122.416238745127) | 8 | 4 | 7 | 28859 | 19 | |||
106723 | 60332 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 4033 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2013 12:00:00 AM | 3x3 | Permit Number 770595 | 6002797.86052916 | 2104715.61000638 | 37.7593062690744 | -122.433387871218 | (37.7593062690744, -122.433387871218) | 2 | 4 | 5 | 28862 | 3 | ||
107605 | 108437 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
107980 | 233484 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1818 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008611.01854 | 2107834.46107 | 37.7681979991668 | -122.413503659485 | (37.7681979991668, -122.413503659485) | 8 | 4 | 7 | 28853 | 19 | |||
108313 | 96526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
108771 | 94031 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2576 Harrison St | 2 | 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 | ||
112502 | 91739 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2814 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 4 | 3x3 | 6008944.07429 | 2102060.386342 | 37.7523624022397 | -122.411943563585 | (37.7523624022397, -122.411943563585) | 2 | 4 | 7 | 28859 | 19 | ||
112885 | 40291 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3698X 24th St | 4 | 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 |
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) );