trees
6,714 rows where qSpecies_id = 7 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145919 | 49811 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 820 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 6 | Permit Number 46603 | 6015361.63713 | 2103953.42579 | 37.7579182481496 | -122.389882619693 | (37.7579182481496, -122.389882619693) | 10 | 3 | 8 | 28856 | 29 | |
153424 | 38586 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1601 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 5 | Permit Number 40543 | 6015170.391 | 2094645.6065 | 37.7323503039144 | -122.389893876253 | (37.7323503039144, -122.389893876253) | 10 | 3 | 8 | 58 | 1 | |
39721 | 38587 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1601 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40543 | 6015156.0012 | 2094654.7636 | 37.7323746494327 | -122.38994426497 | (37.7323746494327, -122.38994426497) | 10 | 3 | 8 | 58 | 1 | |
74001 | 200024 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1624 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015148.4453 | 2094513.8756 | 37.7319873803768 | -122.389960549589 | (37.7319873803768, -122.389960549589) | 10 | 3 | 8 | 58 | 1 | |||
30039 | 196194 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 87 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015403.39344 | 2112238.08548 | 37.7806684231409 | -122.390317027303 | (37.7806684231409, -122.390317027303) | 6 | 2 | 9 | 28856 | 20 | |||
160564 | 196091 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 972 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015230.48964 | 2104060.4129 | 37.7582047379774 | -122.390343661653 | (37.7582047379774, -122.390343661653) | 10 | 3 | 8 | 28856 | 29 | |||
20902 | 57075 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 972 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 10 | Permit Number 14342 | 6015229.87754 | 2104071.31623 | 37.7582346422339 | -122.39034654037 | (37.7582346422339, -122.39034654037) | 10 | 3 | 8 | 28856 | 29 | ||
48070 | 67680 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1523 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 7 | Permit Number 31284 | 6014960.4779 | 2093407.781 | 37.7289398410715 | -122.390533137865 | (37.7289398410715, -122.390533137865) | 10 | 3 | 8 | 58 | 1 | |
10588 | 82677 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1627 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014950.6191 | 2094457.8846 | 37.7318226671335 | -122.390640571691 | (37.7318226671335, -122.390640571691) | 10 | 3 | 8 | 58 | 1 | |||
80673 | 67679 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1539 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31283 | 6014892.62692915 | 2093462.84742446 | 37.7290872780734 | -122.390771552273 | (37.7290872780734, -122.390771552273) | 10 | 3 | 8 | 58 | 1 | ||
66115 | 196280 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 11 | : Yard | Tree | Private 2 | 12 | 6015022.69172 | 2102195.1938 | 37.7530717153135 | -122.390931963945 | (37.7530717153135, -122.390931963945) | 10 | 3 | 8 | 28856 | 29 | ||||
143668 | 196281 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 12 | : Yard | Tree | Private 2 | 12 | 6015018.37236 | 2102200.19302 | 37.7530852024401 | -122.390947250631 | (37.7530852024401, -122.390947250631) | 10 | 3 | 8 | 28856 | 29 | ||||
259 | 196282 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 13 | : Yard | Tree | Private 2 | 12 | 6015015.25562 | 2102205.64875 | 37.7531000097757 | -122.390958410295 | (37.7531000097757, -122.390958410295) | 10 | 3 | 8 | 28856 | 29 | ||||
40766 | 42068 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100X Ripley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42381 | 6015269 | 2115673 | 37.7900924610766 | -122.391022110897 | (37.7900924610766, -122.391022110897) | 6 | 2 | 9 | 28855 | 6 |
151424 | 196072 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 4 | : Yard | Tree | Private 2 | 6 | 6014990.91174 | 2102121.65719 | 37.7528680359305 | -122.391036726872 | (37.7528680359305, -122.391036726872) | 10 | 3 | 8 | 28856 | 29 | ||||
26654 | 196279 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 6 | : Yard | Tree | Private 2 | 5 | 6014984.46572 | 2102135.07494 | 37.7529045205317 | -122.391059956347 | (37.7529045205317, -122.391059956347) | 10 | 3 | 8 | 28856 | 29 | ||||
18883 | 196073 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 5 | : Yard | Tree | Private 2 | 9 | 6014983.58057 | 2102134.91171 | 37.7529040232186 | -122.391063005979 | (37.7529040232186, -122.391063005979) | 10 | 3 | 8 | 28856 | 29 | ||||
37427 | 39264 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 540 Delancey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015215.52427 | 2113624.42786 | 37.7844645829043 | -122.391063889106 | (37.7844645829043, -122.391063889106) | 6 | 2 | 9 | 28856 | 6 |
96248 | 196074 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 7 | : Yard | Tree | Private 2 | 8 | 6014974.36324 | 2102149.68411 | 37.7529440736099 | -122.391095913948 | (37.7529440736099, -122.391095913948) | 10 | 3 | 8 | 28856 | 29 | ||||
20145 | 196076 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 18 | : Yard | Tree | Private 2 | 6 | 6014971.87416 | 2102223.03647 | 37.7531453455068 | -122.391109648404 | (37.7531453455068, -122.391109648404) | 10 | 3 | 8 | 28856 | 29 | ||||
108608 | 39266 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 540 Delancey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015200.60575 | 2113640.87265 | 37.784508908704 | -122.391116652331 | (37.784508908704, -122.391116652331) | 6 | 2 | 9 | 28856 | 6 |
53577 | 196075 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 17 | : Yard | Tree | Private 2 | 6 | 6014963.46919 | 2102214.24517 | 37.7531207400437 | -122.391138100256 | (37.7531207400437, -122.391138100256) | 10 | 3 | 8 | 28856 | 29 | ||||
157955 | 196077 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 19 | : Yard | Tree | Private 2 | 6 | 6014960.28506 | 2102234.79181 | 37.7531769800583 | -122.391150547759 | (37.7531769800583, -122.391150547759) | 10 | 3 | 8 | 28856 | 29 | ||||
125480 | 39265 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 540 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015189.33432 | 2113651.1602 | 37.78453653049 | -122.391156367288 | (37.78453653049, -122.391156367288) | 6 | 2 | 9 | 28856 | 6 |
25551 | 49513 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1648@3rd ST Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2003 12:00:00 AM | Permit Number 46418 | 6014785.81315318 | 2094304.60337815 | 37.7313926432313 | -122.391199634158 | (37.7313926432313, -122.391199634158) | 10 | 3 | 8 | 58 | 1 | |||
89576 | 26008 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1625 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6014811.10476 | 2095618.36202 | 37.7350013613099 | -122.391203993568 | (37.7350013613099, -122.391203993568) | 10 | 3 | 8 | 58 | 1 | |||
185798 | 82979 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1175 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52488 | 6014632.4876 | 2090162.3488 | 37.7200103300667 | -122.391440240364 | (37.7200103300667, -122.391440240364) | 10 | 3 | 8 | 58 | 1 | |
28216 | 30766 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1595 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 6 | Permit Number 34647 | 6014606.5276 | 2093671.0453 | 37.7296430696457 | -122.391775180038 | (37.7296430696457, -122.391775180038) | 10 | 3 | 8 | 58 | 1 | |
113034 | 40011 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50722 | 6014429.18041 | 2094668.89271 | 37.7323731097309 | -122.392458061291 | (37.7323731097309, -122.392458061291) | 10 | 3 | 8 | 58 | 1 | |
46839 | 40018 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Latona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50722 | 6014428.09341 | 2094657.08868 | 37.7323406379015 | -122.392460993976 | (37.7323406379015, -122.392460993976) | 10 | 3 | 8 | 58 | 1 | |
122201 | 40014 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25X Bay View St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50722 | 6014394.45523 | 2094706.73166 | 37.7324750793504 | -122.392580761188 | (37.7324750793504, -122.392580761188) | 10 | 3 | 8 | 58 | 1 | |
152728 | 40015 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25 Bay View St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | 6 | Permit Number 41263 | 6014358.79544 | 2094713.56098 | 37.7324918508025 | -122.39270452409 | (37.7324918508025, -122.39270452409) | 10 | 3 | 8 | 58 | 1 | ||
119896 | 39694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1770 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | 8 | Permit Number 41079 | 6014361.02925 | 2095331.76998 | 37.7341894506734 | -122.392740033843 | (37.7341894506734, -122.392740033843) | 10 | 3 | 8 | 58 | 1 | |
51966 | 40016 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25X Bay View St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50722 | 6014347.1001 | 2094717.00207 | 37.7325006497719 | -122.392745198625 | (37.7325006497719, -122.392745198625) | 10 | 3 | 8 | 58 | 1 | |
164711 | 50301 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3212 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | Permit Number 47011 | 6014135.02682875 | 2089827.85867998 | 37.7190642634607 | -122.393136412697 | (37.7190642634607, -122.393136412697) | 10 | 3 | 8 | 58 | 1 | ||
126867 | 196107 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 559 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6014419.73249 | 2104517.48217 | 37.7594147452193 | -122.393179616148 | (37.7594147452193, -122.393179616148) | 10 | 3 | 8 | 28856 | 29 | |||
177233 | 196108 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 553 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6014419.65969 | 2104542.9303 | 37.7594846162341 | -122.393181648629 | (37.7594846162341, -122.393181648629) | 10 | 3 | 8 | 28856 | 29 | |||
174831 | 196092 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 01st St | 24 | : Yard | Tree | Private 2 | 10 | 6014425.82588 | 2105887.05023 | 37.7631756200823 | -122.393254379501 | (37.7631756200823, -122.393254379501) | 14 | 3 | 8 | 28856 | 29 | ||||
65215 | 67661 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 33 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 5 | Permit Number 31262 | 6014174.7724 | 2093920.80707 | 37.7303048875537 | -122.393285285582 | (37.7303048875537, -122.393285285582) | 10 | 3 | 8 | 58 | 1 | |
6715 | 67660 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 37 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 6 | Permit Number 31261 | 6014167.43331 | 2093890.78969 | 37.7302220581813 | -122.393308558267 | (37.7302220581813, -122.393308558267) | 10 | 3 | 8 | 58 | 1 | |
114568 | 196093 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 01st St | 25 | : Yard | Tree | Private 2 | 8 | 6014406.11466 | 2105887.9731 | 37.763177058994 | -122.393322619136 | (37.763177058994, -122.393322619136) | 14 | 3 | 8 | 28856 | 29 | ||||
163347 | 196189 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 49 Lucy St | 2 | : | Tree | Private 2 | 8 | Width 4ft | 6014162.43629 | 2093869.58355 | 37.7301635528011 | -122.393324350359 | (37.7301635528011, -122.393324350359) | 10 | 3 | 8 | 58 | 1 | |||
120328 | 67653 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 27 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 7 | Permit Number 31252 | 6014173.95689 | 2094523.3573 | 37.7319593226536 | -122.393330254407 | (37.7319593226536, -122.393330254407) | 10 | 3 | 8 | 58 | 1 | |
28429 | 67658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 49 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 7 | Permit Number 31259 | 6014158.60184 | 2093846.43818 | 37.7300997872766 | -122.39333598759 | (37.7300997872766, -122.39333598759) | 10 | 3 | 8 | 58 | 1 | |
143352 | 196094 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 01st St | 26 | : Yard | Tree | Private 2 | 8 | 6014400.8809 | 2105882.83985 | 37.7631626734333 | -122.393340361863 | (37.7631626734333, -122.393340361863) | 14 | 3 | 8 | 28856 | 29 | ||||
147774 | 67652 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 41 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 8 | Permit Number 31251 | 6014164.92937 | 2094480.71091 | 37.7318417227986 | -122.393358481407 | (37.7318417227986, -122.393358481407) | 10 | 3 | 8 | 58 | 1 | |
180627 | 67672 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1777 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31275 | 6014169.61511167 | 2095049.17888581 | 37.7334028801998 | -122.393382048969 | (37.7334028801998, -122.393382048969) | 10 | 3 | 8 | 58 | 1 | ||
77559 | 67659 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 44 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 9 | Permit Number 31260 | 6014110.85725 | 2093863.20548 | 37.7301431741556 | -122.393502220965 | (37.7301431741556, -122.393502220965) | 10 | 3 | 8 | 58 | 1 | |
41547 | 87176 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1784 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50145 | 6014123.92226 | 2095138.61734 | 37.7336459211168 | -122.393546280538 | (37.7336459211168, -122.393546280538) | 10 | 3 | 8 | 58 | 1 | |
7792 | 81654 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6014140.03196 | 2096118.29222 | 37.7363368024053 | -122.393559125566 | (37.7363368024053, -122.393559125566) | 10 | 3 | 8 | 58 | 1 | |||
154185 | 25996 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6014137.90687 | 2096120.20835 | 37.7363419456235 | -122.393566607009 | (37.7363419456235, -122.393566607009) | 10 | 3 | 8 | 58 | 1 | ||
20174 | 49363 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1875@ EVANS Marin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2003 12:00:00 AM | 3 | Permit Number 46338 | 6014150.89902 | 2100527.87809 | 37.748445208788 | -122.39383011827 | (37.748445208788, -122.39383011827) | 10 | 3 | 8 | 58 | 1 | ||
55418 | 46463 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 31 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | 8 | Permit Number 44667 | 6013974.32308 | 2095449.03509 | 37.7344899510581 | -122.394085216368 | (37.7344899510581, -122.394085216368) | 10 | 3 | 8 | 58 | 1 | ||
139479 | 196191 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1700 Armstrong Ave | 4 | Side Yard : Yard | Tree | Private 2 | 11 | 6013892.03543 | 2092881.84794 | 37.7274364045408 | -122.39419004313 | (37.7274364045408, -122.39419004313) | 10 | 3 | 8 | 58 | 1 | ||||
137949 | 196190 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 39 Ceres St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013905.10394 | 2093942.74194 | 37.7303501306396 | -122.39421910833 | (37.7303501306396, -122.39421910833) | 10 | 3 | 8 | 58 | 1 | |||
134770 | 117619 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 5700 03RD ST | 1 | Front Yard : Yard | Tree | Private 2 | 6013866 | 2092333 | 37.7259279317454 | -122.394241638465 | (37.7259279317454, -122.394241638465) | 10 | 3 | 8 | 58 | 1 | |||||
53779 | 114494 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 322 Ritch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014223.46606 | 2111741.73077 | 37.7792400254408 | -122.394364230131 | (37.7792400254408, -122.394364230131) | 6 | 2 | 9 | 28856 | 34 | |||
9 | 32966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 556 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/2020 12:00:00 AM | 3 | Permit Number 37281 | 6014072.59224 | 2104507.52941 | 37.759368126158 | -122.394379509632 | (37.759368126158, -122.394379509632) | 10 | 3 | 8 | 28856 | 29 | |
192578 | 114493 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 322 Ritch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014211.87183 | 2111751.31287 | 37.7792656912091 | -122.394405010779 | (37.7792656912091, -122.394405010779) | 6 | 2 | 9 | 28856 | 34 | |||
168318 | 32963 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 534 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 7 | Permit Number 37278 | 6014065.51367 | 2104636.52078 | 37.7597219149616 | -122.394413022839 | (37.7597219149616, -122.394413022839) | 10 | 3 | 8 | 28856 | 29 | |
175947 | 114492 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 322 Ritch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 1 | 3x3 | Permit Number 777002 | 6014200.75816 | 2111763.05938 | 37.7792973266569 | -122.394444280578 | (37.7792973266569, -122.394444280578) | 6 | 2 | 9 | 28856 | 34 | |
84383 | 196156 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 418 Mississippi St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6014038.63136 | 2105124.6384 | 37.7610606853181 | -122.39454017619 | (37.7610606853181, -122.39454017619) | 10 | 3 | 8 | 28856 | 29 | |||
113448 | 196157 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 422 Mississippi St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014037.08737 | 2105100.22653 | 37.7609935698072 | -122.394543806767 | (37.7609935698072, -122.394543806767) | 10 | 3 | 8 | 28856 | 29 | |||
21685 | 196155 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 418 Mississippi St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014037.44823 | 2105136.58178 | 37.7610934134625 | -122.394545104498 | (37.7610934134625, -122.394545104498) | 10 | 3 | 8 | 28856 | 29 | |||
143159 | 196110 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 233 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6014050.95059 | 2105936.57906 | 37.7632907818606 | -122.394554425942 | (37.7632907818606, -122.394554425942) | 14 | 3 | 8 | 28856 | 29 | |||
1550 | 201970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 21 | : | Tree | Private 2 | 3 | Width 3ft | 6013765.00423 | 2092206.62002 | 37.7255753034535 | -122.39458193082 | (37.7255753034535, -122.39458193082) | 10 | 3 | 8 | 58 | 1 | |||
50075 | 196300 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25 Stillman St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014184.73952 | 2113142.03031 | 37.7830827763816 | -122.3945962858 | (37.7830827763816, -122.3945962858) | 6 | 2 | 9 | 28856 | 6 | |||
29530 | 201971 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6013754.58016 | 2092201.85922 | 37.7255616517262 | -122.394617632995 | (37.7255616517262, -122.394617632995) | 10 | 3 | 8 | 58 | 1 | ||||
124562 | 201972 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 19 | : | Tree | Private 2 | 3 | Width 3ft | 6013746.1142 | 2092220.94334 | 37.7256135821948 | -122.394648235135 | (37.7256135821948, -122.394648235135) | 10 | 3 | 8 | 58 | 1 | |||
139747 | 196299 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25 Stillman St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6014168.1975 | 2113125.45849 | 37.7830363542897 | -122.394652354018 | (37.7830363542897, -122.394652354018) | 6 | 2 | 9 | 28856 | 6 | |||
183040 | 201973 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013730.31809 | 2092219.82075 | 37.7256096215628 | -122.39470276282 | (37.7256096215628, -122.39470276282) | 10 | 3 | 8 | 58 | 1 | ||||
89036 | 201974 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 17 | : | Tree | Private 2 | 4 | Width 3ft | 6013727.10603 | 2092236.0738 | 37.7256540705737 | -122.39471500442 | (37.7256540705737, -122.39471500442) | 10 | 3 | 8 | 58 | 1 | |||
150546 | 196263 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1059 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6013674.30393 | 2089830.73604 | 37.7190465590346 | -122.394729166931 | (37.7190465590346, -122.394729166931) | 10 | 3 | 8 | 58 | 1 | ||||
67311 | 201975 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013711.44714 | 2092234.27571 | 37.7256482627537 | -122.394769010484 | (37.7256482627537, -122.394769010484) | 10 | 3 | 8 | 58 | 1 | ||||
55481 | 201976 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 15 | : | Tree | Private 2 | 5 | Width 3ft | 6013710.28394 | 2092247.91618 | 37.7256856520577 | -122.394773986446 | (37.7256856520577, -122.394773986446) | 10 | 3 | 8 | 58 | 1 | |||
181772 | 201977 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 14 | : | Tree | Private 2 | 5 | Width 4ft | 6013690.41157 | 2092261.69641 | 37.7257223848541 | -122.394843648839 | (37.7257223848541, -122.394843648839) | 10 | 3 | 8 | 58 | 1 | |||
86407 | 201978 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6013680.98178 | 2092258.06513 | 37.7257118897673 | -122.394875992933 | (37.7257118897673, -122.394875992933) | 10 | 3 | 8 | 58 | 1 | ||||
59593 | 201941 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6013681.12245 | 2092335.8479 | 37.7259254733716 | -122.394880951809 | (37.7259254733716, -122.394880951809) | 10 | 3 | 8 | 58 | 1 | |||
87756 | 201979 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 12 | : | Tree | Private 2 | 3 | Width 3ft | 6013673.65636 | 2092275.41387 | 37.7257591185834 | -122.394902531039 | (37.7257591185834, -122.394902531039) | 10 | 3 | 8 | 58 | 1 | |||
170915 | 201942 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 8 | : | Tree | Private 2 | 2 | Width 3ft | 6013661.36989 | 2092347.25444 | 37.7259556950922 | -122.394950034125 | (37.7259556950922, -122.394950034125) | 10 | 3 | 8 | 58 | 1 | |||
23047 | 256727 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
57423 | 256728 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
72224 | 256730 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
81173 | 256733 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
98052 | 256726 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
153380 | 256729 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
158257 | 256731 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
178281 | 256732 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
138155 | 201943 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6013641.01292 | 2092357.44861 | 37.7259825542392 | -122.39502112104 | (37.7259825542392, -122.39502112104) | 10 | 3 | 8 | 58 | 1 | |||
108570 | 201982 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6013638.14457 | 2092296.94833 | 37.7258162731896 | -122.395026801165 | (37.7258162731896, -122.395026801165) | 10 | 3 | 8 | 58 | 1 | |||
60661 | 30774 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 548 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 4 | 4.5x12 | Permit Number 34652 | 6014028.90307 | 2112230.33243 | 37.7805707972354 | -122.395071541515 | (37.7805707972354, -122.395071541515) | 6 | 2 | 9 | 28856 | 34 |
100659 | 56520 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 609 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 9 | Permit Number 31878 | 6013865.39943 | 2104246.99962 | 37.7586412482196 | -122.395077840386 | (37.7586412482196, -122.395077840386) | 10 | 3 | 8 | 28856 | 29 | |
186235 | 68128 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 607 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 10 | Permit Number 31879 | 6013862.47141 | 2104272.49707 | 37.7587110958561 | -122.395089752816 | (37.7587110958561, -122.395089752816) | 10 | 3 | 8 | 28856 | 29 | |
99574 | 201944 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 10 | : | Tree | Private 2 | 2 | Width 3ft | 6013619.17874 | 2092369.08927 | 37.7260133029649 | -122.395097415939 | (37.7260133029649, -122.395097415939) | 10 | 3 | 8 | 58 | 1 | |||
114173 | 201983 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 8 | : | Tree | Private 2 | 2 | Width 3ft | 6013616.63963 | 2092305.22026 | 37.7258377903696 | -122.395101721872 | (37.7258377903696, -122.395101721872) | 10 | 3 | 8 | 58 | 1 | |||
53147 | 201984 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6013594.77768 | 2092310.70039 | 37.7258516219291 | -122.395177681321 | (37.7258516219291, -122.395177681321) | 10 | 3 | 8 | 58 | 1 | |||
128989 | 200490 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1088 Jamestown Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 6013545.6611 | 2089994.9439 | 37.7194902878281 | -122.39518533478 | (37.7194902878281, -122.39518533478) | 10 | 3 | 8 | 58 | 1 | |||
50673 | 201945 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 12 | : | Tree | Private 2 | 2 | Width 3ft | 6013588.62557 | 2092382.18651 | 37.7260475662288 | -122.395203954116 | (37.7260475662288, -122.395203954116) | 10 | 3 | 8 | 58 | 1 | |||
150980 | 113584 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 1828 NEWHALL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013636 | 2094731 | 37.732499564412 | -122.395204639391 | (37.732499564412, -122.395204639391) | 10 | 3 | 8 | 58 | 1 | ||||
180328 | 119264 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1243 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013843.66164 | 2105220.96082 | 37.7613143247043 | -122.395221244488 | (37.7613143247043, -122.395221244488) | 10 | 3 | 8 | 28856 | 29 |
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) );