trees
2,421 rows where qSpecies_id = 8 sorted by SiteOrder descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4522 | 141909 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.7792188274982 | -122.427751880486 | (37.7792188274982, -122.427751880486) | 7 | 9 | 11 | 29490 | 41 | |||
17913 | 35078 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
46230 | 99035 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
49564 | 114655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001302.3779 | 2113905.5111 | 37.7844544851842 | -122.439218650192 | (37.7844544851842, -122.439218650192) | 15 | 6 | 11 | 29490 | 13 | |||
58531 | 223496 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007971.83825 | 2103118.56148 | 37.7552133167577 | -122.415380629129 | (37.7552133167577, -122.415380629129) | 2 | 4 | 7 | 28859 | 19 | |||
64054 | 52809 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
74102 | 223636 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bartlett St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006708.59634 | 2102368.48305 | 37.7530826924205 | -122.419696083521 | (37.7530826924205, -122.419696083521) | 2 | 4 | 7 | 28859 | 19 | |||
86145 | 46992 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
99745 | 200655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1516 Oakdale Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015384.229 | 2095258.3254 | 37.7340445629032 | -122.389197350847 | (37.7340445629032, -122.389197350847) | 10 | 3 | 8 | 58 | 1 | |||
110517 | 94756 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010397.45691 | 2097793.22458 | 37.7407271415462 | -122.406616826609 | (37.7407271415462, -122.406616826609) | 10 | 3 | 8 | 58 | 1 | ||
129567 | 1769 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
146918 | 191664 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013199.96962 | 2111004.76664 | 37.7771595428277 | -122.397853242637 | (37.7771595428277, -122.397853242637) | 6 | 2 | 9 | 28856 | 34 | |||
157261 | 26139 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Oakdale Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11/05/2005 12:00:00 AM | 4 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
172332 | 117144 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
181248 | 207645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992161.38152 | 2104923.06164 | 37.759266696124 | -122.470188750009 | (37.759266696124, -122.470188750009) | 1 | 8 | 4 | 56 | 12 | |||
42967 | 173911 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
43724 | 94755 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010386.24454 | 2097752.48777 | 37.7406146597357 | -122.40665272486 | (37.7406146597357, -122.40665272486) | 10 | 3 | 8 | 58 | 1 | ||
48192 | 99026 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351X 23rd St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | Permit Number 41415 | 6006571 | 2102346.4 | 37.7530143054678 | -122.420170352411 | (37.7530143054678, -122.420170352411) | 2 | 4 | 7 | 28859 | 19 | |
55582 | 117143 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
68640 | 52808 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
85068 | 223635 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bartlett St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006712.94406 | 2102318.00043 | 37.7529443236272 | -122.41967746664 | (37.7529443236272, -122.41967746664) | 2 | 4 | 7 | 28859 | 19 | |||
98389 | 99034 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
106707 | 46991 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
116157 | 224110 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006506.1757 | 2109285.60199 | 37.7720640758221 | -122.420887151946 | (37.7720640758221, -122.420887151946) | 8 | 2 | 9 | 28853 | 19 | |||
119510 | 102645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1800 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/2015 12:33:00 PM | 3 | 3x3 | 6013980.4 | 2096382.2 | 37.7370525675082 | -122.394129514082 | (37.7370525675082, -122.394129514082) | 10 | 3 | 8 | 58 | 1 | ||
154494 | 223495 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007975.84228 | 2103064.94118 | 37.7550663126612 | -122.415362986219 | (37.7550663126612, -122.415362986219) | 2 | 4 | 7 | 28859 | 19 | |||
163011 | 223649 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1812 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008605.94683 | 2107884.16729 | 37.7683341961038 | -122.413524717993 | (37.7683341961038, -122.413524717993) | 8 | 4 | 7 | 28853 | 19 | |||
166499 | 35079 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
169917 | 98974 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.7548994960031 | -122.414464835105 | (37.7548994960031, -122.414464835105) | 2 | 4 | 7 | 28859 | 19 | ||
170651 | 207644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992160.10563 | 2104906.0361 | 37.7592198747043 | -122.470191922822 | (37.7592198747043, -122.470191922822) | 1 | 8 | 4 | 56 | 12 | |||
177363 | 44431 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 Prague St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2017 11:19:00 AM | 3 | Permit Number 43768 | 6002228.37284 | 2086951.06128 | 37.7104965784279 | -122.434087529513 | (37.7104965784279, -122.434087529513) | 9 | 7 | 6 | 28861 | 5 | |
179325 | 103921 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
181101 | 223510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006653.24947 | 2102596.28503 | 37.7537050664578 | -122.419903647955 | (37.7537050664578, -122.419903647955) | 2 | 4 | 7 | 28859 | 19 | |||
2430 | 224109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006481.46308 | 2109309.64111 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) | 8 | 2 | 9 | 28853 | 19 | |||
22315 | 113814 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:05:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 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 | |||
32261 | 223373 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Bosworth St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 6003068.252 | 2095170.80318 | 37.7331137949537 | -122.431771230282 | (37.7331137949537, -122.431771230282) | 2 | 7 | 5 | 28861 | 25 | ||||
38276 | 52807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
40081 | 223634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006707.09054 | 2102321.33719 | 37.7529531558696 | -122.419697945997 | (37.7529531558696, -122.419697945997) | 2 | 4 | 7 | 28859 | 19 | |||
46431 | 173910 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
47946 | 46990 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
48492 | 141906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004683.4832 | 2111946.7944 | 37.7792681524686 | -122.427381601663 | (37.7792681524686, -122.427381601663) | 7 | 9 | 11 | 29490 | 41 | |||
55194 | 191103 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012409.65437 | 2101419.97094 | 37.7507977840112 | -122.399913981553 | (37.7507977840112, -122.399913981553) | 10 | 3 | 8 | 28856 | 1 | |||
56655 | 99384 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 7 | 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 | ||
59674 | 191663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013137.81115 | 2110946.71833 | 37.7769966935644 | -122.398064196625 | (37.7769966935644, -122.398064196625) | 6 | 2 | 9 | 28856 | 34 | |||
63290 | 126560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | 3 | 1 | 10 | 308 | 23 | |||
63304 | 207643 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992162.23499 | 2104876.45393 | 37.759138772946 | -122.470182404389 | (37.759138772946, -122.470182404389) | 1 | 8 | 4 | 56 | 12 | |||
66136 | 99033 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
89263 | 6737 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/30/2012 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
90719 | 200102 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1528 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014998.4615 | 2092408.3352 | 37.7261976699 | -122.390332023639 | (37.7261976699, -122.390332023639) | 10 | 3 | 8 | 58 | 1 | |||
113949 | 114653 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001412.8316 | 2113920.3557 | 37.7845015292891 | -122.438837583296 | (37.7845015292891, -122.438837583296) | 15 | 6 | 11 | 29490 | 13 | |||
117978 | 99025 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351X 23rd St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006571 | 2102346.4 | 37.7530143054678 | -122.420170352411 | (37.7530143054678, -122.420170352411) | 2 | 4 | 7 | 28859 | 19 | ||
127181 | 35074 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
140065 | 117142 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
146469 | 94754 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010365.49883 | 2097628.45401 | 37.7402729290463 | -122.406715716973 | (37.7402729290463, -122.406715716973) | 10 | 3 | 8 | 58 | 1 | ||
183538 | 21343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
183973 | 223509 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006634.2551 | 2102596.18969 | 37.7537037345613 | -122.419969328122 | (37.7537037345613, -122.419969328122) | 2 | 4 | 7 | 28859 | 19 | |||
185618 | 98973 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.7548994960031 | -122.414464835105 | (37.7548994960031, -122.414464835105) | 2 | 4 | 7 | 28859 | 19 | ||
806 | 189267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Fairfax Ave | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6017011.55747 | 2097196.03632 | 37.7394552087924 | -122.383705980546 | (37.7394552087924, -122.383705980546) | 10 | 3 | 8 | 58 | 1 | |||
2915 | 223666 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1511 Castro St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/16/2016 05:50:00 AM | 2 | Width 3ft | 6002610.0457 | 2101075.27233 | 37.7493001124297 | -122.433777236447 | (37.7493001124297, -122.433777236447) | 2 | 4 | 5 | 28862 | 22 | ||
7031 | 126517 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3835 Scott St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6000579.5194 | 2121468.07283 | 37.8051781307269 | -122.44226256568 | (37.8051781307269, -122.44226256568) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
30235 | 35086 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
39001 | 99032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
41731 | 126559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012005.05894 | 2119209.80303 | 37.7996220201986 | -122.402563960758 | (37.7996220201986, -122.402563960758) | 3 | 1 | 10 | 308 | 23 | |||
64284 | 223521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 793 27th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001408.82629 | 2099966.50087 | 37.7461874535894 | -122.437851664431 | (37.7461874535894, -122.437851664431) | 2 | 7 | 5 | 63 | 22 | |||
71069 | 6736 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 2 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
73679 | 224048 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 395 Diamond St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001818.32693 | 2103639.30032 | 37.7562953621538 | -122.436698524039 | (37.7562953621538, -122.436698524039) | 2 | 4 | 5 | 28862 | 3 | |||
76198 | 103919 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
82399 | 224103 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006296.39827 | 2109605.75372 | 37.7729313091609 | -122.421635532653 | (37.7729313091609, -122.421635532653) | 8 | 2 | 9 | 28853 | 19 | |||
89435 | 191102 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012387.52299 | 2101410.46082 | 37.7507704374056 | -122.399989846558 | (37.7507704374056, -122.399989846558) | 10 | 3 | 8 | 28856 | 1 | |||
105337 | 207555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993925.10789 | 2106274.71202 | 37.7630797847136 | -122.464187105451 | (37.7630797847136, -122.464187105451) | 1 | 5 | 11 | 56 | 12 | |||
108528 | 191677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007442.31511 | 2109225.32703 | 37.7719512972482 | -122.417644690367 | (37.7719512972482, -122.417644690367) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
130734 | 126548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008157.98833 | 2119355.87849 | 37.7998075800257 | -122.415886610195 | (37.7998075800257, -122.415886610195) | 5 | 1 | 1 | 308 | 32 | |||
138935 | 176257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 13 Santa Ysabel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000825.3698 | 2093157.80225 | 37.7274591636907 | -122.439381211582 | (37.7274591636907, -122.439381211582) | 9 | 7 | 6 | 28861 | 25 | |||
139188 | 207642 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992163.37213 | 2104857.85489 | 37.7590877706116 | -122.470177117291 | (37.7590877706116, -122.470177117291) | 1 | 8 | 4 | 56 | 12 | |||
143690 | 223633 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006707.78219 | 2102302.55947 | 37.7529016355147 | -122.419694221906 | (37.7529016355147, -122.419694221906) | 2 | 4 | 7 | 28859 | 19 | |||
146226 | 52806 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
148803 | 223508 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006568.19765 | 2102592.69577 | 37.753690419196 | -122.420197522121 | (37.753690419196, -122.420197522121) | 2 | 4 | 7 | 28859 | 19 | |||
153436 | 223368 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3450 26th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006716.93708 | 2100883.67936 | 37.7490062301666 | -122.419561903754 | (37.7490062301666, -122.419561903754) | 2 | 4 | 7 | 28859 | 19 | |||
154253 | 117141 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
154436 | 224108 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006456.73439 | 2109332.89582 | 37.7721911464267 | -122.42106153229 | (37.7721911464267, -122.42106153229) | 8 | 2 | 9 | 28853 | 19 | |||
159359 | 173644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
165704 | 99383 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 6 | 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 | ||
182167 | 99024 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351X 23rd St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006571 | 2102346.4 | 37.7530143054678 | -122.420170352411 | (37.7530143054678, -122.420170352411) | 2 | 4 | 7 | 28859 | 19 | ||
188224 | 46989 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
188535 | 95671 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Colby St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110 | 2090446 | 37.7204811172617 | -122.41054968459 | (37.7204811172617, -122.41054968459) | 9 | 3 | 7 | 309 | 28 | |
194119 | 191080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015525.99309 | 2102510.04982 | 37.7539641575461 | -122.389213417992 | (37.7539641575461, -122.389213417992) | 10 | 3 | 8 | 28856 | 29 | |||
1511 | 260421 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
1530 | 191101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012369.93883 | 2101402.46492 | 37.7507475020033 | -122.400050093052 | (37.7507475020033, -122.400050093052) | 10 | 3 | 8 | 28856 | 1 | |||
2303 | 223507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006548.17508 | 2102589.95451 | 37.7536817641104 | -122.420266570244 | (37.7536817641104, -122.420266570244) | 2 | 4 | 7 | 28859 | 19 | |||
7390 | 27682 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 141 Industrial St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011440.5288809 | 2097124.3937126 | 37.738948976933 | -122.402963228074 | (37.738948976933, -122.402963228074) | 10 | 3 | 8 | 58 | 1 | ||
7451 | 255209 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
8807 | 224036 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1511 Castro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2016 07:10:00 AM | 2 | Width 3ft | 6002606.66337 | 2101060.9954 | 37.7492607194187 | -122.433787912303 | (37.7492607194187, -122.433787912303) | 2 | 4 | 5 | 28862 | 22 | ||
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 |
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) );