home / trees

Street_Tree_List

Data source: data.sfgov.org

42 rows where qSpecies = 15

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
51 100045 Property Tree 5 Acacia decurrens :: Acacia: Silver Wattle 15 556 28th St   Front Yard : Yard 4 Tree 1 Private 2         Not sure which property tree is located on. 6002301.0 2099461.0 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
8500 109645 Undocumented 3 Acacia decurrens :: Acacia: Silver Wattle 15 999X PAGE ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6001842.0 2109394.0 37.7720977038705 -122.437028639855 (37.7720977038705, -122.437028639855) 15 5 11 29492 9
27065 12921 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 1050 Lawton St 1 Median : Cutout 1 Tree 1 DPW 1     12 12   5990990.03726 2104515.89347 37.7580809319146 -122.474210073944 (37.7580809319146, -122.474210073944) 1 8 4 56 12
27076 12922 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 1050 Lawton St 2 Median : Cutout 1 Tree 1 DPW 1   02/04/2016 07:28:00 AM 3 12   5990985.67005 2104518.50205 37.758087841387294 -122.474225367817 (37.7580878413873, -122.474225367817) 1 8 4 56 12
27087 12923 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 1050 Lawton St 3 Median : Cutout 1 Tree 1 DPW 1     7 12   5990980.55181 2104515.4644 37.758079204297296 -122.474242847056 (37.7580792042973, -122.474242847056) 1 8 4 56 12
27098 12924 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 1050 Lawton St 4 Median : Cutout 1 Tree 1 DPW 1   03/01/2016 02:10:00 PM 3 12   5990975.53972 2104517.45741 37.7580843862142 -122.474260326262 (37.7580843862142, -122.474260326262) 1 8 4 56 12
27109 12925 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 1050 Lawton St 5 Median : Cutout 1 Tree 1 DPW 1     18 12   5990970.42148 2104514.41976 37.7580757491191 -122.474277805496 (37.7580757491191, -122.474277805496) 1 8 4 56 12
59762 188540 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 701 Terry A Francois Blvd 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     9     6016727.21777 2107625.64787 37.7680770223524 -122.38541572217599 (37.7680770223524, -122.385415722176) 14 3 9 310 20
73257 201701 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 43 Gilroy St 1 Side Yard : Yard 27 Tree 1 Private 2     23 Width 0ft   6015213.19192 2088555.8526400002 37.71563141862261 -122.389320803321 (37.7156314186226, -122.389320803321) 10 3 8 58 1
73258 201702 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 43 Gilroy St 2 Side Yard : Yard 27 Tree 1 Private 2     30 Width 0ft   6015209.27922 2088565.69519 37.7156582274311 -122.38933501442 (37.7156582274311, -122.38933501442) 10 3 8 58 1
73259 201703 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 43 Gilroy St 3 Side Yard : Yard 27 Tree 1 Private 2     39 Width 0ft   6015230.77883 2088581.00853 37.7157014668276 -122.389261770026 (37.7157014668276, -122.389261770026) 10 3 8 58 1
73260 201704 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 42 Gilroy St 1 Side Yard : Yard 27 Tree 1 Private 2     34 Width 0ft   6015220.38125 2088614.2880799999 37.7157922695756 -122.389300031678 (37.7157922695756, -122.389300031678) 10 3 8 58 1
73261 201705 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 42 Gilroy St 2 Side Yard : Yard 27 Tree 1 Private 2     7 Width 0ft   6015223.65534 2088604.14368 37.7157645965377 -122.389288006849 (37.7157645965377, -122.389288006849) 10 3 8 58 1
73262 201706 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 42 Gilroy St 4 Side Yard : Yard 27 Tree 1 Private 2     6 Width 0ft   6015220.50019 2088604.5221400002 37.7157654607945 -122.38929893900601 (37.7157654607945, -122.389298939006) 10 3 8 58 1
73263 201707 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 42 Gilroy St 3 Side Yard : Yard 27 Tree 1 Private 2     15 Width 0ft   6015219.60254 2088607.0599200001 37.7157723792799 -122.389302218834 (37.7157723792799, -122.389302218834) 10 3 8 58 1
74826 20351 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 60                      
74837 20352 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74848 20353 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 60                      
74859 20354 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74870 20355 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 5 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74881 20356 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 6 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74892 20357 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 7 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74903 20358 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 8 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74914 20359 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 9 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74926 20360 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 10 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74937 20361 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 11 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74948 20362 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 12 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
74959 20363 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 13 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 60                      
74970 20364 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 262X Sunset Blvd 14 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60                      
75002 203672 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 1650 18th Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 4ft   5990615.48268 2104135.94174 37.757015979912794 -122.47547768906901 (37.7570159799128, -122.475477689069) 1 8 4 56 12
90947 220114 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 130 Belgrave Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 2ft   5997929.61055 2104920.40859 37.759591201186204 -122.45023932650801 (37.7595912011862, -122.450239326508) 15 5 11 29492 12
90948 220115 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 456 Belvedere St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 4ft   5998557.4561 2106556.13282 37.7641184000685 -122.448185715597 (37.7641184000685, -122.448185715597) 15 5 11 29492 9
90949 220116 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 1294 Stanyan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   5997564.34231 2104932.51093 37.759603520995604 -122.451503472906 (37.7596035209956, -122.451503472906) 15 5 11 29492 12
118218 246629 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 3300 Harrison St 7 Side Yard : Yard 27 Tree 1 Private 2     11     6009040.22496 2099335.66052 37.744886304570606 -122.411418580397 (37.7448863045706, -122.411418580397) 2 7 7 28859 2
119481 247845 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 151 Chapman St 3 Side Yard : Yard 27 Tree 1 Private 2     17     6009128.636519999 2098211.49028 37.7418045383421 -122.41103347993 (37.7418045383421, -122.41103347993) 10 7 7 28859 2
119483 247847 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 149 Chapman St 2 Side Yard : Yard 27 Tree 1 Private 2     19     6009164.829969999 2098210.04366 37.7418025958088 -122.410908232241 (37.7418025958088, -122.410908232241) 10 7 7 28859 2
119743 248084 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 15 Montcalm St 1 Side Yard : Yard 27 Tree 1 Private 2     9     6010670.84523 2100349.03377 37.7477601313264 -122.40585153953998 (37.7477601313264, -122.40585153954) 2 7 7 28859 2
179962 86925 Permitted Site 2 Acacia decurrens :: Acacia: Silver Wattle 15 746 Carolina St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/08/2007 12:00:00 AM   3x3 Permit Number 49882 6012399.0 2104446.0 37.7591060051571 -122.40016332416401 (37.7591060051571, -122.400163324164) 10 3 8 28856 29
179963 86926 Permitted Site 2 Acacia decurrens :: Acacia: Silver Wattle 15 746 Carolina St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/08/2007 12:00:00 AM   3x3 Permit Number 49882 6012399.0 2104446.0 37.7591060051571 -122.40016332416401 (37.7591060051571, -122.400163324164) 10 3 8 28856 29
184968 92794 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 15 999 Wisconsin St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/22/2009 12:00:00 AM 3   Permit Number 52022 6012812.69075 2102940.3148 37.754994780604704 -122.398626914107 (37.7549947806047, -122.398626914107) 10 3 8 28856 29
191005 99434 Undocumented 3 Acacia decurrens :: Acacia: Silver Wattle 15 244 Glenview Dr 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5999066.0 2100737.0 37.7481695560511 -122.44600824337601 (37.7481695560511, -122.446008243376) 2 5 5 63 38
191006 99435 Undocumented 3 Acacia decurrens :: Acacia: Silver Wattle 15 244 Glenview Dr 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5999066.0 2100737.0 37.7481695560511 -122.44600824337601 (37.7481695560511, -122.446008243376) 2 5 5 63 38

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 19.664ms · Data source: data.sfgov.org