sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3048 253287 4 17 1237 Shafter Ave 1 1 1 1   08/16/2017 12:00:00 AM 3 3x3 Permit Number 780510 6016839.12241 2092718.7941400001 37.727152059320204 -122.383990506478 (37.7271520593202, -122.383990506478)
9964 173762 4 37 1405 Van Dyke Ave 2 1 1 1   01/17/2017 12:00:00 AM 3 3x3 Permit Number 773007 6015436.02818 2092717.7192900002 37.727071439337 -122.388840955894 (37.727071439337, -122.388840955894)
9965 173761 4 37 1405 Van Dyke Ave 1 1 1 1   01/17/2017 12:00:00 AM 3 3x3 Permit Number 773007 6015436.02818 2092717.7192900002 37.727071439337 -122.388840955894 (37.727071439337, -122.388840955894)
15001 105275 4 9 64 Townsend St 4 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015531.53579 2112438.89481 37.7812269075454 -122.389887748547 (37.7812269075454, -122.389887748547)
13567 105276 4 9 64 Townsend St 5 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015520.229280001 2112423.42174 37.7811837949483 -122.38992578265699 (37.7811837949483, -122.389925782657)
15264 105277 4 9 64 Townsend St 6 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015510.23316 2112419.2864900003 37.781171886114706 -122.38996007562 (37.7811718861147, -122.38996007562)
9622 122597 4 9 42X Colin P Kelly Jr St 5 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9623 75842 4 9 42X Colin P Kelly Jr St 2 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9625 122599 4 9 42X Colin P Kelly Jr St 7 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9627 122596 4 9 42X Colin P Kelly Jr St 4 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9628 122598 4 9 42X Colin P Kelly Jr St 6 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9630 72480 4 9 42X Colin P Kelly Jr St 3 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9633 75872 4 9 42X Colin P Kelly Jr St 1 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9761 122592 4 96 72 Townsend St 1 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9764 122593 4 9 72 Townsend St 2 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9765 122594 4 9 72 Townsend St 3 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
138 72565 4 44 270 Brannan St 1 5 1 1   11/16/1996 12:00:00 AM 3 4x4 Permit Number 770847 6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
139 116640 4 44 270 Brannan St 2 5 1 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
81075 121531 4 208 333 Beale St 7 1 1 1       6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
82070 121539 4 11 201 Folsom St 6 1 1 1       6x6   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
83676 121526 4 208 333 Beale St 2 1 1 1       6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
101224 121527 4 208 333 Beale St 3 1 1 1       6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
101696 121525 4 208 333 Beale St 1 1 1 1     5 6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
101714 121533 4 208 333 Beale St 9 1 1 1       6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
121482 121532 4 208 333 Beale St 8 1 1 1       6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
121865 121530 4 208 333 Beale St 6 1 1 1       6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
126691 121528 4 208 333 Beale St 4 1 1 1       6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
138808 121536 4 11 201 Folsom St 3 1 1 1       6x6   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
139668 121535 4 11 201 Folsom St 2 1 1 1       6x6   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
140570 121537 4 11 201 Folsom St 4 1 1 1       6x6   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
142431 121538 4 11 201 Folsom St 5 1 1 1       6x6   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
144469 121529 4 208 333 Beale St 5 1 1 1       6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
145519 121534 4 11 201 Folsom St 1 1 1 1       6x6   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
78470 121547 4 6 318 Main St 8 1 1 1       8x15   6015095.0 2115307.0 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205)
79273 121543 4 6 318 Main St 4 1 1 1       8x15   6015095.0 2115307.0 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205)
90872 121545 4 6 318 Main St 6 1 1 1       8x15   6015095.0 2115307.0 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205)
106586 121542 4 6 318 Main St 3 1 1 1       8x15   6015095.0 2115307.0 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205)
115120 121546 4 6 318 Main St 7 1 1 1       8x15   6015095.0 2115307.0 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205)
126027 121544 4 6 318 Main St 5 1 1 1       8x15   6015095.0 2115307.0 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205)
129011 121540 4 6 318 Main St 1 1 1 1       8x15   6015095.0 2115307.0 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205)
144636 121541 4 6 318 Main St 2 1 1 1       8x15   6015095.0 2115307.0 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205)
13744 115348 4 6 399 Fremont St 1 1 1 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014915.48611 2114547.7853200003 37.7869832575075 -122.39216652446001 (37.7869832575075, -122.39216652446)
16266 115349 4 6 399 Fremont St 2 1 1 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014896.08459 2114567.05321 37.787035085459706 -122.392234997951 (37.7870350854597, -122.392234997951)
15102 115350 4 6 399 Fremont St 3 1 1 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014880.23802 2114582.9179 37.7870777663613 -122.39229093398599 (37.7870777663613, -122.392290933986)
16337 115351 4 6 399 Fremont St 4 1 1 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014858.418740001 2114606.67601 37.7871417890985 -122.39236808681801 (37.7871417890985, -122.392368086818)
9788 115347 4 90 398X HARRISON ST 2 1 1 1   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854.0 2114630.0 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805)
9806 115346 4 90 398X HARRISON ST 1 1 1 1   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854.0 2114630.0 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805)
14382 115352 4 6 399 Fremont St 5 1 1 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014845.33617 2114621.37484 37.7871814222392 -122.392414378515 (37.7871814222392, -122.392414378515)
13917 115353 4 6 399 Fremont St 6 1 1 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014819.91687 2114646.3157900004 37.787248492781295 -122.39250406973 (37.7872484927813, -122.39250406973)
15478 115354 4 6 399 Fremont St 7 1 1 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014804.627730001 2114662.16926 37.7872911737029 -122.39255807669 (37.7872911737029, -122.39255807669)
157784 113241 4 15 329 Brannan St 3 1 1 1   11/10/2015 12:00:00 AM 3 3x4 Permit Number 770912 6014742.36618 2112476.99378 37.7812877223957 -122.39262057328999 (37.7812877223957, -122.39262057329)
14429 115355 4 6 399 Fremont St 8 1 1 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014786.34664 2114681.69198 37.7873437633547 -122.392622692086 (37.7873437633547, -122.392622692086)
69564 113240 4 15 329 Brannan St 2 1 1 1   11/10/2015 12:00:00 AM 2 3x4 Permit Number 770912 6014728.70394 2112464.7296599997 37.7812532891345 -122.392666980121 (37.7812532891345, -122.392666980121)
109588 113335 4 12 2X STANFORD ST 1 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
119781 113337 4 12 2X STANFORD ST 2 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
127734 113338 4 12 2X STANFORD ST 3 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
13813 115356 4 6 399 Fremont St 9 1 1 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014763.69701 2114705.74438 37.7874085478076 -122.39270273893801 (37.7874085478076, -122.392702738938)
83448 121513 4 11 300 Folsom St 8 1 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
87909 121515 4 11 300 Folsom St 10 1 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
89423 121518 4 11 300 Folsom St 13 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
91523 121514 4 11 300 Folsom St 9 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
91964 121522 4 208 280 Beale St 1 1 1 1       6x10   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
97096 121521 4 11 300 Folsom St 16 1 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
99977 121510 4 11 300 Folsom St 5 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
100921 121512 4 11 300 Folsom St 7 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
101034 121516 4 11 300 Folsom St 11 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
101133 121511 4 11 300 Folsom St 6 1 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
112546 121517 4 11 300 Folsom St 12 1 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
118836 121519 4 11 300 Folsom St 14 1 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
127155 121523 4 208 280 Beale St 2 1 1 1       6x10   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
142598 121520 4 11 300 Folsom St 15 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
144900 121509 4 11 300 Folsom St 4 1 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
145478 121524 4 208 280 Beale St 3 1 1 1       6x10   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
26030 118375 4 6 340 Fremont St 2 1 1 1     2 4x6   6014712.487269999 2114662.02755 37.7872856671566 -122.392876855803 (37.7872856671566, -122.392876855803)
3289 253392 4 46 115 Steuart St 1 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3293 253393 4 46 115 Steuart St 2 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3316 253394 4 46 115 Steuart St 3 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
129716 113329 4 15 329 Brannan St 1 1 1 1   11/10/2015 12:00:00 AM 3 3x3 Permit Number 770912 6014656.6559 2112395.64308 37.781059591367296 -122.39291139783701 (37.7810595913673, -122.392911397837)
14383 118374 4 6 340 Fremont St 1 1 1 1     4 4x6   6014693.17098 2114681.8097099997 37.787338911495 -122.392945071183 (37.787338911495, -122.392945071183)
78293 118379 4 6 340 Fremont St 6 1 1 1       4x6   6014683.0 2114666.0 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362)
83570 118377 4 6 340 Fremont St 4 1 1 1       4x6   6014683.0 2114666.0 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362)
86944 118378 4 6 340 Fremont St 5 1 1 1       4x6   6014683.0 2114666.0 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362)
89450 118380 4 6 340 Fremont St 7 1 1 1       4x6   6014683.0 2114666.0 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362)
109208 118376 4 6 340 Fremont St 3 1 1 1       4x6   6014683.0 2114666.0 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362)
60824 121501 4 6 299 Fremont St 1 5 1 1     4 10x4   6014441.60375 2115047.86993 37.7883300516388 -122.39384108102101 (37.7883300516388, -122.393841081021)
35251 121502 4 6 299 Fremont St 2 5 1 1     4 10x4   6014428.99687 2115060.94265 37.7883652457059 -122.393885614549 (37.7883652457059, -122.393885614549)
151686 121503 4 6 299 Fremont St 3 5 1 1     5 10x4   6014412.49464 2115075.87435 37.7884053276005 -122.39394375569401 (37.7884053276005, -122.393943755694)
38160 121504 4 6 299 Fremont St 4 5 1 1     5 10x4   6014396.4001 2115093.29031 37.7884522533286 -122.39400066032499 (37.7884522533286, -122.394000660325)
46572 121505 4 6 299 Fremont St 5 5 1 1     5 10x4   6014377.50413 2115113.61118 37.7885069995398 -122.394067461056 (37.7885069995398, -122.394067461056)
20380 112084 4 6 99X Fremont St 1 1 1 1   11/23/2015 12:00:00 AM     Permit Number 775592 6013631.8 2115864.7 37.790527840543795 -122.396700174955 (37.7905278405438, -122.396700174955)
104211 112085 4 6 99X Fremont St 2 1 1 1   11/23/2015 12:00:00 AM     Permit Number 775592 6013631.8 2115864.7 37.790527840543795 -122.396700174955 (37.7905278405438, -122.396700174955)
171614 109469 4 283 360 Berry St 1 1 1 1     8 4x4 Permit Number 773752 6013484.3589 2109540.27035 37.7731542007368 -122.3967667483 (37.7731542007368, -122.3967667483)
187427 109470 4 283 360 Berry St 2 1 1 1     8 4x4 Permit Number 773752 6013467.61268 2109523.16527 37.77310630195289 -122.39682347663299 (37.7731063019529, -122.396823476633)
166306 109458 4 283 360 Berry St 3 1 1 1     9 4x4 Permit Number 773752 6013450.121119999 2109506.07563 37.7730584040491 -122.396882784219 (37.7730584040491, -122.396882784219)
152424 109459 4 283 360 Berry St 4 1 1 1     10 4x4 Permit Number 773752 6013430.92674 2109487.72122 37.7730069385559 -122.39694789334101 (37.7730069385559, -122.396947893341)
147831 109460 4 283 360 Berry St 5 1 1 1     7 4x4 Permit Number 773752 6013412.32492 2109471.0252 37.7729600595772 -122.39701106892099 (37.7729600595772, -122.397011068921)
159239 109461 4 283 360 Berry St 6 1 1 1     10 4x4 Permit Number 773752 6013397.072509999 2109454.07559 37.7729126707161 -122.397062640549 (37.7729126707161, -122.397062640549)
151818 109462 4 283 360 Berry St 7 1 1 1     10 4x4 Permit Number 773752 6013376.015 2109435.75899 37.7728612052211 -122.39713419690001 (37.7728612052211, -122.3971341969)
22937 109463 4 283 360 Berry St 8 1 1 1   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013357.96458 2109418.68041 37.7728133064148 -122.39719543803899 (37.7728133064148, -122.397195438039)
175630 109464 4 283 360 Berry St 9 1 1 1     8 4x4 Permit Number 773752 6013338.99753 2109402.3629400004 37.772767446381394 -122.39725990323 (37.7727674463814, -122.39725990323)
27515 109465 4 283 360 Berry St 10 1 1 1     8 4x4 Permit Number 773752 6013321.87847 2109385.26551 37.772719547604495 -122.397317921189 (37.7727195476045, -122.397317921189)
Powered by Datasette · Query took 8.675ms · Data source: data.sfgov.org