Street_Tree_List

Data source: data.sfgov.org

953 rows where qSpecies = 94 sorted by TreeID

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
17077 551 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2900 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6009445.64374 2102206.2231799997 37.752790964934704 -122.41021934346 (37.7527909649347, -122.41021934346)
17372 552 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2904 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6009418.497 2102204.07854 37.7527835545272 -122.41031307080699 (37.7527835545272, -122.410313070807)
20570 554 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2912X 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6009391.31353 2102200.13523 37.7527712032402 -122.410406798162 (37.7527712032402, -122.410406798162)
21969 556 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2934 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6009338.079419999 2102203.4712799997 37.7527773788967 -122.410591127672 (37.7527773788967, -122.410591127672)
21452 569 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2970 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6009068.4734 2102184.68731 37.7527106833549 -122.411522150837 (37.7527106833549, -122.411522150837)
19625 571 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2970 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/30/2015 12:00:00 AM 12 3x3   6009054.006130001 2102184.0831400002 37.752708212935794 -122.411572138748 (37.7527082129358, -122.411572138748)
20802 574 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3000 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5x6   6008882.07656 2102170.50291 37.7526612791072 -122.412165744373 (37.7526612791072, -122.412165744373)
18722 576 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3008 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008852.23919 2102169.31321 37.7526563382221 -122.412268843556 (37.7526563382221, -122.412268843556)
17601 577 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3024 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008801.63126 2102168.54838 37.752651398249604 -122.41244380126301 (37.7526513982496, -122.412443801263)
18516 580 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3013 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008848.9981 2102129.16474 37.7525459176681 -122.412277214445 (37.7525459176681, -122.412277214445)
17916 587 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3041 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6008724.79045 2102125.26547 37.7525282406021 -122.41270647162202 (37.7525282406021, -122.412706471622)
1507 590 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3049 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6008590.89573 2102118.12773 37.7525011260356 -122.413168999261 (37.7525011260356, -122.413168999261)
20951 592 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3056 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6008558.8392900005 2102157.7680200003 37.752608169649 -122.41328265918699 (37.752608169649, -122.413282659187)
21673 596 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3066 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 3x3   6008530.73419 2102152.9446900003 37.752593347917596 -122.413379510765 (37.7525933479176, -122.413379510765)
19889 597 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3067 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008545.44191 2102115.03145 37.7524900724667 -122.41332596783998 (37.7524900724667, -122.41332596784)
18661 598 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3070 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 3x3   6008489.074019999 2102147.94889 37.75257729142999 -122.41352322603399 (37.75257729143, -122.413523226034)
19961 600 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3078 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 3x3   6008460.582 2102146.28241 37.7525711157729 -122.41362163882401 (37.7525711157729, -122.413621638824)
19855 602 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3085 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5x5   6008423.83472 2102105.59165 37.7524573245683 -122.413745839724 (37.7524573245683, -122.413745839724)
21513 604 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3090 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 3x3   6008414.92242 2102144.51738 37.752563705358604 -122.413779413197 (37.7525637053586, -122.413779413197)
20158 605 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3098 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6008383.72095 2102142.9064 37.752557529712895 -122.41388719964701 (37.7525575297129, -122.413887199647)
20360 611 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3108 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008224.09237 2102134.47643 37.752525416718 -122.41443862795799 (37.752525416718, -122.414438627958)
21465 612 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3114 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3x3   6008205.07322 2102132.16672 37.7525180063146 -122.41450423619601 (37.7525180063146, -122.414504236196)
19935 613 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3124 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   6008177.96308 2102131.82169 37.7525155358782 -122.41459796353998 (37.7525155358782, -122.41459796354)
20356 620 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3145 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6008061.58213 2102085.15012 37.752380847108604 -122.41499712672 (37.7523808471086, -122.41499712672)
18768 622 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3150 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3x3   6007969.891890001 2102118.08704 37.7524661316063 -122.415316538925 (37.7524661316063, -122.415316538925)
18462 623 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3158 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6007941.8237 2102115.0630200002 37.7524562507759 -122.415413389641 (37.7524562507759, -122.415413389641)
17117 625 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3160 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 4x6   6007920.1411 2102115.05717 37.7524550160009 -122.415488371495 (37.7524550160009, -122.415488371495)
20796 626 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3155 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6007952.38293 2102079.53558 37.752359293949795 -122.415374359065 (37.7523592939498, -122.415374359065)
20532 627 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3168 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3x3   6007870.94281 2102116.96374 37.752457485548796 -122.415658642859 (37.7524574855488, -122.415658642859)
18232 630 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3176 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 3x3   6007837.40103 2102111.35303 37.752440194268395 -122.41577423901501 (37.7524401942684, -122.415774239015)
18228 633 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3182 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3x3   6007808.47554 2102110.59584 37.7524364890666 -122.415874214834 (37.7524364890666, -122.415874214834)
17807 640 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3214 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6007574.72227 2102100.08892 37.7523944952223 -122.41668183031601 (37.7523944952223, -122.416681830316)
20895 641 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3208 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6007604.52296 2102099.47851 37.7523944952114 -122.41657873113 (37.7523944952114, -122.41657873113)
20129 642 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3225 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x4   6007512.22413 2102054.36572 37.7522654344184 -122.416894720512 (37.7522654344184, -122.416894720512)
17817 643 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3224 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6007548.56119 2102101.97423 37.752398200442 -122.41677243341199 (37.752398200442, -122.416772433412)
20011 644 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3245 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6007452.42683 2102052.29911 37.75225639624 -122.41710136313101 (37.75225639624, -122.417101363131)
20968 655 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3255X 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   06/02/1992 12:00:00 AM 12 3x4   6007319.73993 2102042.10408 37.7522209377659 -122.41755949396901 (37.7522209377659, -122.417559493969)
19861 656 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3255X 24th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     12 4x4   6007336.00672 2102041.77073 37.7522209377618 -122.41750321711099 (37.7522209377618, -122.417503217111)
22195 1351 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 271 Amber Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   5999796.36324 2099302.3291700003 37.7442719740833 -122.443379644158 (37.7442719740833, -122.443379644158)
19453 1923 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 78 Berkeley Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6001189.660619999 2097346.8097900003 37.7389819342562 -122.43842185440901 (37.7389819342562, -122.438421854409)
17222 3468 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3231 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 4x4   6007477.096919999 2102052.55322 37.752258481762 -122.41701606785601 (37.752258481762, -122.417016067856)
21001 5127 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2764 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/1994 12:00:00 AM 15 3X3   6002472.72131 2095943.62285 37.7352020045603 -122.433885356532 (37.7352020045603, -122.433885356532)
21680 5133 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2796 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6002464.77756 2095726.89475 37.734606468121704 -122.433897334607 (37.7346064681217, -122.433897334607)
19320 5332 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 125 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     90 6x7   6004849.91389 2107615.9681599997 37.7673861676625 -122.42649738994601 (37.7673861676625, -122.426497389946)
21156 5334 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 140 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3X3   6004762.96876 2107575.6784599996 37.7672706263574 -122.426795251693 (37.7672706263574, -122.426795251693)
19950 5335 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 149 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 6X8   6004854.459 2107562.68516 37.7672401222731 -122.42647787465 (37.7672401222731, -122.42647787465)
20206 5338 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 158 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5x5   6004769.98156 2107435.4149 37.766885892799 -122.426761005535 (37.766885892799, -122.426761005535)
20645 5358 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 230 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   6004797.6722800005 2107012.30465 37.765725699015604 -122.426635095043 (37.7657256990156, -122.426635095043)
20213 5371 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 266 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 6x6   6004805.70542 2106808.5131599996 37.765166590486395 -122.42659279722 (37.7651665904864, -122.42659279722)
19766 5379 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 299 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 4X4   6004899.9834 2106715.40982 37.764916280383 -122.426260083162 (37.764916280383, -122.426260083162)
21085 5576 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1040 Dolores St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X3   6005062.54747 2102282.8606 37.752754731270706 -122.425382354736 (37.7527547312707, -122.425382354736)
20031 5670 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1416 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x3   6005182.49595 2100071.1312 37.7466886088884 -122.424810216828 (37.7466886088884, -122.424810216828)
16957 5672 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1422 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3x3   6005185.06241 2100046.61651 37.7466214421279 -122.424799598532 (37.7466214421279, -122.424799598532)
21323 5685 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1506 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 5x5   6005209.87097 2099535.96992 37.7452207246578 -122.42467749309601 (37.7452207246578, -122.424677493096)
20211 5689 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1535 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3X3   6005306.00348 2099419.02782 37.74490505722029 -122.424336766952 (37.7449050572203, -122.424336766952)
19035 5708 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1603 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6005329.17263 2098980.1167599997 37.743701215741794 -122.424225442544 (37.7437012157418, -122.424225442544)
17131 5742 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1755 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6005373.18109 2098196.81653 37.741552935912 -122.424017580443 (37.741552935912, -122.424017580443)
21076 5748 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1770 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 5X5   6005291.423690001 2098088.82872 37.7412518096224 -122.424292591354 (37.7412518096224, -122.424292591354)
13606 6798 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1375 Fairfax Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x9   6016915.23611 2097187.56543 37.7394266247399 -122.38403843113701 (37.7394266247399, -122.384038431137)
23078 7496 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2696 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6008261.6755800005 2102751.78327 37.754222512965995 -122.414352332587 (37.754222512966, -122.414352332587)
20538 10222 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1375-1377 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6005868.37697 2101019.32612 37.7493308512387 -122.422505871374 (37.7493308512387, -122.422505871374)
17377 12244 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 401X Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X3   6005028.531359999 2110211.81183 37.7745238232573 -122.426064391571 (37.7745238232573, -122.426064391571)
11475 13369 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 900 Mansell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3X50   6009189.31279 2090017.3428599997 37.71930856033371 -122.410245275395 (37.7193085603337, -122.410245275395)
1622 15770 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 4770 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/29/2007 12:00:00 AM 3 3X3   6001421.7162 2091049.3752 37.721703820816394 -122.43716874658399 (37.7217038208164, -122.437168746584)
20144 16900 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 409 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005007.3916 2110203.70331 37.774500364432505 -122.426136940772 (37.7745003644325, -122.426136940772)
17445 16902 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 427 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004930.51635 2110189.46412 37.7744569217764 -122.42640185318899 (37.7744569217764, -122.426401853189)
16901 16914 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 483 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004697.20239 2110157.0841200002 37.77435482265879 -122.427206624104 (37.7743548226588, -122.427206624104)
20778 22835 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 104 Turquoise Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/14/1994 12:00:00 AM 20 2X2   5999575.13645 2098938.39255 37.743260073094504 -122.44411845071899 (37.7432600730945, -122.444118450719)
18629 23094 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1384 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/1992 12:00:00 AM 3 3x3   6006412.34173 2101544.72785 37.750804156590206 -122.42066211905701 (37.7508041565902, -122.420662119057)
21797 23099 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1406 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 5x4   6006424.41645 2101384.80463 37.7503657245067 -122.420609012309 (37.7503657245067, -122.420609012309)
16970 23100 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1406 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     27 3X3   6006427.47457 2101357.7543900004 37.7502916230775 -122.42059651712098 (37.7502916230775, -122.420596517121)
20574 23101 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1406 Valencia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     28 3X3   6006426.26721 2101342.93585 37.7502508667074 -122.420599640465 (37.7502508667074, -122.420599640465)
7271 23546 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2805 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005607.92942 2120044.70688 37.801555234346104 -122.424759800825 (37.8015552343461, -122.424759800825)
18141 24446 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1156 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6006345.52984 2102866.64807 37.754430080088895 -122.420987008139 (37.7544300800889, -122.420987008139)
20215 24447 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1156 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6006347.0218400005 2102851.3253900004 37.754388091646 -122.420980760555 (37.754388091646, -122.420980760555)
20042 24448 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1156 Valencia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6006348.61536 2102840.94797 37.7543596874688 -122.420974512988 (37.7543596874688, -122.420974512988)
17762 24449 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1156 Valencia St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6006348.4307699995 2102831.95647 37.7543349884778 -122.420974512988 (37.7543349884778, -122.420974512988)
20707 24450 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1384 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6006415.18821 2101529.37673 37.7507621663522 -122.42065118602301 (37.7507621663522, -122.420651186023)
17610 24602 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 419 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6007254.49022 2097303.30919 37.7392055992492 -122.41744932972401 (37.7392055992492, -122.417449329724)
19544 24603 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 407 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X2   6007220.87336 2097309.53692 37.739220807683296 -122.41756600326401 (37.7392208076833, -122.417566003264)
23132 25364 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 994 Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6000636.2417 2088870.0556299998 37.7156752201082 -122.43972775363001 (37.7156752201082, -122.43972775363)
11311 25396 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 945 Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   6000465.251630001 2089064.76788 37.7162001220051 -122.440332727576 (37.7162001220051, -122.440332727576)
13913 26001 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1711 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6014400.39468 2095925.2599900002 37.735821239067796 -122.392645436853 (37.7358212390678, -122.392645436853)
14200 26002 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1711 Oakdale Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6014429.78226 2095903.68978 37.7357636437757 -122.392542323281 (37.7357636437757, -122.392542323281)
16498 26003 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1711 Oakdale Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6014451.27252 2095887.995 37.7357217425631 -122.39246692501999 (37.7357217425631, -122.39246692502)
16905 26220 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 765X San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6005701.2867 2098677.11468 37.7428902448864 -122.422917229343 (37.7428902448864, -122.422917229343)
18006 26514 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2880 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6008952.92902 2101706.37447 37.7513908617048 -122.411887928494 (37.7513908617048, -122.411887928494)
20672 26517 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2883 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3X3   6009010.68122 2101716.60139 37.7514221824079 -122.411688936397 (37.7514221824079, -122.411688936397)
20104 26548 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3085 24th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6008470.90767 2102107.16108 37.752464277228 -122.41358316405399 (37.752464277228, -122.413583164054)
11743 28251 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3340 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6011988.71606 2089960.7357 37.7193096502899 -122.40056475438101 (37.7193096502899, -122.400564754381)
12579 28252 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3342 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6011993.05449 2089944.3685299999 37.7192649513087 -122.40054860885598 (37.7192649513087, -122.400548608856)
21401 28743 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 750 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6005621.9935800005 2098694.18206 37.742932633526 -122.42319261615 (37.742932633526, -122.42319261615)
91480 30505 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1500 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 34518 6007587.04685478 2110100.36731732 37.7743620934089 -122.417206068405 (37.7743620934089, -122.417206068405)
81461 30532 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1020 Harrison St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.776812772940005 -122.404779881684 (37.77681277294, -122.404779881684)
85365 30533 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1020 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.776812772940005 -122.404779881684 (37.77681277294, -122.404779881684)
81288 30534 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1020 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.776812772940005 -122.404779881684 (37.77681277294, -122.404779881684)
146184 30538 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 614 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 34538 6003619.86564688 2110438.7017887 37.775067091373295 -122.43095343382099 (37.7750670913733, -122.430953433821)
109018 30843 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1375 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/14/1995 12:00:00 AM     Permit Number 34691 6011743.60320296 2101979.83639733 37.7522978969141 -122.40225661865 (37.7522978969141, -122.40225661865)
91059 30886 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1440 Kearny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 34718 6011020.35277298 2119822.53522602 37.8012494094877 -122.40601460797501 (37.8012494094877, -122.406014607975)
141323 30890 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 412 Hayes St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/08/1995 12:00:00 AM     Permit Number 34719 6005865.19335847 2111068.58127823 37.7769235557198 -122.423231126893 (37.7769235557198, -122.423231126893)

Next page

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