sf-trees

Data source: data.sfgov.org

Custom SQL query returning 40 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
586 237035 3 98 150 Octavia St 2 4 1 2   04/12/2017 02:27:00 PM 3 Width 4ft   6005709.86547 2109855.10938 37.7735828886787 -122.423682154918 (37.7735828886787, -122.423682154918)
622 237036 3 98 150 Octavia St 4 4 1 2   04/13/2017 02:42:00 PM 3 Width 4ft   6005705.053180001 2109878.39065 37.7736465417793 -122.423700457022 (37.7736465417793, -122.423700457022)
643 239154 3 98 150 Octavia St 6 4 1 2   04/13/2017 02:47:00 PM 3 Width 4ft   6005701.84613 2109911.12293 37.773736235682 -122.42371387848999 (37.773736235682, -122.42371387849)
659 244390 2 98 250 Octavia St 2 1 1 1   04/15/2017 01:00:00 PM 3 Width 0ft   6005651.6782 2110185.3753 37.774486434317105 -122.423906923072 (37.7744864343171, -122.423906923072)
660 244391 2 98 250 Octavia St 3 1 1 1   04/15/2017 01:16:00 PM 3 Width 0ft   6005650.1507 2110201.4148 37.774530388668 -122.42391334778499 (37.774530388668, -122.423913347785)
664 244393 2 98 250 Octavia St 5 1 1 1   04/15/2017 01:35:00 PM 3 Width 0ft   6005645.568 2110235.0213 37.774622405266 -122.423931590501 (37.774622405266, -122.423931590501)
668 244392 2 98 250 Octavia St 4 1 1 1   04/15/2017 01:27:00 PM 3 Width 0ft   6005647.8593 2110218.2181 37.774576397101995 -122.42392246931401 (37.774576397102, -122.423922469314)
825 244349 2 98 300 Octavia St 4 1 1 2   04/19/2017 02:48:00 PM 3 Width 0ft   6005619.6911 2110403.6421 37.77508393621179 -122.424033097665 (37.7750839362118, -122.424033097665)
831 244348 3 98 300 Octavia St 3 1 1 2   04/19/2017 02:44:00 PM 3 Width 0ft   6005622.9962 2110384.2841 37.7750309704349 -122.424020287681 (37.7750309704349, -122.424020287681)
852 244300 3 98 350 Octavia St 3 1 1 2   04/20/2017 11:46:00 AM 3 Width 0ft   6005602.4578 2110538.44 37.775453085580295 -122.424102299872 (37.7754530855803, -122.424102299872)
856 244351 3 98 300 Octavia St 6 1 1 2   04/20/2017 07:17:00 AM 3 Width 0ft   6005616.3861 2110436.6924 37.7751744977295 -122.42404688124701 (37.7751744977295, -122.424046881247)
863 244299 3 98 350 Octavia St 2 1 1 2   04/20/2017 11:32:00 AM 3 Width 0ft   6005603.4021 2110525.6921 37.7754181362545 -122.424098126533 (37.7754181362545, -122.424098126533)
866 244301 3 98 350 Octavia St 4 1 1 2   04/20/2017 11:53:00 AM 3 Width 0ft   6005600.097 2110553.5487 37.775494437113295 -122.42411154116199 (37.7754944371133, -122.424111541162)
1092 139390 2 98 432 OCTAVIA ST 5 1 1 1   05/02/2017 03:33:00 PM 3 Width 0ft   6005538.2982 2110931.9956 37.776530070945796 -122.424352241322 (37.7765300709458, -122.424352241322)
1585 23896 3 98 1581 Webster St 3 1 1 2   05/24/2017 12:00:00 AM 3 3x3   6003535.353102201 2114132.0136397 37.7852032161945 -122.43150950273301 (37.7852032161945, -122.431509502733)
9895 24292 3 98 403 Winfield St 1 1 1 2   10/28/1992 12:00:00 AM 3 3X3            
31848 184755 2 98 1301 Sunset Blvd 25 9 1 1     3 Width 0ft   5984688.1718 2106071.0721 37.7619839309054 -122.496119032944 (37.7619839309054, -122.496119032944)
51786 185555 2 98 2201 Sunset Blvd 39 9 1 1     3 Width 0ft   5984902.7901 2099826.3861 37.7448503133319 -122.49491630522101 (37.7448503133319, -122.494916305221)
55306 187251 2 98 2401 Sunset Blvd 34 9 1 1     3 Width 0ft   5984973.9834 2098481.6163 37.7411621065182 -122.494571017919 (37.7411621065182, -122.494571017919)
57230 181567 2 98 1300 Sunset Blvd 62 9 1 1     3 Width 0ft   5984855.7554 2106265.0899 37.7625264639896 -122.49555374589599 (37.7625264639896, -122.495553745896)
59344 185312 2 98 2601 Sunset Blvd 37 9 1 1     3 Width 0ft   5984965.1696 2097238.5346 37.737748422490604 -122.494509877006 (37.7377484224906, -122.494509877006)
71197 186427 2 98 1601 Sunset Blvd 15 9 1 1     3 Width 0ft   5984725.0315 2104075.456 37.7565066846119 -122.495844334494 (37.7565066846119, -122.495844334494)
73198 187253 2 98 2401 Sunset Blvd 36 9 1 1     3 Width 0ft   5984962.1374 2098459.5582 37.741100847588896 -122.494610350765 (37.7411008475889, -122.494610350765)
82634 26499 3 98 2710 Harrison St 3 1 1 2     3 4x3   6008889.7812 2102567.01926 37.7537504562032 -122.41216712165199 (37.7537504562032, -122.412167121652)
92800 12755 3 98 1733 Lake St 1 1 1 2   02/24/2008 12:00:00 AM 3 3X3   5990033.85435 2114674.56985 37.785918437001705 -122.478259694764 (37.7859184370017, -122.478259694764)
93443 15888 3 98 5625 Mission St 1 1 1 2     3 3X3   5998561.46984 2087228.1352400002 37.711048567191604 -122.446781008521 (37.7110485671916, -122.446781008521)
94867 15877 3 98 5508 Mission St 1 1 1 2   12/15/1997 12:00:00 AM 3 3X3   5999048.25069 2087729.15393 37.7124520473945 -122.445134579389 (37.7124520473945, -122.445134579389)
104095 22545 3 98 7 Topaz Way 1 1 1 2     3 2X3   6001395.6747592995 2098711.0868843 37.742739635423206 -122.43780724032301 (37.7427396354232, -122.437807240323)
111245 99672 3 98 1250X Shrader St 2 1 1 4 2   3 3x3   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
128536 19363 3 98 738 Shields St 1 1 1 2     3 3X3   5992103.0127542 2089880.5617979001 37.7179604248963 -122.469295726054 (37.7179604248963, -122.469295726054)
131967 181355 2 98 2300 Sunset Blvd 53 9 1 1     3 Width 0ft   5985079.1419 2099429.3232 37.7437704079628 -122.49427726096201 (37.7437704079628, -122.494277260962)
140313 99583 2 98 650X Brunswick St 23 1 1 1     3 3x6   5998578.4 2086902.6 37.710155688278 -122.44669908653499 (37.710155688278, -122.446699086535)
148012 185313 2 98 2601 Sunset Blvd 38 9 1 1     3 Width 0ft   5984983.1747 2097234.3473 37.7377379790483 -122.49444731702299 (37.7377379790483, -122.494447317023)
150729 186250 2 98 1701 Sunset Blvd 61 9 1 1     3 Width 0ft   5984767.3503 2103112.4152 37.753864919503 -122.495626952484 (37.753864919503, -122.495626952484)
164218 185692 2 98 2101 Sunset Blvd 24 9 1 1     3 Width 0ft   5984851.9348 2100530.8696 37.746781656202295 -122.495144090409 (37.7467816562023, -122.495144090409)
177379 181571 2 98 1200 Sunset Blvd 30 9 1 1     3 Width 0ft   5984860.385 2106736.0056 37.7638197374851 -122.49557246911101 (37.7638197374851, -122.495572469111)
179730 184869 2 98 1201 Sunset Blvd 58 9 1 1     3 Width 0ft   5984640.7069 2106821.7773 37.764042376179205 -122.496338586447 (37.7640423761792, -122.496338586447)
182690 181343 2 98 2500 Sunset Blvd 20 9 1 1     3 Width 0ft   5985164.5677 2097705.9234 37.739043415002705 -122.493854905389 (37.7390434150027, -122.493854905389)
183333 187234 2 98 2401 Sunset Blvd 17 9 1 1     3 Width 0ft   5984956.0101 2098625.8109 37.7415569740276 -122.494643790117 (37.7415569740276, -122.494643790117)
185026 187377 2 98 2200 Sunset Blvd 63 9 1 1     3 Width 0ft   5985052.2703 2100029.8298 37.7454176637381 -122.49441443213001 (37.7454176637381, -122.49441443213)
Powered by Datasette · Query took 2.021ms · Data source: data.sfgov.org