trees
2,421 rows where qSpecies_id = 8 sorted by DBH
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
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 | ||||
1004 | 50532 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47171 | 5996679.82856356 | 2106618.62344586 | 37.7641824656847 | -122.454684361894 | (37.7641824656847, -122.454684361894) | 15 | 5 | 11 | 29492 | 12 | |||
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 | ||||
1793 | 260413 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1510 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015825 | 2096697 | 37.7380192974637 | -122.387773802776 | (37.7380192974637, -122.387773802776) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||||
2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 10 | |||
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 | ||
3265 | 255205 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
4341 | 255207 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
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 | ||
4498 | 58438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | 15 | 5 | 11 | 29492 | 9 | ||
4693 | 255208 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
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 | ||
5548 | 64543 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25426 | 6015321.62159268 | 2095235.25021997 | 37.7339777321734 | -122.389412195042 | (37.7339777321734, -122.389412195042) | 10 | 3 | 8 | 58 | 1 | ||
5654 | 31560 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 178 Ewing Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1995 12:00:00 AM | Permit Number 35104 | 5998523.78697564 | 2112531.01963796 | 37.7805219856792 | -122.448732545056 | (37.7805219856792, -122.448732545056) | 15 | 6 | 2 | 54 | 16 | |||
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 | ||||
6315 | 46517 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 46010 | 6005209.24135079 | 2109497.7250609 | 37.7725733258296 | -122.425388452589 | (37.7725733258296, -122.425388452589) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||||
7451 | 255209 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
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 | ||||
8207 | 47474 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
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 | |
8593 | 91087 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207 | 2088764 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
9047 | 47479 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
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 | ||||
11137 | 46998 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
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 | ||||
11678 | 262547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014600.2068 | 2090881.6643 | 37.7219836364279 | -122.391602089471 | (37.7219836364279, -122.391602089471) | 10 | 3 | 8 | 58 | 1 | |||
12028 | 261519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:20:00 PM | Width 4ft | 5982910.9702 | 2111318.38005 | 37.7762872714849 | -122.502653994406 | (37.7762872714849, -122.502653994406) | 11 | 6 | 2 | 55 | 26 | |||
12387 | 88728 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
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 | ||
13230 | 260498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 349 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6000178 | 2110153 | 37.7740870040886 | -122.442839045318 | (37.7740870040886, -122.442839045318) | 15 | 5 | 11 | 29492 | 16 | ||||
14053 | 62766 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1988 12:00:00 AM | Permit Number 25290 | 5993348.39587904 | 2103942.72221653 | 37.7566434919089 | -122.466012277578 | (37.7566434919089, -122.466012277578) | 1 | 8 | 4 | 56 | 12 | ||
14205 | 79589 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1746 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53534 | 5993448.84463132 | 2103598.20779392 | 37.7557033388246 | -122.465639863764 | (37.7557033388246, -122.465639863764) | 1 | 8 | 4 | 56 | 12 | ||
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 | ||||
14527 | 255214 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
14615 | 260497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6000185 | 2110105 | 37.7739556073117 | -122.44281138372 | (37.7739556073117, -122.44281138372) | 15 | 5 | 11 | 29492 | 16 | ||||
14895 | 42944 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42839 | 6007671.6020798 | 2107773.96917263 | 37.7679791099284 | -122.416748729284 | (37.7679791099284, -122.416748729284) | 8 | 4 | 7 | 28853 | 19 | ||
16949 | 255206 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
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 | ||
17633 | 255212 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
17913 | 35078 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
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 | ||||
18297 | 51025 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47502 | 6005670.67188859 | 2109250.29159524 | 37.7719199923513 | -122.423774718207 | (37.7719199923513, -122.423774718207) | 7 | 9 | 5 | 28852 | 10 | |||
18737 | 258112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5993962.87947 | 2115311.61201 | 37.7878948748238 | -122.464712734046 | (37.7878948748238, -122.464712734046) | 11 | 6 | 1 | 54 | 11 | ||||||
18784 | 255213 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
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 | ||
21310 | 254733 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 398 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 3x3 | 6008656 | 2108503 | 37.7700361768699 | -122.413395357755 | (37.7700361768699, -122.413395357755) | 8 | 2 | 9 | 28853 | 19 | |||
21319 | 91088 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 132 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51983 | 5992207 | 2088751 | 37.7148649307688 | -122.468854138233 | (37.7148649307688, -122.468854138233) | 9 | 8 | 6 | 64 | 24 | ||
23473 | 87390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.436018296661 | (37.8000499325498, -122.436018296661) | 13 | 9 | 1 | 57 | 17 | |||
23668 | 66231 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/1994 12:00:00 AM | Permit Number 29328 | 5997721.47171687 | 2090151.04761265 | 37.7190261896858 | -122.449894746819 | (37.7190261896858, -122.449894746819) | 9 | 8 | 6 | 28861 | 24 | ||
23823 | 45113 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1272 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43975 | 5992408.94148991 | 2106797.24353803 | 37.7644270145157 | -122.46946900258 | (37.7644270145157, -122.46946900258) | 11 | 8 | 11 | 56 | 12 | ||
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 | ||
24334 | 48686 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||
24478 | 69061 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1259 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33069 | 5992353.79544263 | 2106887.79671216 | 37.764672462389 | -122.469666328544 | (37.764672462389, -122.469666328544) | 11 | 8 | 11 | 56 | 12 | ||
24551 | 62760 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 409 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23114 | 5993046.38592213 | 2104560.1415905 | 37.7583213372073 | -122.467101616449 | (37.7583213372073, -122.467101616449) | 1 | 8 | 4 | 56 | 12 | ||
25797 | 35077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
25810 | 48572 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
27234 | 69058 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33066 | 5992350.1648235 | 2106993.32933415 | 37.7649620171359 | -122.469686569205 | (37.7649620171359, -122.469686569205) | 11 | 8 | 11 | 56 | 12 | ||
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 | ||||
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 | ||
28303 | 56711 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1659 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2015 12:00:00 AM | Permit Number 774226 | 5983116.27836009 | 2103843.81660781 | 37.7557763190096 | -122.501390749613 | (37.7557763190096, -122.501390749613) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
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 | ||
29812 | 99390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
30232 | 99397 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
30235 | 35086 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
30387 | 60896 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1992 12:00:00 AM | Permit Number 20684 | 5995496.17178877 | 2107213.04806332 | 37.7657466388052 | -122.458821302083 | (37.7657466388052, -122.458821302083) | 15 | 5 | 11 | 56 | 12 | ||
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 | ||
30539 | 67015 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 379 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30370 | 5995013.54183778 | 2088325.60684353 | 37.7138586475181 | -122.459122836548 | (37.7138586475181, -122.459122836548) | 9 | 8 | 6 | 28861 | 24 | ||
30640 | 38839 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 947 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40668 | 5992575.8845778 | 2114792.63949005 | 37.7863898589993 | -122.469473646902 | (37.7863898589993, -122.469473646902) | 11 | 6 | 2 | 54 | 11 | ||
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 | ||
31066 | 56439 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 12650 | 6005234.88834925 | 2109313.51101723 | 37.7720689675781 | -122.425286625875 | (37.7720689675781, -122.425286625875) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||
32256 | 99396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
32297 | 48573 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
32383 | 88740 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||
32693 | 46869 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
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 | ||
32978 | 66244 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 545 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29343 | 5995212.13315242 | 2091201.87256763 | 37.7217676067917 | -122.458644529473 | (37.7217676067917, -122.458644529473) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |
34300 | 92278 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52728 | 5991376 | 2097700 | 37.7393886087034 | -122.472378389349 | (37.7393886087034, -122.472378389349) | 1 | 8 | 4 | 29491 | 40 | ||
34618 | 63613 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24252 | 6005229.19307431 | 2109538.39058576 | 37.7726861107413 | -122.425322331795 | (37.7726861107413, -122.425322331795) | 7 | 9 | 11 | 28852 | 10 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );