trees
484 rows where qSpecies_id = 56 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
122223 | 113804 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 990X OSHAUGHNESSY BLVD | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 3x30 | 6000025 | 2096199 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | 9 | 7 | 4 | 63 | 40 | ||||
123942 | 114396 | Permitted Site 7 | Eucalyptus globulus :: Blue Gum 56 | 35 HIGUERA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | |||||
124028 | 257931 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
124057 | 224245 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 160 Coso Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 6007485.6356 | 2099587.10163 | 37.7454893881214 | -122.416811886672 | (37.7454893881214, -122.416811886672) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
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 | |||
126064 | 207794 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 213 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 10ft | 5993149.25155 | 2096563.99491 | 37.736371894833 | -122.46616478659 | (37.736371894833, -122.46616478659) | 1 | 8 | 4 | 59 | 40 | |||
126653 | 191723 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x Carolina St | 30 | Median : Yard | Tree | DPW 1 | 50 | 6012476.48508 | 2103328.88343 | 37.7560429683291 | -122.399816899747 | (37.7560429683291, -122.399816899747) | 10 | 3 | 8 | 28856 | 29 | ||||
126689 | 209021 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 34 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 6000790.06178 | 2095561.69984 | 37.7340577017886 | -122.43967553722 | (37.7340577017886, -122.43967553722) | 9 | 7 | 5 | 63 | 40 | ||||
128096 | 256447 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 3001 Sunset Blvd | 31 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
128317 | 4837 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 127 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006404.24922 | 2097646.68025 | 37.7401005434118 | -122.420413452032 | (37.7401005434118, -122.420413452032) | 2 | 7 | 7 | 28859 | 2 | |||
128365 | 208977 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 300x Marietta Dr | 45 | Median : Cutout | Tree | DPW 1 | 27 | Width 5ft | 5999505.82373 | 2097502.74743 | 37.7393141797969 | -122.444254970484 | (37.7393141797969, -122.444254970484) | 9 | 7 | 4 | 59 | 40 | |||
128484 | 224220 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 46 | 6004122.93683 | 2095831.82479 | 37.7349885405914 | -122.428171995061 | (37.7349885405914, -122.428171995061) | 2 | 7 | 5 | 28861 | 2 | ||||
128772 | 258286 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
129458 | 207796 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 145 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 45 | Width 10ft | 5993217.29355 | 2096710.01575 | 37.7367767570402 | -122.465940145823 | (37.7367767570402, -122.465940145823) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
129920 | 106227 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 38 Stanford Heights Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997884 | 2095808.5 | 37.7345695210024 | -122.44974042874 | (37.7345695210024, -122.44974042874) | 9 | 7 | 4 | 59 | 40 | |||||
130715 | 251303 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Cashmere St | 2 | Back Yard : Yard | Tree | Health Dept 13 | 3x3 | 6017463 | 2095772 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | 10 | 3 | 8 | 58 | 1 | ||||
131453 | 208923 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 201 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 10ft | 5992447.89906 | 2096049.02744 | 37.734917433899 | -122.468552177239 | (37.734917433899, -122.468552177239) | 1 | 8 | 4 | 59 | 40 | |||
131738 | 92899 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 3 | 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 | ||||
132170 | 253847 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 190X Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5991377 | 2095081 | 37.732197556005 | -122.472184075725 | (37.732197556005, -122.472184075725) | 1 | 8 | 4 | 64 | 40 | ||||
132508 | 254295 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 110 Junipero Serra Blvd | 7 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
132855 | 207793 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 215 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 10ft | 5993139.69787 | 2096516.18073 | 37.7362400578338 | -122.466194343712 | (37.7362400578338, -122.466194343712) | 1 | 8 | 4 | 59 | 40 | |||
134035 | 114403 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1X HIGUERA AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | |||
134080 | 114044 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 549X ARLINGTON ST | Median : Cutout | Tree | Private 2 | 70 | 6003400 | 2095634 | 37.7344044281823 | -122.430657330781 | (37.7344044281823, -122.430657330781) | 2 | 7 | 5 | 63 | 7 | |||||
134246 | 258292 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 9 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
134306 | 224258 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6001075.26018 | 2107893.83056 | 37.7679350014146 | -122.439573286101 | (37.7679350014146, -122.439573286101) | 15 | 5 | 5 | 29492 | 3 | |||
134451 | 247927 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 12 | Side Yard : Yard | Tree | Private 2 | 34 | 6010318.55961 | 2098736.7728 | 37.7433135063186 | -122.406956112045 | (37.7433135063186, -122.406956112045) | 10 | 7 | 7 | 28859 | 2 | ||||
134765 | 208974 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 130 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 6ft | 5994229.97779 | 2096604.20114 | 37.7365445844613 | -122.462431207033 | (37.7365445844613, -122.462431207033) | 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 | |||
135166 | 207759 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 315 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 10ft | 5993145.97421 | 2095838.45755 | 37.7343795610583 | -122.46612340967 | (37.7343795610583, -122.46612340967) | 9 | 8 | 4 | 59 | 40 | |||
136621 | 209007 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 172 Kensington Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5994745.50567 | 2098641.39451 | 37.7421678860404 | -122.460796414937 | (37.7421678860404, -122.460796414937) | 1 | 8 | 4 | 59 | 40 | |||
136862 | 105901 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
138399 | 254281 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 80X Junipero Serra Blvd | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
138898 | 209036 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 427 Baden St | 2 | Front Yard : Yard | Tree | Private 2 | 41 | 6000750.14831 | 2095370.65935 | 37.7335308771479 | -122.439799837889 | (37.7335308771479, -122.439799837889) | 9 | 7 | 5 | 63 | 40 | ||||
139166 | 176348 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 5989603.79735 | 2090546.09261 | 37.7196430676648 | -122.477982952958 | (37.7196430676648, -122.477982952958) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
139286 | 4843 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 146 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6006528.82493 | 2097534.91084 | 37.7398006689526 | -122.419974789699 | (37.7398006689526, -122.419974789699) | 2 | 7 | 7 | 28859 | 2 | |||
140152 | 208932 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 435 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 47 | Width 10ft | 5992980.53983 | 2096066.62854 | 37.7349965157706 | -122.4667119458 | (37.7349965157706, -122.4667119458) | 1 | 8 | 4 | 59 | 40 | |||
140170 | 253136 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 3059 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x5 | 5999298 | 2114593 | 37.7862278895056 | -122.446202552789 | (37.7862278895056, -122.446202552789) | 15 | 6 | 1 | 29490 | 31 | ||||
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 | ||||
140615 | 96803 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 300X Melrose Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 48 | 5998134.5 | 2095546.7 | 37.7338650092742 | -122.448855518806 | (37.7338650092742, -122.448855518806) | 9 | 7 | 4 | 59 | 40 | ||||
140860 | 253846 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 150 Junipero Serra Blvd | 3 | Median : Cutout | Tree | Private 2 | 3x3 | 5991384 | 2095197 | 37.7325164679088 | -122.472168327848 | (37.7325164679088, -122.472168327848) | 1 | 8 | 4 | 64 | 40 | ||||
141599 | 251417 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5990003 | 2112517 | 37.7799925618685 | -122.478208632121 | (37.7799925618685, -122.478208632121) | 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 | |||
142172 | 207758 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | 5994815.67763 | 2105291.72467 | 37.7604320448236 | -122.461035696659 | (37.7604320448236, -122.461035696659) | 15 | 5 | 4 | 56 | 12 | ||||
142283 | 114069 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 2 HIGUERA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 40 | 5988091 | 2090188 | 37.7185719141165 | -122.483185851801 | (37.7185719141165, -122.483185851801) | 1 | 8 | 4 | 64 | 14 | ||||
142651 | 247929 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 37 | 6010384.75611 | 2098766.60945 | 37.7433991352743 | -122.406729322823 | (37.7433991352743, -122.406729322823) | 10 | 7 | 7 | 28859 | 2 | ||||
142760 | 209024 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 32 | 6000772.29534 | 2095570.30388 | 37.7340803152378 | -122.439737577826 | (37.7340803152378, -122.439737577826) | 9 | 7 | 5 | 63 | 40 | ||||
143583 | 208924 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 235 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 44 | Width 10ft | 5992506.66791 | 2096052.38869 | 37.7349300576612 | -122.468349238953 | (37.7349300576612, -122.468349238953) | 1 | 8 | 4 | 59 | 40 | |||
143744 | 207783 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 260 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 10ft | 5993078.05201 | 2096316.5606 | 37.7356883939084 | -122.466392973362 | (37.7356883939084, -122.466392973362) | 1 | 8 | 4 | 59 | 40 | |||
143887 | 207777 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 118 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | Width 10ft | 5993220.09553 | 2096827.09916 | 37.7370984004648 | -122.465938963216 | (37.7370984004648, -122.465938963216) | 1 | 8 | 4 | 59 | 40 | |||
143983 | 208934 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 405 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 10ft | 5992888.06418 | 2096062.32962 | 37.7349793747065 | -122.467031351742 | (37.7349793747065, -122.467031351742) | 1 | 8 | 4 | 59 | 40 | |||
144155 | 208987 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993980.02644 | 2096844.06194 | 37.7371887859367 | -122.463312789075 | (37.7371887859367, -122.463312789075) | 1 | 8 | 4 | 59 | 40 | |||
144422 | 247935 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 31 | 6010295.56922 | 2098768.42696 | 37.7433991352522 | -122.407037837932 | (37.7433991352522, -122.407037837932) | 2 | 7 | 7 | 28859 | 2 | ||||
144814 | 224259 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 3ft | 6001093.91519 | 2107903.07464 | 37.7679614450866 | -122.43950942342 | (37.7679614450866, -122.43950942342) | 15 | 5 | 5 | 29492 | 3 | |||
144923 | 224243 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 39 | Front Yard : Yard | Tree | Private 2 | 20 | 6004771.77471 | 2096643.75237 | 37.73725460102 | -122.425986510284 | (37.73725460102, -122.425986510284) | 2 | 7 | 5 | 63 | 7 | ||||
145692 | 208947 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 340 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 10ft | 5992761.11825 | 2096003.55707 | 37.7348106717797 | -122.467465972472 | (37.7348106717797, -122.467465972472) | 9 | 8 | 4 | 59 | 40 | |||
145770 | 258288 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 5 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
146246 | 191736 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200 Helena St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 57 | 6010895.57722 | 2096228.10312 | 37.7364575084979 | -122.404784345514 | (37.7364575084979, -122.404784345514) | 10 | 3 | 8 | 58 | 1 | ||||
146647 | 17957 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2500 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6001928.8852 | 2115030.4127 | 37.7875788082428 | -122.437131721785 | (37.7875788082428, -122.437131721785) | 13 | 6 | 1 | 29490 | 27 | |||
146721 | 2615 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
147064 | 207761 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 345 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 10ft | 5993145.03343 | 2095739.54752 | 37.7341079244482 | -122.466119476937 | (37.7341079244482, -122.466119476937) | 9 | 8 | 4 | 59 | 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 | |||
147618 | 208986 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 372 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5993088 | 2095554 | 37.7335951664771 | -122.466303177465 | (37.7335951664771, -122.466303177465) | 9 | 8 | 4 | 59 | 40 | |||
147696 | 258285 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
148291 | 207805 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 35 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 10ft | 5993257.87377 | 2097404.51842 | 37.738686028527 | -122.465850290071 | (37.738686028527, -122.465850290071) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||||
151227 | 207804 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 55 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 10ft | 5993316.27316 | 2097156.75234 | 37.738009093546 | -122.465630378851 | (37.738009093546, -122.465630378851) | 1 | 8 | 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 | |||||
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 | |||
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 | ||||
152264 | 207803 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 55 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 10ft | 5993318.63441 | 2097122.65017 | 37.7379155937141 | -122.465619738075 | (37.7379155937141, -122.465619738075) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
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 | ||||
153947 | 249920 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 358 Greenwich St | 5 | Back Yard : Yard | Tree | Private 2 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||||
154190 | 121341 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 401X Cargo Way | 2 | Side Yard : Yard | Tree | Private 2 | 18 | 3x3 | 6017217 | 2098844 | 37.7439915378474 | -122.383110313195 | (37.7439915378474, -122.383110313195) | 10 | 3 | 8 | 58 | 1 | |||
154387 | 208956 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 630 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 8ft | 5993584.21489 | 2095997.15656 | 37.7348405832115 | -122.464619800786 | (37.7348405832115, -122.464619800786) | 9 | 8 | 4 | 59 | 40 | |||
155844 | 191729 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 6009963.10998 | 2107668.13664 | 37.7678171371844 | -122.408815154618 | (37.7678171371844, -122.408815154618) | 8 | 4 | 8 | 28853 | 19 | ||||
157725 | 208918 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 10ft | 5992207.01448 | 2096041.6179 | 37.7348831715052 | -122.469384453049 | (37.7348831715052, -122.469384453049) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
158118 | 114076 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 24 HIGUERA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
158171 | 111538 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 16 | Front Yard : Yard | Tree | DPW 1 | 28 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
158749 | 207799 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 10ft | 5993278.01218 | 2096833.03373 | 37.7371180362587 | -122.465739151856 | (37.7371180362587, -122.465739151856) | 1 | 8 | 4 | 59 | 40 | |||
158886 | 247820 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 Jarboe Ave | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6009707.55977 | 2096850.28614 | 37.7380994142676 | -122.408935726717 | (37.7380994142676, -122.408935726717) | 10 | 7 | 7 | 28859 | 2 | ||||
159364 | 208943 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 10ft | 5992457.65692 | 2095992.19703 | 37.7347619554908 | -122.468514307707 | (37.7347619554908, -122.468514307707) | 9 | 8 | 4 | 59 | 40 | |||
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 | ||||
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 | |||
161254 | 207762 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 10ft | 5993165.17049 | 2095669.26931 | 37.7339161197195 | -122.466044752265 | (37.7339161197195, -122.466044752265) | 9 | 8 | 4 | 59 | 40 | |||
161732 | 23202 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 520X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6006708.88776 | 2112470.99571 | 37.7808218241176 | -122.420412091366 | (37.7808218241176, -122.420412091366) | 7 | 9 | 9 | 28852 | 36 | |||
161936 | 191732 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 4 | Front Yard : Yard | Tree | Private 2 | 18 | 6009982.19315 | 2107558.06249 | 37.7675159677065 | -122.408741381426 | (37.7675159677065, -122.408741381426) | 8 | 4 | 8 | 28853 | 19 | ||||
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 | |||
162813 | 191721 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1150x Tennessee St | 7 | Median : Yard | Tree | DPW 1 | 50 | 6015559.12531 | 2103608.85918 | 37.7569830917109 | -122.389175557402 | (37.7569830917109, -122.389175557402) | 10 | 3 | 8 | 28856 | 29 | ||||
163725 | 207792 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 255 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 10ft | 5993127.30718 | 2096365.92491 | 37.7358267779692 | -122.466226266925 | (37.7358267779692, -122.466226266925) | 1 | 8 | 4 | 59 | 40 | |||
163874 | 246763 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 7 | Front Yard : Yard | Tree | Private 2 | 27 | 6009290.72604 | 2098884.53398 | 37.7436616572582 | -122.410520540796 | (37.7436616572582, -122.410520540796) | 2 | 7 | 7 | 28859 | 2 | ||||
164002 | 111525 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 3 | Front Yard : Yard | Tree | DPW 1 | 26 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
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 |
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) );