Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6880 | 6880 | 18913 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2612 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002139.88643 | 2115759.87525 | 37.789593716919704 | -122.43645393002599 | (37.7895937169197, -122.436453930026) | |||
9174 | 9174 | 6373 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2101 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000795.1374 | 2112740.1737 | 37.7812258903975 | -122.440889897719 | (37.7812258903975, -122.440889897719) | |||
10622 | 10622 | 15860 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 5366 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999545.5765 | 2088270.5652 | 37.7139670145471 | -122.44345454060199 | (37.7139670145471, -122.443454540602) | |||
14680 | 14680 | 26127 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1419 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6015993.0176 | 2094731.6994 | 37.7326322840804 | -122.38705584245199 | (37.7326322840804, -122.387055842452) | |||
14946 | 14946 | 26611 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1485 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1998 12:00:00 AM | 12 | 3X3 | 6011726.3053 | 2092603.41849 | 37.7265512783073 | -122.401657461237 | (37.7265512783073, -122.401657461237) | ||
15994 | 15994 | 26106 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1539X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2000 12:00:00 AM | 12 | 3x3 | 6015355.6491 | 2095208.8603 | 37.733907157322605 | -122.389292708309 | (37.7339071573226, -122.389292708309) | ||
16117 | 16117 | 26556 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 228 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/1998 12:00:00 AM | 12 | 3x3 | 6011088.04001 | 2099355.12223 | 37.7450543887552 | -122.404338947303 | (37.7450543887552, -122.404338947303) | ||
16121 | 16121 | 26100 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1577 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015169.8802 | 2095341.3169 | 37.7342605555935 | -122.38994422273198 | (37.7342605555935, -122.389944222732) | |||
16567 | 16567 | 26102 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015232.536 | 2095297.3479 | 37.73414330023979 | -122.389724529704 | (37.7341433002398, -122.389724529704) | |||
19983 | 19983 | 4397 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1011 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004431.54351 | 2102978.61798 | 37.7546294472032 | -122.427614046667 | (37.7546294472032, -122.427614046667) | |||
20683 | 20683 | 12972 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001913.39953 | 2095585.0292900002 | 37.734185633051894 | -122.435793484091 | (37.7341856330519, -122.435793484091) | |||
21318 | 21318 | 27510 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1259 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6005834.02618 | 2101632.44152 | 37.751012387419706 | -122.422668221463 | (37.7510123874197, -122.422668221463) | |||
25939 | 25939 | 223572 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 801 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008169.79 | 2095684.73442 | 37.7348128040698 | -122.414170142558 | (37.7348128040698, -122.414170142558) | |||
26513 | 26513 | 207686 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990741.806609999 | 2098714.09627 | 37.742136330634 | -122.474645120982 | (37.742136330634, -122.474645120982) | |||
27448 | 27448 | 223517 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 980 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999663.10864 | 2101754.10727 | 37.7509963650963 | -122.44401653863001 | (37.7509963650963, -122.44401653863) | |||
29434 | 29434 | 223375 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 12 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006422.52922 | 2105783.74221 | 37.7624440827408 | -122.42092782106 | (37.7624440827408, -122.42092782106) | |||
29785 | 29785 | 223507 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006548.17508 | 2102589.95451 | 37.7536817641104 | -122.42026657024401 | (37.7536817641104, -122.420266570244) | |||
33533 | 33533 | 223540 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1661 Noe St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6003385.2005900005 | 2098555.09449 | 37.7424242458904 | -122.43091690040701 | (37.7424242458904, -122.430916900407) | |||
36003 | 36003 | 224038 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4079 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003358.63467 | 2101239.00379 | 37.749792130611894 | -122.431200287561 | (37.7497921306119, -122.431200287561) | |||
44765 | 44765 | 246572 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6005238.2187 | 2109262.1859999998 | 37.7719282296287 | -122.42527145302601 | (37.7719282296287, -122.425271453026) | |||
46904 | 46904 | 207555 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1353 07th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993925.107890001 | 2106274.71202 | 37.763079784713604 | -122.46418710545099 | (37.7630797847136, -122.464187105451) | |||
51462 | 51462 | 191085 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6014420.63086 | 2105780.4317900003 | 37.762882580487 | -122.393264886285 | (37.762882580487, -122.393264886285) | ||||
53704 | 53704 | 64964 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1649 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 12 | Permit Number 25999 | 6005045.106240001 | 2119511.2308099996 | 37.8000586419391 | -122.42666941405899 | (37.8000586419391, -122.426669414059) | |
54980 | 54980 | 207548 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1329 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993918.37336 | 2106436.18995 | 37.7635227727814 | -122.464222121451 | (37.7635227727814, -122.464222121451) | |||
56564 | 56564 | 223462 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 801 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998613.88681 | 2107552.61 | 37.766857700856 | -122.44806229174601 | (37.766857700856, -122.448062291746) | |||
56710 | 56710 | 207685 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2431 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990740.98987 | 2098842.82853 | 37.7424897489131 | -122.47465733828501 | (37.7424897489131, -122.474657338285) | |||
57080 | 57080 | 223538 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1661 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6003388.52326 | 2098515.37807 | 37.742315382040005 | -122.430902577793 | (37.74231538204, -122.430902577793) | |||
57297 | 57297 | 176254 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011871.08574 | 2089770.5771299999 | 37.718780952366096 | -122.400958007209 | (37.7187809523661, -122.400958007209) | |||
57316 | 57316 | 200715 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1463 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6015932.4229 | 2095126.9778 | 37.7337142836816 | -122.387292898181 | (37.7337142836816, -122.387292898181) | |||
58343 | 58343 | 223508 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 23rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006568.19765 | 2102592.69577 | 37.753690419196 | -122.42019752212099 | (37.753690419196, -122.420197522121) | |||
60019 | 60019 | 223396 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6006003.81464 | 2104993.73555 | 37.76025129906861 | -122.42231986997 | (37.7602512990686, -122.42231986997) | |||
62352 | 62352 | 72297 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 463 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | 6002248.50751 | 2090769.44278 | 37.7209821527804 | -122.43429074752301 | (37.7209821527804, -122.434290747523) | ||
63158 | 63158 | 223392 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 35 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6005261.50146 | 2105224.90356 | 37.7608441312586 | -122.424903631195 | (37.7608441312586, -122.424903631195) | |||
70985 | 70985 | 223439 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 391 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6003417.4163 | 2098613.9262200003 | 37.7425876095457 | -122.430809705719 | (37.7425876095457, -122.430809705719) | |||
72076 | 72076 | 223626 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 324 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006742.14463 | 2101694.44585 | 37.7512338301811 | -122.419532249527 | (37.7512338301811, -122.419532249527) | |||
74122 | 74122 | 55804 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1631 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1973 12:00:00 AM | 12 | Permit Number 11848 | 6005137.19925 | 2119177.96133 | 37.79914877534139 | -122.42632699542 | (37.7991487753414, -122.42632699542) | ||
74156 | 74156 | 223622 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 451 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006808.3932300005 | 2101170.9079 | 37.7498000455516 | -122.419266019623 | (37.7498000455516, -122.419266019623) | |||
75839 | 75839 | 223600 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6007768.16924 | 2106112.90661 | 37.76342365039 | -122.41629704999399 | (37.76342365039, -122.416297049994) | |||
76856 | 76856 | 224044 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4723 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000124.85335 | 2104609.2479 | 37.7588622143265 | -122.442624763133 | (37.7588622143265, -122.442624763133) | |||
78633 | 78633 | 66232 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 218 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | 12 | Permit Number 29329 | 5997099.27039938 | 2089468.87131755 | 37.7171174718407 | -122.451996253737 | (37.7171174718407, -122.451996253737) | |
101323 | 101323 | 63418 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 801 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1987 12:00:00 AM | 12 | 3x3 | Permit Number 24001 | 6008135.77579227 | 2095692.82463993 | 37.7348331074336 | -122.414288314039 | (37.7348331074336, -122.414288314039) |
104281 | 104281 | 105752 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 67 LANDERS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6004519.3 | 2107402.1 | 37.766780241717896 | -122.42762569898399 | (37.7667802417179, -122.427625698984) | |||
111526 | 111526 | 63371 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 383 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1987 12:00:00 AM | 12 | 3x3 | Permit Number 23950 | 6007315.99222237 | 2095761.28369901 | 37.7349749972264 | -122.417127446777 | (37.7349749972264, -122.417127446777) | |
121032 | 121032 | 4390 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 56 Chilton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | |||
130480 | 130480 | 224045 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 118 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6000330.71148 | 2104908.09647 | 37.7596945117222 | -122.44193426187799 | (37.7596945117222, -122.441934261878) | |||
131236 | 131236 | 224060 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 191 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001739.33994 | 2107707.04853 | 37.767459917456996 | -122.437262937651 | (37.767459917457, -122.437262937651) | |||
142650 | 142650 | 4333 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 5X Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001761.4698131 | 2095822.8308426999 | 37.7348299498779 | -122.43633576569799 | (37.7348299498779, -122.436335765698) | |||
143478 | 143478 | 64120 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 318 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | 12 | Permit Number 24891 | 6003817.65498965 | 2099560.57193818 | 37.745209548627 | -122.42949329292 | (37.745209548627, -122.42949329292) | |
147511 | 147511 | 223608 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3336 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006799.35896 | 2102646.46368 | 37.753851075890495 | -122.419401926961 | (37.7538510758905, -122.419401926961) | |||
149252 | 149252 | 207663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1201 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5996706.11666 | 2107295.5599599998 | 37.76604266777311 | -122.454642347884 | (37.7660426677731, -122.454642347884) | |||
150196 | 150196 | 64563 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/1988 12:00:00 AM | 12 | Permit Number 25455 | 6009863.09945 | 2117549.8357 | 37.794944341360605 | -122.409858709005 | (37.7949443413606, -122.409858709005) | |
150389 | 150389 | 223640 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006698.01233 | 2102508.6219599997 | 37.7534668855122 | -122.41974262792601 | (37.7534668855122, -122.419742627926) | |||
150910 | 150910 | 126495 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2700 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6000053.14506 | 2117822.05774 | 37.7951371326294 | -122.44382203238001 | (37.7951371326294, -122.44382203238) | |||
157348 | 157348 | 223473 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 260 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6006678.29672 | 2095767.0259099999 | 37.7349548690689 | -122.41933259734199 | (37.7349548690689, -122.419332597342) | |||
159264 | 159264 | 191112 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2121 24th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012137.40992 | 2102323.8212900003 | 37.7532643788521 | -122.40091892986099 | (37.7532643788521, -122.400918929861) | |||
163432 | 163432 | 223485 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6009074.65326 | 2097933.54072 | 37.741038322247704 | -122.411200507415 | (37.7410383222477, -122.411200507415) | |||
167238 | 167238 | 223523 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 472 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002077.68113 | 2100921.8810099997 | 37.7488487129938 | -122.43560718863199 | (37.7488487129938, -122.435607188632) | |||
167475 | 167475 | 65612 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 676 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 12 | Permit Number 28517 | 6002045.90134 | 2090021.05349 | 37.718915740944794 | -122.434937601102 | (37.7189157409448, -122.434937601102) | |
172656 | 172656 | 207549 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1329 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993919.81303 | 2106419.06836 | 37.7634758443473 | -122.464215899053 | (37.7634758443473, -122.464215899053) | |||
173735 | 173735 | 61781 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2121 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/1985 12:00:00 AM | 12 | Permit Number 21856 | 6012125.65384 | 2102323.1371400002 | 37.753261844557706 | -122.40095953697201 | (37.7532618445577, -122.400959536972) | |
176317 | 176317 | 223615 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 408 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006795.31694 | 2101399.5635599997 | 37.7504271455035 | -122.419327456816 | (37.7504271455035, -122.419327456816) | |||
176945 | 176945 | 223646 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3434 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006604.84709 | 2105555.01905 | 37.7618263375482 | -122.420281015175 | (37.7618263375482, -122.420281015175) | |||
178848 | 178848 | 223388 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 79 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6005277.224909999 | 2104948.4923799997 | 37.7600860594465 | -122.424829585516 | (37.7600860594465, -122.424829585516) | |||
179399 | 179399 | 223516 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3372 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005877.44246 | 2103762.05553 | 37.7568622641928 | -122.42266940406401 | (37.7568622641928, -122.422669404064) | |||
180532 | 180532 | 223599 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6007767.1377 | 2106084.40018 | 37.763345320342495 | -122.41629859860501 | (37.7633453203425, -122.416298598605) | |||
184033 | 184033 | 224099 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6003688.866090001 | 2098162.22587 | 37.7413627203269 | -122.42983890015101 | (37.7413627203269, -122.429838900151) | |||
184233 | 184233 | 223598 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 304 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6007773.137630001 | 2106049.50965 | 37.763249856425396 | -122.41627537542 | (37.7632498564254, -122.41627537542) | |||
185115 | 185115 | 207576 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1245 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5993280.81145 | 2107003.85945 | 37.765044675683704 | -122.46646848852899 | (37.7650446756837, -122.466468488529) | |||
185386 | 185386 | 207687 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2479 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990748.39034 | 2098537.74279 | 37.7416524908805 | -122.474609488939 | (37.7416524908805, -122.474609488939) | |||
185693 | 185693 | 223509 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 23rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006634.2551 | 2102596.1896900004 | 37.7537037345613 | -122.41996932812201 | (37.7537037345613, -122.419969328122) | |||
187351 | 187351 | 207566 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1465 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993331.08215 | 2105529.0811799997 | 37.7609982220075 | -122.466187433302 | (37.7609982220075, -122.466187433302) | |||
188820 | 188820 | 244490 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1316 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000139.8345 | 2109225.3958 | 37.7715378614524 | -122.442904440425 | (37.7715378614524, -122.442904440425) |
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");