trees

Custom SQL query returning 57 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
8590 142524 1 36 301 FRANCISCO ST 14 Sidewalk: Curb side : Cutout Tree 4   03/23/2016 02:52:00 PM 20 Width 0ft   6009733.2838 2121208.6135 37.8049831671154 -122.410566384357 (37.8049831671154, -122.410566384357) 3 1 10 308 23
24124 142520 1 7 301 FRANCISCO ST 3 Sidewalk: Curb side : Cutout Tree 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145) 3 1 10 308 23
39581 142525 1 54 301 FRANCISCO ST 15 Sidewalk: Curb side : Cutout Tree 4     23 Width 0ft   6009759.5801 2121214.59 37.8050010513122 -122.410475804946 (37.8050010513122, -122.410475804946) 3 1 10 308 23
55266 142521 1 36 301 FRANCISCO ST 4 Sidewalk: Curb side : Cutout Tree 4   05/04/2013 12:00:00 AM 0 Width 0ft   6009485.2617 2121177.5361 37.8048839283261 -122.411422499274 (37.8048839283261, -122.411422499274) 3 1 10 308 23
65057 142547 1 70 301 FRANCISCO ST 9 Sidewalk: Curb side : Cutout Tree 4     20 Width 0ft   6009612.5597 2121193.6724 37.8049353736756 -122.410983109438 (37.8049353736756, -122.410983109438) 3 1 10 308 23
66275 142545 1 70 301 FRANCISCO ST 7 Sidewalk: Curb side : Cutout Tree 4     20 Width 0ft   6009562.3577 2121186.5007 37.8049128667558 -122.411156332795 (37.8049128667558, -122.411156332795) 3 1 10 308 23
69868 142549 1 36 301 FRANCISCO ST 11 Sidewalk: Curb side : Cutout Tree 4     9 Width 0ft   6009666.9453 2121202.0395 37.8049613971858 -122.410795492578 (37.8049613971858, -122.410795492578) 3 1 10 308 23
71668 142546 1 36 301 FRANCISCO ST 8 Sidewalk: Curb side : Cutout Tree 4   03/26/2016 09:47:00 AM 23 Width 0ft   6009592.8375 2121191.8795 37.8049293448711 -122.411051233847 (37.8049293448711, -122.411051233847) 3 1 10 308 23
80723 142526 1 36 301 FRANCISCO ST 17 Sidewalk: Curb side : Cutout Tree 4     10 Width 0ft   6009810.3798 2121222.957 37.8050268727325 -122.410300597206 (37.8050268727325, -122.410300597206) 3 1 10 308 23
83356 142550 1 36 301 FRANCISCO ST 16 Sidewalk: Curb side : Cutout Tree 4   03/26/2016 09:53:00 AM 22 Width 0ft   6009784.6811 2121219.3711 37.8050155861628 -122.410389277522 (37.8050155861628, -122.410389277522) 3 1 10 308 23
98442 142544 1 36 301 FRANCISCO ST 6 Sidewalk: Curb side : Cutout Tree 4   03/23/2016 02:55:00 PM 26 Width 0ft   6009534.8661 2121184.7078 37.8049064021217 -122.411251344133 (37.8049064021217, -122.411251344133) 3 1 10 308 23
99299 142522 1 36 301 FRANCISCO ST 12 Sidewalk: Curb side : Cutout Tree 4     8 Width 0ft   6009689.0581 2121206.8206 37.8049757647303 -122.410719306308 (37.8049757647303, -122.410719306308) 3 1 10 308 23
125465 142523 1 36 301 FRANCISCO ST 13 Sidewalk: Curb side : Cutout Tree 4     7 Width 0ft   6009712.3662 2121206.8206 37.8049770715314 -122.410638645677 (37.8049770715314, -122.410638645677) 3 1 10 308 23
134500 142542 1 7 301 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453) 3 1 10 308 23
153778 142519 1 7 301 FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree 4     6 Width 0ft   6009452.9889 2121171.5596 37.8048657081731 -122.411533760714 (37.8048657081731, -122.411533760714) 3 1 10 308 23
165062 142548 1 36 301 FRANCISCO ST 10 Sidewalk: Curb side : Cutout Tree 4     7 Width 0ft   6009639.4537 2121197.2583 37.8049467277157 -122.410890292822 (37.8049467277157, -122.410890292822) 3 1 10 308 23
191008 142543 1 7 301 FRANCISCO ST 5 Sidewalk: Curb side : Cutout Tree 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924) 3 1 10 308 23
3324 100985 1 7 2190 Powell St 6 Sidewalk: Curb side : Cutout Tree 4 DPW 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
11226 33101 1 300 450X Chestnut St 1 Sidewalk: Curb side : Cutout Tree 4 DPW 11/05/1996 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754367 -122.410721035819 (37.804135754367, -122.410721035819) 3 1 10 308 23
14472 100972 1 48 450X Chestnut St 4 Sidewalk: Curb side : Cutout Tree 4 DPW 03/24/2016 07:43:00 AM 3   Permit Number 37341 6009614 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
17603 75990 1 271 350 Broadway 1 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.402853834756 (37.7984395708796, -122.402853834756) 3 1 10 308 23
49150 100970 1 36 450X Chestnut St 2 Sidewalk: Curb side : Cutout Tree 4 DPW   9   Permit Number 37341 6009657.9659 2120896.9693 37.8041232469329 -122.410805008122 (37.8041232469329, -122.410805008122) 3 1 10 308 23
51293 100971 1 58 450X Chestnut St 3 Sidewalk: Curb side : Cutout Tree 4 DPW   4   Permit Number 37341 6009642.5454 2120895.3461 37.8041179253888 -122.410858257388 (37.8041179253888, -122.410858257388) 3 1 10 308 23
58468 100975 1 36 450X Chestnut St 7 Sidewalk: Curb side : Cutout Tree 4 DPW   11   Permit Number 37341 6009580.8633 2120886.4184 37.8040899533369 -122.411071082632 (37.8040899533369, -122.411071082632) 3 1 10 308 23
65532 100981 1 468 2190 Powell St 2 Sidewalk: Curb side : Cutout Tree 4 DPW 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
65536 100982 1 468 2190 Powell St 3 Sidewalk: Curb side : Cutout Tree 4 DPW 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
66219 100977 1 58 450X Chestnut St 9 Sidewalk: Curb side : Cutout Tree 4 DPW   3   Permit Number 37341 6009542.7178 2120879.1139 37.8040677578058 -122.411202572075 (37.8040677578058, -122.411202572075) 3 1 10 308 23
66578 100978 1 58 450X Chestnut St 10 Sidewalk: Curb side : Cutout Tree 4 DPW   5   Permit Number 37341 6009524.0508 2120877.4907 37.8040622540071 -122.411267056058 (37.8040622540071, -122.411267056058) 3 1 10 308 23
90901 100974 1 36 450X Chestnut St 6 Sidewalk: Curb side : Cutout Tree 4 DPW   15   Permit Number 37341 6009596.2838 2120888.8532 37.8040975034287 -122.411017890761 (37.8040975034287, -122.411017890761) 3 1 10 308 23
92277 100973 1 36 450X Chestnut St 5 Sidewalk: Curb side : Cutout Tree 4 DPW   0   Permit Number 37341 6009614 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
106695 100983 1 7 2190 Powell St 4 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
121961 100979 1 58 450X Chestnut St 11 Sidewalk: Curb side : Cutout Tree 4 DPW   6   Permit Number 37341 6009507.0071 2120874.2443 37.8040523843138 -122.411325807727 (37.8040523843138, -122.411325807727) 3 1 10 308 23
132915 100984 1 7 2190 Powell St 5 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
182607 100976 1 58 450X Chestnut St 8 Sidewalk: Curb side : Cutout Tree 4 DPW   5   Permit Number 37341 6009558.1383 2120880.7372 37.8040730797801 -122.411149322876 (37.8040730797801, -122.411149322876) 3 1 10 308 23
188027 100980 1 468 2190 Powell St 1 Sidewalk: Curb side : Cutout Tree 4 DPW 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
191936 100987 1 7 2190 Powell St 8 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
3937 98576 1 19 301X Francisco St 14 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/23/2016 02:52:00 PM 3 3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
22336 98569 1 70 301X Francisco St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
24959 98573 1 36 301X Francisco St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
25070 98562 1 14 2035X Stockton St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
47784 98579 1 36 301X Francisco St 17 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
66737 98559 1 14 2035X Stockton St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
73345 98561 1 14 2035X Stockton St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
79751 98566 1 36 301X Francisco St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/04/2013 12:00:00 AM   3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
93557 98577 1 97 301X Francisco St 15 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     6x7   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
115679 98564 1 7 301X Francisco St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
137680 98571 1 70 301X Francisco St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
145225 98567 1 7 301X Francisco St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
152258 98578 1 36 301X Francisco St 16 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/26/2016 09:53:00 AM 3 6x7   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
152503 98570 1 36 301X Francisco St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/26/2016 09:47:00 AM 3 3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
155011 98574 1 36 301X Francisco St 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
156452 98568 1 36 301X Francisco St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/23/2016 02:55:00 PM 3 3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
159114 98563 1 7 301X Francisco St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
160459 98572 1 36 301X Francisco St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
175355 98575 1 36 301X Francisco St 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
177484 98565 1 7 301X Francisco St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
188990 98560 1 14 2035X Stockton St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23