trees
467 rows where Police Districts = 7 and qSpecies_id = 8 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194416 | 179075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2017 08:37:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
194407 | 265071 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 430 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000887 | 2092304 | 37.7251183251209 | -122.439106989741 | (37.7251183251209, -122.439106989741) | 9 | 7 | 6 | 28861 | 25 | ||||
192873 | 45557 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2001 12:00:00 AM | Permit Number 44428 | 6003953.11185898 | 2099806.69128577 | 37.7458930039208 | -122.429042450873 | (37.7458930039208, -122.429042450873) | 2 | 7 | 5 | 63 | 22 | |||
192858 | 176227 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001457.22396 | 2089001.68524 | 37.7160833414588 | -122.436899487435 | (37.7160833414588, -122.436899487435) | 9 | 7 | 6 | 28861 | 5 | |||
192617 | 223653 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 360 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003566.55526 | 2095262.2275 | 37.7333930596415 | -122.430054982967 | (37.7333930596415, -122.430054982967) | 2 | 7 | 5 | 28861 | 25 | |||
191832 | 5105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2638 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/2002 12:00:00 AM | 3 | 3X3 | 6002275.8937 | 2096498.71459 | 37.7367149871144 | -122.434605539024 | (37.7367149871144, -122.434605539024) | 2 | 7 | 5 | 63 | 7 | ||
191582 | 87901 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50919 | 6007188 | 2097721 | 37.7403487442124 | -122.417708821494 | (37.7403487442124, -122.417708821494) | 2 | 7 | 7 | 28859 | 2 | ||
191267 | 64261 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 164 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25063 | 6009942.27368722 | 2100102.27070153 | 37.7470418016369 | -122.408353511002 | (37.7470418016369, -122.408353511002) | 2 | 7 | 7 | 28859 | 2 | ||
190107 | 161124 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781528 | 6003266.33968 | 2090358.66738 | 37.7199119739285 | -122.430743107307 | (37.7199119739285, -122.430743107307) | 9 | 7 | 6 | 28861 | 5 | |
190056 | 49867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.7334093561858 | -122.430016351279 | (37.7334093561858, -122.430016351279) | 2 | 7 | 5 | 28861 | 25 | ||
189482 | 97895 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 375X Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
189239 | 63459 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 147 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1987 12:00:00 AM | Permit Number 24050 | 6006045.33301804 | 2095867.39473231 | 37.7351947901182 | -122.421528105477 | (37.7351947901182, -122.421528105477) | 2 | 7 | 7 | 28859 | 2 | ||
187784 | 176245 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011861.55971 | 2090354.44953 | 37.7203836161938 | -122.401031937775 | (37.7203836161938, -122.401031937775) | 10 | 7 | 8 | 309 | 28 | |||
186402 | 66454 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29604 | 6009026.99951004 | 2097886.74358701 | 37.7409071549012 | -122.411361972152 | (37.7409071549012, -122.411361972152) | 10 | 7 | 7 | 28859 | 2 | ||
186256 | 176231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 670 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001253.10056 | 2089784.48632 | 37.7182211342895 | -122.437661063033 | (37.7182211342895, -122.437661063033) | 9 | 7 | 6 | 28861 | 5 | |||
185311 | 58274 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 679 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 11 | Permit Number 28518 | 6002069.69674 | 2089980.14992 | 37.7188047799052 | -122.434852426303 | (37.7188047799052, -122.434852426303) | 9 | 7 | 6 | 28861 | 5 | |
184595 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 100x OGDEN AVE | 4 | Back Yard : Yard | Tree | Private 2 | 6007659 | 2096105 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | 2 | 7 | 7 | 28859 | 2 | |||||
184438 | 62674 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 391 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31517 | 6003426.2105163 | 2098608.75328602 | 37.7425739041197 | -122.430778928831 | (37.7425739041197, -122.430778928831) | 2 | 7 | 5 | 63 | 22 | ||
184359 | 49493 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
184301 | 4333 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 5X Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001761.4698131 | 2095822.8308427 | 37.7348299498779 | -122.436335765698 | (37.7348299498779, -122.436335765698) | 2 | 7 | 5 | 63 | 7 | |||
184145 | 45300 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44138 | 6007485.11382992 | 2096559.26498899 | 37.7371755914125 | -122.416599241748 | (37.7371755914125, -122.416599241748) | 2 | 7 | 7 | 28859 | 2 | ||
182996 | 31016 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.7119506311233 | -122.437892574784 | (37.7119506311233, -122.437892574784) | 9 | 7 | 6 | 28861 | 5 | |||
181745 | 49495 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 9 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
181431 | 95766 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 200 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767501 | 6004737 | 2091251 | 37.7224453364084 | -122.425723020763 | (37.7224453364084, -122.425723020763) | 9 | 7 | 6 | 28861 | 5 | |
181410 | 34892 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
181103 | 83378 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 586 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52310 | 6003277.11077 | 2089949.83191 | 37.7187900121188 | -122.430676716663 | (37.7187900121188, -122.430676716663) | 9 | 7 | 6 | 28861 | 5 | |
180915 | 45298 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44138 | 6007485.11382992 | 2096559.26498899 | 37.7371755914125 | -122.416599241748 | (37.7371755914125, -122.416599241748) | 2 | 7 | 7 | 28859 | 2 | ||
180100 | 223574 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007417.99776 | 2097972.40072 | 37.7410519748757 | -122.416931385896 | (37.7410519748757, -122.416931385896) | 2 | 7 | 7 | 28859 | 2 | |||
179878 | 63368 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1987 12:00:00 AM | Permit Number 23946 | 6007413.89798524 | 2095700.92669416 | 37.7348147774413 | -122.416784676409 | (37.7348147774413, -122.416784676409) | 2 | 7 | 7 | 28859 | 2 | ||
179872 | 64120 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | 12 | Permit Number 24891 | 6003817.65498965 | 2099560.57193818 | 37.745209548627 | -122.42949329292 | (37.745209548627, -122.42949329292) | 2 | 7 | 5 | 63 | 22 | |
179534 | 63374 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 355 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23954 | 6007173.36790377 | 2095773.19407167 | 37.7349996759488 | -122.417621394563 | (37.7349996759488, -122.417621394563) | 2 | 7 | 7 | 28859 | 2 | ||
179470 | 207589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 451 Hearst Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998517.2369 | 2094367.8013 | 37.7306499124478 | -122.447447460328 | (37.7306499124478, -122.447447460328) | 9 | 7 | 4 | 28861 | 40 | |||
179323 | 159293 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 486 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:16:00 AM | 3 | Width 0ft | 5998231.36405 | 2087340.7209 | 37.7113388384862 | -122.447930029355 | (37.7113388384862, -122.447930029355) | 9 | 7 | 6 | 28861 | 25 | ||
179288 | 180663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.7091162701556 | -122.433514058849 | (37.7091162701556, -122.433514058849) | 9 | 7 | 6 | 28861 | 5 | ||
178873 | 63344 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 420 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1987 12:00:00 AM | Permit Number 23918 | 6009445.61532171 | 2100209.13086816 | 37.7473073913184 | -122.410078463277 | (37.7473073913184, -122.410078463277) | 2 | 7 | 7 | 28859 | 2 | ||
178849 | 252855 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 926 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001578 | 2088750 | 37.7153991335272 | -122.43646402536 | (37.7153991335272, -122.43646402536) | 9 | 7 | 6 | 28861 | 5 | ||||
178350 | 63376 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 323 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23956 | 6007022.17725354 | 2095785.81975129 | 37.7350258345142 | -122.418145010299 | (37.7350258345142, -122.418145010299) | 2 | 7 | 7 | 28859 | 2 | ||
178312 | 32500 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 738 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 4 | Permit Number 37005 | 6007353.28943 | 2095467.09661 | 37.7341693220512 | -122.416977659594 | (37.7341693220512, -122.416977659594) | 2 | 7 | 7 | 28859 | 2 | |
178064 | 251779 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1207 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:23:00 AM | 3 | 3x3 | 6001136 | 2087356 | 37.7115463934242 | -122.437891982586 | (37.7115463934242, -122.437891982586) | 9 | 7 | 6 | 28861 | 5 | ||
177617 | 63319 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 418 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23886 | 6009434.58955214 | 2100208.53017763 | 37.7473051239614 | -122.410116547341 | (37.7473051239614, -122.410116547341) | 2 | 7 | 7 | 28859 | 2 | ||
177363 | 44431 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 Prague St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2017 11:19:00 AM | 3 | Permit Number 43768 | 6002228.37284 | 2086951.06128 | 37.7104965784279 | -122.434087529513 | (37.7104965784279, -122.434087529513) | 9 | 7 | 6 | 28861 | 5 | |
176611 | 223543 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 558 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003065.83042 | 2096030.39341 | 37.735473896589 | -122.431840957411 | (37.735473896589, -122.431840957411) | 2 | 7 | 5 | 63 | 7 | |||
176334 | 65612 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 676 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 12 | Permit Number 28517 | 6002045.90134 | 2090021.05349 | 37.7189157409448 | -122.434937601102 | (37.7189157409448, -122.434937601102) | 9 | 7 | 6 | 28861 | 5 | |
176065 | 176235 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 19 Brunswick St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6001042.78255 | 2087493.58621 | 37.7119188733302 | -122.438224016125 | (37.7119188733302, -122.438224016125) | 9 | 7 | 6 | 28861 | 5 | |||
175482 | 49494 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
175322 | 63375 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 350 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23955 | 6007139.10410586 | 2095723.87438281 | 37.7348623268067 | -122.417736362263 | (37.7348623268067, -122.417736362263) | 2 | 7 | 7 | 28859 | 2 | ||
174537 | 207704 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5997711.57572 | 2094740.62548 | 37.7316275258898 | -122.450259604396 | (37.7316275258898, -122.450259604396) | 9 | 7 | 4 | 59 | 40 | |||
174449 | 223419 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 402 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009048.42055 | 2100050.37834 | 37.7468492215202 | -122.411440725326 | (37.7468492215202, -122.411440725326) | 2 | 7 | 7 | 28859 | 2 | |||
174137 | 63392 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23974 | 6007409.67653099 | 2095518.22353368 | 37.7343128771184 | -122.416786331963 | (37.7343128771184, -122.416786331963) | 2 | 7 | 7 | 28859 | 2 | ||
173282 | 223533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 53 Newburg St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | Width 10ft | 6002432.22452 | 2099844.06913 | 37.7459094263876 | -122.434304133936 | (37.7459094263876, -122.434304133936) | 2 | 7 | 5 | 63 | 22 | |||
172148 | 176238 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2018 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012153.04029 | 2088061.68652 | 37.7141044057814 | -122.399863463036 | (37.7141044057814, -122.399863463036) | 10 | 7 | 8 | 309 | 39 | |||
172131 | 176254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011871.08574 | 2089770.57713 | 37.7187809523661 | -122.400958007209 | (37.7187809523661, -122.400958007209) | 10 | 7 | 8 | 309 | 39 | |||
172061 | 207703 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6000991.68804 | 2094917.78379 | 37.7323011315777 | -122.438932323977 | (37.7323011315777, -122.438932323977) | 9 | 7 | 4 | 63 | 40 | |||
172015 | 223566 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 144 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6009026.08799 | 2097793.63743 | 37.7406514546128 | -122.411358547973 | (37.7406514546128, -122.411358547973) | 10 | 7 | 7 | 28859 | 2 | |||
170398 | 246489 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Duncan St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6004042.8614 | 2099814.35756 | 37.745919133669 | -122.428732655803 | (37.745919133669, -122.428732655803) | 2 | 7 | 5 | 63 | 22 | |||
170286 | 160563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 750 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:34:00 PM | 3 | Width 0ft | Permit Number 47139 | 6002231.24921 | 2089300.0903 | 37.7169466582377 | -122.434245412715 | (37.7169466582377, -122.434245412715) | 9 | 7 | 6 | 28861 | 5 |
170210 | 176249 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012088.82637 | 2089370.3173 | 37.7176940632127 | -122.400177264384 | (37.7176940632127, -122.400177264384) | 10 | 7 | 8 | 309 | 39 | ||
170037 | 223415 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009521.39447 | 2099607.71888 | 37.7456602935022 | -122.409773978512 | (37.7456602935022, -122.409773978512) | 2 | 7 | 7 | 28859 | 2 | |||
168956 | 87915 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 493 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50937 | 6007865 | 2096582 | 37.7372593745364 | -122.415287407139 | (37.7372593745364, -122.415287407139) | 2 | 7 | 7 | 28859 | 2 | ||
168842 | 223445 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6003784.31175 | 2099553.81383 | 37.7451891045094 | -122.429608106246 | (37.7451891045094, -122.429608106246) | 2 | 7 | 5 | 63 | 22 | |||
168831 | 223473 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 260 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6006678.29672 | 2095767.02591 | 37.7349548690689 | -122.419332597342 | (37.7349548690689, -122.419332597342) | 2 | 7 | 7 | 28859 | 2 | |||
168353 | 180626 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6002802.39914 | 2087193.02957 | 37.7111935323316 | -122.432120840807 | (37.7111935323316, -122.432120840807) | 9 | 7 | 6 | 28861 | 5 | |||
168221 | 64250 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 665 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25048 | 6002286.59850584 | 2098838.14561874 | 37.7431391293174 | -122.434735768073 | (37.7431391293174, -122.434735768073) | 2 | 7 | 5 | 63 | 7 | ||
168190 | 223423 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 352 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008776.78934 | 2100032.92411 | 37.7467860567247 | -122.412378770366 | (37.7467860567247, -122.412378770366) | 2 | 7 | 7 | 28859 | 2 | |||
167942 | 28261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3574 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 6012138.7194258 | 2089093.5243211 | 37.7169368272436 | -122.399985378545 | (37.7169368272436, -122.399985378545) | 10 | 7 | 8 | 309 | 39 | ||
167343 | 96926 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.7334451019942 | -122.429455740482 | (37.7334451019942, -122.429455740482) | 2 | 7 | 5 | 28861 | 25 | ||
166764 | 96201 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.71535722204 | -122.399324379639 | (37.71535722204, -122.399324379639) | 10 | 7 | 8 | 309 | 39 | ||
166148 | 223561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 441 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008606.47777 | 2096794.40952 | 37.737884249652 | -122.412738780697 | (37.737884249652, -122.412738780697) | 10 | 7 | 7 | 28859 | 2 | |||
165501 | 49858 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46630 | 6003649.21999567 | 2095274.80996329 | 37.7334322896584 | -122.429770085042 | (37.7334322896584, -122.429770085042) | 2 | 7 | 5 | 28861 | 25 | ||
165343 | 251760 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 242 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 10:24:00 AM | 3 | 3x3 | 6001791 | 2086587 | 37.7094721136144 | -122.435573153975 | (37.7094721136144, -122.435573153975) | 9 | 7 | 6 | 28861 | 5 | ||
165259 | 52386 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3243PRECITA Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48511 | 6009040.2496951 | 2099805.3133039 | 37.7461758688375 | -122.411451668833 | (37.7461758688375, -122.411451668833) | 2 | 7 | 7 | 28859 | 2 | ||
165045 | 114647 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | 10 | 7 | 7 | 28859 | 2 | |||
163863 | 223573 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008156.49487 | 2095642.89016 | 37.7346971620413 | -122.414213149027 | (37.7346971620413, -122.414213149027) | 2 | 7 | 7 | 28859 | 2 | |||
163515 | 223437 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 512 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003198.53842 | 2098939.40251 | 37.7434688884883 | -122.431589752474 | (37.7434688884883, -122.431589752474) | 2 | 7 | 5 | 63 | 22 | |||
163310 | 223474 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 261 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006757.06634 | 2095805.91843 | 37.7350660954209 | -122.419063020159 | (37.7350660954209, -122.419063020159) | 2 | 7 | 7 | 28859 | 2 | |||
162888 | 67170 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 418 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30614 | 6007857.32486247 | 2096914.25519808 | 37.7381712430263 | -122.415337457862 | (37.7381712430263, -122.415337457862) | 2 | 7 | 7 | 28859 | 2 | ||
162560 | 176253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Delta St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010117.92765 | 2089629.2495 | 37.7182949452416 | -122.407008046982 | (37.7182949452416, -122.407008046982) | 10 | 7 | 8 | 309 | 39 | |||
162057 | 49861 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46630 | 6003649.21999567 | 2095274.80996329 | 37.7334322896584 | -122.429770085042 | (37.7334322896584, -122.429770085042) | 2 | 7 | 5 | 28861 | 25 | ||
161711 | 176228 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001469.88954 | 2089023.11794 | 37.7161429107373 | -122.436857242679 | (37.7161429107373, -122.436857242679) | 9 | 7 | 6 | 28861 | 5 | |||
161598 | 63432 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 127 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1987 12:00:00 AM | 9 | Permit Number 24018 | 6005906.17265772 | 2095879.01582361 | 37.7352188514571 | -122.422010059455 | (37.7352188514571, -122.422010059455) | 2 | 7 | 7 | 28859 | 2 | ||
161503 | 207705 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998743.30271 | 2093743.30134 | 37.7289480983677 | -122.446621004966 | (37.7289480983677, -122.446621004966) | 9 | 7 | 4 | 28861 | 40 | |||
160973 | 45791 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2001 12:00:00 AM | Permit Number 44428 | 6003953.11185898 | 2099806.69128577 | 37.7458930039208 | -122.429042450873 | (37.7458930039208, -122.429042450873) | 2 | 7 | 5 | 63 | 22 | ||
160868 | 66455 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29605 | 6009024.9615405 | 2097864.85103927 | 37.7408469284457 | -122.411367472491 | (37.7408469284457, -122.411367472491) | 10 | 7 | 7 | 28859 | 2 | ||
159901 | 38421 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
158252 | 251761 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001827 | 2086593 | 37.7094906329517 | -122.435449161052 | (37.7094906329517, -122.435449161052) | 9 | 7 | 6 | 28861 | 5 | ||||
156822 | 4390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 56 Chilton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | 2 | 7 | 5 | 63 | 7 | |||
155940 | 223446 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 422 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003080.60278 | 2099509.24195 | 37.7450268497235 | -122.432038227307 | (37.7450268497235, -122.432038227307) | 2 | 7 | 5 | 63 | 22 | |||
155694 | 31037 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 722 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34796 | 6002553.27762 | 2087290.2882 | 37.7114464558494 | -122.432988809779 | (37.7114464558494, -122.432988809779) | 9 | 7 | 6 | 28861 | 5 | |
155233 | 223479 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007707.4423 | 2097481.91784 | 37.7397214944505 | -122.415895865096 | (37.7397214944505, -122.415895865096) | 2 | 7 | 7 | 28859 | 2 | |||
155206 | 252856 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 926 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001578 | 2088750 | 37.7153991335272 | -122.43646402536 | (37.7153991335272, -122.43646402536) | 9 | 7 | 6 | 28861 | 5 | ||||
154681 | 170290 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 112 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2017 12:00:00 AM | 3 | Width 3ft | 5999300.3013 | 2093511.31058 | 37.7283429067858 | -122.44467875894 | (37.7283429067858, -122.44467875894) | 9 | 7 | 4 | 28861 | 40 | ||
154115 | 63369 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23948 | 6007406.67814687 | 2095701.52961522 | 37.7348160268391 | -122.416809680655 | (37.7348160268391, -122.416809680655) | 2 | 7 | 7 | 28859 | 2 | ||
153925 | 82699 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 81 Bessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50230 | 6008367.05322263 | 2100072.37489424 | 37.7468713781772 | -122.413798392872 | (37.7468713781772, -122.413798392872) | 2 | 7 | 7 | 28859 | 2 | ||
153675 | 251589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778123 | 6007098.02705 | 2095773.46513 | 37.7349961804395 | -122.417881894445 | (37.7349961804395, -122.417881894445) | 2 | 7 | 7 | 28859 | 2 | |
153447 | 49497 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
153244 | 176248 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012084.62968 | 2089393.6592 | 37.7177579213627 | -122.400193408991 | (37.7177579213627, -122.400193408991) | 10 | 7 | 8 | 309 | 39 | ||
153000 | 223657 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 336 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | Permit Number 18811 | 6003655.95998 | 2095270.88152 | 37.7334218847062 | -122.429746502924 | (37.7334218847062, -122.429746502924) | 2 | 7 | 5 | 28861 | 25 | ||
152919 | 96071 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1514 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767695 | 6010091 | 2100531 | 37.7482273255229 | -122.407869453177 | (37.7482273255229, -122.407869453177) | 2 | 7 | 7 | 28859 | 2 | |
151753 | 223576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007174.02692 | 2097594.37425 | 37.7400002716996 | -122.417748161849 | (37.7400002716996, -122.417748161849) | 2 | 7 | 7 | 28859 | 2 | |||
151454 | 176233 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 490 Lisbon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002171.16375 | 2090646.0569 | 37.7206389723959 | -122.43454928373 | (37.7206389723959, -122.43454928373) | 9 | 7 | 6 | 28861 | 5 |
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) );