trees
484 rows where qSpecies_id = 56 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149188 | 92034 | Permitted Site 7 | Eucalyptus globulus :: Blue Gum 56 | 10 Elk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.442670159752 | (37.7402285519688, -122.442670159752) | 2 | 7 | 5 | 63 | 7 | |||
| 150726 | 106275 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 42 Stanford Heights Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | 9 | 7 | 4 | 59 | 40 | |||||
| 151340 | 111511 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 800x BOSWORTH ST | 6 | Front Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
| 151892 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 1 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
| 152308 | 256445 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 3001 Sunset Blvd | 29 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 152776 | 253841 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 80X Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
| 152900 | 257934 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
| 157123 | 66251 | Permitted Site 7 | Eucalyptus globulus :: Blue Gum 56 | 35 HIGUERA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1990 12:00:00 AM | Permit Number 29352 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | |||
| 159425 | 258291 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 8 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
| 164122 | 256226 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 410 Baden St | 2 | Front Yard : Yard | Tree | Private 2 | 6000789.00569 | 2095372.0781 | 37.7335369844496 | -122.439665598801 | (37.7335369844496, -122.439665598801) | 9 | 7 | 5 | 63 | 40 | |||||
| 164270 | 92039 | Permitted Site 7 | Eucalyptus globulus :: Blue Gum 56 | 10 Elk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.442670159752 | (37.7402285519688, -122.442670159752) | 2 | 7 | 5 | 63 | 7 | |||
| 165630 | 108200 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 90 Reuel Ct | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 774102 | 6017404.09127 | 2096025.61699 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | 10 | 3 | 8 | 58 | 1 | ||||
| 166600 | 254313 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 190X Junipero Serra Blvd | 5 | Median : Yard | Tree | Private 2 | 10x10 | 5991377 | 2095081 | 37.732197556005 | -122.472184075725 | (37.732197556005, -122.472184075725) | 1 | 8 | 4 | 64 | 40 | ||||
| 170679 | 257933 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
| 171148 | 256446 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 3001 Sunset Blvd | 30 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 173822 | 254318 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 210 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5991371 | 2094995 | 37.7319610744091 | -122.472198552297 | (37.7319610744091, -122.472198552297) | 1 | 8 | 4 | 64 | 40 | ||||
| 175631 | 92898 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 2 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
| 177622 | 254294 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 110 Junipero Serra Blvd | 6 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
| 178630 | 254286 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100X Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5991400 | 2095443 | 37.7331928478719 | -122.472130937334 | (37.7331928478719, -122.472130937334) | 1 | 8 | 4 | 64 | 40 | ||||
| 181524 | 121089 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
| 184600 | 115801 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 9M CAIRE TER | 1 | Front Yard : Yard | Tree | Private 2 | 6012720 | 2101959 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | 10 | 3 | 8 | 28856 | 29 | |||||
| 188995 | 119265 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1317 Bosworth St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000208 | 2096491 | 37.7365761953737 | -122.441754571906 | (37.7365761953737, -122.441754571906) | 2 | 7 | 5 | 63 | 7 | |||||
| 160808 | 169607 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 118 Saint Mary's Ave | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 0 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.7352888053199 | -122.42875656067 | (37.7352888053199, -122.42875656067) | 2 | 7 | 5 | 63 | 7 | |||
| 82743 | 209039 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6000750.66308 | 2095345.51302 | 37.7334618604699 | -122.439796255913 | (37.7334618604699, -122.439796255913) | 9 | 7 | 5 | 63 | 40 | ||||
| 140361 | 209041 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 6 | Front Yard : Yard | Tree | Private 2 | 1 | 6000751.4342 | 2095340.23559 | 37.7334474137664 | -122.439793211699 | (37.7334474137664, -122.439793211699) | 9 | 7 | 5 | 63 | 40 | ||||
| 173314 | 209040 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 5 | Front Yard : Yard | Tree | Private 2 | 1 | 6000753.71672 | 2095344.13435 | 37.7334582487793 | -122.43978559983 | (37.7334582487793, -122.43978559983) | 9 | 7 | 5 | 63 | 40 | ||||
| 186657 | 209037 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6000749.92806 | 2095352.54396 | 37.7334811239592 | -122.439799300997 | (37.7334811239592, -122.439799300997) | 9 | 7 | 5 | 63 | 40 | ||||
| 107830 | 209027 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10 | 6000763.85093 | 2095573.2374 | 37.7340878893448 | -122.439766982962 | (37.7340878893448, -122.439766982962) | 9 | 7 | 5 | 63 | 40 | ||||
| 111701 | 209033 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 38 Martha Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10 | 6000746.95442 | 2095582.5977 | 37.7341126287783 | -122.439826070211 | (37.7341126287783, -122.439826070211) | 9 | 7 | 5 | 63 | 40 | ||||
| 147597 | 208980 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 302 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993091.73044 | 2095958.45065 | 37.7347059025462 | -122.466319664239 | (37.7347059025462, -122.466319664239) | 9 | 8 | 4 | 59 | 40 | |||
| 46802 | 176341 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 500x Mansell St | 17 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | 10 | 3 | 8 | 309 | 28 | |||
| 129613 | 209008 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 406 Baden St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6000788.7045 | 2095325.02184 | 37.7334077617457 | -122.439663267741 | (37.7334077617457, -122.439663267741) | 9 | 7 | 5 | 63 | 40 | ||||
| 139243 | 106810 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 3500X MISSION ST | 10 | Median : Cutout | Tree | DPW 1 | 11 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
| 191735 | 247932 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 5 | Side Yard : Yard | Tree | Private 2 | 11 | 6010369.90614 | 2098762.79338 | 37.7433878262904 | -122.406780401602 | (37.7433878262904, -122.406780401602) | 10 | 7 | 7 | 28859 | 2 | ||||
| 5310 | 209020 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 33 Martha Ave | 4 | : Yard | Tree | Private 2 | 12 | 6000767.68455 | 2095534.49854 | 37.7339817396554 | -122.439750952547 | (37.7339817396554, -122.439750952547) | 9 | 7 | 5 | 63 | 40 | ||||
| 29552 | 209015 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 412 Baden St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6000779.78636 | 2095479.1538 | 37.7338304646942 | -122.439705146498 | (37.7338304646942, -122.439705146498) | 9 | 7 | 5 | 63 | 40 | ||||
| 36161 | 106795 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 199X ARLINGTON ST | 55 | Median : Cutout | Tree | DPW 1 | 12 | 6005045 | 2097131 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | 2 | 7 | 5 | 63 | 7 | ||||
| 66557 | 13410 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 364 Marietta Dr | 3 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 5999660.108164 | 2097381.7238333 | 37.7389906787724 | -122.443712833155 | (37.7389906787724, -122.443712833155) | 9 | 7 | 4 | 59 | 40 | |||
| 106599 | 224227 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 17 | Front Yard : Yard | Tree | Private 2 | 12 | 6004843.36157 | 2096707.31423 | 37.7374331731056 | -122.425743524245 | (37.7374331731056, -122.425743524245) | 2 | 7 | 5 | 63 | 7 | ||||
| 110371 | 112189 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301x CORBETT AVE | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 12 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | |||
| 124476 | 118438 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 5201 Anza St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5982520.38622 | 2111663.82262 | 37.7772127952946 | -122.504030702291 | (37.7772127952946, -122.504030702291) | 11 | 6 | 2 | 55 | 26 | |||
| 142039 | 24268 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 350X Winding Way | 6 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6001111.91618 | 2086587.12369 | 37.7094338594537 | -122.437920185566 | (37.7094338594537, -122.437920185566) | 9 | 7 | 6 | 28861 | 5 | |||
| 151807 | 24267 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 350X Winding Way | 5 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6001124.44895 | 2086586.86413 | 37.7094338594468 | -122.437876851744 | (37.7094338594468, -122.437876851744) | 9 | 7 | 6 | 28861 | 5 | |||
| 162434 | 24323 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 600X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006332.38089 | 2112512.31586 | 37.7809140549901 | -122.421717549941 | (37.7809140549901, -122.421717549941) | 7 | 9 | 11 | 28852 | 41 | |||
| 188435 | 209019 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 33 Martha Ave | 2 | : Yard | Tree | Private 2 | 12 | 6000764.3171 | 2095528.56799 | 37.7339652640682 | -122.439762169782 | (37.7339652640682, -122.439762169782) | 9 | 7 | 5 | 63 | 40 | ||||
| 31048 | 209011 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 408 Baden St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 6000782.19416 | 2095354.33843 | 37.7334878877384 | -122.439687876799 | (37.7334878877384, -122.439687876799) | 9 | 7 | 5 | 63 | 40 | ||||
| 33889 | 209004 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 156 Kensington Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5994803.6888 | 2098556.09355 | 37.7419370183784 | -122.460589057359 | (37.7419370183784, -122.460589057359) | 1 | 8 | 4 | 59 | 40 | |||
| 65072 | 224234 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 24 | Front Yard : Yard | Tree | Private 2 | 13 | 6004836.88053 | 2096694.1378 | 37.7373966273622 | -122.425764994654 | (37.7373966273622, -122.425764994654) | 2 | 7 | 5 | 63 | 7 | ||||
| 84756 | 208946 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 300 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 10ft | 5992719.83793 | 2096001.79663 | 37.7348034547201 | -122.467608563598 | (37.7348034547201, -122.467608563598) | 9 | 8 | 4 | 59 | 40 | |||
| 170276 | 224264 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11 Germania St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004254.57068 | 2108904.38845 | 37.7708901844568 | -122.42864845406 | (37.7708901844568, -122.42864845406) | 7 | 9 | 11 | 29492 | 10 | |||
| 190588 | 224226 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 16 | Front Yard : Yard | Tree | Private 2 | 13 | 6004846.93797 | 2096712.62979 | 37.7374479705325 | -122.42573153718 | (37.7374479705325, -122.42573153718) | 2 | 7 | 5 | 63 | 7 | ||||
| 23607 | 224229 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 19 | Front Yard : Yard | Tree | Private 2 | 14 | 6004833.29966 | 2096702.67223 | 37.7374198586269 | -122.425777982686 | (37.7374198586269, -122.425777982686) | 2 | 7 | 5 | 63 | 7 | ||||
| 37863 | 224257 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6001064.07525 | 2107884.43165 | 37.7679085577502 | -122.439611299541 | (37.7679085577502, -122.439611299541) | 15 | 5 | 5 | 29492 | 3 | |||
| 89483 | 224222 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 6004869.89816 | 2096730.73115 | 37.7374989702074 | -122.425653440952 | (37.7374989702074, -122.425653440952) | 2 | 7 | 5 | 63 | 7 | ||||
| 168667 | 224263 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004229.44428 | 2108900.23084 | 37.7708773466362 | -122.428735070474 | (37.7708773466362, -122.428735070474) | 7 | 9 | 11 | 29492 | 10 | |||
| 170594 | 209005 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 172 Kensington Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5994782.01847 | 2098589.82391 | 37.7420283868014 | -122.460666429624 | (37.7420283868014, -122.460666429624) | 1 | 8 | 4 | 59 | 40 | |||
| 179028 | 208978 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 700 Junipero Serra Blvd | 109 | : | Tree | Private 2 | 14 | Width 0ft | 5991241.87233 | 2091923.37185 | 37.7235196771825 | -122.47242112456 | (37.7235196771825, -122.47242112456) | 9 | 8 | 4 | 64 | 40 | |||
| 181513 | 191726 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 700 Missouri St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6013632.69543 | 2103711.63212 | 37.757158302141 | -122.395845128465 | (37.757158302141, -122.395845128465) | 10 | 3 | 8 | 28856 | 29 | ||||
| 187949 | 224255 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 388 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999122.55283 | 2104753.13218 | 37.7592000986313 | -122.446101520571 | (37.7592000986313, -122.446101520571) | 2 | 5 | 5 | 28862 | 3 | |||
| 3064 | 111546 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 24 | Front Yard : Yard | Tree | DPW 1 | 15 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 36671 | 208936 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 3 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 10ft | 5991855.38456 | 2095971.03212 | 37.7346690339426 | -122.470595009771 | (37.7346690339426, -122.470595009771) | 9 | 8 | 4 | 59 | 40 | |||
| 61319 | 119631 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 265 Fowler Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 3x5 | 5997384 | 2099137 | 37.7436801569324 | -122.451709113802 | (37.7436801569324, -122.451709113802) | 9 | 7 | 4 | 59 | 40 | |||
| 81100 | 207787 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 292 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 10ft | 5993086.25016 | 2096104.57414 | 37.7351068050182 | -122.466349227661 | (37.7351068050182, -122.466349227661) | 1 | 8 | 4 | 59 | 40 | |||
| 124274 | 106792 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 199X ARLINGTON ST | 1 | Median : Cutout | Tree | DPW 1 | 15 | 6005045 | 2097131 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | 2 | 7 | 5 | 63 | 7 | ||||
| 153588 | 224221 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1000 San Jose Ave | 63 | Front Yard : Yard | Tree | Private 2 | 15 | 6005093.24107 | 2097044.161 | 37.7383721957242 | -122.424903531393 | (37.7383721957242, -122.424903531393) | 2 | 7 | 5 | 28859 | 7 | ||||
| 154172 | 224228 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 18 | Front Yard : Yard | Tree | Private 2 | 15 | 6004840.27089 | 2096702.34469 | 37.7374193532181 | -122.425753856564 | (37.7374193532181, -122.425753856564) | 2 | 7 | 5 | 63 | 7 | ||||
| 187643 | 224241 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 41 | Front Yard : Yard | Tree | Private 2 | 15 | 6004764.42793 | 2096634.95876 | 37.7372300405369 | -122.42601128569 | (37.7372300405369, -122.42601128569) | 2 | 7 | 5 | 63 | 7 | ||||
| 23508 | 224254 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 190 Storrie St | 4 | Front Yard : Yard | Tree | Private 2 | 16 | Width 3ft | 6000752.12131 | 2105271.59361 | 37.7607165903087 | -122.440502889194 | (37.7607165903087, -122.440502889194) | 15 | 4 | 5 | 28862 | 3 | |||
| 77234 | 207754 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1364 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5993663.75343 | 2106217.17575 | 37.7629067380829 | -122.4650868556 | (37.7629067380829, -122.4650868556) | 1 | 8 | 11 | 56 | 12 | |||
| 79539 | 95436 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 2675 25th Ave | 3 | Unaccepted Street : Yard | Tree | Private 2 | 16 | 5988610 | 2097126.3 | 37.7376529013161 | -122.481899870051 | (37.7376529013161, -122.481899870051) | 1 | 8 | 3 | 29491 | 35 | ||||
| 97814 | 208935 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 3 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 10ft | 5991812.79149 | 2095969.62922 | 37.7346627188958 | -122.470742164934 | (37.7346627188958, -122.470742164934) | 9 | 8 | 4 | 59 | 40 | |||
| 103049 | 185917 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 0ft | 5985004.5736 | 2101420.7172 | 37.7492338700088 | -122.494681880668 | (37.7492338700088, -122.494681880668) | 1 | 8 | 3 | 29491 | 35 | |||
| 105925 | 111513 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 800x BOSWORTH ST | 8 | Front Yard : Yard | Tree | DPW 1 | 16 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 110387 | 207760 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 333 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 10ft | 5993144.47081 | 2095802.99513 | 37.7342821033408 | -122.466126031205 | (37.7342821033408, -122.466126031205) | 9 | 8 | 4 | 59 | 40 | |||
| 134921 | 207789 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 275 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 10ft | 5993131.90761 | 2096210.54353 | 37.735400404893 | -122.466199073252 | (37.735400404893, -122.466199073252) | 1 | 8 | 4 | 59 | 40 | |||
| 173451 | 209016 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 412 Baden St | 4 | Side Yard : Yard | Tree | Private 2 | 16 | 6000787.61929 | 2095495.57167 | 37.7338759901863 | -122.439679242399 | (37.7338759901863, -122.439679242399) | 9 | 7 | 5 | 63 | 40 | ||||
| 67100 | 247923 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.407058269637 | (37.7432925026595, -122.407058269637) | 10 | 7 | 7 | 28859 | 2 | ||||
| 75560 | 207778 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 124 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 10ft | 5993200.08857 | 2096786.31561 | 37.7369852648432 | -122.466005173107 | (37.7369852648432, -122.466005173107) | 1 | 8 | 4 | 59 | 40 | |||
| 92601 | 208973 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 136 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 6ft | 5994259.72598 | 2096572.09553 | 37.7364581434207 | -122.462326027748 | (37.7364581434207, -122.462326027748) | 9 | 8 | 4 | 59 | 40 | |||
| 116774 | 207776 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 110 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 10ft | 5993235.98614 | 2096867.28826 | 37.7372096663776 | -122.46588694193 | (37.7372096663776, -122.46588694193) | 1 | 8 | 4 | 59 | 40 | |||
| 119025 | 176335 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 287 Hester Ave | 5 | Side Yard : Yard | Tree | Private 2 | 17 | 6012233.93602 | 2087774.20569 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | 10 | 3 | 8 | 309 | 1 | ||||
| 157947 | 224235 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 25 | Front Yard : Yard | Tree | Private 2 | 17 | 6004831.64132 | 2096688.95275 | 37.7373820943173 | -122.425782740103 | (37.7373820943173, -122.425782740103) | 2 | 7 | 5 | 63 | 7 | ||||
| 185364 | 224261 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 6001117.5941 | 2107921.40745 | 37.7680131300332 | -122.439428835199 | (37.7680131300332, -122.439428835199) | 15 | 5 | 5 | 29492 | 3 | |||
| 1295 | 19941 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
| 2286 | 20017 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY48 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
| 3109 | 224224 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 18 | 6004854.03678 | 2096713.39587 | 37.7374504751573 | -122.425707047762 | (37.7374504751573, -122.425707047762) | 2 | 7 | 5 | 63 | 7 | ||||
| 3457 | 20016 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
| 7537 | 19938 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
| 8170 | 19942 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
| 13640 | 19939 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
| 14982 | 26911 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 10 Caine Ave | 7 | Median : Cutout | Tree | DPW 1 | 18 | 10 | 5997609.86555 | 2089654.44991 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | 9 | 8 | 6 | 28861 | 24 | |||
| 16383 | 7808 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 700X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006239.03041 | 2112534.82936 | 37.7809706070447 | -122.422042095466 | (37.7809706070447, -122.422042095466) | 7 | 9 | 11 | 28852 | 41 | |||
| 17517 | 19940 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
| 20776 | 247930 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | 10 | 7 | 7 | 28859 | 2 | ||||
| 26442 | 176342 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6011455.5144 | 2090588.63485 | 37.7210039820195 | -122.402451970878 | (37.7210039820195, -122.402451970878) | 10 | 7 | 8 | 309 | 28 | |||
| 28767 | 176346 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | 9 | 7 | 8 | 309 | 39 | ||||
| 36888 | 209029 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6000758.12976 | 2095576.10922 | 37.7340954490409 | -122.439786968613 | (37.7340954490409, -122.439786968613) | 9 | 7 | 5 | 63 | 40 | ||||
| 64758 | 191722 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014479.64038 | 2101959.5389 | 37.7523945096015 | -122.392793471535 | (37.7523945096015, -122.392793471535) | 10 | 3 | 8 | 28856 | 1 | ||||
| 68807 | 43994 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 141 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2000 12:00:00 AM | 18 | Permit Number 43551 | 6010001.85414 | 2107517.13485 | 37.7674046909874 | -122.408670488759 | (37.7674046909874, -122.408670488759) | 8 | 4 | 8 | 28853 | 19 | ||
| 111198 | 208961 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1575 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5993977.82871 | 2104681.32491 | 37.7587077962432 | -122.463889098911 | (37.7587077962432, -122.463889098911) | 1 | 5 | 4 | 56 | 12 |
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) );