sf-trees

Data source: data.sfgov.org

Custom SQL query returning 51 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
22043 859 3 42 400X Alemany Blvd 5 1 1 2     16 3x3   6008091.178180001 2095049.40427 37.7330639095777 -122.41439699202299 (37.7330639095777, -122.414396992023)
18171 1377 3 42 65 Amethyst Way 1 1 1 2   04/10/1998 12:00:00 AM 3 1X1   5998937.99517 2100006.33795 37.746156024995706 -122.44639832203 (37.7461560249957, -122.44639832203)
140403 1378 3 42 65 Amethyst Way 2 1 1 2   04/10/1998 12:00:00 AM 7 1X1   5998886.878159099 2099985.9166978 37.746097033504896 -122.44657360851801 (37.7460970335049, -122.446573608518)
21207 10209 3 42 1301 Guerrero St 1 1 1 2   11/17/1994 12:00:00 AM 12 3X3PL   6005849.39823 2101351.62015 37.7502421837319 -122.4225951102 (37.7502421837319, -122.4225951102)
8970 10634 3 42 830 Hayes St 3 1 1 2   08/02/1990 12:00:00 AM 12 3X3   6003840.507 2110782.2115 37.7760227838468 -122.43021469913201 (37.7760227838468, -122.430214699132)
2164 10688 3 42 1221 Hayes St 1 1 1 2   11/18/1991 12:00:00 AM 6 3X3   6002001.6656 2110480.73 37.7750906677438 -122.43655414222 (37.7750906677438, -122.43655414222)
12141 17224 3 42 1880X Alemany Blvd 1 1 1 2     15 3X3   6001029.5778 2091188.70927 37.72206410195621 -122.43853424087601 (37.7220641019562, -122.438534240876)
12807 17229 3 42 1880X Alemany Blvd 6 1 1 2     14 3X3   6000980.939130001 2091103.3398799999 37.7218269300432 -122.438696258244 (37.7218269300432, -122.438696258244)
100029 19281 3 42 1770 Scott St 1 1 1 2     10 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
86900 19282 3 42 1770 Scott St 2 1 1 2     11 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
99251 19283 3 42 1770 Scott St 3 1 1 2     8 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
121915 19284 3 42 1770 Scott St 4 1 1 2   06/01/1998 12:00:00 AM 9 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
65727 19285 3 42 1770 Scott St 5 1 1 2   06/01/1998 12:00:00 AM 11 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
8932 19577 3 42 100 STAIRWAY3 2 1 1 2     3 15ST            
7439 19729 3 42 100 STAIRWAY14 7 1 1 2     6 40ST            
10291 19793 3 42 100 STAIRWAY19 15 1 1 2     6 20ST            
3716 20054 3 42 100 STAIRWAY54 1 1 1 2     6 15ST            
15903 20055 3 42 100 STAIRWAY54 2 1 1 2     6 15ST            
6851 20056 3 42 100 STAIRWAY54 3 1 1 2     6 15ST            
11185 20057 3 42 100 STAIRWAY54 4 1 1 2     6 15ST            
16839 20059 3 42 100 STAIRWAY54 6 1 1 2     12 15ST            
7770 20060 3 42 100 STAIRWAY54 7 1 1 2     12 15ST            
15210 20061 3 42 100 STAIRWAY54 8 1 1 2     12 15ST            
15394 20062 3 42 100 STAIRWAY54 9 1 1 2     6 15ST            
1434 20063 3 42 100 STAIRWAY54 10 1 1 2     6 15ST            
16172 20064 3 42 100 STAIRWAY54 11 1 1 2     6 15ST            
111638 23659 3 42 305 Virginia Ave 1 11 1 2     12 12   6006899.0385805 2098362.9679323 37.742095179874795 -122.418753453583 (37.7420951798748, -122.418753453583)
128008 23660 3 42 305 Virginia Ave 2 11 1 2     12 12   6006899.0385805 2098362.9679323 37.742095179874795 -122.418753453583 (37.7420951798748, -122.418753453583)
77429 23663 3 42 311 Virginia Ave 2 11 1 2     12 12   6006938.1768512 2098312.3803834 37.7419584813283 -122.41861453896999 (37.7419584813283, -122.41861453897)
142538 23664 3 42 311 Virginia Ave 3 11 1 2     12 12   6006938.1768512 2098312.3803834 37.7419584813283 -122.41861453896999 (37.7419584813283, -122.41861453897)
112941 23666 3 42 313 Virginia Ave 1 11 1 2     12 12   6006939.3181056 2098298.0428385 37.7419191778851 -122.41860957638501 (37.7419191778851, -122.418609576385)
91582 23671 3 42 317 Virginia Ave 2 11 1 2     6 12   6006937.941544901 2098264.8464559 37.7418279505329 -122.41861198258002 (37.7418279505329, -122.41861198258)
104707 23675 3 42 319 Virginia Ave 4 11 1 2     6 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
107814 23676 3 42 319 Virginia Ave 5 11 1 2     6 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
104998 23677 3 42 319 Virginia Ave 6 11 1 2     6 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
103201 23678 3 42 319 Virginia Ave 7 11 1 2     6 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
108432 24819 3 42 400X Alemany Blvd 11 1 1 2   04/09/2001 12:00:00 AM 18 3x3   6007950.68171 2094974.0594400002 37.7328491354706 -122.41487739629801 (37.7328491354706, -122.414877396298)
110460 25177 3 42 3076 Market St 1 1 1 2   04/19/1996 12:00:00 AM 30 3X3   6000054.6842234 2105404.3700399 37.7610414235505 -122.442924538729 (37.7610414235505, -122.442924538729)
19917 28134 3 42 400X Eugenia Ave 2 1 1 2   08/17/2016 12:00:00 AM 3 6x9   6006749.04287 2098002.24216 37.741096261078404 -122.41924650972 (37.7410962610784, -122.41924650972)
82962 29220 3 42 1902X 41st Ave 3 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
92157 29223 3 42 1902X 41st Ave 6 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
110361 29224 3 42 1902X 41st Ave 7 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
93774 98707 2 42 105X Ord St 1 1 1 2       3x3   6000883.6 2105740.8 37.7620124016568 -122.440081810476 (37.7620124016568, -122.440081810476)
124870 98708 2 42 105X Ord St 2 1 1 2           6000883.6 2105740.8 37.7620124016568 -122.440081810476 (37.7620124016568, -122.440081810476)
118711 116614 2 42 299X SHOTWELL ST 1 1 1 2     10 3x3   6007772.0 2106483.0 37.7644400562771 -122.41631001514901 (37.7644400562771, -122.416310015149)
112048 116664 3 42 199x Esmeralda Ave 18 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
24270 188526 3 42 1427x Innes Ave 12 3 1 2     13     6016254.90623 2096663.3838099998 37.7379507994938 -122.386285047323 (37.7379507994938, -122.386285047323)
169840 188527 3 42 1427x Innes Ave 30 3 1 2     15     6016131.12478 2096760.51066 37.7382106379019 -122.386719795784 (37.7382106379019, -122.386719795784)
154734 203652 3 42 400x Marietta Dr 38 11 1 2     6 Width 3ft   5999131.48243 2096996.51385 37.737902818863795 -122.445512879233 (37.7379028188638, -122.445512879233)
117 220007 3 42 929 Valencia St 1 1 1 2   09/12/2015 03:22:00 PM 1 Width 3ft Permit Number 24134 6006336.25046 2104153.4311599997 37.7579627654961 -122.421110461684 (37.7579627654961, -122.421110461684)
167015 220038 3 42 500x 27th St 11 11 1 2     1 Width 4ft   6002807.79997 2100063.2344299997 37.7465325135634 -122.433021102638 (37.7465325135634, -122.433021102638)
Powered by Datasette · Query took 9.092ms · Data source: data.sfgov.org