sf-trees

Data source: data.sfgov.org

Custom SQL query returning 36 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
21627 10139 3 52 905 Guerrero St 1 1 1 2   12/22/2014 12:00:00 AM 1 2X2   6005721.36321 2103691.7160799997 37.7566603214356 -122.42320418503999 (37.7566603214356, -122.42320418504)
29331 219232 2 52 393 Ashton Ave 1 1 1 1     1 Width 3ft   5994163.921 2092422.7016599998 37.72505940734629 -122.46235640053101 (37.7250594073463, -122.462356400531)
35605 49762 1 52 123@ GIRARD Ordway St 1 1 1 1 1 06/04/2003 12:00:00 AM 1   Permit Number 46556 6011554.1535 2090217.48516 37.7199903867389 -122.402084923384 (37.7199903867389, -122.402084923384)
40415 226761 2 52 69 28th St 1 1 1 1     1 Width 3ft   6005532.060269999 2099607.16908 37.745434412567896 -122.423568476998 (37.7454344125679, -122.423568476998)
40786 229741 2 52 714 Dolores St 3 1 1 1     1 Width 4ft   6004954.861330001 2104148.63623 37.757871629989296 -122.42588755157101 (37.7578716299893, -122.425887551571)
45434 176587 2 52 125 Ordway St 1 1 1 1     1 Width 3ft   6011540.71743 2090213.76704 37.719979427594104 -122.402131106273 (37.7199794275941, -122.402131106273)
47184 229792 2 52 1347 Minna St 1 1 1 1     1 Width 3ft   6006987.3466 2107613.99379 37.7675013456445 -122.419104149736 (37.7675013456445, -122.419104149736)
52880 176585 2 52 205 Seneca Ave 3 9 1 1     1 Width 6ft   5999821.59853 2090369.86807 37.719746961831 -122.442651149242 (37.719746961831, -122.442651149242)
61921 228526 2 52 405 Florida St 2 4 1 1     1 Width 3ft   6009242.70378 2106296.2843400002 37.7640099687976 -122.41121004561701 (37.7640099687976, -122.411210045617)
71654 229780 2 52 1201 Vermont St 50 9 1 1     1 Width 4ft   6011438.150669999 2102669.0861400003 37.7541733704045 -122.40336141212099 (37.7541733704045, -122.403361412121)
71727 176584 2 52 263 Naglee Ave 1 1 1 1     1 Width 1ft   5997986.0041 2088216.93337 37.7137306897928 -122.44884112532301 (37.7137306897928, -122.448841125323)
72817 190701 2 52 199 Texas St 3 1 1 1     1 Width 3ft   6013753.34046 2106269.9769900003 37.7641896695377 -122.39560712917101 (37.7641896695377, -122.395607129171)
97228 34748 1 52 2752 Harrison St 1 1 1 1 1 07/28/1997 12:00:00 AM 1 5x12 Permit Number 38396 6008918.26554882 2102430.84513518 37.7533781509064 -122.412058993069 (37.7533781509064, -122.412058993069)
131666 190744 2 52 2086 Quesada Ave 1 7 1 1     1     6012709.58294 2096557.7365 37.737463838180496 -122.398535643704 (37.7374638381805, -122.398535643704)
133111 226319 2 52 1363 Alabama St 1 1 1 1     1 Width 4ft   6009300.5119199995 2101248.8429900003 37.7501540762619 -122.41065363417101 (37.7501540762619, -122.410653634171)
135367 226326 2 52 739 Shotwell St 1 1 1 1     1 Width 3ft   6007955.30705 2103442.0816599997 37.7561007003072 -122.415460702047 (37.7561007003072, -122.415460702047)
148346 245473 2 52 2889 24th St 1 1 1 1     1 Width 0ft   6009585.3359 2102170.0295 37.752699414397604 -122.409733705951 (37.7526994143976, -122.409733705951)
151613 226366 2 52 1220 Diamond St 1 1 1 1     1 Width 3ft   6001939.37968 2100462.1573799998 37.7475785645179 -122.436052541893 (37.7475785645179, -122.436052541893)
152981 226310 2 52 110 Montcalm St 1 1 1 1     1 Width 2ft   6010345.87417 2099884.35237 37.7464660383936 -122.406942531387 (37.7464660383936, -122.406942531387)
153899 190705 2 52 2207 25th St 1 1 1 1     1 Width 3ft   6012167.672590001 2101868.22715 37.7520151045386 -122.40078226978301 (37.7520151045386, -122.400782269783)
153976 226362 2 52 7 Elizabeth St 1 1 1 1     1 Width 3ft   6005992.12876 2102270.13031 37.7527722527625 -122.42216678559299 (37.7527722527625, -122.422166785593)
155165 219233 2 52 387 Ashton Ave 1 1 1 1     1 Width 3ft   5994164.56547 2092392.43636 37.724976343277795 -122.462351978558 (37.7249763432778, -122.462351978558)
158392 226775 2 52 4065 25th St 1 1 1 1     1 Width 3ft   6003443.878880001 2101243.2515 37.7498086241662 -122.43090581267599 (37.7498086241662, -122.430905812676)
160383 226365 2 52 1214 Diamond St 1 1 1 1     1 Width 3ft   6001939.894830001 2100487.05511 37.7476469570616 -122.436052541887 (37.7476469570616, -122.436052541887)
168226 226409 2 52 340 Bennington St 2 1 1 1     1 Width 3ft   6007041.57099 2096614.1671900002 37.7373013855609 -122.41813666630101 (37.7373013855609, -122.418136666301)
169916 106484 1 52 758 Arkansas St 1 1 1 1   01/04/2016 12:00:00 AM 1 3x3 Permit Number 771079 6013015.32424 2103511.36307 37.756574042268895 -122.39796620198601 (37.7565740422689, -122.397966201986)
171644 226410 2 52 340 Bennington St 1 1 1 1     1 Width 3ft   6007045.3382 2096649.7231400001 37.7373992263821 -122.41812616129499 (37.7373992263821, -122.418126161295)
174234 228525 2 52 405 Florida St 1 4 1 1     1 Width 3ft   6009242.66431 2106282.23281 37.763971384304206 -122.411209189472 (37.7639713843042, -122.411209189472)
174782 229840 2 52 3732 20th St 1 1 1 1     1 Width 3ft   6005421.91572 2104323.47522 37.7583780804987 -122.42428471508002 (37.7583780804987, -122.42428471508)
175495 229865 2 52 539 Hickory St 1 1 1 1     1 Width 3ft   6004844.26448 2110392.80621 37.7750103735616 -122.426714698547 (37.7750103735616, -122.426714698547)
179213 228527 2 52 405 Florida St 3 4 1 1     1 Width 3ft   6009241.97976 2106321.44557 37.7640790151609 -122.4112143273 (37.7640790151609, -122.4112143273)
180912 123149 2 52 530 10th Ave 3 1 1 1     1 Width 3ft   5992851.14917 2111838.68412 37.77829500806129 -122.468306331193 (37.7782950080613, -122.468306331193)
181213 101797 2 52 600X Carolina St 1 1 1 1     1 6x6   6012355.97365 2105123.66121 37.7609643139807 -122.400359728744 (37.7609643139807, -122.400359728744)
182379 80400 1 52 847 Baker St 1 1 1 1   06/19/2008 12:00:00 AM 1 3x3 Permit Number 51000 6000427.8652 2111924.6617 37.778965778909296 -122.442101918526 (37.7789657789093, -122.442101918526)
188041 226307 2 52 303 Bennington St 1 1 1 1     1 Width 2ft   6007092.99842 2096727.1490900002 37.7376145033994 -122.417966864376 (37.7376145033994, -122.417966864376)
188188 229822 2 52 956 York St 1 1 1 1     1 Width 6ft   6009932.67033 2103635.88774 37.7567437920002 -122.40863595569701 (37.7567437920002, -122.408635955697)
Powered by Datasette · Query took 6.667ms · Data source: data.sfgov.org