trees

467 rows where Police Districts = 7 and qSpecies_id = 8 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Police 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
2450 251744 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 70 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002620 2086992 37.710631205907 -122.432736905509 (37.710631205907, -122.432736905509) 9 7 6 28861 5
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
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
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
17189 39942 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 27 Ervine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/1999 12:00:00 AM     Permit Number 41213 6009741.23684285 2089425.45829631 37.7177142900305 -122.408295747981 (37.7177142900305, -122.408295747981) 9 7 8 309 39
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
23922 58026 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 680 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/26/1987 12:00:00 AM     Permit Number 16994 6008648.68681502 2095709.61951023 37.7349080209093 -122.412516183192 (37.7349080209093, -122.412516183192) 10 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
27608 251772 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 90x Seville St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002045 2087474 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533) 9 7 6 28861 5
29323 84791 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 499x Lisbon St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2007 12:00:00 AM     Permit No. 49321 6002176 2090606 37.7205292596373 -122.434529703705 (37.7205292596373, -122.434529703705) 9 7 6 28861 5
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
30876 88307 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 401 Amazon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51301 6001480.2 2088981.7 37.7160297722944 -122.436818641634 (37.7160297722944, -122.436818641634) 9 7 6 28861 5
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
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
33032 95765 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 200 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767501 6004737 2091251 37.7224453364084 -122.425723020763 (37.7224453364084, -122.425723020763) 9 7 6 28861 5
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
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
39029 103456 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 410 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6003658 2091068 37.721881827041 -122.429439831937 (37.721881827041, -122.429439831937) 9 7 6 28861 5
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
44789 44020 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 67 Ruth St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2000 12:00:00 AM     Permit Number 43561 6001434.84212338 2091667.66659412 37.7234022554793 -122.437167620555 (37.7234022554793, -122.437167620555) 9 7 6 28861 25
45628 251771 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 90x Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002045 2087474 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533) 9 7 6 28861 5
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
46531 251773 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 90x Seville St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002045 2087474 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533) 9 7 6 28861 5
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
53101 34891 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 95 Ward St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1997 12:00:00 AM     Permit Number 38498 6011846.48740204 2089823.39477464 37.7189246067483 -122.401046743519 (37.7189246067483, -122.401046743519) 10 7 8 309 39
53756 251780 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1219 Naples St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001110 2087312 37.7114241006266 -122.437978695611 (37.7114241006266, -122.437978695611) 9 7 6 28861 5
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
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
63637 95714 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 649 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767469 6004402.3 2092291.6 37.7252836757454 -122.426954078943 (37.7252836757454, -122.426954078943) 9 7 6 28861 5
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
71396 66453 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 125 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29603 6009081.83261092 2097914.76259057 37.7409871642392 -122.411174357607 (37.7409871642392, -122.411174357607) 10 7 7 28859 2
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
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
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
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
80662 88308 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 401 Amazon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51301 6001480.2 2088981.7 37.7160297722944 -122.436818641634 (37.7160297722944, -122.436818641634) 9 7 6 28861 5
82021 88310 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 401 Amazon Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51301 6001480.2 2088981.7 37.7160297722944 -122.436818641634 (37.7160297722944, -122.436818641634) 9 7 6 28861 5
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
87911 251759 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 248 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001757 2086582 37.7094564535298 -122.43569030601 (37.7094564535298, -122.43569030601) 9 7 6 28861 5
88741 40429 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 516 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1999 12:00:00 AM     Permit Number 41524 6002015.10880124 2090488.09848269 37.7201963938126 -122.435077424443 (37.7201963938126, -122.435077424443) 9 7 6 28861 5
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
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
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
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
106857 111194 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 890x JARBOE AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM   3x3 Permit Number 774267 6009115 2096842 37.7380434517433 -122.410983924329 (37.7380434517433, -122.410983924329) 10 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
111574 88309 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 401 Amazon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51301 6001480.2 2088981.7 37.7160297722944 -122.436818641634 (37.7160297722944, -122.436818641634) 9 7 6 28861 5
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
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
117533 95391 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 529 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767260 6002482 2099437 37.7447945350785 -122.434102922936 (37.7447945350785, -122.434102922936) 2 7 5 63 22
118483 81870 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 57 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2008 12:00:00 AM   3x3 Permit Number 50229 6008272.40622301 2100066.89947631 37.746851028213 -122.414125287136 (37.746851028213, -122.414125287136) 2 7 7 28859 2
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
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
127843 64026 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 907 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1987 12:00:00 AM     Permit Number 24783 6008326.13361224 2095676.92812978 37.7348001501968 -122.413629054856 (37.7348001501968, -122.413629054856) 10 7 7 28859 2
135101 83726 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 219 Miguel St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50486 6004171.06042013 2096811.82293441 37.7376821162511 -122.428075429636 (37.7376821162511, -122.428075429636) 2 7 5 63 7
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
138025 31017 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1200 Naples St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM     Permit Number 34784 6001138.87641909 2087503.16195668 37.7119506311233 -122.437892574784 (37.7119506311233, -122.437892574784) 9 7 6 28861 5
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
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
143396 84789 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 499x Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2007 12:00:00 AM     Permit No. 49321 6002176 2090606 37.7205292596373 -122.434529703705 (37.7205292596373, -122.434529703705) 9 7 6 28861 5
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
148006 60514 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1551 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1982 12:00:00 AM     Permit Number 20115 6004602.91474331 2099861.26634292 37.7460796156332 -122.426799407471 (37.7460796156332, -122.426799407471) 2 7 5 63 22
148740 42130 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 166 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2011 12:00:00 AM     Permit Number 767992 5998983.29782445 2093814.78501268 37.7291580818069 -122.445796466287 (37.7291580818069, -122.445796466287) 9 7 4 28861 40
149374 63458 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 48 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/17/1987 12:00:00 AM     Permit Number 24049 6007171.84075647 2095576.51841089 37.7344595618195 -122.417612739346 (37.7344595618195, -122.417612739346) 2 7 7 28859 2
149441 64269 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1663 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1988 12:00:00 AM     Permit Number 25072 6009753.58464886 2100137.8418766 37.7471289041039 -122.409008493901 (37.7471289041039, -122.409008493901) 2 7 7 28859 2
150769 56599 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 548 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50484 6003117.57249137 2096080.2960431 37.7356138508419 -122.43166562739 (37.7356138508419, -122.43166562739) 2 7 5 63 7
152919 96071 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1514 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2011 12:00:00 AM   3x3 Permit Number 767695 6010091 2100531 37.7482273255229 -122.407869453177 (37.7482273255229, -122.407869453177) 2 7 7 28859 2

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