trees

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

✎ 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
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
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
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
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
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
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
21456 34943 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3968 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2016 12:00:00 AM 3   Permit Number 775333 6003347.35755113 2102457.99102165 37.7531385434777 -122.43132628846 (37.7531385434777, -122.43132628846) 2 4 5 28862 22
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
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
30001 115382 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 625 Moultrie St 1 Side Yard : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 776180 6007689.5 2096426.5 37.7368225406079 -122.415883184956 (37.7368225406079, -122.415883184956) 2 7 7 28859 2
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
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
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
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
35633 246625 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3300 Harrison St 3 Side Yard : Yard Tree Private 2     1     6009033.3388 2099395.8346 37.7450511430894 -122.411446641942 (37.7450511430894, -122.411446641942) 2 7 7 28859 2
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
38375 115384 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 324 Park St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 777467 6006881.6 2096254.2 37.7363039898307 -122.418664241464 (37.7363039898307, -122.418664241464) 2 7 7 28859 2
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
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
48911 32226 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1524 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1995 12:00:00 AM 10   Permit Number 35545 6008720.30382 2099880.58736 37.7463646038601 -122.412563325657 (37.7463646038601, -122.412563325657) 2 7 7 28859 2
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
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
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
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
77707 64130 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 650 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM 24   Permit Number 24901 6002310.61439363 2098891.53580323 37.7432870897096 -122.434656544552 (37.7432870897096, -122.434656544552) 2 7 5 63 22
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
95447 32498 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 676 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM 9   Permit Number 37003 6007391.76195 2095838.15833 37.7351903403438 -122.416870928073 (37.7351903403438, -122.416870928073) 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
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
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
103281 63387 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 181 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM 14   Permit Number 23968 6006281.90561253 2095847.6388786 37.735153881321 -122.420708784491 (37.735153881321, -122.420708784491) 2 7 7 28859 2
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
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
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
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
119604 50063 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 259 Liberty St 1 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
121321 63486 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 241 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/07/1987 12:00:00 AM     Permit Number 24081 6006644.95300973 2095817.32130171 37.7350910911062 -122.419451445549 (37.7350910911062, -122.419451445549) 2 7 7 28859 2
122980 107236 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 3326 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2015 12:00:00 AM     Permit Number 775776 6006851 2102663.4 37.7539004875763 -122.419224541208 (37.7539004875763, -122.419224541208) 2 4 7 28859 19
124282 35298 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 4128 24th St 1 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
124395 63322 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 319 Montcalm St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1987 12:00:00 AM     Permit Number 23895 6009664.87242413 2099573.52917991 37.7455744556115 -122.409275438791 (37.7455744556115, -122.409275438791) 2 7 7 28859 2
126421 64123 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 319 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24894 6003820.50853257 2099508.65029248 37.7450671453675 -122.429479723764 (37.7450671453675, -122.429479723764) 2 7 5 63 22
128906 37406 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1710 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45479 6002579.2352778 2100599.04049757 37.7479907436881 -122.433849744568 (37.7479907436881, -122.433849744568) 2 4 5 63 22
131404 62103 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 437 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22196 6006813.60805899 2101235.59554089 37.7499779567927 -122.419252574646 (37.7499779567927, -122.419252574646) 2 4 7 28859 19
131699 42906 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3270 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42819 6008379.96600066 2104491.21306208 37.7590052357633 -122.414066301806 (37.7590052357633, -122.414066301806) 2 4 7 28859 19
136898 63378 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 306 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23958 6006899.99608094 2095743.84196722 37.7349036948983 -122.418564459297 (37.7349036948983, -122.418564459297) 2 7 7 28859 2
140538 62115 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 455 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22217 6006819.18462488 2101134.94773993 37.7497019148816 -122.419226151887 (37.7497019148816, -122.419226151887) 2 4 7 28859 19
140555 99879 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 76 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2012 12:00:00 AM     Permit Number 768149 6004987.5 2096139.2 37.7358814033012 -122.425204756431 (37.7358814033012, -122.425204756431) 2 7 5 28859 2
141294 51961 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2680 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2005 12:00:00 AM     Permit Number 48182 6002292.28789306 2096370.56832846 37.7363640576921 -122.434539697316 (37.7363640576921, -122.434539697316) 2 7 5 63 7
142445 32504 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM 9   Permit Number 37008 6007356.06097 2095755.17697 37.7349604835245 -122.416988482053 (37.7349604835245, -122.416988482053) 2 7 7 28859 2
143019 64122 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 330 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24893 6003743.68198418 2099556.50648257 37.7451941972726 -122.429748789002 (37.7451941972726, -122.429748789002) 2 7 5 63 22
146237 35565 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1021 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2003 12:00:00 AM     Permit Number 38935 6005771.77167049 2102851.56857317 37.7543563162185 -122.422970143174 (37.7543563162185, -122.422970143174) 2 4 5 28859 19
146738 32499 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 707 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM     Permit Number 37004 6007421.96096236 2095649.42060619 37.7346738065112 -122.416753152102 (37.7346738065112, -122.416753152102) 2 7 7 28859 2
147036 33049 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1259 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM     Permit Number 37325 6005839.09502219 2101642.93131356 37.7510414759561 -122.422651438228 (37.7510414759561, -122.422651438228) 2 4 5 28859 19

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