trees
484 rows where qSpecies_id = 56 sorted by Police Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86597 | 208949 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 402 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 10ft | 5992933.73617 | 2096006.17085 | 37.7348278128415 | -122.466869367631 | (37.7348278128415, -122.466869367631) | 9 | 8 | 4 | 59 | 40 | |||
90362 | 254305 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 170 Junipero Serra Blvd | 2 | Median : Cutout | Tree | Private 2 | 10x10 | 5991380 | 2095134 | 37.732343254282 | -122.47217756607 | (37.732343254282, -122.47217756607) | 1 | 8 | 4 | 64 | 40 | ||||
91634 | 208930 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 435 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 55 | Width 10ft | 5993068.37064 | 2096069.711 | 37.7350100478567 | -122.466408510055 | (37.7350100478567, -122.466408510055) | 1 | 8 | 4 | 59 | 40 | |||
91970 | 208996 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 4ft | 5993421.96829 | 2097241.5815 | 37.7382481090644 | -122.465271101502 | (37.7382481090644, -122.465271101502) | 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 | |||
93771 | 29600 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991176.92289 | 2091079.14193 | 37.7211978713578 | -122.472584119478 | (37.7211978713578, -122.472584119478) | 9 | 8 | 4 | 64 | 40 | ||
97567 | 254310 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 190X Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5991377 | 2095081 | 37.732197556005 | -122.472184075725 | (37.732197556005, -122.472184075725) | 1 | 8 | 4 | 64 | 40 | ||||
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 | |||
98944 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 301X Sargent St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5993018 | 2089140 | 37.7159798527116 | -122.466079257059 | (37.7159798527116, -122.466079257059) | 9 | 8 | 6 | 64 | 24 | ||||
100447 | 208954 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 600 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 8ft | 5993495.97502 | 2095994.95159 | 37.7348294415148 | -122.464924714122 | (37.7348294415148, -122.464924714122) | 9 | 8 | 4 | 59 | 40 | |||
101469 | 254309 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 170 Junipero Serra Blvd | 6 | Median : Cutout | Tree | Private 2 | 10x10 | 5991380 | 2095134 | 37.732343254282 | -122.47217756607 | (37.732343254282, -122.47217756607) | 1 | 8 | 4 | 64 | 40 | ||||
102459 | 208944 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 234 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 10ft | 5992497.26068 | 2095992.67828 | 37.7347655644733 | -122.468377420108 | (37.7347655644733, -122.468377420108) | 9 | 8 | 4 | 59 | 40 | |||
102664 | 207795 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 213 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 10ft | 5993167.32945 | 2096610.60875 | 37.7365009277821 | -122.466105670558 | (37.7365009277821, -122.466105670558) | 1 | 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 | |||
104292 | 253843 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 130X Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 10x30 | 5991393 | 2095322 | 37.7328602072681 | -122.472146321186 | (37.7328602072681, -122.472146321186) | 1 | 8 | 4 | 64 | 40 | ||||
104882 | 254303 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 140 Junipero Serra Blvd | 6 | Median : Cutout | Tree | Private 2 | 3x3 | 5991388 | 2095260 | 37.73268968153 | -122.472159089582 | (37.73268968153, -122.472159089582) | 1 | 8 | 4 | 64 | 40 | ||||
104986 | 114043 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 LINARES AVE | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 5994258 | 2102054 | 37.7515099774588 | -122.462729551044 | (37.7515099774588, -122.462729551044) | 1 | 8 | 4 | 29491 | 40 | ||||
105571 | 208927 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | Width 10ft | 5992731.01578 | 2096057.52147 | 37.7349571065737 | -122.467573969373 | (37.7349571065737, -122.467573969373) | 1 | 8 | 4 | 59 | 40 | |||
107735 | 207766 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 14 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 10ft | 5993184.09693 | 2097461.91411 | 37.7388393665447 | -122.466109543018 | (37.7388393665447, -122.466109543018) | 1 | 8 | 4 | 59 | 40 | |||
107750 | 208968 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 34 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 6ft | 5993576.11533 | 2097077.37044 | 37.7378061147578 | -122.464726220253 | (37.7378061147578, -122.464726220253) | 1 | 8 | 4 | 59 | 40 | |||
108706 | 209006 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 172 Kensington Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5994773.63128 | 2098602.47798 | 37.7420626491773 | -122.460696346461 | (37.7420626491773, -122.460696346461) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
110527 | 208925 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 235 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 45 | Width 10ft | 5992554.16067 | 2096052.70309 | 37.7349336639503 | -122.468185064096 | (37.7349336639503, -122.468185064096) | 1 | 8 | 4 | 59 | 40 | |||
112500 | 209000 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 135 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 4ft | 5994206.5655 | 2096669.18291 | 37.7367216600723 | -122.462516864768 | (37.7367216600723, -122.462516864768) | 9 | 8 | 4 | 59 | 40 | |||
112642 | 208952 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 440 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 10ft | 5993062.86843 | 2096011.9995 | 37.7348512689743 | -122.466423339872 | (37.7348512689743, -122.466423339872) | 9 | 8 | 4 | 59 | 40 | |||
114597 | 208945 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 234 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 40 | Width 10ft | 5992554.30272 | 2095990.82137 | 37.7347637604433 | -122.46818007286 | (37.7347637604433, -122.46818007286) | 9 | 8 | 4 | 59 | 40 | |||
115626 | 208920 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 135 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992288.77396 | 2096040.55395 | 37.734884974665 | -122.469101707103 | (37.734884974665, -122.469101707103) | 1 | 8 | 4 | 59 | 40 | |||
115802 | 208964 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 60 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 6ft | 5993779.53053 | 2096936.19584 | 37.7374302098203 | -122.464012675648 | (37.7374302098203, -122.464012675648) | 1 | 8 | 4 | 59 | 40 | |||
115843 | 208957 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 625 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 8ft | 5993588.44342 | 2096129.23717 | 37.7352034875532 | -122.46461476908 | (37.7352034875532, -122.46461476908) | 1 | 8 | 4 | 59 | 40 | |||
116722 | 208960 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 601 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 44 | Width 8ft | 5993401.29019 | 2096115.48675 | 37.7351549412444 | -122.465260822223 | (37.7351549412444, -122.465260822223) | 1 | 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 | |||
119017 | 105441 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 425 WAWONA ST | unknown : Yard | Tree | Private 2 | 5991587.6 | 2097036.5 | 37.7375790508831 | -122.471598439568 | (37.7375790508831, -122.471598439568) | 1 | 8 | 4 | 29491 | 40 | ||||||
119656 | 114409 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 500X ARBALLO DR | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | ||||
121390 | 207802 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 65 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 10ft | 5993322.83202 | 2097078.2937 | 37.7377940440554 | -122.465602003431 | (37.7377940440554, -122.465602003431) | 1 | 8 | 4 | 59 | 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 | |||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
163869 | 208917 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 10ft | Permit Number 782932 | 5992152.90186 | 2096040.12972 | 37.7348759580475 | -122.469571429275 | (37.7348759580475, -122.469571429275) | 1 | 8 | 4 | 59 | 40 | ||
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 | ||||
167614 | 208953 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 502 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 8ft | 5993239.50835 | 2095986.25518 | 37.734790772481 | -122.465810769367 | (37.734790772481, -122.465810769367) | 9 | 8 | 4 | 59 | 40 | |||
168419 | 208951 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 440 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 40 | Width 10ft | 5993021.57409 | 2096009.58153 | 37.7348422469539 | -122.466565931871 | (37.7348422469539, -122.466565931871) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
171112 | 207771 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 50 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 10ft | 5993253.43088 | 2097238.90262 | 37.7382310327445 | -122.465853621172 | (37.7382310327445, -122.465853621172) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
171379 | 207780 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 250 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 10ft | 5993075.61435 | 2096444.65306 | 37.7360399631594 | -122.466410708005 | (37.7360399631594, -122.466410708005) | 1 | 8 | 4 | 59 | 40 | |||
171661 | 207788 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 285 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 10ft | 5993135.10109 | 2096167.22841 | 37.7352816566244 | -122.46618488553 | (37.7352816566244, -122.46618488553) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
174677 | 208913 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 25 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 52 | Width 10ft | 5991855.18446 | 2096027.35196 | 37.7348236624713 | -122.470599802253 | (37.7348236624713, -122.470599802253) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
177674 | 207779 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 126 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | Width 10ft | 5993175.19587 | 2096740.86685 | 37.7368590378112 | -122.46608793591 | (37.7368590378112, -122.46608793591) | 1 | 8 | 4 | 59 | 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 | ||||
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 | |||
179436 | 208938 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 66 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 10ft | 5991979.81471 | 2095977.19537 | 37.7346931510662 | -122.470165265142 | (37.7346931510662, -122.470165265142) | 9 | 8 | 4 | 59 | 40 | |||
179682 | 207769 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 40 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 40 | Width 10ft | 5993228.66009 | 2097329.84492 | 37.7384793085579 | -122.465945871829 | (37.7384793085579, -122.465945871829) | 1 | 8 | 4 | 59 | 40 | |||
182896 | 208941 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 130 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 10ft | 5992287.57342 | 2095984.60456 | 37.7347312823091 | -122.469101787134 | (37.7347312823091, -122.469101787134) | 9 | 8 | 4 | 59 | 40 | |||
186983 | 208979 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 46 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5992891.21268 | 2101728.13425 | 37.7505364203394 | -122.467432335147 | (37.7505364203394, -122.467432335147) | 1 | 8 | 4 | 29491 | 12 | |||
189787 | 208965 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 56 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 6ft | 5993745.43898 | 2096960.72106 | 37.7374955851482 | -122.464132325055 | (37.7374955851482, -122.464132325055) | 1 | 8 | 4 | 59 | 40 | |||
191199 | 207791 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 255 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 10ft | 5993127.95212 | 2096331.51719 | 37.7357323401679 | -122.466221537416 | (37.7357323401679, -122.466221537416) | 1 | 8 | 4 | 59 | 40 | |||
192427 | 185929 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5985012.7201 | 2101493.4926 | 37.7494341681805 | -122.494659074897 | (37.7494341681805, -122.494659074897) | 1 | 8 | 3 | 29491 | 35 | |||
192845 | 207765 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 356 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5992543.86147 | 2094436.1305 | 37.7304943639181 | -122.46810311697 | (37.7304943639181, -122.46810311697) | 9 | 8 | 4 | 59 | 40 | |||
444 | 105900 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
973 | 176338 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | 10 | 7 | 8 | 309 | 28 | |||
1776 | 247999 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Peralta Ave | 3 | Side Yard : Yard | Tree | Private 2 | 35 | 6009750 | 2099218 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | 2 | 7 | 7 | 28859 | 2 |
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) );