trees
2,421 rows where qSpecies_id = 8 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21456 | 34943 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3968 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2016 12:00:00 AM | 3 | Permit Number 775333 | 6003347.35755113 | 2102457.99102165 | 37.7531385434777 | -122.43132628846 | (37.7531385434777, -122.43132628846) | 2 | 4 | 5 | 28862 | 22 | ||
| 21637 | 41577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 715 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2000 12:00:00 AM | 7 | Permit Number 42091 | 5981330.80652 | 2110844.76376 | 37.7748938752615 | -122.50808495995 | (37.7748938752615, -122.50808495995) | 11 | 6 | 2 | 55 | 26 | ||
| 21897 | 223405 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 201 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005449.32896 | 2102471.93612 | 37.7532957337303 | -122.424058237901 | (37.7532957337303, -122.424058237901) | 2 | 4 | 5 | 28859 | 19 | |||
| 22090 | 224049 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 260 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002051.64145 | 2104349.66378 | 37.7582591055966 | -122.435942470278 | (37.7582591055966, -122.435942470278) | 2 | 4 | 5 | 28862 | 3 | |||
| 22344 | 189270 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 59 Robblee Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012477.87962 | 2095853.3507 | 37.735516831132 | -122.39928732315 | (37.735516831132, -122.39928732315) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 22636 | 126510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000996.04097 | 2120002.97644 | 37.8011790965073 | -122.440715988969 | (37.8011790965073, -122.440715988969) | 13 | 9 | 1 | 57 | 17 | |||
| 22702 | 207672 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 542 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993147.42915 | 2105300.29395 | 37.76035943445 | -122.466805971728 | (37.76035943445, -122.466805971728) | 1 | 8 | 4 | 56 | 12 | |||
| 23051 | 223487 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006838.49776 | 2096321.93409 | 37.7364875458659 | -122.418818066419 | (37.7364875458659, -122.418818066419) | 2 | 7 | 7 | 28859 | 2 | |||
| 23082 | 96956 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988378.9117 | 2110569.83713 | 37.7745517889402 | -122.483684211452 | (37.7745517889402, -122.483684211452) | 11 | 6 | 2 | 55 | 26 | ||
| 23320 | 181055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Brunswick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:09:00 AM | 3 | Width 2ft | 6000651.24572 | 2087413.96665 | 37.7116779791296 | -122.439571570199 | (37.7116779791296, -122.439571570199) | 9 | 7 | 6 | 28861 | 5 | ||
| 23398 | 122165 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 631 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991266.55577 | 2111104.42075 | 37.776187272392 | -122.473734392293 | (37.776187272392, -122.473734392293) | 11 | 6 | 2 | 54 | 26 | |||
| 23459 | 223514 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3349 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006548.63349 | 2106093.81796 | 37.763302585471 | -122.420513683285 | (37.763302585471, -122.420513683285) | 8 | 4 | 7 | 28859 | 19 | |||
| 23473 | 87390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.436018296661 | (37.8000499325498, -122.436018296661) | 13 | 9 | 1 | 57 | 17 | |||
| 23656 | 191084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014440.03961 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | 14 | 3 | 8 | 28856 | 29 | ||||
| 23708 | 223428 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6008915.2046 | 2100223.65051 | 37.7473175155876 | -122.411913617629 | (37.7473175155876, -122.411913617629) | 2 | 7 | 7 | 28859 | 2 | |||
| 23844 | 58977 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 508 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2017 12:00:00 AM | 3 | 9x9 | Permit Number 779525 | 5995325.65714 | 2112056.92494 | 37.779036849804 | -122.45976196403 | (37.779036849804, -122.45976196403) | 11 | 6 | 2 | 54 | 11 | |
| 23880 | 96952 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782532 | 5988431.28084 | 2110571.1656 | 37.7745584847462 | -122.483503155986 | (37.7745584847462, -122.483503155986) | 11 | 6 | 2 | 55 | 26 | |
| 23976 | 207635 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 5994307.66331 | 2105637.8573 | 37.7613531889164 | -122.462817781532 | (37.7613531889164, -122.462817781532) | 1 | 5 | 11 | 56 | 12 | |||
| 24039 | 189257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2231 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011833.55798 | 2098197.58892 | 37.7419176820557 | -122.40167971856 | (37.7419176820557, -122.40167971856) | 10 | 3 | 8 | 58 | 1 | |||
| 24051 | 223567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007671.39008 | 2095684.74944 | 37.7347848378312 | -122.415893289437 | (37.7347848378312, -122.415893289437) | 2 | 7 | 7 | 28859 | 2 | |||
| 24237 | 223512 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007094.15413 | 2105540.45939 | 37.7618139197035 | -122.418587660093 | (37.7618139197035, -122.418587660093) | 2 | 4 | 7 | 28859 | 19 | |||
| 24312 | 126513 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1775 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001669.3138 | 2121059.84725 | 37.8041193022167 | -122.438461940777 | (37.8041193022167, -122.438461940777) | 13 | 9 | 1 | 57 | 17 | |||
| 24334 | 48686 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
| 24439 | 49859 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 3 | 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 | ||
| 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 | |||
| 24502 | 191066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 05th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011926.00282 | 2111797.31864 | 37.7792646776498 | -122.40231606173 | (37.7792646776498, -122.40231606173) | 14 | 2 | 9 | 28856 | 34 | |||
| 24529 | 27530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1898X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 6013528.91672 | 2096649.27619 | 37.7377607988237 | -122.395709213912 | (37.7377607988237, -122.395709213912) | 10 | 3 | 8 | 58 | 1 | |||
| 24617 | 207548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993918.37336 | 2106436.18995 | 37.7635227727814 | -122.464222121451 | (37.7635227727814, -122.464222121451) | 1 | 5 | 11 | 56 | 12 | |||
| 24820 | 207648 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1575 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992116.65286 | 2104730.33527 | 37.7587349341825 | -122.470329406704 | (37.7587349341825, -122.470329406704) | 1 | 8 | 4 | 56 | 12 | |||
| 24915 | 207606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995896.38015 | 2090348.10443 | 37.7194626645441 | -122.456217581487 | (37.7194626645441, -122.456217581487) | 9 | 8 | 6 | 28861 | 24 | |||
| 24919 | 207665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 5996615.28225 | 2106600.56008 | 37.7641291658503 | -122.454906302505 | (37.7641291658503, -122.454906302505) | 15 | 5 | 11 | 29492 | 12 | |||
| 25043 | 253081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | ||
| 25072 | 223529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002046.64832 | 2102339.03335 | 37.7527381135931 | -122.435815881724 | (37.7527381135931, -122.435815881724) | 2 | 4 | 5 | 28862 | 22 | |||
| 25131 | 185158 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985178.5125 | 2097636.1993 | 37.7388527871834 | -122.493801554637 | (37.7388527871834, -122.493801554637) | 1 | 8 | 3 | 29491 | 35 | |||
| 25321 | 126537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008941.49289 | 2119413.64812 | 37.8000102179579 | -122.413179470958 | (37.8000102179579, -122.413179470958) | 3 | 1 | 10 | 308 | 32 | |||
| 25492 | 251734 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 898X Prague St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.21061 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | 9 | 7 | 6 | 28861 | 5 | ||
| 25666 | 84783 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280 Charter Oak Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | 7 | Permit No. 49320 | 6010967.59518 | 2095106.34893 | 37.7333814341037 | -122.404456411357 | (37.7333814341037, -122.404456411357) | 10 | 3 | 8 | 58 | 1 | ||
| 25721 | 207622 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995492.16828 | 2107225.03182 | 37.7657793129775 | -122.458836016967 | (37.7657793129775, -122.458836016967) | 15 | 5 | 11 | 56 | 12 | |||
| 25810 | 48572 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
| 25863 | 248419 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 726 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999075.0539 | 2108056.9885 | 37.7682689481267 | -122.446503486875 | (37.7682689481267, -122.446503486875) | 15 | 5 | 11 | 29492 | 9 | |||
| 26008 | 54985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 610 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 1 | Permit Number 10863 | 5990982.11543 | 2111201.05221 | 37.7764361179599 | -122.474725393074 | (37.7764361179599, -122.474725393074) | 11 | 6 | 2 | 54 | 26 | ||
| 26247 | 207604 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 146 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996244.76197 | 2090857.98578 | 37.7208826706709 | -122.45505018502 | (37.7208826706709, -122.45505018502) | 9 | 8 | 6 | 28861 | 24 | |||
| 26446 | 223420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009036.51349 | 2099774.38399 | 37.7460907342145 | -122.411462403466 | (37.7460907342145, -122.411462403466) | 2 | 7 | 7 | 28859 | 2 | |||
| 26465 | 176246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.7203718080967 | -122.401081316846 | (37.7203718080967, -122.401081316846) | 10 | 7 | 8 | 309 | 28 | |||
| 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 | ||
| 26610 | 103937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | ||
| 26950 | 104269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2867 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 7x7 | 5999338.58115 | 2117675.40642 | 37.7946936832082 | -122.446283969628 | (37.7946936832082, -122.446283969628) | 13 | 9 | 1 | 57 | 27 | |||
| 26966 | 207618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 720 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993529.31712 | 2090633.69129 | 37.720110655762 | -122.464420306879 | (37.720110655762, -122.464420306879) | 9 | 8 | 6 | 64 | 24 | |||
| 27076 | 69940 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1295 30th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | 1 | 8 | 3 | 56 | 35 | |
| 27608 | 251772 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
| 27617 | 26468 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | ||
| 27761 | 126498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1645 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005080.33881 | 2119170.38355 | 37.7991247544637 | -122.426523212175 | (37.7991247544637, -122.426523212175) | 13 | 9 | 1 | 57 | 17 | |||
| 27764 | 223429 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008933.85702 | 2100227.23414 | 37.7473284018833 | -122.411849371861 | (37.7473284018833, -122.411849371861) | 2 | 7 | 7 | 28859 | 2 | |||
| 27975 | 126544 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008150.08042 | 2119430.1089 | 37.800010953609 | -122.415919233995 | (37.800010953609, -122.415919233995) | 5 | 1 | 1 | 308 | 32 | |||
| 27990 | 7136 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 336X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2005 12:00:00 AM | 6 | 3X3 | 5994611.62343 | 2110790.08992 | 37.775517371009 | -122.462140179219 | (37.775517371009, -122.462140179219) | 11 | 6 | 2 | 54 | 11 | ||
| 28197 | 91005 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2415 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988054.23451 | 2111177.58374 | 37.776201586759 | -122.4848519135 | (37.776201586759, -122.4848519135) | 11 | 6 | 2 | 55 | 26 | ||
| 28205 | 223464 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998616.14306 | 2107232.00709 | 37.7659775352626 | -122.448031401823 | (37.7659775352626, -122.448031401823) | 15 | 5 | 11 | 29492 | 9 | |||
| 28283 | 223478 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 147 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006034.33786 | 2095867.87013 | 37.7351954754822 | -122.42156615355 | (37.7351954754822, -122.42156615355) | 2 | 7 | 7 | 28859 | 2 | |||
| 28303 | 56711 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1659 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2015 12:00:00 AM | Permit Number 774226 | 5983116.27836009 | 2103843.81660781 | 37.7557763190096 | -122.501390749613 | (37.7557763190096, -122.501390749613) | 1 | 8 | 3 | 56 | 35 | |||
| 28306 | 223532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 529 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002464.30667 | 2099434.4104 | 37.7447864204556 | -122.434163917953 | (37.7447864204556, -122.434163917953) | 2 | 7 | 5 | 63 | 22 | |||
| 28331 | 94753 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010359.28963 | 2097585.56035 | 37.7401548048867 | -122.406734163873 | (37.7401548048867, -122.406734163873) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 28415 | 223396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 90 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6006003.81464 | 2104993.73555 | 37.7602512990686 | -122.42231986997 | (37.7602512990686, -122.42231986997) | 2 | 4 | 5 | 28859 | 19 | |||
| 28703 | 223452 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998137.72031 | 2105984.6438 | 37.7625252312687 | -122.449596269873 | (37.7625252312687, -122.449596269873) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||
| 29054 | 223592 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009191.70637 | 2102498.92995 | 37.7535804348003 | -122.411118182576 | (37.7535804348003, -122.411118182576) | 2 | 4 | 7 | 28859 | 19 | |||
| 29160 | 223644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3266 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008388.34903 | 2104490.30808 | 37.759003221729 | -122.414037245221 | (37.759003221729, -122.414037245221) | 2 | 4 | 7 | 28859 | 19 | |||
| 29275 | 257895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3644 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | ||||
| 29323 | 84791 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 499x Lisbon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176 | 2090606 | 37.7205292596373 | -122.434529703705 | (37.7205292596373, -122.434529703705) | 9 | 7 | 6 | 28861 | 5 | |||
| 29432 | 223456 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 508 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998596.25965 | 2106249.17699 | 37.7632777947483 | -122.448029403535 | (37.7632777947483, -122.448029403535) | 15 | 5 | 11 | 29492 | 9 | |||
| 29467 | 191681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1241 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017111.18893 | 2093915.90803 | 37.7304541363294 | -122.383133251796 | (37.7304541363294, -122.383133251796) | 10 | 3 | 8 | 58 | 1 | |||
| 29548 | 251781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:14:00 AM | 3 | 3x3 | 6001070 | 2087245 | 37.7112378586553 | -122.438112149268 | (37.7112378586553, -122.438112149268) | 9 | 7 | 6 | 28861 | 5 | ||
| 29812 | 99390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
| 29823 | 207664 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 428 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5996430.67292 | 2106975.20707 | 37.7651472586653 | -122.455571889857 | (37.7651472586653, -122.455571889857) | 15 | 5 | 11 | 29492 | 12 | |||
| 29910 | 172261 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 230 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001860 | 2086600 | 37.7095117275676 | -122.435335608043 | (37.7095117275676, -122.435335608043) | 9 | 7 | 6 | 28861 | 5 | |||
| 30001 | 115382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 625 Moultrie St | 1 | Side Yard : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776180 | 6007689.5 | 2096426.5 | 37.7368225406079 | -122.415883184956 | (37.7368225406079, -122.415883184956) | 2 | 7 | 7 | 28859 | 2 | ||
| 30232 | 99397 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
| 30263 | 253080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2849X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2017 11:00:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | ||
| 30286 | 90215 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2434 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987937.95416 | 2111227.93997 | 37.7763330776559 | -122.485257849615 | (37.7763330776559, -122.485257849615) | 11 | 6 | 2 | 55 | 26 | ||
| 30368 | 223652 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 360 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003548.82407 | 2095261.83271 | 37.7333909714052 | -122.430116256482 | (37.7333909714052, -122.430116256482) | 2 | 7 | 5 | 28861 | 25 | |||
| 30436 | 223435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 335 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006142.1002 | 2107638.15055 | 37.7675200389439 | -122.422029465401 | (37.7675200389439, -122.422029465401) | 8 | 4 | 7 | 28853 | 19 | |||
| 30499 | 83186 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3453 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50577 | 6006512.76900503 | 2105506.90807829 | 37.7616890471737 | -122.420596061932 | (37.7616890471737, -122.420596061932) | 2 | 4 | 7 | 28859 | 19 | ||
| 30507 | 207570 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1425 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5993940.55788 | 2105777.49426 | 37.7617154448214 | -122.464097572554 | (37.7617154448214, -122.464097572554) | 1 | 5 | 11 | 56 | 12 | |||
| 30646 | 223609 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3330 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006825.79297 | 2102649.13813 | 37.7538599081198 | -122.419310701547 | (37.7538599081198, -122.419310701547) | 2 | 4 | 7 | 28859 | 19 | |||
| 30817 | 51030 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47506 | 6011828.2745 | 2089900.62278 | 37.7191356431884 | -122.401115122362 | (37.7191356431884, -122.401115122362) | 10 | 7 | 8 | 309 | 28 | ||
| 30856 | 15055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1224 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6015288.0468 | 2095812.3346 | 37.7355604273252 | -122.389568564294 | (37.7355604273252, -122.389568564294) | 10 | 3 | 8 | 58 | 1 | ||
| 30876 | 88307 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 401 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | 9 | 7 | 6 | 28861 | 5 | ||
| 30925 | 176229 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001482.8368 | 2089045.33875 | 37.7162046599834 | -122.43681408062 | (37.7162046599834, -122.43681408062) | 9 | 7 | 6 | 28861 | 5 | |||
| 31011 | 189240 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013877.57271 | 2103955.2138 | 37.7578407445781 | -122.39501530244 | (37.7578407445781, -122.39501530244) | 10 | 3 | 8 | 28856 | 29 | |||
| 31050 | 162895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 989 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:58:00 AM | 3 | Width 0ft | 5995899.78819 | 2090467.68802 | 37.7197912084714 | -122.45621444284 | (37.7197912084714, -122.45621444284) | 9 | 8 | 6 | 28861 | 24 | ||
| 31142 | 90343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1521 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990837.83753 | 2111277.85575 | 37.7766386380593 | -122.475230094421 | (37.7766386380593, -122.475230094421) | 11 | 6 | 2 | 54 | 26 | ||
| 31166 | 191060 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 1 | Width 2ft | 6011653.22625 | 2111699.06795 | 37.7789796735174 | -122.403252800969 | (37.7789796735174, -122.403252800969) | 14 | 2 | 9 | 28856 | 34 | |||
| 31204 | 207694 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991855.32533 | 2096348.4574 | 37.7357053452243 | -122.470622695389 | (37.7357053452243, -122.470622695389) | 1 | 8 | 4 | 59 | 40 | |||
| 31228 | 244888 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 158 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999901.22 | 2109095.6532 | 37.7711680141967 | -122.443720495999 | (37.7711680141967, -122.443720495999) | 15 | 5 | 11 | 29492 | 9 | |||
| 31318 | 223620 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 439 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006808.42719 | 2101225.05572 | 37.7499487250622 | -122.419269742819 | (37.7499487250622, -122.419269742819) | 2 | 4 | 7 | 28859 | 19 | |||
| 31365 | 189263 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2211 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011935.60653 | 2098120.24236 | 37.7417109989595 | -122.401321431357 | (37.7417109989595, -122.401321431357) | 10 | 3 | 8 | 58 | 1 | |||
| 31379 | 251733 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:24:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
| 31460 | 7681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994678.74309 | 2110742.55121 | 37.7753907066265 | -122.461904549943 | (37.7753907066265, -122.461904549943) | 11 | 6 | 2 | 54 | 11 | ||
| 31475 | 176232 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 490 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002153.50763 | 2090617.3285 | 37.7205590883176 | -122.434608262185 | (37.7205590883176, -122.434608262185) | 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) );