trees

2,365 rows where qSpecies_id = 31 sorted by Location descending

✎ View and edit SQL

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)
147382 136973 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2430 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6000191.50201 2119579.32161 37.7999700038735 -122.443469586277 (37.7999700038735, -122.443469586277) 13 9 1 57 17
173998 136990 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2423 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6000237.89939 2119535.3298 37.7998518599455 -122.443305872762 (37.7998518599455, -122.443305872762) 13 9 1 57 17
121063 136991 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2423 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000225.01908 2119533.20073 37.799845279595 -122.443350290299 (37.799845279595, -122.443350290299) 13 9 1 57 17
106141 137053 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900 Green St 28 Front Yard : Yard Tree Private 2     8     6008580.77711 2119003.85777 37.7988647784329 -122.414398677364 (37.7988647784329, -122.414398677364) 5 1 10 308 32
66717 136968 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 77 Pixley St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003015.29864 2119068.11708 37.7987270014142 -122.433661633074 (37.7987270014142, -122.433661633074) 13 9 1 57 17
90799 136967 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 77 Pixley St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002998.66634 2119066.93448 37.7987228105586 -122.433719101552 (37.7987228105586, -122.433719101552) 13 9 1 57 17
39987 33125 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2380 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 13 6x7 Permit Number 37358 6001538.52427 2119069.35252 37.7986464896046 -122.438771824677 (37.7986464896046, -122.438771824677) 13 9 1 57 17
41592 33124 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2380 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 12 6x6 Permit Number 37358 6001499.40758 2119065.90574 37.7986348002003 -122.438906933417 (37.7986348002003, -122.438906933417) 13 9 1 57 17
58674 136969 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2640 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6000252.03874 2118890.89742 37.7980832262203 -122.443210635483 (37.7980832262203, -122.443210635483) 13 9 1 57 17
70821 96366 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1326 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006664.3237 2118739.81484 37.7980319387709 -122.421011488604 (37.7980319387709, -122.421011488604) 13 9 10 28858 32
145165 104802 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2670 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 6x9   6000116.77208 2118873.41414 37.7980275078187 -122.443677439384 (37.7980275078187, -122.443677439384) 13 9 1 57 17
89564 63582 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1370 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/1987 12:00:00 AM 7 3x3 Permit Number 24205 6006460.0817 2118715.02595 37.797952359573 -122.42171646447 (37.797952359573, -122.42171646447) 13 9 10 28858 32
66508 66277 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2750 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2007 12:00:00 AM 6   Permit No. 49271 5999752.72813 2118820.10006 37.7978603517187 -122.444933297631 (37.7978603517187, -122.444933297631) 13 9 1 57 17
82816 101523 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2326 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6001809.97493 2118762.85825 37.7978203759732 -122.437810557338 (37.7978203759732, -122.437810557338) 13 9 1 57 17
89847 101524 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2326 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6001795.96309 2118760.54126 37.7978132173675 -122.437858876082 (37.7978132173675, -122.437858876082) 13 9 1 57 17
184326 136987 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1508 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005725.54512 2118613.25141 37.7976314643833 -122.424250931151 (37.7976314643833, -122.424250931151) 13 9 1 57 17
10305 98993 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1919 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2012 12:00:00 AM 1 3x3 Permit Number 768862 6003810 2118645 37.7976102909597 -122.430881499482 (37.7976102909597, -122.430881499482) 13 9 1 57 17
114670 137059 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 39 Osgood Pl 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6011878.58523 2118466.36717 37.7975736631502 -122.402949290579 (37.7975736631502, -122.402949290579) 3 1 10 308 23
26567 110786 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 410 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012080 2118442 37.7975180016372 -122.402250623365 (37.7975180016372, -122.402250623365) 3 1 10 308 23
97685 137055 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 430 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6012022.18721 2118437.46443 37.7975023208205 -122.40245035302 (37.7975023208205, -122.40245035302) 3 1 10 308 23
23263 137056 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 430 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012005.94187 2118434.64519 37.7974936729554 -122.402506368172 (37.7974936729554, -122.402506368172) 3 1 10 308 23
180728 137057 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 430 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6011992.2179 2118432.89222 37.7974880935481 -122.402553733674 (37.7974880935481, -122.402553733674) 3 1 10 308 23
190372 137058 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 440 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6011933.40589 2118423.08303 37.7974578763363 -122.402756549698 (37.7974578763363, -122.402756549698) 3 1 10 308 23
98651 33318 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2604 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM 8   Permit Number 37462 6004913.93801 2118560.00816 37.7974394114518 -122.427055518194 (37.7974394114518, -122.427055518194) 13 9 1 57 17
61571 55641 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 450 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/1973 12:00:00 AM 12   Permit Number 11624 6011869.72365 2118415.97295 37.7974347979269 -122.40297640786 (37.7974347979269, -122.40297640786) 3 1 10 308 23
16688 137060 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 462 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011807.58318 2118407.27 37.7974074315733 -122.403190818824 (37.7974074315733, -122.403190818824) 3 1 10 308 23
75256 137061 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 462 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011779.14715 2118403.24493 37.7973947915995 -122.403288932137 (37.7973947915995, -122.403288932137) 3 1 10 308 23
73533 35673 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 490 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   04/03/1998 12:00:00 AM 8 4x4 Permit Number 38982 6011704.38678633 2118401.70170081 37.7973863786405 -122.403547515196 (37.7973863786405, -122.403547515196) 3 1 10 308 23
116030 35674 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 490 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/03/1998 12:00:00 AM 8 4x4 Permit Number 38982 6011704.38678633 2118401.70170081 37.7973863786405 -122.403547515196 (37.7973863786405, -122.403547515196) 3 1 10 308 23
180670 35675 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 490 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/03/1998 12:00:00 AM 8 4x4 Permit Number 38982 6011704.38678633 2118401.70170081 37.7973863786405 -122.403547515196 (37.7973863786405, -122.403547515196) 3 1 10 308 23
186422 35676 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 490 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/1998 12:00:00 AM 8 4x4 Permit Number 38982 6011704.38678633 2118401.70170081 37.7973863786405 -122.403547515196 (37.7973863786405, -122.403547515196) 3 1 10 308 23
116258 137062 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 462 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011753.78546 2118398.85013 37.7973813080638 -122.40337638132 (37.7973813080638, -122.40337638132) 3 1 10 308 23
107408 137063 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 462 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011730.01399 2118396.8785 37.7973745667251 -122.403458498435 (37.7973745667251, -122.403458498435) 3 1 10 308 23
82189 110674 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 34 Bonita St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 2.5x3   6006186.90221 2118494.21303 37.7973306546326 -122.422646045101 (37.7973306546326, -122.422646045101) 13 9 10 28858 32
52919 110675 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 34 Bonita St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 2.5x3   6006170.0244 2118492.14329 37.7973240194296 -122.422704299571 (37.7973240194296, -122.422704299571) 13 9 10 28858 32
180201 136989 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2781 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5999666.44189 2118415.79962 37.7967453254804 -122.445202788494 (37.7967453254804, -122.445202788494) 13 9 1 57 17
103206 106762 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900x Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     7     6003492.62047 2118318.25536 37.796695146921 -122.431956373706 (37.796695146921, -122.431956373706) 13 9 1 57 17
65142 136958 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Divisadero St 8 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6000568.04629 2118355.71273 37.7966317645105 -122.442078724458 (37.7966317645105, -122.442078724458) 13 9 1 57 17
168818 48429 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2460 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2002 12:00:00 AM 10   Permit Number 45807 6001230.18864 2118334.23878 37.7966105144187 -122.439786028808 (37.7966105144187, -122.439786028808) 13 9 1 57 17
120365 136962 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2460 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001208.87225 2118332.01325 37.7966031903358 -122.439859628443 (37.7966031903358, -122.439859628443) 13 9 1 57 17
45688 136988 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2855 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5999300.72637 2118363.97788 37.7965821551925 -122.446464513021 (37.7965821551925, -122.446464513021) 13 9 1 57 17
84003 136959 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Divisadero St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6000575.50747 2118297.87683 37.7964733875853 -122.442048753659 (37.7964733875853, -122.442048753659) 13 9 1 57 17
185104 136960 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6000577.85533 2118280.57754 37.7964260220962 -122.442039387228 (37.7964260220962, -122.442039387228) 13 9 1 57 17
190529 137028 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2057 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6003223.22919 2118218.73656 37.7964066183283 -122.432881414555 (37.7964066183283, -122.432881414555) 13 9 1 57 17
184193 136961 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6000580.09999 2118271.36688 37.7964008599691 -122.442030958785 (37.7964008599691, -122.442030958785) 13 9 1 57 17
42775 137027 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2057 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6003211.76656 2118215.6872 37.7963975954305 -122.432920859704 (37.7963975954305, -122.432920859704) 13 9 1 57 17
3454 136963 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2590 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6000644.64668 2118255.6964 37.7963615110306 -122.441806488875 (37.7963615110306, -122.441806488875) 13 9 1 57 17
69088 136964 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2590 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6000622.04414 2118252.24291 37.7963507407448 -122.441884450223 (37.7963507407448, -122.441884450223) 13 9 1 57 17
185186 46875 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1031 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM 10 3x4 Permit Number 44938 6009178.55411 2118013.02984 37.7961777714378 -122.412260097639 (37.7961777714378, -122.412260097639) 3 1 10 308 21
141862 55752 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2224 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/1973 12:00:00 AM 19   Permit Number 11785 6002371.1638 2118147.1071 37.7961615782478 -122.435824610533 (37.7961615782478, -122.435824610533) 13 9 1 57 17
80399 136965 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2762 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5999775.07561 2118126.74108 37.7959578476198 -122.44480610383 (37.7959578476198, -122.44480610383) 13 9 1 57 17
164102 136966 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2774 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5999732.29105 2118122.60926 37.7959440610266 -122.444953848948 (37.7959440610266, -122.444953848948) 13 9 1 57 17
73890 55949 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2814 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/20/1989 12:00:00 AM 3   Permit Number 28156 5999490.08281 2118090.45953 37.7958419601055 -122.445789619521 (37.7958419601055, -122.445789619521) 13 9 1 57 17
174642 69334 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2059 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/1994 12:00:00 AM 12   Permit Number 33419 6003702.41325 2117935.14226 37.7956551079377 -122.43120308357 (37.7956551079377, -122.43120308357) 13 9 1 29490 27
59679 137031 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1752 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6005234.06309 2117850.62901 37.7955097334486 -122.425897279546 (37.7955097334486, -122.425897279546) 13 9 1 28858 27
81011 137032 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1756 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005211.20032 2117849.05905 37.7955041306666 -122.425976276892 (37.7955041306666, -122.425976276892) 13 9 1 28858 27
179762 137033 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1756 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005192.45176 2117848.27927 37.79550092999 -122.426041094625 (37.79550092999, -122.426041094625) 13 9 1 28858 27
30309 137034 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1756 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6005175.40466 2117844.84093 37.7954905257115 -122.426099835651 (37.7954905257115, -122.426099835651) 13 9 1 28858 27
174907 30288 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1365 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/1956 12:00:00 AM 14   Permit Number 132 6008888.59821 2117621.05322 37.795085225551 -122.413235675009 (37.795085225551, -122.413235675009) 5 1 10 28857 21
52684 30285 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1355 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/1956 12:00:00 AM 8   Permit Number 132 6008895.30173 2117592.00623 37.7950058459972 -122.413210424719 (37.7950058459972, -122.413210424719) 5 1 10 28857 21
116316 137016 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2741 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6000594.28905 2117750.14892 37.7949705413204 -122.441944432297 (37.7949705413204, -122.441944432297) 13 9 1 57 27
138487 30286 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1355 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/06/1956 12:00:00 AM 10   Permit Number 132 6008896.76565 2117570.49119 37.7949468531686 -122.413203837186 (37.7949468531686, -122.413203837186) 5 1 10 28857 21
10264 137022 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003025.71137 2117483.5061 37.7943766605074 -122.433512298867 (37.7943766605074, -122.433512298867) 13 9 1 29490 27
26952 137023 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003036.9655 2117481.25366 37.7943711144001 -122.433473197238 (37.7943711144001, -122.433473197238) 13 9 1 29490 27
176355 137021 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6003013.18529 2117480.30225 37.7943671528679 -122.433555411475 (37.7943671528679, -122.433555411475) 13 9 1 29490 27
176412 137024 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 4ft   6003051.10397 2117478.36483 37.7943639845568 -122.433424069968 (37.7943639845568, -122.433424069968) 13 9 1 29490 27
44300 137020 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6002995.15639 2117477.21245 37.7943576461387 -122.433617572612 (37.7943576461387, -122.433617572612) 13 9 1 29490 27
119288 53481 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1969 12:00:00 AM 8   Permit Number 6390 6002979.07126 2117470.0427 37.7943370471773 -122.433672716337 (37.7943370471773, -122.433672716337) 13 9 1 29490 27
181780 137025 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2257 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6003076.30587 2117463.99371 37.79432595493 -122.43333584109 (37.79432595493, -122.43333584109) 13 9 1 29490 27
169213 137026 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2257 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6003079.39439 2117445.17436 37.7942744570554 -122.433323809051 (37.7942744570554, -122.433323809051) 13 9 1 29490 27
37219 137015 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2795 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6000234.59127 2117454.54255 37.7941383806269 -122.443167794482 (37.7941383806269, -122.443167794482) 13 9 1 57 27
74737 137014 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2795 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6000218.16422 2117453.42518 37.7941343759438 -122.443224553374 (37.7941343759438, -122.443224553374) 13 9 1 57 27
33627 39478 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2856 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 777203 5999897.32915775 2117456.37972289 37.7941241886563 -122.44433488583 (37.7941241886563, -122.44433488583) 13 9 1 57 27
84706 103143 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2620 Buchanan St 1 Front Yard : Yard Tree Private 2       3x3   6003626 2117322 37.7939672460834 -122.431423695166 (37.7939672460834, -122.431423695166) 13 9 1 29490 27
153927 137043 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1228 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6008992.0949 2117188.5729 37.7939035505658 -122.412846968238 (37.7939035505658, -122.412846968238) 3 1 10 28857 21
4577 137042 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1228 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6008994.19297 2117174.51361 37.7938650649634 -122.412838714232 (37.7938650649634, -122.412838714232) 3 1 10 28857 21
43128 51255 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2485 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2006 12:00:00 AM 8   Permit Number 49056 6001759.16032 2117307.51172 37.7938214847188 -122.437882095676 (37.7938214847188, -122.437882095676) 13 9 1 29490 27
56170 46874 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1360 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44937 6008040.39641169 2117081.79459414 37.7935568987708 -122.416132380604 (37.7935568987708, -122.416132380604) 5 1 10 28858 21
127597 103379 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 2712 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2013 12:00:00 AM 4 3x3 Permit Number 770136 6000520 2117210 37.7934832007909 -122.44216269001 (37.7934832007909, -122.44216269001) 13 9 1 57 27
16717 262293 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002408 2117119 37.7933407549318 -122.435623560602 (37.7933407549318, -122.435623560602) 13 9 1 29490 27
14326 112045 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Front Yard : Yard Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 785474 6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226) 13 9 1 29490 27
2469 260495 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014820 2116826 37.7932334067411 -122.392656317548 (37.7932334067411, -122.392656317548) 12 2 9 28855 6
3271 260494 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014820 2116826 37.7932334067411 -122.392656317548 (37.7932334067411, -122.392656317548) 12 2 9 28855 6
8039 260496 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014820 2116826 37.7932334067411 -122.392656317548 (37.7932334067411, -122.392656317548) 12 2 9 28855 6
163341 137046 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1149 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6008987.23365 2116902.13898 37.7931168002562 -122.412843528313 (37.7931168002562, -122.412843528313) 5 1 10 28857 21
155952 137047 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1360 Clay St 2 Sidewalk: Curb side : Pot Tree Private 2     13 Width 3ft   6008168.86514 2116916.33428 37.7931098080181 -122.415676146347 (37.7931098080181, -122.415676146347) 5 1 10 28858 21
27935 253392 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
70032 253393 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
183902 253394 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
126471 137011 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2920 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   5999664.75657 2117066.45447 37.7930402850302 -122.445111563071 (37.7930402850302, -122.445111563071) 13 9 1 57 27
84435 137012 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2920 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   5999646.08574 2117066.27924 37.7930387382068 -122.445176152363 (37.7930387382068, -122.445176152363) 13 9 1 57 27
187100 137013 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2920 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   5999627.95657 2117064.96637 37.7930340986073 -122.445238785654 (37.7930340986073, -122.445238785654) 13 9 1 57 27
18245 66733 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1133 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/06/1991 12:00:00 AM     Permit Number 29980 6008997 2116859 37.7929988993441 -122.41280668477 (37.7929988993441, -122.41280668477) 5 1 10 28857 21
174564 137037 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1034 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009816.75031 2116820.89237 37.7929402426503 -122.409967600744 (37.7929402426503, -122.409967600744) 3 1 10 28857 21
169533 137038 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1034 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009796.46818 2116817.71138 37.7929303716781 -122.410037553588 (37.7929303716781, -122.410037553588) 3 1 10 28857 21
147272 137039 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1034 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009772.70737 2116813.88249 37.7929185267084 -122.410119497111 (37.7929185267084, -122.410119497111) 3 1 10 28857 21
15181 137040 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1034 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2020 12:00:00 AM 3 Width 3ft   6009716.37448 2116806.11676 37.7928940462749 -122.410313864011 (37.7928940462749, -122.410313864011) 3 1 10 28857 21
96 137041 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1034 Sacramento St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2020 12:00:00 AM 3 Width 3ft   6009697.84819 2116804.05029 37.7928873337267 -122.410377820179 (37.7928873337267, -122.410377820179) 3 1 10 28857 21
121496 53398 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1221 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1972 12:00:00 AM 9   Permit Number 9833 6008515.21769 2116802.84208 37.7928176497632 -122.414469707612 (37.7928176497632, -122.414469707612) 5 1 10 28858 21
181351 137048 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1221 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008515.8047 2116792.05002 37.7927880503911 -122.414466912531 (37.7927880503911, -122.414466912531) 5 1 10 28858 21

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);