Street_Tree_List

Data source: data.sfgov.org

44 rows where PlotSize = "3x3", qLegalStatus = 3 and qSpecies = 59

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1336 7171 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 801 Fillmore St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3 Permit Number 780067 6003475.9145 2111120.5411 37.7769310959731 -122.431500078765 (37.7769310959731, -122.431500078765)
1340 7172 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 801 Fillmore St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3 Permit Number 780067 6003478.683999999 2111101.7087 37.7768795438362 -122.43148915347099 (37.7768795438362, -122.431489153471)
1343 7169 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 801 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3 Permit Number 780067 6003470.3756 2111160.9753 37.777041804334296 -122.43152212680799 (37.7770418043343, -122.431522126808)
1345 7170 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 801 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3 Permit Number 780067 6003473.1451 2111141.589 37.776988731328295 -122.43151116193 (37.7769887313283, -122.43151116193)
1838 9642 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1482 Golden Gate Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3x3   6002517.4506 2111986.4237 37.7792542228164 -122.43487763237101 (37.7792542228164, -122.434877632371)
4206 13097 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1475 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6005336.846 2119866.4127 37.801050369840205 -122.42568517574 (37.8010503698402, -122.42568517574)
5422 4684 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 722 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6009311.9987 2119994.7358 37.801626533850204 -122.411938460907 (37.8016265338502, -122.411938460907)
7272 14849 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1344 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6002734.6717 2111669.6476 37.7783967656122 -122.43410352432501 (37.7783967656122, -122.434103524325)
7736 20147 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1025 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/13/1989 12:00:00 AM 12 3x3   6002893.7013 2111823.32 37.778827735903604 -122.433564367127 (37.7788277359036, -122.433564367127)
7852 14863 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1398 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6002510.6756 2111638.0989 37.77829742557871 -122.434876152922 (37.7782974255787, -122.434876152922)
8320 9641 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1482 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6002541.4785 2111991.5 37.77926952525671 -122.434794873127 (37.7792695252567, -122.434794873127)
9534 8072 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 661 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6005345.6576 2111619.4154 37.778406678029796 -122.425067563729 (37.7784066780298, -122.425067563729)
10079 492 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2749X 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6010397.1581 2102215.0511 37.752868494158704 -122.406929439613 (37.7528684941587, -122.406929439613)
10272 531 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2847 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     23 3x3   6009825.6422 2102183.2205 37.752749097586296 -122.408903610932 (37.7527490975863, -122.408903610932)
11043 15768 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 4770 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/29/2007 12:00:00 AM 15 3x3   6001444.506 2091085.1877 37.721803449313896 -122.437092531149 (37.7218034493139, -122.437092531149)
13519 113149 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1035X Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3x3   6010826.0688 2111360.9298 37.7780049945656 -122.406090456701 (37.7780049945656, -122.406090456701)
14599 7391 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1035X Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/28/1992 12:00:00 AM 30 3x3   6010784.4697 2111320.9947 37.77789301527721 -122.40623154915001 (37.7778930152772, -122.40623154915)
14749 7388 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1035X Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3   6010798.3361 2111334.861 37.7779318645299 -122.406184557349 (37.7779318645299, -122.406184557349)
14753 7389 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1035X Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3   6010809.9838 2111345.3995 37.7779614523005 -122.406145006296 (37.7779614523005, -122.406145006296)
16043 7390 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1035X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3   6010768.3847 2111305.4643 37.7778494726714 -122.40628609857299 (37.7778494726714, -122.406286098573)
17018 4509 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1807X Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5998320.8634 2109271.3175 37.7715600792218 -122.44919964223699 (37.7715600792218, -122.449199642237)
17157 16991 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 899 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6002773.5007 2109890.2869 37.7735132873347 -122.433841985714 (37.7735132873347, -122.433841985714)
17194 5146 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 217 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6001830.6224 2108865.7235 37.7706465411236 -122.437030167851 (37.7706465411236, -122.437030167851)
17284 16993 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 900 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6002625.7759 2109923.0859 37.7735949613156 -122.434355332323 (37.7735949613156, -122.434355332323)
17429 529 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2833 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6009902.781 2102188.0955 37.7527668038666 -122.408637193736 (37.7527668038666, -122.408637193736)
18044 4510 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1805X Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5998343.9349 2109273.4537 37.7715672642721 -122.449119990901 (37.7715672642721, -122.449119990901)
18224 494 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2749X 24th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6010448.7752 2102218.4922 37.752880830855496 -122.40675117970801 (37.7528808308555, -122.406751179708)
18297 513 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2792 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6010090.1844 2102241.1856 37.752923071613495 -122.40799285948499 (37.7529230716135, -122.407992859485)
18610 487 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2718 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6010403.4669 2102258.6388 37.7529885293488 -122.406910694342 (37.7529885293488, -122.406910694342)
18753 498 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2752 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6010250.9097 2102250.6095 37.7529579449469 -122.40743770281999 (37.7529579449469, -122.40743770282)
18907 481 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2700 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6010503.8335 2102264.9476 37.753011467555204 -122.406564050249 (37.7530114675552, -122.406564050249)
18981 15282 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1600 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6007118.1667 2109554.742 37.7728375468829 -122.418789312367 (37.7728375468829, -122.418789312367)
19249 17087 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1621 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5999187.9651 2109387.1019 37.7719275511448 -122.446208630434 (37.7719275511448, -122.446208630434)
19445 16994 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 900 Oak St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6002602.5998 2109922.2867 37.7735914513761 -122.434435444699 (37.7735914513761, -122.434435444699)
19705 17131 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2001 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5997393.7333 2109140.5793 37.771148033222794 -122.452397184671 (37.7711480332228, -122.452397184671)
20229 493 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2749X 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6010421.2461 2102217.9187 37.752877715813796 -122.406846340514 (37.7528777158138, -122.406846340514)
20300 17086 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1611 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5999247.78 2109394.7924 37.771952083100295 -122.446002280338 (37.7719520831003, -122.446002280338)
21377 16990 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 899 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6002737.3984 2109886.1011 37.773499745425795 -122.43396656947701 (37.7734997454258, -122.433966569477)
21717 491 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2749X 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6010371.9231 2102214.4775 37.7528655070754 -122.40701666692699 (37.7528655070754, -122.407016666927)
21783 17132 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2017 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5997337.3364 2109131.1798 37.7711189934376 -122.45259158414301 (37.7711189934376, -122.452591584143)
21970 524 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2826 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6009890.4218 2102229.0519 37.752878568819796 -122.408682823354 (37.7528785688198, -122.408682823354)
22559 9075 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 5612 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5989561.9341 2112697.6008 37.7804628284507 -122.47974767842399 (37.7804628284507, -122.479747678424)
22784 9074 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 5612 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5989576.4513 2112697.6008 37.780463671789 -122.47969745716499 (37.780463671789, -122.479697457165)
23341 10463 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1584 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3x3   5998533.6334 2108659.497 37.7698923436585 -122.44841959455401 (37.7698923436585, -122.448419594554)

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 2717.921ms · Data source: data.sfgov.org