trees
443 rows where qSpecies_id = 32 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
114296 | 38316 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 8 | 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 | ||
124229 | 38308 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 5 | 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 | ||
124358 | 87931 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008038 | 2106791 | 37.7653007068824 | -122.415411798097 | (37.7653007068824, -122.415411798097) | 8 | 4 | 7 | 28859 | 19 | ||
133308 | 38305 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 7 | 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 | ||
187382 | 38306 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 6 | 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 | ||
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 | |||
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 | |||
171151 | 199687 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015600.4454 | 2092895.2979 | 37.7275681466115 | -122.388284951178 | (37.7275681466115, -122.388284951178) | 10 | 3 | 8 | 58 | 1 | |||
14763 | 97267 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2050X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769192 | 5999912.27224 | 2116008.29642 | 37.7901489853223 | -122.444179075813 | (37.7901489853223, -122.444179075813) | 13 | 6 | 1 | 29490 | 27 | |
3388 | 261119 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2067 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | 6011786.16554 | 2094038.32843 | 37.730494584078 | -122.401551330673 | (37.730494584078, -122.401551330673) | 10 | 3 | 8 | 58 | 1 | ||
150663 | 91759 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2100X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008715.935636 | 2106109.169361 | 37.7634666376506 | -122.413018756224 | (37.7634666376506, -122.413018756224) | 8 | 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 | |||
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 | ||
123820 | 233428 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2147 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.0081 | 2105817.64626 | 37.7626700032421 | -122.412762703536 | (37.7626700032421, -122.412762703536) | 8 | 4 | 7 | 28859 | 19 | |||
149857 | 91824 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2151 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008766 | 2105886 | 37.7628566761401 | -122.412829820139 | (37.7628566761401, -122.412829820139) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 | ||
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 | ||
190246 | 95637 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2196 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767403 | 6008103 | 2105638 | 37.7621384889596 | -122.415105357383 | (37.7621384889596, -122.415105357383) | 8 | 4 | 7 | 28859 | 19 | |
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 | |||
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 | |||
123302 | 233425 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008802.53088 | 2105481.30644 | 37.7617475308496 | -122.412674861355 | (37.7617475308496, -122.412674861355) | 8 | 4 | 7 | 28859 | 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 | ||
159351 | 96524 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
194076 | 96525 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
17666 | 52759 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 22 Gaven St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2014 12:00:00 AM | 3 | Permit Number 774111 | 6010286.03762 | 2095339.86575 | 37.7339845095792 | -122.406829209621 | (37.7339845095792, -122.406829209621) | 10 | 3 | 7 | 309 | 28 | ||
170251 | 52758 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 22 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 1 | Permit Number 774111 | 6010296.38896 | 2095344.759 | 37.733998524598 | -122.406793766427 | (37.733998524598, -122.406793766427) | 10 | 3 | 7 | 309 | 28 | ||
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 | |||
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 | |||
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 | ||
83366 | 45466 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2211 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2001 12:00:00 AM | Permit Number 44247 | 6011994.00463493 | 2101339.69847182 | 37.7505541915496 | -122.401345703709 | (37.7505541915496, -122.401345703709) | 10 | 3 | 8 | 28856 | 1 | |||
118535 | 194531 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2221 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011908.13677 | 2101346.92633 | 37.75056924647 | -122.401643151235 | (37.75056924647, -122.401643151235) | 10 | 3 | 8 | 28856 | 1 | |||
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 | |||
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 | |||
167745 | 39073 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2280X Alameda St | 6 | 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 | |||
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 | |||
126685 | 211312 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992605.95071 | 2099584.48851 | 37.7446340456409 | -122.468262856351 | (37.7446340456409, -122.468262856351) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
174477 | 233422 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2349 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008855.0309 | 2104568.88986 | 37.7592451897218 | -122.41242878797 | (37.7592451897218, -122.41242878797) | 2 | 4 | 7 | 28859 | 19 | |||
193219 | 233423 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2349 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008850.79758 | 2104700.64825 | 37.7596067306737 | -122.412452742325 | (37.7596067306737, -122.412452742325) | 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 | |||
120408 | 178359 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 235 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003629.76511 | 2092456.58351 | 37.7256929707372 | -122.429636417784 | (37.7256929707372, -122.429636417784) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
119309 | 233476 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.53012 | 2104788.45028 | 37.7598440959392 | -122.412688136268 | (37.7598440959392, -122.412688136268) | 2 | 4 | 7 | 28859 | 19 | |||
119326 | 233469 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008788.18662 | 2104615.29768 | 37.7593688636119 | -122.412663249315 | (37.7593688636119, -122.412663249315) | 2 | 4 | 7 | 28859 | 19 | |||
140452 | 233472 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008783.57561 | 2104687.59979 | 37.7595671299267 | -122.412684307851 | (37.7595671299267, -122.412684307851) | 2 | 4 | 7 | 28859 | 19 | |||
155461 | 233473 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008782.8633 | 2104706.90651 | 37.7596201017978 | -122.412688136266 | (37.7596201017978, -122.412688136266) | 2 | 4 | 7 | 28859 | 19 | |||
159245 | 233477 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008779.60533 | 2104818.31587 | 37.7599258236246 | -122.412707280136 | (37.7599258236246, -122.412707280136) | 2 | 4 | 7 | 28859 | 19 | |||
174518 | 233478 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008776.66854 | 2104837.11683 | 37.7599772819377 | -122.41271876626 | (37.7599772819377, -122.41271876626) | 2 | 4 | 7 | 28859 | 19 | |||
5845 | 96500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 1 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
115599 | 96503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | |||
124180 | 96506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 8 | 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 | ||
146063 | 96501 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 2 | 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 | ||
189404 | 96510 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 12 | 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 | ||
119202 | 91819 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2415 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 8 | 3x3 | 6008857.839983 | 2104395.646442 | 37.7587696603701 | -122.412406827225 | (37.7587696603701, -122.412406827225) | 2 | 4 | 7 | 28859 | 19 | ||
145019 | 233421 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2415 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008868.39184 | 2104298.37433 | 37.7585031654107 | -122.412363458525 | (37.7585031654107, -122.412363458525) | 2 | 4 | 7 | 28859 | 19 | |||
179917 | 91756 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2450 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |
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 | ||
131782 | 233419 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2525 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008908.13628 | 2103593.41402 | 37.7565697345137 | -122.412176180999 | (37.7565697345137, -122.412176180999) | 2 | 4 | 7 | 28859 | 19 | |||
106410 | 57835 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 254 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1977 12:00:00 AM | 30 | 3x10 | Permit Number 16776 | 5996589.21937103 | 2105630.13222731 | 37.7614631235225 | -122.4549263227 | (37.7614631235225, -122.4549263227) | 15 | 5 | 11 | 29492 | 12 | |
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 | ||
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 | ||
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 | |||
156920 | 233417 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2595 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008920.69253 | 2103375.89006 | 37.7559731674471 | -122.412117384237 | (37.7559731674471, -122.412117384237) | 2 | 4 | 7 | 28859 | 19 | |||
166080 | 91817 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2595 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008914.192408 | 2103366.044871 | 37.7559457700652 | -122.41213916812 | (37.7559457700652, -122.41213916812) | 2 | 4 | 7 | 28859 | 19 | ||
169761 | 91816 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2595 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008914.192408 | 2103366.044871 | 37.7559457700652 | -122.41213916812 | (37.7559457700652, -122.41213916812) | 2 | 4 | 7 | 28859 | 19 | ||
131550 | 233462 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2598 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008860.64869 | 2103366.96238 | 37.7559452848687 | -122.412324405443 | (37.7559452848687, -122.412324405443) | 2 | 4 | 7 | 28859 | 19 | |||
138652 | 91754 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2598 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008875.46007 | 2103341.542813 | 37.7558763196163 | -122.412271386078 | (37.7558763196163, -122.412271386078) | 2 | 4 | 7 | 28859 | 19 | ||
170559 | 91755 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2598 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008875.46007 | 2103341.542813 | 37.7558763196163 | -122.412271386078 | (37.7558763196163, -122.412271386078) | 2 | 4 | 7 | 28859 | 19 | ||
58134 | 38018 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 26 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.7429295327147 | -122.46804846503 | (37.7429295327147, -122.46804846503) | 1 | 8 | 4 | 29491 | 40 | ||
141605 | 38019 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 26 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.7429295327147 | -122.46804846503 | (37.7429295327147, -122.46804846503) | 1 | 8 | 4 | 29491 | 40 | ||
922 | 91748 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 3 | 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 | ||
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 | |
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 | |
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 | |
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 | |
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 | ||
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 |
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) );