trees
2,421 rows where qSpecies_id = 8 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60242 | 63429 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 174 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1987 12:00:00 AM | 1 | Permit Number 24014 | 5988702.91741 | 2114182.56462 | 37.7844901800735 | -122.482828244548 | (37.7844901800735, -122.482828244548) | 11 | 6 | 2 | 55 | 26 | ||
6422 | 260907 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2125 Lake St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988893.20555 | 2114661.62902 | 37.7858166251674 | -122.482205030291 | (37.7858166251674, -122.482205030291) | 11 | 6 | 2 | 55 | 26 | |||
20721 | 120492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989019.39617 | 2110533.53925 | 37.7744893859398 | -122.481466017661 | (37.7744893859398, -122.481466017661) | 11 | 6 | 2 | 55 | 26 | |||
71479 | 120490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5989039.20971 | 2110535.30773 | 37.7744953937056 | -122.481397609154 | (37.7744953937056, -122.481397609154) | 11 | 6 | 2 | 55 | 26 | |||
157804 | 88392 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 22nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51370 | 5989049.86115 | 2113182.34537 | 37.7817640398692 | -122.481554671506 | (37.7817640398692, -122.481554671506) | 11 | 6 | 2 | 55 | 26 | ||
98116 | 82192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1682 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49856 | 5989061.047 | 2103886.9798 | 37.7562421670239 | -122.480835227785 | (37.7562421670239, -122.480835227785) | 1 | 8 | 3 | 56 | 35 | |
43469 | 64884 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2550 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/1989 12:00:00 AM | 8 | Permit Number 25910 | 5989263.5772 | 2097984.1265 | 37.7400462586589 | -122.479702916678 | (37.7400462586589, -122.479702916678) | 1 | 8 | 3 | 29491 | 35 | |
159603 | 38858 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1539 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40685 | 5989290.38339079 | 2104868.56062873 | 37.7589506522356 | -122.480113948201 | (37.7589506522356, -122.480113948201) | 1 | 8 | 3 | 56 | 35 | |
162000 | 38859 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1543 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40686 | 5989291.28049712 | 2104842.48405606 | 37.7588791051043 | -122.480108937189 | (37.7588791051043, -122.480108937189) | 1 | 8 | 3 | 56 | 35 | |
39889 | 38861 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40688 | 5989338.7682 | 2104794.677 | 37.7587505988826 | -122.479941205975 | (37.7587505988826, -122.479941205975) | 1 | 8 | 3 | 56 | 35 | |
148596 | 38856 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1530 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 3 | Permit Number 40683 | 5989340.55843436 | 2104922.50162386 | 37.7591016749524 | -122.479944368724 | (37.7591016749524, -122.479944368724) | 1 | 8 | 3 | 56 | 35 | |
96490 | 51407 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1554 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 5 | Permit Number 47732 | 5989341.6825 | 2104766.5057 | 37.7586734173793 | -122.479929065557 | (37.7586734173793, -122.479929065557) | 1 | 8 | 3 | 56 | 35 | |
63633 | 51408 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1554 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 4 | Permit Number 47732 | 5989342.6539 | 2104753.8772 | 37.758638799348 | -122.479924781914 | (37.758638799348, -122.479924781914) | 1 | 8 | 3 | 56 | 35 | |
186285 | 90322 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989457.99472 | 2111233.88007 | 37.7764378199226 | -122.480000100994 | (37.7764378199226, -122.480000100994) | 11 | 6 | 2 | 55 | 26 | ||
181705 | 90323 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989481.72771 | 2111237.09883 | 37.7764480366161 | -122.479918238394 | (37.7764480366161, -122.479918238394) | 11 | 6 | 2 | 55 | 26 | ||
60411 | 90324 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989502.24352 | 2111235.4245 | 37.7764446312789 | -122.479847146645 | (37.7764446312789, -122.479847146645) | 11 | 6 | 2 | 55 | 26 | ||
158104 | 120821 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5989570.27097 | 2114621.23399 | 37.7857450701275 | -122.479859643088 | (37.7857450701275, -122.479859643088) | 11 | 6 | 2 | 55 | 26 | |||
24453 | 120820 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5989571.70093 | 2114608.17958 | 37.7857093094708 | -122.47985374027 | (37.7857093094708, -122.47985374027) | 11 | 6 | 2 | 55 | 26 | |||
60973 | 90325 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1921 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989582.35832 | 2111234.7631 | 37.7764474692851 | -122.479569961566 | (37.7764474692851, -122.479569961566) | 11 | 6 | 2 | 55 | 26 | ||
134790 | 41374 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2918 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2000 12:00:00 AM | Permit Number 42011 | 5989628.92991844 | 2111970.3143396 | 37.7784697940849 | -122.479462685957 | (37.7784697940849, -122.479462685957) | 11 | 6 | 2 | 55 | 26 | |||
183879 | 51750 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 355 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2005 12:00:00 AM | 6 | Permit Number 48020 | 5989629.76736 | 2112987.41168 | 37.7812625086441 | -122.4795342239 | (37.7812625086441, -122.4795342239) | 11 | 6 | 2 | 55 | 26 | ||
13516 | 90326 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989640.77384 | 2111238.69513 | 37.7764616586133 | -122.479368175716 | (37.7764616586133, -122.479368175716) | 11 | 6 | 2 | 55 | 26 | ||
113703 | 90327 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989656.13714 | 2111238.78364 | 37.7764627939564 | -122.479315036767 | (37.7764627939564, -122.479315036767) | 11 | 6 | 2 | 55 | 26 | ||
161425 | 94326 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53626 | 5989679.6833 | 2112963.89728 | 37.7812008439985 | -122.479359820471 | (37.7812008439985, -122.479359820471) | 11 | 6 | 2 | 55 | 26 | |
146520 | 81459 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1119 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49734 | 5989696.8991 | 2098996.9987 | 37.7428525058761 | -122.47827872443 | (37.7428525058761, -122.47827872443) | 1 | 8 | 3 | 29491 | 35 | |
79788 | 82191 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1995 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49854 | 5989705.78063845 | 2101796.33096673 | 37.7505392542177 | -122.478452670316 | (37.7505392542177, -122.478452670316) | 1 | 8 | 3 | 29491 | 35 | ||
130799 | 182614 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1866 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5989725.7736 | 2102651.2747 | 37.7528878642991 | -122.478446043912 | (37.7528878642991, -122.478446043912) | 1 | 8 | 3 | 56 | 35 | |||
2248 | 90191 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1860X Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.44542 | 37.7766336380006 | -122.478900695137 | (37.7766336380006, -122.478900695137) | 11 | 6 | 2 | 55 | 26 | |||
63446 | 90328 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1849X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989790.54801 | 2111243.58929 | 37.7764837946672 | -122.478850428089 | (37.7764837946672, -122.478850428089) | 11 | 6 | 2 | 55 | 26 | ||
186715 | 90190 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1844 Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989791.50296 | 2111298.55594 | 37.7766347733354 | -122.478851145848 | (37.7766347733354, -122.478851145848) | 11 | 6 | 2 | 55 | 26 | |||
146084 | 90189 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1844 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989807.27253 | 2111298.22245 | 37.7766347733404 | -122.478796570506 | (37.7766347733404, -122.478796570506) | 11 | 6 | 2 | 55 | 26 | ||
138260 | 90329 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1849X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989811.50047 | 2111242.93957 | 37.7764832273358 | -122.478777900828 | (37.7764832273358, -122.478777900828) | 11 | 6 | 2 | 55 | 26 | ||
79395 | 90330 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1831 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 2 | 3x3 | 5989853.25507 | 2111244.33044 | 37.7764894706591 | -122.478633563095 | (37.7764894706591, -122.478633563095) | 11 | 6 | 2 | 55 | 26 | ||
87383 | 90188 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1828 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989860.89772 | 2111301.42951 | 37.776646692653 | -122.47861130194 | (37.776646692653, -122.47861130194) | 11 | 6 | 2 | 55 | 26 | ||
56815 | 90187 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1826 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989876.68913 | 2111302.12921 | 37.776649530669 | -122.478556726612 | (37.776649530669, -122.478556726612) | 11 | 6 | 2 | 55 | 26 | ||
152020 | 90331 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1821 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989897.56523 | 2111248.76817 | 37.7765042280072 | -122.478480607879 | (37.7765042280072, -122.478480607879) | 11 | 6 | 2 | 55 | 26 | ||
70450 | 75463 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1806 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2013 12:00:00 AM | 3 | 3x3 | 5989925.9266 | 2111303.98207 | 37.7766574766255 | -122.47838653717 | (37.7766574766255, -122.47838653717) | 11 | 6 | 2 | 55 | 26 | ||
65154 | 47258 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1290 20TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45199 | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||
178036 | 117440 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1290 20TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||||
82445 | 254665 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1771 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778441 | 5989948 | 2103325 | 37.7547506343258 | -122.477726795598 | (37.7547506343258, -122.477726795598) | 1 | 8 | 3 | 56 | 35 | |
167839 | 90332 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990079.80484 | 2111253.67647 | 37.7765282832532 | -122.477850554666 | (37.7765282832532, -122.477850554666) | 11 | 6 | 2 | 55 | 26 | ||
3255 | 72399 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 794-798 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769948 | 5990094.17599 | 2109997.03923 | 37.7730787370976 | -122.477708963104 | (37.7730787370976, -122.477708963104) | 11 | 6 | 2 | 55 | 26 |
160291 | 90333 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990096.08573 | 2111253.98064 | 37.7765300633083 | -122.477794257242 | (37.7765300633083, -122.477794257242) | 11 | 6 | 2 | 55 | 26 | ||
99100 | 111742 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776572 | 5990114.7617 | 2111254.66631 | 37.7765330298264 | -122.477729702528 | (37.7765330298264, -122.477729702528) | 11 | 6 | 2 | 55 | 26 | |
108841 | 111743 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5990130.37359 | 2111254.12016 | 37.7765324362559 | -122.477675657167 | (37.7765324362559, -122.477675657167) | 11 | 6 | 2 | 55 | 26 | |||
11087 | 122015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1799 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990132.5051 | 2110630.33529 | 37.7748198185001 | -122.477622678128 | (37.7748198185001, -122.477622678128) | 11 | 6 | 2 | 55 | 26 | |||
14415 | 72426 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4250X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | Permit Number 773790 | 5990138.03134 | 2109951.66223 | 37.7729566892672 | -122.47755394624 | (37.7729566892672, -122.47755394624) | 11 | 6 | 2 | 55 | 26 | |
38972 | 111744 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5990148.86908 | 2111256.53838 | 37.7765401493402 | -122.47761185344 | (37.7765401493402, -122.47761185344) | 11 | 6 | 2 | 55 | 26 | |||
138129 | 90186 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1720 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990170.59933 | 2111312.57301 | 37.7766952659717 | -122.477540779648 | (37.7766952659717, -122.477540779648) | 11 | 6 | 2 | 55 | 26 | ||
28930 | 90335 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 1 | 3x3 | 5990179.830083 | 2111264.66899 | 37.7765642703859 | -122.477505345978 | (37.7765642703859, -122.477505345978) | 11 | 6 | 2 | 55 | 26 | ||
111907 | 90334 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 1 | 3x3 | 5990179.830083 | 2111264.66899 | 37.7765642703859 | -122.477505345978 | (37.7765642703859, -122.477505345978) | 11 | 6 | 2 | 55 | 26 | ||
114817 | 90336 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2013 12:00:00 AM | 1 | 3x3 | 5990179.830083 | 2111264.66899 | 37.7765642703859 | -122.477505345978 | (37.7765642703859, -122.477505345978) | 11 | 6 | 2 | 55 | 26 | ||
136166 | 90185 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1720 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990201.354 | 2111313.50618 | 37.7766996127948 | -122.477434459536 | (37.7766996127948, -122.477434459536) | 11 | 6 | 2 | 55 | 26 | ||
112641 | 122276 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1718 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990220.44471 | 2111314.15807 | 37.7767025104298 | -122.477368467498 | (37.7767025104298, -122.477368467498) | 11 | 6 | 2 | 55 | 26 | |||
143403 | 88383 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51361 | 5990241.51216 | 2114541.21965 | 37.7855643469481 | -122.477531513518 | (37.7855643469481, -122.477531513518) | 11 | 6 | 2 | 55 | 26 | ||
38599 | 48554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 378 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | Permit Number 776479 | 5990306.99232217 | 2112830.037025 | 37.7808697161231 | -122.477179880009 | (37.7808697161231, -122.477179880009) | 11 | 6 | 2 | 55 | 26 | |||
69628 | 114796 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2015 12:00:00 AM | Permit Number 775428 | 5990315.8 | 2110460.7 | 37.7743646815998 | -122.476976231877 | (37.7743646815998, -122.476976231877) | 11 | 6 | 2 | 55 | 26 | |||
50283 | 122031 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990343.843 | 2110450.87965 | 37.7743393443985 | -122.476878509257 | (37.7743393443985, -122.476878509257) | 11 | 6 | 2 | 55 | 26 | |||
28349 | 90183 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990402.31364 | 2111319.28606 | 37.776727141439 | -122.476739710576 | (37.776727141439, -122.476739710576) | 11 | 6 | 2 | 55 | 26 | ||
31798 | 154902 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
34999 | 154898 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
86852 | 154903 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
160246 | 254370 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
14055 | 90182 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990417.75212 | 2111322.65396 | 37.7767372842601 | -122.476686550978 | (37.7767372842601, -122.476686550978) | 11 | 6 | 2 | 55 | 26 | ||
56020 | 90181 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1640 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990451.67378 | 2111322.99271 | 37.7767401818846 | -122.476569231876 | (37.7767401818846, -122.476569231876) | 11 | 6 | 2 | 55 | 26 | ||
161241 | 90180 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1630 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990474.44986 | 2111322.51161 | 37.7767401818998 | -122.476490408326 | (37.7767401818998, -122.476490408326) | 11 | 6 | 2 | 55 | 26 | ||
107588 | 90337 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1629 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2013 12:00:00 AM | 3 | 3x3 | 5990482.39564 | 2111267.2104 | 37.7765888008267 | -122.476458881036 | (37.7765888008267, -122.476458881036) | 11 | 6 | 2 | 55 | 26 | ||
177087 | 207531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1325 18th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5990492.61494 | 2106135.12336 | 37.7624980762427 | -122.476048615548 | (37.7624980762427, -122.476048615548) | 1 | 8 | 3 | 56 | 12 | |||
22379 | 122307 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990526.29521 | 2111270.38864 | 37.7766000733292 | -122.476307253497 | (37.7766000733292, -122.476307253497) | 11 | 6 | 2 | 55 | 26 | |||
62823 | 90339 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1617 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990541.50098 | 2111271.1479 | 37.7766030398525 | -122.476254708345 | (37.7766030398525, -122.476254708345) | 11 | 6 | 2 | 55 | 26 | ||
121704 | 122306 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1609 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990561.02616 | 2111270.95171 | 37.7766036334271 | -122.476187151446 | (37.7766036334271, -122.476187151446) | 11 | 6 | 2 | 55 | 26 | |||
146668 | 90179 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1612 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990564.13249 | 2111328.53275 | 37.7767619152597 | -122.476180612609 | (37.7767619152597, -122.476180612609) | 11 | 6 | 2 | 55 | 26 | ||
159143 | 94155 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1863 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53541 | 5990589.8 | 2102714 | 37.7531102147949 | -122.475462689636 | (37.7531102147949, -122.475462689636) | 1 | 8 | 4 | 56 | 12 | ||
187749 | 90338 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990591.656258 | 2111279.589406 | 37.7766291263166 | -122.47608182516 | (37.7766291263166, -122.47608182516) | 11 | 6 | 2 | 55 | 26 | ||
49306 | 112862 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5990594 | 2098423 | 37.7413284897401 | -122.475134938873 | (37.7413284897401, -122.475134938873) | 1 | 8 | 4 | 29491 | 40 | |||
56479 | 207688 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990596.01765 | 2098405.20532 | 37.7412797470716 | -122.475126663888 | (37.7412797470716, -122.475126663888) | 1 | 8 | 4 | 29491 | 40 | |||
118485 | 207577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1863 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990606.99166 | 2102703.3769 | 37.7530820431036 | -122.475402462551 | (37.7530820431036, -122.475402462551) | 1 | 8 | 4 | 56 | 12 | |||
26608 | 90340 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1609 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990615.55567 | 2111280.455278 | 37.7766328895552 | -122.475999214233 | (37.7766328895552, -122.475999214233) | 11 | 6 | 2 | 55 | 26 | ||
89620 | 207671 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1734 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990626.77188 | 2103577.88918 | 37.7554843697179 | -122.475397903889 | (37.7554843697179, -122.475397903889) | 1 | 8 | 4 | 56 | 12 | |||
53966 | 37491 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1653 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39960 | 5990646.15475208 | 2106518.49529305 | 37.7635596145943 | -122.475545577058 | (37.7635596145943, -122.475545577058) | 1 | 8 | 3 | 56 | 12 | ||
183774 | 115293 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776197 | 5990660.3 | 2100644 | 37.7474306230823 | -122.475067792345 | (37.7474306230823, -122.475067792345) | 1 | 8 | 4 | 29491 | 40 | |||
50502 | 207670 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1946 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990672.18333 | 2102133.32849 | 37.7515206186011 | -122.475135407975 | (37.7515206186011, -122.475135407975) | 1 | 8 | 4 | 29491 | 12 | |||
102682 | 50911 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1946 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47414 | 5990675.27966813 | 2102143.29452462 | 37.751548162175 | -122.47512542803 | (37.751548162175, -122.47512542803) | 1 | 8 | 4 | 29491 | 12 | ||
53137 | 64881 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1989 12:00:00 AM | 10 | 3X3 | Permit Number 25903 | 5990675.59164589 | 2098407.0770941 | 37.7412894981021 | -122.474851664533 | (37.7412894981021, -122.474851664533) | 1 | 8 | 4 | 29491 | 40 |
20143 | 207679 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990677.2269 | 2100653.21825 | 37.7474569149997 | -122.475009933665 | (37.7474569149997, -122.475009933665) | 1 | 8 | 4 | 29491 | 40 | |||
80598 | 37489 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1639 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39958 | 5990687.69704484 | 2106519.91830078 | 37.7635659299099 | -122.475402000804 | (37.7635659299099, -122.475402000804) | 1 | 8 | 3 | 56 | 12 | ||
1238 | 144982 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 676 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 3ft | 5990689.31249 | 2110785.3324 | 37.7752776943529 | -122.4757079065 | (37.7752776943529, -122.4757079065) | 11 | 6 | 2 | 54 | 26 | ||
9588 | 144974 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 3ft | 5990690 | 2111380 | 37.7769105282448 | -122.475748963166 | (37.7769105282448, -122.475748963166) | 11 | 6 | 2 | 54 | 26 | ||
96708 | 90341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2013 12:00:00 AM | 3 | 3x3 | 5990704.93298 | 2111272.88253 | 37.7766172788416 | -122.475689482105 | (37.7766172788416, -122.475689482105) | 11 | 6 | 2 | 54 | 26 | ||
142819 | 64850 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2419 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1989 12:00:00 AM | Permit Number 25865 | 5990734.04742599 | 2098925.10305057 | 37.7427152512508 | -122.474687346453 | (37.7427152512508, -122.474687346453) | 1 | 8 | 4 | 29491 | 40 | ||
171970 | 64849 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2427 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1989 12:00:00 AM | Permit Number 25864 | 5990735.82464568 | 2098873.0190571 | 37.7425723450195 | -122.474677400881 | (37.7425723450195, -122.474677400881) | 1 | 8 | 4 | 29491 | 40 | ||
192643 | 64883 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2431 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1989 12:00:00 AM | Permit Number 25908 | 5990736.71325553 | 2098846.97706037 | 37.7425008919022 | -122.474672428109 | (37.7425008919022, -122.474672428109) | 1 | 8 | 4 | 29491 | 40 | ||
82782 | 207684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2419 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990737.5825 | 2098918.54589 | 37.7426974518186 | -122.474674644836 | (37.7426974518186, -122.474674644836) | 1 | 8 | 4 | 29491 | 40 | |||
112769 | 101127 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Clement St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990738.2441 | 2113419.67903 | 37.7825137204538 | -122.475731055208 | (37.7825137204538, -122.475731055208) | 11 | 6 | 2 | 54 | 26 | |||
166322 | 207685 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2431 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5990740.98987 | 2098842.82853 | 37.7424897489131 | -122.474657338285 | (37.7424897489131, -122.474657338285) | 1 | 8 | 4 | 29491 | 40 | |||
170647 | 64892 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25918 | 5990741.15630477 | 2098716.76707671 | 37.7421436262999 | -122.474647564393 | (37.7421436262999, -122.474647564393) | 1 | 8 | 4 | 29491 | 40 | ||
174573 | 207686 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5990741.80661 | 2098714.09627 | 37.742136330634 | -122.474645120982 | (37.742136330634, -122.474645120982) | 1 | 8 | 4 | 29491 | 40 | |||
42539 | 90178 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990743.86008 | 2111332.65292 | 37.7767836486034 | -122.475559188643 | (37.7767836486034, -122.475559188643) | 11 | 6 | 2 | 54 | 26 | ||
180088 | 51547 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2475 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2005 12:00:00 AM | Permit Number 47846 | 5990746.48796302 | 2098560.51512066 | 37.7417149076087 | -122.474617728253 | (37.7417149076087, -122.474617728253) | 1 | 8 | 4 | 29491 | 40 | ||
36832 | 64890 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2479 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25916 | 5990747.37657328 | 2098534.47311176 | 37.7416434544453 | -122.474612755594 | (37.7416434544453, -122.474612755594) | 1 | 8 | 4 | 29491 | 40 |
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) );