trees

534 rows where Fire Prevention Districts = 2 and qSpecies_id = 8 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
814 261435 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 371 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6007244 2095778 37.7350168462428 -122.417377534221 (37.7350168462428, -122.417377534221) 2 7 7 28859 2
1037 63388 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 139 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23969 6005989.66886949 2095872.0431692 37.7352044148911 -122.421720887046 (37.7352044148911, -122.421720887046) 2 7 7 28859 2
1327 261443 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 354 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007142 2095710 37.7348243937619 -122.417725367022 (37.7348243937619, -122.417725367022) 2 7 7 28859 2
2215 49868 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 368 Bosworth St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46634 6003577.84688999 2095267.92973361 37.7334093561858 -122.430016351279 (37.7334093561858, -122.430016351279) 2 7 5 28861 25
3218 84023 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 309 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 773233 6004808.26935881 2101900.57071737 37.7516906826671 -122.42623448013 (37.7516906826671, -122.42623448013) 2 4 5 28862 22
4370 38420 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1542 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42357 6004548.16357043 2099910.23270392 37.7462109701995 -122.426992216906 (37.7462109701995, -122.426992216906) 2 7 5 63 22
5257 62102 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 440 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22195 6006762.92692973 2101210.352632 37.7499057910946 -122.419426042368 (37.7499057910946, -122.419426042368) 2 4 7 28859 19
6250 261442 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 364 Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007175 2095707 37.7348180134015 -122.417611061749 (37.7348180134015, -122.417611061749) 2 7 7 28859 2
6331 261440 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 374x Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007239 2095686 37.7347639531109 -122.417388303298 (37.7347639531109, -122.417388303298) 2 7 7 28859 2
6487 261445 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 339 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007092 2095790 37.7350412423636 -122.417903903871 (37.7350412423636, -122.417903903871) 2 7 7 28859 2
7760 261189 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 599x Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007159 2095436 37.7340730065148 -122.41764717788 (37.7340730065148, -122.41764717788) 2 7 7 28859 2
8415 96169 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 45 Wool St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767802 6007419 2097998 37.7411223211925 -122.416929733801 (37.7411223211925, -122.416929733801) 2 7 7 28859 2
8997 47687 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1045 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2002 12:00:00 AM     Permit Number 45486 6003826.76338909 2102198.68251842 37.7524537008518 -122.429649915481 (37.7524537008518, -122.429649915481) 2 4 5 28862 22
9157 261444 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 350 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007112 2095712 37.7348281970622 -122.417829229388 (37.7348281970622, -122.417829229388) 2 7 7 28859 2
9542 261434 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 383 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6007317 2095771 37.7350017327518 -122.417124650781 (37.7350017327518, -122.417124650781) 2 7 7 28859 2
9689 63382 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 261 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23962 6006733.60001952 2095809.91850213 37.7350757572483 -122.41914443544 (37.7350757572483, -122.41914443544) 2 7 7 28859 2
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
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
12550 63379 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 311 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23959 6006965.60744401 2095790.54383517 37.7350356215507 -122.418340927554 (37.7350356215507, -122.418340927554) 2 7 7 28859 2
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
18040 33037 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 494 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37315 6006779.65662971 2100908.40918731 37.7490776652966 -122.41934677281 (37.7490776652966, -122.41934677281) 2 4 7 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
20012 63372 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 371 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23952 6007253.22314461 2095766.52547538 37.7349858586394 -122.417344833557 (37.7349858586394, -122.417344833557) 2 7 7 28859 2
24439 49859 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 338 Bosworth St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46630 6003649.21999567 2095274.80996329 37.7334322896584 -122.429770085042 (37.7334322896584, -122.429770085042) 2 7 5 28861 25
28255 39127 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 739 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40808 6007354.16846215 2103008.55652832 37.7548765329449 -122.417508922955 (37.7548765329449, -122.417508922955) 2 4 7 28859 19
29275 257895 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3644 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005306 2104928 37.7600314174308 -122.424728608314 (37.7600314174308, -122.424728608314) 2 4 5 28859 19
29773 63456 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 801 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/17/1987 12:00:00 AM     Permit Number 24046 6007615.99374583 2095696.52300413 37.7348140509231 -122.416085647719 (37.7348140509231, -122.416085647719) 2 7 7 28859 2
29985 59550 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 374 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24919 6003521.85163486 2098666.09972032 37.7427367824396 -122.43045232079 (37.7427367824396, -122.43045232079) 2 7 5 63 22
30499 83186 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3453 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50577 6006512.76900503 2105506.90807829 37.7616890471737 -122.420596061932 (37.7616890471737, -122.420596061932) 2 4 7 28859 19
31788 64128 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 627 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24899 6002528.44281747 2098851.45130448 37.7431893908467 -122.433900486749 (37.7431893908467, -122.433900486749) 2 7 5 63 7
31891 63321 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 308 Montcalm St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1987 12:00:00 AM     Permit Number 23894 6009704.28478725 2099627.84542916 37.7457258041449 -122.409142988334 (37.7457258041449, -122.409142988334) 2 7 7 28859 2
32577 35506 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3451 22nd St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38909 6005392.68349986 2103106.02983212 37.75503360932 -122.424299225131 (37.75503360932, -122.424299225131) 2 4 5 28859 19
32770 60516 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 273 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1982 12:00:00 AM     Permit Number 20119 6004763.14449697 2099853.52664846 37.7460674222913 -122.42624480255 (37.7460674222913, -122.42624480255) 2 7 5 63 22
33240 63451 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 329 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1987 12:00:00 AM   3x7 Permit Number 24039 6007051.75115976 2095783.35007581 37.7350207178849 -122.418042587516 (37.7350207178849, -122.418042587516) 2 7 7 28859 2
34948 63791 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 4079 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24477 6003353.40286408 2101237.77442121 37.7497884585709 -122.43121829162 (37.7497884585709, -122.43121829162) 2 4 5 28862 22
36552 37407 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1710 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39887 6002579.2352778 2100599.04049757 37.7479907436881 -122.433849744568 (37.7479907436881, -122.433849744568) 2 4 5 63 22
37767 35299 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 4128 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1998 12:00:00 AM     Permit Number 38772 6002342.17007059 2101820.0635556 37.7513299284774 -122.434756807393 (37.7513299284774, -122.434756807393) 2 4 5 28862 22
38466 49860 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 338 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46630 6003649.21999567 2095274.80996329 37.7334322896584 -122.429770085042 (37.7334322896584, -122.429770085042) 2 7 5 28861 25
38592 45299 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2 Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2001 12:00:00 AM     Permit Number 44138 6007485.11382992 2096559.26498899 37.7371755914125 -122.416599241748 (37.7371755914125, -122.416599241748) 2 7 7 28859 2
43045 63309 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 320 Montcalm St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1987 12:00:00 AM     Permit Number 23875 6009653.46041158 2099624.96602916 37.7457150505348 -122.409318529175 (37.7457150505348, -122.409318529175) 2 7 7 28859 2
43995 67217 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 412 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1992 12:00:00 AM     Permit Number 30673 6007859.73782149 2096940.24415247 37.7382427386023 -122.415330954317 (37.7382427386023, -122.415330954317) 2 7 7 28859 2
45695 64260 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 170 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/1988 12:00:00 AM     Permit Number 25062 6009914.7515977 2100087.93471467 37.7470008969248 -122.408447669408 (37.7470008969248, -122.408447669408) 2 7 7 28859 2
46240 49866 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 368 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46634 6003577.84688999 2095267.92973361 37.7334093561858 -122.430016351279 (37.7334093561858, -122.430016351279) 2 7 5 28861 25
46394 66647 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 972 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/25/2000 12:00:00 AM     Permit Number 29858 6010191.86940681 2103559.76448884 37.756549288119 -122.407734178809 (37.756549288119, -122.407734178809) 2 4 7 28859 19
47805 46326 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3649 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/2002 12:00:00 AM     Permit Number 44579 6005434.40207527 2102522.16800234 37.7534328160504 -122.424113430233 (37.7534328160504, -122.424113430233) 2 4 5 28859 19
48287 50062 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 259 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46792 6004623.22870051 2103939.22214247 37.7572778811094 -122.427019561527 (37.7572778811094, -122.427019561527) 2 4 5 28862 3
49203 63377 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 308 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23957 6006914.1385317 2095742.66094638 37.7349012482628 -122.418515480064 (37.7349012482628, -122.418515480064) 2 7 7 28859 2
49362 63315 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 391 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/1987 12:00:00 AM     Permit Number 23882 6009191.36429374 2100247.35620947 37.7473980957636 -122.410960347715 (37.7473980957636, -122.410960347715) 2 7 7 28859 2
51053 58102 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 251 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23965 6006689.2765112 2095813.61990221 37.7350834242778 -122.41929794049 (37.7350834242778, -122.41929794049) 2 7 7 28859 2
51264 49857 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 338 Bosworth St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46630 6003649.21999567 2095274.80996329 37.7334322896584 -122.429770085042 (37.7334322896584, -122.429770085042) 2 7 5 28861 25
53539 35777 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3528 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1998 12:00:00 AM     Permit Number 39032 6006085.57014843 2104950.10312581 37.7601361059974 -122.422034016017 (37.7601361059974, -122.422034016017) 2 4 5 28859 19
53859 63380 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 302 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23960 6006871.71117456 2095746.20400929 37.7349085881089 -122.41866241779 (37.7349085881089, -122.41866241779) 2 7 7 28859 2
55160 108690 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 61 OAKWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005327.5 2105108.8 37.7605290659119 -122.424667111807 (37.7605290659119, -122.424667111807) 2 4 5 28859 19
55466 52669 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 346@ SANCHEZ Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2006 12:00:00 AM     Permit Number 48750 6004271.44295602 2099877.18374076 37.7461045741604 -122.427946728117 (37.7461045741604, -122.427946728117) 2 7 5 63 22
55473 39119 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 552 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40804 6007242.03781645 2104093.13141214 37.7578482165395 -122.417973583722 (37.7578482165395, -122.417973583722) 2 4 7 28859 19
57637 63381 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 289 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23961 6006861.89612331 2095799.20465588 37.7350535636056 -122.418700109332 (37.7350535636056, -122.418700109332) 2 7 7 28859 2
59905 49865 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 368 Bosworth St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46634 6003577.84688999 2095267.92973361 37.7334093561858 -122.430016351279 (37.7334093561858, -122.430016351279) 2 7 5 28861 25
60323 64125 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 623 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24896 6002552.88374737 2098852.79748639 37.7431944740998 -122.433816072766 (37.7431944740998, -122.433816072766) 2 7 5 63 7
68249 56109 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3330 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22207 6006832.6652986 2102651.38828329 37.7538664735729 -122.419287095 (37.7538664735729, -122.419287095) 2 4 7 28859 19
68951 33009 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3616 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM     Permit Number 37303 6005672.83784214 2102003.77697796 37.752022893602 -122.423252020871 (37.752022893602, -122.423252020871) 2 4 5 28859 19
69549 63385 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 219 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23966 6006529.47672641 2095826.96456486 37.7351110645595 -122.419851373342 (37.7351110645595, -122.419851373342) 2 7 7 28859 2
70702 64142 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 387 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24915 6003450.8356786 2098610.10956553 37.7425790233006 -122.430693879032 (37.7425790233006, -122.430693879032) 2 7 5 63 22
70969 47557 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 206 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45420 6004100.72419306 2102141.4355601 37.7523120229359 -122.428698432782 (37.7523120229359, -122.428698432782) 2 4 5 28862 22
71264 47688 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1045 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2002 12:00:00 AM     Permit Number 45486 6003826.76338909 2102198.68251842 37.7524537008518 -122.429649915481 (37.7524537008518, -122.429649915481) 2 4 5 28862 22
72272 45790 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 399 Duncan St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2001 12:00:00 AM     Permit Number 44428 6003953.11185898 2099806.69128577 37.7458930039208 -122.429042450873 (37.7458930039208, -122.429042450873) 2 7 5 63 22
72718 64414 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 33 Harper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/1988 12:00:00 AM     Permit Number 25261 6003697.20020727 2098175.28884646 37.741399060208 -122.429811015213 (37.741399060208, -122.429811015213) 2 7 5 63 7
73700 46325 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3649 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2002 12:00:00 AM     Permit Number 56854 6005434.40207527 2102522.16800234 37.7534328160504 -122.424113430233 (37.7534328160504, -122.424113430233) 2 4 5 28859 19
74307 64143 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 461 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24917 6002822.78297859 2098575.51836339 37.7424484420328 -122.432863028806 (37.7424484420328, -122.432863028806) 2 7 5 63 22
75277 32838 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1414 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1996 12:00:00 AM     Permit Number 37193 6002529.48991502 2101462.27171946 37.7503581498404 -122.434083460627 (37.7503581498404, -122.434083460627) 2 4 5 28862 22
76450 64808 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 53 Newburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1989 12:00:00 AM     Permit Number 25810 6002470.46019505 2099868.65232966 37.745979096274 -122.434173677497 (37.745979096274, -122.434173677497) 2 7 5 63 22
76652 63384 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 259 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23964 6006724.73531603 2095810.6587823 37.7350772906705 -122.419175136454 (37.7350772906705, -122.419175136454) 2 7 7 28859 2
77062 63367 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 511 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1987 12:00:00 AM     Permit Number 23943 6007615.98725252 2095736.23144951 37.7349230812673 -122.4160884814 (37.7349230812673, -122.4160884814) 2 7 7 28859 2
78114 33048 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1192 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM     Permit Number 37324 6005740.26598795 2102030.16267757 37.7520991477767 -122.423020719371 (37.7520991477767, -122.423020719371) 2 4 5 28859 19
79670 64117 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 606 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24888 6002640.14988451 2098909.68283406 37.7433556196147 -122.433518394217 (37.7433556196147, -122.433518394217) 2 7 5 63 22
80336 62118 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 473 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22220 6006824.76119309 2101034.29989716 37.749425872837 -122.419199729312 (37.749425872837, -122.419199729312) 2 4 7 28859 19
82316 64027 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 700 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1987 12:00:00 AM     Permit Number 24784 6007920.33784852 2095628.68558962 37.7346448914343 -122.41502862166 (37.7346448914343, -122.41502862166) 2 7 7 28859 2
84014 60994 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 4126 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/25/1988 12:00:00 AM     Permit Number 25142 6003063.49787732 2100688.38010697 37.7482635177611 -122.432181564789 (37.7482635177611, -122.432181564789) 2 4 5 28862 22
86401 32839 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1414 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1996 12:00:00 AM     Permit Number 37193 6002529.48991502 2101462.27171946 37.7503581498404 -122.434083460627 (37.7503581498404, -122.434083460627) 2 4 5 28862 22
90088 63317 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 408 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/1987 12:00:00 AM     Permit Number 23884 6009379.46071943 2100205.52672578 37.7472937869951 -122.410306967571 (37.7472937869951, -122.410306967571) 2 7 7 28859 2
90393 38422 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1542 Church St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42357 6004548.16357043 2099910.23270392 37.7462109701995 -122.426992216906 (37.7462109701995, -122.426992216906) 2 7 5 63 22
92554 47689 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1045 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2002 12:00:00 AM     Permit Number 45486 6003826.76338909 2102198.68251842 37.7524537008518 -122.429649915481 (37.7524537008518, -122.429649915481) 2 4 5 28862 22
94376 63383 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 260 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23963 6006655.03075921 2095764.2987202 37.7349460704184 -122.419412842724 (37.7349460704184, -122.419412842724) 2 7 7 28859 2
96957 59269 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3438 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1991 12:00:00 AM     Permit Number 29732 6005419.26991324 2103743.28355655 37.7567848606038 -122.424252601663 (37.7567848606038, -122.424252601663) 2 4 5 28859 19
99906 61867 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1318 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/17/1999 12:00:00 AM     Permit Number 21907 6010305.63286425 2101528.54455683 37.7509783771367 -122.407197563662 (37.7509783771367, -122.407197563662) 2 4 7 28859 19
100320 48882 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 585 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2002 12:00:00 AM   3x3 Permit Number 46088 6002980.45045304 2095906.61168613 37.7351291798742 -122.432127311126 (37.7351291798742, -122.432127311126) 2 7 5 63 7
100404 48936 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2753 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/2002 12:00:00 AM     Permit Number 46124 6008970.19382594 2102433.57534311 37.7533885608678 -122.411879606442 (37.7533885608678, -122.411879606442) 2 4 7 28859 19
101299 84156 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 618-620 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2012 12:00:00 AM   3x3 Permit Number 769487 6007864.16010864 2104318.1275589 37.7585009983288 -122.415837950653 (37.7585009983288, -122.415837950653) 2 4 7 28859 19
101360 46327 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3649 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/2002 12:00:00 AM     Permit Number 44579 6005434.40207527 2102522.16800234 37.7534328160504 -122.424113430233 (37.7534328160504, -122.424113430233) 2 4 5 28859 19
105766 63386 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 211 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23967 6006484.78968372 2095830.6963139 37.7351187935179 -122.420006137563 (37.7351187935179, -122.420006137563) 2 7 7 28859 2
107540 42062 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1726 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42373 6009298.2802895 2099318.00641811 37.7448523008957 -122.410525022946 (37.7448523008957, -122.410525022946) 2 7 7 28859 2
107647 37400 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 4235 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39882 6002342.85662573 2101181.62217602 37.7495769587767 -122.434708784267 (37.7495769587767, -122.434708784267) 2 4 5 28862 22
112848 87757 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 375 Diamond St   Sidewalk: Curb side : Cutout Tree Private 2   05/27/2008 12:00:00 AM   3x3 Permit Number 50411 6001812 2103665 37.7563655677175 -122.436722244288 (37.7563655677175, -122.436722244288) 2 4 5 28862 3
113367 42063 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3125 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/2001 12:00:00 AM     Permit Number 44019 6008884.76165611 2100531.31488982 37.7481605856471 -122.412040626823 (37.7481605856471, -122.412040626823) 2 4 7 28859 2
113833 62113 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3435 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22214 6006889.06228658 2101433.18572997 37.7505247436869 -122.419005662389 (37.7505247436869, -122.419005662389) 2 4 7 28859 19
113952 82754 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 81 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2008 12:00:00 AM   3x3 Permit Number 50230 6008367.05322263 2100072.37489424 37.7468713781772 -122.413798392872 (37.7468713781772, -122.413798392872) 2 7 7 28859 2
114043 67041 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3862 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1992 12:00:00 AM     Permit Number 30420 6002678.14449025 2103591.98537254 37.7562142727984 -122.433721599504 (37.7562142727984, -122.433721599504) 2 4 5 28862 3
114458 88149 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 980 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2008 12:00:00 AM   3x3 Permit Number 51177 5999654.9 2101769.7 37.7510387106784 -122.444046045087 (37.7510387106784, -122.444046045087) 2 5 5 63 38
116048 62104 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 428-430 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/2016 12:00:00 AM   3x3 Permit Number 22197 6006759.20921855 2101277.45117643 37.7500898190298 -122.419443658065 (37.7500898190298, -122.419443658065) 2 4 7 28859 19
116525 67243 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 4356 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/31/1992 12:00:00 AM     Permit Number 30707 6001601.68859184 2100608.05575584 37.7479599763382 -122.437230700083 (37.7479599763382, -122.437230700083) 2 4 5 28862 22
116907 67855 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 340 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1993 12:00:00 AM     Permit Number 31525 6004308.51979611 2099879.32748922 37.7461125578998 -122.427818673872 (37.7461125578998, -122.427818673872) 2 7 5 63 22

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);