trees
2,421 rows where qSpecies_id = 8 sorted by PermitNotes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 9657 | 126497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | 13 | 9 | 1 | 57 | 17 | |||
| 9670 | 85554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
| 9764 | 150815 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013813.37874 | 2104087.70708 | 37.7582009725247 | -122.395246594574 | (37.7582009725247, -122.395246594574) | 10 | 3 | 8 | 28856 | 29 | |||
| 9952 | 148016 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002451.59987 | 2088819.6954 | 37.7156401042879 | -122.433449457832 | (37.7156401042879, -122.433449457832) | 9 | 7 | 6 | 28861 | 5 | |||
| 9989 | 176265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Excelsior Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6004683.74002 | 2091261.8142 | 37.7224720200432 | -122.425907897826 | (37.7224720200432, -122.425907897826) | 9 | 7 | 6 | 28861 | 5 | |||
| 10016 | 261433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 393 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007343 | 2095769 | 37.7349977038172 | -122.417034617662 | (37.7349977038172, -122.417034617662) | 2 | 7 | 7 | 28859 | 2 | ||||
| 10065 | 223575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007323 | 2098000 | 37.7411224122402 | -122.417261809722 | (37.7411224122402, -122.417261809722) | 2 | 7 | 7 | 28859 | 2 | |||
| 10072 | 223589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008529.06402 | 2096927.29731 | 37.7382447851783 | -122.413015832133 | (37.7382447851783, -122.413015832133) | 10 | 7 | 7 | 28859 | 2 | |||
| 10369 | 223584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007576 | 2096576 | 37.7372266531625 | -122.41628619091 | (37.7372266531625, -122.41628619091) | 2 | 7 | 7 | 28859 | 2 | |||
| 10433 | 189238 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2126 24th St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012108.67622 | 2102369.63804 | 37.75338857883 | -122.401021516451 | (37.75338857883, -122.401021516451) | 10 | 3 | 8 | 28856 | 29 | |||
| 10631 | 106353 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 3520X 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006283 | 2100840 | 37.7488618444312 | -122.421059362487 | (37.7488618444312, -122.421059362487) | 2 | 4 | 5 | 28859 | 19 | |||
| 10646 | 172228 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 203 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6002933 | 2092317 | 37.7252702278754 | -122.432035115452 | (37.7252702278754, -122.432035115452) | 9 | 7 | 6 | 28861 | 5 | |||
| 10751 | 170656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 398X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 6x4 | 6000839.66357 | 2092572.31066 | 37.7258523512861 | -122.439289849442 | (37.7258523512861, -122.439289849442) | 9 | 7 | 6 | 28861 | 25 | ||
| 10927 | 74852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009221.87688 | 2119018.0672 | 37.7989397873109 | -122.412181258567 | (37.7989397873109, -122.412181258567) | 3 | 1 | 10 | 308 | 4 | |||
| 10976 | 262163 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | |||
| 11167 | 78311 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 651 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002171.16475 | 2090137.23408 | 37.7192418585039 | -122.434512917837 | (37.7192418585039, -122.434512917837) | 9 | 7 | 6 | 28861 | 5 | |||
| 11395 | 69965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5992352.53877 | 2110655.12549 | 37.7750164659141 | -122.469944995693 | (37.7750164659141, -122.469944995693) | 11 | 6 | 2 | 54 | 11 | |||
| 11488 | 71394 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1549 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6015490.02353 | 2096504.22569 | 37.7374714167655 | -122.388918537456 | (37.7374714167655, -122.388918537456) | 10 | 3 | 8 | 58 | 1 | |||
| 11545 | 261446 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 329 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007068 | 2095792 | 37.7350453831972 | -122.417987022359 | (37.7350453831972, -122.417987022359) | 2 | 7 | 7 | 28859 | 2 | ||||
| 11592 | 224089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004580.79593 | 2109148.95091 | 37.7715801506238 | -122.427537458604 | (37.7715801506238, -122.427537458604) | 7 | 9 | 11 | 28852 | 10 | |||
| 11677 | 26000 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1715 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014353.43695 | 2095957.87317 | 37.7359081801195 | -122.39281007034 | (37.7359081801195, -122.39281007034) | 10 | 3 | 8 | 58 | 1 | ||
| 11678 | 262547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014600.2068 | 2090881.6643 | 37.7219836364279 | -122.391602089471 | (37.7219836364279, -122.391602089471) | 10 | 3 | 8 | 58 | 1 | |||
| 11818 | 207596 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994790.18426 | 2091971.80036 | 37.7238573834024 | -122.460158838768 | (37.7238573834024, -122.460158838768) | 9 | 8 | 4 | 28861 | 24 | |||
| 11823 | 223370 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99 Lapidge St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006029.2284 | 2104988.85011 | 37.7602393183104 | -122.422231628499 | (37.7602393183104, -122.422231628499) | 2 | 4 | 5 | 28859 | 19 | |||
| 11873 | 224059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002696.79261 | 2106527.84926 | 37.7642765053752 | -122.433866946505 | (37.7642765053752, -122.433866946505) | 15 | 5 | 5 | 28862 | 3 | |||
| 11903 | 73567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1549 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6015475.76559 | 2096515.71199 | 37.7375021654981 | -122.388968635992 | (37.7375021654981, -122.388968635992) | 10 | 3 | 8 | 58 | 1 | |||
| 12028 | 261519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:20:00 PM | Width 4ft | 5982910.9702 | 2111318.38005 | 37.7762872714849 | -122.502653994406 | (37.7762872714849, -122.502653994406) | 11 | 6 | 2 | 55 | 26 | |||
| 12056 | 207640 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992163.90266 | 2104824.95669 | 37.7589974714712 | -122.47017288688 | (37.7589974714712, -122.47017288688) | 1 | 8 | 4 | 56 | 12 | |||
| 12094 | 223388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
| 12160 | 170683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2020 12:00:00 AM | 3 | Width 3ft | 6000666.46145 | 2092693.59381 | 37.7261755091709 | -122.439897287525 | (37.7261755091709, -122.439897287525) | 9 | 7 | 6 | 28861 | 25 | ||
| 12755 | 214559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1342 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | Width 3ft | 5991532.56497 | 2106606.32246 | 37.7638521099028 | -122.472486197695 | (37.7638521099028, -122.472486197695) | 11 | 8 | 11 | 56 | 12 | ||
| 12812 | 170654 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000891.32853 | 2092534.3103 | 37.7257509509219 | -122.439108525449 | (37.7257509509219, -122.439108525449) | 9 | 7 | 6 | 28861 | 25 | ||
| 13100 | 176239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009040.83689 | 2090406.80665 | 37.7203696227506 | -122.410785993677 | (37.7203696227506, -122.410785993677) | 9 | 3 | 7 | 309 | 28 | |||
| 13230 | 260498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 349 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6000178 | 2110153 | 37.7740870040886 | -122.442839045318 | (37.7740870040886, -122.442839045318) | 15 | 5 | 11 | 29492 | 16 | ||||
| 13251 | 262414 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | 6003118 | 2094425 | 37.7310688083977 | -122.431546013106 | (37.7310688083977, -122.431546013106) | 9 | 7 | 5 | 28861 | 25 | |
| 13393 | 207553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993922.26035 | 2106313.56882 | 37.7631863112193 | -122.464199775125 | (37.7631863112193, -122.464199775125) | 1 | 5 | 11 | 56 | 12 | |||
| 13425 | 223490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008605.30011 | 2107940.39716 | 37.768488553924 | -122.41353093232 | (37.768488553924, -122.41353093232) | 8 | 4 | 7 | 28853 | 19 | |||
| 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 | ||
| 13680 | 247278 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2015 12:00:00 AM | 18 | Width 0ft | 5998896.1541 | 2109320.6647 | 37.7717284621218 | -122.447213239628 | (37.7717284621218, -122.447213239628) | 15 | 5 | 11 | 29492 | 9 | ||
| 13899 | 223627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006726 | 2101710 | 37.7512756289395 | -122.419589182986 | (37.7512756289395, -122.419589182986) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 14120 | 11922 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 620X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2016 12:00:00 AM | 3 | 3X4 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | ||
| 14213 | 74019 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6010272.25282 | 2105997.87843 | 37.7632482996846 | -122.407628081878 | (37.7632482996846, -122.407628081878) | 8 | 4 | 8 | 28859 | 19 | ||
| 14267 | 261441 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 364 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
| 14283 | 176234 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000330.77387 | 2088762.22962 | 37.7153617623173 | -122.44077585684 | (37.7153617623173, -122.44077585684) | 9 | 7 | 6 | 28861 | 5 | |||
| 14335 | 126528 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2865 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999858.5831 | 2117397.02889 | 37.7939590162525 | -122.444464683403 | (37.7939590162525, -122.444464683403) | 13 | 9 | 1 | 57 | 27 | |||
| 14507 | 78352 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 647 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002178.01905 | 2090148.09572 | 37.71927207124 | -122.434490001335 | (37.71927207124, -122.434490001335) | 9 | 7 | 6 | 28861 | 5 | |||
| 14527 | 255214 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 14607 | 144226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 786 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:53:00 PM | 0 | Width 4ft | 5982632.5127 | 2110441.98121 | 37.7738645680338 | -122.503552325389 | (37.7738645680338, -122.503552325389) | 11 | 6 | 2 | 55 | 26 | ||
| 14615 | 260497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6000185 | 2110105 | 37.7739556073117 | -122.44281138372 | (37.7739556073117, -122.44281138372) | 15 | 5 | 11 | 29492 | 16 | ||||
| 14625 | 161993 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 138 Guttenberg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 5999425.42548 | 2087282.88829 | 37.7112482236968 | -122.443798910798 | (37.7112482236968, -122.443798910798) | 9 | 7 | 6 | 28861 | 5 | |||
| 14856 | 126525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3321 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004100.5255 | 2120576.79123 | 37.8029309470697 | -122.430014078187 | (37.8029309470697, -122.430014078187) | 13 | 9 | 1 | 57 | 17 | |||
| 14859 | 245105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999853.8212 | 2109427.1506 | 37.7720755187291 | -122.443908271008 | (37.7720755187291, -122.443908271008) | 15 | 5 | 11 | 29492 | 9 | |||
| 14883 | 242086 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/16/2016 05:57:00 AM | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | 2 | 4 | 5 | 28862 | 22 | ||
| 14957 | 85546 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
| 15002 | 73575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | 3 | 1 | 10 | 28860 | 6 | |||
| 15080 | 223395 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3641 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005336.13601 | 2104859.99107 | 37.7598463829262 | -122.424619544351 | (37.7598463829262, -122.424619544351) | 2 | 4 | 5 | 28859 | 19 | |||
| 15086 | 207588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001743.96601 | 2095815.79538 | 37.7348096375426 | -122.436395778947 | (37.7348096375426, -122.436395778947) | 2 | 7 | 5 | 63 | 7 | |||
| 15156 | 90172 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990908.22712 | 2111337.09849 | 37.7768053819444 | -122.474990924283 | (37.7768053819444, -122.474990924283) | 11 | 6 | 2 | 54 | 26 | ||
| 15246 | 242850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 483 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003468.14105 | 2098906.5693 | 37.7433940136201 | -122.430655192302 | (37.7433940136201, -122.430655192302) | 2 | 7 | 5 | 63 | 22 | |||
| 15380 | 74967 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012084.12824 | 2119041.91729 | 37.7991654604723 | -122.402278540244 | (37.7991654604723, -122.402278540244) | 3 | 1 | 10 | 28860 | 6 | ||
| 15417 | 224105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006280.26739 | 2109523.46395 | 37.7727044515829 | -122.421685485523 | (37.7727044515829, -122.421685485523) | 8 | 2 | 9 | 28853 | 19 | |||
| 15449 | 85521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
| 15567 | 223585 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
| 15652 | 147295 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5987874.57425 | 2110110.67904 | 37.7732616993961 | -122.485395090629 | (37.7732616993961, -122.485395090629) | 11 | 6 | 2 | 55 | 26 | |||
| 15659 | 26852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2016 05:13:00 AM | 3 | 2X2 | 6005817.98305 | 2101925.96787 | 37.7518174380456 | -122.422744557734 | (37.7518174380456, -122.422744557734) | 2 | 4 | 5 | 28859 | 19 | ||
| 15681 | 245106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999851.4945 | 2109440.7782 | 37.7721128039526 | -122.443917298515 | (37.7721128039526, -122.443917298515) | 15 | 5 | 11 | 29492 | 9 | |||
| 15688 | 126539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008917.81168 | 2119409.99919 | 37.799998869415 | -122.413261159078 | (37.799998869415, -122.413261159078) | 3 | 1 | 10 | 308 | 32 | |||
| 16056 | 243760 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2432 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1x3 | 6001985.30347 | 2097161.30264 | 37.7385177995686 | -122.435657623519 | (37.7385177995686, -122.435657623519) | 2 | 7 | 5 | 63 | 7 | |||
| 16530 | 223386 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3665 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005227.03743 | 2104855.48781 | 37.7598278559952 | -122.424996542879 | (37.7598278559952, -122.424996542879) | 2 | 4 | 5 | 28859 | 19 | |||
| 16533 | 74989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009226.90425 | 2118994.74178 | 37.798876023557 | -122.412162212732 | (37.798876023557, -122.412162212732) | 3 | 1 | 10 | 308 | 4 | |||
| 16907 | 207595 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994790.50669 | 2091956.97642 | 37.7238166989736 | -122.460156650725 | (37.7238166989736, -122.460156650725) | 9 | 8 | 4 | 28861 | 24 | |||
| 16949 | 255206 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 16994 | 261098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1999 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012390 | 2093339 | 37.7286080475288 | -122.399414697344 | (37.7286080475288, -122.399414697344) | 10 | 3 | 8 | 58 | 1 | ||
| 17045 | 176247 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011833.80931 | 2090345.75054 | 37.7203581824627 | -122.401127251532 | (37.7203581824627, -122.401127251532) | 10 | 7 | 8 | 309 | 28 | |||
| 17486 | 191662 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013078.45063 | 2110885.87068 | 37.776826313422 | -122.398265274217 | (37.776826313422, -122.398265274217) | 6 | 2 | 9 | 28856 | 34 | |||
| 17626 | 90350 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992328.99634 | 2111334.95536 | 37.7768817336944 | -122.470075945794 | (37.7768817336944, -122.470075945794) | 11 | 6 | 2 | 54 | 11 | ||
| 17633 | 255212 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 17745 | 207576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1245 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993280.81145 | 2107003.85945 | 37.7650446756837 | -122.466468488529 | (37.7650446756837, -122.466468488529) | 11 | 8 | 11 | 56 | 12 | |||
| 17998 | 85553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 332 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008375 | 2108695 | 37.7705475827471 | -122.414380922989 | (37.7705475827471, -122.414380922989) | 8 | 2 | 9 | 28853 | 19 | |||
| 18129 | 223629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006717.33389 | 2102164.58545 | 37.7525233285091 | -122.419651401605 | (37.7525233285091, -122.419651401605) | 2 | 4 | 7 | 28859 | 19 | |||
| 18139 | 260420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
| 18151 | 72422 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6010224.23312 | 2105998.24791 | 37.7632466260627 | -122.407794192953 | (37.7632466260627, -122.407794192953) | 8 | 4 | 8 | 28859 | 19 | ||
| 18281 | 261190 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
| 18382 | 223425 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1514 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010157.18753 | 2100400.68055 | 37.7478732021894 | -122.407631390476 | (37.7478732021894, -122.407631390476) | 2 | 7 | 7 | 28859 | 2 | |||
| 18581 | 207557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 438 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993090.30731 | 2105981.36839 | 37.7622261896015 | -122.467053045158 | (37.7622261896015, -122.467053045158) | 1 | 8 | 11 | 56 | 12 | |||
| 18737 | 258112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5993962.87947 | 2115311.61201 | 37.7878948748238 | -122.464712734046 | (37.7878948748238, -122.464712734046) | 11 | 6 | 1 | 54 | 11 | ||||||
| 18784 | 255213 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 18922 | 74929 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014021.82023 | 2112985.48182 | 37.7826438712502 | -122.395148955186 | (37.7826438712502, -122.395148955186) | 6 | 2 | 9 | 28856 | 6 | |||
| 18943 | 166174 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3356 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6006632.30883 | 2102638.63296 | 37.7538201643798 | -122.419979070489 | (37.7538201643798, -122.419979070489) | 2 | 4 | 7 | 28859 | 19 | |||
| 19092 | 150813 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25 Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013747.19893 | 2104113.81693 | 37.758268983752 | -122.395477303948 | (37.758268983752, -122.395477303948) | 10 | 3 | 8 | 28856 | 29 | |||
| 19307 | 191107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2021 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012536.97765 | 2101462.04256 | 37.7509204011789 | -122.399476636765 | (37.7509204011789, -122.399476636765) | 10 | 3 | 8 | 28856 | 1 | |||
| 19415 | 207567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993332.90632 | 2105478.86698 | 37.7608604521776 | -122.466177475135 | (37.7608604521776, -122.466177475135) | 1 | 8 | 4 | 56 | 12 | |||
| 19885 | 191110 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6011791.4986 | 2102301.92631 | 37.7531849588319 | -122.40211362974 | (37.7531849588319, -122.40211362974) | 10 | 3 | 8 | 28856 | 29 | |||
| 19933 | 223498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006745.96401 | 2102320.90162 | 37.7529541496195 | -122.41956348298 | (37.7529541496195, -122.41956348298) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 20316 | 200101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1528 Yosemite Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015012.674 | 2092395.4762 | 37.7261631500088 | -122.39028199338 | (37.7261631500088, -122.39028199338) | 10 | 3 | 8 | 58 | 1 | |||
| 20325 | 223546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 384 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000939.02096 | 2096709.07098 | 37.7372165929608 | -122.439242751069 | (37.7372165929608, -122.439242751069) | 2 | 7 | 5 | 63 | 7 |
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) );