Street_Tree_List

Data source: data.sfgov.org

37 rows where DBH = 3, PlotSize = "Width 0ft" and qSpecies = 48

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
179 182083 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1101 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:33:00 PM 3 Width 0ft   5989775.2775 2098997.3719 37.742858080169505 -122.47800774412599 (37.7428580801695, -122.478007744126)
1386 183693 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983046.6569 2105897.5428 37.7614111825323 -122.501783460946 (37.7614111825323, -122.501783460946)
1390 183692 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983047.3598 2105912.7714 37.761453037237 -122.501782156698 (37.761453037237, -122.501782156698)
1404 183694 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983048.5312 2105875.9885 37.7613521106328 -122.501775383852 (37.7613521106328, -122.501775383852)
1408 183696 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983051.3079 2105837.6039 37.7612468805065 -122.50176294055599 (37.7612468805065, -122.501762940556)
1417 183690 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983045.4855 2105953.0685 37.7615635715471 -122.50179162058001 (37.7615635715471, -122.50179162058)
1419 183699 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983053.3747 2105791.1008 37.761119317578505 -122.501752351825 (37.7611193175785, -122.501752351825)
1428 183691 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983046.4226 2105931.5142 37.76150444459871 -122.50178678479799 (37.7615044445987, -122.501786784798)
1430 183687 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft Permit Number 33196 5983043.3769 2106010.2341 37.7617204082059 -122.50180314292801 (37.7617204082059, -122.501803142928)
3913 253116 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 12:00:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3915 160069 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:26:00 AM 3 Width 0ft   6000296.79811 2090527.7878900003 37.7202076512361 -122.441019880684 (37.7202076512361, -122.441019880684)
3918 253108 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:41:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3922 160059 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 10:50:00 AM 3 Width 0ft   6000588.557440001 2091082.6412900002 37.7217477663201 -122.440051133668 (37.7217477663201, -122.440051133668)
3928 253114 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 24 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:55:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3934 160071 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:31:00 AM 3 Width 0ft   6000209.4859 2090450.10808 37.7199893866688 -122.44131611827 (37.7199893866688, -122.44131611827)
3935 160073 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:36:00 AM 3 Width 0ft   6000082.999340001 2090399.7386 37.7198438772755 -122.44174972458201 (37.7198438772755, -122.441749724582)
3937 253112 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:51:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3939 160065 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:13:00 AM 3 Width 0ft   6000417.53141 2090750.6791299998 37.7208265358932 -122.440618525839 (37.7208265358932, -122.440618525839)
3946 160063 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:07:00 AM 3 Width 0ft   6000471.59074 2090857.9533099998 37.7211241647202 -122.440439349407 (37.7211241647202, -122.440439349407)
3950 162332 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 36 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:06:00 PM 3 Width 0ft   5996526.7373 2090117.21242 37.718864853708205 -122.45402201441001 (37.7188648537082, -122.45402201441)
3960 160061 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:02:00 AM 3 Width 0ft   6000547.454419999 2091000.21878 37.7215191128017 -122.440187308101 (37.7215191128017, -122.440187308101)
3968 253118 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 28 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 01:35:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3973 253110 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:46:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3974 162331 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 26 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:09:00 PM 3 Width 0ft   5996526.61739 2090076.5104099999 37.7187530886569 -122.454019490912 (37.7187530886569, -122.454019490912)
3982 159338 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 517 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:04:00 AM 3 Width 0ft   5998112.9338 2087183.20699 37.7108995709325 -122.44832801714199 (37.7108995709325, -122.448328017142)
3992 159336 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 523 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 10:36:00 AM 3 Width 0ft   5998080.57171 2087152.95418 37.7108146533454 -122.448437690352 (37.7108146533454, -122.448437690352)
4058 159346 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:49:00 AM 3 Width 0ft   5998276.6806 2087336.8062099998 37.7113306798385 -122.44777312285 (37.7113306798385, -122.44777312285)
4070 159339 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 517 Ellington Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:12:00 AM 3 Width 0ft   5998126.4578599995 2087195.02696 37.710932799068104 -122.44828212563 (37.7109327990681, -122.44828212563)
4072 159348 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:44:00 AM 3 Width 0ft   5998312.68186 2087372.3667799998 37.711430378688796 -122.447651252104 (37.7114303786888, -122.447651252104)
4077 159345 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:39:00 AM 3 Width 0ft   5998268.07471 2087327.6085 37.7113049331395 -122.447802205131 (37.7113049331395, -122.447802205131)
4091 159347 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:27:00 AM 3 Width 0ft   5998288.37354 2087349.92963 37.711367382076396 -122.44773365338999 (37.7113673820764, -122.44773365339)
48320 140696 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 162 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5997358.0622 2109907.9029 37.7732528619693 -122.452575957146 (37.7732528619693, -122.452575957146)
60263 247309 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 220 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6002790.9139 2109368.8454 37.7720825259473 -122.43374447503099 (37.7720825259473, -122.433744475031)
70054 184494 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1875 38th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5984410.615 2102424.5695 37.7519553887834 -122.496809845733 (37.7519553887834, -122.496809845733)
131222 247385 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 355 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6002203.8017 2109776.7723 37.7731692596784 -122.435804531936 (37.7731692596784, -122.435804531936)
153529 183672 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1254 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5984312.3195 2106638.1262 37.7635188796404 -122.497460805156 (37.7635188796404, -122.497460805156)
162586 183640 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1484 47th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5981572.1323 2104991.2828 37.7588361283195 -122.506815916291 (37.7588361283195, -122.506815916291)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 523.124ms · Data source: data.sfgov.org