Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3489 | 3489 | 74967 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 8 | 3x3 | 6012084.12824 | 2119041.9172900002 | 37.799165460472295 | -122.40227854024401 | (37.7991654604723, -122.402278540244) | |
3749 | 3749 | 223601 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 280x Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007724.0 | 2106220.0 | 37.7637152201621 | -122.41645740380899 | (37.7637152201621, -122.416457403809) | |||
8142 | 8142 | 14641 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 600X McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1998 12:00:00 AM | 8 | 4x4 | 6006147.64251 | 2112148.2738 | 37.77990406506721 | -122.422330778736 | (37.7799040650672, -122.422330778736) | ||
18802 | 18802 | 509 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2753 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008975.21686 | 2102392.50435 | 37.7532760709475 | -122.411859333666 | (37.7532760709475, -122.411859333666) | |||
24524 | 24524 | 223397 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3560 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005876.75311 | 2104933.14392 | 37.7600777604998 | -122.422755010534 | (37.7600777604998, -122.422755010534) | |||
24645 | 24645 | 31679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4909 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35185 | 5997751.25621 | 2105611.0193 | 37.7614772360152 | -122.450905959737 | (37.7614772360152, -122.450905959737) | |
25760 | 25760 | 223377 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2801 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010298.3381900005 | 2101037.92652 | 37.7496308398979 | -122.407188209083 | (37.7496308398979, -122.407188209083) | |||
26741 | 26741 | 126534 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1551 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008369.15173 | 2117857.28388 | 37.795704680394 | -122.415049773051 | (37.795704680394, -122.415049773051) | |||
26791 | 26791 | 223457 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 31 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998436.79798 | 2105994.15168 | 37.7625684428081 | -122.448562558536 | (37.7625684428081, -122.448562558536) | |||
26893 | 26893 | 31681 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 59 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35187 | 5998307.66476 | 2107187.9506099997 | 37.7658389290403 | -122.44909518650101 | (37.7658389290403, -122.449095186501) | |
27265 | 27265 | 207601 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5995608.85604 | 2090759.60342 | 37.720576034226 | -122.457241192545 | (37.720576034226, -122.457241192545) | |||
28935 | 28935 | 223424 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 115 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010291.05729 | 2100231.54093 | 37.7474162746512 | -122.407156552038 | (37.7474162746512, -122.407156552038) | |||
29080 | 29080 | 223542 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4112 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6001417.09599 | 2102930.9043099997 | 37.7543274674466 | -122.43803537522699 | (37.7543274674466, -122.438035375227) | |||
29914 | 29914 | 223374 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 14 Lundys Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007165.43911 | 2099578.0998299997 | 37.7454466559323 | -122.41791844039699 | (37.7454466559323, -122.417918440397) | |||
30399 | 30399 | 31893 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1997 12:00:00 AM | 8 | Permit Number 35323 | 6008432.94494 | 2108718.71395 | 37.770615950606704 | -122.41418216828501 | (37.7706159506067, -122.414182168285) | |
30930 | 30930 | 223427 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 357 Precita Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008897.95249 | 2100223.67255 | 37.747316608191 | -122.411973275956 | (37.747316608191, -122.411973275956) | |||
32189 | 32189 | 31714 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35214 | 5998115.883119999 | 2105983.06318 | 37.7625196419841 | -122.44967168249799 | (37.7625196419841, -122.449671682498) | |
33933 | 33933 | 207650 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1239 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992348.57689 | 2106988.87327 | 37.7649496901864 | -122.469691736987 | (37.7649496901864, -122.469691736987) | |||
34670 | 34670 | 185158 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985178.5125 | 2097636.1993 | 37.7388527871834 | -122.49380155463699 | (37.7388527871834, -122.493801554637) | |||
35578 | 35578 | 33334 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3360 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | 6x9 | Permit Number 37474 | 6004131.26666 | 2120719.53303 | 37.8033246198945 | -122.42991788581999 | (37.8033246198945, -122.42991788582) |
35823 | 35823 | 223628 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 286 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006719.8805 | 2102105.02561 | 37.7523599342706 | -122.419638369512 | (37.7523599342706, -122.419638369512) | |||
36570 | 36570 | 223663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 838 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001879.47646 | 2101560.4690900003 | 37.750590864394 | -122.436338275392 | (37.750590864394, -122.436338275392) | |||
36646 | 36646 | 191087 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6014377.05875 | 2105781.79588 | 37.762883905197 | -122.393415683687 | (37.762883905197, -122.393415683687) | ||||
38275 | 38275 | 191664 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013199.96962 | 2111004.76664 | 37.777159542827704 | -122.397853242637 | (37.7771595428277, -122.397853242637) | |||
39259 | 39259 | 223378 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2801 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010326.912769999 | 2101041.03112 | 37.7496409635678 | -122.407089615513 | (37.7496409635678, -122.407089615513) | |||
39459 | 39459 | 223403 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3624 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005621.17135 | 2101994.19422 | 37.7519936655859 | -122.423430010205 | (37.7519936655859, -122.423430010205) | |||
39940 | 39940 | 126545 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008151.874919999 | 2119410.8388 | 37.799958143615704 | -122.41591165898899 | (37.7999581436157, -122.415911658989) | |||
40998 | 40998 | 223441 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 400 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003293.90646 | 2098651.4975400004 | 37.742683773149 | -122.431239447646 | (37.742683773149, -122.431239447646) | |||
41611 | 41611 | 223487 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 315 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6006838.49776 | 2096321.93409 | 37.7364875458659 | -122.41881806641899 | (37.7364875458659, -122.418818066419) | |||
42731 | 42731 | 140303 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 154 COLE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997832.4894 | 2110000.3166 | 37.773533777498606 | -122.450941522503 | (37.7735337774986, -122.450941522503) | |||
42733 | 42733 | 114649 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001565.302999999 | 2113942.4968 | 37.7845709964296 | -122.43831167213001 | (37.7845709964296, -122.43831167213) | |||
43225 | 43225 | 191064 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Clara St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011636.45479 | 2111621.6337599996 | 37.778766120497295 | -122.403305371746 | (37.7787661204973, -122.403305371746) | |||
43488 | 43488 | 191089 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 150 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012552.521790001 | 2106660.8958 | 37.765196177289205 | -122.39978789390601 | (37.7651961772892, -122.399787893906) | |||
50577 | 50577 | 191067 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 374 06th St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011934.76855 | 2111785.94153 | 37.779233928048 | -122.402284937117 | (37.779233928048, -122.402284937117) | |||
54790 | 54790 | 207545 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1243 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994515.71143 | 2107079.97224 | 37.7653248424019 | -122.462202826907 | (37.7653248424019, -122.462202826907) | |||
56302 | 56302 | 126535 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1551 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008372.45938 | 2117840.81731 | 37.7956596531341 | -122.41503716185301 | (37.7956596531341, -122.415037161853) | |||
57190 | 57190 | 41945 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 653 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 8 | Permit Number 42303 | 5993457.880580001 | 2111001.78107 | 37.7760321220276 | -122.466146606961 | (37.7760321220276, -122.466146606961) | |
57346 | 57346 | 223568 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 500 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007653.2155 | 2095688.14958 | 37.7347931520797 | -122.415956366103 | (37.7347931520797, -122.415956366103) | |||
58907 | 58907 | 74852 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1660 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 8 | 6009221.87688 | 2119018.0672 | 37.7989397873109 | -122.412181258567 | (37.7989397873109, -122.412181258567) | ||
60642 | 60642 | 42138 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 579 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 8 | Permit Number 42433 | 5991254.316269999 | 2111466.88915 | 37.7771818025968 | -122.473803180798 | (37.7771818025968, -122.473803180798) | |
61565 | 61565 | 223404 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3638 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005519.51135 | 2101987.48205 | 37.7519694971987 | -122.423781088428 | (37.7519694971987, -122.423781088428) | |||
61749 | 61749 | 223367 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3450 26th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6006755.66784 | 2100887.58392 | 37.7490191327351 | -122.41942824923099 | (37.7490191327351, -122.419428249231) | |||
62686 | 62686 | 67384 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 632 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1992 12:00:00 AM | 8 | Permit Number 30880 | 5992568.1848 | 2111126.41775 | 37.7763229702913 | -122.469233345827 | (37.7763229702913, -122.469233345827) | |
62720 | 62720 | 207622 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995492.16828 | 2107225.03182 | 37.7657793129775 | -122.458836016967 | (37.7657793129775, -122.458836016967) | |||
65274 | 65274 | 223545 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 219 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004195.70944 | 2096761.73033 | 37.737545967881495 | -122.427986637589 | (37.7375459678815, -122.427986637589) | |||
65496 | 65496 | 224055 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3810 20th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6004350.69854 | 2104285.65184 | 37.7582136808258 | -122.427986763479 | (37.7582136808258, -122.427986763479) | |||
66798 | 66798 | 223406 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 201 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005448.95671 | 2102484.16065 | 37.75332927843721 | -122.424060394494 | (37.7533292784372, -122.424060394494) | |||
68555 | 68555 | 223586 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 490 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007563.6657 | 2096555.6427099998 | 37.7371700629347 | -122.41632739489599 | (37.7371700629347, -122.416327394896) | |||
70477 | 70477 | 114651 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001524.5433 | 2113938.4711 | 37.7845576244995 | -122.43845239809299 | (37.7845576244995, -122.438452398093) | |||
70812 | 70812 | 176244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011881.091109999 | 2090360.91966 | 37.720402471380204 | -122.400964878027 | (37.7204024713802, -122.400964878027) | |||
70880 | 70880 | 126536 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1859 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006939.28013 | 2117655.3637200003 | 37.7950698030789 | -122.419983060779 | (37.7950698030789, -122.419983060779) | |||
72314 | 72314 | 223584 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 490 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6007520.48154 | 2096559.30623 | 37.737177693694704 | -122.416476962041 | (37.7371776936947, -122.416476962041) | |||
74948 | 74948 | 176246 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.72037180809671 | -122.401081316846 | (37.7203718080967, -122.401081316846) | |||
75244 | 75244 | 191090 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 150 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012554.60334 | 2106645.79178 | 37.765154821059 | -122.399779633629 | (37.765154821059, -122.399779633629) | |||
75359 | 75359 | 223476 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 219 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006570.2994 | 2095821.46125 | 37.7350982533824 | -122.419709844034 | (37.7350982533824, -122.419709844034) | |||
75663 | 75663 | 207649 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992350.24318 | 2107007.29573 | 37.765000369682205 | -122.469687315036 | (37.7650003696822, -122.469687315036) | |||
79689 | 79689 | 95859 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 130 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5993374.31334 | 2114625.40648 | 37.78597679306171 | -122.466699148127 | (37.7859767930617, -122.466699148127) | |||
81794 | 81794 | 40252 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/13/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41415 | 6006702.84210434 | 2102592.14346256 | 37.7536964884672 | -122.419731851285 | (37.7536964884672, -122.419731851285) |
83076 | 83076 | 103366 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 290X Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 769396 | 6006718.6 | 2102097.0 | 37.7523378256517 | -122.41964222832199 | (37.7523378256517, -122.419642228322) | ||
89491 | 89491 | 63370 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 393 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1987 12:00:00 AM | 8 | 3x3 | Permit Number 23949 | 6007368.29978773 | 2095756.91555198 | 37.734965945742395 | -122.416946291173 | (37.7349659457424, -122.416946291173) | |
117343 | 117343 | 98974 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
121120 | 121120 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 748 Treat Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 8 | 3x3 | 6008496.2 | 2104169.0 | 37.758127039951205 | -122.41364151852801 | (37.7581270399512, -122.413641518528) | |||
129795 | 129795 | 141025 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998165.4308 | 2112645.9232 | 37.780816982450105 | -122.449980546707 | (37.7808169824501, -122.449980546707) | |||
129832 | 129832 | 223452 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998137.72031 | 2105984.6438 | 37.762525231268704 | -122.44959626987301 | (37.7625252312687, -122.449596269873) | |||
131674 | 131674 | 126533 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1551 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008367.412269999 | 2117875.57513 | 37.7957548058969 | -122.41505708724199 | (37.7957548058969, -122.415057087242) | |||
131823 | 131823 | 31713 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 43549 | 5998153.78946 | 2105987.36259 | 37.762533615662704 | -122.44954088871 | (37.7625336156627, -122.44954088871) | |
132325 | 132325 | 223637 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006705.76334 | 2102387.84087 | 37.7531356849695 | -122.419707254007 | (37.7531356849695, -122.419707254007) | |||
135952 | 135952 | 43032 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2111 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2000 12:00:00 AM | 8 | Permit Number 42893 | 6012270.45394 | 2101364.96859 | 37.750638997909604 | -122.40039148918501 | (37.7506389979096, -122.400391489185) | ||
136213 | 136213 | 207661 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1205 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996709.68526 | 2107252.63916 | 37.7659250229495 | -122.45462690381599 | (37.7659250229495, -122.454626903816) | |||
140919 | 140919 | 60458 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 64 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | 8 | 3x3 | Permit Number 20044 | 5997231.487462901 | 2089612.30707346 | 37.717518885545005 | -122.45154958496201 | (37.717518885545, -122.451549584962) |
141815 | 141815 | 98973 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
144170 | 144170 | 49493 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
147450 | 147450 | 223644 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3266 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008388.34903 | 2104490.30808 | 37.759003221729 | -122.41403724522101 | (37.759003221729, -122.414037245221) | |||
150681 | 150681 | 126519 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 250 Alhambra St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6000986.5183 | 2120044.44522 | 37.8012924164688 | -122.440751917771 | (37.8012924164688, -122.440751917771) | |||
151484 | 151484 | 224092 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 262 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004449.56008 | 2109136.25999 | 37.771537880690005 | -122.42799050647899 | (37.77153788069, -122.427990506479) | |||
153945 | 153945 | 68221 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1320 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 8 | Permit Number 32011 | 5991372.40112 | 2113442.77696 | 37.782613885971706 | -122.473538854201 | (37.7826138859717, -122.473538854201) | |
154882 | 154882 | 64884 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2550 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/1989 12:00:00 AM | 8 | Permit Number 25910 | 5989263.5772 | 2097984.1265 | 37.7400462586589 | -122.47970291667801 | (37.7400462586589, -122.479702916678) | |
157367 | 157367 | 207656 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1331 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5994848.43771 | 2106461.0106900004 | 37.763644487022795 | -122.461007146788 | (37.7636444870228, -122.461007146788) | |||
158780 | 158780 | 31661 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4812 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35169 | 5998134.627069999 | 2105673.0184299997 | 37.761669409447705 | -122.44958451213499 | (37.7616694094477, -122.449584512135) | |
162446 | 162446 | 120821 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5989570.27097 | 2114621.23399 | 37.785745070127504 | -122.47985964308799 | (37.7857450701275, -122.479859643088) | |||
167865 | 167865 | 223442 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 400 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003266.99586 | 2098649.35837 | 37.742676374416 | -122.431332344034 | (37.742676374416, -122.431332344034) | |||
168779 | 168779 | 67275 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 282 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1992 12:00:00 AM | 8 | Permit Number 30749 | 6004343.26025 | 2091654.32947 | 37.7235305328868 | -122.427112803239 | (37.7235305328868, -122.427112803239) | |
171060 | 171060 | 223402 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3600 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005679.726980001 | 2101995.97902 | 37.752001871001205 | -122.423227642937 | (37.7520018710012, -122.423227642937) | |||
172784 | 172784 | 191062 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Clara St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011643.64166 | 2111627.47024 | 37.7787825475055 | -122.40328092009399 | (37.7787825475055, -122.403280920094) | |||
174179 | 174179 | 224098 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6002523.84844 | 2101397.51058 | 37.7501800108976 | -122.434098340276 | (37.7501800108976, -122.434098340276) | |||
176210 | 176210 | 207654 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1279 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992358.22699 | 2106733.7624 | 37.7642497811258 | -122.469639786754 | (37.7642497811258, -122.469639786754) | |||
179313 | 179313 | 207614 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 218 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997036.49742 | 2089508.9624599998 | 37.7172239569865 | -122.452216120002 | (37.7172239569865, -122.452216120002) | |||
179524 | 179524 | 126517 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3835 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000579.5194 | 2121468.07283 | 37.8051781307269 | -122.44226256568001 | (37.8051781307269, -122.44226256568) | |||
180710 | 180710 | 223475 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006730.85862 | 2095808.36248 | 37.735071330371106 | -122.419153803122 | (37.7350713303711, -122.419153803122) | |||
182751 | 182751 | 223539 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1661 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6003387.19904 | 2098534.7214900004 | 37.742368419572294 | -122.43090853672301 | (37.7423684195723, -122.430908536723) | |||
185922 | 185922 | 223412 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1726 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009299.39544 | 2099281.89074 | 37.7447531977014 | -122.410518617161 | (37.7447531977014, -122.410518617161) | |||
186820 | 186820 | 191108 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2251 24th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011748.829919999 | 2102300.63955 | 37.753179044 | -122.40226109699499 | (37.753179044, -122.402261096995) | |||
187416 | 187416 | 223524 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4120 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002344.76473 | 2101815.8426099997 | 37.751318486070396 | -122.434747532969 | (37.7513184860704, -122.434747532969) | |||
187770 | 187770 | 33945 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.7642900003 | 37.799801537482296 | -122.42753193854601 | (37.7998015374823, -122.427531938546) | |
188172 | 188172 | 224064 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 253 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999797.090969999 | 2105500.9321 | 37.761291869548 | -122.44382237682301 | (37.761291869548, -122.443822376823) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");