sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
74708 129392 2 30 31 Casa Way 1 1 1 1     3 Width 3ft   6001624.74168 2121508.73342 37.80534928880979 -122.438648369353 (37.8053492888098, -122.438648369353)
28660 142575 2 30 2251 MASON ST 4 1 1 1     15 Width 0ft   6008927.1192 2120859.172 37.803978459247205 -122.41333149055401 (37.8039784592472, -122.413331490554)
130376 84614 1 30 2034 Beach St 1 1 1 1   06/13/2008 12:00:00 AM 3 3x3 Permit Number 50834 6000478.89565 2121006.72285 37.8039056520943 -122.442577640443 (37.8039056520943, -122.442577640443)
92502 101350 1 30 600 Chestnut St 14 1 1 1   11/01/1993 12:00:00 AM     Permit Number 32655 6008949.0 2120797.0 37.8038089789489 -122.41325137117902 (37.8038089789489, -122.413251371179)
102408 101353 1 30 600 Chestnut St 17 1 1 1   11/01/1993 12:00:00 AM     Permit Number 32655 6008949.0 2120797.0 37.8038089789489 -122.41325137117902 (37.8038089789489, -122.413251371179)
189123 84613 1 30 2029-22031 Beach St 1 1 1 1   06/13/2008 12:00:00 AM 4 3x3 Permit Number 50833 6000517.3597800005 2120966.99196 37.8037987541811 -122.442441679147 (37.8037987541811, -122.442441679147)
150955 142587 2 30 2320 Taylor St 3 1 1 1     13 Width 0ft   6008491.26 2120799.1265 37.8037891087643 -122.414835562646 (37.8037891087643, -122.414835562646)
115563 101359 1 30 2201X Mason St 4 1 1 1   11/01/1993 12:00:00 AM   5x5 Permit Number 32655 6008936.1 2120783.7 37.803771736238 -122.41329507143601 (37.803771736238, -122.413295071436)
162169 101345 1 30 600 Chestnut St 9 1 1 1   11/01/1993 12:00:00 AM 22   Permit Number 32655 6008773.8267 2120774.1665 37.803736447762795 -122.413855954453 (37.8037364477628, -122.413855954453)
120267 27626 1 30 2310X Taylor St 3 1 1 1     3 3X3   6008495.093859999 2120769.31703 37.8037074748624 -122.41482018433399 (37.8037074748624, -122.414820184334)
184446 142580 2 30 650 CHESTNUT ST 5 1 1 1     14 Width 0ft   6008660.8 2120758.6253 37.8036874273397 -122.414245990591 (37.8036874273397, -122.414245990591)
48721 33958 1 30 690 Chestnut St 3 1 1 1   04/21/1997 12:00:00 AM 15   Permit Number 37913 6008590.6293 2120749.6774 37.8036589168384 -122.414488187223 (37.8036589168384, -122.414488187223)
46474 129453 2 30 855 Chestnut St 2 9 1 1     4 Width 6ft   6007720.64474 2120576.4205400003 37.8031342846895 -122.417486534671 (37.8031342846895, -122.417486534671)
49285 129456 2 30 855 Chestnut St 5 9 1 1     3 Width 6ft   6007719.74229 2120576.43903 37.803134284681 -122.41748965894199 (37.803134284681, -122.417489658942)
65391 129455 2 30 855 Chestnut St 4 9 1 1     5 Width 6ft   6007721.09596 2120576.41129 37.8031342846798 -122.41748497255199 (37.8031342846798, -122.417484972552)
35185 129454 2 30 855 Chestnut St 3 9 1 1     5 Width 6ft   6007720.06236 2120575.53372 37.8031318169374 -122.41748848713002 (37.8031318169374, -122.41748848713)
76720 129452 2 30 855 Chestnut St 1 9 1 1     5 Width 6ft   6007720.96455 2120575.51523 37.803131816931206 -122.41748536375799 (37.8031318169312, -122.417485363758)
75243 129405 2 30 3545 Scott St 1 1 1 1     5 Width 3ft   6000706.97602 2120551.39476 37.8026684412687 -122.44175565829399 (37.8026684412687, -122.441755658294)
28468 129406 2 30 3545 Scott St 2 1 1 1     6 Width 3ft   6000708.230719999 2120533.5731200003 37.8026195792908 -122.44175003663099 (37.8026195792908, -122.441750036631)
152638 129450 2 30 1257 Lombard St 1 1 1 1     15 Width 6ft   6006338.43207 2120038.90392 37.8015805322681 -122.42223151426799 (37.8015805322681, -122.422231514268)
31094 87873 1 30 2341 Francisco St 1 1 1 1   06/13/2008 12:00:00 AM 3 3x3 Permit Number 50845 6000097.31037 2119864.70248 37.8007482115146 -122.443816038389 (37.8007482115146, -122.443816038389)
123726 35235 1 30 1077 Filbert St 1 1 1 1 1 02/17/1998 12:00:00 AM 6   Permit Number 38732 6007771.26508 2119552.1201 37.8003246614186 -122.417238733675 (37.8003246614186, -122.417238733675)
54446 129451 2 30 1147 Filbert St 1 10 1 1     9 Width 3ft   6007395.89235 2119499.90916 37.80016017810029 -122.418533970572 (37.8001601781003, -122.418533970572)
185179 61519 1 30 1161 Filbert St 1 1 1 1   08/20/1984 12:00:00 AM 7   Permit Number 21475 6007368.68612 2119491.86468 37.8001365583177 -122.418627544125 (37.8001365583177, -122.418627544125)
66909 129449 2 30 884 Union St 1 1 1 1     6 Width 3ft   6008727.37725 2119383.41122 37.799915172210206 -122.41391825502899 (37.7999151722102, -122.413918255029)
108210 122590 2 30 100 MacOndray Ln 1 14 1 1           6008161.0 2119143.0 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147)
156039 31965 1 30 1000 Green St 1 1 1 1     3   Permit Number 35367 6008195.50256 2118963.54127 37.7987324288073 -122.41572900131099 (37.7987324288073, -122.415729001311)
94707 94202 1 30 1000 Green St 1 1 1 1   06/25/2010 12:00:00 AM 6 3x3 Permit Number 53605 6008232.0 2118962.0 37.798730248485896 -122.415602598872 (37.7987302484859, -122.415602598872)
5887 94203 1 30 1000 Green St 2 1 1 1   06/25/2010 12:00:00 AM 6 3x3 Permit Number 53605 6008148.35783 2118956.03523 37.7987091687558 -122.415891605907 (37.7987091687558, -122.415891605907)
156333 129391 2 30 1851 Filbert St 2 1 1 1     1 Width 3ft   6004117.78483 2119036.12679 37.798701658520706 -122.42984439412399 (37.7987016585207, -122.429844394124)
70158 98192 2 30 1020 Green St 1 1 1 1     15 3x3   6008091.62981 2118948.72517 37.7986859077751 -122.41608738562799 (37.7986859077751, -122.416087385628)
27723 129402 2 30 3000 Lyon St 1 1 1 1     6 Width 3ft   5999090.32735 2119096.86414 37.7985824452762 -122.44724531075 (37.7985824452762, -122.44724531075)
98308 107371 2 30 448 BROADWAY   1 1 1     1 3x3   6011394.4 2118786.8 37.798426445485 -122.404647279275 (37.798426445485, -122.404647279275)
184974 42710 1 30 1600 Union St 1 1 1 1 1 09/15/2010 12:00:00 AM 10 3x3 Permit Number 53744 6005271.11771 2118900.89126 37.7983955805457 -122.42584385893 (37.7983955805457, -122.42584385893)
180480 143382 2 30 1600 UNION ST 1 1 1 1     8 Width 0ft   6005275.1713 2118900.2974 37.798394179030794 -122.425829789965 (37.7983941790308, -122.425829789965)
176903 129458 2 30 731 Sansome St 1 1 1 1     17 Width 3ft   6012131.08094 2118327.87745 37.7972074996935 -122.40206584156401 (37.7972074996935, -122.402065841564)
146952 129404 2 30 2844 Broderick St 2 1 1 1     6 Width 4ft   6000064.89028 2118400.48534 37.7967260116595 -122.44382296947799 (37.7967260116595, -122.443822969478)
46359 129457 2 30 822 Pacific Ave 1 1 1 1     4 Width 3ft   6010137.05679 2118184.23209 37.7967015887668 -122.408955554965 (37.7967015887668, -122.408955554965)
44629 129403 2 30 2844 Broderick St 1 1 1 1     11 Width 4ft   6000067.16914 2118384.00921 37.7966809025571 -122.443813899808 (37.7966809025571, -122.443813899808)
162829 51087 1 30 2031REVISED Larkin St 1 1 1 1   08/03/2004 12:00:00 AM 8   Permit Number 47544 6006859.53299 2118230.7659 37.7966452201661 -122.42029985774799 (37.7966452201661, -122.420299857748)
3230 1713 3 30 555 Battery St 1 1 1 2     6 5x6   6012507.60717 2118114.90232 37.796643729085005 -122.40074798855 (37.796643729085, -122.40074798855)
3485 1714 3 30 555 Battery St 2 1 1 2     6 5x9   6012511.35044 2118080.94057 37.796550687018204 -122.400732648813 (37.7965506870182, -122.400732648813)
59034 129459 2 30 458 Jackson St 1 1 1 1     13 Width 3ft   6011895.81451 2118092.21584 37.7965472956624 -122.402863344166 (37.7965472956624, -122.402863344166)
148459 129460 2 30 468 Jackson St 1 1 1 1     7 Width 3ft   6011856.71365 2118087.11906 37.7965311177706 -122.402998283841 (37.7965311177706, -122.402998283841)
148356 129461 2 30 468 Jackson St 2 1 1 1     7 Width 3ft   6011829.8803199995 2118083.5136599997 37.796519719768895 -122.403090879839 (37.7965197197689, -122.403090879839)
7931 1715 3 30 555 Battery St 3 1 1 2     6 5x6   6012518.40757 2118034.67495 37.796424046287996 -122.400704977573 (37.796424046288, -122.400704977573)
1485 115988 1 30 499 Jackson St 3 1 1 1   06/09/2016 12:00:00 AM 3 3x3 Permit Number 777967 6011781.45666 2118040.71778 37.7963995082912 -122.40325542520901 (37.7963995082912, -122.403255425209)
41714 115987 2 30 499 Jackson St 2 1 1 1     3 3x3   6011766.1004 2118039.4815599998 37.7963952562896 -122.40330847443 (37.7963952562896, -122.40330847443)
7798 1716 9 30 555 Battery St 4 1 1 2     18 5x15   6012528.51285 2117974.4106400004 37.796259138493205 -122.400665775228 (37.7962591384932, -122.400665775228)
69 19206 3 30 630 Sansome St 4 1 1 2     12 3X3   6012230.08543 2117977.14861 37.7962500076802 -122.40169859442699 (37.7962500076802, -122.401698594427)
7985 1718 3 30 555 Battery St 6 1 1 2     20 9x6   6012538.2564900005 2117884.3369 37.7960123609319 -122.400625729299 (37.7960123609319, -122.400625729299)
134345 32357 1 30 716 Montgomery St 1 1 1 1   10/03/1996 12:00:00 AM 3   Permit Number 36911 6011755.33078 2117880.08122 37.7959569797808 -122.40333452058998 (37.7959569797808, -122.40333452059)
178509 106106 1 30 708 Montgomery St 1 1 1 1     14     6011765.54028 2117816.6633 37.7957834196109 -122.403294730072 (37.7957834196109, -122.403294730072)
148228 129462 2 30 584 Washington St 1 1 1 1     11 Width 3ft   6011873.80865 2117764.68671 37.7956467505394 -122.402916441935 (37.7956467505394, -122.402916441935)
173778 71255 2 30 1392 Pacific Ave 1 1 1 1 1 08/19/1995 12:00:00 AM 1     6007494.44606 2117816.87319 37.795544530015604 -122.418073553678 (37.7955445300156, -122.418073553678)
136784 129423 2 30 2129 Vallejo St 7 1 1 1     12 Width 4ft   6003338.49011 2117887.74598 37.795504340202896 -122.432458934629 (37.7955043402029, -122.432458934629)
178008 129422 2 30 2129 Vallejo St 6 1 1 1     14 Width 4ft   6003322.87221 2117886.8736900003 37.7955010594859 -122.432512912861 (37.7955010594859, -122.432512912861)
24380 129424 2 30 2129 Vallejo St 8 1 1 1     18 Width 4ft   6003346.86179 2117886.37825 37.7955010594853 -122.43242986946699 (37.7955010594853, -122.432429869467)
38881 129421 2 30 2129 Vallejo St 5 1 1 1     11 Width 4ft   6003307.9218 2117884.58152 37.795493917972 -122.43256447998999 (37.795493917972, -122.43256447999)
148134 129420 2 30 2129 Vallejo St 4 1 1 1     9 Width 4ft   6003293.360640001 2117882.88889 37.795488444692296 -122.43261474308599 (37.7954884446923, -122.432614743086)
156068 129419 2 30 2129 Vallejo St 3 1 1 1     8 Width 4ft   6003276.06747 2117879.65532 37.795478585430104 -122.43267434925899 (37.7954785854301, -122.432674349259)
30187 97675 1 30 2562 Green St 1 1 1 1     10     6000810.80569 2117928.4487099997 37.7954724412642 -122.441208053918 (37.7954724412642, -122.441208053918)
71525 97676 1 30 2562 Green St 2 1 1 1     5     6000785.23545 2117926.05562 37.7954644138979 -122.441296359259 (37.7954644138979, -122.441296359259)
47633 129418 2 30 2129 Vallejo St 2 1 1 1     13 Width 4ft   6003255.2303 2117874.11084 37.795462179980895 -122.432746053085 (37.7954621799809, -122.432746053085)
52761 129417 2 30 2129 Vallejo St 1 1 1 1     15 Width 4ft   6003236.15275 2117871.33798 37.795453484440706 -122.432811866398 (37.7954534844407, -122.432811866398)
98803 104725 1 30 2747 Green St 2 1 1 1   11/06/2013 12:00:00 AM   3x3 Permit Number 770749 5999893.3 2117731.9 37.794880464642894 -122.44436863671899 (37.7948804646429, -122.444368636719)
118595 104724 1 30 2747 Green St 1 1 1 1       3x3 Permit Number 770749 5999893.3 2117731.9 37.794880464642894 -122.44436863671899 (37.7948804646429, -122.444368636719)
95348 97442 1 30 1900@Gough Pacific Ave 2 5 1 1           6004943.9 2117474.7 37.794461125583794 -122.42687450783701 (37.7944611255838, -122.426874507837)
65596 129426 2 30 2149 Broadway 2 10 1 1     3 Width 4ft   6003248.10705 2117506.03033 37.7944511216749 -122.432744393832 (37.7944511216749, -122.432744393832)
163894 129427 2 30 2149 Broadway 3 10 1 1     3 Width 4ft   6003257.40294 2117505.83832 37.794451121666604 -122.43271221522 (37.7944511216666, -122.43271221522)
45037 129425 2 30 2149 Broadway 1 10 1 1     3 Width 4ft   6003239.07369 2117504.42466 37.794446200597 -122.432775535577 (37.794446200597, -122.432775535577)
74170 129446 2 30 1329 Washington St 1 1 1 1     14 Width 3ft   6008344.2402 2117236.00141 37.7939973921104 -122.415091973713 (37.7939973921104, -122.415091973713)
150569 129445 2 30 24 Priest St 21 1 1 1     9 Width 3ft   6008315.59279 2117230.60537 37.793980966003 -122.415190714801 (37.793980966003, -122.415190714801)
27806 129444 2 30 1338 Clay St 3 1 1 1     9 Width 3ft   6008418.059880001 2116953.62618 37.793226207275794 -122.414816555443 (37.7932262072758, -122.414816555443)
167387 129428 2 30 2250 Washington St 1 1 1 1     3 Width 4ft   6003926.506990001 2116660.0257099997 37.7921666602192 -122.430336659605 (37.7921666602192, -122.430336659605)
63792 64471 1 30 2332 Washington St 1 1 1 1   07/06/1988 12:00:00 AM 4   Permit Number 25341 6003518.39121 2116605.0137 37.7919924858215 -122.431744816269 (37.7919924858215, -122.431744816269)
55487 129414 2 30 2501 Jackson St 8 1 1 1     4 Width 3ft   6001550.43955 2116611.49961 37.791898545338896 -122.438554394686 (37.7918985453389, -122.438554394686)
173107 54086 1 30 2405 Washington St 1 1 1 1   05/12/1972 12:00:00 AM 7   Permit Number 9810 6003110.67405 2116498.63256 37.791677270739896 -122.433147915142 (37.7916772707399, -122.433147915142)
43089 46211 1 30 2244 Webster St 1 1 1 1   08/15/2003 12:00:00 AM 3   Permit Number 46882 6003263.56021 2116449.57494 37.7915512424562 -122.43261542476299 (37.7915512424562, -122.432615424763)
75466 129435 2 30 2201 Clay St 7 1 1 1     4 Width 4ft   6004184.0136 2116319.13373 37.7912452400168 -122.429421362005 (37.7912452400168, -122.429421362005)
130371 129434 2 30 2201 Clay St 6 1 1 1     4 Width 4ft   6004173.55874 2116318.162 37.7912419799702 -122.429457466206 (37.7912419799702, -122.429457466206)
69337 129433 2 30 2201 Clay St 5 1 1 1     2 Width 4ft   6004155.37388 2116318.23991 37.791241164293496 -122.429520390877 (37.7912411642935, -122.429520390877)
159374 129432 2 30 2201 Clay St 4 1 1 1     2 Width 4ft   6004124.61142 2116315.60844 37.7912321971464 -122.429626640374 (37.7912321971464, -122.429626640374)
186133 129431 2 30 2201 Clay St 3 1 1 1     5 Width 4ft   6004108.39045 2116309.70837 37.7912150785667 -122.42968234348301 (37.7912150785667, -122.429682343483)
169241 129430 2 30 2201 Clay St 2 1 1 1     5 Width 4ft   6004093.9756 2116304.66162 37.791200405233496 -122.42973185833401 (37.7912004052335, -122.429731858334)
114102 129429 2 30 2201 Clay St 1 1 1 1     5 Width 4ft   6004071.91056 2116304.52286 37.7911987747643 -122.429808192813 (37.7911987747643, -122.429808192813)
61686 105315 1 30 2101 Laguna St   1 1 1         Permit Number 770797 6004250.84301 2116191.67517 37.7908990545176 -122.429181041856 (37.7908990545176, -122.429181041856)
82615 105316 1 30 2101 Laguna St 2 1 1 1         Permit Number 770797 6004250.84301 2116191.67517 37.7908990545176 -122.429181041856 (37.7908990545176, -122.429181041856)
95709 98492 6 30 2149 Laguna St 1 7 1 1           6004211.7 2116183.0 37.7908730187591 -122.429315856087 (37.7908730187591, -122.429315856087)
147603 129408 2 30 2199 Webster St 2 1 1 1     7 Width 3ft   6003263.17406 2116138.42129 37.7906968721156 -122.432594525436 (37.7906968721156, -122.432594525436)
55145 129409 2 30 2199 Webster St 3 1 1 1     11 Width 3ft   6003265.25593 2116107.39334 37.7906117953446 -122.43258510502399 (37.7906117953446, -122.432585105024)
183006 129410 2 30 2199 Webster St 4 1 1 1     12 Width 3ft   6003271.2174 2116075.89812 37.7905256555748 -122.43256222807301 (37.7905256555748, -122.432562228073)
8677 18861 1 30 2200 Sacramento St 1 1 1 1     5 3X3   6004226.06461 2116051.48796 37.790512733214 -122.42925677349 (37.790512733214, -122.42925677349)
6585 44092 1 30 2200 Sacramento St 2 1 1 1   11/01/2000 12:00:00 AM 8 3x3 Permit Number 43607 6004180.10381 2116042.60341 37.790485736467296 -122.429415161181 (37.7904857364673, -122.429415161181)
5858 18862 1 30 2200 Sacramento St 3 1 1 1     5 3X3PL   6004143.20725 2116038.00121 37.790471010977505 -122.42954249260201 (37.7904710109775, -122.429542492602)
164372 111668 1 30 2200 Sacramento St 4 1 1 1     7 3X3PL   6004109.02078 2116034.23701 37.790458739741 -122.429660507029 (37.790458739741, -122.429660507029)
40498 129411 2 30 2111 Webster St 2 1 1 1     6 Width 3ft   6003275.408009999 2116033.9816799997 37.790410801365105 -122.43254473354901 (37.7904108013651, -122.432544733549)
54469 57397 1 30 1190 Pine St 1 1 1 1   09/02/1976 12:00:00 AM 11   Permit Number 16237 6008290.06558 2115917.44184 37.7903739066804 -122.41518604372601 (37.7903739066804, -122.415186043726)
64750 129447 2 30 1190 Pine St 2 1 1 1     8 Width 3ft   6008246.65377 2115911.69756 37.7903556945065 -122.41533583927799 (37.7903556945065, -122.415335839278)
42869 129448 2 30 1190 Pine St 3 1 1 1     10 Width 3ft   6008230.449580001 2115909.44994 37.79034861235171 -122.415391745646 (37.7903486123517, -122.415391745646)
157755 129412 2 30 2111 Webster St 4 1 1 1     6 Width 3ft   6003281.29754 2115999.00202 37.790315090121005 -122.432521856625 (37.790315090121, -122.432521856625)
Powered by Datasette · Query took 10.104ms · Data source: data.sfgov.org