Street_Tree_List

Data source: data.sfgov.org

2,323 rows where qSpecies = 46 sorted by TreeID

View and edit SQL

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
17419 7534 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2834 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3x3   6008307.18508 2101915.21999 37.7519280555366 -122.41413576777398 (37.7519280555366, -122.414135767774)
95054 7535 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2840 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/10/2011 12:00:00 AM 18 5x5   6008283.0 2101875.0 37.7518162620418 -122.414216558168 (37.7518162620418, -122.414216558168)
20924 7536 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2840 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/19/2011 12:00:00 AM 18 3x3   6008309.449109999 2101885.9528099997 37.7518478216207 -122.414125868034 (37.7518478216207, -122.414125868034)
21762 7538 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2850 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008311.6922 2101838.15576 37.751716707677005 -122.414114729924 (37.751716707677, -122.414114729924)
19825 7539 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2857 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008370.65475 2101801.07309 37.7516181986274 -122.41390820600701 (37.7516181986274, -122.413908206007)
113026 7540 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2863 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6008408.04234 2101806.11331 37.75163413761621 -122.41377927099701 (37.7516341376162, -122.413779270997)
17627 7541 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2862 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008316.9211099995 2101778.89436 37.7515542829106 -122.414092455501 (37.7515542829106, -122.414092455501)
118591 7542 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2865 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6008399.627 2101758.5363 37.7515030292582 -122.41380500737199 (37.7515030292582, -122.413805007372)
17333 7543 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2872 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6008316.06064 2101754.32335 37.7514867681181 -122.41409369299299 (37.7514867681181, -122.414093692993)
21656 7544 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2872 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008318.08385 2101730.76273 37.751422189596 -122.414085029817 (37.751422189596, -122.414085029817)
17485 7545 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2873 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6008374.1374 2101703.06598 37.7513492887427 -122.41388923032301 (37.7513492887427, -122.413889230323)
21393 7546 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2877 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008375.68859 2101675.71306 37.751274270892 -122.413881931411 (37.751274270892, -122.413881931411)
17234 7547 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2880 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008318.28918 2101705.8135599997 37.7513536963225 -122.414082554892 (37.7513536963225, -122.414082554892)
583 7548 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2882 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 5x5   6008321.80095 2101666.80438 37.751246783135 -122.414067651319 (37.751246783135, -122.414067651319)
20424 7549 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2883 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3X3   6008378.51382 2101648.7543099998 37.7512004068929 -122.413870254611 (37.7512004068929, -122.413870254611)
17404 7550 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2888 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008324.12517 2101635.93861 37.75116216321621 -122.414057430518 (37.7511621632162, -122.414057430518)
99456 7551 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2889 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6008375.88429 2101615.45305 37.7511088214431 -122.41387699241899 (37.7511088214431, -122.413876992419)
19588 7552 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2894 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/2007 12:00:00 AM 3 3x3   6008324.51175 2101611.42037 37.751094863355895 -122.414054359326 (37.7510948633559, -122.414054359326)
17323 7553 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2896 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3X3   6008325.6957 2101595.54831 37.751051348745996 -122.41404914235001 (37.751051348746, -122.41404914235)
18939 7554 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2906 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008330.04331 2101493.18506 37.7507705264571 -122.414026867047 (37.7507705264571, -122.414026867047)
17428 7555 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2906 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008330.30695 2101471.08552 37.750709860893394 -122.41402439212601 (37.7507098608934, -122.414024392126)
21774 7556 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2908 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/02/2005 12:00:00 AM 3 4X4   6008332.644180001 2101445.38004 37.7506394106909 -122.41401449147301 (37.7506394106909, -122.414014491473)
19814 7557 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2909 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/21/2011 12:00:00 AM 3 4x4   6008393.46054 2101471.49038 37.7507145193727 -122.413806029524 (37.7507145193727, -122.413806029524)
21495 7558 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2914 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/02/2005 12:00:00 AM 3 3x3   6008334.08225 2101415.12982 37.7505564311505 -122.414007378743 (37.7505564311505, -122.414007378743)
18102 7559 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2915 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   6008391.206590001 2101423.19839 37.750581793832005 -122.413810408316 (37.750581793832, -122.413810408316)
21564 7560 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2918 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008338.44221 2101396.4402400004 37.7505053586356 -122.41399097961599 (37.7505053586356, -122.413990979616)
17190 7561 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2921 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 4X4   6008393.481319999 2101389.9459599997 37.750490617869296 -122.41380019023899 (37.7504906178693, -122.413800190239)
17424 7562 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2924 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/14/2013 12:00:00 AM 3 5x5   6008336.41396 2101367.26054 37.7504251238168 -122.41399592947201 (37.7504251238168, -122.413995929472)
19289 7563 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2928 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/05/2011 12:00:00 AM 3 3x3   6008338.378930001 2101340.84965 37.7503527158034 -122.413987266292 (37.7503527158034, -122.413987266292)
21542 7565 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2933 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 4X4   6008395.085519999 2101323.9209 37.7503094179601 -122.413789973034 (37.7503094179601, -122.413789973034)
121264 7567 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2940 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008316.60715 2101278.9723 37.750181591677396 -122.414058177859 (37.7501815916774, -122.414058177859)
14561 7568 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2941 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008397.77442 2101269.6431 37.7501605343002 -122.413776835747 (37.7501605343002, -122.413776835747)
19140 7569 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2951 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 5x5   6008400.77269 2101230.49082 37.750053199295 -122.413763698449 (37.750053199295, -122.413763698449)
19200 7570 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2960 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008348.00397 2101217.6000099997 37.7500148405247 -122.413945264386 (37.7500148405247, -122.413945264386)
88731 7571 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2961 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3x3   6008420.23555 2101188.1699900003 37.749938088747605 -122.41369340153601 (37.7499380887476, -122.413693401536)
17345 7572 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2966 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 4X4   6008349.712309999 2101178.7554599997 37.7499082780476 -122.413936609292 (37.7499082780476, -122.413936609292)
91861 7573 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2969X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008400.46895 2101159.93411 37.74985944932929 -122.413759758659 (37.7498594493293, -122.413759758659)
17777 7574 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2970 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008349.21001 2101154.19809 37.749840820806 -122.413936609291 (37.749840820806, -122.413936609291)
20069 7575 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2970 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 4x4   6008351.10034 2101124.2510900004 37.749758699223705 -122.413927954233 (37.7497586992237, -122.413927954233)
19953 7576 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2978 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 4X4   6008351.0872599995 2101088.6463 37.749660935717 -122.413925481097 (37.749660935717, -122.413925481097)
21976 7577 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2986 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6008351.27775 2101063.00668 37.7495905457652 -122.413923008859 (37.7495905457652, -122.413923008859)
21812 7578 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2981 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/31/2011 12:00:00 AM 3 3x3   6008415.2713 2101072.56886 37.749620395175704 -122.413702392551 (37.7496203951757, -122.413702392551)
17189 7579 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2995 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 4x4   6008416.03486 2101001.24422 37.7494245965646 -122.41369470787 (37.7494245965646, -122.41369470787)
21130 7580 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2994 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6008356.81629 2101001.6523 37.7494223914388 -122.41389951674401 (37.7494223914388, -122.413899516744)
89821 7582 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3000X Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6008378.51714 2100951.63552 37.7492862752884 -122.41382093686701 (37.7492862752884, -122.413820936867)
96332 7583 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3000X Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3X3   6008378.51714 2100951.63552 37.7492862752884 -122.41382093686701 (37.7492862752884, -122.413820936867)
105072 7584 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3000X Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     50 3X3   6008378.51714 2100951.63552 37.7492862752884 -122.41382093686701 (37.7492862752884, -122.413820936867)
98874 7585 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3000X Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008378.51714 2100951.63552 37.7492862752884 -122.41382093686701 (37.7492862752884, -122.413820936867)
109710 7588 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3000X Folsom St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008378.51714 2100951.63552 37.7492862752884 -122.41382093686701 (37.7492862752884, -122.413820936867)
117283 7590 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3025 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6008718.17 2100791.65733 37.748866079627206 -122.41263509881 (37.7488660796272, -122.41263509881)
92031 7591 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3025 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x4   6008718.17 2100791.65733 37.748866079627206 -122.41263509881 (37.7488660796272, -122.41263509881)
112146 7592 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3065 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6008718.17 2100791.65733 37.748866079627206 -122.41263509881 (37.7488660796272, -122.41263509881)
141612 7593 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3065 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/28/1992 12:00:00 AM 6 3X3   6008718.17 2100791.65733 37.748866079627206 -122.41263509881 (37.7488660796272, -122.41263509881)
17364 7595 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3079 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008433.91036 2100662.40633 37.7484952272826 -122.413608931409 (37.7484952272826, -122.413608931409)
119628 7596 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3085 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008718.17 2100791.65733 37.748866079627206 -122.41263509881 (37.7488660796272, -122.41263509881)
19010 7597 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3106 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008396.4425 2100409.14848 37.747797733781795 -122.41372058405099 (37.7477977337818, -122.413720584051)
17173 7598 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3106 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6008393.64019 2100437.22493 37.7478746680801 -122.41373225995702 (37.7478746680801, -122.413732259957)
17755 7599 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3106 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X3   6008391.53469 2100462.67214 37.747944422200796 -122.413741340393 (37.7479444222008, -122.413741340393)
20811 7600 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3106 Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008389.36019 2100484.75835 37.748004943889605 -122.413750421747 (37.7480049438896, -122.413750421747)
145668 7601 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3127 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/23/2011 12:00:00 AM 3 3x3   6008460.24171 2100469.91585 37.7479681699401 -122.413504265914 (37.7479681699401, -122.413504265914)
111374 7602 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3129 FOLSOM ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008475.0 2100384.0 37.7477330928409 -122.413447156935 (37.7477330928409, -122.413447156935)
17684 7603 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3143 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/20/1997 12:00:00 AM 20 5x5   6008454.26481 2100356.41026 37.7476561733017 -122.413516907381 (37.7476561733017, -122.413516907381)
120317 7604 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3135 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6008451.38096 2100365.34568 37.7476805460435 -122.41352751146799 (37.7476805460435, -122.413527511468)
20038 7605 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3161 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008457.15281 2100295.8297099997 37.747489994777105 -122.413502636944 (37.7474899947771, -122.413502636944)
21407 7606 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3165 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008459.42733 2100260.29181 37.747392543336794 -122.413492258783 (37.7473925433368, -122.413492258783)
17555 7607 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3167 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008461.5790099995 2100237.0852799998 37.7473289441915 -122.413483177404 (37.7473289441915, -122.413483177404)
19225 7608 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3201X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3x3   6008473.46462 2100066.10981 37.7468601509795 -122.413429987917 (37.7468601509795, -122.413429987917)
21218 7609 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3201X Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008465.56489 2100101.76306 37.7469576033137 -122.413459825618 (37.7469576033137, -122.413459825618)
22097 7610 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3201X Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3x3   6008468.12704 2100135.3338200003 37.74704992500789 -122.413453339725 (37.7470499250079, -122.413453339725)
20136 7611 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3202 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008410.88803 2100143.2291900003 37.74706838989189 -122.41365182637699 (37.7470683898919, -122.413651826377)
22190 7612 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3206 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6008407.88866 2100124.9846 37.747018125884296 -122.41366090774599 (37.7470181258843, -122.413660907746)
121960 7614 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3214 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008411.06777 2100078.0669299997 37.746889478932296 -122.41364659668699 (37.7468894789323, -122.413646596687)
21399 7615 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3215 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/16/2014 02:11:00 PM 3 3x3   6008475.32345 2099918.5016 37.7464549560373 -122.413413122941 (37.7464549560373, -122.413413122941)
21648 7617 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3219 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008478.47787 2099889.29651 37.7463749424642 -122.41340015022399 (37.7463749424642, -122.413400150224)
18985 7618 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3220 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   6008417.3382 2100000.0106200003 37.746675505789796 -122.41361939413099 (37.7466755057898, -122.413619394131)
19944 7619 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3224 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6008417.80655 2099967.8717400003 37.746587285877 -122.413615501862 (37.746587285877, -122.413615501862)
19815 7623 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3238 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 5x4.1   6008419.9299 2099888.25217 37.746368787483 -122.413602529127 (37.746368787483, -122.413602529127)
22062 7624 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3240 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4x4   6008423.543409999 2099863.14752 37.746300058605 -122.41358825870199 (37.746300058605, -122.413588258702)
20701 7625 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3244 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6008426.82761 2099840.2908799998 37.7462374837687 -122.413575285989 (37.7462374837687, -122.413575285989)
21744 7626 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3250 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4x4   6008427.33483 2099791.71253 37.7461041269002 -122.41357009687799 (37.7461041269002, -122.413570096878)
21857 7627 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3254 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008428.98919 2099762.5381099996 37.746024113322 -122.41356231324801 (37.746024113322, -122.413562313248)
22205 7628 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3255 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3x3   6008489.95741 2099735.13949 37.7459523060695 -122.41334955525 (37.7459523060695, -122.41334955525)
19913 7629 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3255 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008486.89529 2099750.51965 37.7459943646489 -122.413361231161 (37.7459943646489, -122.413361231161)
22223 7630 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3255 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008486.33548 2099778.1775 37.7460702755308 -122.41336512251499 (37.7460702755308, -122.413365122515)
101710 7631 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3255 Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008510.8607 2099758.97829 37.746018935721104 -122.413278959756 (37.7460189357211, -122.413278959756)
92873 7632 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3255 Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008510.8607 2099758.97829 37.746018935721104 -122.413278959756 (37.7460189357211, -122.413278959756)
102350 7633 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3255 Folsom St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6008510.8607 2099758.97829 37.746018935721104 -122.413278959756 (37.7460189357211, -122.413278959756)
20562 7634 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3256 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6008430.659080001 2099734.11047 37.745946151106295 -122.41355452874201 (37.7459461511063, -122.413554528742)
21072 7635 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3258 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3x3   6008433.89749 2099709.0131599996 37.7458774213094 -122.41354155600901 (37.7458774213094, -122.413541556009)
19332 7636 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3268 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6008436.93734 2099674.2060599998 37.7457820194342 -122.41352858328999 (37.7457820194342, -122.41352858329)
17940 7637 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3274 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4X4   6008436.96279 2099620.40725 37.745634301277704 -122.41352469103701 (37.7456343012777, -122.413524691037)
90709 7638 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3274 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 3X3   6008420.15681 2099616.94183 37.7456238423258 -122.413582558723 (37.7456238423258, -122.413582558723)
20066 7641 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3289 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 4x4   6008504.24968 2099498.35818 37.7453029595644 -122.41328339301901 (37.7453029595644, -122.413283393019)
20361 7642 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3293 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008503.393730001 2099474.8384700003 37.745238331599396 -122.41328468984301 (37.7452383315994, -122.413284689843)
20174 7643 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3292 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3   6008441.79801 2099489.92136 37.7452762874815 -122.413498744673 (37.7452762874815, -122.413498744673)
21665 7644 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3297 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008507.0455599995 2099451.60062 37.745174730640294 -122.413270419413 (37.7451747306403, -122.413270419413)
17647 7645 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3299 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2008 12:00:00 AM 3 4x4   6008510.32989 2099428.74367 37.74511215491329 -122.41325744669201 (37.7451121549133, -122.413257446692)
17325 7646 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3301 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3x3   6008513.44624 2099397.67081 37.745027010685 -122.413244473962 (37.745027010685, -122.413244473962)
126046 7647 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3302 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 4X4   6008452.78429 2099390.30637 37.7450033836799 -122.41345371210801 (37.7450033836799, -122.413453712108)
21188 7649 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3305 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 4x4   6008514.31351 2099348.33737 37.7448916006788 -122.413237987153 (37.7448916006788, -122.413237987153)

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