sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
79727 99261 3 2 3099X Polk St 1 5 1 4 2   12 3x6   6005936.6 2121383.7 37.805250324017294 -122.42371770971 (37.8052503240173, -122.42371770971)
18618 98576 3 21 301X Francisco St 14 1 1 4 2 03/23/2016 02:52:00 PM 3 3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
77569 98569 3 5 301X Francisco St 7 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
80335 98579 3 26 301X Francisco St 17 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
94043 98566 3 26 301X Francisco St 4 1 1 4 2 05/04/2013 12:00:00 AM   3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
95832 98577 3 94 301X Francisco St 15 1 1 4 2     6x7   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
105255 98564 3 16 301X Francisco St 2 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
111189 98571 3 5 301X Francisco St 9 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
112530 98567 3 16 301X Francisco St 5 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
116963 98570 3 26 301X Francisco St 8 1 1 4 2 03/26/2016 09:47:00 AM 3 3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
117271 98572 3 26 301X Francisco St 10 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
117633 98578 3 26 301X Francisco St 16 1 1 4 2 03/26/2016 09:53:00 AM 3 6x7   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
119062 98568 3 26 301X Francisco St 6 1 1 4 2 03/23/2016 02:55:00 PM 3 3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
120761 98574 3 26 301X Francisco St 12 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
123219 98563 3 16 301X Francisco St 1 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
126470 98573 3 26 301X Francisco St 11 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
138574 98575 3 26 301X Francisco St 13 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
138890 98565 3 16 301X Francisco St 3 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
4581 142526 3 26 301 FRANCISCO ST 17 1 1 4     10 Width 0ft   6009810.3798 2121222.957 37.8050268727325 -122.410300597206 (37.8050268727325, -122.410300597206)
4583 142550 3 26 301 FRANCISCO ST 16 1 1 4   03/26/2016 09:53:00 AM 22 Width 0ft   6009784.6811 2121219.3711 37.805015586162796 -122.41038927752199 (37.8050155861628, -122.410389277522)
4565 142525 3 59 301 FRANCISCO ST 15 1 1 4     23 Width 0ft   6009759.5801 2121214.59 37.8050010513122 -122.410475804946 (37.8050010513122, -122.410475804946)
4595 142523 3 26 301 FRANCISCO ST 13 1 1 4     7 Width 0ft   6009712.3662 2121206.8206 37.804977071531404 -122.410638645677 (37.8049770715314, -122.410638645677)
4590 142522 3 26 301 FRANCISCO ST 12 1 1 4     8 Width 0ft   6009689.0581 2121206.8206 37.804975764730294 -122.410719306308 (37.8049757647303, -122.410719306308)
4571 142549 3 26 301 FRANCISCO ST 11 1 1 4     9 Width 0ft   6009666.9453 2121202.0395 37.8049613971858 -122.41079549257799 (37.8049613971858, -122.410795492578)
4612 142548 3 26 301 FRANCISCO ST 10 1 1 4     7 Width 0ft   6009639.4537 2121197.2583 37.8049467277157 -122.410890292822 (37.8049467277157, -122.410890292822)
4570 142547 3 5 301 FRANCISCO ST 9 1 1 4     20 Width 0ft   6009612.5597 2121193.6724 37.804935373675605 -122.41098310943799 (37.8049353736756, -122.410983109438)
4573 142546 3 26 301 FRANCISCO ST 8 1 1 4   03/26/2016 09:47:00 AM 23 Width 0ft   6009592.8375 2121191.8795 37.8049293448711 -122.411051233847 (37.8049293448711, -122.411051233847)
4568 142545 3 5 301 FRANCISCO ST 7 1 1 4     20 Width 0ft   6009562.3577 2121186.5007 37.80491286675579 -122.41115633279499 (37.8049128667558, -122.411156332795)
4591 142544 3 26 301 FRANCISCO ST 6 1 1 4   03/23/2016 02:55:00 PM 26 Width 0ft   6009534.8661 2121184.7078 37.8049064021217 -122.41125134413299 (37.8049064021217, -122.411251344133)
4622 142543 3 16 301 FRANCISCO ST 5 1 1 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924)
4564 142521 3 26 301 FRANCISCO ST 4 1 1 4   05/04/2013 12:00:00 AM 0 Width 0ft   6009485.2617 2121177.5361 37.8048839283261 -122.41142249927401 (37.8048839283261, -122.411422499274)
4558 142520 3 16 301 FRANCISCO ST 3 1 1 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145)
4611 142519 3 16 301 FRANCISCO ST 2 1 1 4     6 Width 0ft   6009452.9889 2121171.5596 37.804865708173104 -122.411533760714 (37.8048657081731, -122.411533760714)
4605 142542 3 16 301 FRANCISCO ST 1 1 1 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453)
3436 100973 3 26 450X Chestnut St 5 1 1 4 4   0   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
145311 100972 3 26 450X Chestnut St 4 1 1 4 4 03/24/2016 07:43:00 AM 3   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
87567 100981 3 468 2190 Powell St 2 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
89035 100982 3 468 2190 Powell St 3 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
90630 98561 3 12 2035X Stockton St 4 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
91242 98559 3 12 2035X Stockton St 2 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
97910 100983 3 16 2190 Powell St 4 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
107842 100984 3 16 2190 Powell St 5 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
119959 100985 3 18 2190 Powell St 6 1 1 4 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
126599 98562 3 12 2035X Stockton St 5 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
140818 100980 3 468 2190 Powell St 1 1 1 4 4 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
141315 98560 3 12 2035X Stockton St 3 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145388 100987 3 16 2190 Powell St 8 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
92501 97725 3 94 1000X Bay St 4 5 1 4 2     7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
92726 97722 3 94 1000X Bay St 1 5 1 4 2   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
117800 97724 3 94 1000X Bay St 3 5 1 4 2   14 7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
128722 97723 3 94 1000X Bay St 2 5 1 4 2   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
28296 33101 3 26 450X Chestnut St 1 1 1 4 4 11/01/1997 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754366996 -122.410721035819 (37.804135754367, -122.410721035819)
40243 100970 3 26 450X Chestnut St 2 1 1 4 4   9   Permit Number 37341 6009657.9659 2120896.9693 37.804123246932896 -122.41080500812201 (37.8041232469329, -122.410805008122)
47263 100971 3 22 450X Chestnut St 3 1 1 4 4   4   Permit Number 37341 6009642.5454 2120895.3461 37.8041179253888 -122.410858257388 (37.8041179253888, -122.410858257388)
64540 100974 3 26 450X Chestnut St 6 1 1 4 4   15   Permit Number 37341 6009596.2838 2120888.8532 37.8040975034287 -122.41101789076099 (37.8040975034287, -122.411017890761)
59125 100975 3 26 450X Chestnut St 7 1 1 4 4   11   Permit Number 37341 6009580.8633 2120886.4184 37.8040899533369 -122.411071082632 (37.8040899533369, -122.411071082632)
177834 100976 3 22 450X Chestnut St 8 1 1 4 4   5   Permit Number 37341 6009558.1383 2120880.7372 37.8040730797801 -122.411149322876 (37.8040730797801, -122.411149322876)
57285 100977 3 22 450X Chestnut St 9 1 1 4 4   3   Permit Number 37341 6009542.7178 2120879.1139 37.8040677578058 -122.411202572075 (37.8040677578058, -122.411202572075)
55605 100978 3 22 450X Chestnut St 10 1 1 4 4   5   Permit Number 37341 6009524.0508 2120877.4907 37.8040622540071 -122.41126705605801 (37.8040622540071, -122.411267056058)
147766 100979 3 22 450X Chestnut St 11 1 1 4 4   6   Permit Number 37341 6009507.0071 2120874.2443 37.8040523843138 -122.411325807727 (37.8040523843138, -122.411325807727)
101461 97726 3 11 2999X Polk St 9 1 1 4 2   6 4x4   6005802.2 2120854.7 37.8037902383764 -122.42414517362499 (37.8037902383764, -122.424145173625)
5962 82000 3 2 1150 Francisco St 1 1 1 4 2 06/04/2008 12:00:00 AM 6 3x3 Permit Number 50638 6005983.68719 2120729.63993 37.803457100839296 -122.423508229633 (37.8034571008393, -122.423508229633)
1794 81999 3 2 1150 Francisco St 2 1 1 4 2 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005960.45556 2120727.0973099996 37.803448808170295 -122.423588442877 (37.8034488081703, -122.423588442877)
8271 81998 3 26 1150 Francisco St 3 1 1 4 2 06/04/2008 12:00:00 AM 4 3x3 Permit Number 50638 6005939.397969999 2120724.9413900003 37.8034416999448 -122.42366116024999 (37.8034416999448, -122.42366116025)
7474 81997 3 2 1150 Francisco St 4 1 1 4 2 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005918.11487 2120722.35908 37.8034334081868 -122.42373462766001 (37.8034334081868, -122.42373462766)
5699 97727 3 2 1150 Francisco St 5 1 1 4 2   4 3x3 Permit Number 50638 6005898.3389 2120719.3141099997 37.8034239311172 -122.42380284664699 (37.8034239311172, -122.423802846647)
8576 97728 3 2 1150 Francisco St 6 1 1 4 2   5 3x3 Permit Number 50638 6005878.13407 2120716.4935 37.8034150458325 -122.423872565669 (37.8034150458325, -122.423872565669)
7419 97731 3 47 1150 Francisco St 9 1 1 4 2   3 3x3 Permit Number 50638 6005778.11415 2120709.05822 37.803388983478605 -122.42421815984501 (37.8033889834786, -122.424218159845)
8881 97729 3 26 1150 Francisco St 7 1 1 4 2   4 3x3 Permit Number 50638 6005819.00921 2120706.70735 37.80338483759171 -122.42407647347099 (37.8033848375917, -122.424076473471)
87136 76065 3 11 2999X Polk St 6 1 1 4 2 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
99879 76212 3 11 2999X Polk St 1 1 1 4 2 11/16/1996 12:00:00 AM 6 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
111391 76137 3 11 2999X Polk St 4 1 1 4 2 11/16/1996 12:00:00 AM 6 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
118611 76145 3 11 2999X Polk St 3 1 1 4 2 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
123362 76037 3 11 2999X Polk St 7 1 1 4 2 11/16/1996 12:00:00 AM 6 4x6   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
127697 76093 3 11 2999X Polk St 5 1 1 4 2 11/16/1996 12:00:00 AM 6 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
127791 76027 3 11 2999X Polk St 8 1 1 4 2 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
138385 76170 3 11 2999X Polk St 2 1 1 4 2 11/16/1996 12:00:00 AM 5 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
5294 97730 3 2 1150 Francisco St 8 1 1 4 2   6 3x3 Permit Number 50638 6005803.34745 2120703.57786 37.8033753605476 -122.424130448959 (37.8033753605476, -122.424130448959)
7339 97732 3 2 1150 Francisco St 10 1 1 4 2   5 3x3 Permit Number 50638 6005757.30775 2120698.05289 37.8033575908394 -122.424289378073 (37.8033575908394, -122.424289378073)
7989 97733 3 26 1150 Francisco St 11 1 1 4 2   4 3x3 Permit Number 50638 6005736.8865 2120695.23683 37.8033487055393 -122.42435984622801 (37.8033487055393, -122.424359846228)
8363 97734 3 2 1150 Francisco St 12 1 1 4 2   5 3x3 Permit Number 50638 6005715.837730001 2120693.51258 37.8033427825912 -122.424432563629 (37.8033427825912, -122.424432563629)
6518 97735 3 37 1150 Francisco St 13 1 1 4 2 06/22/2016 02:46:00 PM 3 3x3 Permit Number 50638 6005694.978999999 2120690.49004 37.8033333055591 -122.424504530974 (37.8033333055591, -122.424504530974)
10126 97736 3 26 1150 Francisco St 14 1 1 4 2 01/31/2017 12:02:00 PM 3 3x3 Permit Number 50638 6005674.32361 2120686.81612 37.8033220514443 -122.424575748272 (37.8033220514443, -122.424575748272)
1845 98642 3 26 3500X Fillmore St 21 1 1 4 2   10 3x3   6002233.86885 2120387.2869599997 37.8023047257379 -122.436460093962 (37.8023047257379, -122.436460093962)
89957 113573 2 43 901 LOMBARD ST 4 1 1 4 2     3x3   6007813.0 2120272.0 37.802303618634795 -122.417145352251 (37.8023036186348, -122.417145352251)
6303 98641 3 26 3500X Fillmore St 20 1 1 4 2   10 3x3   6002235.030730001 2120370.79549 37.802259510526596 -122.436454892273 (37.8022595105266, -122.436454892273)
6270 98640 3 26 3500X Fillmore St 19 1 1 4 2   5 3x3   6002237.13778 2120351.54005 37.8022067598879 -122.43644622191002 (37.8022067598879, -122.43644622191)
5958 98639 3 26 3500X Fillmore St 18 1 1 4 2   6 3x3   6002240.752780001 2120332.50299 37.8021546945469 -122.436432348976 (37.8021546945469, -122.436432348976)
5471 98637 3 26 3500X Fillmore St 16 1 1 4 2   5 3x3   6002243.51572 2120296.51697 37.8020560434066 -122.43642021082898 (37.8020560434066, -122.436420210829)
6980 98636 3 32 3500X Fillmore St 15 1 1 4 2   12 6x6   6002249.0569400005 2120273.69699 37.8019937006086 -122.436399401415 (37.8019937006086, -122.436399401415)
6762 98635 3 26 3500X Fillmore St 14 1 1 4 2   6 3x3   6002251.83785 2120250.68488 37.8019306734253 -122.436388130233 (37.8019306734253, -122.436388130233)
82915 95268 3 43 2245 Jones St 7 1 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
104719 95263 3 15 2245 Jones St 1 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
112310 95267 3 125 2245 Jones St 6 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
116005 95264 3 15 2245 Jones St 2 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
120920 95266 3 15 2245 Jones St 5 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
122189 95269 3 43 2245 Jones St 8 1 1 4 2     6x6   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
125879 95271 3 21 2245 Jones St 10 1 1 4 2 03/23/2016 02:36:00 PM 3 6x6   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
128015 95272 3 11 2245 Jones St 11 1 1 4 2 06/08/2011 12:00:00 AM 3 3x3   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
143508 95265 3 15 2245 Jones St 3 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
145453 95270 3 21 2245 Jones St 9 1 1 4 2 03/23/2016 02:41:00 PM 3     6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
Powered by Datasette · Query took 22.467ms · Data source: data.sfgov.org