sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
77542 14768 1 144 1000X McAllister St 3 1 1 21   11/25/1992 12:00:00 AM 3 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
77557 9556 1 128 1195X Golden Gate Ave 9 1 1 21   01/19/2016 07:58:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
77576 9548 1 26 1195X Golden Gate Ave 1 1 1 21   10/12/1994 12:00:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
78822 14769 1 11 1000X McAllister St 4 1 1 21   07/11/1995 12:00:00 AM 6 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
80298 9558 1 150 1195X Golden Gate Ave 11 1 1 21   12/15/2005 12:00:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
83117 14776 1 25 1000X McAllister St 11 1 1 21   06/30/1994 12:00:00 AM 12 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
86826 29064 1 6 1000X McAllister St 1 1 1 21   03/02/2006 12:00:00 AM 3 3x3   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
99583 9555 1 82 1195X Golden Gate Ave 8 1 1 21     6 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
104137 9554 1 26 1195X Golden Gate Ave 7 1 1 21   05/14/1992 12:00:00 AM 12 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
108008 14770 1 82 1000X McAllister St 5 1 1 21   02/06/2016 08:42:00 AM 3 4x4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
110180 14775 1 25 1000X McAllister St 10 1 1 21     12 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
111085 9551 1 26 1195X Golden Gate Ave 4 1 1 21   05/14/1992 12:00:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
112538 14773 1 82 1000X McAllister St 8 1 1 21   05/13/1992 12:00:00 AM 6 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
122469 14777 1 25 1000X McAllister St 12 1 1 21     12 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
123500 14771 1 25 1000X McAllister St 6 1 1 21     18 4x4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
123863 9557 1 128 1195X Golden Gate Ave 10 1 1 21   01/19/2016 07:54:00 AM 3 3x3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
124348 14774 1 11 1000X McAllister St 9 1 1 21   05/13/1992 12:00:00 AM 6 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
126868 14772 1 25 1000X McAllister St 7 1 1 21   06/30/1994 12:00:00 AM 18 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
140317 9553 1 82 1195X Golden Gate Ave 6 1 1 21     6 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
141722 9550 1 82 1195X Golden Gate Ave 3 1 1 21     6 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
143620 9559 1 26 1195X Golden Gate Ave 12 1 1 21     3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
145179 29063 1 6 1000X McAllister St 2 1 1 21   12/15/2005 12:00:00 AM 3 3x3   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
145804 9549 1 26 1195X Golden Gate Ave 2 1 1 21   05/14/1992 12:00:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.43006254712499 (37.7797350134544, -122.430062547125)
6478 98738 2 5 1150 Scott St 2 1 1 20 2   3 4X4   6001885.6171 2112431.4484 37.780440254610205 -122.43709527307301 (37.7804402546102, -122.437095273073)
81359 112751 2 43 135X TRENTON ST 5 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
86815 112748 2 21 135X TRENTON ST 2 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
87276 112509 2 11 699x WILLOW ST 1 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
94993 112510 2 11 699x WILLOW ST 2 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
101441 112750 2 43 135X TRENTON ST 4 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
102473 95360 3 5 775X Broadway 3 1 1 20 2   12 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
111421 95362 3 5 775X Broadway 2 1 1 20 2     3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
112944 95359 3 5 775X Broadway 5 1 1 20 2   12 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
114297 95361 3 5 775X Broadway 4 1 1 20 2   10 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
114699 98740 2 5 1150 Scott St 4 1 1 20 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
118079 95358 3 5 775X Broadway 1 1 1 20 2   25 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
118120 114914 2 40 200x MIDDLE POINT RD 1 1 1 20 3     3x3   6017974.0 2095171.0 37.7339480130439 -122.380237547959 (37.7339480130439, -122.380237547959)
120473 112511 2 11 699x WILLOW ST 3 1 1 20 4 08/08/2015 03:37:00 PM 3 2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
126442 95363 3 5 775X Broadway 6 1 1 20 2   20 3x3   6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
126702 98737 2 5 1150 Scott St 1 1 1 20 2   24 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
128761 98739 2 5 1150 Scott St 3 1 1 20 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
138572 112749 2 21 135X TRENTON ST 3 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
144482 98742 2 51 1150 Scott St 6 1 1 20 2 03/21/2012 12:00:00 AM 3 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
145720 98741 2 51 1150 Scott St 5 1 1 20 2 03/21/2012 12:00:00 AM 3 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
181574 102134 1 37 400 Beale St 3 1 1 20 3 11/24/2015 12:00:00 AM 1 3x3 Permit Number 769373 6015285.47231 2114577.79035 37.787086180420296 -122.390888542866 (37.7870861804203, -122.390888542866)
4504 8092 1 35 762 Fulton St 3 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004291.3267 2111546.8391 37.778147787093 -122.428709714706 (37.778147787093, -122.428709714706)
5269 8090 1 35 762 Fulton St 1 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004349.2473 2111557.1689 37.7781794280627 -122.428510082803 (37.7781794280627, -122.428510082803)
5536 8091 1 35 762 Fulton St 2 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004317.1512 2111553.1108 37.7781664691559 -122.42862082556499 (37.7781664691559, -122.428620825565)
5687 8096 1 82 762 Fulton St 7 1 1 19   04/14/1998 12:00:00 AM 18 3X3   6004110.3708 2111520.4613 37.7780651171853 -122.429333825297 (37.7780651171853, -122.429333825297)
7365 8095 1 82 762 Fulton St 6 1 1 19   04/14/1998 12:00:00 AM 24 3X3   6004129.5547 2111522.3059 37.778071268059996 -122.42926759287201 (37.77807126806, -122.429267592872)
7737 8094 1 10 762 Fulton St 5 1 1 19     100 3X3   6004211.6397 2111535.7715 37.7781128879326 -122.428984591665 (37.7781128879326, -122.428984591665)
14790 26012 1 114 1618X Oakdale Ave 2 1 1 19   01/02/1998 12:00:00 AM 3 3X3   6015044.018999999 2095518.8416 37.7347410214535 -122.390391768412 (37.7347410214535, -122.390391768412)
16622 105164 2 2 1600X Oakdale Ave 3 1 1 19     15 5x5   6014842.39521 2095664.6842099999 37.735130289038 -122.39109904720101 (37.735130289038, -122.391099047201)
16814 105175 2 42 1601X Newcomb Ave 4 1 1 19     10 3x3   6015153.3918 2095715.6028 37.735287354242395 -122.390027366589 (37.7352873542424, -122.390027366589)
79382 22281 1 43 4755X 03rd St 5 1 1 19     18 3X3   6015037.5047362 2095657.5026115002 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921)
86507 105174 2 55 1601X NEWCOMB AVE 3 1 1 19     40 3x3 Permit Number 770204 6015135.0 2095759.0 37.735405494081505 -122.390093985074 (37.7354054940815, -122.390093985074)
91673 26011 1 49 1618X Oakdale Ave 1 1 1 19   01/02/1998 12:00:00 AM 6 3X3   6014975.06835 2095558.9055400002 37.7348472038217 -122.390632955135 (37.7348472038217, -122.390632955135)
93459 22283 1 9 4755X 03rd St 7 1 1 19     6 3X3 Permit Number 770204 6015037.5047362 2095657.5026115002 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921)
93465 22280 1 131 4755X 03rd St 4 1 1 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115002 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921)
93945 22277 1 131 4755X 03rd St 1 1 1 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115002 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921)
96893 105172 2 42 1601X NEWCOMB AVE 1 1 1 19     12 3x3 Permit Number 770204 6015135.0 2095759.0 37.735405494081505 -122.390093985074 (37.7354054940815, -122.390093985074)
101377 105163 2 114 1600X OAKDALE AVE 2 1 1 19     17 4x4 Permit Number 770204 6015006.0 2095503.0 37.734695414582795 -122.390522107646 (37.7346954145828, -122.390522107646)
109805 22284 1 9 4755X 03rd St 8 1 1 19     6 3x3 Permit Number 770204 6015037.5047362 2095657.5026115002 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921)
118554 22282 1 131 4755X 03rd St 6 1 1 19     4 3X3   6015037.5047362 2095657.5026115002 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921)
118765 105165 2 32 1600X OAKDALE AVE 4 1 1 19     16 3x3   6015006.0 2095503.0 37.734695414582795 -122.390522107646 (37.7346954145828, -122.390522107646)
122595 22278 1 131 4755X 03rd St 2 1 1 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115002 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921)
129364 8097 1 18 762 Fulton St 8 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004143.8911021 2111521.3201229 37.7780693729621 -122.42921792780001 (37.7780693729621, -122.4292179278)
143331 22279 1 131 4755X 03rd St 3 1 1 19     6 3X3   6015037.5047362 2095657.5026115002 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921)
3328 140422 1 59 1499 TURK ST 1 1 1 18     14 Width 0ft   6002931.6326 2112346.6107 37.7802667133087 -122.43347055342699 (37.7802667133087, -122.433470553427)
3331 140432 1 22 1499 Turk St 11 1 1 18     13 Width 0ft   6003204.3695 2112383.9326 37.7803846599605 -122.432529697936 (37.7803846599605, -122.432529697936)
3334 140424 1 59 1499 TURK ST 3 1 1 18     13 Width 0ft   6002981.8736 2112352.3525 37.7802853291655 -122.43329715719 (37.7802853291655, -122.43329715719)
3335 140428 1 59 1499 TURK ST 7 1 1 18     14 Width 0ft   6003076.6138 2112365.9894 37.7803281468599 -122.43297038187401 (37.7803281468599, -122.432970381874)
3337 140433 1 59 1499 Turk St 12 1 1 18     15 Width 0ft   6003251.7396 2112391.1099 37.7804070531695 -122.432366335522 (37.7804070531695, -122.432366335522)
3339 140429 1 59 1499 TURK ST 8 1 1 18     15 Width 0ft   6003096.7102 2112369.578 37.7803391401181 -122.432901115602 (37.7803391401181, -122.432901115602)
3342 140426 1 59 1499 TURK ST 5 1 1 18     12 Width 0ft   6003027.0905 2112359.5298 37.7803076012967 -122.43314124413601 (37.7803076012967, -122.433141244136)
3343 140423 1 59 1499 TURK ST 2 1 1 18     13 Width 0ft   6002956.7531 2112350.9171 37.7802799627924 -122.43338395792802 (37.7802799627924, -122.433383957928)
3344 140425 1 59 1499 TURK ST 4 1 1 18     12 Width 0ft   6003006.2764 2112357.3766 37.780300508432795 -122.43321309578998 (37.7803005084328, -122.43321309579)
3347 140434 1 59 1499 Turk St 13 1 1 18     14 Width 0ft   6003279.731000001 2112394.6985 37.780418493723204 -122.43226975660299 (37.7804184937232, -122.432269756603)
3348 140430 1 22 1499 TURK ST 9 1 1 18   05/18/1992 12:00:00 AM 5 Width 0ft   6003115.3712 2112373.8844 37.7803520228236 -122.432836866316 (37.7803520228236, -122.432836866316)
3349 140427 1 59 1499 TURK ST 6 1 1 18     14 Width 0ft   6003052.211 2112362.4007 37.7803169090148 -122.43305454594 (37.7803169090148, -122.43305454594)
3351 140431 1 59 1499 Turk St 1 1 1 18     14 Width 0ft   6003184.2731 2112381.0617 37.7803756375453 -122.432599015585 (37.7803756375453, -122.432599015585)
17096 22978 1 11 630 Valencia St 2 1 1 18   03/14/1995 12:00:00 AM 18 3X3   6006171.13469 2105920.83028 37.762806320675104 -122.421807041478 (37.7628063206751, -122.421807041478)
19046 22977 1 11 630 Valencia St 1 1 1 18   03/14/1995 12:00:00 AM 20 3X3   6006170.03999 2105955.48094 37.7629014015073 -122.421813289079 (37.7629014015073, -122.421813289079)
77683 22980 1 11 630 Valencia St 4 1 1 18   09/30/2006 12:00:00 AM 6 3X3   6006179.6291421 2105955.3041542 37.762901456856206 -122.42178011092 (37.7629014568562, -122.42178011092)
78686 22716 1 43 1401X Turk St 8 1 1 18     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894)
79478 22719 1 43 1401X Turk St 5 1 1 18     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894)
80929 115946 1 11 3403x 17TH ST 5 1 1 18       3x3   6006158.0 2105944.0 37.7628691985612 -122.42185411572201 (37.7628691985612, -122.421854115722)
83157 22713 1 22 1401X Turk St 11 1 1 18     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894)
83367 115940 6 41 3401x 17TH ST 1 1 1 18     20 3x3   6006069.0 2106010.0 37.7630453994978 -122.42216662533801 (37.7630453994978, -122.422166625338)
86610 20161 1 43 1150X Steiner St 4 1 1 18     18 4X4   6002889.1141449995 2112192.1807580004 37.779840274990796 -122.433606604391 (37.7798402749908, -122.433606604391)
87132 20160 1 43 1150X Steiner St 3 1 1 18     18 4X4   6002889.1141449995 2112192.1807580004 37.779840274990796 -122.433606604391 (37.7798402749908, -122.433606604391)
87612 22982 1 11 630 Valencia St 6 1 1 18   11/30/1994 12:00:00 AM 20 3X3   6006179.6291421 2105955.3041542 37.762901456856206 -122.42178011092 (37.7629014568562, -122.42178011092)
87696 22711 1 43 1401X Turk St 13 1 1 18     12 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894)
88203 115945 1 11 3403x 17TH ST 4 1 1 18       3x3   6006158.0 2105944.0 37.7628691985612 -122.42185411572201 (37.7628691985612, -122.421854115722)
88384 22722 1 43 1401X Turk St 2 1 1 18     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894)
91993 20162 1 43 1150X Steiner St 5 1 1 18     18 4X4   6002889.1141449995 2112192.1807580004 37.779840274990796 -122.433606604391 (37.7798402749908, -122.433606604391)
95968 22983 1 11 630 Valencia St 7 1 1 18   01/25/1995 12:00:00 AM 18 3X3   6006179.6291421 2105955.3041542 37.762901456856206 -122.42178011092 (37.7629014568562, -122.42178011092)
97147 22721 1 43 1401X Turk St 3 1 1 18     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894)
103172 22985 1 11 630 Valencia St 9 1 1 18   11/29/1994 12:00:00 AM 20 3X3   6006179.6291421 2105955.3041542 37.762901456856206 -122.42178011092 (37.7629014568562, -122.42178011092)
103307 115942 6 41 3401x 17TH ST 3 1 1 18       3x3   6006069.0 2106010.0 37.7630453994978 -122.42216662533801 (37.7630453994978, -122.422166625338)
103423 22714 1 43 1401X Turk St 10 1 1 18     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894)
106335 115943 1 11 3403x 17TH ST 2 1 1 18       3x3   6006158.0 2105944.0 37.7628691985612 -122.42185411572201 (37.7628691985612, -122.421854115722)
Powered by Datasette · Query took 125.176ms · Data source: data.sfgov.org